Uploading product database question

kayo · Post by **kayo** » Tue Jul 01, 2008 4:18 pm

I am uploading products to ShopSite 8 via an Excel spreadsheet saved as a tab delimited file. Everything uploads fine except for the name of each product has quotes around it when it uploads. On the spreadsheet under the Name column they are listed simply as Widget 1 but it comes up on ShopSite as "Widget 1".

These quotations do not appear in Excel or when the tab delimited file is opened in Notepad. Anyone know why this is showing up?

Thanks.

Post by **Jim** » Tue Jul 01, 2008 9:36 pm

This is because excel incorrectly saves tab delimited files with quote marks around the data. See the following kbase article that tells you how to work around this issue.
http://support.shopsite.com/kbase/view_ ... nID=S02720