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鈥檛 matter.
Simple product CSV file structure
Attribute
Description
sku(Required) The Stock-Keeping Unit is a unique, alphanumeric identifier that is used to track inventory. A SKU can be up to 64 characters in length. For example:
Note: A SKU longer than 64 characters causes import to fail.
sku123Note: A SKU longer than 64 characters causes import to fail.
store_view_codeIdentifies the specific store views where the product is available. If blank, the product is available at the default store view. For example:
storeview1, english, spanishattribute_set_codeAssigns the product to a specific attribute set or product template, according to product type. For example:
After the product is created, the attribute set cannot be changed using the import functionality. However, you can change the attribute set from the Admin, and re-export the product to update the CSV file .
defaultAfter the product is created, the attribute set cannot be changed using the import functionality. However, you can change the attribute set from the Admin, and re-export the product to update the CSV file .
product_typeIndicates the type of product. Values:
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.categoriesIndicates each category that is assigned to the product. Separate categories and subcategories with a forward slash. To indicate multiple category paths, separate each path with a pipe | symbol. For example:
Default Category/Gear|Default Category/Gear/Bagsproduct_websitesThe website code of each website where the product is available. A single product can be assigned to multiple websites, or limited to one. If specifying multiple websites, separate each with a comma and without a space. For example:
base or base,website2nameThe product name appears in all product listings, and is the name that customers use to identify the product.
descriptionThe product description provides detailed information about the product, and might include simple HTML tags.
short_descriptionThe use of the short product description depends on the theme. It might appear in product listings and is sometimes used in RSS feed listings sent to shopping sites.
weightThe weight of the individual product. The actual product weight is determined by the carrier at the time of shipment.
product_online
Determines if the product is available for sale in the store. Values:
1 鈥 (Yes) The product is enabled, and available for sale.2 鈥 (No) The product is disabled, and is not available for sale.tax_class_nameThe name of the tax class that is associated with this product.
visibilityDetermines if the product is visible in the catalog, and made available for search. Values:
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 鈥擳he product is available for search operations.Catalog, Search 鈥 The product is included in catalog listings and is also available for search.priceThe price that the product is offered for sale in your store.
special_priceThe discounted price of the product during the specified date range.
special_price_from_dateThe beginning date of the time period when the special price is in effect.
special_price_to_dateThe last date of the time period when the special price is in effect.
url_keyThe part of the URL that identifies the product. The default value is based on the product name. For example:
product-namesave_rewrites_history
When provided with value
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_titleThe meta title appears in the title bar and tab of the browser and search results lists. The meta title should be unique to the product, incorporate high-value keywords, and be fewer than 70 characters in length.
meta_keywordsMeta keywords are visible only to search engines, and are ignored by some search engines. Choose high-value keywords, separated by a comma. For example:
keyword1, keyword2, keyword3meta_descriptionMeta descriptions provide a brief overview of the product for search results listings. Ideally, a meta description should be between 150-160 characters in length, although the field accepts up to 255 characters.
base_imageThe relative path for the main image on the product page. Commerce stores files internally in an alphabetical folder structure. You can see the exact location of each image in the exported data. For example:
To upload a new image or write over an existing image, enter the file name, preceded by a forward slash. For example:
/sample_data/m/b/mb01-blue-0.jpgTo upload a new image or write over an existing image, enter the file name, preceded by a forward slash. For example:
/image.jpgbase_image_labelThe label that is associated with the base image.
small_imageThe file name of the small image that is used on catalog pages, preceded by a forward slash. For example:
/image.jpgsmall_image_labelThe label associated with the small image. For example:
Small Image 1, Small Image 2thumbnail_imageThe file names of any thumbnail image to appear in the gallery on the product page, preceded by a forward slash. For example:
/image.jpgthumbnail_image_labelThe label associated with any thumbnail images. For example:
Thumbnail 1, Thumbnail 2created_atIndicates the date when the product was created. The date is automatically generated when the product is created, but can be edited later.
updated_atIndicates the date when the product was last updated.
new_from_dateSpecifies the 鈥渇rom鈥 date for new product listings, and determines if the product is featured as a new product.
new_to_dateSpecifies the 鈥渢o鈥 date for new product listings, and determines if the product is featured as a new product.
display_product_options_inIf the product has multiple options, determines where they appear on the product page. Values: Product Info Column / Block after Info Column
map_priceThe minimum advertised price of the product. (Appears only if MAP is enabled.)
msrp_priceThe manufacturer鈥檚 suggested retail price for the product. (Appears only if MAP is enabled.)
map_enabledDetermines if Minimum Advertised Price is enabled in the configuration. Values:
1 鈥 (Yes) MAP is enabled.0 (or blank) 鈥 (No) MAP is not enabled.gift_message_availableDetermines if a gift message can be included with the product purchase. Values:
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_designLists the available themes that can be applied to the product page.
custom_design_fromSpecifies the beginning date when the selected theme is applied to the product page.
custom_design_toSpecifies the end date when the selected theme is applied to the product page.
custom_layout_updateAdditional XML code that is applied as a layout update to the product page.
page_layoutDetermines the page layout of the product page. Values:
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_containerIf the product has multiple options, determines where they appear on the product page. Values: Product Info Column / Block after Info Column
msrp_display_actual_price_typeDetermines where the actual price of a product is visible to the customer. Values:
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鈥檚 this? link.country_of_manufactureIdentifies the country where the product was manufactured.
additional_attributesAdditional attributes created for the product. For example:
has_options=0,required_options=0color=Black,has_options=0,required_options=0,size_general=XSqtyThe quantity of the product that is currently in stock.
out_of_stock_qtyThe stock level that determines the product to be out of stock.
use_config_min_qtyDetermines if the default value from the configuration is used, and corresponds to the Use Config Settings checkbox. Values:
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_decimalDetermines if the qty attribute has a decimal value. Values:
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_backordersDetermines if your store allows backorders, and how they are managed.
use_config_backordersDetermines if the default configuration setting for backorders is used, and corresponds to the state of the Use Config Settings checkbox. Values:
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_qtySpecifies the minimum quantity of the item that can be purchased in a single order.
use_config_min_sale_qtyDetermines if the default configuration setting for minimum quantity is used, and corresponds to the state of the Use Config Settings checkbox. Values:
1 鈥 (Yes)0 (or blank) 鈥 (No)max_cart_qtySpecifies the maximum quantity of the product that can be purchased in a single order.
use_config_max_sale_qtyDetermines if the default configuration setting for maximum quantity is used, and corresponds to the state of the Use Config Settings checkbox. Values:
1 鈥 (Yes)0 (or blank) 鈥 (No)is_in_stockIndicates if the product is in stock.
notify_on_stock_belowSpecifies the stock level that triggers an out of stock notification.
use_config_notify_stock_qtyDetermines if the default configuration setting is used to trigger stock level notification, and corresponds to the state of the Use Config Settings checkbox. Values:
1 鈥 (Yes)0 (or blank) 鈥 (No)manage_stockDetermines if inventory control is used to manage the product. Values:
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_stockDetermines if the default configuration setting for managing stock is used, and corresponds to the state of the Use Config Settings checkbox. Values:
1 鈥 (Yes)0 (or blank) 鈥 (No)use_config_qty_incrementsDetermines if the default configuration setting for quantity increments is used, and corresponds to the state of the Use Config Settings checkbox. Values:
1 鈥 (Yes)0 (or blank) 鈥 (No)qty_incrementsEstablishes the number of products that make up a quantity increment.
use_config_enable_qty_incDetermines if the default configuration setting to enable quantity increments is used, and corresponds to the state of the Use Config Settings checkbox. Values:
1 鈥 (Yes)0 (or blank) 鈥 (No)enable_qty_incrementsDetermines if quantity increments are enabled for the product.
is_decimal_dividedDetermines if parts of the product can be shipped separately. Options:
Yes / Nowebsite_idFor installations with multiple websites, identifies a specific website where the product is available. If blank, the product is available in all websites.
related_skusLists the SKU of each product that has been identified as a related product. For example:
24-WG080,24-UG03,24-UG01,24-UG02related_positionDetermines the position (sort order) of the SKUs that are listed as Related Products in the related_skus column. For example:
1,2,3,4crosssell_skusLists the SKU of each product that has been identified as a cross-sell.
crosssell_positionDetermines the position (sort order) of the SKUs that are listed as Cross-sell Products in the
crosssell_skus column.upsell_skusLists the SKU of each product that has been identified as an Up sell.
upsell_positionDetermines the position (sort order) of the SKUs that are listed as up-sell products in the
upsell_skus column.additional_imagesThe file names of any additional image to be associated with the product, preceded by a forward slash. For example:
/image.jpgadditional_image_labelsThe labels associated with any additional images. For example:
Label 1, Label 2custom_optionsSpecifies the properties and values assigned to each custom option. For example:
`name=Color, type=drop_down, required=1, price= price_type=fixed, sku=, option_title=Black
`name=Color, type=drop_down, required=1, price= price_type=fixed, sku=, option_title=Black
Service data for product variations
Attribute
Description
Applies to
_super_products_skuThe generated SKU for a configurable product variation. For example: WB03-XS-Green
Configurable Products
_super_attribute_codeThe attribute code of a configurable product variation. For example: color
Configurable Products
_super_attribute_optionThe value of a configurable product variation. For example: green
Configurable Products
_super_attribute_price_corrA price adjustment that is associated with a configurable product variation.
Configurable Products
_associated_skuThe SKU of a product that is associated with a grouped product.
Grouped Products
Bundle Products
Bundle Products
_associated_default_qtyDetermines the quantity of the associated product that is included.
Configurable Products
Grouped Products
Bundle Products
Grouped Products
Bundle Products
_associated_positionDetermines the position of the associated product when listed with other associated products.
Configurable Products
Grouped Products
Bundle Products
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
Attribute
Description
configurable_variation_labelsLabels that identify product variations. For example:
Choose Color: or Choose Size:configurable_variationsDescribes the values associated with a product variation. For example: `sku=sku-red xs,color=red,size=xs,price=10.99,display=1,image=/pub/media/import/image1.png
Grouped products
Attribute
Description
associated_skusIdentifies the SKUs of the individual products that make up the group.
Bundle products
Attribute
Description
bundle_price_typeDetermines if the price of a bundle item is fixed or dynamic.
bundle_sku_typeDetermines if each item is assigned a variable, dynamic SKU, or if a fixed SKU is used for the bundle. Options: Fixed / Dynamic
bundle_weight_typeDetermines if the weight of a bundle item is variable or fixed.
bundle_valuesDescribes teach value associated with a bundle option. For example:
name=Bundle Option One,type=dropdown; required=1, sku=sku-option2,price=10, price_type=fixedAdvanced 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.
Attribute
Description
sku(Required) The Stock-Keeping Unit is a unique, alphanumeric identifier that is used to track inventory. A SKU can be up to 64 characters in length. For example:
Note: A SKU longer than 64 characters causes import to fail.
sku123Note: A SKU longer than 64 characters causes import to fail.
tier_price_websiteThe website code identifies each website where tier pricing is available. For example:
- website1 - All Websites [USD]tier_price_customerIdentifies the customers鈥 groups where tier pricing is available. For example:
- ALL GROUPS - NOT LOGGED IN - General - Wholesale - Retailertier_price_customer_groupIdentifies the customer groups where tier pricing is available. For example:
- ALL GROUPS - NOT LOGGED IN - General - Wholesale - Retailertier_price_qtyThe quantity of the product that must be ordered to receive the tier price discount.
tier_priceThe discounted tier price of the product. For bundle products, tier price is calculated as a percentage.
group_price_websiteThe website code of each website where group pricing is available. If specifying multiple websites, separate each with a comma and without a space. For example:
- website1 - All Websites [USD]group_price_customer_groupIdentifies the customers鈥 groups where group pricing is available. For example:
- NOT LOGGED IN - General - Wholesale - Retailergroup_priceThe discounted group price of the product. For bundle products, group price is calculated as a percentage.
recommendation-more-help
d3c62084-5181-43fb-bba6-1feb2fcc3ec1