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

  1. Go to the Products tab
  2. Click on Export Products (If this is not visible, select Other Actions, and then Export Products)
  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 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. Low Stock Threshold
  9. Manual Order Price
  10. Average Cost
  11. Weight (in pounds)
  12. 30 Day Shipments
  13. Total Value of Inventory

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 Price
  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.

Tagged:

Leave a Reply

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