Before you can complete this procedure, you need to have your Metrc plant tags received into platform. If you haven't done so already, see How to Add Tracking IDs (Tags) from METRC.
Setting up your plants involves the following tasks covered in this article:
1. Generate a report of your plants
Use this report as a record of the state of your plants before rebuilding them.
Open the App Drawer and click Analytics.
On the All tab, click Plants.
Scroll to the Plants Reporting section and wait for it to load, then scroll to the Plants Report subsection, hover over the top-right corner of it to reveal the Download button
and click it.
Choose a location on your computer to save the report.
2. Remove all your plants in MJ Platform
STOP. Do not complete this procedure unless you have generated your plants report as outlined above.
Open the App Drawer and click Plants.
Destroy plants:
Click the checkbox at the top-left of the list to select all plants on the page.
Click Destroy Plants.
Fill out the required fields:
In the Waste field, enter 0.
From the Destroy Reason drop-down menu, select Destroy.
In the Destruction Date field, enter today's date.
In the Notes field, enter "Metrc preparation" or a similar note.
Click Save. This deactivates the selected plants.
Repeat step 2 until all plants are destroyed.
3. Rebuild plants based on the report
Open the plants report in Microsoft Excel. Each row in the report represents one plant.
Crete a pivot table from the report in Microsoft Excel:
Click the Select All Cells button
to the left of column A.
Open the Insert tab and click Pivot Table.
Click OK to generate the pivot table.
From the Pivot Table Fields side bar on the right, select the following checkboxes in the order they are listed here:
Section Name
Stage
Planting Batch ID
Plant Type
Strain Name
From the same list, drag Strain Name to the Values pane. this completes the pivot table, which will be used in the next step.
Add plants in MJ Platform based on the report:
From the pivot table, take note of the deepest (most indented) level. This is your target, which indicates the number of plants you have of a strain for a specific plant type, batch ID, growth phase, and section (location).
In the example below, at the deepest level, you can see that this user has 50 Abracadabra strain clones with the planting batch ID ABRA201001P in the Flowering phase located in a place called "section 1".
In MJ Platform, go to the Plant Listing page and click Create Plant.
Fill in the required fields:
Strain Name: Select the same strain as the one containing your target in the pivot table. In the sample above, it would be Abracadabra.
Planting Date: Select today's date.
Plant Type: Select the same plant type as the one containing your target in the pivot table. In the sample above, it would be Clone.
Quantity: Enter the number listed in the pivot table for the target.
Change Location: Select the same location as the one containing your target in the pivot table. In the sample above, it would be section 1.
Click Save and Create More.
Repeat step 3 for the next target until you have gone through them all.
In the example below, this was done nine times.
4. Update the rebuilt plants
Using the report, go through each rebuilt plant in MJ Platform and modify them to select the correct growth phase and apply Metrc plant tags.
Open the App Drawer and click Plants.
Click Scan Search.
From the drop-down menu next to the search bar, select Batch.
Update plants according to the groups in the pivot table created earlier. Start with the first target in the pivot table again.
Copy the target's batch ID.
Paste the batch ID into the search field in MJ Platform. The list updates.
If the list does not update after a few moments, click Update Search.
Click the listed batch and click Plant Modification.
From the Change Growth Phase drop-down menu, select the growth phase containing the target in the pivot table. This displays the Beginning Tag and Ending Tag fields.
In the Beginning Tag field, select the first available Metrc plant tag. The Ending Tag is automatically populated according to the plant count.
In the Modification Date field, enter today's date.
Click Save And Print Label.
Repeat step 4 for each target in the pivot table until you have gone through them all.