How to format price or number into feed?.

Channels are strict about number formatting. Google, for example, wants a price like 19.99 with a dot for the decimal and no thousands separator; a value such as 1.999,00 in the wrong place can get an item rejected. CTX Feed formats prices on the feed’s attribute rows. This guide shows the free way to do it, the extra controls in CTX Feed Pro, and the settings to use for the common channels.

The free way: the Price output type

Open your feed (CTX Feed → Manage Feeds → the feed’s name) and go to the Config tab — the attribute-mapping table. Every price or numeric field is one row, and each row has an Output column.

Set a price row’s Output to one of these:

• Price — writes the number with 2 decimals, a dot as the decimal separator and no thousands separator: 1999.5 becomes 1999.50.
• Rounded Price — rounds to a whole number first, then writes it the same way: 1999.5 becomes 2000.00.

With Output left on Default, the row writes your WooCommerce price exactly as stored (for example 1999.5).

On the Google Shopping template the price rows already use Price, so in most cases there is nothing to change.

Change decimals and separators (Pro)

This section requires CTX Feed Pro. On the free plugin the Number format row is shown but locked.

To use a different format — for example a comma decimal separator for a European channel — fill in the Number format row on the feed’s Filters tab:

• Decimals — how many digits after the decimal point.
• Thousand separator — for example . or a space. Leave it empty for none.
• Decimal separator — for example ,.

Empty boxes keep the default (2 decimals, a dot and no thousands separator). The boxes apply to every row whose Output is Price or Rounded Price: with Decimals 2, Thousand separator . and Decimal separator ,, 1999.5 becomes 1.999,50.

Round, multiply, add, or format one row (Pro)

Commands require CTX Feed Pro.

For a single row, click the row’s More button (or Show prefix / suffix / command above the table) and click Build in the Command field. The Build output command window has numeric steps:

• Format number — decimals, decimal separator and thousands separator for this row only.
• Round — round to a set number of decimals (a bare Round with no value rounds to a whole number).
• Integer — drop the decimals entirely.
• Multiply — multiply the value by a factor (for example 1.2 to add 20%).
• Add — add a fixed amount to the value.

You can chain steps: for instance Multiply by 1.1, then Format number with 2 decimals and a point separator, to mark a price up 10% and present it cleanly. Steps run in the order you add them, top to bottom. See How to use command to format attribute output.

Adding the currency code or symbol

A price field’s number and its currency label are handled separately. Some channels want a bare number; others (like Google’s price) want 19.99 USD. The currency code is added with the row’s Suffix (free, under More) — the Google template already sets it to your store currency. Keep the number clean and add the label with the Suffix; see the dedicated guide on adding a currency code or symbol.

Recommended settings by channel

• Google Shopping / Meta / Pinterest — 2 decimals, a dot as the decimal separator, no thousands separator, with the currency code as a suffix (19.99 USD). That is exactly what the Price output type writes, so keep it.
• European price-comparison sites — many accept or require a comma decimal separator; check the channel’s spec and set the Number format boxes (Pro) to match.
• Weights and dimensions — set the decimals your channel expects, and add the unit with a Suffix if required.

Troubleshooting

• Formatting did not apply. Click Save & generate — formatting only takes effect on the next generation. Open the feed URL to verify the values.
• The price shows many decimals or none. The row’s Output is on Default, which writes the raw WooCommerce price. Set it to Price.
• Item rejected for price format. Confirm the decimal separator is a dot and there is no thousands separator for Google/Meta, and that the currency code is added via the Suffix, not inside the number.
• Thousands separator ignored in a Format number command. It only takes effect when a decimal separator is also set in the same step.
• Price is off by rounding. Rounded Price, Round and Integer change the value, not just the display. Use Price if you only want to control how it looks.

Related guides

• How to use command to format attribute output
• Add currency code or symbol to price into feed
• How to make a multi-currency product feed
• Price with tax not working — WooCommerce product feed