How do I import custom ecommerce catalogs?

When you have products that you want to sell that are not in the ARI subscribed catalogs currently available, follow the below instructions:

Step-by-Step Guide

On the Command Center > Store > Custom Products page, there is a button for "Import Custom Products" that will allow you to import a CSV of products that will create a new catalog or update one already in existence. Also available is the ability to upload a ZIP file of images that match the file names specified in your CSV.

1. Download the file template by clicking on the Sample CSV link

2. Review the list of required and optional fields
   
   
   
   Required Fields

   Field Name	Description
   Catalog	Name of your catalog
   Category	Name of your catalog section the product is in
   Subcategory	Name of the subsection the product is in
   Product	Name of your product
   Product Description	Descriptive information about your product
   IsTaxable	Should the item be taxed? Valid values are TRUE and FALSE
   Sku	Part Number
   Item Description	Description of this individual part number
   Price	Price of this individual part number

3. Build out your CSV. You do not need to create the catalog before importing your CSV; the system will create the catalog if it does not already exist.
   1. You can create entirely new catalogs or include only the items that you wish to add to an already existing catalog with this upload.
4. Once your CSV is ready for upload, choose your catalog year, industry, and company in Step 1.
   
   
   
   
5. In Step 2, browse your computer for your file and select it.
   1. If your file has header information, check the corresponding box.

   2. If your file does not have header information, columns must be in the order specified below. Your file will not import if the columns are not ordered exactly as specified.

      Column Letter	Header Name	Required
      A	Catalog	Y
      B	Category	Y
      C	Subcategory	Y
      D	Product	Y
      E	Product Description	Y
      F	Image1
      G	Image2
      H	Image3
      I
      J
      K	Weight
      L	Width
      M	Height
      N	Length
      O	MinShipDays
      P	MaxShipDays
      Q	IsTaxable
      R
      S	Sku	Y
      T	Item Description	Y
      U	Price
      V
      W	Size
      X	Color

6. Click the Import File button in Step 3 to upload your CSV.
   
   
   
   
7. To upload up to three (3) images per custom product....
   1. For each product for which you are adding images, reference the image file name(s) in your CSV import (Columns F, G & H) 
   2. Select the images that you will be importing and save them to a ZIP file.  Make sure that all image are in the root folder of the ZIP file, and not within a subfolder.  If images are within a subfolder, they will fail to import.
   3. Return to Step 1 and enter the catalog year, industry, and company that applies.
   4. At Step 2, browse to your image ZIP file and upload it.
   5. Skip Step 3 and go to Step 4.  Click on the Import File button.
   
   

Related Articles

• Page:
  How do I import custom ecommerce catalogs?
• Page:
  How do I change all pricing to Call For Price?
• Page:
  How do I import customer accounts using CSV upload?