How to Sync In-Store and Online Inventory: Step by Step

To sync in-store and online inventory, keep one master stock count that every sales channel reads from and writes to. Each sale, return, or delivery updates that single number. Then hold back a small safety buffer on online listings, and run regular counts to catch the errors that slip through.

Most small retailers don't get into trouble because they lack software. They get into trouble because the shelf, the register, and the website each hold a different opinion about how many units exist. This guide walks you through fixing that, whether you run a full POS, a spreadsheet, or nothing but a notebook. The thresholds below are practical starting points, not universal laws, so adjust them to your own sales data.

Why Does In-Store and Online Inventory Fall Out of Sync?

Inventory drifts because the same unit can be sold in two places within minutes, and nobody updates the other place. Add theft, damaged goods, miscounted deliveries, and returns put back on the wrong shelf, and the gap between "system says 4" and "shelf has 2" grows every week.

Here is a typical scenario, shown as an illustration rather than a named client. A candle shop has three of a bestselling scent left. A customer buys two at the counter at 2:10 pm. A website visitor buys two at 2:14 pm. Nobody did anything wrong. The website simply never heard about the first sale. That's an oversell, and it costs you a refund, an apology, and sometimes a review.

The common causes are worth naming, because each one needs a different fix:

• Delayed updates. Someone adjusts the website stock at the end of the day, not at the moment of sale.
• Two separate counts. The register and the web store each keep their own numbers.
• Unlogged events. Shrinkage, samples, damaged items, and staff discounts never reach the system.
• Receiving errors. A supplier ships 24 and the paperwork says 30.
• Variants. Size M in blue gets sold but the system decrements size L.

The fix isn't a smarter tool first. It's a clear rule about where the truth lives.

Build a Single Source of Truth for Your Inventory

A single source of truth inventory means one place holds the official stock count, and every channel reads from it. In-store sales, web orders, returns, and deliveries all change that one number. If two systems each keep a count, you will eventually have two different answers.

Pick the master based on where most of your sales and receiving happen:

• Your e-commerce platform is the master if you sell mostly online and keep a modest stockroom.
• Your POS is the master if the register handles the bulk of volume and the website is a secondary channel.
• A spreadsheet is the master only for a small catalog, as a rough guide under 100 SKUs and a few orders a day. The real limit is how often you update the same number twice.

Whichever you choose, write down three rules and tape them somewhere staff can see them. First, nothing is received without being logged. Second, nothing leaves the building without being logged, including gifts and samples. Third, nobody edits stock in a second place.

If you're still deciding on tooling, our retail inventory management software buyer's guide compares the options by store size and budget.

How to Sync In-Store and Online Inventory Without a POS

You can sync in-store and online inventory without a POS by making your online store the master count and updating it from the shop floor on a phone or tablet. It's slower than automation, but it works for small catalogs when you pair it with a strict routine.

Many owners assume they need a register system first. They don't. Plenty of boutiques, bakeries, and gift shops run on a cash box, a card reader, and an admin dashboard. Here's the routine that holds up.

A manual inventory sync routine for a small business

Manual inventory sync for a small business is about discipline, not tools. Use this sequence:

1. Take a baseline count. Count every SKU once, on a closed day or before opening, and enter it as your starting stock.
2. Log in-store sales as you go. Keep a tally sheet by the till with product name, variant, and quantity. Enter it into your admin at set times, such as noon and close.
3. Let online orders decrement automatically. Your e-commerce platform already does this, so never adjust those by hand.
4. Pull online stock for the shelf. When a web order comes in, set the item aside in a labeled bin immediately, so the shelf can't sell it.
5. Reconcile at close. Compare the tally sheet to the admin. Fix differences the same day while you still remember what happened.

The weak point is the gap between tally and entry. If you sell a fast mover, shorten that gap, or lower the quantity you show online.

A small shop inventory spreadsheet that works

A small shop inventory spreadsheet needs only seven columns: SKU, product name, variant, location, on-hand count, reserved for online orders, and reorder point. Add a "last counted" date so you can see which rows are stale.

Use data validation so quantities can't go negative, and keep one tab for receiving and one for adjustments. Every change gets a date, an initial, and a reason. Skip the reason column and you'll never find out why shrinkage is climbing.

Be honest about its limits, though. Google Sheets or Excel won't push counts to your website on their own. Someone has to type, and typing is where errors enter. If you're updating the same number in two places more than a few times a day, it's time to move the count into your store platform.

Connectors and integrations: automating the spreadsheet

If you want to keep a spreadsheet but stop retyping, there are three common routes:

• Native CSV import and export. Most store platforms let you download products with stock levels and upload edited quantities in bulk. It's free and fine for a once-a-day update, but it's still manual and can overwrite sales made while you edited.
• Automation tools such as Zapier or Make. These can watch a Google Sheet row and push the new quantity to your store, or send each new web order back to the sheet. They fit small catalogs but need testing, and a broken step can fail silently, so check a few SKUs weekly.
• Inventory sync apps. Dedicated apps connect your store, POS, and marketplaces to one stock record. They are the most reliable option, though they usually carry a monthly fee.

Whichever route you pick, make sure data flows in one direction per field. Let the store write online sales, let the sheet write receiving and adjustments, and never let both overwrite the same cell.

Prevent Overselling Online and In Store With Safety Stock

Safety stock for online orders is a small quantity you hide from your website so a delayed update can't cause an oversell. If you have 5 units, you might show 3 online. The two held back absorb in-store sales that haven't been logged yet.

The right buffer depends on how fast you sell and how fast you update. Use these as starting points, then tune them with your own oversell log. You can also calculate a buffer directly: multiply the units you sell per hour at peak by the hours between updates, then round up. A item selling 1 unit an hour with updates every 4 hours needs a buffer of about 4 units.

Situation	Suggested online buffer	Why
Slow seller, updated in real time	0 units	Little risk of a collision
Steady seller, updated twice a day	1-2 units	Covers sales between updates
Bestseller, manual updates	10-20% of stock, minimum 2	Fast turnover makes gaps costly
One-of-a-kind or handmade item	Sell in one channel at a time	No spare unit to absorb errors

Two other tactics help. First, set a low-stock threshold so listings show "only 2 left" or switch to backorder or pre-order when they hit your buffer. Second, give your best sellers extra attention. In most shops a minority of products drives a majority of sales, so your fastest sellers tend to cause most oversells. Sort your own sales report by units sold over the last 90 days, mark the top 10 to 20 percent, and count those more often.

You can also assign stock by channel. A sweater with 8 units might be split 5 for the floor and 3 for online. It's cruder than a shared pool, but it removes the collision entirely for items you can't afford to oversell.

Real-Time Inventory for Small Retailers: When to Automate

Real-time inventory for small retailers becomes worth paying for when you sell the same SKUs in both channels and make more than a handful of sales per day. At that point, manual entry costs you more in errors and refunds than software would.

A connected setup works like this: the register and the web store write to the same stock record, so a sale in either one decrements the count within seconds. Shopify's POS product and Square's retail point of sale both take this approach, and each has its own pricing and plan limits you should check before you commit.

Before you buy anything, ask five questions:

• Does one sale update every channel within seconds, not on a schedule?
• Does it handle variants (size, color) as separate stock lines?
• Can you scan barcodes with a phone or handheld scanner?
• Does it support multiple locations if you open a second shop?
• What are the add-on costs? Inventory features are often sold as extra apps.

That last one matters. Stacking separate apps for inventory, alerts, and reporting adds monthly cost on top of a base plan. Add up the listed price of each app you would need, since app pricing varies widely and changes often. A platform that includes stock tracking by default keeps that cost off your books. Rovela, for instance, ships with a catalog, admin dashboard, and inventory tools in a single flat subscription, so your store and stock count live in one place.

If you haven't yet put your physical shop online, start with how to start selling online from a physical store before you worry about syncing anything.

Set a Stock Count Routine for Retail

A stock count routine for retail means counting a rotating slice of your products on a fixed schedule, so every SKU gets verified several times a year without closing the shop. This is called cycle counting, and it beats one painful annual count.

A simple schedule that works for a shop with a few hundred SKUs:

• Daily (10 minutes): count your 10 fastest sellers and anything that shows 3 units or fewer.
• Weekly (30-45 minutes): count one category, such as skincare on week one, accessories on week two.
• Monthly: check receiving records against supplier invoices.
• Twice a year: run a full count, ideally before your busiest season.

When a count doesn't match, don't just overwrite the number. Write down the difference and the likely cause. After a few weeks, patterns show up: one supplier short-ships, one staff member forgets to log samples, or one variant gets mislabeled on the shelf.

Count in a consistent order, shelf to back stock to online reserve bin, and have someone other than the person who receives goods do the verifying when you can. Two sets of eyes catch more.

Oversold Item: What to Do When It Happens

If you've oversold an item, contact the online customer immediately, offer a choice between a refund, a backorder with a date, or a similar product, and fix the stock record. Speed and honesty matter more than the compensation itself.

Follow this order:

1. Confirm the count. Check the shelf and back stock before you write to anyone. Sometimes the unit is simply misplaced.
2. Decide who gets priority. Usually the customer who ordered first keeps the item. A person standing in your shop has already paid, so don't take it back.
3. Message the other customer the same day. Say what happened in two sentences. Don't blame the system.
4. Offer options. A full refund, a firm restock date, or a substitute. A small gesture, such as a discount code or free shipping on their next order, helps keep the relationship.
5. Find the cause. Was it a delayed update, a missed return, a miscounted delivery? Fix the rule, not just the number.
6. Adjust the buffer. If it was a bestseller, raise its online safety stock.

Track oversells in a simple log. If you hit more than one or two a month, your sync method is no longer matching your sales volume.

Common Questions About Syncing Inventory

Can I sync inventory with Google Sheets?

You can use Sheets as a record, but it won't update your online store by itself. You'd need a connector (see the integrations section above) or a manual entry step, which keeps the error risk alive. It's fine for small catalogs and a stopgap, not a long-term answer.

How often should inventory sync?

Instantly is ideal. If you're manual, update at least twice a day, and more often for fast-moving items. The longer the gap, the more safety stock you need.

What if I sell on marketplaces too?

Treat each marketplace as another channel reading from the same master count. Hold back more safety stock for them, since they're harder to pause quickly and penalize cancellations.

Do I need barcodes?

Not at the start, but they cut miscounts and speed up receiving. Once you pass a few hundred SKUs, barcodes pay for themselves quickly.

How to Sync In-Store and Online Inventory: Your Next Step

To sync in-store and online inventory, build four habits: one master count, a safety buffer on online listings, a regular stock count routine, and a clear plan for when an item oversells. Start with a spreadsheet if you must, but move to connected, automatic stock as soon as your sales volume makes manual entry a risk.

If you're ready to put your shop online with stock tracking, a catalog, and checkout already built in, Rovela builds a complete store from a plain-language description in hours. You can see what's included on the pricing page, or read about setting up local delivery to serve nearby customers from the same inventory.