The Import Products function allows you to import categories, manufacturers, products,
variants and images from an Excel spreadsheet.
When importing your products the program will lookup products by sku, if the product
currently exists in the database the import program will update the existing product and if
the product sku does not exist the import program will insert a new record in the
database.
Including column headings as the first row in the spreadsheet is optional. The sheet name
of your Excel spreadsheet that contains the data your want to import must be named
“Sheet1”.
Field Specification for version 3.97 and above:
1. CategoryName
2. SubcategoryName
3. Manufacturer
4. ProductSortOrder
5. ProductSku
6. ProductName
7. UnitCost
8. QuantityOnHand
9. Weight
10. Summary
11. ProductDescription
12. Description2
13. Description3
14. Description4
15. Description5
16. ThumbImage1
17. LargeImage1
18. ZoomImage1
19. LargeImage2
20. ZoomImage2
21. LargeImage3
22. ZoomImage3
23. LargeImage4
24. ZoomImage4
25. LargeImage5
26. ZoomImage5
27. VariantGroup1
28. VariantName1
29. VariantPriceDif1
30. VariantWeightDif1
31. VariantImage1
32. VariantDisplayType1
33. VariantGroup2
34. VariantName2
35. VariantPriceDif2
36. VariantWeightDif2
37. VariantImage2
38. VariantDisplayType2
39. VariantGroup3
40. VariantName
41. VariantPriceDif3
42. VariantWeightDif3
43. VariantImage3
44. VariantDisplayType3
45. VariantGroup4
46. VariantName4
47. VariantPriceDif4
48. VariantWeightDif4
49. VariantImage4
50. VariantDisplayType4
51. VariantGroup5
52. VariantName5
53. VariantPriceDif5
54. VariantWeightDif5
55. VariantImage5
56. VariantDisplayType5
57. VariantSku
58. VariantQtyOnHand
If you are importing variants the VariantDisplayType field is required. The following are
the options for the VariantDisplayType field:
 DropdownList
 RadioButtons
 CheckBox
 TextBox
Cart version 3.97 and above field specification and sample spreadsheet - http://www.smith-consulting.com/forums/forumid/4/threadid/4993/scope/posts.aspx
B. Importing the Data
To import your products click the button titled “Import Products” from the Store Admin Menu.
After you click Import Products, the following screen will be displayed
Step1: Click the browse button and choose the excel file to upload.
Step2: Click the button titled “Import Categories and Products”
Step3: Copy the physical images (jpeg, gif, etc) to your server in the following
directories:
Cart versions 2.44.16 and greater image locations are as follows:
 Thumbnail Images - \portals\[yourportalid]\smithcart\thumbnails
 Large Images - \portals\[yourportalid]\smithcart \images

Hi Dave,

That is a great suggestion, I will add it to the Enhancement Requests Forum.

If you would like to prioritize a feature request to the top of the list do one of the following:
Submit a quote request here http://www.smith-consulting.com/services/requestaquote.aspx

Email sales@smith-consulting.com

We quote all features enhancements below cost since it is enhancing the module, If your company has budget to sponsor a feature let us know, in most cases we can start work on the new feature within a week.

Thanks, Kevin