How to Sync Inventory Across Instagram, Your Website and Your Shop Counter

To keep inventory in sync across Instagram, your website and your shop counter, choose one system as the single source of truth for stock, give every product variant its own SKU, and make every sale in every channel reduce that one number at the moment it happens. Everything else, like your Instagram posts, your website, your catalog and your counter, should read stock from that source, never keep its own count. Most overselling comes from stock being counted in more than one place.

This guide shows how to set that up, from a spreadsheet for very small shops to a fully connected system, and how to handle the hard parts: orders that arrive in DMs, returns, and more than one location.

Why stock goes out of sync

If you've ever sold the last item twice, one of these is usually the cause:

• Each channel keeps its own number. The website thinks you have 5, the counter thinks 3, and your Instagram posts say "available" because nobody updated them.

• Updates happen later. Counter sales get typed in at closing time; the website sold two in the meantime.

• DM orders aren't counted until they're paid. A customer says "yes, I'll take it", someone else buys it at the counter, and the DM customer pays for something that's gone.

• Variants aren't tracked separately. You know you have "12 of the blue shirt" but not that all of them are size L.

• Returns, damages and samples go unrecorded. The count drifts a little every week until it's badly wrong.

• Two branches share stock informally. "Just call the other shop" works until both shops sell the same item.

None of these are fixed by working harder. They're fixed by deciding where the true number lives and when it changes.

Principle: one source of truth

Pick one place that holds the real stock number. It might be a spreadsheet, your POS, your website platform or an all-in-one commerce system. Then follow two rules without exception:

1. Every sale, return and adjustment updates the source of truth, whichever channel it happened in.

2. Every channel takes its stock number from the source of truth, never from its own records.

The rest of this guide is about making those two rules practical.

Step 1: Give every variant a SKU

A SKU (stock keeping unit) is a unique code for one specific item you can count. Not "blue shirt", but "blue shirt, size M". Without SKUs, you can't sync anything, because different channels can't agree on what they're talking about.

A simple, readable SKU format:

[Category]-[Product number]-[Colour]-[Size]
TS-014-BLU-M
TS-014-BLU-L
DRS-021-BLK-S

Tips:

• Keep SKUs short, uppercase and without spaces.

• Never reuse a SKU for a different product, even after the old one is discontinued.

• Use the same SKU everywhere: on the price tag, in your POS, on your website, in your catalog, and in the product code you put in Instagram captions.

• If you sell bundles ("2 for 30"), track the individual SKUs inside the bundle, not the bundle as stock.

Step 2: Do one full count

You can't sync from a wrong starting point. Pick a quiet time, count every SKU in every location, and enter the numbers into your source of truth. Record the date. From then on, every change is logged against this starting count.

Step 3: Choose how channels stay in sync

There are four ways to keep channels in step, from simplest to most automatic. Most shops move up this list as they grow.

A useful test: how many minutes pass between a sale at the counter and that item showing as unavailable on your website? With method 1 it's whenever you remember; with 2 it's hours; with 3 it's usually minutes; with 4 it's immediate.

Step 4: Decide exactly when stock changes

Syncing goes wrong in the grey areas: is the item "sold" when the customer asks, when they confirm, when they pay or when it ships? Write down a rule for each event and apply it the same way in every channel:

The key idea is reservation: an item that's promised to someone is no longer available to anyone else, even before it's paid.

Step 5: Handle orders that arrive in chats

Instagram DMs and WhatsApp are where most sync problems start for social sellers, because the "order" is a conversation, not a transaction.

• Reserve stock when the buyer confirms the order summary, not when they first ask. (Our guides on Instagram DM orders and WhatsApp order management show the summary message to use.)

• Set a reservation deadline, for example 24 hours to pay, and tell the buyer: "I'm holding it for you until [time]." When it passes, release the stock.

• Check stock before saying "available". If you reply from memory, you'll eventually promise something that's gone. Look it up, or use a tool that answers from the real count.

• Mark sold-out sizes on the post or in the caption so buyers stop asking for them.

Instagram itself doesn't keep a stock count for posts. What you show there comes from your Meta catalog (if you tag products) and from what you write in captions. Make sure both reflect your source of truth.

Step 6: Keep a small buffer on slow-updating channels

If a channel only updates every few hours (method 2), it will sometimes show stock you've already sold. A simple fix is a buffer: publish slightly less than you really have to that channel.

Stock shown on slow channel = real stock − buffer
Buffer ≈ how many of that item you usually sell between updates

So if you usually sell 2 of a size between catalog updates, show 3 when you have 5. When the shown number hits 0, you still have 2 for the counter or fast channels. Remove the buffer once all channels update immediately.

Step 7: Make the counter part of the system

The shop counter is where syncing is hardest, because it's busy and people take shortcuts.

• Ring up every sale in the POS, including cash sales and staff purchases. "I'll enter it later" is how counts drift.

• Scan barcodes or SKU labels rather than typing product names.

• Make sure the POS updates the source of truth immediately, or that the POS is the source of truth.

• Plan for internet outages. If the POS works offline, make sure it syncs as soon as it's back online, and avoid selling the very last unit of an item online during an outage.

Step 8: More than one location

With two or more shops, or a shop plus a warehouse:

• Track stock per location, not just in total. "We have 8" isn't useful if all 8 are in the other branch.

• Decide which location fulfils online orders. Some shops ship from the warehouse only; others from whichever branch has stock.

• Record transfers as two steps: out of one location when it leaves, into the other when it arrives. Items in transit belong to neither.

• Give each branch visibility of the others' stock, so staff can offer "we have it in the other branch" instead of losing the sale.

Step 9: Count regularly and fix the gaps

Even good systems drift. Build a habit of checking:

• Weekly spot counts: count your 20 best-selling SKUs and compare with the system. Fix differences and note why they happened.

• Monthly full count of one product category at a time, so you don't have to close the shop.

• Look for patterns. If the same SKU is always off, something in the process for that item is broken: a bundle, a common return or a size that's often mislabelled.

How to choose a tool

When a spreadsheet stops working, look for a system that:

1. Tracks stock per variant (SKU) and per location.

2. Updates instantly from every channel you sell in: website, counter, Instagram, Facebook, WhatsApp.

3. Reserves stock for chat orders and releases it automatically.

4. Pushes availability out to your website and social catalog, rather than you updating each one.

5. Works at the counter, including offline.

6. Records returns, damages and transfers with a reason.

7. Gives you a single report of what sold where.

The point that matters most is number 2. If even one channel keeps its own stock number, you'll still oversell; you'll just do it less often.

Nodi Commerce runs your online store, shop counter POS, Instagram, Facebook and WhatsApp orders and your branches on one catalog with one stock count. When an item sells anywhere, at the counter, on your website or in a chat, it's deducted everywhere at once, and Nodi's AI checks the real count before telling a customer something is available. See how Nodi keeps one stock count →

Checklist

• ☐ One source of truth chosen and written down

• ☐ Every variant has a unique SKU, used in every channel

• ☐ Full opening count done and dated

• ☐ Sync method chosen for each channel

• ☐ Stock-change rules written for every event

• ☐ Chat orders reserve stock at confirmation, with a deadline

• ☐ Buffer set on any channel that updates slowly

• ☐ Every counter sale rung up in the POS

• ☐ Stock tracked per location, transfers recorded

• ☐ Weekly spot counts on best sellers

Selling in the UAE? Read Inventory Management for Small UAE Shops and Best POS Systems in the UAE for Small Shops.

See it in Nodi: Inventory management in Nodi

Common questions

What is the easiest way to sync inventory for a small shop?

Choose one source of truth, give every variant a SKU, and update that one record the moment anything sells. A spreadsheet works for very small volumes. Once you sell the same items in two or more channels every day, a system where all channels share one stock count is far more reliable than linking separate tools.

Why do I keep overselling?

Usually because stock is counted in more than one place, updates happen late, or chat orders aren't reserved when the customer confirms. Fix where the true number lives, and when it changes, and most overselling stops.

Does Instagram track my inventory?

Not by itself. If you tag products, Instagram shows what's in your Meta catalog, which you or a connected system keep up to date. Captions and posts don't update themselves, so mark sold-out sizes by hand or keep them out of captions.

What is safety stock?

Safety stock, or a buffer, is a small number of units you hold back from a channel so it doesn't sell items you've already sold elsewhere. It's useful for channels that only update every few hours.

How often should I count my stock?

Spot-check your best sellers weekly and do a full count of one category each month. Count everything at least once or twice a year.

Should I track stock by product or by size and colour?

By size and colour (each variant). Knowing you have "12 blue shirts" is useless if a customer wants a medium and all 12 are large.