1. Required format
The import file must be in CSV format.
2. Content
| Column | 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: sku123Note: A SKU longer than 64 characters causes import to fail. |
| store_view_code | Identifies the specific store view(s) where the product is available. If blank, the product is available at the default store view. For example: storeview1, english, spanish |
| attribute_set_code | Assigns the product to a specific attribute set or product template, according to product type. Once the product is created, the attribute set cannot be changed. For example: default |
| product_type | Indicates the type of product. Values: simple — Tangible items that are generally 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 | Indicates 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: To set products in a subcategory, enter To set products to several categories, enter |
| product_websites | The 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,website2 |
| name | The product name appears in all product listings, and is the name that customers use to identify the product. |
| description | The product description provides detailed information about the product, and might include simple HTML tags. |
| short_description | The 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. |
| weight | The 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_name | The name of the tax class that is associated with this product. |
| visibility | Determines 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 —The product is available for search operations. Catalog, Search — The product is included in catalog listings and is also available for search. |
| price | The price that the product is offered for sale in your store. |
| special_price | The discounted price of the product during the specified date range. |
| special_price_from_date | The beginning date of the time period when the special price is in effect. |
| special_price_to_date | The last date of the time period when the special price is in effect. |
| url_key | The part of the URL that identifies the product. The default value is based on the product name. For example: product-name |
| save_rewrites_history | When provided with value 1 in combination with a new url_key, a new 301 url rewrite is generated so the old url will be redirected to the new url. |
| meta_title | The 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 less than 70 characters in length. |
| meta_keywords | Meta 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, keyword3 |
| meta_description | Meta 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_image | The relative path for the main image on the product page. Magento stores files internally in an alphabetical folder structure. You can see the exact location of each image in the exported data. 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.jpg |
| base_image_label | The label that is associated with the base image. |
| small_image | The file name of the small image that is used on catalog pages, preceded by a forward slash. For example: /image.jpg |
| small_image_label | The label associated with the small image. For example: Small Image 1, Small Image 2 |
| thumbnail_image | The file names of any thumbnail image to appear in the gallery on the product page, preceded by a forward slash. For example: /image.jpg |
| thumbnail_image_label | The label associated with any thumbnail images. For example: Thumbnail 1, Thumbnail 2 |
| created_at | Indicates the date when the product was created. The date is automatically generated when the product is created, but can be edited later. |
| updated_at | Indicates the date when the product was last updated. |
| new_from_date | Specifies the “from” date for new product listings, and determines if the product is featured as a new product. |
| new_to_date | Specifies the “to” date for new product listings, and determines if the product is featured as a new product. |
| display_product_options_in | If the product has multiple options, determines where they appear on the product page. Values: Product Info Column / Block after Info Column |
| map_price | The minimum advertised price of the product. (Appears only if MAP is enabled.) |
| msrp_price | The manufacturer’s suggested retail price for the product. (Appears only if MAP is enabled.) |
| map_enabled | Determines 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_available | Determines 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_design | Lists the available themes that can be applied to the product page. |
| custom_design_from | Specifies the beginning date when the selected theme is applied to the product page. |
| custom_design_to | Specifies the end date when the selected theme is applied to the product page. |
| custom_layout_update | Additional XML code that is applied as a layout update to the product page. |
| page_layout | Determines 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_container | If 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_type | Determines 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’s this? link. |
| country_of_manufacture | Identifies the country where the product was manufactured. |
| additional_attributes | Additional attributes created for the product. For example:has_options=0,required_options=0color=Black,has_options=0,required_options=0,size_general=XS |
| qty | The quantity of the product that is currently in stock. |
| out_of_stock_qty | The stock level that determines the product to be out of stock. |
| use_config_min_qty | Determines 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_decimal | Determines 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_backorders | Determines if your store allows backorders, and how they are managed. |
| use_config_backorders | Determines 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_qty | Specifies the minimum quantity of the item that can be purchased in a single order. |
| use_config_min_sale_qty | Determines if the default configuration setting for minimum quantity 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). |
| max_cart_qty | Specifies the maximum quantity of the product that can be purchased in a single order. |
| use_config_max_sale_qty | Determines if the default configuration setting for maximum quantity 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). |
| is_in_stock | Indicates if the product is in stock. 1-In Stock 0-Out Of Stock |
| notify_on_stock_below | Specifies the stock level that triggers an out of stock notification. |
| use_config_notify_stock_qty | Determines 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) 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). |
| manage_stock | Determines 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 keep track of the number of items that are currently in stock. |
| use_config_manage_stock | Determines if the default configuration setting for managing stock 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). |
| use_config_qty_increments | Determines if the default configuration setting for quantity increments 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). |
| qty_increments | Determines if the product is sold in quantity increments. Options: Yes / No |
| use_config_enable_qty_inc | Determines 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) 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). |
| enable_qty_increments | Determines if quantity increments are enabled for the product. |
| is_decimal_divided | Determines if parts of the product can be shipped separately. Options: Yes / No |
| website_id | For installations with multiple websites, identifies a specific website where the product is available. If blank, the product is available in all websites. |
| related_skus | Lists the sku of each product that has been identified as a Related Product. For example: 24-WG080,24-UG03,24-UG01,24-UG02 |
| related_position | Determines the position (sort order) of the SKUs that are listed as Related Products in the related_skus column. For example: 1,2,3,4 |
| crosssell_skus | Lists the sku of each product that has been identified as a Cross-sell. |
| crosssell_position | Determines the position (sort order) of the SKUs that are listed as Cross-sell Products in the crosssell_skus column. |
| upsell_skus | Lists the sku of each product that has been identified as an Up-sell. |
| upsell_position | Determines the position (sort order) of the SKUs that are listed as Up-sell Products in the upsell_skus column. |
| additional_images | The file names of any additional image to be associated with the product, preceded by a forward slash. For example: /image.jpg |
| additional_image_labels | The labels associated with any additional images. For example: Label 1, Label 2 |
| custom_options | Specifies 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=White |