Inventory items and stocks are frequently experiencing information changes.
Edit multiple stocks easily, in-app or via export/import.
Edit Selected Stocks
Go to the Storage module > Stocks.
Use the columns to filter and sort the stocks on the list, and select the ones you wish to update.
Click 'Edit' on the toolbar:
A window will open which will allow to edit the data for all the selected stocks.
Click on the pencil icon next to the fields you wish to update to open it for editing.
Save the changes, the window will close and a green notification bar will notify that the changes were successfully saved.
How to bulk-update stocks using export/import
Go to the Storage module > Stocks.
Use the columns to filter and sort the stocks on the list, and select the ones you wish to update.
Export Stocks:
Click the (. . .) icon on the upper right corner > Choose 'Export'.
An email with a link to the Excel file will be automatically sent to you.
Edit Stocks:
Download the Excel file received by email.
Make all changes needed inside the Excel file.
Import back the file:
Click the (. . .) icon on the upper right corner again and choose 'Import / update'.
In the new window opened select your file in the attachment box.
You will get an email when the upload is completed, the stocks will be updated!
Important:
Go through the do's and dont's the first time working with the excel file:
Stock ID column have to be with the correct ID, Do not leave this empty.
Labguru will update any stock that have data written in it's row. If it is the same data as before no change will be applied but it will state that the stock was updated. If a cell is left empty the data will remain as before the update (no change).
You may change the content of a stock as long as the new content is of same collection (stocks are 'collection sensitive' e.g. a plasmid cannot become an antibody) and its corresponding system ID is provided.
If designated position within a box is already taken, stocks will be placed in the next available slot.
Changing locations - It is possible to change stocks' locations within a box, move to another box or to a storage location. Changes from a Storage location to a box cannot be done.
In general, make sure to follow the same basic principles as in importing stocks.