Your Excel sheet says 40 units left. Lazada SG already sold 3 more this morning.
Nothing in the spreadsheet knows that yet, and the next sale could push a SKU into negative stock before anyone opens the file to check.
What Is Inventory Software in Excel?
Inventory software in Excel is a spreadsheet-based stock tracking system that uses built-in formulas, rather than a dedicated app, to monitor SKU counts, reorder points, and sales velocity across your sales channels. It isn’t a product with a login and a monthly bill. It’s a workbook you build yourself, structured either as one tab per channel or a single master sheet with a channel column running down the side.
For a lot of Singapore sellers, this is genuinely where inventory tracking starts. Before signing up for a paid tool, most operators track their first batch of SKUs in Excel or Google Sheets because it’s free, already installed, and fast enough to set up in an afternoon.
Singapore adds a wrinkle most regional guides skip over. Industrial and warehouse space here runs among the priciest in Southeast Asia, and listings on JTC, the statutory board that manages Singapore’s industrial land, reflect that. A misread stock count costs more when every square foot of storage is expensive: a stockroom count error means paying for space to hold product you didn’t actually have, or scrambling for last-minute space you didn’t budget for.
The real question isn’t whether Excel can track inventory. It can, and does, for thousands of sellers. The question is how long it keeps working once a second marketplace, a second staff member, or a flash sale enters the picture.
How Do You Build an Excel Inventory Tracker for Shopee SG and Lazada SG?
A working tracker needs five columns at minimum: SKU code, product name, channel (Shopee SG, Lazada SG, Qoo10 SG), current stock count, and reorder point.
From there, most sellers follow roughly this sequence:
- List every active SKU on its own row, using one consistent code format across every channel. GS1 Singapore, the local body that maintains barcode and product identification standards, is a useful reference if you want SKU codes that stay readable once you add a warehouse partner or accounting system later.
- Add a stock count column that updates after each sale, either manually or by importing a channel’s order export.
- Calculate a reorder point per SKU using average daily sales multiplied by supplier lead time, with a safety buffer added on top. Longer supplier lead times, common when sourcing from overseas manufacturers, mean this buffer matters more for Singapore sellers than for operators sourcing domestically.
- Apply conditional formatting so any row that drops below its reorder point is visibly flagged, not buried in a 200-row list.
- Set a fixed review cadence. A tracker only earns its keep if someone actually opens it and acts on the flagged rows, ideally daily during a sale period and at least weekly otherwise.
That sequence gets a single-channel tracker working. Multi-channel tracking is where the formulas need to carry more weight.
Which Excel Formulas Do Singapore Sellers Actually Need?
Three functions cover most of what a spreadsheet tracker has to do, according to Microsoft’s own function reference documentation.
| Function | What It Does | Where It’s Used |
|---|---|---|
| SUMIFS | Totals sales for one SKU across multiple channel rows or columns | Combined sell-through across Shopee SG, Lazada SG, and Qoo10 SG |
| XLOOKUP (or VLOOKUP) | Pulls a SKU’s current stock count or reorder point from a master sheet into a channel-specific tab | Keeping every channel tab aligned to one source of truth |
| COUNTIFS | Counts how many SKUs currently sit below their reorder point | A running low-stock count at the top of the sheet, no scrolling needed |
SUMIFS is worth learning first. A formula like =SUMIFS(Sales!C:C, Sales!A:A, "SKU-2200") totals every sale of that SKU regardless of which marketplace column it came from, per Microsoft’s SUMIFS documentation. That one formula replaces manually adding figures from Shopee SG’s seller centre and Lazada SG’s seller centre by hand.
XLOOKUP earns its place once the workbook grows past one sheet. If a master SKU list lives on one tab and Lazada SG order data lives on another, XLOOKUP carries the current stock figure across without retyping it, which is where most copy-paste errors happen in a shared file.
Sellers on Google Sheets can use the same three functions under nearly identical names, so switching spreadsheet tools doesn’t mean relearning the formulas.
Where Does an Excel System Break Down for Singapore’s Multi-Channel Sellers?
Excel has no concept of “right now.” Every cell reflects whatever was last typed in, not the live count sitting on Shopee SG or Lazada SG at this exact moment.
That gap creates a specific failure pattern for sellers running more than one channel:
- Update lag. Between a sale landing on Shopee SG and someone subtracting it from the spreadsheet, there’s a window. A Lazada SG buyer can purchase the same physical unit during that window, forcing a cancellation once the oversell surfaces.
- Version conflicts. Once two or more staff open and edit the same workbook, whoever saves last overwrites the other person’s update, unless the file lives in a shared, real-time cloud version.
- No audit trail. Dedicated software logs who changed a count and when. A spreadsheet cell just shows the current number, with nothing recording what it read an hour earlier or who touched it.
- Delivery speed raises the stakes. Singapore buyers expect fast turnaround, and couriers like Ninja Van SG, Qxpress, SingPost, and J&T SG are built around next-day and same-island delivery windows. A stock error that would be a minor delay elsewhere becomes a cancelled order and a bad review here, because there’s little slack in the fulfillment timeline to quietly correct it.
- Manual entry doesn’t scale with order spikes. Updating stock for a normal day’s orders takes minutes. During a Shopee SG 9.9 or Lazada SG 11.11 sale event, order volume can spike well past what manual updates can keep pace with.
Still tracking stock across Shopee SG and Lazada SG in a spreadsheet? Check whether your reorder timing actually holds up under real sale-day volume. Try the free reorder point calculator. 2 minutes. Free. No signup.
None of this makes Excel a bad tool. It means Excel was never built to solve a live, multi-user, multi-channel sync problem, and no combination of formulas changes that underlying limitation.
When Should You Move From Excel to Dedicated Inventory Software?
The switch usually makes sense once one or more of these signals show up, based on seller community reports and patterns InventoryFlow has tracked across Singapore multi-channel operators.
| Signal | Excel | Dedicated Software |
|---|---|---|
| SKU count | Manageable under roughly 100-150 | Handles hundreds to thousands |
| Real-time multi-channel sync | No, manual only | Yes, via API |
| Multiple staff editing at once | Version conflict risk | Built-in permissions and audit trail |
| Setup effort | Low, build it yourself | Higher, connect each channel |
| Ongoing cost | Free | Typically from around S$120-250/month, depending on tool and tier |
If overselling incidents keep repeating, if stock updates are eating more than an hour a day, or if the store now runs three or more active channels, that’s generally the point where dedicated software pays for itself in avoided cancellations and freed-up time. Start by comparing options against your own SKU count and channel mix on our Ecommerce Inventory Management hub for Singapore, which covers the criteria that matter most for a local setup.
If SKU count and channel count are still under that threshold, a well-built Excel tracker using the formulas above, paired with the free SKU generator and safety stock calculator, is a reasonable place to stay for now.
Frequently Asked Questions
Can Excel work as inventory software for a Singapore ecommerce store?
Yes, for single-channel sellers with a lean SKU count. Excel handles SKU tracking, reorder points, and sales totals well when one person updates it consistently. Add a second marketplace like Lazada SG, and the manual update gap between platforms starts creating overselling risk that formulas alone cannot close.
What formulas do I need to build an inventory tracker in Excel?
SUMIFS totals sales per SKU across channel columns, XLOOKUP pulls stock counts from a master sheet into channel tabs, and COUNTIFS flags how many SKUs sit below their reorder point. These three functions, documented in Microsoft’s official function reference, cover most of what a basic tracker needs.
Does Excel sync automatically with Shopee SG and Lazada SG orders?
No. Excel has no live connection to marketplace seller centres. Every stock figure reflects whatever a person last typed in, not the actual count on Shopee SG or Lazada SG right now. Closing that gap requires either a manual export-and-update routine or dedicated inventory software with an API connection.
How many SKUs can a Singapore seller manage in Excel before switching?
Single-channel sellers with under roughly 100 SKUs often manage fine in a spreadsheet. Once SKU count climbs past 150 to 200 across two or more marketplaces, or once a second staff member starts editing the same file, version conflicts and update lag tend to start causing stockouts, based on seller community reports.
What inventory software replaces Excel for Singapore multi-channel sellers?
Tools like Ginee, Zoho Inventory, and Sellercraft connect directly to Shopee SG and Lazada SG seller accounts through an API, syncing stock levels in real time as orders arrive. That removes the manual update step, which is the main point of failure in a spreadsheet-based system.
