Intro and mindset
- Inventory is the second pillar of an Amazon brand. After your core offers and products, inventory comes next.
- Going out of stock is the most expensive thing that can happen to your products. When it does, you lose the momentum, revenue and profit those days should have brought, and that revenue goes to your direct competitors: they grow their sales, improve their rankings, raise their profits and expand their ad budgets at your expense.
- Put simply: nothing you do to improve PPC, organic ranking, profit, content or main images matters while you're out of stock.
- That's why, without a solid inventory management system, this is where most of your attention must go before you try to grow the brand further.
- If you've gone out of stock regularly over the past 12 months, putting a solid system in place from now on could be worth a very large amount of extra revenue.
Team structure for inventory management
For context, this is how the SOP's authors ran inventory at their busiest: 40+ listings, hundreds of child ASINs, 8 marketplaces, and dozens of freights and purchase orders in progress at any time.
- 1 VA full-time, working with suppliers
Regular contact with suppliers; coordinating inspections for every order; checking barcodes, invoices and quantities; keeping all order documents; handling product improvements based on negative feedback.
- 1 VA full-time, working with the freight forwarder
Regular contact with the forwarder; coordinating, tracking and monitoring all freight; collecting quotes and picking the cheapest; checking invoices match quotes; keeping records; handling the Amazon reconciliation process.
- 1 VA at about 75% capacity, managing 3PLs
Overseeing 3PLs in the US, UK, Canada and Europe; tracking their data and logistics; communicating with them; checking payments are correct.
- 1 senior VA, paid about 2.5 times the standard rate
Managing the other three VAs, supporting them, answering questions and keeping everything running smoothly.
- That setup was more than most brands need, but it worked very well. The point is how important this department is.
- Don't get it wrong. Inventory management isn't complicated: the work just has to be done correctly, the basics covered, and the main goal met: not going out of stock.
- Long-term plan: work on your business, not in it. Build the system first, use it and perfect it, then hire VAs to replace you, task by task.
Inventory levels table: creation and analysis
- One of your most important processes is checking inventory levels against sales levels every week.
- For example, if your stock was planned for 50 units a day and sales grow to 75 a day (1.5 times), you must react to that change and, above all, know about it. The same applies the other way: planned for 50 a day but now selling only 30.
- Build the table from your Seller Central data: the app's Inventory Levels page does it for you, or use a Google Sheet linked to Sellerboard through its API.
- It shows every child ASIN with live data on available, reserved and inbound units.
- Once it's ready, check it every week. The SOP's authors reviewed it in the first meeting of each week, when they went over the previous week's numbers.
Your goals for this process:
- Monitor weekly to find child ASINs that might go out of stock
- For products running low, follow the next guide
Maximize profits when your product is about to go out of stock.
- Watch products that did go out of stock
When the inventory is received, push back to normal sales levels as quickly as possible.
What the table contains
| Column | What it shows |
|---|---|
| Sales velocity | Average units sold a day, over the last 3, 7, 14 and 30 days |
| FBA active, reserved, inbound | Units ready to sell, units held by Amazon, and units on their way into FBA |
| FBA full | Active + reserved + inbound |
| AWD | Units in Amazon Warehousing and Distribution, including those on the way |
| Warehouse stock | Units in your own warehouse or a 3PL |
| DOI FBA (active) | Days of inventory: FBA active ÷ velocity |
| DOI FBA (full) | FBA full ÷ velocity |
| Marketplace DOI | (FBA full + AWD + warehouse) ÷ velocity |
| Expected out-of-stock date | Today + marketplace DOI, not counting purchase orders |
| Status | FBA DOI | Total DOI |
|---|---|---|
| Out of stock | 0 days | 0 days |
| Will go out of stock | Under 14 days | Under 90 days |
| Low | Under 60 days | Under 120 days |
| Ideal | Under 90 days | Under 200 days |
| High | Over 90 days | Over 200 days |
Weekly inventory table
| Child ASIN | Velocity | FBA full | DOI FBA | Marketplace DOI | Status |
|---|---|---|---|---|---|
| Blue, large | 42 / day | 2,900 | 69 | 131 | Ideal |
| Blue, small | 38 / day | 760 | 20 | 58 | Low |
| Grey, large | 25 / day | 240 | 10 | 10 | Will go OOS |
| Grey, small | 6 / day | 1,350 | 225 | 260 | High |
Checklist
- Inventory levels table set up per child ASIN
- Reviewed every week, in a fixed meeting
- Products at risk of going out of stock flagged
- Roles set for suppliers, freight and 3PLs
Related guides
- Maximize profits when your product is about to go out of stockSlow your sales down and raise profit per unit until the next inventory batch arrives: monitor stock, set a daily sales limit, then adjust…
- Inventory planning: 5 key principlesHow to decide your next purchase orders: a six-month forecast, monthly POs that keep six months in the cycle, buffers, best sellers first…
- Avoiding the low-inventory-level feeWhen Amazon adds a low-inventory-level fee to FBA orders, how to see which products are at risk, how to find what you've already paid, and…
