Quick diagnosis
| What you see | What to check first |
|---|---|
| Products appear in the admin but not on the storefront | Status, Published on online store, and whether the product is published to the Online Store channel |
| Nothing changed after importing products that already exist | Whether Overwrite products with matching handles was selected. Without it, products that match an existing handle are ignored |
| Only some products appeared | Lines that were ignored or rejected, such as duplicate handles or rows without a title |
| Products appear in some markets or channels but not others | The Included / market columns and the channel availability of each product |
The settings that control visibility
Status
The Status column accepts active, draft and archived. Shopify’s documentation says that if the column is in your file, every row needs a value in it, and if the column isn’t there at all, products are uploaded as active. A draft product isn’t ready to be sold, so rows marked draft import as drafts.
Published on online store
This column (called Published in older templates) takes true or false. The default is true, which makes the imported product visible on the online store. A value of false keeps it off the online store.
The sales-channel checkbox in the import dialog
When you import, Shopify offers Publish new products to all sales channels. If you only want new products on your online store, deselect it. Shopify also states that a CSV can’t be used to bulk-update product availability on other sales channels, so changes for existing products have to be made in the admin. Shopify explains how in its help article.
Markets columns
If you sell internationally, your export includes columns such as Included / [Primary] and Included / International, named after your markets. They default to true, and they control whether a product is included for sale in that market.
Make sure the import actually ran
- Shopify sends a confirmation email to the account that set up the store when a CSV is uploaded.
- Imports can’t be canceled once they begin, and Shopify doesn’t keep a history of past imports. To see what an import changed, check the store’s activity log.
- Lines can be ignored without stopping the whole import. If some products are missing, look at the ignored-line messages and see our guide to handle and option errors.
A safer way to import a big catalog
This one is our suggestion, not a Shopify requirement. For the first import, set Status to draft, check a handful of products in the admin (prices, variants, images, inventory), and only then change them to active. It means a mistake never reaches your storefront.
What ShopiClean does with visibility columns
Disclosure: ShopiClean is our own product. Everything in this guide can be done by hand in a spreadsheet; the tool simply automates the checks. The scan and the on-screen 5-row preview are free, and downloading the repaired file needs a 7-Day Pass ($9).
What it does:
- Standardizes yes/no and status values to the words Shopify accepts. In our test, Yes became
true, No becamefalseand Published in the Status column becameactive. - Works with both the older Published column and the current Published on online store column.
What it does not do:
- It leaves blank Published and Status cells as they are and doesn’t warn about them. If your file has a Status column, check that every row has a value.
- It can’t see your store’s sales channels, markets or import settings, and it can’t change availability for you.
Sources and how this guide was checked
The Shopify behaviors described above were checked against the Shopify Help Center pages below on 19 October 2026. Shopify can change how imports work, so if something here differs from what you see, trust Shopify’s documentation.