Learn / Invalid compare-at price

Fix invalid compare-at prices in Shopify CSV

Compare-at prices must be plain numeric values. Remove currency symbols, commas, and text.

Before and after example

Variant Price,Variant Compare At Price
29.00,$39.00 USD

Variant Price,Variant Compare At Price
29.00,39.00

1. 1. Find all Compare At Price cells with non-numeric characters.
2. 2. Convert values to numbers with optional decimal points.
3. 3. Re-check rows where Compare At Price is lower than Price.

Why this fails in Shopify

Compare-at fields are numeric import columns. Text formatting can fail validation and inconsistent values can create merchandising errors.