Invalid price

What is this issue?

The price value is not a valid decimal number.

Why Amazon rejects this

Invalid price values cause the row to be rejected by Amazon's flat-file processor.

Valid values / expected format

• ✓Positive decimal number -- e.g. 9.99, 100.00, 1999.95
• ✓Use a period (.) as the decimal separator, not a comma
• ✓No currency symbols ($, USD, GBP, EUR)
• ✓No thousand separators -- write 1000.00 not 1,000.00
• ✓Maximum 2 decimal places for most platforms

Examples

Fix in StriveFormats

Upload your CSV to StriveFormats to detect this issue across all rows, with clear line-by-line reporting.

Fix in Excel

1. 1In Excel, click the column letter for the Price / StartPrice column to select it.
2. 2Press Ctrl+H (Find & Replace). In 'Find what', type: $ -- leave 'Replace with' blank -- click Replace All. Repeat for the pound sign, euro sign, and any other currency prefix.
3. 3Find: , (comma, for thousand separators like 1,000) -- Replace with: (nothing). This converts 1,000.00 to 1000.00.
4. 4Right-click the selected column, choose 'Format Cells', select 'Number', set Decimal places to 2, click OK.
5. 5Scroll through the column and verify values look like 9.99 or 1000.00 with no symbols.
6. 6Save as CSV (Comma delimited).

Fix in Google Sheets

1. 1In Google Sheets, click the column letter for the Price / StartPrice column.
2. 2Press Ctrl+H. Find: $ -- Replace with: (empty) -- Replace All. Repeat for the pound sign and euro sign.
3. 3Find: , (the comma used in thousand separators like 1,000) -- Replace with: (empty) -- Replace All.
4. 4Select the column again. Go to Format > Number > Number to ensure cells are treated as numbers.
5. 5Verify all prices look like 9.99 or 1000.00 with no symbols.
6. 6Go to File > Download > Comma Separated Values (.csv).

Prevent it next time

• --Always format price cells as Number (2 decimal places), not Currency, in Excel.
• --Never copy prices from a webpage or PDF -- they often include currency symbols or use commas as decimal separators.
• --Use a period (.) as the decimal separator regardless of your computer's regional settings.
• --Avoid using SUM() or other formula results in price cells -- use Paste Special > Values to paste plain numbers.
• --Run every file through StriveFormats before importing to catch formatting issues early.

How StriveFormats detects this

StriveFormats validates the Price / StartPrice column by checking that each non-empty cell parses as a positive decimal number. Values containing currency symbols, commas, or non-numeric characters are flagged.