Knowledgebase: CSV Export-Import

What do all of the Product CSV headers correspond to?
 

Below is a guide of the different CSV columns that are present in a standard Product Export and how they relate to your products.

Note:
The following list represents the CSV column headers that are exported from your store during a typical product export. We are showing them here sorted in the exact order as shown in the default exported CSV file.

Along with each definition, we will specify the tab in which the setting may be found while viewing the product from inside the Online Store Manager.

Please be aware that not all exported columns can/will be used for importing data. Wherever applicable, we will mention these.

  • catalogid
    This is the item's database ID. It is created by the store.
    Should not be used for Importing CSV data. It is best to remove this column altogether.
  • id
    Corresponds to the product's ID/SKU
    Hint: Look in the Product's INFORMATION TAB
  • name
    Corresponds to the product's Name
    Hint: Look in the Product's INFORMATION TAB
  • categories
    Corresponds to the Cateogry the product resides in
    Hint: Look in the Product's INFORMATION TAB

A special note about Categories
There are certain formatting rules that come into play for how categories are shown in the CSV export.

  • If the product resides in only one category, the CSV export will reflect the category name in this column.
  • If the product resides in a sub-category, the CSV export will reflect it as "main category/sub-category" with a forward slash denoting the subcategory the item belongs to.
  • If the product resides in multiple categories, each individual category location will be separated with the @ symbol.

This is important to note because it may get somewhat confusing when reading the CSV export of a product that resides in several places at once. For example, if a product resides in "Category A", and "Category B" but also in Category A's sub-category "Sub-cat 1" all at the same time; the CSV record will read as follows:

Category A@Category A/Sub-cat 1@Category B

When naming your Categories, please be careful that you do not use symbols such as the forward slash (/) or the @ sign since these may be recognized by the import system as brand new categories.

  • mfgid
    Corresponds to the MPN field of the product
    Hint: Look in the Product's INFORMATION TAB
  • manufacturer
    Corresponds to the assigned Manufacturer of the product
    Hint: Look in the Product's INFORMATION TAB
  • distributor
    Corresponds to the assigned Distributor of the product
    Hint: Look in the Product's INFORMATION TAB
  • cost
    Corresponds to the Cost field of the product as set in the "Pricing" section
    Hint: Look in the Product's INFORMATION TAB
  • price
    Corresponds to the Price field of the product as set in the "Pricing" section
    Hint: Look in the Product's INFORMATION TAB
  • price2
    Corresponds to the Retail Price field of the product as set in the "Pricing" section
    Hint: Look in the Product's INFORMATION TAB
  • price3
    Obsolete setting from previous versions
    NO LONGER USED AND MAY BE LEFT BLANK
  • saleprice
    Corresponds to the On Sale Price field of the product as set in the "Pricing" section
    Hint: Look in the Product's INFORMATION TAB
  • onsale
    Corresponds to the On Sale check box of the product as set in the "Pricing" section
    Hint: Look in the Product's INFORMATION TAB
  • stock
    Corresponds to the "Current Stock" number set for the product in the Inventory Options section.
    Hint: Look in the Product's INFORMATION TAB
  • stock_alert
    Correspodns to the "Stock Alert" number set for the product in the Inventory Options section.
    Hint: Look in the Product's INFORMATION TAB
  • display_stock
    Obsolete setting from previous versions
    NO LONGER USED AND MAY BE LEFT BLANK
  • weight
    Corresponds to the "Weight" of the item as specified in the "Shipping Options" section.
    Hint: Look in the Product's INFORMATION TAB
  • minimumorder
    Corresponds to the Min. Qty setting for the product
    Hint: Look in the Product's ADVANCED TAB
  • maximumorder
    Corresponds to the Min. Qty setting for the product
    Hint: Look in the Product's ADVANCED TAB
  • date_created
    Corresponds to the "Date Available" option of the product
    Hint: Look in the Product's ADVANCED TAB
  • description
    Corresponds to the "Short Description" specified for the product
    Hint: Look in the Product's INFORMATION TAB
  • extended_description
    Corresponds to the "Description" area of the product. (The one with WYSIWYG available)
    Hint: Look in the Product's INFORMATION TAB
  • keywords
    Corresponds to the "Keywords" area of the product.
    Hint: Look in the Product's INFORMATION TAB
  • sorting
    Obsolete setting from previous versions
    NO LONGER USED AND MAY BE LEFT BLANK
  • thumbnail
    Contains the path to the product's Thumbnail image
    Hint: Look in the Product's IMAGES TAB
  • image1
    Contains the path to the product's Main image
    Hint: Look in the Product's IMAGES TAB
  • image2
    Contains the path to the product's Second image
    Hint: Look in the Product's IMAGES TAB
  • image3
    Contains the path to the product's Third image
    Hint: Look in the Product's IMAGES TAB
  • image4
    Contains the path to the product's Fourth image
    Hint: Look in the Product's IMAGES TAB
  • realmedia
    Contains the path to any video URL that you may have associated with the product.
  • related
    Contains the ID of any items flagged as "Related" to the product
    Hint: Look in the Product's RELATED TAB
  • accessories
    Contains the ID of any items flagged as "Up-Selling" items to the product
    Hint: Look in the Product's UP-SELLING TAB
  • shipcost
    Corresponds to the "Shipping" cost set in the "Shipping Options" section.
    Hint: Look in the Product's INFORMATION TAB
  • imagecaption1
    Contains the caption to the product's Main image
    Hint: Look in the Product's IMAGES TAB
  • imagecaption2
    Contains the caption to the product's Second image
    Hint: Look in the Product's IMAGES TAB
  • imagecaption3
    Contains the caption to the product's Third image
    Hint: Look in the Product's IMAGES TAB
  • imagecaption4
    Contains the caption to the product's Fourth image
    Hint: Look in the Product's IMAGES TAB
  • title
    Corresponds to the "Title" field of the product
    Hint: Look in the Product's META TAGS TAB
  • metatags
    Corresponds to the "Meta Tags" field for the product
    Hint: Look in the Product's META TAGS TAB
  • displaytext
    Corresponds to the "Display Text" option of the product
    Hint: Look in the Product's ADVANCED TAB
  • eproduct_password
    Obsolete setting from previous versions
    NO LONGER USED AND MAY BE LEFT BLANK
  • eproduct_random
    Obsolete setting from previous versions
    NO LONGER USED AND MAY BE LEFT BLANK
  • eproduct_expire
    Obsolete setting from previous versions
    NO LONGER USED AND MAY BE LEFT BLANK
  • eproduct_path
    Corresponds to the File 1 Path field of the eProducts Tab
    Hint: Look in the Product's EPRODUCTS TAB
  • eproduct_serial
    Corresponds to the "Assign Key" checkbox in the eProduct Tab
    Hint: Look in the Product's EPRODUCTS TAB
  • eproduct_instructions
    Corresponds to the "Special Instructions" text box in the eProducts tab
    Hint: Look in the Product's EPRODUCTS TAB
  • homespecial
    Corresponds to the "Home Special" checkbox located in the option section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • categoryspecial
    Corresponds to the "Category Special" checkbox located in the option section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • hide
    Corresponds to the "Hide" checkbox located in the option section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • free_shipping
    Corresponds to the "Free Shipping" checkbox located in the "Shipping Options" section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • nontax
    Corresponds to the "Non-Taxable" checkbox located in the option section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • notforsale
    Corresponds to the "Not For Sale" checkbox located in the option section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • giftcertificate
    Corresponds to the "Home Special" checkbox located in the option section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • userid
    The username attached to the product's last update.
    Informational Record Not used for CSV data import
  • last_update
    The date of the product's last update.
    Informational Record Not used for CSV data import
  • extra_field_1
    Corresponds to "Field 1" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_2
    Corresponds to "Field 2" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_3
    Corresponds to "Field 3" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_4
    Corresponds to "Field 4" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_5
    Corresponds to "Field 5" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_6
    Corresponds to "Field 6" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_7
    Corresponds to "Field 7" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_8
    Corresponds to "Field 8" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_9
    Corresponds to "Field 9" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_10
    Corresponds to "Field 10" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_11
    Corresponds to "Field 11" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_12
    Corresponds to "Field 12" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • extra_field_13
    Corresponds to "Field 13" in the Custom Fields area of the Information Tab.
    Hint: Look in the Product's INFORMATION TAB
  • usecatoptions
    Corresponds to the "Do Not Use Category Options" setting of the product.
    Hint: Look in the Product's ADVANCED TAB
  • qtyoptions
    Corresponds to the "Qty Options" field of the product.
    Hint: Look in the Product's ADVANCED TAB
  • price_1
    Corresponds to Price Level 1
    Hint: Look in the Product's ADVANCED TAB
  • price_2
    Corresponds to Price Level 2
    Hint: Look in the Product's ADVANCED TAB
  • price_3
    Corresponds to Price Level 3
    Hint: Look in the Product's ADVANCED TAB
  • price_4
    Corresponds to Price Level 4
    Hint: Look in the Product's ADVANCED TAB
  • price_5
    Corresponds to Price Level 5
    Hint: Look in the Product's ADVANCED TAB
  • price_6
    Corresponds to Price Level 6
    Hint: Look in the Product's ADVANCED TAB
  • price_7
    Corresponds to Price Level 7
    Hint: Look in the Product's ADVANCED TAB
  • price_8
    Corresponds to Price Level 8
    Hint: Look in the Product's ADVANCED TAB
  • price_9
    Corresponds to Price Level 9
    Hint: Look in the Product's ADVANCED TAB
  • price_10
    Corresponds to Price Level 10
    Hint: Look in the Product's ADVANCED TAB
  • hide_1
    Corresponds to the "Hide on this level" checkbox for Price Level 1
    Hint: Look in the Product's ADVANCED TAB
  • hide_2
    Corresponds to the "Hide on this level" checkbox for Price Level 2
    Hint: Look in the Product's ADVANCED TAB
  • hide_3
    Corresponds to the "Hide on this level" checkbox for Price Level 3
    Hint: Look in the Product's ADVANCED TAB
  • hide_4
    Corresponds to the "Hide on this level" checkbox for Price Level 4
    Hint: Look in the Product's ADVANCED TAB
  • hide_5
    Corresponds to the "Hide on this level" checkbox for Price Level 5
    Hint: Look in the Product's ADVANCED TAB
  • hide_6
    Corresponds to the "Hide on this level" checkbox for Price Level 6
    Hint: Look in the Product's ADVANCED TAB
  • hide_7
    Corresponds to the "Hide on this level" checkbox for Price Level 7
    Hint: Look in the Product's ADVANCED TAB
  • hide_8
    Corresponds to the "Hide on this level" checkbox for Price Level 8
    Hint: Look in the Product's ADVANCED TAB
  • hide_9
    Corresponds to the "Hide on this level" checkbox for Price Level 9
    Hint: Look in the Product's ADVANCED TAB
  • hide_10
    Corresponds to the "Hide on this level" checkbox for Price Level 10
    Hint: Look in the Product's ADVANCED TAB
  • minorderpkg
    Corresponds to the "Allow only Mulitples" checkbox
    Hint: Look in the Product's ADVANCED TAB
  • listing_displaytype
    Corresponds to the "Listing Template" selected for the product. (-1 denotes the Default template is selected.)
    Hint: Look in the Product's ADVANCED TAB
  • show_out_stock
    Corresponds to the "Inventory Control" drop down menu in the "Inventory Options" section.(-1 denotes Default, 1 denotes Out of Stock, 2 denotes Back Order, 3 denotes Waiting List.)
    Hint: Look in the Product's INFORMATION TAB
  • pricing_groupopt
    Corresponds to the "Group Options for Qty. Pricing" setting
    Hint: Look in the Product's ADVANCED TAB
  • qtydiscount_opt
    Corresponds to the "Apply Qty. Pricing discount to options" checkbox of the item
    Hint: Look in the Product's ADVANCED TAB
  • loginlevel
    Corresponds to the "Login Required" option on the prodcut.
    Hint: Look in the Product's ADVANCED TAB
  • redirectto
    Corresponds to the "Redirect To" field of the product when login requirements are enabled
    Hint: Look in the Product's Advanced TAB
  • accessgroup
    Corresponds ot the "Allow Access" function of the product (if using Login Required)
    Hint: Look in the Product's ADVANCED TAB
  • self_ship
    Corresponds to the "Ships by itself" checkbox located in the "Shipping Options" section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • tax_code
    Corresponds to the "Tax Code" field of the product.
    Hint: Look in the Product's ADVANCED TAB
  • eproduct_reuseserial
    Corresponds to the "Re-Use Keys" checkbox in the eProduct Tab
    Hint: Look in the Product's EPRODUCTS TAB
  • nonsearchable
    Corresponds to the "Non-Searchable" checkbox located in the option section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • instock_message
    Corresponds to the "In Stock Message" located in the "Inventory Options" section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • outofstock_message
    Corresponds to the "Out of Stock Message" located in the "Inventory Options" section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • backorder_message
    Corresponds to the "Back Order Message" located in the "Inventory Options" section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • height
    Corresponds to the Height entered for the product in the Shipping Options section
    Hint: Look in the Product's INFORMATION TAB
  • width
    Corresponds to the Width entered for the product in the Shipping Options section
    Hint: Look in the Product's INFORMATION TAB
  • depth
    Corresponds to the Depth entered for the product in the Shipping Options section
    Hint: Look in the Product's INFORMATION TAB
  • reward_points
    Corresponds to the "Custom Points" field in the "Reward Options" section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • reward_disable
    Corresponds to the "Disable Rewards" checkbox in the "Reward Options" section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • reward_redeem
    Corresponds to the "Redeem Points" field in the "Reward Options" section of the Information Tab
    Hint: Look in the Product's INFORMATION TAB
  • filename
    Corresponds to the "Custom File Name" field on the Product
    Hint: Look in the Product's META TAGS TAB
  • fractional_qty
    Corresponds to the "Allow fractional qty" checkbox on the product.
    Hint: Look in the Product's ADVANCED TAB
  • gtin
    Corresponds to the "GTIN" field in the product's Information Tab
    Hint: Look in the Product's INFORMATION TAB
Help Desk Software by Kayako fusion