Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Download the file template by clicking on the Sample CSV link
  2. Review the list of required and optional fields



    Required Fields

    Field NameDescription
    CatalogName of your catalog
    CategoryName of your catalog section the product is in
    SubcategoryName of the subsection the product is in
    ProductName of your product
    Product DescriptionDescriptive information about your product
    IsTaxableShould the item be taxed? Valid values are TRUE and FALSE
    SkuPart Number
    Item DescriptionDescription of this individual part number
    PricePrice 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 you 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 LetterHeader NameRequired
      ACatalogY
      BCategoryY
      CSubcategoryY
      DProductY
      EProduct DescriptionY
      FImage1 
      GImage2 
      HImage3 
      I  
      J  
      KWeight 
      LWidth 
      MHeight 
      NLength 
      OMinShipDays 
      PMaxShipDays 
      QIsTaxable 
      R  
      SSkuY
      TItem DescriptionY
      UPrice 
      V  
      WSize 
      XColor 
  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 unit 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.

...