Skip to main content
Table of Contents

Update Items in bulk

Create or edit item attributes using a spreadsheet to export the data and import updates.

Table of Contents

Bulk Update Items

Purpose

Use Bulk Update Items to update existing items in Flourish without editing them one by one.

Prerequisites

Your User Role must have Bulk update items (update company item master) checked.

Enable the Permission
  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 the box for Bulk update items (update company item master).
  8. Click Save.

Log out and log back in to see the change.

Bulk Update Items
  1. Click Settings.
  2. Select Inventory.
  3. Click Bulk Update Items.
  4. Read the IMPORTANT section on the page carefully, then follow the on-page instructions.
  5. To update external items, check the box on the download screen.
  6. Refer to the Item Column Descriptions section on the page for details on each CSV field.
Flourish supports uploading additional attributes on items, including page dimensions and reference fields, for use in future custom reporting.
Good to Know - Please Read
  • Do not change the column names in the CSV file.
  • Users with the permission described in Prerequisites can use the CSV import to disable items in Flourish. Disabling items or strains through bulk import or update does not deactivate them in any external system.
  • The currently supported fields appear in the Item Column Descriptions grid on the Bulk Item Update page, and also appear in an export.
  • Do not delete any columns from the exported data. You can hide columns as you edit, but do not delete. All columns are updated; this may change in a future release.
  • Bulk Update Items supports updating existing items only. Importing new items will be available in a future release.
  • This feature does not delete or disable items in METRC. If you disable an item, it will only be disabled in Flourish.
  • You can update the Name of an item, only if no packages have been created. You cannot update items integrated with Leaflink, QuickBooks, or METRC.
  • You can update the Strain of an item only if packages have never been created for it.
  • Do not edit the data in the ID column. The API uses this column to identify which item to update.
  • Do not edit the data in the InventoryType column. This column supports filtering and sorting on the exported data before you trigger an update.
  • Do not edit the data in the SyncEachByWeightOrVolumeUom column. This column supports filtering and sorting on the exported data before you trigger an update.
  • The Bulk Item Update page also includes additional helpful documentation. Review it before uploading your file.
Troubleshooting a CSV Error

If you see an error like the one below, the uploaded CSV is missing one or more required columns:

Fatal Error: failed to read CSV file data in *items.Updater.Update: error reading CSV bytes: found unmatched struct field with tags [Description Class]

In the example above, the Description and Class columns were either missing from the file or their column headers were changed before upload. This can also happen if Flourish released an update that added new fields, and the file you are uploading is from an earlier version.

You can resolve this by adding the missing columns to the file, but proceed carefully — this action can remove existing data.

  • Download a new CSV and reapply your changes to the up-to-date file. This is the safest option.
  • Adding blank columns can work if the fields do not affect your operations.
  • Blank content in an uploaded column only overwrites existing data if the database currently holds a non-empty value for that field.

How did we do?

Create and Update Strains in Bulk

Create and Manage Item Price Sets for Retail and Wholesale

Contact