Shopify said the import worked. How to check if it actually did.

Run these five checks in your Shopify admin right now — they catch every common way an import reports "success" while landing wrong. Each one tells you what to fix in your source file before you import again.

Check 1 — are the product counts right?

After the import, go to Products in your Shopify admin and look at the total product count (bottom of the list or visible in the pagination). Compare it to the number of products in your file.

• Count went up by the right number: new products were created correctly.
• Count didn't change at all: your file contained Handles that already exist in your store, so Shopify updated the existing products rather than creating new ones — or the rows were skipped for another reason.
• Count went up by fewer than expected: some rows were silently skipped. This often means variant rows were dropped (Shopify has a 100-variant-per-product limit) or image rows were skipped because the URL wasn't reachable.

Check 2 — are the products visible to customers?

Products in Shopify can exist in your admin but be invisible on the storefront if they imported as drafts. Open a product you just imported and look at the Status field in the top right. If it says Draft instead of Active, customers can't see or buy it.

This happens when your CSV's Published column was blank, contained FALSE, or was missing entirely. A blank Published column is not treated as "yes, publish it" — it's treated as "no." You need an explicit TRUE in that cell for a product to go live on import.

Check 3 — are the prices correct?

Find a product with a known price and open it. Look at the price for each variant. If prices show as $0.00 or blank, your CSV had a price formatting problem — dollar signs, commas, or currency codes in the Variant Price column. Shopify accepted the rows but couldn't parse the numbers, so it stored zero.

Check 4 — do the product names and descriptions look right?

Click into one product and check the title and description for strange characters. If you see é instead of é, or ’ instead of an apostrophe, your file had a character problem that Shopify accepted without complaint. The text in your store is now garbled for every customer who visits those product pages.

Check 5 — did the import overwrite products you didn't intend to change?

Look for products whose content or prices changed unexpectedly. Shopify matches on Handle — if your import file contained a Handle that already existed in your store, that product was updated, not created. If someone else's products share handles with yours (possible with certain supplier templates), their data may have been silently overwritten.

Fix the file before the next import

Catching these issues after the import is the hard path. The easier path is to run your file through the Shopify products CSV repair tool before you upload it. It checks for price formatting, blank Published values, character problems, and duplicate Handles, and gives you a plain-language list of what's wrong before anything touches your live store. A repaired file, not a re-import guess.

Why Shopify's "success" can still mean something went wrong

Shopify's import pipeline is built to be forgiving. Rather than blocking an entire import for recoverable issues, it often accepts the file, records what it can, and quietly skips or mishandles the parts it couldn't parse. The "import successful" message means the file was processed — not that every row landed the way you intended. That's why the checks above matter: several common problems produce a success message alongside a broken result, and knowing which one you hit tells you what to fix in the file.