Skip to main content

Create Items in Bulk with CSV Import

Create many new items at once by uploading a CSV file. Covers permissions, the CSV columns, validation errors, and what Metrc companies can upload.

Use Bulk Item Create to add multiple new items to your company's item master at once by uploading a CSV file, rather than creating them one at a time. Use this article to prepare the file: which columns are required, what each one does, and how to fix validation errors.

Updating items that already exist? Use Update Items in Bulk with CSV Import instead. The columns are the same, but the workflow and rules differ.
Metrc companies: if your company has a Metrc facility, you can bulk-create non-cannabis items only. Cannabis items go through Flourish Support. See Metrc Companies: Non-Cannabis Items Only.

Prerequisites

Your user role needs the Bulk update items (update company item master) permission. To turn it on:

  1. Click the gear icon (Settings).
  2. Select User Roles.
  3. Select the facility you need.
  4. Click the Configure icon.
  5. Locate the Admin card.
  6. Next to Inventory, click Actions to open the Actions for Admin Inventory modal.
  7. Check Bulk update items (update company item master).
  8. Click Save.
    The Edit Role page for the Admin role in Flourish, with the Inventory module's Actions panel expanded and the Bulk update items permission shown.
Tip: log out and log back in to see the permission take effect.

Before You Begin

  • Download the CSV template from the Bulk Item Create screen before you fill in any data, so your column headers match what Flourish expects.
  • Remove the example data on the first row of the template.
  • Don't delete, rename, or reorder columns, even ones you don't use. Leave unused columns blank.
  • Leave the ID column blank. Flourish assigns IDs when it creates the items.
  • Make sure the Classes, Categories, Brands, and Strains you reference already exist in Flourish.
  • BioTrack facilities: fill in BioTrack Category for every cannabis item.
  • Need examples? Export rows from Bulk Item Update and copy rows that match the item types you need to create.

Create Items with a CSV

  1. Click the gear icon (Settings).
  2. Select Inventory, then Items.
  3. Click Bulk Update Items.
    The Items list page in Flourish Inventory settings, with the Bulk Update Items button.
  4. In the top right, click Bulk Create.
    The Bulk Item Update page in Flourish with the Bulk Create button highlighted in the top-right corner.
  5. Read the instructions and the NOTE on the page, then click Download an example CSV template.
    The Bulk Item Create screen showing the numbered workflow for adding new items to the item master.
  6. Open the CSV, remove the example row, and enter one row per new item. See the Column Reference below, or the Item Column Descriptions on the page.
  7. Save the file as a .csv.
  8. Click SELECT CSV, choose your file, and click UPLOAD.
    The CSV upload area of the Bulk Item Create screen with a selected file and the Upload button.
  9. Flourish validates the file. Review any errors on the right side of the screen, fix them in your CSV, and upload it again. See Troubleshooting Validation Errors.
  10. When the file passes validation, confirm on the confirmation screen to create the items.
  11. Go to All Items to check that the new items look right.

Metrc Companies: Non-Cannabis Items Only

If any facility in your company uses Metrc, you can bulk-create non-cannabis items, such as Raw Materials and Supplies, yourself. Cannabis items sync to Metrc and can't easily be undone, so Flourish Support loads those for you.

  • Every row's InventoryType must be something other than Cannabis.
  • If any row is Cannabis, validation fails on that row with this message, and nothing in the file is imported: "Cannabis items can't be bulk-created on Metrc companies yet. Remove these rows, or send the file to Flourish Support and we'll load them for you."
  • Non-cannabis items don't sync to Metrc, so there's no Metrc step after the import. The new items show a sync status of N/A.

To create cannabis items in bulk:

  1. Move the cannabis rows into their own CSV, and upload the non-cannabis rows as usual.
  2. Attach the cannabis CSV and submit the request. Support creates the items and syncs them to Metrc.
Companies without a Metrc facility (including BioTrack and NMS2S companies) can bulk-create cannabis and non-cannabis items in the same file.

Important Rules

  • UOM = Each: set UnitWeight/WeightUOM or UnitVolume/VolumeUOM on Each items, never both.
  • Class and Category: the Category must exist within the InventoryType and Class you enter.
  • RetailDisplayName: if left blank, Flourish sets it to the item's Name.
  • ProductSourceType: required for cannabis items. Once set, it can be changed but not removed.
  • InventoryType can't be changed after the item is created.
  • SellByLot: when on, the item must be sold from a specific lot or batch.

Column Reference

Required columns must be filled in for every row. All other columns are optional unless noted.

Required Fields

Column Name

Description

Example

ID

Flourish's internal item ID. Leave blank; Flourish assigns it.

(leave blank)

Name

The item name. Must be unique: no other item can share this Name or RetailDisplayName.

Bulk Flower - Hawaiian Sativa

InventoryType

The inventory type. Closely tied to Class. Can't be changed after creation. Metrc companies can't use Cannabis here; see Metrc Companies.

Cannabis, Raw Materials, Supplies

Class

The class of the item. Use together with Category.

Buds, Concentrate, Concentrate (each)

Category

The category of the item. Must exist within the Class. Use together with Class.

Buds (by strain), Tinctures

UOM

The top-level unit of measure for the item.

Each, Grams, Pounds, Milliliters, Liters

Basic Item Information

Column Name

Description

Required?

Example

RetailDisplayName

Display name shown to customers at retail. Defaults to Name if left blank.

No

Bulk Flower - Hawaiian Sativa - Grade A

SKU

Unique, human-readable item identifier. Important for integrations (QuickBooks, LeafLink, and others).

No

HAWAIIAN-ABC-123

PartNumber

Unique part number for the item.

No

987456321

NDC Number

NDC number for the item.

No

0777-3105-02

Brand

Brand the item falls under.

No

Willie's Reserve

ProductLine

Product line the item falls under.

No

Calm

Description

Long-form description of the item.

No

Our Hawaiian Sativa is grown to perfection...

StandardDailyUseDescription

Suggested daily usage description.

No

Use it when you need it!

Strain

Strain name. Setting this makes the item strain-required by default.

No

Hawaiian Sativa, Hawaiian Sativa x Sweet Tooth #3

ProductSourceType

Used during harvesting. Can't be removed once set, only changed.

Required for cannabis

Flower, Mixed

ReorderPoint

Quantity that triggers a reorder alert.

No

10, 30

State Traceability

Column Name

Description

Required?

Example

BioTrack Category

BioTrack category for cannabis items. Must be a valid BioTrack category for your state. Applies only to cannabis items in BioTrack facilities.

Required for cannabis items in BioTrack facilities

Flower, Concentrate

Weight, Volume & Dimensions

Set weight or volume on Each items, not both.

Column Name

Description

Required?

Example

WeightUOM

Weight unit of measure. Only if UOM = Each and the item is weight-based. Use with UnitWeight.

No

Grams, Pounds

UnitWeight

Unit weight value. Only if UOM = Each and the item is weight-based. Use with WeightUOM.

No

3.5, 7

UnitWeightDisplay

Custom label text for unit weight. Overrides the default number and UOM display.

No

1.25 g, 1 gram (0.035 oz), 1 cookie (10mg THC)

VolumeUOM

Volume unit of measure. Only if UOM = Each and the item is volume-based. Use with UnitVolume.

No

Milliliters, Liters

UnitVolume

Unit volume value. Only if UOM = Each and the item is volume-based. Use with VolumeUOM.

No

500, 1000

UnitVolumeDisplay

Custom label text for unit volume. Overrides the default number and UOM display.

No

1 mg, 5 mg per Dropper, 1 can (12 Oz)

SyncEachByWeightOrVolumeUom

Can only be set when the item is created. Ask your Implementation Engineer if you're unsure.

No

true, false, 1, 0

UnitLength

Unit length. Use with DimensionUOM.

No

10

UnitWidth

Unit width. Use with DimensionUOM.

No

10

UnitHeight

Unit height. Use with DimensionUOM.

No

10

DimensionUOM

Unit of measure for dimensions. Must be a length unit. Use with UnitLength, UnitWidth, and UnitHeight.

No

Inches, in, Centimeters, cm

Flags & Settings

These are true/false fields. Accepted values: 1, 0, true, false, TRUE, FALSE. Leave blank to use the default.

Column Name

Description

Example

Sellable

Marks the item as sellable.

true

SellByLot

The item must be sold from a specific lot or batch.

true, false

is_medical

Marks the item as a medical item.

true

NeedsFulfillment

Marks the item as requiring fulfillment.

true

eCommerceActive

Marks the item as active on your e-commerce menu.

true

LotTracked

Marks the item as lot-tracked.

true

IsTaxExempt

Marks the item as tax-exempt (for example, gift cards).

false

UseByDateReq

Requires a Use By Date when packages of this item are created. Blank is treated as false.

true

ShelfDays

When UseByDateReq = true, this many days are added to today's date to calculate the Use By Date.

7, 30, 365

E-Commerce

These fields control how the item appears on your connected e-commerce platform.

Column Name

Description

Required?

Example

eCommerceItemName

The item name on your e-commerce storefront, when it differs from your internal name.

No

Flower - Hawaiian Sativa

ItemStrainType

The strain type shown on your e-commerce menu.

No

Hybrid, Indica, Sativa, CBD, THC

eCommerceCategoryName

The category name on your e-commerce platform.

No

Flower

eCommerceSubCategoryName

The subcategory name on your e-commerce platform.

No

Cannabis Flower

Cannabinoid & Potency

Column Name

Description

Required?

Example

UnitCBDContentUOM

Unit of measure for CBD content. Use with UnitCBDContent.

No

Milligrams, mg

UnitCBDContent

CBD content per unit. Use with UnitCBDContentUOM.

No

100, 500

UnitCBDPercent

CBD percentage per unit.

No

0.5, 10, 25.5

UnitTHCContentUOM

Unit of measure for THC content. Use with UnitTHCContent.

No

Milligrams, mg

UnitTHCContent

THC content per unit. Use with UnitTHCContentUOM.

No

100, 500

UnitTHCPercent

THC percentage per unit.

No

0.5, 10, 25.5

CBDPerDoseUOM

Unit of measure for CBD per dose. Use with CBDPerDose.

No

Milligrams, mg

CBDPerDose

CBD per dose. Use with CBDPerDoseUOM.

No

100, 500

THCPerDoseUOM

Unit of measure for THC per dose. Use with THCPerDose.

No

Milligrams, mg

THCPerDose

THC per dose. Use with THCPerDoseUOM.

No

100, 500

Number of Servings

Number of servings per unit.

No

1, 3.5, 12

NumDosesPerUnit

Number of doses per unit.

No

10, 25

ServingSize

Serving size description. Maps to ServingSize in Metrc.

No

0.5 gram, 1/2 tablespoon, 1 brownie

ServingSizeInGrams

Serving size in grams.

No

0.100, 3.5

DaysOfSupply

Maps to SupplyDurationDays in Metrc. Also used in Flourish.

No

0, 1, 7, 30

UsableCannabisPerUnitUOM

Unit of measure for usable cannabis per unit. Use with UsableCannabisPerUnit.

No

Gram, g, Pound, lb, Milligram, mg, Milliliter, mL

UsableCannabisPerUnit

Usable cannabis per unit. Maps to MMJ Used Qty in some states. Use with UsableCannabisPerUnitUOM.

No

3.5, 14

Metrc Fields

These fields map to Metrc and aren't used anywhere else in Flourish unless noted.

Column Name

Description

Required?

Example

MetrcAdministrationMethod

Maps to AdministrationMethod in Metrc only.

No

Light it up!

MetrcItemIngredients

Maps to Ingredients or PublicIngredients in Metrc only.

No

THC, CBD, Love, Sunshine, Water!

ItemIngredients

Maps to Product, Package, and Harvest Package labels only.

No

THC, CBD, Love, Sunshine, Water!

Allergens

Maps to item allergens in Metrc. Can also be added to Product, Package, and Harvest Package labels.

No

None, Tree Nuts, Soy, Latex

Pricing

Tip: use Price for a single standard price. Use RetailPrice, WholesalePrice, and their discount columns for Extended Item Pricing tiers. See Set Up Item Pricing.

Column Name

Description

Required?

Example

Cost

Standard cost per unit.

No

1.25, 15

Price

Default selling price per unit.

No

2.50, 25

RetailPrice

Retail price per unit.

No

2.50, 25

RetailDiscountPrice

Retail discount price per unit.

No

2.25, 22.50

WholesalePrice

Wholesale price per unit.

No

2.00, 20

WholesaleDiscountPrice

Wholesale discount price per unit.

No

1.75, 17.50

Reference Fields

Five free-text fields for any item-level data your team tracks.

Column Name

Description

Example

RefField1

Reference Field 1.

Sample, Test Item

RefField2

Reference Field 2.

Sample, Test Item

RefField3

Reference Field 3.

Sample, Test Item

RefField4

Reference Field 4.

Sample, Test Item

RefField5

Reference Field 5.

Sample, Test Item

QuickBooks & Accounting

Note: don't edit QBO Item Type if your QuickBooks integration is turned off.

Column Name

Description

Required?

Example

Expense Account

Cost of Goods Sold account name for the item.

No

CostOfGoodsSold

Revenue Account

Revenue account name for the item.

No

Revenue

Asset Account

Asset account name for the item.

No

Assets

QBO Item Type

QuickBooks item type.

No

Inventory

System Fields

Flourish manages these columns. Don't edit them.

Column Name

Description

Notes

Enabled

All new items are created as active (enabled).

Read-only

External

Ignored during bulk create. Items created here are always internal items.

Read-only

Troubleshooting Validation Errors

After you upload the CSV, errors appear on the right side of the Bulk Item Create screen. Fix them in the CSV, save, and upload again until no errors remain, then confirm.

If you see

Do this

"Cannabis items can't be bulk-created on Metrc companies yet..."

Your company has a Metrc facility. Remove the cannabis rows and upload the rest, then send the cannabis rows to Support with Request help from Support. See Metrc Companies.

Category not found in the InventoryType/Class

Check that the Category exists under that Class and InventoryType in your settings.

Duplicate Name or RetailDisplayName

Each item needs a unique Name and RetailDisplayName. Check your item master for conflicts.

UnitWeight and UnitVolume both set

Clear the one that doesn't apply.

Missing ProductSourceType

Fill it in for every row with InventoryType = Cannabis.

BioTrack Category missing or invalid

In BioTrack facilities, enter a valid BioTrack category for your state on cannabis rows. Leave it blank on non-cannabis rows.

Invalid true/false value

Flag columns (Sellable, LotTracked, and so on) accept only 1, 0, true, false, TRUE, FALSE.

Still stuck? Contact Flourish Support.

How did we do?

Update Items in Bulk with CSV Import

Brand Management