CSV Column Headers List

In this article you will find a guide to the various columns and their uses found in your CSV files.

Please refer to the Basic Template and Requirements or Configurable Product Template following this page for required fields and tips. Any of the below columns may be added to those templates as needed.

📘

Note that these are case-sensitive and values should not be capitalized unless you have made them that way such as a Category Name or Attribute value.

HeaderUseExample
skuAs this suggests, your product's SKU (Stock Keeping Unit) goes here! This must be a unique value.100123
_typeWhat type of product is this? Your options are: simple, configurable, virtual, downloadable, grouped or bundle.simple
_categoryThe Category and Subcategories that this product will live inMen/Outerwear/Overcoat
category_idsThe Category ID as a numeric value. Assign items to multiple categories using the Category IDs, comma separated.35,44,81
costThe cost for the vendor. Does not apply to Bundle or Group products.3.41
descriptionThe long description with detailed information regarding the product.
Note that HTML in this field will often return an error! For CSV updates, use plain text.
Sourced from local farmers and made with all organic components...
imageThis is the MAIN Image of the product. Can be a URL or File Name.https://cdn.com/imageA.jpg
is_in_stockDefines whether the product is available for selling (0 - Out of Stock, 1 - In Stock)1
manage_stock0 - No (You won't track inventory)
1 - Yes (You will track inventory and need to set a quantity)

If use_config_manage_stock = 0

manage_stock: 0: Do not track inventory on the product

manage_stock: 1: Track inventory on the product
use_config_manage_stockDefines whether to use default product settings rather than the individual product setting.
0 =Ignore manage stock setting in Product -> Settings -> Inventory -> Manage Stock
1 =Use manage stock setting in Product -> Settings -> Inventory -> Manage Stock

When set to 1 it will ignore the product level manage_stock setting and will only go by what the system config setting is
_media_imageThe Main Image URL or Filename MUST be added to this column, BUT additional images only need to be added to this column as additional rows.https://cdn.com/imageA.jpg
meta_keywordTitle to describe your page to search engines.Wool
meta_titleTitle to describe your page to search engines.Wool Sweaters
minimal_priceYour "As Low As" Price9.99
min_sale_qtyMinimum number of items in the shopping cart to be sold1
min_qty_groupA group used to combine the quantity of individual products to satisfy the total min_sale_qty in the cart.
max_sale_qtyMaximum number of items in the shopping cart to be sold100
msrpManufacturer's Suggested Retail Price49.99
msrp_enabledAdd Manufacturer Suggest Retail Price (MSRP) and Manufacturer's Actual Pricing (MAP) rules.Yes / No
msrp_display_actual_price_typeWhere the actual price will be displayedIn Cart
Before Order Confirmation
On Gesture
Use Config
nameYour Product's name. This must be a unique value.Unisex Dinosaur Socks - TRex
priceWhat the customer sees as the price10
price_suffixUsed for Price per unit or any other suffix.Per Box or /dozen
qtyHow many of this product do you have in stock?100
min_qtyWhen the item's stock reaches this number, it will become out of stock.0
is_qty_decimalChoose whether the product can be sold using decimals (e.g., you can buy 2.5 product)
0 for no, 1 for yes
0
short_descriptionThe shorter description that appears to the right of the Product Image on the Product page.10% Recycled cardboard, please see additional information for more on our sources.
special_priceSale Price for an item, not associated with a catalog sale1.99
special_from_dateBeginning dates for the special price (Sale Price)YYYY-MM-DD
2017-02-13
special_to_dateEnd dates for the special price (Sale Price)YYYY-MM-DD
2017-02-14
statusIs the product Enabled or Disabled? Enabled is 1, Disabled, 21
tax_class_idTax code if you sell taxable goods (2) or charge for shipping (4). For non taxable goods use 02
url_pathThe URL key that will show up after youstorename.com/maxi-dress-and-jacket
visibilityHow will the customer be able to view this item? Catalog & Search, Not Visible Individually?
Visible in Catalog and Search = 4
Visible in Catalog = 2
Visible in Search = 3
Not visible individually = 1
4
weightThe weight of the item to be used with your shipping calculations..05
display_child_skuWhether the SKU displayed on the Product Page should show the Variation SKU selected for Configurable products.0 = No
1= True
notify_stock_qtyThe number of inventory items below which the customer will be notified via the RSS feed5
use_config_manage_stockChoose whether to view and specify the product quantity and availability and whether the product is in stock management( 0 - No, 1 - Yes)1
qty_incrementsThe product quantity increment value6
enable_qty_incrementsDefines whether the customer can add products only in increments to the shopping cart ( 0 - No, 1 - Yes)0
is_decimal_dividedDefines whether the stock items can be divided into multiple boxes for shipping. ( 0 - No, 1 - Yes)
_links_related_skuThe SKU of the products you want as Related1234
_links_crosssell_skuThe SKU of the products you want as Cross Sell4567
_links_upsell_skuThe SKU of the products you want as Up Sell7890
_associated_skuThe SKUs of the Simple Products that will be linked to this bundle ProductAB-12
_associated_default_qtyDefault number for the bundle product's simple component8
display_child_skuIn a configurable product when a variation is selected what is the behavior with respect to the SKU displayed Do not display Variation SKU
Show Variation SKU in the Product Page
* Replace parent SKU with the variation SKU
zoey_default_variationThe default variation to show when a configurable product is first loadedVariation Product ID - Where Variation Product ID is the Entity ID which you can get by exporting your Products or looking at the Product ID in the Admin - see image below
zb2b_product_atq_restrictedHide Add To Quote button for this product. Yes - hide, No - don't hide.Yes
No
zb2b_product_restrictedEnable Product Restriction for this product. Product will be hidden based on B2B > Product Restrictions for the below groups.Yes
No
zb2b_restricted_prod_groupsMulti-select customer groups to apply restriction to. Leave blank for all.Customer Group NAME
i.e. "Wholesale"
zoey_add_to_cart_qtyDefault quantity to be displayed in the quantity box on a product pageNumerical value, example: 1
zoey_product_skip_shippingDefines whether a Configurable Product or its individual Variations should skip shipping. To enable this feature go to Product->Settings->Inventory->Advanced Options and then change Enable Non-Shippable Products to "Yes". By default this will be "No".Yes
No

You may have other attributes in here such as color, size, country_of_manufacture, manufacturer. All of these will be determined on the Attribute Set that you are using as well as the Attributes you have already set up.

Item ends with _position. Set a number to decide which choice will come first, second, third and so on.

📘

User Default Settings

Any line that begins with use_config will use your default settings rather than the individual product setting.

❗️

HTML

Using HTML in your CSV files may cause issues with the import itself or the imported data. Please note the Support Team is not able to troubleshoot or assist with issues related to HTML in CSV files.