Perpetual inventory system for ecommerce brands: how live stock counts work
A perpetual inventory system updates your stock count every time stock moves, whether that is an order, a receipt, a return or a transfer. Every sales channel reads from that one running record, so a Shopify order and an Amazon order reduce the same count.
That matters most in a peak week, when a monthly count goes stale within days. A spreadsheet updated on Fridays can't keep up with orders from several channels.
This guide explains how the count moves and why it still drifts. A switching checklist closes it out.
Perpetual inventory system, defined
A perpetual inventory system is a stock tracking method that updates the quantity on hand after every transaction. Sales, purchase receipts, returns, transfers and adjustments all move the count. The running balance follows one formula: beginning inventory plus receipts minus shipments equals ending inventory. Physical counts then check that the record matches the shelf.
What is a perpetual inventory system?
A perpetual inventory system is an inventory method that keeps a running stock balance and changes it each time a transaction is recorded. Some teams call it a continuous inventory system.
The Wikipedia entry on perpetual inventory describes the quantity as updating continuously as business happens. The formula is simple: beginning inventory + receipts - shipments = ending inventory.
In ecommerce, five kinds of events move that number:
- Orders shipped from a webshop, a marketplace or a wholesale account.
- Purchase receipts from suppliers.
- Customer returns put back into sellable stock.
- Transfers between warehouses or stores.
- Adjustments for damaged, lost or found units.
Perpetual inventory example for one SKU
A perpetual inventory example makes the formula concrete. The table uses example numbers for one SKU in one warehouse over one day.
| Event (example) | Source | Change | Running count |
|---|---|---|---|
| Opening balance | Last record | 120 | |
| Supplier receipt | Purchase order | +50 | 170 |
| Order shipped | Shopify webshop | -4 | 166 |
| Order shipped | Amazon | -2 | 164 |
| Customer return | WooCommerce store | +1 | 165 |
| Transfer out | To a second warehouse | -15 | 150 |
| Adjustment | One damaged unit | -1 | 149 |
In this example, 120 units + 51 received (including the return) - 22 out = 149 units. Each row changed the count when it happened, so nobody had to walk the shelves.
How does perpetual inventory differ from periodic inventory?
Perpetual inventory differs from periodic inventory in timing. Perpetual updates the count with every transaction, while periodic updates it only after a physical count at the end of a period.
The difference reaches your books too. The inventory valuation overview explains that a perpetual system records cost of goods sold with each sale. A periodic system works it out at period end.
| Question | Perpetual inventory | Periodic inventory |
|---|---|---|
| When does the count change? | With every transaction | After a physical count at period end |
| When is cost of goods sold recorded? | With each sale | At period end |
| What do you see between counts? | A running balance | The last count only |
| Are physical counts still needed? | Yes, to correct drift | Yes, they produce the numbers |
For a brand with one shop and one stockroom, periodic counts can work. Once several channels draw on the same units, the gap between counts is where overselling happens.
Why does real-time inventory tracking matter for ecommerce brands?
Real-time inventory tracking matters for ecommerce brands because every channel sells from one shared pool of stock. A count that is a week old can look healthy while the shelf is already empty.
Peak weeks expose this fastest. Orders arrive from Shopify, WooCommerce, Amazon and EU marketplaces at the same time, and static spreadsheets can't keep pace.
A perpetual record moves with each order, so every channel starts from the latest number. How that shared number is split across channels, with buffers and reserved stock, is a separate topic. The multichannel inventory management guide covers it in detail.
How do warehouse bins and barcodes support perpetual stock tracking?
Warehouse bins and barcodes support perpetual stock tracking by turning each physical move into a recorded transaction. A scan at receiving or picking tells the system which unit moved and where it went.
Why perpetual counts still drift
Perpetual counts still drift because the record only knows what gets scanned. The perpetual inventory article lists theft, breakage, scanning errors and untracked movements as causes. The resulting gap is called phantom inventory.
Phantom inventory hurts multi-channel sellers twice. Channels show stock you can't ship, and reorders never trigger because the system thinks units are on hand.
How cycle counts keep the record accurate
Cycle counts keep the record accurate by checking a few bins on a schedule. The warehouse never has to close for one big count. The inventory valuation overview notes that a physical count at least annually is good practice, even with a perpetual system.
Bin-level data makes cycle counts practical. Prim.io's all-in-one cloud ERP covers inventory, warehouse bins, barcodes, serial numbers, and expiry dates, so a discrepancy points to one location and one batch.
The same logic scales to several sites. OhGood manages 3 warehouses in one live view using Prim.io. Location setup is covered in the guide to ERP inventory management.
How Prim.io handles perpetual inventory
Prim.io handles perpetual inventory by posting every order, receipt, return and transfer to one stock record shared by warehouse and finance. Prim.io is a cloud ERP with built-in AI for ecommerce and multi-channel brands, running orders, stock, finance, CRM, production and BI in one system.
Orders from webshops, marketplaces, wholesale and stores arrive through native channel integrations and draw down the same count. When a sale lands, the warehouse knows and the accounts update with it.
Across customers, Prim.io handles 3.1M+ orders per month.
The Prim.io AI assistant answers questions from your company's own sales, stock and finance data. Prim.io MCP connects Claude, ChatGPT and Cursor, with per-user permissions and approval before any change.
See every module on the Prim.io ERP platform page.
Free demo account, no credit card needed, cancel anytime.
Why ecommerce brands choose Prim.io
Ecommerce brands choose Prim.io because stock and finance share one system. If you are still comparing tools, the ecommerce inventory management software guide lists what to check.
- 50+ native integrations, plus an API for custom connections.
- BI powered by Qlik for stock and margin reporting.
- Purchasing and landed cost in the same record as stock.
- Manufacturing with BOMs and multi-company setups for groups with several entities.
Compare plans on the Prim.io pricing page.
Frequently asked questions about perpetual inventory
Multi-channel brands ask the following perpetual inventory questions most often.
What is perpetual inventory?
Perpetual inventory is a tracking method that updates stock quantities after every transaction instead of waiting for a scheduled count. Sales, supplier receipts, returns, transfers and adjustments each change the running balance. The formula is beginning inventory plus receipts minus shipments equals ending inventory, so the current number is available without counting shelves.
How does stock update across channels?
Stock updates across channels when each order posts to one shared inventory record. An order from Shopify, WooCommerce, Amazon or an EU marketplace reduces the same count, and the new quantity goes back to the other connected channels. How fast each channel receives the update depends on that channel's connector.
Why do brands switch from periodic to perpetual?
Brands switch from periodic to perpetual inventory because a periodic count goes stale soon after it is taken. With several channels selling one pool of stock, stale numbers cause overselling during peaks. Perpetual systems also record cost of goods sold with each sale, so margins are visible during the month.
Do you still need physical counts with a perpetual system?
Yes, physical counts are still needed with a perpetual system. Theft, breakage, scanning errors and untracked movements create phantom inventory that the record cannot see. A full physical count at least annually is good practice, and regular cycle counts of individual bins catch drift between those full counts.
How does live stock tracking prevent stockouts?
Live stock tracking helps prevent stockouts by showing the true quantity on hand while there is still time to reorder. Each sale lowers the count, so low stock shows up as it happens instead of at the next count. Channels reading the shared count are also less likely to sell units that are already gone.
Perpetual inventory checklist for multi-channel brands
A perpetual inventory system keeps stock accurate when every movement is recorded and checked against the shelf. Use this checklist to move from periodic counts to live stock.
- Switch from periodic manual stock checks to perpetual tracking.
- Implement barcode scanning and bin locations.
- Sync stock levels across all sales channels to prevent overselling.
- Monitor serial numbers and expiry dates for traceability.
- Review multi-warehouse inventory views in real time.
Start with whichever step causes the most overselling.
Free demo account, no credit card needed, cancel anytime.
Meet an expert
Prefer to talk? Call our team directly.
Explore more success stories
ERP inventory management: how stock works across warehouses, 3PLs and channels
Ready to see it for yourself?
The best way to understand Prim.io is to try it. Start with a free demo account and explore at your own pace.