3. Importing your Inventory: A Step Towards Efficiency

How to efficiently set up your Inventory in Labstep by using the Import tool, including some tips and best practices.

Anoä Calpas avatar
Written by Anoä Calpas
Updated over a week ago

Now that you have all your templates set up, the quickest way to get going is to use our import tool. In this article, we'll go over the different import options. The import tool is the best way to set up your Inventory in bulk. For more information about how to use the import tool, click here.

Import Options

You have two options: either import from a file (CSV /XLSX) or type/paste manually into a table. Additionally, depending on the format of your file, you'll have two different modes: either one row per resource or one row per item. This will depend on how your spreadsheet is formatted.

Importing One Row Per Item

When importing one row per item, each row represents an individual item in your Inventory.

To do this effectively, ensure that you have a "Name" column to identify the resource. If individual item names aren't specified, Labstep will automatically generate them using the resource name with an incrementing number (e.g., Acetone #34).

Importing this way enables you to specify item-specific metadata such as location, amount remaining, lot numbers, barcodes, or expiry dates for each item.

This option is preferable if your spreadsheet contains specific item names, such as Blood Sample #3 or Passage #98, or specific item information such as locations, amounts, lot numbers, barcodes etc.

  • Locations:

When specifying locations, you have the option to provide a path of nested locations.

Utilise set locations like "Freezer A" for general item placement. For granular detail, use paths like "Freezer A > Shelf 2 > Box 98" to specify precise item locations and sub-locations.

Labstep dynamically creates sub-locations during the import process if the one(s) referenced do not match any from your Inventory.

Example Import – Items

Name

Item Name

Amount Remaining

Location

Use By Date

Barcode nº

Lot nº

Colombia El Jordan Estate

Bag 1

500g

Freezer A

26/04/2024

ABC-abc-6589

45678

Colombia El Jordan Estate

Bag 2

250g

Freezer A> Shelf 5> Box 65

27/04/2024

ABC-abc-1234

0987

365 Pacific Rim

Bag 1

1000g

Box 66

28/04/2024

ABC-abc-0987

47385

Lazy Sunday Coffee Beans

Bag 3

50g

Shelf 5

01/05/2024

ABC-abc-4567

73928

Jamaica Blue Mountain

Bag 5

750g

Shelf 23> Box 7

02/05/2024

ABC-abc-5432

12346

Importing One Row Per Resource

Alternatively, you can choose to import one row per resource, specifying the number of items in stock for each resource.

In this case, each row represents a resource, and you'll need to specify the number of items in stock under a column named "number of items" or "items in stock." You'll need a Name column for your resources. Within the resource, each item will use the resource name with an incrementing number. You can update the name after import by clicking on the item's cell.

Keep in mind that resource-specific metadata fields will apply to the resource only, not individual items. If you have an item template set up, then you will be able to fill in the fields once the upload is complete.

Example Import – Resources

Name

Items in stock

Vendor

Organic

Ethically Sourced

Country of Origin

Colombia El Jordan Estate

52

Fortnum & Mason

yes

yes

Columbia

Colombia El Jordan Estate

20

Whole Foods

yes

yes

Ethiopia

365 Pacific Rim

7

Waitrose

no

yes

Kenya

Revert Import

Mistakes happen! Labstep allows you to revert an import if needed:

If you make a mistake during the import process, you can revert it by navigating to the import tool and clicking "Revert".

Be cautious when reverting imports, as it will permanently delete the imported resources/items.

Tips & Best Practices

  • Ensure your spreadsheet has a "Name" column.

  • Set up templates before initiating the import process.

  • Reference items in stock if importing resources to avoid "0 available" items.

  • Match spreadsheet columns with metadata fields set in your templates.

  • The first import might take longer than subsequent ones.

  • Invalid rows will halt the import process.

  • Clicking "back" before "import" will result in lost changes.

Conclusion

Importing your Inventory into Labstep is a crucial step towards optimising your laboratory workflows. With the ability to import both resources and items and granular control over metadata fields, Labstep empowers you to manage your Inventory efficiently, saving time and reducing errors. With your Inventory efficiently set up, you'll then be able to seamlessly link it to your research.

Now, it's time to put your knowledge into action and seamlessly transition your Inventory into Labstep's comprehensive platform!


Knowledge Check

  • What are the two options for importing Inventory in Labstep?

  • How can you specify item locations during the import process?

  • What is the purpose of reverting an import?

  • Why is it important to match spreadsheet columns with metadata fields?

  • What should you do if you encounter invalid rows during the import process?


This lesson is part of the "Labstep 101: Everything You Need to Know to Get Started" course. View all lessons here.

Did this answer your question?