Quick Rule Summary · Updated November 2026

To bulk-update Shopify prices safely with “Overwrite products with matching handles,” include URL handle, Title (on row 1), Option1 value (for variants), and Price—and completely omit columns like Description, Tags, or Product image URL instead of leaving them blank (blank columns erase live store data!).

01 / INTERACTIVE BULK UPDATE SIMULATORPreview sale markdowns, post-sale resets & option dependencies.

Test how Shopify’s CSV overwrite handles four common pricing tasks—including the dangerous mistake of unchecking Option1 columns on a multi-size product:

% markdown / hike
Variant safety dependency
Inspect blank-price behavior in Workspace ↗

02 / THE #1 PARTIAL-CSV DISASTERWhy a 3-column CSV deletes size and color variants.

Shopify’s Product CSV importer matches products by URL handle (legacy Handle), NOT by SKU! When you tick “Overwrite products with matching handles”:

  1. Shopify rebuilds the variant tree from the option columns in your CSV: If an apparel item has Small, Medium, and Large in your store, your partial price-update CSV must include URL handle, Row-2 Title, Option1 name, and every row’s Option1 value (plus Option2 and Option3 if the item also varies by Color or Material).
  2. SKU alone cannot identify variants during CSV import: Including SKU without Option1 value causes duplicate-handle collisions and strips existing variant options.
  3. Leave images and descriptions completely out of the file: Columns that are omitted entirely from Row 1 (such as Description, Vendor, Tags, and Product image URL) stay untouched on your live store!

03 / OMITTED COLUMN VS. BLANK CELLThe critical rule for ending a sale.

Merchants often finish a weekend promotion, upload a CSV with updated Price values, and wonder why old strikethrough prices are still showing—or worse, why their product tags vanished:

How Shopify’s CSV Overwrite treats omitted columns versus included columns with empty cells
CSV structureEffect when Overwrite is checkedWhen to use it
Column omitted from Row 1
(Header not in CSV at all)
Preserves existing store data (provided dependent option/variant columns aren’t broken).Leave out Description, Tags, Product category, and Product image URL during fast price updates.
Column in Row 1 + blank cells
(Header present, cells empty)
Erases / resets live store values (or applies Shopify’s default, such as 0.00 on an empty Price).Include Compare-at price with empty cells to clear old sale strikethroughs after a promo ends (see empty Price rules).

04 / SAFE 4-STEP WORKFLOWRun bulk price updates with an instant rollback net.

  1. Export a full product CSV backup first: In Shopify Admin (Products → Export → All products, Plain CSV file), save an untouched timestamped backup on your computer—that file is your 60-second undo button.
  2. Keep only identity + pricing columns in a copy: Retain URL handle, Title, Option1–3 name/value, SKU, Price, and Compare-at price. Strip currency symbols (24.00, never $24.00).
  3. Preflight in Row & Record (Update mode): Load your edited UTF-8 CSV into our browser-local workspace, switch the import intent to Update existing products, and confirm zero missing option dependencies or non-numeric prices (or check headers fast via our Chrome Extension ↗).
  4. Test 2 products before updating 2,000: Upload a 2-product test slice with Overwrite products with matching handles checked, verify storefront variants, images, and strikethroughs, then run your full batch.

Common questions.

Can I update Shopify prices by CSV using only SKU and Price?

No. Shopify’s Product CSV importer matches products by URL handle (Handle), not by SKU. Even for a price-only update, you must include URL handle, Title, Price, and—for any product with variants—all active Option name and Option value columns.

If I leave Description and Product image URL out of my price update CSV, will Shopify delete my photos?

No—as long as those column headers are completely omitted from Row 1 (not included as blank columns) and you keep all required Option1–3 variant columns so existing variant IDs are preserved. Always keep a full export backup and test 1–2 products first.

How do I remove Compare-at sale prices in bulk after a sale ends?

Include the Compare-at price (or Variant Compare At Price) column header in Row 1, leave the cells underneath completely blank (never 0.00), set Price back to regular retail, and import with Overwrite products with matching handles checked.

What happens if I put 0 or 0.00 in Compare-at price instead of leaving it blank?

Depending on your theme, 0.00 in Compare-at price is either ignored as lower than Price or causes broken badge logic in third-party filter apps. Always use a genuinely empty cell when an item is not on sale.

RELATED CSV TOOLSRelated Shopify price & catalog CSV tools

Ready to verify your price-update CSV?

Switch Row & Record to Update mode to check option dependencies and prices locally in your browser.

Open CSV Preflight Workspace ↗

Verified November 2026 against Shopify’s CSV overwrite column-dependency rules and Row & Record’s Update-mode validator.

Shopify CSV overwrite & omitted-column rulesShopify product CSV column referenceRow & Record Chrome Extension ↗