Using the Amazon SellerCentral Inventory Report

Did you know that SellerCentral allows you to request an inventory report for your offers? Apart from the product’s SKU and ASIN, the inventory reports also contain your product’s current stock and price information, thus providing you with a quick offer overview. As the inventory reports are generated in the standard reporting format (tab-delimited text files), you can import the reports into Excel or process the reports for uploading the information into your data warehouse.

How to request an inventory report:

In SellerCentral, select the „Inventory“tab and then select option „Inventory Reports“. Request an inventory report. SellerCentral will process your request as a background process; creating  an inventory report can take up to one hour.

 

Once the report has been prepared for you, the file can be downloaded from SellerCentral. Save the file onto your hard drive and select „Text file“as file type.

 

Note: In case you participate  in the „Fulfillment By Amazon“ program, SellerCentral’s „Inventory Report“ also allows you to request an inventory report for those items that are fulfilled by Amazon.

Importing your Inventory Report into Excel:

Run Excel, then open the inventory report file that we’ve just saved. Excel will now start the import wizard for your file.

Please select “Delimited” as Original Data Type, then go to the next screen.

 

If not already selected, please check the „Tab“ delimiter option. The dialogue should now show you all four columns SKU, ASIN, price and quantity as separated information. Proceed to the next step.

Now you can set the format for each of the columns. We recommend choosing format option “Text” in order to retain leading zeros in your numeric information – otherwise Excel might just remove these leading zeros from your inventory report.

 

Confirm your selection and click the „Finish“button. Excel will now import your inventory report.

 

A follow-up article in this blog will show you how you can use the inventory report in combination with the ListingLoader template in order to create a product inventory report from scratch (e.g. in case you’ve lost the original file).

Comments

[Shaun Hopkins]

I would recommend that anyone looking at selling with seller central on amazon.co.uk really think twice. Do you want to lose £1000's of stock for months and months on end! We signed up with them over a month ago on the understanding of 14 day payment cycles. We had a load of sales that we shipped. They then they moved it to 30 days plus the 14 so we cancelled and refunded about 25% of the new orders because we weren't prepared to have the money tied up that long. Now as a result of this I have had an email stating 90 more wait. Don't let them ruin your business and cash flow too! Looks like going legal with these guys in Luxembourg will be the only way to sort them out!