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

Lab Fairy embraces Eli Lewis's lab at Ben Gurion university of the Negev

When there is a job for Lab Fairy it doesn't matter whether it's in the Noth or in the South - Lab Fairy packs its tools and embarks for an assignment! This time Lab Fairy has got a call from Ben-Gurion University of the Negev. 
It's a pure pleasure to work with a professional lab managerHaving boarded a train heading South, the Lab Fairy had an hour ride to Beer Sheva. At the campus which is shared by hospital and university, Lab Fairy was met by amazing lab manager - Ronen Schuster. Ronen was so positive and cooperative that Lab Fairy had a true pleasure of working with him. Ronen accompanied us to the lab and gave very accurate instructions, so the expectations on both sides were very clear.  Lab Fairy plunged into work. Lab Fairy's target was a fridge full of antibodies. On previous Lab Fairy assignments,  there were containers mostly with chemicals, therefore dealing with the new type of inventory items made it even more interesting and exciting!



The goals are shared…

LabSuit goes to Vilnius for LOGIN Fare

Good news!!!

We're flying to Vilnius, Lithuania to take part in LOGIN Fare, which will take place on 24-26 of May!!!

Special thanks to Startup Lithuania team for organizing the pitch battle event at Tel Aviv and granting a winning place! LabSuit will have a great company with the other two startups from Israel, Distribyte, and SwitchRTC.

We've got some introductions to PI's at Vilnius University, so we plan to get back with new labs that would fall in love with LabSuit!

Read more here at the official Startup Lithuania page:
http://www.startuplithuania.lt/en/news/switchrtc-distribyte-and-labsuit-coming-to-login-startup-fair-from-tel-aviv

Case study: social media comes to help to accelerate one's research

Even Lab Researchers have their WOW! Moments
“Labs-Around-Me” is a sharing economy concept for the world of research laboratories. Such labs can share chemicals, antibodies, plasmids and more, with other labs around them.

As LabSuit's concept of “Labs-Around-Me” has evolved, more and more researchers have experienced  amazing WOW! moments when they begin to understand the benefit of our platform.

True Story This is a story of something experienced by a LabSuit subscriber not so long ago.

As we all know, “Labs-Around-Me” allow facilities and researchers to participate in a special LabSuit community. The community includes hundreds of labs - and, through a simple interface, allows them all to collaborate in locating and exchanging chemical reagents.

Events begin in December 2015 Every day LabSuit delivers hundreds of messages between universities - as well as internally, within the same campus. Researchers ask questions about chemicals, buffers, and sharing protocols. Most often, they cou…