To export your inventory data into a spreadsheet, it takes just one click.

  1. Go to the Products tab.
  2. Select Other Actions, and then Export SKU Inventory Info.
  3. To export inventory information into a spreadsheet, select Warehouse-specific  from the Type of product export and choose the warehouses you would like inventory exported from.
  4. If you are trying to get supplier information (Supplier SKU, Supplier Unit Cost, Supplier assigned) for your products, select All Products (includes supplier info).
  5. Click Export.
  6. Click into the Activity tray in the top right-hand corner.
  7. Click on the orange CSV link to download the file to your computer.

What fields are in the inventory export?

For the Warehouse-specific export, these are the columns.

  1. SKU
  2. ASIN
  3. Description
  4. Category
  5. Warehouse
  6. Location in Warehouse
  7. Physical On Hand
  8. Available On Hand
  9. Total Committed
  10. Low Stock Threshold
  11. Manual Order Price
  12. Weight Average Unit Cost
  13. Weight (in pounds)
  14. 30 Day Shipments
  15. Total Value of Inventory
  16. Length
  17. Width
  18. Height
  19. UPC
  20. Product Tags

For the All products (includes supplier info) export, these are the columns.

  1. Product SKU
  2. Product Description
  3. Supplier SKU
  4. Supplier Name
  5. Supplier Unit Cost
  6. Default (TRUE/FALSE)

How to use the inventory export

If you want to edit your on-hand quantities in bulk, then a spreadsheet is the best way to go (See this article related to bulk data edit). Also, exporting all data into a spreadsheet give you the ability to run advanced reporting on your inventory, sales, and cost-of-goods-sold data.

Note: The inventory export file will not exactly match the example file needed for specific Data imports.


Leave a Reply

Your email address will not be published. Required fields are marked *