How to import bundle products?

How to import bundle products?

In order to link a bundle product with the options, all the products should be imported to Magento first. 

Here are the minimum required fields to import a new product:



For more convenience, please, feel free to add product attributes such as name, price, description, etc.:


Here is an example of the import file:



Then, to link bundle products with simple options, the following fields will be needed:

Root Entity



Bundle Option Entity



Bundle Option Value Entity



Bundle Selection





Here are some tips on how to locate the values for some of the fields in the import file:
1) catalog_product_bundle_option.option_id
This value van be located in the DB table 'catalog_product_bundle_option'. Find the last value and increase it by 1 to insert in the import file.
2) catalog_product_bundle_option.parent_id
ID of the bundle product, which can be located in Catalog > Products grid.
3) catalog_product_bundle_option_value.value_id
This value should be checked in the 'catalog_product_bundle_option_value' DB table.
4) catalog_product_bundle_option_value.option_id
The same id as in the 'catalog_product_bundle_option_value' field.
5) catalog_product_bundle_option_value.store_id
"0" for all the store views. IDs of the separate store views can be located in Stores > All Stores > needed store view's URL.
6) catalog_product_bundle_option_value.parent_product_id
ID of the bundle product, which can be located in Catalog > Products grid.
7) catalog_product_bundle_selection.selection_id
The value can be checked in the 'catalog_product_bundle_selection' DB table. Find the last existing value and increase it by 1 to insert in the import file.
8) catalog_product_bundle_selection.option_id
The same id as in the 'catalog_product_bundle_option_value' field.
9) catalog_product_bundle_selection.parent_product_id
ID of the bundle product, which can be located in Catalog > Products grid.
10) catalog_product_bundle_selection.product_id
ID of the simple product, which can be located in Catalog > Products grid. If the 'SKU to Product ID' modifier is enabled for this field, you may use the product's SKU in the import file.

Here is the sample import file for more convenience.

More use-case scenarios may be found in the article Useful Tips and Popular Import Use Cases.

      • Related Articles

      • Import and Export Guidelines

        General Information About the Package and Its Tariffs The Import & Export solution is designed for migrating data from one website to another or to/from a different platform, as well as for automated/manual updates of product quantities, prices, and ...

      • What is the required minimum of fields to import orders/products/customers?

              There is an option to automatically fill the import profile with fields for typical cases for all import modules. This option is available on creating a new import profile in the Import Settings tab:       If enabled, Fields Configuration will ...

      • How to assign multiple websites to the products?

        At the moment, the following import fields are required to assign the product to multiple websites: Root Entity Product Website Entity Here is an example of the import file, where 'website_id' stands for the ID of the website, which can be located in ...

      • Products are being imported without name, price, and other values. How to fix this?

        If the product itself is imported, but additional attributes are missing, the following steps might be helpful to resolve the issue: Step 1. Ensure that the Entity Keys are added as prefixes to the columns' names in the import file. In Magento's ...

      • Is it possible to import data to Magento with a custom file?

              It is possible to use a custom import file, but there are a few peculiarities that must be taken into account.       Import modules provide features for flexible configuration of the import file like setting custom entity and field names or ...