How to download an Inventory file?


#1

Greetings sellers,

I have always added inventory through the web interface. It would be really convenient to be able to edit an inventory file to make pricing changes, etc. but I don’t have one.

I read in the forums that Catalog team could help us download our inventory, so I wrote to Seller Support and made this request for the Catalog team’s assistance. I received a very detailed reply from Seller Support saying that this wasn’t possible.

Anyone have any suggestions how I can get my inventory into an editable Excel file?

Thanks!


#2

Not sure what or how you asked but of course inventory files are available.

You can run reports
https://sellercentral.amazon.com/listing/reports

You can download an inventory file for your catalog, copy paste from report above and make changes as you see fit.

https://sellercentral.amazon.com/listing/download?ref_=ag_download_tnav_status


#3

You can download the inventory report from here:
https://sellercentral.amazon.com/listing

Or you can do so from here if not needing for a specific category:
https://sellercentral.amazon.com/listing/reports

The Seller University has a section about it as well:
https://sellercentral.amazon.com/learn/courses?ref_=selleru_athena_c4_m21&courseId=4&moduleId=21&modLanguage=English&videoPlayer=youtube

The download will default to notepad. You can either modify your windows extensions to have csv files automatically open to excel, your can simply copy and paste everything you see in the notepad into an excel worksheet and edit from there.


#4

Thanks for the answer, but is there a way to automatically populate the listing template (inventory file?) with what I already have in seller central? By copying and pasting things I don’t want to risk damaging parent child relationships, etc.

What’s prompting all this is that Amazon separated one of my parent child listed products, and now one child is in limbo, it can’t be found through amazon.com search. I want to rebuild the parent-child relationship and the only way to do it is through an upload.


#5

Yep, you need to update with the parent sku/ASIN and one anchor child ASIN along with the lost child then save as an update, no need to do every ASIN/SKU. this should reestablish the connections.

Below is an outline I had saved from a message:

  1. Enter the parent SKU/ASIN

  2. Then, enter the child SKUs in the SKU column for the ASINs that you want to map under the parent. For the child items, you will need to enter the respective ASINs in the “Product ID” column and provide the value “ASIN” in the “Product_ID_Type” column. This would deally set up the required relationship in your seller account as well as on Amazon.com.

3.In the Product ID column for the child SKUs, enter their ASIN value

  1. In the product ID type column, type ASIN (All upper cases and then enter - you don’t get ASIN option, thus, type all caps).

  2. Fill the other required details (refer to the Data definitions sheet at the bottom).

  3. In the update delete column, enter as Update.

If you use text files, everything you need to set up relationships is in the inventory template. The Data Definitions tab in each category-specific inventory file lists the terms you can use for variation themes.

  1. Once feeding all your data, save your file. In “Save As Type” list select Text (Tab-delimited) (*.txt). Browse to where you would like to save the file, rename the file, and click Save. You might see a warning that the selected file format (the tab-delimited file type) does not support workbooks containing multiple worksheets. Click Yes.

  2. Upload your file from the page below. Make sure you select the appropriate option from drop-down menu. In this case you will need to select ‘Inventory Files for non-Media categories.’
    https://sellercentral.amazon.com/gp/item-manager/ezdpc/uploadInventory.html/ref=ag_invfile_dnav_onconfig_

Important tips:

  • Don’t include price and quantity values for parent products. This can cause your products to disappear from the site.
  • When you list your child products, fully describe each one so that they are included in browse and search results.
  • For better customer service, add the size and color to the child product title.

closed #6

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