Bulk and Manually Update Existing Inventory

In this article, we will guide you through how to bulk edit and manually edit your inventory items. 

Bulk Edit

Let’s imagine I own a convenience store and I would like to change the prices of my drinks in bulk. Below is what I currently have. (Note the prices and quantities)

1. To begin, open the spreadsheet that you previously used to import and create your existing inventory items.
2. Duplicate the spreadsheet.
3. Delete all irrelevant items (rows) that you do not wish to edit.
4. In the action_id, input “update” to indicate to the system that you wish to edit those items.
5. In the id column after action_id, find the corresponding item ID generated by the Bindo dashboard and input it in the column. This id can be found through clicking into each item from the Inventory page.

6. Ensure that the store ID corresponds to your store.
7. You may now make your desired adjustments to the price, quantity, product name, department, sku, brand and description.
8. You may also include your _mark if you are making changes to your suppliers list.
9. Save your file as a .xlsx or .CSV.

To start importing, first login to your HQ Bindo account, and navigate to Side Menu Bar > Inventory.

In the Inventories tab, click on the 3-dot icon and click "import" on the bottom right.

Click choose file, and select the spreadsheet you were working on. (the name of the file does not matter.)

After importing, you will see the updated changes in your inventory page.

That’s it! I hope you found this article insightful. As always, should you encounter any difficulties during your importing process, give us a call and our POS Experts will be delighted to assist you.

Manually Editing Inventory Items

1. Login to your Bindo HQ account and navigate to Side Menu Bar > Inventory > Inventories. 
2. Click the product you would like to make modifications to.
3. Once in the product’s page, click “Edit” on the bottom right corner.
4. Now, you can make changes to the item. You can update skus, price, quantity, category, brands and more.
5. After, click save and your changes will be recorded!

‍

Well done! This wraps up our tutorial on Bulk and Manually Editing Inventory Items, we hope you found it helpful. As always, should you require further assistance, please do not hesitate to contact our POS experts.