Small lists, kept once for everyone.
Every application keeps its own list of countries, currencies and markets, and each one is a little different. Which one is right? It depends who you ask.
Today
- countries (ERP)
248 - countries (webshop)
251 - markets.xlsx
v12
In refiroo
| Market | Currency | Arabica 1 kg | Green tea |
|---|---|---|---|
| Germany | EUR | ✓ | ✓ |
| Switzerland | CHF | ✓ |
How it goes
- 01Keep each list once
Countries, currencies and markets as record types of your own, with the fields you need.
- 02Relate them
Fill a cell of the relation matrix and the relation is stored once: this product, sold in that market.
- 03Tell the others
Systems read a consumer API of their own, and a change feed and webhooks tell them when something moves.