Why your webshop and accounting do not show the same stock

Monday morning, 09:12. A customer calls. She ordered a garden set on Friday evening, paid for it and already put her old chairs out with the bulky waste. But the message she just received says: out of stock. You check Exact Online: zero units. In your webshop it still showed three.

Voorraad synchronisatie probleem webshop en boekhouding

"Sorry, this product turned out to be unavailable"

Monday morning, 09:12. A customer calls. She ordered a garden set on Friday evening, paid for it, and already put her old chairs out with the bulk waste. But the message she just received says: out of stock. You check Exact Online: zero units. Your webshop still showed three. Those three had already been sold on Friday afternoon through Bol.com, but you hadn't processed that change yet.

Now you have an angry customer, a refund, and a 1-star review that hurts your reputation. Not because your product is bad. But because two systems told a different story about your stock.

This is what overselling does. And it happens more often than you think.

How stock discrepancies arise

Stock synchronization problems rarely come out of nowhere. They have three recognizable causes and these reinforce each other.

Time delay between systems

Your webshop and your accounting live in separate worlds. A sale in WooCommerce only becomes visible in Exact Online once someone enters it manually. Or when an import runs, sometimes just once a day, sometimes even only once a week.

In the meantime your webshop keeps selling based on outdated numbers. The same item can be shown as "in stock" through Shopify, Bol.com and Amazon at the same time while there are only two units left in your warehouse. Three orders later you have disappointed three customers.

Manual entry

Every time someone types in a stock change manually, a receipt, a correction, a transfer between warehouses, there is a chance of errors. Automated systems reach an accuracy of 99.96% to 99.99%. With manual entry the error rate lies between 1% and 5%, according to research by DocuClipper.

That sounds small. But with a range of 500 items with regular changes you are quickly talking about dozens of stock errors per month. Errors that only stand out when a customer orders something that isn't there.

Returns as a blind spot

Returns are the silent saboteur of your stock management. A customer sends a product back. The package arrives, is checked, and has to be put back into stock in your warehouse, in Exact Online, and in all your sales channels.

In practice this takes time. Sometimes hours, sometimes days. The item is not for sale while it is actually available, which means you miss out on revenue. Or worse: the return is processed in one system but not in the other, causing the numbers to drift apart.

What overselling really costs you

The consequences of stock discrepancies go beyond a cancelled order. Worldwide, stockouts and overselling cost businesses $1 trillion per year, calculated Strabo Partners. That is an astronomical figure, but even on the scale of a single webshop it adds up.

Direct costs per incident

Every oversell costs you €6 to €10 in direct costs. Think of the time for customer service, processing the refund, the transaction fees you don't get back, and any shipping costs for a replacement product.

At five oversells per week, which is not unusual for a webshop with multiple sales channels, you lose €120 to €200 per month. Purely on damage control.

Cancellations and refunds

75% of customers who are told that an ordered product is not available after all cancel the order and ask for a refund. They don't order an alternative. They leave.

That is revenue you already had. That was in your reports. That you now get to reverse, including all the administrative hassle that comes with it.

Customers who don't come back

This is the hidden damage. After an oversell experience about 15% of customers no longer make a repeat purchase. They simply don't come back. No complaint, no review, they quietly disappear from your customer base.

With an average customer value of €150 per year and ten oversell incidents per month you potentially lose €2,700 in annual repeat revenue. Every month the problem continues, that amount grows.

Multiple channels, greater chaos

Do you sell only through your own webshop? Then the problem is manageable. Do you also sell through Bol.com, Amazon or a physical store? Then the risks multiply.

Each channel has its own stock registration. A sale on Bol.com must not only be processed in Exact Online, but also adjust the stock in your Shopify shop. And in your Amazon listing. And the other way around.

Without central stock synchronization it is a matter of time. Not whether something goes wrong, but when and how often.

The solution lies in the frequency

The core problem is not that your systems are wrong. The problem is that they don't talk to each other quickly enough.

A daily export does not solve stock synchronization problems. Even an export per hour is insufficient during busy sales periods. What you need is a connector that synchronizes every five minutes, in both directions.

Sale in your webshop? Stock in Exact Online is automatically reduced. Goods receipt booked in Exact Online? Your webshop shows the correct numbers within minutes. Return processed? All channels are updated.

That is the difference between 1-5% errors with manual entry and the 99.96%+ accuracy of automated synchronization. Not a bit better, but a completely different order of magnitude.

What this means for your webshop

Stock discrepancies are not an administrative inconvenience. They cost you customers, revenue and reputation. And the problem grows larger as you grow faster and process more orders, through more channels, with far more moments at which stock discrepancies can occur. With all the consequences that entails.

The technology to solve this exists. A connector between your webshop and Exact Online that continuously synchronizes stock, orders and items. No manual typing, no outdated numbers, no angry customers on Monday morning.

The difference between a webshop that considers oversells "part of the deal" and a webshop that structurally prevents them? Five minutes. That is how long a synchronization cycle takes. That is how little is needed to eliminate the problem.

Do you want to prevent stock discrepancies? View our webshop connectors →