Free catalogue check

Demo

Sync simulator

Every night a supplier sends a file and the shop's prices and stock follow it. Pick tonight's file, set the rules, and see what goes live, what waits for a person and what stops the run, with and without guards. Products, files and rules are illustrative.

Tonight's supplier file
Price and stock rules
45%

On the price before VAT: cost ÷ (1 − margin).

VAT in the shelf price

Price ending

2 units

Held back from the supplier's stock, so the last units aren't sold twice.

Guards
15%

Bigger changes wait for a person: a typo, a wrong currency, a rule changed by mistake.

25%

Of the shop's products. A file that suddenly lacks many products is usually broken, not a clearance.

Tonight's run, 02:00

9 updates applied, 1 item waits for review

Everything within the rules went live; the rest waits for a person, with the reason in the alert.

Without guards, the same file would have published 1 price change over the 15% limit.

The alert the shop team gets

From
Sync monitor
Subject
Tonight's sync: 1 item to review
  • NL-BN-GR: the price would go from €24.90 to €244.90. Approve or correct it.
Tonight's file · supplier-stock.csv · 12 rows
Ref;EAN;Cost;Stock
88231-S;9521234123453;69.10;11
88231-M;9521234123460;69.10;9
88231-L;9521234123477;69.10;2
77410-S;9521234123484;31.90;22
77410-M;9521234123491;31.90;0
66102-M;9521234123507;41.00;7
51220;9521234123514;112.00;28
51318-M;9521234123521;9.80;18
50944-42;9521234123538;8.40;36
93028;;47.40;8
41200;9521234123545;21.00;12
40750;9521234123552;13.50;19

What the run does, product by product

The shop's current price and stock on the left of each arrow, tonight's on the right.

ProductPriceStockResult
NL-TJ-STrail Jacket · SUpdated€139.90 → €150.9012 → 9Updated
NL-TJ-MTrail Jacket · MUpdated€139.90 → €150.907Updated
NL-TJ-LTrail Jacket · LUpdated€139.90 → €150.903 → 0Updated
NL-FM-SFleece Mid Layer · SUpdated€64.90 → €69.9020Updated
NL-FM-MFleece Mid Layer · MUpdated€64.90 → €69.901 → 0Updated
NL-RT-MRain Trousers · MUpdated€83.90 → €89.905Updated
NL-BN-GRMerino BeanieHeld: the file asks for €244.90 (+883.5%)€24.9029 → 26Held: the file asks for €244.90 (+883.5%)
NL-GL-MLiner Gloves · MNo change€21.9016No change
NL-SK-42Hiking Socks · 39–42Updated€18.9038 → 34Updated
NL-BP-28Daypack 28 LUpdated€100.90 → €103.904 → 6Updated
NL-HL-200Head Torch 200 lmNo change€45.9010No change
NL-BT-750Steel Bottle 750 mlUpdated€29.9023 → 17Updated

Run log

  1. 02:00:01 Fetched tonight's supplier file: 12 rows, 4 columns.
  2. 02:00:01 Columns found: Ref, EAN, Cost and Stock.
  3. 02:00:02 Matched 11 products by barcode and 1 by the supplier's reference.
  4. 02:00:02 Held NL-BN-GR: the price would go from €24.90 to €244.90 (+883.5%), over the 15% limit.
  5. 02:00:03 Applied 9 updates: 7 prices, 6 stock levels.
  6. 02:00:03 Report sent: 1 item waits for review.

What it shows

What a sync needs beyond copying numbers

  • Matching that survives real files: by barcode, and by the supplier's own reference where a product has none.
  • Prices from rules you can read: margin, VAT, the shop's price ending, a safety buffer on stock.
  • Guards that hold back what shouldn't go live: a price typo, a file cut off halfway, a renamed column.
  • A log and an alert in plain words, so someone knows by morning what happened and what needs them.
  • The same file run without guards, to show what a plain sync would have done.

The demo runs one supplier and twelve products. A real sync works the same way on thousands of rows, several suppliers and your own rules, with the Monitor plan watching it every night. The free check starts with where your current sync or spreadsheet loses time or sales.

Get a free check of your catalogueAll demos →