Inventory
Access from: Profitability → Inventory
Inventory tells you how much money you have sitting in Amazon's warehouses (FBA), valued at your product cost: the tied-up capital. It also tells you how long each stock lasts at the pace you sell, which products are heading for the aged inventory surcharge and how much storage you will pay until everything sells.
It is today's stock: it has no period.
Which stock counts
- Only the stock in Amazon's warehouses for your Seller connections. It does not include your own warehouse or Vendor: on Vendor the stock already belongs to Amazon.
- Only the products active in Epinium, and only the stock Epinium has synced from Amazon in the last 7 days.
- One row per stock. In the EU, Amazon shares a single stock across every country, so a pan-European SKU shows once, with all its countries in the Countries column, not once per country. The UK, the US and the other marketplaces each have their own stock.
Tied-up capital
Tied-up capital is the stock's units times its cost per unit (product cost plus shipping cost): what you have paid and not yet recovered. It is not an expense, it is money sitting idle.
The units are the ones in Amazon's warehouse and unsold, including those moving between warehouses. Units reserved for orders (already sold), inbound units and unsellable units do not count.
A product without product cost does not count in the capital: above the table a notice tells you how many products were left out, with the Add costs button, and each rotation card tells you how many of its products lack a cost. You can also load it in Costs and expenses so the capital is the real one.
Rotation
Each stock has a rotation based on its days of stock: how many days it lasts if you sell as in the last 90 days (up to the last day with sales Amazon has sent and at most up to 14 days ago; fewer days if your sales history is shorter), adding every country of its stock and subtracting refunds. If the product reached Amazon partway through those 90 days, it is measured from its first day in the warehouse.
| Rotation | How long it lasts |
|---|---|
| Low stock | Under 28 days. You may run out of stock, and Amazon charges a low-inventory fee. |
| Healthy | 28 to 89 days. |
| Excess | 90 to 240 days (90 to 180 in the United States): money sitting idle and storage piling up. |
| Surcharge risk | More than 240 days (180 in the United States). At this pace, the last units will reach the aged inventory surcharge Amazon charges from day 241 in the EU and the UK and from day 181 in the United States. Other marketplaces use the EU day. |
| No sales | It has stock and in the last 90 days it has sold nothing, or everything it sold was returned. |
Rotation measures how long the stock will last, not how long it has been in the warehouse: a product at Surcharge risk does not pay it yet, but will pay it on part of its stock if it keeps selling the same way.
Indicators
- Tied-up capital: that of all your stock with a cost, and how many products you have at Amazon.
- Capital at risk: the part of the capital in Excess, Surcharge risk and No sales, and what share of the total it is. It is the money that takes more than 90 days to sell, or doesn't sell.
- Storage until sold: what we estimate you will pay in storage until all the stock sells at the current pace. Below it, what Amazon charged you in the last month already billed.
- One card per rotation, with its capital and how many products it has (and how many of them lack a cost).
The indicators count all the stock in the connection, country and cluster filters. They do not change with the rotation filter or the search, which only filter the table.
Storage until sold
It is an estimate: the storage Amazon charged you per unit in the last month already billed, times the units you will have left each month at the current pace. From October to December it uses the higher rate of those months. It has two limits:
- A maximum of 12 months. If the stock takes longer to sell, or does not sell, the figure is a minimum.
- It does not include the aged inventory surcharge, only regular storage.
The table
| Column | What it is |
|---|---|
| Countries | The countries that share this stock. |
| Rotation | Low stock, Healthy, Excess, Surcharge risk or No sales. |
| Units | In Amazon's warehouse and unsold. |
| Cost per unit | Product cost plus shipping cost, per unit. |
| Tied-up capital | Units times cost per unit. |
| Days of stock | How many days the stock lasts at the pace of the last 90 days. |
| Storage last month | What Amazon charged you in storage for this stock in the last month already billed. |
| Storage until sold | What we estimate you will pay in storage until it sells. |
| Inbound stock | Sent to Amazon and not received yet: they do not pay storage yet. |
| Unsellable | Damaged, defective or under review by Amazon. They do not count in the capital. |
With Edit columns you can add ASIN, Sales per day, Runs out on (when the stock runs out at the current pace), Inbound capital (what the inbound units are worth at cost), Storage per unit, Reserved and Total at Amazon (everything Amazon has or is receiving, the figure you see in Seller Central).
The table is sorted by tied-up capital, from highest to lowest. Clicking the SKU or the title opens the product page. With the search box you filter by SKU, ASIN or title.
Filters
- Connection, Country and Clusters, as in the P&L.
- Rotation: keeps the stocks of the rotations you select.
Currency
All amounts are in your account currency. Product cost is converted at the latest exchange rate available, and storage at the rate of each day it was charged.
Available on Business and Master
Inventory is on the Business and Master plans: the capital is valued at product cost. On other plans it shows in the menu with a crown and, when you click it, offers you to upgrade.
From the API and the MCP
The same data is in the public API (/v1/pnl/inventory) and in the MCP, so an assistant can tell you how much money you have sitting idle and which stock you should move. On Free and Guru they respond with a 403.