Seller Forums
Sign in
Sign in
imgSign in
ForumsHomeDiscussions
ForumsHomeDiscussions
imgSign in
user profile
Seller_P91KAof0AAOAm

How to download an excel file of entire Amazon inventory

Hello esteemed Amazon seller crew,

Hope you are all good :slight_smile:

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

310 views
7 replies
Account Setup
Tags:Taxes
00
Reply
user profile
Seller_P91KAof0AAOAm

How to download an excel file of entire Amazon inventory

Hello esteemed Amazon seller crew,

Hope you are all good :slight_smile:

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

Account Setup
Tags:Taxes
00
310 views
7 replies
Reply
7 replies
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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? :sweat_smile:

00
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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?

00
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

AH! I can create a CUSTOM version of Open Listings Report with Product Tax code addeed!! Hopefully this will do it!

10
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

Haha :smiley: 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? :thinking:

00
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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

10
Follow this discussion to be notified of new activity
user profile
Seller_P91KAof0AAOAm

How to download an excel file of entire Amazon inventory

Hello esteemed Amazon seller crew,

Hope you are all good :slight_smile:

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

310 views
7 replies
Account Setup
Tags:Taxes
00
Reply
user profile
Seller_P91KAof0AAOAm

How to download an excel file of entire Amazon inventory

Hello esteemed Amazon seller crew,

Hope you are all good :slight_smile:

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

Account Setup
Tags:Taxes
00
310 views
7 replies
Reply
user profile

How to download an excel file of entire Amazon inventory

by Seller_P91KAof0AAOAm

Hello esteemed Amazon seller crew,

Hope you are all good :slight_smile:

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

Account Setup
Tags:Taxes
00
310 views
7 replies
Reply
7 replies
7 replies
Quick filters
Sort by
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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? :sweat_smile:

00
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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?

00
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

AH! I can create a CUSTOM version of Open Listings Report with Product Tax code addeed!! Hopefully this will do it!

10
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

Haha :smiley: 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? :thinking:

00
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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

10
Follow this discussion to be notified of new activity
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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? :sweat_smile:

00
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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? :sweat_smile:

00
Reply
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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?

00
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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?

00
Reply
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

AH! I can create a CUSTOM version of Open Listings Report with Product Tax code addeed!! Hopefully this will do it!

10
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

AH! I can create a CUSTOM version of Open Listings Report with Product Tax code addeed!! Hopefully this will do it!

10
Reply
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

Haha :smiley: 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? :thinking:

00
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

Haha :smiley: 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? :thinking:

00
Reply
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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

10
user profile
Seller_P91KAof0AAOAm
In reply to: Seller_P91KAof0AAOAm’s post

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

10
Reply
Follow this discussion to be notified of new activity