Home > Docs > Product Import Export Plugin for WooCommerce > Import Grouped Products in WooCommerce – Product Import Export

Import Grouped Products in WooCommerce – Product Import Export

Last updated on October 31, 2023

The Product Import Export Plugin For WooCommerce can be used to import grouped products into the WooCommerce Store with ease. To import grouped products in WooCommerce:

  • Select the post type as Product.
  • Select an import method.
  • Ensure the necessary attribute columns are mapped.
  • In the advanced options/ batch import and scheduling step, if required, enable the option Use SKU to link up-sells, cross-sells and grouped products. (Also, in the input file, under the column: “children“, mention the SKU value instead of ID.)
  • Click on Import to finish.

The basic flow of importing grouped products is demonstrated with “Hoodie and Jeans” as a grouped product. Here, the products: Black Hoodie and Jeans are separate child products. Normally, we come across the following cases when dealing with grouped products.

Case 1: When the WooCommerce store has child products, but no parent products.

In this case, it is sufficient for the CSV to have data of only the parent product. In the column: “children“, mention multiple child product IDs using the pipe symbol:“|”.

Case 2: When the WooCommerce store does not have any child or parent products.

In this case, the CSV must have the data of both the child and parent products. However, this scenario is considered uncertain, as one does not know the child product’s ID that will be generated on import. To resolve this:

  • In the column: “children“, mention the SKU value instead of ID.
  • Enable the option: Use SKU to link up-sells, cross-sells and grouped products, by choosing Yes. This option is listed in the Advanced options/Batch import/Scheduling step of the import process.
Using SKU to link grouped products
Using SKU to link grouped products

Once we have identified all the details, we can perform an import. For help on import, refer to How to import products. On successful import, we can see that the products have come perfectly into the system.

Imported grouped products
Imported grouped products

The base product and its child product in your shop can be viewed as :

Product view with grouped items
Product view with grouped items
Single product view
Single product view

Related articles: