Uploading product database question

General ShopSite user discussion

Uploading product database question

Postby 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.
kayo
 
Posts: 18
Joined: Fri Jan 19, 2007 10:20 am

Postby 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
Jim
Site Admin
 
Posts: 4953
Joined: Fri Aug 04, 2006 1:42 pm
Location: Utah


Return to User Forum

Who is online

Users browsing this forum: No registered users and 74 guests