Your best-selling product sold out three days into a Facebook campaign. That campaign had finally hit 2X ROAS. Meanwhile, $20,000 sits in boxes of things nobody has bought since January.
This e-commerce inventory management checklist replaces the guesswork with formulas.
You are not disorganized. You are guessing. And guessing about inventory is expensive.
Most inventory checklists are written for warehouses with loading docks and inventory managers. That is not you. You run a Shopify or WooCommerce store with two to ten people.
No ops manager. No inventory analyst. Just you and a spreadsheet you stopped updating in November.
The advice online tells you what to track. SKUs. Reorder markers. Cycle counts.
But it never tells you how to calculate anything for a store doing $250K to $1M in revenue.
This post gives you the formulas. It gives you the specific thresholds. It gives you a system you can run in 30 minutes per week.
What’s the biggest mistake in managing inventory for a small e-commerce store?
The biggest mistake is ordering extra units "just to be safe" evenly across your entire catalog. This traps $15,000 to $40,000 in slow-moving stock. Meanwhile your actual best-sellers still run dry.
Safety stock without SKU-level demand data is just expensive hope.
Here is what most store owners do. Supplier lead times get unpredictable. So they add 10 or 20 extra units per order across every product line.
It feels responsible. It feels conservative. The logic goes: nobody gets fired for having too much inventory.
Here is what it actually costs. A store doing $500,000 in annual revenue typically carries 80 to 150 SKUs. About 15 to 20 of those generate 80 percent of sales.
The "just-in-case" buffer applied evenly means stocking 15 extra units of a bag that sells one unit per quarter.
That is $375 in cash locked up in one SKU at a $25 landed cost. Multiply that across 100 C-tier items. You sit on $20,000 to $37,500 in dead inventory.
Your top 12 products still stock out because their buffer was identical to everything else despite selling 20 times faster.
The 20 percent move that works: ABC analysis. Pull your last 90 days of sales data. Rank every SKU by revenue contribution.
Identify your A items — the top 20 percent of SKUs driving roughly 80 percent of revenue.
Calculate reorder points for only those A items using the formula below. Skip B and C items for now. This single move prevents 60 to 70 percent of revenue-impacting stockouts within two weeks.
A Shopify store selling home organization products at $30K per month did exactly this. They carried 95 SKUs. Their top eight products stocked out every month.
They ran an ABC analysis in one afternoon.
They found 14 A SKUs driving 77 percent of revenue. They built reorder point calculations for those 14 items only. Within three weeks, stockouts on best-sellers dropped from eight per month to one.
They never touched 81 of their SKUs. They didn’t need to.
What are the essential steps on an e-commerce inventory management checklist for a store under $1M?
Only three steps matter for a store under $1 million. Track what moves. Automate alerts on your A items.
Clear dead stock every quarter. The 40-point checklists on Shopify’s blog cover things a solo operator never needs to do.
Cut the noise.
A two-person team needs a small surface area to manage. Three routines cover 90 percent of the inventory risk.
The goal is not perfect inventory management. The goal is not losing money to stockouts while cash rots in slow-moving SKUs.
First, maintain a SKU-level record with three data points per product. Track current stock count. Track average daily units sold over the last 90 days.
Track supplier lead time in days.
Do not track anything else until these three numbers are reliable. A Google Sheet handles this for stores with fewer than 200 SKUs. Shopify and WooCommerce surface all three data points natively.
Second, set automated low-stock alerts on your A items only. Use the reorder point formula: (average daily units sold × supplier lead time in days) × 1.3. When stock hits that threshold, your system notifies you immediately.
Not next month. Not when you happen to check the dashboard.
Third, run a dead stock audit every 90 days. Flag any SKU that has not sold a single unit in the trailing 12 weeks. Mark it down, bundle it, or liquidate it.
Cash tied up in dead stock is cash unavailable for reordering your actual revenue drivers.
A WooCommerce store selling specialty coffee at $15K per month set up these three routines. The owner spent 90 minutes building the tracking sheet. They spent 20 minutes per week updating it.
Inventory accuracy went from roughly 70 percent — eyeballing stock in the garage — to near 97 percent. The owner freed $8,500 in cash by liquidating 30 slow-moving coffee accessory SKUs in the first quarter. That cash funded a larger purchase order for their three best-selling beans, which had been stocking out every six weeks.
How can I prevent stockouts without overstocking in my online store?
You prevent stockouts without overstocking by calculating reorder points per SKU using actual demand velocity. Gut instinct says order 50 more of everything. The formula says order 200 of one product and zero of seventeen others.
Trust the formula.
Most small stores oscillate between stockouts and overstocks because they lack a reorder trigger tied to real data. They reorder when they "feel like it’s time." Or they reorder when a supplier emails them.
Both produce wrong outcomes for different products.
A proper reorder point accounts for three variables. How fast you sell. How long the supplier takes.
How much volatility you need to absorb.
The calculation in full:
Average daily units sold equals total units sold over 90 days divided by 90. Supplier lead time is the average number of days from purchase order submission to goods-in-hand. The safety buffer is a multiplier of 1.3 for stable suppliers with consistent lead times.
Use 1.5 if lead times swing by more than five days. Use 2.0 if your supplier is unreliable.
Then: reorder point equals (average daily units sold × lead time in days) multiplied by your safety buffer.
An example with numbers. You sell a ceramic planter that moves four units per day on average. Your supplier takes 14 days to deliver.
Your reorder point is (4 × 14) × 1.3.
That equals 72.8. Round up to 73. When your inventory drops to 73 units, you place a reorder.
Not 50 units. Not 100 units. Seventy-three.
Do not apply a blanket formula across everything. Run this calculation for your A items first. Your C items need a different approach — primarily, stop ordering them until proven otherwise.
Overstocking disappears when every reorder decision ties back to a number. You stop buying extra because it feels safe. You buy exactly what the data demands.
A $20K-per-month baby products store applied this method to their top 18 SKUs. They previously reordered using a flat "two weeks of stock" rule across all products. Their fastest seller moved 12 units daily.
Their slowest A item moved three units daily. Same rule for both.
After switching to velocity-based reorder points, total inventory value dropped from $65,000 to $41,000 in 60 days. Stockouts on their number one product hit zero for the first time in nine months.
What’s the 20-minute shortcut that actually fixes inventory for a store under $500K?
Pull your last 90 days of sales data by SKU today. Rank every product by revenue contribution. Identify your A items — roughly 20 percent of SKUs generating about 80 percent of revenue.
Calculate reorder points for those A items only.
Skip B and C items for now. This move prevents most revenue-impacting stockouts in under two weeks.
No new headcount. No new software.
Why this works: inventory problems for small stores are not "we don’t have enough stock." They are "we don’t have enough of the right stock." Fixing the right stock takes 20 minutes of sorting a spreadsheet column.
The math is aggressive because it assumes you have been guessing. Most stores find that assumption is accurate.
Here is the exact process.
Open your sales report for the trailing 90 days. Export it. Add a column for revenue contribution per SKU.
Sort descending. Add a cumulative percentage column next to it. Draw the line at 80 percent cumulative revenue.
Every SKU above that line is an A item. Every SKU between 80 and 95 percent is B. Everything below 95 percent is C.
Your A items get the full reorder point calculation: (average daily units sold × lead time) × 1.3 safety buffer. Set a low-stock alert in your platform at that number.
Your B items get a lighter treatment. Set a reorder point using the lead time calculation without the safety buffer. Review them monthly.
Your C items get reviewed once per quarter with one question: do I reorder this or kill it? Most will be killed. That frees up cash.
This is not lazy. It is targeted. You invest precision where precision pays.
You invest neglect where neglect costs nothing.
A $350K-per-year apparel store did this during a single lunch break. Out of 120 SKUs, 22 were A items. Eighteen of those 22 had no reorder logic at all before the exercise.
The owner was reordering everything on a generic "monthly restock" calendar. Within two weeks of setting alerts on the A items, the store avoided three stockouts. Those avoided stockouts saved roughly $8,400 in lost sales, based on average order value and daily velocity.
The owner also identified 40 C items with zero sales in three months. They halved reorder quantities for those items. That freed $5,200 in working capital.
What inventory management software is best for small e-commerce businesses?
For stores under $500K in annual revenue, the best tool is what you already use. Shopify or WooCommerce with built-in inventory tracking. Plus a spreadsheet for ABC analysis.
Paid inventory software earns its cost around $750K to $1M in revenue, when SKU counts typically cross 150 and manual tracking breaks.
Three tools cover the spectrum for small e-commerce operations.
Shopify’s native inventory system handles low-stock alerts, multi-location tracking, and demand reports. It costs nothing beyond your subscription. It works for stores with under 200 SKUs.
The limitation: it does not calculate reorder points or safety stock automatically. You build those formulas yourself and plug the thresholds into the alert settings.
TradeGecko, now QuickBooks Commerce, adds demand forecasting and automated purchase order generation. It starts around $39 per month. Implementation takes two to four hours for a store with under 100 SKUs.
It makes sense once you hit 80 to 100 SKUs where manual reorder point calculations become a weekly chore.
Cin7 targets multi-channel inventory sync across Shopify, Amazon, and wholesale accounts. Pricing runs $300 to $500 per month. Implementation takes a full workday plus cleanup.
It justifies its cost only when you sell across three or more channels and manual syncing causes regular overselling.
The mistake most small stores make: buying software before fixing their data. A spreadsheet with accurate daily sales velocity and lead time numbers beats an expensive platform filled with wrong inputs. Every time.
Get your ABC analysis done first. Get your reorder points calculated. Let your software decision follow your process, not the reverse.
A $480K-per-year home decor store using WooCommerce ran their entire inventory system in a Google Sheet for two years. The owner spent 30 minutes every Monday updating stock levels and checking reorder thresholds for 22 A items.
They switched to TradeGecko at $59 per month only after SKU count crossed 140. Spreadsheet maintenance had hit two hours per week.
The move saved roughly 90 minutes per week. At their effective hourly rate of $75, that paid back the software cost in the first month.
What should you expect after implementing these inventory changes?
Expect two things within the first 60 days. Stockouts on your A items drop by 60 to 70 percent. You identify $15,000 to $30,000 in trapped cash from slow-moving inventory.
The cash does not appear by magic. It appears because you stop reordering product nobody buys.
Week one: data extraction and ABC classification. This takes 60 to 90 minutes. You pull sales data, rank by revenue, and identify your A, B, and C tiers.
No software required. Just a CSV export and a sort function.
Week two: calculation. You determine average daily sales velocity for each A item. You confirm supplier lead times — not what suppliers promise, but what you actually experience based on delivery records.
You multiply and set your reorder points. You configure low-stock alerts in your platform. This takes two to three hours total.
Week four brings the first real test. A low-stock alert fires for one of your best-sellers. You place the reorder with time to spare.
The order arrives before you hit zero. You lose zero sales and avoid the stockout entirely.
Week eight brings a dead stock decision. You review your C-tier items. You see products that sat untouched since your last quarter.
You mark them down, bundle them with best-sellers, or donate them for a tax write-off.
Cash recovers. Shelf space clears. Mental load drops.
The timeline is not theoretical. A $42K-per-month pet supplies store tracked their progress after implementing this system. At week two, they had 17 A items with active reorder points.
At week four, stockout alerts had triggered four times. All four reorders arrived before inventory hit zero.
At week eight, they identified $17,500 in dead stock. A flash sale cleared $9,200 of it.
By week twelve, total inventory value dropped from $78,000 to $54,000. Their best-seller stockout rate went from twice monthly to zero for three consecutive months.
The system does not require perfection. It requires consistency — 30 minutes per week updating stock counts and verifying alerts. The arithmetic is not complicated.
The discipline separates two kinds of stores. Some run out of both product and cash. Others run out of neither.
Your inventory is not a storage problem. It is a cash flow problem wearing a box of unsold SKUs. Fix the right 20 percent of it this week.
You stop the bleed before the next restock cycle hits.
