How to create csv import product configurable, downloadable, grouped, bundle for magento 2

Magento 2 support import product configurable, downloadable, grouped, bundle. We will guide create csv format to import product. Besides, we provide extension help you export product from magento 1.

Table of Contents

• A. Product Configurable
• B. Product Downloadable
• C. Product Bundle
• D. Product Grouped

A. Product Configurable

1. Prerequisites

   Product attributes should already be created and assigned to attribute set. Product simple must import first.

2. CSV format

   

   • Column configurable_variations: It's options include sku, attribute name and attribute value each product simple. if you have more one product item then you can separate by pipe (|).
   • Column additional_attributes: It's options for each simple product. Comma separated if more than one attribute per simple product.
   • Column configurable_variation_labels: It's label each attribute. You can skip value for this column.
3. CSV sample http://extensions2.mlx-store.com/Migration/csv/product.csv

B. Product Downloadable

1. CSV format

   Column downloadable_links It's a link include value(Pipe separated if more than one link):

   • group_title: name of group
   • title: name of link
   • price: price of link
   • sortorder: position of link
   • downloads: value is unlimited or define number for link
   • file|url: path of file or url

     

2. CSV sample http://extensions2.mlx-store.com/Migration/csv/product.csv

C. Product Bundle

1. CSV format
   • Column bundle_price_type: value is fixed or dynamic.
   • Column bundle_sku_type: value is fixed or dynamic.
   • Column bundle_weight_type: value is fixed or dynamic.
   • Column bundle_price_view: value is 'Price Range' or 'As Low as'.
   • Column bundle_shipment_type: value is separately or together.
   • Column bundle_values: value of bundle item include field(Pipe separated if more than one value):

     

     • name: name of bundle item.
     • type: type of bundle item. value is: select, radio, checkbox, multi.
     • required: value is 1 or 0.
     • sku: value is sku product item.
     • price: price value
     • default: value is 1 or 0.
     • default_qty: define default qty.
     • price_type: value is percent or fixed
     • position: position of item and must > 0
2. CSV sample http://extensions2.mlx-store.com/Migration/csv/product.csv

D. Product Grouped

1. CSV format

   Column associated_skus: is sku product item (Comma separated if more than one item).

   

2. CSV sample http://extensions2.mlx-store.com/Migration/csv/product.csv