How to download an excel file of entire Amazon inventory
Hello esteemed Amazon seller crew,
Hope you are all good 
Can you please tell me how I would download my entire inventory of seller fulfilled items into a csv or excel file? I need to do this to bulk change some tax classes
Any help appreciated, as I don’t fancy doing this manually in amazon for 5000 items and some Lol
Best regards
Luke
7 replies
Seller_P91KAof0AAOAm
OK so I managed to download this from Inventory Reports > Open Listings Report.
However this doesn’t contain the field I want to change, I basically want to change the Product Tax Rate field in bulk for some stuff - any ideas how I might do that? 
Seller_P91KAof0AAOAm
Thanks for the response as always @The_Little_Shop
I’ve got an inventory file (Open Listings Report, covering all merchant fulfilled active listings)
However fields available on that are:-
item-name item-description listing-id seller-sku price quantity open-date image-url item-is-marketplace product-id-type zshop-shipping-fee item-note item-condition zshop-category1 zshop-browse-path zshop-storefront-feature asin1 asin2 asin3 will-ship-internationally expedited-shipping zshop-boldface product-id bid-for-featured-placement add-delete pending-quantity Business Price Quantity Price Type Quantity Lower Bound 1 Quantity Price 1 Quantity Lower Bound 2 Quantity Price 2 Quantity Lower Bound 3 Quantity Price 3 Quantity Lower Bound 4 Quantity Price 4 Quantity Lower Bound 5 Quantity Price 5 merchant-shipping-group Progressive Price Type Progressive Lower Bound 1 Progressive Price 1 Progressive Lower Bound 2 Progressive Price 2 Progressive Lower Bound 3 Progressive Price 3 Minimum order quantity Sell remainder
I would have expected product-tax-code or similar? don’t suppose you know which it is?
Seller_P91KAof0AAOAm
AH! I can create a CUSTOM version of Open Listings Report with Product Tax code addeed!! Hopefully this will do it!
Seller_P91KAof0AAOAm
Haha 
Thanks anyway.
Here is another one though… I need to see the product names in order to know which ones need changing and which ones don’t… the below is all I get though
sku asin price quantity ProductTaxCode Minimum order quantity Sell remainder
And there is no option on custom columns to show the products name? 
Seller_P91KAof0AAOAm
OK, so it wasn’t on the full inventory report, but it has come through on the open l;istings report
Unfortunately open listings report only has 2.3k lines, and I have 6k listings.
“Hmmmm” Again Lol
