Woo to Shopify Check

Shopify import error · from WooCommerce

Shopify CSV import: products show up as Draft, or hidden WooCommerce products become visible

After a WooCommerce import, some products are missing from the Shopify storefront and others appear that customers were never meant to see. Both come from how the two platforms model visibility.

Why it happens

WooCommerce has a publish status (published, private, draft, pending) and, separately, a catalog visibility (shop and search, shop only, search only, hidden). Shopify has only a product status (Active, Draft, Archived) plus sales channels. A private or draft WooCommerce product has no Active equivalent, so the safe mapping is Draft.

Catalog visibility has no column in the Shopify product CSV at all. A product hidden in WooCommerce, often a gift card, a bundle component or a product sold only through a direct link, imports as an ordinary Active product and appears in collections and search.

How the free check finds it

The check reads the Published column of the export (-1 means private or draft) and the Visibility in catalog column. Private and draft products are flagged and written with Status = draft; hidden products are flagged with their line number so you can decide what to do with each one after the import.

These are the findings the check reports for this problem, each with the lines of your file where it found them:

  1. Changes silently

    Private or draft product

    It is imported as Draft and stays hidden until you publish it.

    What to do: Publish it in Shopify when ready.

  2. Changes silently

    Product hidden in the catalog

    Shopify has no “hidden in catalog” setting, so the product becomes visible in your store.

    What to do: Set it to Draft or remove it from sales channels after the import.

Fix it by hand

  1. Open the report and list the products flagged as hidden: decide for each whether it should be Draft, Archived, or Active but removed from the Online Store channel.
  2. Import the file, then use bulk edit in Shopify admin to set the status or sales channels of those products.
  3. Review the Draft products the check reported and publish the ones that were private in WooCommerce only by mistake.

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.

Run the free check See an example report

Other import errors

All Shopify import errors