Each column on the CSV you choose to import must follow certain rules depending on which Distru Field you map it to. Here is a list of rules and descriptions for each Distru Field, categorized by the different objects you can import.

Use CTRL-F to quickly search this document for the column header you need help with

Quick Links

Companies

  • Company Name - The display name in Distru for this company record

    • Required

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

    • Cannot have a duplicate record with the same company name on the CSV

    • Cannot have a duplicate record with the same company name existing in Distru, unless this record is being updated using the Company ID column

  • Legal Business Name - The name of the company as listed on their license

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Email - Main contact email for the company

    • Must be a valid email address

  • Leaflink Customer Name - The name of this company as listed in Leaflink that should be synced to this company record

    • Must be an exact match to the Leaflink customer name

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Image Name - File name of the image for this company

    • Values must come from existing images in Distru. Can be used for moving images via bulk update or migration to a new account

  • Image Scope - Unique identifier for the image

    • Values must come from existing images in Distru. Can be used for bulk update or migration to a new account

  • Image URL Original

    • Values must come from existing images in Distru. Can be used for bulk update or migration to a new account

  • Image URL Thumb

    • Values must come from existing images in Distru. Can be used for bulk update or migration to a new account

  • Image URL Small

    • Values must come from existing images in Distru. Can be used for bulk update or migration to a new account

  • Image URL Medium

    • Values must come from existing images in Distru. Can be used for bulk update or migration to a new account

  • Image URL Large

    • Values must come from existing images in Distru. Can be used for bulk update or migration to a new account

  • Owner - User name that is assigned as owner of this company record

    • Must be existing user's full name exact match as it appears in Distru

  • Group - Customizable group classification for companies

    • Groups do not need to exist in Distru before upload. New groups will be automatically created

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Relationship Type - How the company relates to your operation

    • Required

    • Only accepts values that exist in Distru before upload. New values can be added manually

    • Default values include Branch, Current Customer, Current Supplier, Potential Customer, Potential Supplier

  • Category - The type of operation for the company

    • Required

    • Accepted values: Cultivator, Delivery, Dispensary, Distributor, Lab, Manufacturer, Microbusiness, Other, Retail

  • Description - Description to display on the company record

  • Phone Number - Main company phone number

  • Website - Main company website

    • Must be a URL

  • Facebook - Company Facebook link

    • Must be a Facebook URL

  • Instagram - Company Instagram link

    • Must be an instagram URL

  • Twitter - Company Twitter link

    • Must be a Twitter URL

  • Weedmaps - Company Weedmaps link

    • Must be a Weedmaps URL

  • Leafly - Company Leafly link

    • Must be a leafly URL

  • Order Email - Default email address to send Sales Orders to for this company

    • Must be a valid email address

  • Invoice Email - Default email address to send Invoices to for this company

    • Must be a valid email address

  • Purchase Email - Default Email to send Purchase Orders to for this company

    • Must be a valid email address

  • Order Shipment Email - Default email to send Shipment packing slips to for this company (Non-Metrc shipments)

    • Must be a valid email address

The following columns can be duplicated to insert multiple values, but must include a # followed by a number in the column name to relate to each other properly

Example: License Active #1, License Number #1, License Type #1, License Issue Date #1, License Expiry Date #1, License Active #2, License Number #2 License Type #2, License Issue Date #2, License Expiry Date #2,

  • License Active - Is this license Active?

    • REQUIRED if "License Number" has a value entered

    • Accepted values: TRUE,FALSE

  • License Number - The license number for this company

    • Must be a valid license number format for your state

  • License Type - The legal type for the license number provided

    • REQUIRED if "License Number" has a value entered

    • Accepted Values for California

      • Type 6 Non Volatile Solvent Extraction

      • Type 7 Volatile Solvent Extraction

      • Type 8 Testing

      • Type 9 Non-Storefront

      • Type 10 Retailer

      • Type 11 Distributor

      • Type 12 Microbusiness

      • Type 13 Distributor-Transport Only

      • Type N Infusion

      • Type P Packaging and Labeling

      • Specialty Cottage Outdoor

      • Specialty Cottage Indoor

      • Specialty Cottage Mixed-Light Tier 1

      • Specialty Cottage Mixed-Light Tier 2

      • Specialty Outdoor, Specialty Indoor

      • Specialty Mixed-Light Tier 1

      • Specialty Mixed-Light Tier 2

      • Small Outdoor, Small Indoor

      • Small Mixed-Light Tier 1

      • Small Mixed-Light Tier 2

      • Nursery

      • Processor

      • Other

    • Accepted Values for Colorado

      • Cultivation

      • Delivery

      • Operator

      • Product Manufacturer

      • R&D Cultivation

      • Store

      • Testing Facility

      • Transporter

      • Transporter - NP

    • Accepted Values for Oregon

      • Laboratory

      • Recreational Processor

      • Recreational Producer

      • Recreational Retailer

      • Recreational Wholesaler

      • Research Certificate

    • Accepted Values for Oklahoma

      • Dispensary - DA

      • Grower - GA

      • Lab - LA

      • Processor - PA

      • Transporter - TA

      • Other

    • Accepted Values for Michigan

      • Class A Grower

      • Class B Grower

      • Class C Grower

      • Designated Consumption Establishment

      • Entity Prequalification

      • Entity Registration

      • Event Organizer

      • Excess Grower

      • Individual Prequalification

      • Microbusiness

      • Processor

      • Provisioning Center

      • Retailer

      • Safety Compliance

      • Secure Transporter

      • Sole Proprietor

      • Temporary Event

    • Accepted Values for Massachusetts

      • Cultivator

      • Microbusiness

      • Product Manufacturer

      • Retail

      • Testing Laboratory

      • Transporter (Existing Licensee)

      • Transporter (Third Party)

    • Accepted Values for Nevada

      • Cultivation Facility

      • Distributor Facility

      • Product Manufacturing Facility

      • Retail Store

      • Testing Facility

    • Accepted Values for Maine

      • Cultivation Tier 1

      • Cultivation Tier 2

      • Cultivation Tier 3

      • Cultivation Tier 4

      • Distributor

      • Marijuana Store

      • Marijuana Testing Facility

      • Nursery Cultivation

      • Product Manufacturing Facility

  • License Issue Date

    • REQUIRED if "License Number" has a value entered

    • Accepted format: Month/Day/Year (10/31/2020)

  • License Expiry Date

    • REQUIRED if "License Number" has a value entered

    • Accepted format: Month/Day/Year (10/31/2020)

  • Location Name - Name for a specific location related to this company

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Location Address - Complete location address

    • REQUIRED if "Location Name" has a value entered

    • Separate by commas: Street Address, Apt Number, City, State, Country, Zip

  • Location Street Address

    • REQUIRED if "Location Name" has a value entered

    • Number and Street Name (420 Smoke Lane)

  • Location Apt Number

    • Apartment or Suite number (Unit 4) - Must be separate from Street Address

  • Location City

  • Location State

  • Location Country

  • Location Zip

  • Location Latitude

    • Not required, but can be input if you want to manually enter location geocode

  • Location Longitude

    • Not required, but can be input if you want to manually enter location geocode

  • Location Manual - Should this location be automatically geocoded?

    • Accepted Values: TRUE, FALSE

      • TRUE = Do not automatically geocode

      • FALSE = Automatically geocode

  • Location License Number - License number associated with this location

    • Must be a license number listed in the "License Number" column for this record

Products

  • Name - The name of this product to be displayed in Distru and Menus

    • Required

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Leaflink Product - The name of the Leaflink Product this product should be mapped to

    • Must be exact name match to a Leaflink Product

    • Requires Leaflink API integration to be turned on first

  • SKU - The unique SKU number for this product

    • Required

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Unit Type Name - Unit of measurement for this product

    • Required

    • Accepted Values: Gram, Kilogram, Miligram, Ounce, Pound, Fluid Ounce

      Gallon, Liters, Milliliter, Pint, Quart, Unit

  • Category Name - Category this product belongs to

    • Required

    • Categories must exist in the Distru account prior to upload

      • View and add additional categories in your account through Settings > Customize Distru > Product Categories

      • Accepted Values for CA

        Capsule

        Clone - Cutting

        Clone - Tissue Culture

        Edible (volume - each)

        Edible (volume)

        Edible (weight - each)

        Edible (weight)

        Extract (volume - each)

        Extract (volume)

        Extract (weight - each)

        Extract (weight)

        Flower

        Flower (packaged eighth - each)

        Flower (packaged gram - each)

        Flower (packaged half ounce - each)

        Flower (packaged ounce - each)

        Flower (packaged quarter - each)

        Fresh Cannabis Plant

        Immature Plant

        Infused Butter/Oil (volume - each)

        Infused Butter/Oil (volume)

        Infused Butter/Oil (weight - each)

        Infused Butter/Oil (weight)

        Kief

        Leaf

        Other Concentrate (volume - each

        Other Concentrate (volume)

        Other Concentrate (weight - each)

        Other Concentrate (weight)

        Packaging

        Pre-Roll Flower

        Pre-Roll Infused

        Pre-Roll Leaf

        Seeds

        Seeds (each)

        Shake

        Shake (Packaged Eighth - each)

        Shake (Packaged Gram - each)

        Shake (Packaged Half Ounce - each)

        Shake (Packaged Ounce - each)

        Shake (Packaged Quarter - each)

        Tincture (volume - each)

        Tincture (volume)

        Tincture (weight - each)

        Tincture (weight)

        Topical (volume - each)

        Topical (volume)

        Topical (weight - each)

        Topical (weight)

        Vape Cartridge (volume - each)

        Vape Cartridge (weight - each)

        Waste

      • Accepted Values for CO

        Bud allocated for extraction

        Buds

        Concentrate

        Concentrate (Each)

        Contaminated Product Allocated for Extraction

        Extract (each)

        Immature Plants

        Infused (edible)

        Infused (non-edible)

        Seeds

        Shake/Trim

        Shake/Trim (by strain)

        Shake/Trim allocated for extraction

        Wet Whole Plants

      • Accepted Values for MA

        Bud allocated for extraction

        Buds

        Concentrate

        Concentrate (Each)

        Contaminated Product Allocated for Extraction

        Extract (each)

        Immature Plants

        Infused (edible)

        Infused (non-edible)

        Seeds

        Shake/Trim

        Shake/Trim (by strain)

        Shake/Trim allocated for extraction

        Wet Whole Plants

      • Accepted Values for ME

        Buds/Flower

        Capsule

        Concentrate (Each)

        Concentrate (Weight)

        Drink

        Edible (Liquid/Tincture)

        Edible (Solid)

        Immature Plants (Seedling)

        Infused Non-Edibles

        Infused Pre-Roll

        Kief (Flower)

        Kief (Mixed Strain)

        Mature Plants (Each)

        Raw Pre-Rolls

        Seeds

        Shake/Trim

        Shake/Trim (by strain)

        Suppository

        Topical

        Vape Products

        Vegetative Plants (Immature)

        Wet Flower

        Wet Trim

      • Accepted Values for MI

        Buds

        Concentrate

        Concentrate (Each)

        Gas

        Immature Plants

        Infused Liquid

        Infused Liquid (Each)

        Infused Non-Edible

        Infused-Edible

        Seeds

        Shake/Trim

        Shake/Trim (by strain)

        Wet Whole Plants

      • Accepted Values for MO

        Buds/Flower

        Wet Whole Plant

        Immature Plants

        Kief

        Seeds

        Shake/Trim

        Shake/Trim (by strain)

        Vegetative Plants

        Wet Flower

        Wet Trim

        Capsule

        Concentrate

        Concentrate (Each)

        Concentrate (Weight)

        Drink

        Edible (Liquid/Tincture)

        Edible (Solid)

        Infused Non-Edibles

        Infused Pre-Roll

        Suppository

        Topical

        Vape Products

        Waste

        Dermal Patch

        Liquid Tincture

      • Accepted Values for MT

        Bud allocated for extraction

        Buds

        Concentrate

        Concentrate (Each)

        Contaminated Product Allocated for Extraction

        Extract (each)

        Immature Plants

        Infused (edible)

        Infused (non-edible)

        Seeds

        Shake/Trim

        Shake/Trim (by strain)

        Shake/Trim allocated for extraction

        Wet Whole Plants

      • Accepted Values for NV

        Capsule/Tablet

        Flowers/Buds Approved for Extraction

        Immature Plants

        Infused Edible : @edible_subcategories

        Infused Non-Edible

        Infused Pre-rolls

        Kief

        Marijuana Flowers/Buds

        Non-Solvent Based Concentrate

        Non-Solvent Based Concentrate (Each)

        Pre-rolled cigs/joints

        R&D Testing / Homogeneity Testing (Count-based)

        R&D Testing / Homogeneity Testing (Weight-based)

        Seeds

        Seeds (bulk)

        Shake/Trim

        Shake/Trim Approved for Extraction

        Small/Popcorn Buds

        Solvent Based Concentrate

        Solvent Based Concentrate (Each)

        Terpenes

        Tinctures

        Tinctures (Each)

        Waste

        Wet Whole Plant Approved for Extraction

        Whole Wet Plant

      • Accepted Values for OK

        Concentrate (Non-Solvent Based) (Count-Volume)

        Concentrate (Non-Solvent Based) (Count-Weight)

        Concentrate (Weight Based)

        Edibles (Count-Volume)

        Edibles (Count-Weight)

        Extracts (Solvent Based) (Count-Volume)

        Extracts (Solvent Based) (Count-Weight)

        Flower & Buds

        Immature Plants

        Kief

        Mature Plants

        Metered Dose Nasal Spray Products

        MMJ Waste

        Pre-Roll (Flower Only)

        Pre-Roll (Infused)

        Pressurized Metered Dose Inhaler Products

        Rectal/Vaginal Administration Products (Count-Volume)

        Rectal/Vaginal Administration Products (Count-Weight)

        Seeds

        Tinctures (Count-Volume)

        Tinctures (Count-Weight)

        Topicals (Count-Volume)

        Topicals (Count-Weight)

        Transdermal Patches

        Vape Cartridges

        Whole Wet Plant

        Shake/Trim

        Shake/Trim (by Strain)

      • Accepted Values for OR

        Buds

        Buds (by strain)

        Capsule

        Capsule (each)

        Combined Category

        Combined Category (each)

        Concentrate

        Concentrate (Each)

        Edibles

        Edibles (each)

        Extracts

        Extracts (each)

        Harvested Industrial Hemp

        Hemp Cannabinoid Product

        Hemp Cannabinoid Product (each)

        Hemp Concentrate

        Hemp Concentrate (each)

        Hemp Extract

        Hemp Extract (each)

        Immature Plants

        Infused Pre-Roll

        Inhalable Cannabinoid Product with Non-Cannabis Additives

        Inhalable Cannabinoid Product with Non-Cannabis Additives (each)

        Inhalable Cannabinoid Product with Non-Cannabis Additives (each - with ingredients)

        Inhalable Cannabinoid Product with Non-Cannabis Additives (with ingredients)

        Inhalable Hemp Cannabinoid Product with Non-Cannabis Additives

        Inhalable Hemp Cannabinoid Product with Non-Cannabis Additives (each)

        Inhalable Hemp Cannabinoid Product with Non-Cannabis Additives (each - with ingredients)

        Inhalable Hemp Cannabinoid Product with Non-Cannabis Additives (with ingredients)

        Non-Infused (Plain) Pre-Roll

        Seeds (each)

        Seeds (weight)

        Shake/Trim

        Shake/Trim (by strain)

        Suppository

        Suppository (each)

        Tinctures

        Tinctures (each)

        Topicals

        Topicals (each)

        Transdermal Patch

        Transdermal Patch (each)

        Usable Hemp

        Waste

        Whole Harvested Plant

  • Subcategory Name - Sub-classification of this product in relation to the Product Category

    • Subcategories must exist in the Distru account prior to upload

    • View and add additional subcategories in your account through Settings > Customize Distru > Product Categories by adding them to their relevant Categories

  • Description - Description of this product. Visible in Live Menu

  • Inventory Tracking Method - Tracking style of inventory for this product

    • Required

    • Accepted Values: package, batch, product

      • package = Cannabis Inventory tracked in Metrc

      • batch = Inventory where every portion belongs to a specific batch (ideal for packaging)

      • product = Inventory is tracked in sums by location (Ideal for service line items)

  • Unit Cost

    • Number only (exclude $)

  • Unit Price

    • Required

    • Number only (exclude $)

  • Wholesale Unit Price

    • Number only (exclude $)

  • Vendor Name - The vendor that supplies this product to you. If you make it yourself, put your own company

    • Required

    • Vendor name must be an exact match to an existing Company in the Distru account

  • Brand Name - The brand that is associated with this product

    • Brand name must be an exact match to an existing Company in the Distru account

  • Product Group Name - Customizable grouping for products

    • Groups do not need to exist prior to upload, new groups will be automatically created

  • UPC - UPC code associated with this product

  • THC - Average THC level for this product

  • CBD - Average CBD level for this product

  • Inactive - Products marked inactive are removed from regular view/access but are not deleted. Can be returned to active

    • Required

    • Accepted Values: TRUE, FALSE

Contacts

  • First Name - The first name of this contact

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Last Name - The last name of this contact

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Description - A note about this contact

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Title - The position/role of this contact at their company

    • Cannot contain special characters EXCEPT FOR ,, ~, #, -, $, /, |, %, &, ', (), and .

  • Email - Email address specific to this contact

    • Must be a valid email address

  • Phone - Phone number specific to this contact

    • Numerical values only

  • Work Phone - Alternate work phone specific for this contact

    • Numerical values only

  • Owner Full Name - Distru user assigned as the owner of this contact

    • Must be an exact name match of the Distru user's full name

  • Employer - The company record this contact should be associated with

    • Must be an existing company in Distru

    • Must be an exact name match fo the company record

Did this answer your question?