Ecommerce inventory management when your stock sits in a shop

Most guides to ecommerce inventory management are written with warehouses in mind. They assume stock sits on organised racks, inventory moves when an order is picked, and discrepancies mainly happen when a process or system goes wrong.

A physical retail shop works differently.

Products are picked up, tried on, moved around, returned, damaged, sold at the till, or occasionally put back in the wrong place. A member of staff might sell the last unit in-store while your ecommerce website still shows it as available.Your point-of-sale (POS) or inventory system may hold the current stock number while your ecommerce store or marketplace holds another version of it. The gap between those numbers is where inventory problems begin.Effective ecommerce inventory management is therefore not only about knowing how much stock to order. For retailers selling both in-store and online, it is also about keeping the physical stock, POS or inventory system, and online sales channels aligned.This guide explains where inventory counts drift, how inaccurate stock reaches customers, what retailers can fix operationally, and when connecting your systems becomes useful.

What Ecommerce Inventory Management Means When You Also Have a Shop

For a warehouse-only business, inventory management is largely a planning problem: how much inventory should you hold, when should you reorder, and how should future demand be forecast?

Physical retailers have another problem.

It is a stock truth problem.Your physical shelf, POS, ecommerce platform and marketplaces may all contain information about the same product. If two systems show different quantities, planning against either number becomes difficult.A practical inventory management process therefore follows four stages:

1. Choose one system to own the inventory count. Other connected systems should receive inventory information from it.
2. Keep that inventory count aligned with physical stock.
3. Send stock changes to your online sales channels quickly enough to minimise discrepancies.
4. Use reliable inventory data for purchasing, reorder points, safety stock and forecasting.

Retailers often concentrate on forecasting and replenishment first. But if the underlying inventory number is inaccurate, better forecasting cannot solve the problem.

How Bad Can Inventory Record Errors Become?

Inventory inaccuracies are not unusual in retail.Research published by ECR Retail Loss in 2020 examined inventory records across seven retailers in four European countries. The three-year project considered approximately one million SKUs across roughly 100 stores, with about 233,000 SKUs used for its conclusions.The research found that approximately 59.5% of audited SKUs had stock records that did not match physical inventory. Results varied significantly among the participating retailers.The study also found discrepancies in both directions. A system can show more stock than is physically available, but it can also show less.Stores where inventory records were corrected saw sales between 3.8% and 8.4% higher than matched control stores, averaging approximately 6%. The largest increases occurred among faster-moving products and items with larger inventory discrepancies.These figures need context.The research describes an association rather than proving that correcting inventory records alone caused the increase in sales. It also studied European grocery, general merchandise, fashion and apparel retailers. An independent retailer running a physical shop and an ecommerce website may experience different results.The useful lesson is therefore not that every retailer will experience the same percentages. It is that inventory accuracy can become a meaningful operational issue when physical and recorded stock diverge.

Five Places Where Inventory Counts Can Drift

Before assuming that your ecommerce integration is broken, it helps to understand where inventory discrepancies originate.

1. The Shop Floor

Physical retail creates inventory movements that do not always appear immediately in software.Customers move products. Items can be damaged or misplaced. A product may be taken off the shelf but not correctly written off in the system.No ecommerce integration can determine whether a physical product is sitting on the wrong shelf.Regular counting remains necessary.

2. Receiving Inventory

Suppose your supplier’s paperwork says 24 units were delivered, but only 22 physically arrived.If your team enters 24 into the inventory system without checking the delivery, the system begins with an incorrect number.Every subsequent sale and stock calculation is then based on inaccurate information.Receiving procedures should therefore compare what physically arrived with what is being entered into the inventory system.

3. Returns

Returns can create discrepancies in either direction.A returned product might be placed back on the shop floor before the inventory system has been updated.The opposite can also happen: the product is added back to available inventory before staff confirm that it is actually suitable for resale.A defined returns process helps prevent this gap.

4. Two Systems Both Controlling Inventory

Problems can arise when both your POS and ecommerce platform independently modify inventory without a clearly defined stock master.For example, your POS believes the available quantity is 10 while your ecommerce store believes it is 12.Which number should your business trust?A multichannel inventory setup should have a clearly defined source for inventory quantities and a deliberate synchronization direction.If you’re unsure which systems can work together, see our guide to which inventory tools connect to a POS.

5. The Synchronization Gap

Every connected setup has some degree of processing time.Imagine there is one unit remaining.A customer purchases it in your physical shop. Until that inventory change reaches the ecommerce store, the website may still consider the item available.For products that sell infrequently, a short synchronization gap may have little practical effect. For fast-moving products being purchased both online and in-store, the same gap becomes more important.You can learn more about how overselling actually happens when inventory is shared across multiple sales channels.

What Your Ecommerce Platform Already Does Matters

Before buying new inventory software or changing your integration, understand how your existing platforms handle inventory.Some behaviour that looks like a synchronization problem can actually be the result of a platform setting, location configuration or inventory policy.

Shopify and Out-of-Stock Products

Shopify documents that its Continue selling when out of stock setting applies to online inventory behaviour but doesn’t apply in the same way to orders placed through Shopify POS. Shopify POS staff can continue selling an item when available inventory reaches zero or below.That means your online store and physical checkout can behave differently for the same product.

Shopify Inventory Locations

Inventory location settings also affect online availability.According to Shopify’s documentation, stock assigned to a location that does not fulfil online orders does not automatically make that inventory available to customers through the online store.If physical inventory exists but your website says a product is unavailable, review the product’s inventory and fulfilment locations before concluding that synchronization has failed.

Multiple Shopify Fulfilment Locations

Shopify introduced functionality in April 2025 that can split units of a single line item across fulfilment locations when certain conditions are met.For merchants operating multiple locations, this makes it especially important to understand how inventory locations, shipping zones and out-of-stock settings interact.If your business holds inventory in several shops or warehouses, read our guide to managing stock across more than one location.

Zoho Inventory and Shopify

Zoho Inventory also documents specific behaviour for its native Shopify integration.For example, Zoho explains that inventory from warehouses can be combined when stock information is sent to Shopify. Its documentation also describes how stock counts are handled during synchronization.For retailers operating multiple warehouses or stores, these defaults are worth checking before deciding how inventory should be represented on Shopify.The broader lesson is simple:Understand what your existing systems already do before assuming you need another system.Inventory problems can sometimes come from configuration rather than the connection itself.

Manual vs Spreadsheet vs Connected Inventory Management

Different inventory management methods can work at different stages of a retail business.

There is no universal sales volume or SKU number at which every retailer must automate inventory management.A more practical trigger is when incorrect inventory begins creating identifiable business problems.Examples include cancelled online orders, customers arriving at your shop for products that are not actually available, repeated manual inventory corrections, or purchasing decisions based on inaccurate reports.At that point, the cost of maintaining disconnected systems deserves attention.

What to Fix First

Buying software should not necessarily be your first response to inaccurate inventory.Start with the underlying process.

1. Decide Which System Owns Your Inventory

Choose one system as the inventory master.For many physical retailers, that may be the POS or dedicated inventory management system.Your ecommerce platforms and marketplaces can then receive inventory information from that source rather than maintaining independent quantities.

2. Count Physical Inventory Regularly

Software only knows what has been entered into it.If your system says there are eight units while only six physically exist, synchronizing that number perfectly still sends inaccurate information to every channel.Cycle counting can help.Instead of relying only on an annual stocktake, count selected products throughout the year. Fast-moving and high-value products can be checked more frequently.Inventory accuracy is maintenance, not a one-time project.

3. Improve Receiving and Returns

Deliveries should be checked against physical quantities rather than entered automatically from supplier paperwork.Returns should also follow a defined process.A returned product should not become available inventory until staff know whether it can actually be sold again.These operational improvements help make the inventory number trustworthy before it is synchronized anywhere else.

4. Connect Your Sales Channels Deliberately

Once the inventory master is reliable, determine how inventory should move between systems.Decide:

• Which system sends inventory updates?
• Which systems receive them?
• How are SKUs matched?
• What happens when an SKU does not match?
• How should different locations be mapped?
• How are online orders returned to the POS or inventory system?

These decisions become increasingly important as the number of sales channels grows.

5. Consider Buffer Inventory for Fast-Moving Products

Connected systems reduce the time between an in-store sale and an online inventory update, but synchronization should not be treated as instantaneous.For particularly fast-moving or limited-stock products, retailers may choose to make slightly less inventory available online than physically exists.Whether this is appropriate depends on your sales volume, margins and inventory strategy.

6. Then Work on Reordering and Forecasting

Once the inventory number itself is trustworthy, reorder points, purchasing and forecasting become more useful.Forecasting against inaccurate inventory simply produces more sophisticated decisions based on unreliable data.

Where an Ecommerce Inventory Connector Fits

If your inventory lives in a POS or inventory management system while products are also sold through ecommerce platforms or marketplaces, manually moving information between those systems can become difficult as the business grows.This is where an integration platform can help.SKUPlugs connects supported POS and inventory systems with ecommerce platforms and marketplaces so that products, inventory and orders can stay aligned on a near real-time basis.Rather than maintaining separate inventory workflows for each sales channel, retailers can use their POS or inventory system as the central source and connect it with the channels where they sell.SKUPlugs supports integrations involving ecommerce platforms such as Shopify, WooCommerce, Magento and BigCommerce, as well as marketplaces including Amazon, Walmart and Faire.You can see all SKUPlugs integrations to check whether your POS, inventory system and ecommerce platform are supported.A connector, however, does not correct inaccurate physical inventory.If the POS says you have 12 units when only 10 are actually on the shelf, an integration can only work with the inventory information it receives.The purpose of the connector is to reduce the distance between the inventory number held by your source system and the inventory information shown across your connected sales channels.For current plans and available options, compare SKUPlugs pricing.