Shopsite adds quote marks to product names

General ShopSite user discussion

Shopsite adds quote marks to product names

Postby lonepine » Sat Aug 06, 2011 5:36 am

When I upload product files which are tab separated, Shopsite Pro 10.2 stores about 10% of them with their names in quotes ( " " ) . All the ones in quotes are sorted first. Very annoying. How can I stop this happening. Example: vortex binoculars is changed to "vortex binoculars"
lonepine
 
Posts: 26
Joined: Fri May 06, 2011 6:02 pm

Re: Shopsite adds quote marks to product names

Postby robm » Sat Aug 06, 2011 7:08 am

This is likely due to Excel adding quotes around text when you convert it to a tab delimited text file.

Here is a workaround for this issue:
http://support.lexiconn.com/kb/questions/248/Uploading+product+and+page+databases+using+Excel

You can also just upload the file from Excel directly. We have details on this on our blog at:
http://www.lexiconn.com/blog/2010/03/how-to-quickly-get-your-products-into-shopsite-part-2-database-upload/

Rob
robm
 
Posts: 463
Joined: Fri Aug 04, 2006 5:46 pm
Location: Connecticut

Re: Shopsite adds quote marks to product names

Postby lonepine » Sat Aug 06, 2011 10:29 am

Hi Rob,
I used your Excell/Notepad workaround and it worked as advertised. Thanks again.

Thanks for the emails from your associates. You're expensive but I'm considering.
neville
lonepine
 
Posts: 26
Joined: Fri May 06, 2011 6:02 pm


Return to User Forum

Who is online

Users browsing this forum: No registered users and 73 guests