Ordoro stores a lot of data about your products. There are times when you may need to export this information to generate custom reports for your business. An example would be your total value of inventory.

See below for how to export this information!


Topics

  1. How to export product info
  2. What columns are in the product export?
  3. How to use the product export

How to export product info

1. Go to the Products tab.

2. Select Other Actions -> Export SKU Inventory Info.

3. In the modal, there are two options.

  1. Warehouse-specific: All product and inventory information from the chosen warehouse(s).
  2. All products (includes supplier info): All products with supplier information, regardless of if suppliers are assigned.

4. Click Export.

5. Select the Activity tray in the top right corner.

6. Click CSV to download the file to your computer.


What fields are in the product 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
  9. Committed
  10. PO Reordered
  11. Low Stock Threshold
  12. Price
  13. Weighted Average Unit Cost
  14. Weight
  15. 30 Day Shipments
  16. Total Value of Inventory
  17. Length
  18. Width
  19. Height
  20. UPC
  21. Kit Parent
  22. Kit Component
  23. 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 product export

Once you’ve exported the information, you can modify the product information and re-upload it to Ordoro. See this article related to bulk data edit.

  • Note: The inventory export file is not an exact match for all of Ordoro’s Data Import templates.

Also, with all the raw data, you can create advanced reporting on your products, such as the total value of inventory, see your 30-day sales per product, if products are used in kitting, etc.

Tagged:

Leave a Reply

Your email address will not be published.