Ecommerce hosting

All Any
 
Importing the Shop Data
 
How do I import data into my shopping cart?




The easiest way to do create an importable file is to:
  1. From the shop/owner Categories page, create a few categories.
  2. From the Inventory page, create a few items for sale
  3. Now proceed to the item Export Item Data page, select the categories containing your items and then click the Export Checked button. This will save a file named export.txt. To make it easy to find, save it directly to your desktop. Or Click here for an example file to save to your desktop.
  4. Start up Microsoft Excel, or Open Office, or any other popular spreadsheet software; and open up the export.txt file you have just exported from the shop.
  5. Using this file as a template will help you to create the file in the correct format, add the items that you'd like to import by typing or pasting the information into the correct fields.
  6. After you have finished adding the item information to the spreadsheet, select to Save it as a text file.
    If you are using Open Office select Save As "Text CSV", select the option to "Edit Filter Settings". When you proceed the "Edit Filter Settings" window will come up; in that window leave Character Set at the default; Field Delimiter should be Tab; Text Delimiter should be blank (not "); Fixed Column width should not be checked.
  7. From this import page, browse to the file on your local hard drive, upload, preview, and import it. Sometimes your Excel software may still have the file open when you are trying to upload it; this will cause an incorrect file type error. If you get the "wrong file type" error, open up the file using WordPad, then use the Save As to save it as a text file under another name. Or, FTP the file (in ASCII mode) to your site and specify the url to import it from.
Additional file format information:
The product database file you would like to import should be seperated by a tab , and should have the following values in the following order:
  1. ID -  [ANY NUMBER]
  2. SKU NO - [TEXT VALUE - Leave blank if none]
  3. PRODUCT NAME -  [TEXT VALUE]
  4. PRODUCT DESCRIPTION -  [TEXT VALUE]
  5. IMAGE URL(Note image urls should be fully specified and begin with http://) -  [TEXT VALUE - Leave blank if none] to add: Use a comma between multiple images.
  6. PRICE (in $) -  [ANY NUMBER]
  7. REGULAR PRICE(in $) -  [ANY NUMBER]
  8. CUSTOM TEXT (Specify multiple custom texts separated by ':') -  [TEXT VALUE - Leave blank if none]
  9. PRODUCT SEQUENCE -  [ANY NUMBER]
  10. TAXABLE -  [(0,N,No) / (1,Y,Yes)] (case insensitive)
  11. IS GIFT CERTIFICATE -  [(0,N,No) / (1,Y,Yes)] (case insensitive)
  12. CHARGE SHIPPING - [(0,N,No) / (1,Y,Yes)] (case insensitive)
  13. DISPLAY PRODUCT IN CART -  [Y,N]
  14. CATEGORY -  [PARENT CATEGORY TEXT VALUE&CATEGORY1 TEXT VALUE&&PARENT CATEGORY TEXT VALUE&CATEGORY2 TEXT VALUE]
  15. STOCK QTY -  [ANY NUMBER]
  16. SHIPPING -  [ANY NUMBER]
  17. WEIGHT(in lbs) -  [ANY NUMBER]
  18. PRODUCT LENGTH -  [ANY NUMBER - Leave blank if none]
  19. PRODUCT WIDTH -  [ANY NUMBER - Leave blank if none]
  20. PRODUCT HEIGHT -  [ANY NUMBER - Leave blank if none]
  21. PRODUCT BRAND -  [TEXT VALUE - Leave blank if none]
  22. PRODUCT CONDITION -  [new,used,refurbished]
  23. PRODUCT TYPE -  [TEXT VALUE - Leave blank if none]
  24. PRODUCT OPTIONS & LEVELS -  [TEXT VALUE - Leave blank if none]
  25. ITEM IDs TO SUGGEST AT CHECKOUT -  [TEXT VALUE - Leave blank if none] to add: Use a comma between multiple IDs
  26. HTML TO DISPLAY ON CART PAGE -  [TEXT VALUE - Leave blank if none]

Copyright ©1999-1998-2011 Precision Web Hosting, Inc. Inc. | Acceptable Use Policy | Privacy Policy
Ecommerce Hosting - Free Shopping Cart | Ecommerce Web Hosting Plans | Ecommerce Reseller Web Hosting Plans | Dedicated Server| Free Shopping Cart | Free Shopping Cart Manual | Free Shopping Cart Features | Free Shopping Cart Faq | Web Hosting Order Forms - Ecommerce | Ecommerce Web Site Designers | Search Engine Positioning | Contact Us | Shopping Cart Payment | PayPal Pro Payment | Self Help| Verisign Payflow Link Compatible Shopping Cart | Web Hosting FAQ | Web Hosting Contract | Precision Web Host Site Builder Tutorials | Example Customers | How to make the shop pages look like the rest of your site. Shopping Cart Export To Stamps.com | Shopping cart integration linking to a category | Shopping cart downloadable items | Windows Live Mail Tutorial | Sitebuilder linking to a shopping cart category | Linking to one specific item in the shopping cart | Shopping cart search engine optimization |