Development guides

When store, warehouse and online inventory disagree

An item can be in stock but unavailable to sell. Separate physical, reserved and incoming stock before connecting the systems.

ProApp editorialPublished and checked
Products, parcels and a barcode scanner on a dispatch bench
AI-generated illustration of the article’s setting.

The workflow illustrates a possible design and is not a client case study.

Illustrative workflow
  1. Map SKUs
  2. Sync changes
  3. Resolve differences

A mismatch may mean more than slow sync

The store shows stock, yet the warehouse cannot ship the order. Before blaming slow updates, check the product codes and what each system counts as available. Incoming goods or unchecked returns may have been added too soon. If the systems keep overwriting each other’s totals, the original mistake becomes harder to trace.

Will native Shopify inventory be enough?

Shopify supports inventory across locations. Try its standard settings and existing warehouse connectors first. If the warehouse uses different reservation or return rules, check which records the connector updates, in which direction, and how a failed update is recovered.

Start with one warehouse and map its SKUs

Try one warehouse and a small product range. Map the SKUs, then decide which system controls each quantity. When an update fails, staff need the reason and the time of the last successful sync. Manual corrections also need a record and an agreed way to handle them on the next sync.

Can you trace each stock adjustment?

Test simultaneous sales as well as partial shipments, cancellations and exchanges. Include negative stock and repeated notifications. Check each SKU at each location, tracing changes back to the order or adjustment. Then confirm that a missed update can be recovered.

Bring an example of mismatched stock

Bring the SKU mapping, warehouse API details, return procedures and a day’s examples of mismatched stock. Set the update frequency to suit daily operations and the API limits.

Working through a similar problem?

Tell us how you work today, which tools you use and what you want to improve. We can discuss changes to your current system, connecting tools or developing something new.