One stock count for the shop, the web store and the shopping centre report
Shops lose sales when the till and the web store disagree about stock. I sync them, automate the monthly sales report many shopping centres ask tenants for, and add loyalty with proper consent. Integrations from €1,900.
Try the shelf: sell in the shop and online, then switch sync off and run the same Saturday again. Six sample products, made-up counts.
Synced: shelf, till and web store show the same number. Sell something, or run a Saturday.
- Webhooks listening on till and web store.
What gets synced, and which way
Every field has one master system. Two masters for the same field is how prices and stock drift apart. This is the typical starting design; yours is agreed in discovery.
| Data | Direction | When | Watch out for |
|---|---|---|---|
| Stock levels | till <-> web | On every sale, through webhooks; polling every few minutes where the till offers none | Bundles and variants: one sold set may use stock from three products. |
| Prices | master -> other | When changed, with a log entry | Shelf-edge labels: a web price change should not silently differ from the shelf. |
| New products | master -> other | On creation, by EAN or SKU | Missing barcodes. Products without an EAN or SKU cannot be matched safely. |
| Web orders | web -> till | On payment, so the till's daily sales include them | VAT per rate must match on both sides for the accountant. |
| Returns | either -> stock | After inspection, not on the refund click | A damaged return should not reappear as sellable stock. |
Tenant sales report builder
Many shopping-centre leases ask tenants for regular sales figures. Pick the period, the VAT basis and the format, and see the report the system would send on its own. Sample data from a made-up shop.
Semicolon-separated with decimal commas, so it opens cleanly in Finnish Excel.
check your lease The required period, basis, fields and channel are set by your lease and the centre's reporting portal, not by me.
| Week | Receipts | Sales excl. VAT | VAT 25.5 % | VAT 13.5 % | Returns |
|---|---|---|---|---|---|
| 1 Sep to 6 Sep | 223 | 4,224.72 | 936.15 | 74.73 | 77.40 |
| 7 Sep to 13 Sep | 227 | 4,317.75 | 956.76 | 76.37 | 129.00 |
| 14 Sep to 20 Sep | 237 | 4,493.78 | 995.77 | 79.49 | 103.20 |
| 21 Sep to 27 Sep | 223 | 4,221.58 | 935.45 | 74.67 | 167.70 |
| 28 Sep to 30 Sep | 76 | 1,445.26 | 320.25 | 25.56 | 64.50 |
| Total | 986 | 18,703.09 | 4,144.39 | 330.83 | 541.80 |
unit;period_start;period_end;receipts;sales_excl_vat;vat_25_5;vat_13_5;returns UNIT-012;2026-09-01;2026-09-06;223;4224,72;936,15;74,73;77,40 UNIT-012;2026-09-07;2026-09-13;227;4317,75;956,76;76,37;129,00 UNIT-012;2026-09-14;2026-09-20;237;4493,78;995,77;79,49;103,20 UNIT-012;2026-09-21;2026-09-27;223;4221,58;935,45;74,67;167,70 UNIT-012;2026-09-28;2026-09-30;76;1445,26;320,25;25,56;64,50
Loyalty, with consent you can show
A loyalty register is a personal-data register: it needs a privacy notice, only the data you use, and a way for members to see or delete theirs. Marketing by email or SMS needs prior, active consent. The exception is your own customers buying similar products, provided opt-out is offered when you collect the address and in every message.
Rules summarised from Finnish guidance at the time of writing. Check your own obligations with your privacy adviser.
SAMPLE SIGN-UP AT THE TILL
Join the stamp card
Stamps are collected and the reward text is a service message. No offers are sent.
Tell me your till, your web store and what the centre asks for. Fixed price tomorrow.
Get a retail systems quoteWhat it costs
Proposed prices in euros, excluding VAT 25.5 %. Start with paid discovery from €490, credited to the project, when the till's API is unknown.
Tenant report
The centre's report built and sent from till data.
- Your lease's period and VAT basis
- CSV, API or email delivery
- Copy archived for your accountant
Stock sync
Till and web store agree on every product.
- Shopify, WooCommerce or your web store
- One master per field, logged changes
- Alerts when a sync fails
- Web orders into the till's daily sales
Loyalty add-on
Stamp card or points, tied to your own website.
- Consent stored with wording and date
- Opt-out in every message
- Member data export and deletion
Extra work €95 an hour. Maintenance €79, €199 or €449 a month with 1, 3 or 8 hours included. If the sync does not agree with a manual stock count during the trial week, it does not go live and you do not pay the balance. owner to confirm
When I would not build this
Custom code is a running cost. Sometimes the cheaper answer is already in your till's settings.
- 01Your POS already offers a maintained connector for your web store. Switch it on; I can check its settings for an hour instead.
- 02You sell a handful of products online a week. A daily manual update costs less than any integration.
- 03Your till has no API and no reliable export. Moving to a till that has one is often cheaper than working around it.
From stock count to automatic report
- 1
Match products
EAN or SKU for every product on both sides; gaps listed before any code.
- 2
Pick masters
One system owns stock, one owns prices, written down and agreed.
- 3
Trial week
Sync runs while you count a few products by hand. The numbers must agree.
- 4
Automate the report
First centre report checked with you, then sent on schedule.
Questions about retail systems
Can you sync my till with Shopify or WooCommerce?
Usually, yes, if the till offers an API or a reliable export. Shopify and WooCommerce both have APIs for stock, orders and products. I make one system the master for each field, sync stock on every sale where the till allows it, and log every change. Check API access with your POS vendor first.
What do shopping centres need from tenants?
Many shopping-centre leases ask tenants to report sales regularly, often monthly, sometimes excluding VAT or split by period, through a file or a portal. The details differ per centre, so check your own lease. I automate the report from your till data in the required format so it goes out on time without retyping.
Is a loyalty programme worth it for one shop?
Sometimes. It pays when customers return often and you will actually use the data, for example to send offers to people who agreed to receive them. Marketing messages need prior consent, with an exception for your own customers buying similar products if opt-out is offered. A stamp card in the till may be enough.
Get a retail systems quote
Your till, your web store, roughly how many products, and what your shopping centre asks for. You get a written fixed price within one working day.
Pikselipolku is an independent studio and is not affiliated with Shopify, WooCommerce, SumUp, Zettle, Lightspeed or any other product named here.
Or email hei@pikselipolku.fi