PRACTICAL CSV GUIDES · UPDATED SEPTEMBER 23, 2026
Fix price formatting in a Shopify product CSV
A price can look right in a spreadsheet and still have the wrong format for an import. Shopify’s product CSV documentation asks for a monetary value without a currency symbol, such as 19.99.
Start with the intended amount.
Before changing text, confirm the source currency and decimal convention. A comma may separate decimals or thousands. Removing punctuation blindly can turn 19,99 into 1999. Formatting a number does not convert currencies.
| Source value | Possible correction | First confirm |
|---|---|---|
| $19.99 | 19.99 | The intended currency matches the destination |
| 1,299.00 | 1299.00 | The comma is a thousands separator |
| 19,99 | 19.99 | The comma is a decimal separator |
A small worked example.
Before — fictional data: Title,Price Canvas tote,$24.00 After — confirmed USD source: Title,Price Canvas tote,24.00
Current headers include Price and Compare-at price. Older exports may use Variant Price and Variant Compare At Price. RowReady recognizes both common versions; use one version of each column.
A safe review sequence.
- Keep an untouched copy of the original export.
- Confirm decimal separators and currency with the source owner.
- Correct only the agreed price fields, preserving other columns.
- Export comma-separated UTF-8 CSV.
- Run the checker, then review Shopify’s import preview with a small sample.
An empty price may have a different effect from omitting its column. Never assume a blank cell preserves the current store value. Check the overwrite behavior for your specific import.
When to ask for help.
A supplier sheet with mixed conventions, ambiguous prices or several destination markets needs a field-by-field decision. Our sample delivery shows how a scoped cleanup records assumptions and unresolved questions.
Check your CSV → Ask about cleanup
Source: Shopify’s product CSV documentation, reviewed September 23, 2026.