Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

I cannot keep stock right across several shops or warehouses

Short answer

Multi-location stock goes wrong when each location keeps its own count and transfers are not recorded as a pair: out of one place, into another. Sync delays and online orders that do not name a location add to it. Treat each location as a separate count, record transfers as one movement, and decide which system is the truth.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • A product shows in stock online but the shop I would ship from has none.
  • Stock sent from the warehouse to a shop never shows up in the shop's figures.
  • The total across all locations is right but no single location is.
  • Each shop manager keeps their own spreadsheet.
  • Orders ship from the wrong location.

Why does this happen?

  1. Transfers are recorded on one side only

    A transfer must reduce stock in one place and add it in another. If staff record only the sending side, or the receiving side late, the goods vanish in between. Square's inventory interface treats a move between locations as one adjustment with a from-location and a to-location, which keeps both sides together.

  2. Each location holds its own copy of the count

    When every shop or warehouse runs a separate tool or file, the numbers are combined only when someone merges them. The combined figure is old the moment it is made.

  3. Online orders do not say where they ship from

    If the web shop reduces a single total, no individual location is reduced, and the location that actually packed the order keeps showing stock it no longer has.

  4. Sync arrives late or out of order

    Updates sent between systems can be delayed, repeated or delivered in a different order. Square states that its webhook notifications can arrive more than once and that notifications can arrive in a different order than the events happened.

  5. Locations differ in units and product codes

    One warehouse counts cartons, a shop counts pieces, and a product has a different code in each. Matching them depends on a table that nobody maintains.

What can I do about it today?

  1. Write down your locations and who counts eachA simple list of every shop, warehouse and storage room, with the person responsible for its numbers.
  2. Record transfers on a paper or sheet slip with both placesUntil the system does it, write each transfer once: product, quantity, from, to, date, and have the receiving side confirm.
  3. Choose where online orders ship fromDecide a rule, such as one warehouse first, so stock is reduced in a known place.
  4. Count the same five products everywhereCount them on one day at every location and compare to the system.
  5. Do not merge locations into one to simplifyCombining them hides which place lost the stock and breaks later reports.

When should I bring someone in?

  • Customers are being sold items that no location has.
  • You are adding a new shop or warehouse and the old method will not scale.
  • Stock is held in more than one system that has to agree.

How do I handle it?

  1. Map the locations and the flowsI draw where stock comes in, where it moves and where it leaves, and which system touches each step.
  2. Give each location its own countStock is tracked per product per location, with a transfer as a single movement between two places.
  3. Choose the source of truthOne system owns the numbers. Others read from it or send movements to it, never a total.
  4. Handle repeated and late messagesEach movement carries an identifier so a repeated message is ignored and a late one does not overwrite a newer figure.
  5. Verify with a cross-location countThe sum and each location are compared with a physical count, and the mismatch list is reviewed.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Do I need one system for all locations?

It helps a lot, because one place holds the movements. If not, one system must be chosen as the truth and the others must send movements, not totals.

Why does the total look right but not each shop?

Errors cancel out in the total. A transfer recorded on one side only leaves one shop too high and another too low.

Can a sync fix this alone?

A sync moves wrong numbers around faster. The movements have to be recorded correctly first.

Is a spreadsheet enough for two shops?

It can be, with strict rules for transfers. It breaks down when online orders and more locations arrive.

Sources

How was this page made?

I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.

For your developer: the technical fixes

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.