1. Help
  2. Data formats

Numbers and decimals

How to tell the service whether "1.234" is one thousand two hundred and thirty-four, or one point two three four.

Data formats define how an ERP’s values are read. They are set per ERP connection, from Connections, “Data formats”.

Do I need to change anything?

No, if prices and quantities arrive right in the shop. Every choice starts at “Automatic”. Change them when you see wrong numbers or the errors invalid_money and invalid_number.

Decimal separator

Dot or comma. In Greece the comma is usual (12,50), but many ERPs answer with a dot (12.50).

Thousands separator

None, dot, comma, space or apostrophe.

The trouble is the combination: 1.234 is “one thousand two hundred and thirty-four” if the dot separates thousands, and “one point two three four” if it separates decimals. If you know your ERP’s format, set it explicitly.

Examples before you save

Under the choices, the page shows how two typical numbers are read with the current choice, or that they cannot be read. You can also take a sample of real rows.

Price decimals and rounding

  • Price decimals: how many decimals the price is written with in the shop.
  • Rounding: usual (0.5 rounds up), banker’s (0.5 rounds to even), always down or always up.
  • Zero price: whether 0 means “no price” for the sale price, for both the sale and the regular price, or is a price like any other.

What happens when you save

The change applies from the next run. The next run of every module reads all items again, so that what was read with the old format is corrected too.

See also: Prices and VAT, Greek text and encoding.