Every system has its own code. They all mean the same thing.
The ERP calls it 100245, the webshop cof-arabica-1kg and the warehouse WH-CF-01. Today one spreadsheet holds them together, until somebody sorts a single column.
Today
- codes_FINAL_v7.xlsx
3 tabs - webshop export (from Tom)
stale - warehouse list
?
In refiroo
| Product | ERP | Webshop | Warehouse |
|---|---|---|---|
| Arabica 1 kg | 100245 | cof-arabica-1kg | WH-CF-01 |
| Green tea | 100310 | tea-green | missing |
How it goes
- 01Bring the file you have
Drop in the workbook. refiroo reads every row and proposes the model, and you edit it before anything goes live.
- 02Line the codes up
One column per system in the mapping grid. A missing code shows, so you know what to chase.
- 03Let systems ask
Give one code to the API and get the others back: a lookup, a batch, or a whole crosswalk.