Import Grouped and External Products
Alongside simple and variable products, the WooCommerce Products template supports grouped and external / affiliate products.
Table of Contents
Grouped products
A grouped product displays several simple products on one page so customers can add multiple items from a single screen.
Example CSV
| Name | SKU | Product Type | Price | Grouped Products |
|---|---|---|---|---|
| Simple Product 1 | simple-one | simple | 10.99 | |
| Simple Product 2 | simple-two | simple | 12.99 | |
| Simple Product 3 | simple-three | simple | 14.99 | |
| Grouped Product | group-one | grouped | simple-one, simple-two |
Setup
- Import (or ensure) the simple products exist first, each with a SKU.
- On the grouped row:
- Product Type =
grouped - Product SKU = grouped product SKU
- Under Linked Products → Grouped products:
- Map the list of child SKUs (or IDs / names / slugs)
- Set Grouped Products Type to Product SKU (or match the value type you mapped)
- Product Type =
Linked product references must already exist. Import simple products before the grouped parent, or run two imports.
Grouped products do not use a single selling price the same way simple products do — pricing comes from the linked simples.
External / affiliate products
External products show a button linking to an off-site URL instead of Add to Cart.
Example CSV
| Name | SKU | Product Type | Price | Product Url |
|---|---|---|---|---|
| External Product 1 | external-one | external | 10.99 | https://www.importwp.com/integrations/import-woocommerce-products/ |
Setup
- Set Product Type to
external. - Under Product Fields, enable the External Product URL subgroup:
- Product URL — destination URL
- Product URL Button Text — optional (WooCommerce default used if empty)
- Map Regular Price if you want a displayed price.
- Stock / inventory quantity fields are not applied to external products.
Linked products (upsells and cross-sells)
Under Linked Products you can also map:
| Subgroup | Purpose |
|---|---|
| Up-Sells | Products to promote as upgrades |
| Cross-Sells | Products to suggest in cart |
| Grouped products | Children of a grouped product |
Each subgroup has:
- A products list (comma-separated)
- A Type selector: Product ID / Product SKU / Product Name / Product Slug
Referenced products must already exist when the row is processed.