How to Manage Store and E-commerce Inventory in One Place? An 8-Module Inventory Setup Guide for Warehouses, Branches and Online Sales
How do you manage store, warehouse and e-commerce inventory from one center? Channel map, initial distribution, critical stock, inter-branch transfers and mistakes: an 8-module training.
Contents 14 sections
- What will you be able to do by the end of this training?
- Module 1: Why does splitting inventory by channel cause problems?
- Module 2: How do you map channels and warehouses?
- Module 3: How do you standardize product codes and barcodes?
- Module 4: How is opening stock distributed across channels?
- Module 5: How is the critical stock level determined?
- Module 6: How are store sales and online orders deducted from the same stock?
- Module 7: How do you read branch performance and inventory reports?
- Module 8: How do you establish a weekly inventory routine?
- What are the most common mistakes in multichannel inventory management?
- How do you manage store, warehouse and e-commerce inventory with NetKasam?
- Mini quiz: Test what you have learned
- Conclusion: a single stock grows independently of the number of channels
- Frequently Asked Questions About Store and E-Commerce Inventory Management
You have a physical store, plus an e-commerce channel or marketplace stores. A customer buys a product in the store that is down to its last two units; at the same hour another order comes in online. On the stock screen the product still shows as "available", you accept the order, then you call the customer and say "we're sorry, we're out of stock." This is the first big problem every business selling across multiple channels runs into, and the cause is usually not the product but the setup: each channel's stock is kept in a separate ledger. The answer to how do you manage store and e-commerce inventory from one center is a matter of establishing a system before it is a software setting.
This article is not an ordinary narrative but an 8-module hands-on training. In each module you will find what to do, why you do it and how to tell you did it right. We will work through numbered examples with a sample business that has one central warehouse, two stores and one e-commerce channel, and finish with a mini quiz and a weekly routine list.
What will you be able to do by the end of this training?
In short: You will map your channels and warehouses, define your products with a single code, distribute inventory according to sales velocity, set a critical stock limit for each channel and establish a weekly inventory routine. For a small business it takes 1–2 days.
- 01MapGather channels, stores and warehouses into one list.
- 02CodeGive each product a single stock code and barcode.
- 03DistributionAllocate inventory according to each channel's sales velocity.
- 04LimitDefine the critical stock level for each channel.
- 05SalesHave store and online sales deducted from the same stock.
- 06RoutineEstablish a weekly transfer, count and reporting routine.
Module 1: Why does splitting inventory by channel cause problems?
In short: When each channel's stock is kept separately, three problems are inevitable: the same product being sold on two channels at once, stock running out on one channel while excess piles up on another, and not knowing which stock figure across channels is the real one.
| Problem | How does it happen? | Result |
|---|---|---|
| Overselling | A store sale is not reflected in online stock; two channels sell the same product | Canceled orders, lost customers |
| Unbalanced stock | A product runs out at one branch while sitting for months at another | Missed sales and tied-up capital |
| Unreliable figures | Stock is in separate spreadsheets; nobody knows the total | Wrong purchasing decisions, surprises at the count |
| Duplicate work | The product card is created and updated separately on each channel | Lost time and inconsistent prices |
We covered stock syncing between online channels separately in our article on marketplace stock synchronization; this training sets up a system that also covers the physical store and warehouse. For the general framework of multichannel selling, see our article what is multichannel selling in e-commerce.
Recommended readingHow to Sync Inventory Across Multiple Marketplaces?Module 2: How do you map channels and warehouses?
In short: Write every place the product can be (central warehouse, stores, stock set aside for e-commerce) and every channel it can be sold on into a single list. This list determines how many warehouses and branches you will define in the system.
Our example business has this structure: one central warehouse, two stores and one e-commerce channel (its own website and marketplaces). Let's put into a table what each one holds and where it is supplied from:
| Location | Role | Where does it get stock from? | Sales channel |
|---|---|---|---|
| Central warehouse | Main stock, receiving goods from suppliers | Supplier | No direct sales; distribution |
| Store A | Retail sales | Transfer from the central warehouse | In-store POS screen |
| Store B | Retail sales | Transfer from the central warehouse | In-store POS screen |
| E-commerce stock | Stock set aside for online sales | Quantity set aside from the central warehouse | Website and marketplaces |
NetKasam has no limit on the number of branches and warehouses; you can create as many warehouses as you like and define users for them. Because each branch or warehouse can be reported separately, you can see sales and stock by channel. For details, see the questions is there a warehouse limit in NetKasam and can I see my branch stock and sales separately.
Module 3: How do you standardize product codes and barcodes?
In short: Every product and every variant should have a single stock code and a single barcode. If the same product is known by one code in the store and another online, the stock cannot be combined in one center.
Combining stock is a matching job: the system knows through the code that the barcode scanned in the store and the product sold online are the same product. If codes are inconsistent, two separate product cards are created and each holds its own stock. Apply three rules:
- Single stock code: A unique stock code for each product and variant. For how to structure codes, see our article what you need to know about stock codes.
- Barcode: The barcode scanned in the store and the barcode used on the marketplace should be the same; barcode columns should be kept in text format in Excel. For details, see the barcode creation guide for e-commerce businesses.
- Variants: Create sub-options like size and color as variants of one product, not as separate products; stock is tracked separately for each variant. For how variants are matched on marketplaces, take a look at our guide how to manage products with variants on a marketplace.
In NetKasam, sales can be made on the in-store quick sale screens by product, variant or case barcode; you can also define product sets and sell in units such as cases or boxes. That is why a barcode standard is the foundation of both the store checkout and the warehouse count.
Module 4: How is opening stock distributed across channels?
In short: Distribute stock according to each channel's sales velocity: Target stock = Average daily sales × Target days of cover; transfer need = Target stock − Current stock. Using sales velocity instead of a fixed percentage prevents the fast-selling channel from running out of product while the slow-selling channel stays overstocked.
- Average daily sales = Units sold in the last 30 days ÷ 30
- Days of cover = Current stock ÷ Average daily sales
- Target stock = Average daily sales × Target days of cover
- Transfer need = Target stock − Current stock
- Critical stock level = Average daily sales × Lead time (days) + Safety margin
Target days of cover are set according to lead time and transfer frequency (14 days in the example).
The example product's sales over the last 30 days are: Store A 90 units, Store B 60 units, e-commerce 150 units; 300 units in total. There are 200 units in the central warehouse, and on the channels there are 18 units at Store A, 20 at Store B and 25 in e-commerce stock. We chose a target cover of 14 days:
| Channel | Sales in the last 30 days | Daily average | Current stock | Cover (days) | Target stock (14 days) | Transfer |
|---|---|---|---|---|---|---|
| Store A | 90 | 3 | 18 | 6 | 42 | 24 |
| Store B | 60 | 2 | 20 | 10 | 28 | 8 |
| E-commerce | 150 | 5 | 25 | 5 | 70 | 45 |
| Total | 300 | 10 | 63 | — | 140 | 77 |
The figures are example values chosen only to illustrate the method. The point to watch in the table is days of cover: e-commerce stock covers only 5 days of sales, Store A 6 days; Store B, with 10 days of stock, is the most comfortable channel. So even though stock looks sufficient in total (63 units), the distribution across channels is off.
- E-commerce stock5 days
- Store A6 days
- Store B10 days
Days of cover = Current stock ÷ Average daily sales. The target is 14 days.
When a total of 77 units is transferred from the 200 units in the central warehouse to the channels, the distribution goes like this:
- Stock in the central warehouse200 units
- Transfer to Store A−24 units
- Transfer to Store B−8 units
- Transfer to e-commerce stock−45 units
- Remaining in the central warehouse123 units
Prepared with example values. After the transfer, each channel reaches its 14-day target stock.
To see which channel the share of sales is concentrated in, you can also read the last 30 days as a breakdown:
- E-commerce150 units50%
- Store A90 units30%
- Store B60 units20%
E-commerce makes half of all sales; clearly its share of the distribution should be correspondingly large. A channel's share changes with the season and with promotions, so the distribution is recalculated every week or every transfer period using the current sales velocity. To choose which products to prioritize, take a look at our guide how to do an ABC analysis: distribution can be weekly for class A products and monthly for class C.
Recommended readingHow to Calculate Safety Stock and the Reorder Point?Module 5: How is the critical stock level determined?
In short: The critical stock level is the stock limit at which the system warns you so that you can start procurement or a transfer before the product runs out. It is calculated separately for each channel with the formula daily sales × lead time + safety margin.
The critical stock limit for the same product differs by channel, because sales velocity and replenishment time differ. In our example, a transfer from the central warehouse to a store takes 2 days, and setting stock aside for e-commerce can be done the same day; goods from the supplier reach the central warehouse in 7 days. With this information:
| Location | Daily sales | Replenishment time | Safety margin | Reorder level |
|---|---|---|---|---|
| Store A | 3 units | 2 days (from the central warehouse) | 3 units | 3 × 2 + 3 = 9 |
| Store B | 2 units | 2 days (from the central warehouse) | 2 units | 2 × 2 + 2 = 6 |
| E-commerce stock | 5 units | 1 day (from the central warehouse) | 5 units | 5 × 1 + 5 = 10 |
| Central warehouse | 10 units (total) | 7 days (from the supplier) | 20 units | 10 × 7 + 20 = 90 |
In NetKasam, a critical stock level is defined for each product, and when stock falls to that limit the system sends you a notification; that way you can start procurement or a transfer before the product runs out. For details, see the question what is the critical stock level. You can find how the safety margin is determined in detail in our article how to calculate safety stock.
Module 6: How are store sales and online orders deducted from the same stock?
In short: Barcode sales made on the in-store POS screen and orders coming in online reduce the stock of the same product card. Because you keep stock in one place, products that are not available are sold neither in the store nor online.
Sales speed matters in the store; a customer waiting in line at the checkout is a lost sale. On the NetKasam in-store quick sale screen, you can sell very quickly by product, variant or case barcode; it can be used anywhere with internet, without installation or a server. You can define your stores' sales terms as wholesale or retail and block sales outside the terms you set; it is also possible to define separate users and separate permissions for each store and warehouse. For details, see the questions can I sell with product barcodes in my stores and can I separate my stores into wholesale and retail.
It is also possible to manage e-commerce orders according to warehouse or branch stock; that is, you can determine which stock an online order is fulfilled from. For collecting orders on one screen, invoicing them and handing them to the carrier, see our article on order management in e-commerce.
Module 7: How do you read branch performance and inventory reports?
In short: By reporting each branch and warehouse separately, you see their sales and stock individually and can compare branches with each other. Days of cover, share of sales and products below critical stock are the three key indicators to check every week.
- 5 dayshow long e-commerce stock will last; the riskiest channel
- 50%e-commerce's share of sales over the last 30 days
- 77 unitstotal transfer needed in the initial distribution
- 123 unitsstock remaining in the central warehouse after the transfer
When reading reports, ask three questions: Which channel's days of cover is below target? Which product is below its critical stock limit? At which branch is stock piling up faster than it sells? In NetKasam, you can access reports from the reports screen, save the reports you use often and export them to Excel. For how to check stock value and count discrepancies, see our guide how to do a stock count.
Module 8: How do you establish a weekly inventory routine?
In short: Set aside a short meeting or check-in time once a week: look at days of cover, list items below critical stock, make the transfers and do a count once a month. The routine matters more than setting everything up correctly once.
- Monday: numbers. Read the last 7 days of sales by channel and update the daily average.
- Tuesday: days of cover. List the channels and products below target.
- Wednesday: transfers. Make transfers from the central warehouse to the channels; shipments to stores, allocations to e-commerce stock.
- Thursday: procurement. Order products that have fallen below the central warehouse's critical stock limit.
- Friday: exceptions. Check negative stock, last-unit products and branch count discrepancies.
- Month end: counting. Pick a warehouse or branch, do a cycle count and reconcile the difference with the records.
To run warehouse operations in an orderly way, you can also take a look at our articles what is a warehouse management system (WMS) and the advantages of real-time stock and warehouse tracking.
What are the most common mistakes in multichannel inventory management?
- Creating a separate product card for each channel. Two cards for the same product hold two separate stocks; they do not combine.
- Splitting stock by a fixed percentage. A fixed split like 50%-30%-20% leaves one channel without product when sales velocity changes.
- Not defining critical stock. With no warning, a product is noticed only when it has run out.
- Opening all stock to e-commerce. On promotion days, store shelves empty out and store sales are lost.
- Making transfers without documentation. If a product sent from the center to a store does not appear as a transfer in the records, a discrepancy shows up at the count.
- Ignoring negative stock. Negative stock shows that a sale was made on a channel before it was recorded; if the source is not found, it distorts stock value.
- Not comparing branches. If the same product sells fast at one branch and slowly at another, the cause lies not in stock but in visibility or price.
How do you manage store, warehouse and e-commerce inventory with NetKasam?
- Branch and warehouse management. With branch and warehouse management, you manage your branches and warehouses from one place and centralize inventory tracking and transfers; you can create unlimited warehouses and define separate users and permissions for each branch and warehouse.
- In-store POS screen. With the in-store POS screen, you make quick barcode sales and define wholesale and retail sales terms; no installation or server is needed.
- Inventory management. With inventory management, you track products with variants, critical stock alerts, stock cost and stock movements.
- Marketplace and e-commerce integration. With marketplace integration and e-commerce integration, online orders are deducted from stock and the updated stock is sent to the channels.
- Free bookkeeping. The bookkeeping and e-Invoice (e-Fatura) system is free in every plan; integration plans are on the pricing page.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If a channel has 18 units in stock and sells 3 units a day, what is its days of cover?
- If daily sales are 5 units, target cover is 14 days and current stock is 25 units, what is the transfer need?
- Which three pieces of information determine the critical stock level?
- Why shouldn't the same product be created with two separate product cards?
- How do you prevent store shelves from emptying during an e-commerce promotion?
Answer key:
- 18 ÷ 3 = 6 days.
- Target stock = 5 × 14 = 70; transfer = 70 − 25 = 45 units.
- Average daily sales, replenishment time (days) and safety margin: Daily sales × Replenishment time + Safety margin.
- Two cards hold two separate stocks; a store sale is not reflected in online stock and overselling occurs.
- By setting aside a quantity limited by target stock for the e-commerce channel instead of opening all stock to it.
Frequently Asked Questions About Store and E-Commerce Inventory Management
How do you manage store and e-commerce inventory from one center?
Each product gets a single stock code and barcode, inventory is distributed according to each channel's sales velocity, a critical stock limit is defined for each channel, and both store and online sales are deducted from the same product card's stock. A weekly transfer and check routine keeps things in order.
How is inventory distributed across channels?
Find each channel's average daily sales, multiply by the target days of cover to calculate the target stock, and subtract current stock from target stock to get the transfer need. Sales velocity is used instead of a fixed percentage.
What are days of cover, and how are they calculated?
It shows how many days of sales the current stock can support: Current stock ÷ Average daily sales. For example, with 18 units in stock and 3 units sold per day, days of cover is 6.
How is the critical stock level determined?
Multiply average daily sales by the replenishment lead time and add a safety margin. When stock falls to this limit, the system sends a notification, so procurement or a transfer starts before the product runs out.
Can multiple warehouses and branches be defined in NetKasam?
Yes. You can create as many warehouses as you like, define separate users and permissions for each branch and warehouse, and report on your branches separately and compare them with each other.
Can you sell by barcode in the store?
Yes. On the NetKasam in-store quick sale screen, you can sell very quickly by product, variant or case barcode. Because the system runs online, no installation or server is needed.
Which stock are online orders fulfilled from?
E-commerce orders can be managed according to warehouse or branch stock. Online sales are deducted from stock, and the updated stock is sent to the connected channels.
Can I separate stores into wholesale and retail?
Yes. You can define your stores' sales terms as wholesale or retail and block sales outside the specified terms.
Conclusion: a single stock grows independently of the number of channels
In multichannel selling, stock problems multiply as the number of channels grows; the solution, however, is independent of the number of channels: a single product code, distribution based on sales velocity, a critical stock limit and a weekly routine. When you apply the eight modules of this training, the store and the internet share the same shelf, and overselling and empty-shelf problems become measurable and manageable. As a first step, write down the last 30 days of sales for your 20 best-selling products by channel and calculate each channel's days of cover; a channel with fewer than 5 days of cover is the one closest to running out of product.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.