Amazon FBA Restock & Inventory Planner

About the Amazon FBA Restock & Inventory Planner

Plans what to reorder for every SKU you sell through Fulfillment by Amazon, from the reports you already download. Open the FBA Inventory report (or the Restock Inventory report), add the All Orders report for the sales history if you like, the stranded inventory report, and a supplier sheet with each SKU's lead time, days to reach Amazon, case pack, minimum order, unit cost, stock in your own warehouse and what is already on order.

For each SKU you get its sales rate (a weighted mix of the last 7, 30, 60 and 90 days, with your seasonality), the days of cover at and on its way to Amazon, the stock-out date, the day to order by and how much to order in whole case packs and at least the minimum order, and what to ship to FBA now from your own warehouse. It flags the low-inventory-level fee before it starts, units heading for the aged inventory surcharge, stranded units that are not selling, and your storage use against your capacity limits. Purchase orders come grouped by supplier with their value.

Without a pass the plan is a free preview: how many SKUs to order now, soon or not at all, and the first rows of the plan with the quantities, dates and amounts hidden; the full plan, the purchase orders and the shipment list unlock with a Premium pass. Your reports are read in your browser and never uploaded.

Common uses

• A weekly restock routine: which purchase orders to place and which shipments to send, in one list.
• Keeping fast sellers above the low-inventory-level fee line without overstocking slow ones.
• Planning a seasonal peak with a busier month set in the seasonality.
• Checking a new product’s first order from its expected daily sales.

How the plan is worked out

• Sales rate = your weights × the daily rates over 7, 30, 60 and 90 days, scaled by how busy each coming month is compared with this one. A period longer than your order history is measured over the days the history covers.
• Days of cover = days until the stock at Amazon, in transfer and on its way there runs out at that rate.
• Order by = the day all your stock (Amazon, your warehouse and units on order) runs out − lead time − days to Amazon − safety days.
• Order = the sales over the lead time, the days to Amazon, the days one order covers and the safety days − all your stock, rounded up to whole case packs and to at least the minimum order.
• Ship now = the sales over the days to Amazon and the cover you keep there − the stock at and on its way to Amazon, in whole cases from your own warehouse.

Amazon’s inventory fees

• The low-inventory-level fee is added to units shipped when a SKU keeps too little stock compared with its sales: when both its short-term and long-term historical days of supply are under 28 days. A SKU that sold fewer than 20 units in the last 7 days is exempt, as are some others the fee page lists; the FBA Inventory report says whether it is charged this week.
• The aged inventory surcharge applies to units stored 181 days or more (fee page); the plan shows the units already there, Amazon’s own estimate from the report, and the units aged 91 to 180 days that will pass 181 days in the next 90 at the current sales rate.
• Capacity limits are set by storage type in Seller Central; type yours to see the space used now, after the shipments and once the purchase orders arrive.

Which reports give what

• The FBA Inventory report: stock available, reserved, inbound, units shipped over 7 to 90 days, ages, volumes and the fee flags. The Restock Inventory report gives 30-day sales and Amazon’s own recommendation, shown beside the plan for comparison.
• The All Orders report: every order line by day, the best sales history (cancelled and seller-fulfilled lines are left out). Downloads of overlapping dates are counted once.
• The stranded inventory report: units with no active offer, which are not counted as stock that sells.
• Your supplier sheet: everything Amazon does not know — lead times, case packs, minimums, costs, your own warehouse and units on order.

Limitations

• MySmartCoPilot is not affiliated with or endorsed by Amazon.
• A plan from your past sales and the numbers you enter; demand can change, and suppliers and carriers can be late. Keep the safety days to match your risks.
• Amazon’s fees, exemptions and capacity limits change; the report flags and your own limits are what the plan uses.
• Inbound placement, prep and carrier choices are made in Send to Amazon; the shipment list is what to send, not a shipment plan.
• One marketplace at a time: add the reports of one store together.

Privacy

On this device; its files download once

Your reports and supplier sheet are read in this browser and never uploaded; only your settings are remembered on this device.