upload products

rgrstvr · Post by **rgrstvr** » Sat Dec 06, 2008 4:01 pm

I have created an Excel file of the 8,000 plants we have for sale, including the following fields - SKU, Name, Price, Taxable.

I cannot get a small version of the mother file, with only about 20 products to upload to ShopSite.

It will upload from a text file, but then it includes multiple problems with missing or too many tabs.

And it does not upload hyperlinks from the text file.

And it will not load more than one page at a time from the text file.

There must be a better way.

robm · Post by **robm** » Sat Dec 06, 2008 4:10 pm

Check out these ShopSite knowledgebase articles:

http://support.shopsite.com/KBase/questions/1978/
http://support.shopsite.com/KBase/questions/2358/

Post by **Jim** » Sat Dec 06, 2008 4:16 pm

Read the knowledge base solutions at
http://support.shopsite.com/KBase/search/excel for help in working with Excel and ShopSite, In particular these two

Error message "...xx tabs instead of the correct number of xx" when at...
and
Extra doublequote marks (") appear in my products and/or pages after a data...

I don't under stand what you are referring to in these two question
And it does not upload hyperlinks from the text file.

And it will not load more than one page at a time from the text file.

rgrstvr · Post by **rgrstvr** » Sat Dec 06, 2008 4:50 pm

I have read the knowledge base solutions.

I understand the problems with quote marks and how to remove them.

As to my question - "And it does not upload hyperlinks from the text file." - I have created hyperlinks to information on the internet in my product descriptions which I have created in my mother Excel file of all our plants for sale. But if I transform my mother Excel file into a text file and then upload that information to ShopSite - the products show up in my product descriptions without the hyperlinks.

As to my question - "And it will not load more than one page at a time from the text file." - When I attempt to upload the text file to ShopSite I get the error message that it can only upload one page at a time. So - I have to reduce the text tile to make it small enough so it will fit on one page and then upload that one page. With 8,000 products that will take too long and is just not practical.

I am not happy with the idea of having to convert our Excel file of products into a text file or text files in order to upload it to ShopSite.

Isn't there a good way to upload spreadsheets directly into ShopSite?

Post by **Jim** » Sat Dec 06, 2008 5:29 pm

Excel may display any url as a hypertext link but that doesn't mean that it is the code necessary for the hypertext link to work on the internet. Make sure you have complete <a href statements in your text and they will display properly.

I assume that you mean that in your Excel file you have information on multiple tabs. I don't believe those can not be converted to a single text file when you export to a text format. However the easiest way to work with the Excel pages is to open a text editor such as WordPad or Notepad and copy and paste each page from your Excel spreadsheet to a single text document and then upload that file.

There is no direct import of Excel format files so either exporting to a tab delimited file, making sure that all columns in the Excel file have data in them, or copying and pasting to a text file are the options available. Note that there is also an XML upload format which you might be able to use but it would probably be more work than the text file.

rgrstvr · Post by **rgrstvr** » Sun Dec 07, 2008 9:30 am

Would uploading into ShopSite work better from a database rather than a spreadsheet?

Post by **Jim** » Mon Dec 08, 2008 9:24 am

It really doesn't matter what type of an application creates the upload file as long as it is a tab delimited format with the same number of columns in each row of data. I know there are people using Access and Excel to create their data as well as those who get the data from a supplier as a tab delimited format.