RENO TECHS

Why your POS and online store show different inventory

Trace one product through an in-store sale, an online order, and a return to find where your inventory counts get out of sync.

A customer orders the last bottle on your website, but someone already bought it at the register. Before changing software or correcting counts by hand, follow one product through both systems. Check which system recorded the sale, when the other system received it, and how each decided what was still available to sell.

Check what each system is counting

Start with one product variant, such as the 50 mL bottle of a moisturizer. Compare its SKU, the code you use to identify that item, in your point-of-sale system (POS) and online store. Check that both records refer to the same size, color, or pack quantity and to the location that fulfills online orders. A matching product name can hide a mismatched variant or location.

Then compare the same type of count. On hand is how many units you physically have. Available to sell is how many you can promise to a new customer. If five units are on the shelf and two are committed to unfulfilled orders, three may be available to sell.

Trace one item from sale to return

Use a test environment if you have one. Start with two available units of the same variant at one location. Note the starting count in the POS, the online store’s admin, and what a shopper can see.

  1. Ring up one unit in store. Available stock should fall to one. Record how long it takes the online count to change.
  2. Place a test order online for the remaining unit. After the store reserves the order, the shared available count should reach zero. If the product page still shows availability, check whether checkout also allows another order.
  3. Return one unit and mark it sellable. Available stock should return to one once the restock reaches both channels. If refunds and restocking are separate steps, check when each happens.

Write down the first place the expected count and the actual count diverge. If both systems see the sale and only one sees the return, you’ve narrowed the problem to the return workflow. If updates consistently take several minutes, compare that delay with how often you sell the last unit.

Decide which system owns the stock count

Identify which system should have the final say when counts disagree. It could be your POS, your online store, or a dedicated inventory system. Document where staff should adjust stock manually and which events should change the count. This gives you a place to look when a count is overwritten or a sale is counted twice.

How one retailer connected its channels

At Prude & Boujee, staff updated product information in several places, and in-store sales could leave the online listing showing stock that had already sold. Reno Techs built a centralized operations platform so staff could manage product information in one place and in-store and online purchases could draw from the same stock count.

Read the Prude & Boujee case study

If your one-item test exposes a gap you keep fixing by hand, bring the SKU and the step that failed to a conversation with Reno Techs.