Alongside simple and variable products, the WooCommerce importer Products template supports grouped and external / affiliate products.
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)
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/woocommerce-importer/ |
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.
Updated 2026-09-07