How to Sync Your Physical Store Stock with Your Website So You Never Sell What You No Longer Have

It is one of the most frustrating situations for a business that sells both in a physical shop and online: someone orders a product on your site that you sold over the counter ten minutes ago. The customer waits, you call to apologize, and the trust is gone. It is not because you are careless. It is because the shelf and the website speak two different languages.

The good news: you do not need an expensive system to fix this. You need a clear rule about where the "real" stock lives, and a simple way to keep it synced. In this article I will show you concretely how syncing works, what options you have depending on the size of your business, and what to avoid so you never again sell what you no longer have.

Pick a single source of truth for stock

The first mistake almost everyone makes is keeping stock in two places at once: one in their head or a notebook at the shop, another in the website admin. When you have two lists, they contradict each other constantly.

The fix is to decide that the "real" stock lives in one place, and everything else lines up behind it. In practice you have two options:

• The till / POS in the shop is the main source, and the website pulls its numbers from there.
• An inventory system (an ERP or accounting-inventory tool) is the hub, and both the shop and the website connect to it.

The golden rule: every product has a unique code (SKU or barcode) that is identical everywhere. Without a shared code, no system can automatically match the item on the shelf to the one on the site.

Real-time vs. periodic syncing: which fits you

Not everyone needs syncing to the second. Choose based on how fast your stock moves.

• Real-time (automatic): every sale, in-store or online, instantly reduces stock in the other channel. Ideal if you sell unique products or low-stock items where a single unit matters. It requires the POS and the website to be connected through an integration or a shared inventory system.
• Periodic (scheduled): stock updates every hour or a few times a day through an automated export-import. Enough for shops with larger stock per product, where a small delay will not cause overselling.

Do not jump straight to real-time if you do not need it. It is more expensive and more fragile. For many small retailers, syncing a few times a day plus a buffer solves nearly every problem.

Use a buffer and rules for the last units

Even with good syncing, there is a window of a few seconds where two sales can land at the same time. That is why experienced retailers keep a small safety net.

• Stock buffer: set the site to show "out of stock" one or two units before it actually runs out. That way the last unit on the shelf stays for the in-store customer who is already standing there with cash in hand.
• Alert threshold: when a product drops below a set number, you get a notification to restock or check.
• Products you do not sell online: mark them clearly as "in-store only" so they never appear as available to order.

The buffer costs you a few missed online sales, but it saves you from orders you cannot fulfill, which is far more expensive in reputation.

What to do when a product genuinely runs out

Syncing prevents overselling, but products will still sell out. What matters enormously is how the site looks at that moment.

• Do not hide the product page. Leave it visible, marked "out of stock," because people still search for it and find it on Google.
• Offer an alternative: a "notify me when it is back" button, similar products shown nearby, or the option to order with an estimated delivery date if you can restock.
• Be honest about the timeline. Better to say "back in about a week" than to let the customer think it is available right now.

A sold-out product handled well is not a lost sale; it is an email address gained or a sale postponed. A sold-out product that is hidden is simply a lost sale.

How we approach this at MPO

When we build an online store for a client who also has a physical presence, the first question is not about design. It is: where does your real stock live today? We start from there.

For most shops in Romania we go with an inventory system that connects to both the till and the website, so you never keep two lists. We link the barcodes, set a buffer and an alert threshold, and decide whether you need real-time syncing or a few times a day, depending on how fast stock moves for you.

We work remotely across the whole country, with a demo prepared in advance so you see exactly how it looks before you pay, and with transparent pricing and no surprise costs. If you want to look together at how this would work for your shop, message us on WhatsApp and we will give you a concrete answer.