Amz Consultors logo Amz Consultors AutomationBook a free strategy call

Inventory Management · Forecasting & planning

Inventory management system

Why inventory is the second pillar of an Amazon brand, the team that runs it, and the weekly inventory levels table that stops products going out of stock.

Updated Oct 18, 20264 min readWho: Founder at first, then an inventory teamHow often: Inventory levels table every week; purchase orders every month

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. 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.

  2. 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.

  3. 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.

  4. 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:

  1. Monitor weekly to find child ASINs that might go out of stock
  2. For products running low, follow the next guide

    Maximize profits when your product is about to go out of stock.

  3. 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

ColumnWhat it shows
Sales velocityAverage units sold a day, over the last 3, 7, 14 and 30 days
FBA active, reserved, inboundUnits ready to sell, units held by Amazon, and units on their way into FBA
FBA fullActive + reserved + inbound
AWDUnits in Amazon Warehousing and Distribution, including those on the way
Warehouse stockUnits 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 dateToday + marketplace DOI, not counting purchase orders
Status colours in the template (adjust to your lead times)
StatusFBA DOITotal DOI
Out of stock0 days0 days
Will go out of stockUnder 14 daysUnder 90 days
LowUnder 60 daysUnder 120 days
IdealUnder 90 daysUnder 200 days
HighOver 90 daysOver 200 days
Inventory Levels

Weekly inventory table

Child ASINVelocityFBA fullDOI FBAMarketplace DOIStatus
Blue, large42 / day2,90069131Ideal
Blue, small38 / day7602058Low
Grey, large25 / day2401010Will go OOS
Grey, small6 / day1,350225260High
An illustration with made-up products.

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

Want this done for you?

We run advertising, listings and account health for Amazon, Walmart and eBay brands. Start with a free review of your account.