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.
Prerequisites
Your user role needs the Bulk update items (update company item master) permission. To turn it on:
- Click the gear icon (Settings).
- Select User Roles.
- Select the facility you need.
- Click the Configure icon.
- Locate the Admin card.
- Next to Inventory, click Actions to open the Actions for Admin Inventory modal.
- Check Bulk update items (update company item master).
- Click Save.

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 Categoryfor 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
- Click the gear icon (Settings).
- Select Inventory, then Items.
- Click Bulk Update Items.

- In the top right, click Bulk Create.

- Read the instructions and the NOTE on the page, then click Download an example CSV template.

- 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.
- Save the file as a
.csv. - Click SELECT CSV, choose your file, and click UPLOAD.

- 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.
- When the file passes validation, confirm on the confirmation screen to create the items.
- 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
InventoryTypemust be something other thanCannabis. - 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:
- Move the cannabis rows into their own CSV, and upload the non-cannabis rows as usual.
- Attach the cannabis CSV and submit the request. Support creates the items and syncs them to Metrc.
Important Rules
- UOM = Each: set
UnitWeight/WeightUOMorUnitVolume/VolumeUOMon Each items, never both. - Class and Category: the
Categorymust exist within theInventoryTypeandClassyou 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 |
| Flourish's internal item ID. Leave blank; Flourish assigns it. | (leave blank) |
| The item name. Must be unique: no other item can share this Name or RetailDisplayName. |
|
| The inventory type. Closely tied to Class. Can't be changed after creation. Metrc companies can't use |
|
| The class of the item. Use together with |
|
| The category of the item. Must exist within the Class. Use together with |
|
| The top-level unit of measure for the item. |
|
Basic Item Information
Column Name | Description | Required? | Example |
| Display name shown to customers at retail. Defaults to | No |
|
| Unique, human-readable item identifier. Important for integrations (QuickBooks, LeafLink, and others). | No |
|
| Unique part number for the item. | No |
|
| NDC number for the item. | No |
|
| Brand the item falls under. | No |
|
| Product line the item falls under. | No |
|
| Long-form description of the item. | No |
|
| Suggested daily usage description. | No |
|
| Strain name. Setting this makes the item strain-required by default. | No |
|
| Used during harvesting. Can't be removed once set, only changed. | Required for cannabis |
|
| Quantity that triggers a reorder alert. | No |
|
State Traceability
Column Name | Description | Required? | Example |
| 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 |
|
Weight, Volume & Dimensions
Set weight or volume on Each items, not both.
Column Name | Description | Required? | Example |
| Weight unit of measure. Only if | No |
|
| Unit weight value. Only if | No |
|
| Custom label text for unit weight. Overrides the default number and UOM display. | No |
|
| Volume unit of measure. Only if | No |
|
| Unit volume value. Only if | No |
|
| Custom label text for unit volume. Overrides the default number and UOM display. | No |
|
| Can only be set when the item is created. Ask your Implementation Engineer if you're unsure. | No |
|
| Unit length. Use with | No |
|
| Unit width. Use with | No |
|
| Unit height. Use with | No |
|
| Unit of measure for dimensions. Must be a length unit. Use with | No |
|
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 |
| Marks the item as sellable. |
|
| The item must be sold from a specific lot or batch. |
|
| Marks the item as a medical item. |
|
| Marks the item as requiring fulfillment. |
|
| Marks the item as active on your e-commerce menu. |
|
| Marks the item as lot-tracked. |
|
| Marks the item as tax-exempt (for example, gift cards). |
|
| Requires a Use By Date when packages of this item are created. Blank is treated as |
|
| When |
|
E-Commerce
These fields control how the item appears on your connected e-commerce platform.
Column Name | Description | Required? | Example |
| The item name on your e-commerce storefront, when it differs from your internal name. | No |
|
| The strain type shown on your e-commerce menu. | No |
|
| The category name on your e-commerce platform. | No |
|
| The subcategory name on your e-commerce platform. | No |
|
Cannabinoid & Potency
Column Name | Description | Required? | Example |
| Unit of measure for CBD content. Use with | No |
|
| CBD content per unit. Use with | No |
|
| CBD percentage per unit. | No |
|
| Unit of measure for THC content. Use with | No |
|
| THC content per unit. Use with | No |
|
| THC percentage per unit. | No |
|
| Unit of measure for CBD per dose. Use with | No |
|
| CBD per dose. Use with | No |
|
| Unit of measure for THC per dose. Use with | No |
|
| THC per dose. Use with | No |
|
| Number of servings per unit. | No |
|
| Number of doses per unit. | No |
|
| Serving size description. Maps to | No |
|
| Serving size in grams. | No |
|
| Maps to | No |
|
| Unit of measure for usable cannabis per unit. Use with | No |
|
| Usable cannabis per unit. Maps to MMJ Used Qty in some states. Use with | No |
|
Metrc Fields
These fields map to Metrc and aren't used anywhere else in Flourish unless noted.
Column Name | Description | Required? | Example |
| Maps to | No |
|
| Maps to | No |
|
| Maps to Product, Package, and Harvest Package labels only. | No |
|
| Maps to item allergens in Metrc. Can also be added to Product, Package, and Harvest Package labels. | No |
|
Pricing
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 |
| Standard cost per unit. | No |
|
| Default selling price per unit. | No |
|
| Retail price per unit. | No |
|
| Retail discount price per unit. | No |
|
| Wholesale price per unit. | No |
|
| Wholesale discount price per unit. | No |
|
Reference Fields
Five free-text fields for any item-level data your team tracks.
Column Name | Description | Example |
| Reference Field 1. |
|
| Reference Field 2. |
|
| Reference Field 3. |
|
| Reference Field 4. |
|
| Reference Field 5. |
|
QuickBooks & Accounting
QBO Item Type if your QuickBooks integration is turned off.Column Name | Description | Required? | Example |
| Cost of Goods Sold account name for the item. | No |
|
| Revenue account name for the item. | No |
|
| Asset account name for the item. | No |
|
| QuickBooks item type. | No |
|
System Fields
Flourish manages these columns. Don't edit them.
Column Name | Description | Notes |
| All new items are created as active (enabled). | Read-only |
| 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 |
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 ( |
Still stuck? Contact Flourish Support.
How did we do?
Update Items in Bulk with CSV Import
Brand Management