Inventory in two places: store and website
Photo: Avila Ops Tecnologia
When a physical store and website sell the same product, inventory must be one balance updated by both. Separate counts mean selling online what ran out at the counter at 3 p.m., discovering it at night, and canceling orders. The solution is one inventory record both channels consult and deduct from.
This problem appears in good months. During Valentine’s Day week, florists sell arrangements at the counter and online. Gift shops sell the same mug through both. More sales mean more duplicate-inventory errors, with cancellations arriving on the worst day.
Why two inventories always diverge
It is arithmetic, not carelessness. Every counter sale not deducted online leaves the website thinking it has one more. Every online sale not deducted in-store leaves salespeople promising something already paid for.
With few items and sales, discrepancies are small and someone fixes them each morning. With 30 daily orders, discrepancies happen daily, and morning manual corrections are wrong by 10 a.m.
There is also “reserved” stock: paid online orders not yet picked. They are unavailable but still on the shelf. If the counter does not know, it sells the last unit to a walk-in.
Three ways to solve it
| Method | How it works | Suitable for |
|---|---|---|
| Stock split by channel | Assign ten units to the counter, five online. Each sells only its share. | Few products, plentiful stock, no system |
| Scheduled manual synchronization | Someone updates the website from counter counts twice daily | Up to around ten daily orders, slow-moving products |
| One integrated inventory | Any channel’s sale immediately deducts the same balance and reserves paid orders | Any store with daily turnover in both channels |
The first works but wastes: the site says “sold out” while the counter has eight. The second lasts until the first busy week. The third alone keeps working in June.
What changes with one inventory
Counter sales enter the same system the site consults. The physical checkout is a system screen, not a notebook. When the counter sells, the site sees the new balance within seconds.
A paid online order reserves its unit. The counter sees “3 in stock, 1 reserved” and knows only two are available.
Minimum stock applies to the total, not individual channels. Replenishment alerts consider what the business has, not what the site thinks it has.
One limitation: every physical sale must enter the system immediately. If the counter “records it later,” divergence returns. This changes habits before tools.
What to do now
Count today’s five bestsellers at the counter and online, comparing each system’s balance. Any discrepancy probably already caused a canceled order, even if forgotten. Leave spreadsheets without losing history, with one inventory for store and website: avilaops.com/sistema-para-pequenas-empresas or WhatsApp: wa.me/5517997811471.
Frequently asked questions
How do I integrate physical and online inventory?
Use one inventory system consulted by the store checkout and online store. Sales in either deduct the same balance. If physical checkout is closed with no API, integration may be impossible and replacement appropriate.
What if I sold online something already sold out in-store?
Notify the customer within the first hour with choices: await restocking by a deadline, exchange for a similar item, or receive an immediate full refund. Record the case as a symptom of duplicate inventory.
Is reserving stock only for the website worthwhile?
Temporarily, for high-turnover products during holidays. Instead of risking cancellations, physically separate what the site can sell. It is the first table method: wasteful but avoids cancellations.
Connections, made clear
From order to delivery, with every step in view.
An example of connecting E-Commerce with your team’s day-to-day work.
- OrderThe customer chooses items and places an order.
- ValidationCheck the details and product availability.
- ManagementSend the validated order to ERP.
- FulfillmentThe team prepares and dispatches the items.
- CustomerKeep the customer informed about next steps.
- Order. The customer chooses items and places an order.
- Validation. Check the details and product availability.
- Management. Send the validated order to ERP.
- Fulfillment. The team prepares and dispatches the items.
- Customer. Keep the customer informed about next steps.
Order
The customer chooses items and places an order.
Turn what you learned into your next step.
Tell us about your company and what you want to improve. We can explore the right tools, integrations or custom project together.