Price without a currency code

What is this issue?

The price has a number but no currency code, or only a $ sign, which several currencies use.

Why Google Merchant Center rejects this

Google needs the ISO 4217 currency code (USD, CAD, EUR...) to show the right price.

Valid values / expected format

1. ✓A number, a space, then the ISO 4217 currency code: 19.99 USD
2. ✓Use a period (.) as the decimal separator, not a comma
3. ✓No thousand separators: write 1000.00 USD, not 1,000.00 USD
4. ✓The currency must match the country you sell in
5. ✓Greater than 0

Fix in StriveFormats

StriveFormats flags every price without a currency code. Symbols that name one currency, such as € or £, are converted for you; a bare $ is flagged, because several currencies use it.

Fix in Excel

1. 1In Excel, click the column letter for the price column to select it.
2. 2Right-click the column, choose 'Format Cells', select 'Text', and click OK, so Excel doesn't turn the prices back into numbers.
3. 3If every price is in the same currency, add the code with a helper column: =A2&" USD" (replace A2 with your price cell and USD with your currency), copy it down, then paste it back over the column with Paste Special > Values.
4. 4Press Ctrl+H and replace any currency symbol, such as $ or €, with nothing before you add the code.
5. 5Check that every value looks like 19.99 USD: a number, a space and the code.
6. 6Save as Text (Tab delimited) (*.txt).

Fix in Google Sheets

1. 1In Google Sheets, click the column letter for the price column.
2. 2Go to Format > Number > Plain text, so Sheets keeps the price and the code together as text.
3. 3If every price is in the same currency, add the code with a helper column: =A2&" USD" (replace A2 with your price cell and USD with your currency), copy it down, then paste it back with Edit > Paste special > Values only.
4. 4Press Ctrl+H and replace any currency symbol, such as $ or €, with nothing before you add the code.
5. 5Check that every value looks like 19.99 USD: a number, a space and the code.
6. 6Go to File > Download > Tab Separated Values (.tsv), then rename the file to end in .txt.

Prevent it next time

1. ✓Write prices as text with the code, like 19.99 USD, rather than formatting the cell as Currency.
2. ✓Keep one currency per file, matching the country the feed targets.
3. ✓Use a period (.) as the decimal separator regardless of your computer's regional settings.
4. ✓Put the regular price in price and any discount in sale_price, never the other way round.
5. ✓Run every file through StriveFormats before uploading it to Merchant Center.

How StriveFormats detects this

StriveFormats reads each price value as a number followed by a currency code. A missing code, a comma decimal, a price of 0, or a sale price that isn't lower than the regular price is flagged on its row.