Shopify CSV Blank Overwrites
Why empty cells erase live data — and how to catch it.
Every merchant who’s been burned by a Shopify import describes the same scene. They exported their products, edited one column, and re-imported. Shopify said “success.” Then they noticed prices were gone. Inventory was zeroed out. Titles were blank.
The cause is not a bug. It’s a design choice in Shopify’s importer that almost nobody warns you about. This guide is about that choice — and how to see it coming before you click import.
In Excel, an empty cell means “no value here.” In Shopify’s importer, an empty cell in an included column means “clear this field on the existing product.” Same cell, opposite outcome.
What is a destructive blank?
A destructive blank is an empty cell in a CSV column that Shopify is actively matching against your existing products.
When you export products from Shopify, the CSV includes every column:
Handle, Title, Variant Price,
Variant Inventory Qty, Body (HTML), and so on.
Every row has a value in every column.
When you edit that file and re-import it, Shopify doesn’t know which cells you “changed” and which you “left alone.” It only knows what’s in the cell right now. If a cell is blank, Shopify assumes you want that field cleared.
That’s the whole problem. There is no “leave this field alone” option in the CSV format. Blank = erase.
The scenario that catches merchants
Here’s how it happens in practice — it’s almost always one of these:
1. You deleted a column you didn’t need
You exported 5,000 products. You want to update prices. To make the
file smaller, you delete the Body (HTML),
Image Src, and SEO Title columns — reasoning
that you’re not changing those fields, so why include them?
What actually happens: Shopify reads the remaining
columns as the full set of updates. Since Body (HTML)
isn’t in the file, Shopify leaves it alone. That part is fine.
But — if you deleted some columns and left others blank, the blanks in the included columns get treated as clears. It’s the mixed case that kills you.
2. You left cells blank because you didn’t know what to put
You’re updating inventory for 2,000 products. A few products don’t have inventory tracked yet. You leave those cells blank, figuring Shopify will skip them.
What actually happens: The file includes the
Variant Inventory Qty column. For those blank cells,
Shopify clears the inventory on matching products. If any of those
products had inventory, it’s now gone.
3. A spreadsheet filter or sort left cells empty
You sorted or filtered the CSV in Excel, made changes, then saved. The sort shifted rows but didn’t fully preserve the data in every column. A few cells ended up blank without you noticing.
What actually happens: Those blank cells get treated as deliberate clears on the matching products. The import reports success. The next day, customers see missing prices, zero inventory, or products with no title.
Why Shopify’s importer works this way
It’s not an oversight. It’s how Shopify’s CSV format supports bulk updates.
If you want to clear a product’s compare-at price (because the sale ended),
you include the Variant Compare At Price column with that
cell blank. Shopify clears the value. That’s the intended use.
The same mechanism lets you clear tags, descriptions, or images by exporting, removing the values, and re-importing. It’s efficient. It just has no safety net.
Shopify’s own CSV documentation mentions that blank values in included columns “overwrite” existing data. It’s one sentence buried in a large document. Most merchants never read it. The ones who do find out after the fact.
Omitted column = Shopify ignores it.
Included column with blank cell = Shopify clears the matching field.
Included column with a value = Shopify sets the field to that value.
How to find destructive blanks before import
There are three approaches, each with different tradeoffs:
Approach 1 — The manual check
Open the CSV in Excel or Google Sheets. For each column you plan to include:
- Highlight the column
- Use “Go to Special → Blanks” (Excel) or a filter for empty cells
- Count how many are blank
- Decide: is it intentional or accidental?
This works if you have 50 rows and one column to check. It does not work if you have 2,000 rows and 20 columns. You’ll miss cells. You’ll get tired. You’ll import anyway.
Approach 2 — Split the file
Instead of one update file with many columns, create several smaller files, each targeting one field. Export a file with just Handle + Variant Price. Import it. Then export a file with just Handle + Variant Inventory Qty. Import it. Each file has no blanks because every row is being updated.
This works. It’s also slow, error-prone, and doesn’t scale past a few hundred products.
Approach 3 — Scan the file first
Run the file through a validator that tells you exactly which cells in included columns are blank. Every row, every column, in one pass.
Find every destructive blank in your CSV
Autonom Shopify Guard scans your file, lists every blank cell in an included column, and shows the current live value that would be erased. Free, browser-based, no account required.
Check your CSV for blanks →What a destructive blank looks like in a report
When Autonom detects blanks in included columns, it groups them by column and shows the affected rows. For each one, it tells you:
- Which column has the blanks
- How many rows are affected
- The current live value that would be cleared
- Whether the fix should be to fill the cell or remove the column entirely
If the column is entirely blank — no row has a value — Autonom can remove it from your file automatically, since it has no effect on the import anyway.
If the column is partially blank, Autonom flags it as a review-required fix. You decide whether to remove the column or fill in the missing cells. It never invents data on your behalf.
Related guides
Frequently asked questions
How do I know if a blank cell will erase data or be ignored?
If the column is included in the CSV header, Shopify treats any blank cells in that column as intentional overwrites for matching products. If the entire column is omitted from the CSV, Shopify leaves the corresponding field alone.
Is there a way to tell Shopify “leave this field alone”?
Yes — omit the column entirely. There is no “skip this cell” value. If a column is present, every blank cell is treated as a clear instruction.
What if I only want to update some products’ prices?
Include only the rows for products you want to update. Handle + Variant Price columns are usually enough. Rows for other products shouldn’t be in the file at all.
Can I recover from a destructive blank?
Yes, if you have a backup export from before the import. Re-import the original values. Without a backup, you’ll need to restore manually. This is why we recommend always exporting a fresh backup before any bulk import.
Does this apply to new-product imports too?
No. New-product imports create products, so there’s no existing data to erase. The destructive blank problem is specific to updates and requires the product to already exist in your store.
Are some columns more dangerous than others?
Yes. Price, inventory quantity, title, and status are the highest-impact columns. Clearing a price or an inventory count has immediate customer-facing consequences. Clearing a description is annoying but less urgent. Autonom sorts issues by severity in the report.