Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

7 costly Shopify import mistakes (and how to undo them)

Scientific-notation IDs, decimal commas, missing handles: the seven import mistakes we see most, how to spot them before they go live, and how to recover.

The Bulkvane teamPublished Last updated 4 min read
Bulkvane's import check: values fixed automatically, such as product statuses, and a warning that a compare-at price isn't higher than the price.

Why imports go wrong

Most broken imports aren't caused by a big mistake. They're caused by a spreadsheet program quietly “helping”: reformatting an ID, swapping a dot for a comma, trimming a leading zero. Here are the seven we see most often, and what to do about each.

Accents that turn into “é” after an import are a different problem: the file wasn't saved as UTF-8. Here is how to fix Shopify CSV encoding errors in Excel, Google Sheets and Numbers.

1. IDs turned into scientific notation

Shopify product and variant IDs are long numbers. Open an export in Excel and 7234567890123 becomes 7.23457E+12. Save the file and the real ID is gone, so the import can't find the product.

Bulkvane checks for this and stops the row with a clear message: “ID 7.2E+12 was shortened by your spreadsheet program (scientific notation). Format the ID column as Text and export again.”

2. Decimal commas and currency symbols

A supplier in Germany sends “19,50 €”. Shopify expects 19.50. Depending on the tool, that becomes 1950, an error, or nothing at all.

Bulkvane reads decimal commas, thousands separators and currency symbols, converts them, and tells you it did: “Price “12,50 €” contains a currency symbol and a decimal comma — it will be saved as 12.50.”

3. Handles with spaces or capitals

Handles are the product's URL slug. They can only use lowercase letters, numbers and dashes. “Blue Linen Shirt” isn't a valid handle; “blue-linen-shirt” is. A bad handle can create a duplicate product instead of updating the existing one.

4. Rows with no ID, handle or title

Every row needs something that says which product it belongs to. Variant rows copied from another sheet often lose that link. Keep the Handle column filled on every variant row, even if it repeats.

5. Tags separated the wrong way

Shopify separates tags with commas. Exports from other systems often use semicolons or pipes, which turns “summer;linen” into one strange tag. Bulkvane splits on “;” and “|” too, and removes duplicates.

6. Status values that don't exist

Product status must be Active, Draft or Archived. “Published”, “Live” or “hidden” won't work. Bulkvane accepts different capitalisation and tells you when a value isn't recognised.

7. No way back

The costliest mistake is the one you can't reverse. Shopify's CSV import has no undo, so a wrong file means fixing products one by one or restoring from an old export, if you have one.

  1. Export your catalogue before any big change and keep the file.
  2. Use a tool that shows every change before applying it.
  3. Prefer imports that can be undone. In Bulkvane, each import saves a snapshot first, and one click restores every product it changed for 30 days.

Frequently asked questions

Why did my Shopify import create duplicate products?

Usually because the handle didn't match. A handle with spaces, capitals or a typo doesn't match the existing product, so a new one is created. Keep the exact handle from an export, or keep the ID column.

Why do my product IDs look like 7.23457E+12?

Excel shows long numbers in scientific notation and rounds them when you save. Format the ID and Variant ID columns as Text before you edit. If the file was already saved, export again.

What status values does Shopify accept for products?

Active, Draft and Archived. Words like Published, Live or hidden aren't recognised. Bulkvane accepts any capitalisation and tells you when a value isn't one of the three.

Can I undo a Shopify CSV import?

Not with Shopify's built-in importer. Bulkvane saves a snapshot before each import, and Undo restores every product it changed for 30 days.

Why does “Café” show up as “Café” after an import?

The CSV wasn't saved as UTF-8, the encoding Shopify reads. In Excel, use File → Save As → CSV UTF-8 (Comma delimited). Google Sheets downloads are always UTF-8. Or import an Excel (.xlsx) file into Bulkvane, which doesn't have this problem.

Related guides

How to bulk edit Shopify productsFree CSV templatesBrowse the help center

Preview every change.Undo any import for 30 days.

Install free