Labshake Mylab: upload your inventory
If you inventory has less than 200 items, please enter them manually, since it is likely that it will take us more time to upload the inventory than the time you spend on manually entering them.
If you have more than 200 inventory items saved in a spreadsheet, we can upload the inventory for you. Please contact us to find out how to send the spreadsheet to us. Refer to the following guideline on how to prepare the spreadsheet.
Format of inventory spreadsheet
- Your spreadsheet must be an Excel file, Download this inventory spreadsheet as an example.
- If your inventory contains different categories, each category should be on a separate data sheet in the Excel file, with the category name as the name of the data sheet.
The following are the maximum number of characters allowed for inventory attributes. Make sure that in your spreadsheet these limits are not exceeded.
| Attribute | Maximum characters | Example |
|---|---|---|
| Category name ( as data sheet name) | 100 | Chemicals |
| Item name | 500 | Poly-D-lysine |
| Catalog # | 100 | 223-132 |
| Unit | 30 | 5 mg |
| Quantity | 10 | 2 |
| Location | 300 | Freezer 1 Rack 2 |
| Expiration Date | 10 | 1/1/2026 |
| Supplier name | 100 | Sigma |
| Source Url | 2000 | Https://sigma.com/product/23-132 |
| Notes/Description | 3000 | Aliquoted |
| Names of any custom attribute, 1 per column | 60, such as host, CAS#, etc. | CAS # |
| Values of a custom attribute, 1 per column | 255 | 27964-99-4 |