Import Freezer Samples to Quartzy interactive freezer boxes via Excel

You can place the items that are contained in your freezer boxes onto Quartzy and into interactive freezer box maps using Excel! 

1. On the top left side of the toolbar, click on All Groups (or the Group name) and then click Manage. 

2. Select the Group on the left sidebar and choose the Locations tab. 

3. Add Locations and Sublocations for your freezer boxes. 

Location Name - Freezer name/description. Keep these simple so they are easy to find in the list of locations.

Sublocation Name - Combine multiple sub-levels like shelf, rack, and box name here. Select Freezer Box as the sublocation format and select box dimensions.

Important: You will not be able to upload your items to freezer boxes unless you create all locations and sublocations in advance. 

4. Upload your freezer box inventory using the Import via Excel feature. Make sure the location and sublocation names exactly match those created from the Locations page.

Add Location Details which represent the position of the item within the freezer box. Quartzy uses a Letter-Number nomenclature for box position, such that position "A1" is the first spot in the box, where the Letter is the Row and the Number is the Column.

Link: Click here to see how to transfer your freezer box numbers (1-81) to Quartzy's letter-number nomenclature.

When you do everything correctly, your items will be imported to the Quartzy Inventory for your selected Group. Go to the Manage Locations section to make changes to any of the locations that you added.

 

Next Up: Learn how to delete multiple inventory items at once via Excel

 

More questions? Contact us

Have more questions? Submit a request

Comments