# Using batch operations on inventory items **URL:** \ **Category:** Uncategorized\ **Created:** [April 20, 2016, 9:53am UTC](https://forum.manager.io/t/using-batch-operations-on-inventory-items/5499 "2016-04-20T09:53:38Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [April 20, 2016, 9:53am UTC](https://forum.manager.io/t/using-batch-operations-on-inventory-items/5499/1 "2016-04-20T09:53:38Z")
You can create, update or delete inventory items by batch. When viewing the `Inventory Items` tab, you will see three buttons in the bottom-right corner. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/c/c223bcdce6c965273a39e0b4e85082f692c017c8.png) Once you click the `Batch create` button, you should firstly download the empty spreadsheet template so you know what columns are required. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/d/dffb2641bf97fa784760dd22d8cc1bda14436734.png) Once you open the empty spreadsheet template, you can enter the data. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/7/7aa071b48e1724177f18e5ca51c51f65e1fc3cba.png) Then copy and paste the data from the spreadsheet into Manager. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/d/d6575ec06c19cba3c3a07fafeb6dc3605b15a4eb.png) When you click the `Next` button, you will see the preview of what you are about to import. If you are satisfied, click the `Batch create` button to create all inventory items in Manager. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/b/b6ae653713b9b2fff2aed39c03569c7df6ed7515.png) Now, let’s say you want to quickly update prices on all inventory items. In order to do that, click the `Batch update` button. Then click on step 1 to download all the data from the spreadsheet program. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/4/43dc19026a74dd94f713e9acfd2bbdce7b38e4de.png) Use the spreadsheet program to update data. Do not remove or modify any content in the `Key` column. You can remove any rows you don’t need to update from the spreadsheet. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/0/0ff1b47cdc68d81f2fd00b822402a11ac66867c0.png) Copy and paste data from the spreadsheet to Manager. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/6/63d08bdcfd48fc5be30359f884ad1f15f8ca6b6b.png) After you click the `Next` button, you will see the preview of changes about to be committed. ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/c/c47b21044582fef2bd3fc15d3f4d2f432341f12e.png) If you are satisfied with changes, click the `Batch update` button to save the changes. ---
**Author:** ![davidtranlds](https://avatars.discourse-cdn.com/v4/letter/d/85e7bf/32.png) [@davidtranlds](https://forum.manager.io/u/davidtranlds)\ **Post date:** [June 13, 2016, 12:27pm UTC](https://forum.manager.io/t/using-batch-operations-on-inventory-items/5499/2 "2016-06-13T12:27:28Z")
Glad I found this guide, however, I wish a TaxCode field could be included to then specific the code currently used somehow. I just did a batch create, and I want to have the Tax Code GST 10% automatically included, rather than now going to each item and selecting it. Or maybe I missed something? If not, hopefully in a new future update. 🙂 Thank you again for the awesome guides ---
**Author:** ![davidtranlds](https://avatars.discourse-cdn.com/v4/letter/d/85e7bf/32.png) [@davidtranlds](https://forum.manager.io/u/davidtranlds)\ **Post date:** [June 20, 2016, 8:39am UTC](https://forum.manager.io/t/using-batch-operations-on-inventory-items/5499/3 "2016-06-20T08:39:59Z")
Just remembered one more thing - Discount Price would also be good as I’d like to show the RRP and the discounted price on the invoice, rather than manually adding it Just a thought, it’d be cool 🙂 ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [May 15, 2017, 7:48pm UTC](https://forum.manager.io/t/using-batch-operations-on-inventory-items/5499/4 "2017-05-15T19:48:12Z")
---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [May 5, 2018, 2:08pm UTC](https://forum.manager.io/t/using-batch-operations-on-inventory-items/5499/5 "2018-05-05T14:08:23Z")