Product data attributes reference
The following table lists the attributes from a typical product export, in the default order in which they appear. Each attribute is represented in the CSV file as a column, and product records are represented by rows. Columns that begin with an underscore contain service data such as properties or option values for complex data. You can export a product from your catalog, to see how each attribute is represented in the data.
The installation used to export this data has the sample data installed, and has two websites and several store views. Although this list includes all columns that are typically exported, the sku
is the only required value. To import data, you can include only the columns with changes. The sku
should be the first column, but the order of the rest of the attributes doesn’t matter.
Simple product CSV file structure
sku
sku123
Note: A SKU longer than 64 characters causes import to fail.
store_view_code
storeview1
, english
, spanish
attribute_set_code
default
product_type
simple
— Tangible items that are usually sold as single units or in fixed quantities.grouped
— A group of separate products that is sold as a set.configurable
— A product with multiple options that the customer must select before making a purchase. Inventory can be managed for each set of variations because they represent a separate product with a distinct SKU. For example, a combination of color and size for a configurable product is associated with a specific SKU in the catalog.virtual
— A non-tangible product that does not require shipping and is not kept in inventory. Examples include services, memberships, and subscriptions.bundle
— A customizable product set of simple products that are sold together.categories
Default Category/Gear|Default Category/Gear/Bags
product_websites
base
or base,website2
name
description
short_description
weight
1
— (Yes) The product is enabled, and available for sale.2
— (No) The product is disabled, and is not available for sale.tax_class_name
visibility
Not Visible Individually
— The product is not included in product listings, although it might be available as a variation of another product.Catalog
— The product appears in all catalog listings.Search
—The product is available for search operations.Catalog, Search
— The product is included in catalog listings and is also available for search.price
special_price
special_price_from_date
special_price_to_date
url_key
product-name
1
with a new url_key
, a new 301 URL rewrite is generated so that the old URL is redirected to the new URL.meta_title
meta_keywords
keyword1
, keyword2
, keyword3
meta_description
base_image
/sample_data/m/b/mb01-blue-0.jpg
To upload a new image or write over an existing image, enter the file name, preceded by a forward slash. For example:
/image.jpg
base_image_label
small_image
/image.jpg
small_image_label
Small Image 1
, Small Image 2
thumbnail_image
/image.jpg
thumbnail_image_label
Thumbnail 1
, Thumbnail 2
created_at
updated_at
new_from_date
new_to_date
display_product_options_in
map_price
msrp_price
map_enabled
1
— (Yes) MAP is enabled.0
(or blank) — (No) MAP is not enabled.gift_message_available
1
— (Yes) The option to include a gift message is presented to the customer.0
(or blank) — (No) The option to include a gift message is not presented to the customer.custom_design
custom_design_from
custom_design_to
custom_layout_update
page_layout
No layout updates
— No change is made to the page layout.1 column
— Applies a one-column layout to the product page.2 columns with left bar
— Applies a two-column layout with a left sidebar to the product page.2 columns with right bar
— Applies a two-column layout with a right sidebar to the product page.3 columns
— Applies a three-column layout to the product page.empty
— Applies a blank layout to the product page.product_options_container
msrp_display_actual_price_type
In Cart
— Displays the actual product price in the shopping cart.Before Order Confirmation
— Displays the actual product price at the end of the checkout process, just before the order is confirmed.On Gesture
— Displays the actual product price in a popup when the customer clicks the Click for price or What’s this? link.country_of_manufacture
additional_attributes
has_options=0,required_options=0color=Black,has_options=0,required_options=0,size_general=XS
qty
out_of_stock_qty
use_config_min_qty
1
— (Yes) The default configuration setting is used for the value of this attribute.0
(or blank) — (No) The default configuration can be overridden for the value of this attribute.is_qty_decimal
1
— (Yes) The value of the qty attribute is a decimal value.0
(or blank) — (No) The value of the qty attribute is a whole number (integer).allow_backorders
use_config_backorders
1
— (Yes) The value of the qty attribute is a decimal value.0
(or blank) — (No) The value of the qty attribute is a whole number (integer).min_cart_qty
use_config_min_sale_qty
1
— (Yes)0
(or blank) — (No)max_cart_qty
use_config_max_sale_qty
1
— (Yes)0
(or blank) — (No)is_in_stock
notify_on_stock_below
use_config_notify_stock_qty
1
— (Yes)0
(or blank) — (No)manage_stock
1
— (Yes) Activates full inventory control to manage stock levels of the product.0
(or blank) — (No) The system does not track the number of items that are currently in stock.use_config_manage_stock
1
— (Yes)0
(or blank) — (No)use_config_qty_increments
1
— (Yes)0
(or blank) — (No)qty_increments
use_config_enable_qty_inc
1
— (Yes)0
(or blank) — (No)enable_qty_increments
is_decimal_divided
Yes
/ No
website_id
related_skus
24-WG080,24-UG03,24-UG01,24-UG02
related_position
1,2,3,4
crosssell_skus
crosssell_position
crosssell_skus
column.upsell_skus
upsell_position
upsell_skus
column.additional_images
/image.jpg
additional_image_labels
Label 1
, Label 2
custom_options
`name=Color, type=drop_down, required=1, price= price_type=fixed, sku=, option_title=Black
Service data for product variations
_super_products_sku
_super_attribute_code
_super_attribute_option
_super_attribute_price_corr
_associated_sku
Bundle Products
_associated_default_qty
Grouped Products
Bundle Products
_associated_position
Grouped Products
Bundle Products
Complex product data attributes
The term complex data refers to the data that is associated with multiple product options. The following product types use data that originates from separate products to create product variations and multiple options.
If you export a configurable product, you would find the standard attributes that make up a simple product, plus the additional attributes that are needed to manage complex data.
Configurable products
configurable_variation_labels
Choose Color:
or Choose Size:
configurable_variations
Grouped products
associated_skus
Bundle products
bundle_price_type
bundle_sku_type
bundle_weight_type
bundle_values
name=Bundle Option One,type=dropdown; required=1, sku=sku-option2,price=10, price_type=fixed
Advanced pricing attributes
Advanced Price Import/Export allows you to quickly update pricing information for product groups and tier prices. The process to import and export advanced price data is the same as any other entity type. The sample CSV file contains tier and group prices for each product type that supports advanced pricing. Changing advanced pricing does not affect the rest of the product record.
sku
sku123
Note: A SKU longer than 64 characters causes import to fail.
tier_price_website
- website1 - All Websites [USD]
tier_price_customer
- ALL GROUPS - NOT LOGGED IN - General - Wholesale - Retailer
tier_price_customer_group
- ALL GROUPS - NOT LOGGED IN - General - Wholesale - Retailer
tier_price_qty
tier_price
group_price_website
- website1 - All Websites [USD]
group_price_customer_group
- NOT LOGGED IN - General - Wholesale - Retailer
group_price