Delete Inventory items in bulk using Excel

At times, you may need to remove a large portion of your Inventory. You do not have to do this one by one. It's easy to do in bulk using the Excel download option! 

1. From the Inventory module, select a Lab and click Export Inventory on the left sidebar. 

Note: There is no option to export the Inventory when viewing All Labs. 

Screenshot 2024-11-25 at 4.17.54 PM.png

2. You can choose to either download the entire lab's inventory or just the items that match the filters and search currently activated in the Inventory table. Click Export File.

Screenshot 2024-11-25 at 4.20.35 PM.png

3a. To delete an item, find the item(s) you want to delete from your Inventory and change the "N" in the Delete? (Y/N) column to a "Y" on the Item row and the Instance row. Repeat this for each worksheet in the file. Different Types are separated onto different worksheets.

Screenshot 2025-08-14 at 11.59.05 AM.png

3b. To delete an instance only, find the instance(s) you want to delete from your Inventory and change the "N" in the Delete? (Y/N) column to a "Y" on the Instance row only. Leave the "N" in the Delete? (Y/N) column for the Item row above the Instance you are deleting.

Screenshot 2025-08-14 at 12.00.45 PM.png

4. Save the file. Go back to the Inventory module, select the same Lab, and click on Import Inventory.

Screenshot 2024-11-25 at 4.10.05 PM.png

5. Check the box that verifies that you used the Quartzy Excel template and upload your saved file. The changes to your Inventory will be saved!

Important: Inventory items are permanently deleted. Make sure to always backup your Inventory.

Screenshot 2024-11-25 at 4.05.47 PM.png

 

Next Up: Learn how to upload your freezer box inventory into interactive freezer boxes on Quartzy!

 

More questions? Contact us

Have more questions? Submit a request

Comments