Shopify silent import failure

Your products imported — but they're invisible to customers because they all landed as drafts

The import looked like it worked. Your products are in Shopify admin. But when you go to your live store, none of them are there. Customers can't see them, can't buy them, can't find them. They're all sitting in Draft status — published to you, hidden from everyone else.

import-shopify-products · xlsx-for-ai

The fix: set the Published column to TRUE

Every row in a Shopify product Comma-Separated Values (CSV) file has a column called Published. Set it to TRUE on every row to make products live on your storefront; FALSE (or blank) keeps them hidden in drafts.

If you only have a handful of products, the fastest fix is to go to Products in your admin, click into each draft product, and click Publish. You can also select multiple products from the product list and use the bulk action to set them as active.

If you imported a large catalog, bulk-publishing from the admin can be slow. The cleaner fix is to go back to your original spreadsheet, add a Published column (or find the existing one), set every row to TRUE, and re-import. Shopify will match the rows by their Handle values and update the status without creating duplicates. Before you do this, make sure the Handle values in your file exactly match the handles of the products that were imported — otherwise Shopify will create new products instead of updating the existing ones.

How to confirm this is what happened

In your Shopify admin, go to Products. At the top of the list you'll see filter tabs: All, Active, Draft, Archived. Click Draft. If all your newly imported products are sitting there, that's the problem. The import succeeded — the products exist — but they were never made active on your storefront.

Why they landed as drafts

When the Published column is blank — not set to anything at all — Shopify treats it as FALSE and creates the product as a draft. If you built your product spreadsheet without including a Published column, or if the column was there but left empty, every product came in as a draft. No warning, no error — Shopify just quietly put them all in the hidden pile.

This also happens when someone exports a Shopify CSV where the products were already drafts, and then re-imports it. The FALSE values travel along with the data and make everything a draft again.

How to prevent this next time

When you use the free Shopify product import converter to prepare your file, it checks the Published column and flags blank or missing values before you import. You can choose whether you want products to go live immediately or stay as drafts — and the converter makes sure the column reflects your choice in every row. The report it generates tells you exactly what was set so you're not guessing after the fact.

The converter also catches the other common reasons products end up invisible after import — like being imported with no collections assigned, or with inventory set to 0. You get one plain-language summary of everything that would affect your customers before you ever hit the Shopify import button.

Didn't see any products at all — not even in Drafts? That's a different problem: import said successful but products aren't showing up.

Fix this free → Upload your spreadsheet to the Shopify product import converter. It sets the Published column correctly and shows you a plain summary of what every product's status will be before you import.