Skip to main content

Keeping your digital inventory synchronized with lab closets, drawers and boxes

LabSuit is out of sync with your inventory

Uh Oh! It’s been a while since you last updated your LabSuit inventory, so it no longer reflects an accurate picture of your lab’s closets, boxes, and drawers. No worries! We’ve seen this many times, and it’s easily fixed. No way around it: it’s time to take a short break and rearrange your inventories.
In this article I will describe how to do so in an efficient and quick manner.


Update LabSuit inventory with Excel


First of all, I assume we already have our inventory with LabSuit.
We want to leverage that fact and build up our renewed, updated inventory on top of an existing one.


There are two options
  1. The inventory can be updated directly in LabSuit
  2. The inventory can be updated in Excel and then re-imported into LabSuit.
We will focus on second option.

Download the inventory Excel file.
After opening the Excel file you will see at least one spreadsheet. The  exact number of spreadsheets will depend on how many different item types there are in your inventory.


Preserve the serial number

An exported Excel file would look similar to the one above. Make sure you don't change the serial numbers.
Every item in your inventory has its own unique serial number. (Read more about LabSuit serial numbers)
LabSuit will use this column to fetch a right inventory item from its database and update it based on the values from your Excel file.
Now, go ahead and edit the other fields according to your needs.


If you want to add a new item, add it at the bottom, and do not specify any serial number. LabSuit will recognize it as new item, and will allocate a new serial number for it, automatically.


Managing types










You may also add your own item types simply by creating a new spreadsheet. Make sure to name the spreadsheet after your item type.


Re-import your Excel

The last step is to re-import your Excel file once again into LabSuit.
Make sure the file you upload is the updated one! :-)


Important to know, that if an item has attachments, they will preserved after import. Feel free to ask questions just below that article!

Comments

Popular posts from this blog

Order awaits receiving longer than usual? LabSuit is here to help!

Problem   It's an essential part of the lab manager's duty to track if ordered items are delivered in a timely manner. Though it sounds like a simple task, it's not easy to execute, because of the multiple responsibilities lab managers have. In addition, it's not always clear, when an order item is supposed to be received. Solution Luckily, LabSuit has a creative solution for that. LabSuit uses a data-oriented approach.      For that approach to work,  a lab member needs to order a few times from a specific vendor. Eventually, LabSuit knows how fast the order is marked as received, the more orders are made from that vendor, the more accurate an average time-to-receive is. For example, let's say a lab manager ordered 17 items for a specific vendor in the past. Based on this historical data, LaSuit knows that items from that vendor, on average were marked as received after 8 days, which pretty accurately describes how things are working at that specific lab. ...

Sigma-Merck and LabSuit join hands to provide labs with an improved chemicals purchasing experience

After a long waiting, we are happy to announce a collaboration between LabSuit and Sigma-Merck! To begin with we say a big Thank You to the Israeli Merck Group team and german team altogether! This milestone brings Merck's products catalog into the Labsuit Vendor platform.   Starting today, all lab members that have been using the LabSuit platform to manage lab inventory and requests are able to browse thousands of Merck products without their leaving their favorite lab management tool.   Real-time availability from Rehovot, Israel distribution warehouse  All Sigma-Merck granted discounts are reflected in LabSuit  Rich products data embedded into inventory items Real-time availability Sigma-Merck brings thousands of products available immediately from its warehouse in Rehovot. In order to take advantage of it, LabSuit has a " Sort by Availability " selector. With this control enabled, products that ship directly from Isreal show up first. All Sigma-Merck granted...

New!! Freezer box support added.

This is a big day for Biology Labs, who store their antibodies/plasmids/etc. in freezer boxes. From now, a researcher can easily map all his inventory items into virtual freezer box LabSuit now supports!!! Yes, that is super cool! You're welcome to watch this short explanatory video and get excited the same way as I'm now! You're more than welcome to leave your comments here!