Skip to content
Digitizing E-commerce Operations· Part 2 of 7

Online Store Inventory: One Stock Number Everywhere

Short answer

Online store stock differs from the shelf because the number lives separately in the store, the shop and the warehouse. Part two of Digitizing E-commerce Operations explains why stores oversell, what SKU, stock sync and reservation mean, how to choose the system that holds the true number, and a 20-item count exercise.

Origami Team

Editorial Team · · 7 min read

Share on WhatsApp
Like what we publish? Pin Origami as a preferred source on Google.Add as a preferred source on Google
Online Store Inventory: One Stock Number Everywhere

Your online store's stock disagrees with the shelf because the number lives in 3 places: the store, the shop and the warehouse, each updated by hand at a different time. The fix is to choose one system that holds the true number and have every other system read from it and report each movement the moment it happens. Start this week by comparing the store's stock with a physical count of 20 items and writing down every difference and its cause. This is part 2 of a 7-part series.

In part one we saw that a common reason an order stops after checkout is selling a product that shows as available but is not there. This part is about the root of that problem.

Why the store sells what you do not have

When that happens, the order waits until someone decides to wait, substitute, or cancel and refund. The gap between store stock and the shelf behind it does not come from one big mistake. It comes from small openings that work every day:

  • Separate counters. The online store has a balance, the point-of-sale system in the shop has another, and the warehouse sheet has a third. When an item sells in the shop, the store does not know, so it sells it again.
  • Manual updates in batches. Someone adjusts quantities in the store dashboard at the end of the day, or whenever they remember. Between updates, the store sells from an old number.
  • Reservations that are never released. When a customer orders, the item is reserved for them. If the order is cancelled or the payment fails and the reservation is not released, the item sits on the shelf but shows as unavailable, and you lose a sale you could have made.
  • Returns that never reach the number. A returned item goes back on the shelf, but nobody adds it to the store balance, or it is added before it has been checked and turns out damaged.
  • Side channels. An order by WhatsApp or phone takes the piece off the shelf without passing through the store, so the store balance stays above reality.
  • One item under more than one code. The same product is recorded under two names, or its sizes and colours were not separated properly, so the balance splits across two cards.

We described the same pattern in factories and warehouses in Why Your Recorded Stock Never Matches the Shelf. The rule is the same: the movement happens at one moment, the recording at another, and the distance between them is the gap.

3 words you need to know

  • SKU (stock keeping unit). A unique number or code for each sellable item. The blue shirt in large has one code; the medium has another. If the code is not the same in the store, the shop and the warehouse, no tool can match them.
  • Stock sync. A change in balance moving from one system to another on its own, without anyone copying it. It usually runs through an API, an interface two systems use to exchange information, or a webhook, an instant notice one system sends another the moment something happens, such as a new sale.
  • Reservation. A temporary deduction from the sellable balance for an order that is not yet complete. It has only 3 endings: it becomes a final deduction at shipping, it is released on cancellation, or it is released when the payment window expires. Any reservation that ends in none of these is lost stock.

Which system holds the true number?

The most important decision in this part is not technical: which system is the reference? When every system owns its own number, there is no true number. The rule is that one system holds the balance, and every other system reads from it and reports every sale or return to it.

  • If the warehouse supplies everything, and the shop and the store sell from the same goods, the reference is usually the inventory system or ERP that records receipts and issues.
  • If the online store is almost your only channel, the store itself may be enough as the reference, provided every order passes through it, WhatsApp orders included.
  • If you have more than one branch, decide whether the store sells from the stock of every location or from the warehouse only, because that changes who fulfils the order in the next part.

Once the reference is chosen, the work is integration: connecting the store to it so the balance drops with every sale in any channel and comes back with every cancellation or checked return. The technical side of this integration with Salla and Zid is covered in Integrating Salla/Zid with Your Internal Systems via API. During sale seasons this connection matters even more, because overselling multiplies with the pressure of orders.

Exercise: measure your own gap in a week

You do not need a new tool. You need a sheet and a physical count:

  • Pick 20 items from your best sellers and highest-value products, including items sold both online and in the shop if you have them.
  • Record the store balance for each item at a set hour, then count the actual quantity on the shelf at the same hour, before anything moves.
  • Write 4 columns per item: store balance, physical count, difference, and the cause of the difference as the team finds it.
  • Classify the causes: a shop sale not passed on, a reservation not released, a return not added, a WhatsApp order, a duplicate code, or unknown.
  • Rank the causes by frequency and start with the most common. An unknown cause is itself information: it means there is a movement nobody records.

We will not tell you what a normal gap is, because it depends on your products and your channels. The number that matters is yours, and then the same number after you close the most frequent cause.

Why this matters to the customer and the law

Every order for an item that is not there ends in a cancellation, a delay or a refund, and those are exactly the situations where a store's obligations are regulated. Today those obligations are set by the E-commerce Law and its Implementing Regulation, published with the store compliance list on the Ministry of Commerce e-commerce page (Arabic). The Ministry announced in its official news release (Arabic) that the Council of Ministers approved the Consumer Protection Law, with 10 chapters and 76 articles, which will replace 3 laws including the E-commerce Law 180 days after its publication in the Official Gazette. We cover cancellations and refunds in detail in part 5. This is not legal advice: confirm your obligations with the Ministry of Commerce or a lawyer.

The Origami view

When we work on an online store's inventory, we start by asking who owns the number before any integration, then we unify item codes across the store, the shop and the warehouse, because connecting systems with different codes only spreads the confusion faster. After that we connect every channel to the reference, and make reservations end on their own at shipping, cancellation or payment expiry.

The team that counts items and answers customers today knows where the numbers leak before any report does, so we build on their knowledge rather than over it. That is what we offer through our services.

In the next part

Once the balance is right, the order still has to travel from the shelf to the customer's door without being retyped. The next part walks through fulfilment and shipping step by step: the pick list, the packing check, the shipping label, and the tracking number that reaches the customer on its own.

Sources

  • #Make the Most of Tech
  • #Digitizing E-commerce Operations: From Order to Delivery
  • #E-commerce
  • #Order Management

Frequently asked questions

Why does a product show in stock online when it is not there?

Because the balance is recorded in more than one place and updated by hand: a shop sale not passed to the store, a WhatsApp order that took the piece, or an item recorded under two codes. Every movement that does not reach the store at once makes it sell from an old number.

What is a SKU and why does it matter?

A unique code for each sellable item, with its own code for every size or colour. If the same code is used in the store, the shop and the warehouse, the systems can exchange balances automatically. If it differs, no sync will work.

Why does a product stay unavailable after an order is cancelled?

Because the reservation made for the order was never released. A reservation should end in one of 3 ways: a final deduction at shipping, a release on cancellation, or a release when the payment window expires. When that does not happen automatically, the stock stays stuck.

Which system should hold the true stock number?

One system only, with the others reading from it. If the warehouse supplies the store and the shop, the reference is usually the inventory system or ERP. If the store is almost your only channel, it can be the reference, provided every order passes through it.

Fahim: a Saudi ERP run from WhatsApp

An AI-powered ERP built for the Saudi market and e-invoicing. Ask for a change in a message and the system builds it.

Discover Fahim

Newsletter

New articles and series, in your inbox.

Follow Origami in Google

Pin Origami as a preferred source and our articles will surface first for you in Google Search and Top Stories.

Add as a preferred source on Google