In this short guide, I will tell you how to use Spreadshirt's shop, country and currency data to format your prices correctly.
Formatting Rules
For formatting a price we need the following data:
- thousands separator - . or , depending on the country
- decimal point - , or . depending on the country
- currency symbol - € or other depending on the currency
- price pattern - currency symbol before or after price depending on the currency
- decimal count - 1 or 2 decimal counts depending on the currency
Where do we get this data from? A shop, such as shop 205909, is actually configured for a specific country and currency. A sample payload is illustrated below:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <shop xmlns:xlink="http://www.w3.org/1999/xlink" xmlns="http://api.spreadshirt.net" xlink:href="http://api.spreadshirt.net/api/v1/shops/205909" id="205909"> <user xlink:href="http://api.spreadshirt.net/api/v1/users/40000" id="40000"/> <country xlink:href="http://api.spreadshirt.net/api/v1/countries/1" id="1"/> <language xlink:href="http://api.spreadshirt.net/api/v1/languages/1" id="1"/> <currency xlink:href="http://api.spreadshirt.net/api/v1/currencies/1" id="1"/> ... </shop>
The currency, such as currency 1 defines the currency symbol, the price pattern and the decimal count.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <currency xmlns:xlink="http://www.w3.org/1999/xlink" xmlns="http://api.spreadshirt.net" xlink:href="http://api.spreadshirt.net/api/v1/currencies/1" id="1"> <plain>EUR</plain> <isoCode>EUR</isoCode> <symbol>€</symbol> <decimalCount>2</decimalCount> <pattern>% $</pattern> </currency>
The country, such as country 1 defines the thousands separator and the decimal point.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <country xmlns:xlink="http://www.w3.org/1999/xlink" xmlns="http://api.spreadshirt.net" xlink:href="http://api.spreadshirt.net/api/v1/countries/1" id="1"> <isoCode>DE</isoCode> <thousandsSeparator>.</thousandsSeparator> <decimalPoint>,</decimalPoint> <length> <unit>cm</unit> <unitFactor>1.0</unitFactor> </length> <currency xlink:href="http://api.spreadshirt.net/api/v1/currencies/1" id="1"/> </country>