Inventory Planning for Etsy and Amazon Sellers: Avoid Stockouts, Dead Stock, and Cash Traps
Inventory is one of the hardest parts of ecommerce because it affects both sales and cash flow. Too little inventory creates stockouts and lost momentum. Too much inventory creates dead stock, storage cost, and trapped cash. The goal is not simply to buy more. The goal is to buy the right amount at the right time.
Why inventory planning matters
Inventory is cash in physical form. Every unit sitting on a shelf or in a fulfillment center represents money that cannot be used elsewhere. If that inventory sells quickly at a healthy margin, it is productive. If it sits too long, it becomes a cash trap.
Etsy sellers often face material and component planning. Amazon sellers often face finished goods planning. Both need visibility into sell-through, lead time, margin, and reorder timing.
Sell-through rate
Sell-through measures how quickly inventory turns into sales. A product that sells 100 units per month behaves very differently from a product that sells 5 units per month. Reorder decisions should be based on velocity, not only current stock count.
A simple estimate:
Days of inventory left = current stock / average daily sales.
If a product has 60 units in stock and sells 3 units per day, it has about 20 days of inventory left.
Lead time
Lead time is the number of days between deciding to reorder and having inventory ready to sell. It can include supplier production, shipping, receiving, prep, labeling, and marketplace check-in time.
If your lead time is 30 days, reordering when you have 10 days of inventory left is too late. The reorder point must happen before the stockout risk becomes urgent.
Reorder point
A practical reorder point formula is:
Reorder point = average daily sales x lead time days + safety stock.
Safety stock protects against demand spikes, supplier delays, damaged inventory, and forecasting errors.
Dead stock
Dead stock is inventory that is not moving. It can happen because demand changed, competition increased, pricing is wrong, listing quality is weak, or the product was over-ordered. Dead stock is dangerous because it quietly consumes cash and attention.
Dead stock decisions should be made rationally. Sometimes the right move is discounting. Sometimes it is bundling. Sometimes it is improving the listing. Sometimes it is accepting the loss and freeing cash.
Margin and inventory decisions
Not all products deserve the same inventory investment. A fast-moving low-margin product may be useful, but it should not starve higher-margin products of cash. A slow-moving high-margin product may still be attractive if demand is predictable and storage cost is low.
Use profit tools like the Etsy Profit Calculator and Amazon Seller Profit Calculator to understand which products deserve more working capital.
Inventory planning for handmade sellers
Handmade sellers must plan both finished products and materials. Running out of one small component can stop production even if every other material is available. A BOM-based system helps identify which component limits production capacity.
For example, a seller may have enough wax for 200 candles but only enough jars for 40. The true production capacity is 40, not 200.
Inventory planning for Amazon sellers
Amazon sellers must consider supplier lead time, inbound shipping, fulfillment center receiving time, storage cost, and account-level inventory limits. Reordering too late can lose ranking momentum. Reordering too aggressively can create storage and cash problems.
Final takeaway
Good inventory planning balances sales opportunity with cash discipline. Sellers should track velocity, lead time, reorder points, safety stock, and product-level profit. Inventory should support growth, not hide problems.
Disclaimer: This article is educational and does not provide financial, tax, or legal advice.