Product Import

SmithCart > Integration > Import

The Product Import allows you to import new, update existing, and/or delete Products from an CSV file.  A good way to start the import is to enter a couple products using the UI and then export.  Exporting before importing gives you a good sample CSV file to work with, can then be modified and used as the import file.  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.

Import Field Specification

  Click here to download sample CSV

Running the Product Import

To import your data, navigate to the store admin menu in the BuyNow module and select "Import/Export" as follows:
 

Product Import

The Product Import function allows you to import Categories, Manufacturers, Products, Sale Price, Variants and Images from an Excel spreadsheet. The import products function allows the ability to import an unlimited number of categories and sub categories per product.

Step 1: Choose Import type

Select the Product Import tab at the top of the page.
 

 

Step 2: Choose a File

From the Import Products tab click the Browse button.
 
 
Please note that only .csv files can be imported.

Step 3: Select a File Name

Navigate to the excel file you want to import, and click Open.
 

 

Step 4: Import Now

 

To import the selected product spreadsheet, click the Import Now button to upload the file

When the import is complete, a message stating that the import was successful is displayed.

Note that this process may take several minutes, depending on the number of records to be imported. You should also allow time for the data to be processed: for example, it should take about half a minute to import 100 products, five minutes to import 1,000 and so on.
 

Step 5: Copy Images

To copy the physical images(jpeg, gif, etc.) to your server, copy your image files in the following directories:

Cart versions 2.44.14 and prior image locations are as follows:

  • Thumbnail Images - \desktopmodules\buynow\thumbnails
  • Large Images - \desktopmodules\buynow\images

Cart versions 2.44.16 and greater image locations are as follows:

  • Thumbnail Images - \portals\[yourportalid]\smithcart\thumbnails
  • Large Images - \portals\[yourportalid]\smithcart \images
 

Step 6: Generating Thumbnail images

When products are uploaded using the cart product setup screen thumbnails are automatically generated by the cart. If you are importing your products the thumbnail images are not automatically generated and you will need to upload your thumbnail images. Here is a tip to quickly generate your thumbnail images all at once.

  1. Download the Image Resizer PowerToy from Microsoft for your flavor of Windows
  2. Go to Portals/(Portal #)/SmithCart/Thumbnails
  3. CTRL-A to select all files
  4. Right-click on a file, select "Resize Image"
     

Helpful Product Import Tips

  • Including column headings as the first row in the spreadsheet is optional. The sheet name of your Excel spreadsheet that contains the data you want to import must be named “Sheet1”.
  • Make sure that alphanumeric fields that have all numbers (i.e. SKU) have a single quote in front of the them as excel converts these fields to numbers or scientific notation in some cases if the number is big enough.
  • If the data is coming from a database other than sql server like a unix platform, mainframe or vsam/isam files the data is most likely stored in a different data format and when exported could include characters that may not be visible in ascii so make sure your data is clean of any special characters before importing.
  • If you are importing variants the VariantDisplayType field is required. The following are the options for the VariantDisplayType field:
    • DropdownList
    • RadioButtons
    • CheckBox
    • Grid
    • TextBox
    • MultiLineTextBox
    • Icon
    • FileUpload

Note that this process may take several minutes, depending on the number of records to be imported. You should also allow time for the data to be processed: for example, it should take about half a minute to import 100 products, five minutes to import 1,000 and so on.