Bulk updating inventory quantities in Ordoro is very easy. We resort to a spreadsheet method to perform bulk data edits. We adopted this method, rather than creating a fancy UI for bulk editing, because the spreadsheet method is easy, and process actions very quickly. Also, Excel has easy ways to update a large number of rows in one attempt. It makes sense to allow our users to do their bulk data edits in Excel.

In simple words, you can export your inventory data into a spreadsheet, make changes easily, and re-import that spreadsheet into Ordoro. When uploading be sure the file is in a CSV (comma separated value) format.

There are two ways to update your inventory in bulk: 

  • Updating the Physical On Hand for your products: This will replace the current inventory number stored in the warehouse with the information uploaded.
  • Adjusting the physical on hand with an On Hand Adjustment: This will allow you to increase or decrease the inventory totals currently stored in the warehouse in Ordoro. 
Follow the steps below to replace the Physical On Hand total:

1.  Export your current products from the Products tab. See this link on how to export your current Ordoro products into a csv file.

2.  Download the ‘Update Inventory’ example file from Settings -> Data Import

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

IMPORTANT: If you are not updating certain columns (Low Stock Threshold, Location in Warehouse, On Hand Adjustment), please delete the columns out of the file, do not just leave them blank. If left blank, they will overwrite the existing data as blank.

4.  Upload the saved csv file into Ordoro. The fields should 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.

It is important to note that whatever you enter in the spreadsheet will overwrite whatever is in Ordoro.  If you leave out a quantity, then the Physical On Hand quantity will be set to zero in Ordoro.  Additionally, the order of the columns is essential and must be followed precisely for the csv upload to be successful.

Follow the steps below to adjust inventory totals with the On Hand Adjustment field:

1.  Export your current products from the Products tab. See this link on how to export your current Ordoro products into a csv file.

2.  Download the ‘Update Inventory’ example file from Settings -> Data Import

3.  Using the example file for reference, copy and paste the required fields (SKU and Warehouse) as well as the On Hand Adjustment updates. If you are trying to increase the current total by 10, your CSV file should look like this:

If you are trying to decrease the current total by 10, your CSV file should look like this:

If you upload 0 in the On Hand Adjustment field, the inventory will not change.

4. Upload the saved csv file into Ordoro. The fields should 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.

NOTES: 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.

Comments

  1. Pingback: Exporting inventory data into a spreadsheet

Leave a Reply

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