You can update products in the Ordoro UI in many ways. However, there are some actions, like updating your inventory, that are better managed in a spreadsheet.

For example, you can export your inventory data into a spreadsheet, make changes easily, and re-import the data to Ordoro. Note: all Data Imports are for CSV files (comma-separated value).

There are two ways to update your inventory in bulk: 

NOTE: You cannot import a new Physical On Hand number and an On Hand Adjustment at the same time for the same product in the same warehouse. This will give you an error. You will need to do these in separate imports.

Update Physical On Hand inventory

1. Go to the Products section and export your items.

  • See this link on how to export your current Ordoro products into a CSV file.

2. Go to Settings -> Data Import. Download the Update Inventory example file.

3. Using the example file for reference, copy and paste the required field information (SKU and Warehouse) and the new Physical On Hand number into the sample CSV file. 

  • IMPORTANT: If you are not updating all values (Low Stock Threshold, etc.), delete the columns out of the file. Do not leave them blank. If left blank, they will overwrite the existing data as blank.

4. Upload the saved CSV file to Data Import. The fields will map automatically but always double-check before running the import.

  • Note: Make sure you have Update Inventory selected in the drop-down list before you upload the file.

On Hand Adjustment

1. Go to the Products section and export your items.

  • See this link on how to export your current Ordoro products into a CSV file.

2. Go to Settings -> Data Import. Download the Update Inventory example file.

3. Using the example file for reference, copy and paste the required field information (SKU and Warehouse) and the new On Hand Adjustment number into the sample CSV file. 

  • To increase the current total by 10, your CSV file should look like this:
  • To decrease the current total by 10, your CSV file should look like this:
  • If you upload zero in the On Hand Adjustment field, the inventory will not change.

4. Upload the saved CSV file to Data Import. The fields will map automatically but always double-check before running the import.

  • Note: Make sure you have Update Inventory selected in the drop-down list before you upload the file.

Comments

  1. Pingback: Exporting inventory data into a spreadsheet

Leave a Reply

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