Restock Inventory Report


#1

I use the Restock Inventory report to manage my production and stock levels. For the past 4 days, when I request the report, I get “No Data Available”. I know I can’t replenish inventory right now, but I still need to get quantity on hand, sales last 30 days, recommended replenishment, etc, to be prepared for when replenishment resumes. How can I get the report? Thanks.


#2

Unfortunately, Amazon has mostly disabled that report for now per:

What I would recommend is trying to use order reports for now to see how many units have sold and inventory reports for your quantity on hand.


#3

It is a bit more work, but that data can still be found under
Reports->Fulfillment->Inventory, Inventory Health.
It updates once a day.

The download version has more fields than the ‘view online’ version. Here is a field list for the downloaded version:
snapshot-date,sku,fnsku,asin,product-name,condition,sales-rank,product-group,total-quantity,sellable-quantity,unsellable-quantity,inv-age-0-to-90-days,inv-age-91-to-180-days,inv-age-181-to-270-days,inv-age-271-to-365-days,inv-age-365-plus-days,units-shipped-last-24-hrs,units-shipped-last-7-days,units-shipped-last-30-days,units-shipped-last-90-days,units-shipped-last-180-days,units-shipped-last-365-days,weeks-of-cover-t7,weeks-of-cover-t30,weeks-of-cover-t90,weeks-of-cover-t180,weeks-of-cover-t365,num-afn-new-sellers,num-afn-used-sellers,currency,your-price,sales-price,lowest-afn-new-price,lowest-afn-used-price,lowest-mfn-new-price,lowest-mfn-used-price,qty-to-be-charged-ltsf-12-mo,qty-in-long-term-storage-program,qty-with-removals-in-progress,projected-ltsf-12-mo,per-unit-volume,is-hazmat,in-bound-quantity,asin-limit,inbound-recommend-quantity,qty-to-be-charged-ltsf-6-mo,projected-ltsf-6-mo


#4

Thank you for the share! I didn’t realize that existed. Very, very helpful :slight_smile:


#5

I was afraid of that. It seems wrong to disable a report because they are temporarily limiting shipments – I mean, downloading the report doesn’t cause a shipment. But I can find the same numbers by combining a couple other reports, it’s just a nuisance.

Thanks for the help.


#6

Just wanted to make sure that you saw the better answer:


#7

Yes, thanks for the follow-up. I can use the Inventory Health report. But I manage about 1,000 items, so I automated an interface to the Restock Report to integrate smoothly with my inventory production system. Now I have to do it manually. It’s annoying that Amazon simply disabled the report for no good reason.


#8

If you can automate fetching of the restock report, you can do the same with the inventory health report. The MWS name of it is _GET_FBA_FULFILLMENT_INVENTORY_HEALTH_DATA_


closed #9

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.