Shopify import error · from WooCommerce
Grouped and external/affiliate WooCommerce products missing after a Shopify import
The product count in Shopify is lower than in WooCommerce and no error explains why. Often the missing ones are grouped products or external/affiliate products, types that Shopify does not have.
Why it happens
A WooCommerce grouped product is a page that lists other products, each bought separately; it has no price or stock of its own. Shopify products always carry at least one variant with a price, so there is nothing to import the grouped product into.
An external/affiliate product has a button that sends the buyer to another site. Shopify has no field for that destination URL in the product CSV, so a straight import would create a product that can be added to the cart and paid in your store, which is not what the original did.
How the free check finds it
The check reads the Type column of every row. Grouped and external products are reported by name and left out of the import file, while the children of a grouped product are imported as normal products, so nothing that can actually be sold is lost.
These are the findings the check reports for this problem, each with the lines of your file where it found them:
- Changes silently
Product type Shopify does not have
Grouped and external/affiliate products have no Shopify equivalent and are not imported.
What to do: Child products import normally; rebuild the rest as a collection or as a product with a link.
Fix it by hand
- For each grouped product in the report, create a Shopify collection or a bundle (Shopify Bundles app or a theme section) with its child products.
- For each external product, create a product with the outbound link in the description, or a page with a button, and disable purchase on it if it should not be sold in your store.
- Redirect the old WooCommerce URLs of these products to the new collection or page so links and search results keep working.
Find this in your own export, free
Upload your WooCommerce product export (and customers, if you like). In about a minute you see every row this affects, with line numbers, before anything touches Shopify. No account, no access to your store.