Business basics · Retail

How a shop keeps store and online stock as one count

A shop that also sells online has one pile of goods and two ways to sell it. The case below keeps both channels on the same count, including a return that is not sellable until someone accepts it.

By OdooMatrix Published 2 min read

Part of a complete guide

This task is one section of Small business workflows for 20 industries, with 19 related tasks on one page.

1. What to record

Record the shared quantity, each shop sale, each website order, and a return only after inspection.

This is a stock and order record. It does not set prices, tax, or a delivery promise.

2. People and records

On small screens, scroll the table sideways to see every column.

Retail stock records
RecordWho uses itWhat to keep
Shared quantityShop leadItem, on-hand count, and the location that owns it.
Shop saleCashierItem, quantity, and the receipt that reduced the count.
Website orderOnline leadOrder number, quantity reserved, and whether it has shipped.
ReturnReceiverOrder it came from, condition, and whether it is back on the shelf.

3. One complete cycle

  1. Start with 10 units of one item available to both the shop and the website.
  2. Sell 2 in the shop. The shared count is 8.
  3. Take a website order for 3 and ship it. The shared count is 5.
  4. Receive 1 returned unit and leave it off the shelf until someone accepts the condition.

Expected: Sellable stock is 5 while the return waits. After acceptance it is 6. The shop receipt and the website order both point at the same item.

4. Check before you add tools

At the end of the day, add shop sales and shipped website orders and subtract them from the morning count. A difference needs a name the same day.

Do not treat an unopened return box as available. The website can sell it twice if the count moves before inspection.

5. Frequently asked questions

Can the website reserve an item the shop might sell?

Yes. A reservation holds that quantity until the order ships or the reservation ends. The cashier should see the held quantity before selling the last unit.

When does a return increase the count?

When someone accepts the item back onto the shelf. A parcel on the dock is not sellable stock.

Do the shop and the website need two item records?

No. Use one item. Two records hide which channel sold the last unit.

6. Related articles and next steps

Scope

Sample amounts and names in this guide are illustrative. They are not a client result, a price, or legal advice.

Continue learning

Put this workflow into practice.

Get free business templates or discuss a system for your workflow.

← Back to all articles