Retail POS and inventory across stores and online: getting one stock number

A customer orders a kurta on your website at 9 pm. The last piece in that size was sold at your Navrangpura store at 7 pm, but the website will not know until the nightly upload. Tomorrow someone calls to cancel, and the customer leaves a one star review. Multiply that by three stores, a website and two marketplaces, and you have the most common retail systems problem in India.

Quick answer

Pick one system to own the stock figure, usually your ERP or a retail management system that includes POS. Every store POS, your website and each marketplace reads available stock from it and sends sales back to it, close to real time. Keep a small buffer on online channels, and clean your item master first. Without consistent item codes, no integration will give you a trustworthy number.

Why the numbers drift

• Each store runs its own billing software, and stock is consolidated at day end, or week end.
• The website has its own product catalogue with different SKU codes.
• Marketplaces such as Amazon, Flipkart and Myntra are updated by hand or by a spreadsheet upload.
• Transfers between stores are recorded when the goods leave, but not when they arrive, or the other way round.
• Returns, especially online returns that come back weeks later, are not put back into stock properly.

Each of these on its own causes small errors. Together they make stock figures that nobody believes, and staff stop checking the system before they promise a customer anything.

Choose the owner of stock

There are three common setups.

Retail ERP with built-in POS. One system runs billing in every store and holds central stock. Ginesys, Gofrugal, Zoho, Odoo POS and others work this way. This is the simplest route if you are replacing store billing anyway.

Separate POS, central inventory. You keep the POS your stores like, and connect each to a central inventory system through APIs. More moving parts, but sometimes necessary if stores are franchised or run different software.

Commerce platform as owner. For businesses that are mainly online with a few stores, the e-commerce platform holds stock and the stores use its POS. Shopify, and our own ShopenUp, can work this way.

Whichever you choose, write down that this system owns available stock. Everything else is a reader.

Clean the item master first

This is the dull part that decides success. Before any integration:

1. Give every variant, meaning each size and colour, one SKU code, used everywhere.
2. Map marketplace listing IDs to your SKUs in one table.
3. Make sure every physical item has a barcode that resolves to that SKU.
4. Retire duplicate and dead codes. Many retailers find a large share of their item master has not sold in two years.

Expect this to take longer than the software setup. It is worth it.

How close to real time is enough

True real time across every channel is expensive and rarely necessary. A practical approach:

• Store sales update central stock within a few minutes. Most modern POS systems can do this when online and catch up when the connection returns.
• Online channels receive available stock updates every few minutes, or immediately for items with low stock.
• Online channels see stock minus a buffer, for example two units per SKU, or a percentage for fast movers. This absorbs the delay and the occasional counting error.
• Store to store transfers show as in transit, so they are counted neither in the sending nor the receiving store until received.

Make stores part of online selling

Once stock is reliable, you can do the things that actually earn money: ship online orders from the nearest store, offer order online and pick up in store, and let store staff sell from another branch's stock. Each needs a clear rule for who gets credit for the sale and how the store is told to pick and pack. Agree those rules with store managers early, or they will quietly resist.

UPI, cards and GST at the counter

Your POS needs to handle UPI dynamic QR codes, card terminals from providers such as Pine Labs or Razorpay, split payments and GST-compliant bills. If you are above the e-invoicing threshold, B2B sales from stores also need an IRN, which many store POS systems handle poorly. Test this before rollout if you sell to businesses at the counter.

Where to start

Do a physical count across all locations, clean the item master, then connect one store and the website to a central stock owner. Run that for a month, then add the remaining stores and marketplaces. If your stock figures are still off after that, the cause is almost always process, such as unrecorded transfers or returns.