1 · Import products
Required columns: sku, name. Optional: stock, lead time days, safety days, safety qty, supplier, unit cost, active. Existing SKUs are updated — safe to re-import. A dry run runs first; nothing is written until you confirm.
Example:
sku,name,stock,lead time days,safety days,supplier,unit cost WID-001,Blue Widget,140,14,7,Acme Supply,4.25 GAD-770,Gadget Pro,8,21,10,Eastport Trading,18.00
2 · Import sales history
Required columns: date, sku, qty (dates as YYYY-MM-DD). Rows are totaled per SKU per date, and a date already imported for a SKU is replaced, not added to — importing an overlapping export twice counts it once. Unknown SKUs are skipped with a reason. A quantity of 0 clears that day. Importing sales does not change stock levels unless you switch on stock follows sales in Settings. A dry run runs first; nothing is written until you confirm.
Example:
date,sku,qty 2026-06-01,WID-001,4 2026-06-01,GAD-770,1 2026-06-02,WID-001,6
On file
Limits & safety
Sales imports append. For a clean re-import, clear history first.