Add products to the Dutchie Connect Catalog

Learn how to add products individually or use the Import function to add products in bulk, by uploading a CSV, to add multiple products at one time.

Things to know

  • If you support multiple sub-brands within your account, you must first use the brand selector located in the upper right-hand corner of Dutchie Connect to select the brand for which you will be importing products. This must be done one brand at a time.
    • Once you have selected the appropriate brand, product uploades must match the selected brand only.
    • Each CSV upload supports one brand at a time. If you manage multiple brands, please upload a separate spreadsheet for each
  • You must use the Dutchie Connect Template, or you will encounter errors.
  • Our template has data validation built in, so you can select the appropriate values to easily fill in your product information. Once the completed template is converted to a CSV, all spelling and capitalization must match what is provided in the template to avoid upload errors.
  • This tool should only be used to add new products, and will not check for potential duplicates or edit existing products. 
  • To modify existing products in bulk, first export the products from the Catalog in order to capture each product's unique ID. This will allow the system to map updates back to the appropriate product without creating duplicates. See the "Edit products in bulk" section of Manage Products in Dutchie Connect.

Add a single product from the Products page

Note: Each SKU should have a separate Product record for every market where it's sold. For example, if you sell the same strawberry edible SKU in 10 states, create 10 catalog records—one for each state.

  • Click the Add Product button located at the top of the Products table.
  • Fill out the fields in the Add Library Item form. 
    Note: A preview of how your product will display on Dutchie dispensary menus will appear in the sidebar.
  • Click Save.
  • Navigate back to the Products page to see the new item in the table. You may need to refresh your browser.

Add products to Dutchie Connect in bulk via CSV

 

Dutchie Connect Catolog template 

We've prepared a comprehensive catalog template which includes data validation in the rows and columns. The data validation helps avoid errors, such as entering a subcategory that our system does not recognize. 

Prepare your template for bulk upload to Dutchie Connect

You'll need to prepare the template with product information before uploading it. 

Tip: Each product SKU should have a separate product record for each market where it's sold. For example, if you sell the same strawberry edible SKU in 10 states, create 10 catalog records  or rows—one for each state.

  1. Add product details and new image links. See the Template Field Guide for information regarding each column within the template. All required fields must be completed. 
  2. Once the fields are complete, save each tab as a CSV. Each completed tab in the template (one per category) must be downloaded as a separate CSV for import. 
    • Click File > Download > CSV for each tab.
  3. Delete empty rows from the file.
  4. After removing empty rows, save your file as a new CSV.
  5. Import your CSV.

Dutchie Connect Template - Field Guide

Field  New  Description 
Product Name

Product names do not need to include the brand name as the two will always show near each other on menus. Both fields will return in a search query by a customer as well.

If the product comes in multiple sizes or weights, please list them separately within the template and add a differentiating aspect to the naming convention."


Flower product names should not include the weights as those will be displayed on the PDP along with the category and sub-category.

  • Example: Sour Diesel


Pre-Roll, Vaporizer, and Concentrate product names must include weights. Multi-packs should also include pack sizes. 

  • Example: Sour Diesel Pre-Roll 2-pack | 1g
  • Example: Gorilla Glue Live Resin Cartridge | 1g


Edible & Tincture product names should include total THC potency. 
 

  • Example: Sour Apple Gummies 10-pack | 100mg
     
Brand Name

Important: Brands should be entered onto the template exactly as they appear in the Connect admin. 
 

Tip: Navigate to Settings > Brands to copy your brand name exactly. You can also copy your Brand name from an existing product in your catalog. 
State/Province

Select the state from the dropdown list.

  • Important: Dutchie's Product libraries are segmented by market to ensure compliance rules and content preferences are met. If a product is available in multiple states, duplicate the row and adjust the state cell. 

 

States and provinces should be denoted using postal abbreviations. e.g. CA, OR, AB, NY, etc 
Description This space is for your product description and there is no character limit.
Category The Category is pre-selected for you when you use the template to reduce errors when importing. 
Subcategory Use the dropdown list from the Dutchie Connect Catalog Template to ensure you are using proper values that the system will accept.
Type

This field denotes the strain type of the cannabis product. Please use the options included in the template to ensure accurate filtering on store menus.

  • Indica
  • Sativa
  • Hybrid
  • High-CBD
  • Indica-Hybrid
  • Sativa-Hybrid
  • THC
  • 1 to 1
  • 2 to 1
  • 5 to 1
  • 10 to 1
  • 20 to 1
  • 50 to 1
  • N/A
Image

Image file format should be PNG or JPEG in a 1:1 ratio. Max file size is 20MB. There are no pixel size limits so please feel free to include the highest resolution available. We recommend images on a white or transparent background for a clean aesthetic.

  • Note:  Image links must lead to a publicly accessible image and cannot lead to folders, permission gated images, etc. **
  • Note: the import tool supports up to 9 images per product. However, you will need to add a column for each image that you’d like to import using the following naming convention:
  • Image
  • Image (2)
  • Image (3)
  • All the way up to Image (9)

 

Acceptable Image Formats:


 


 
   

Available Category and Subcategories

The following categories and subcategories are pre-associated on our eCommerce menus. These associations must be followed as provided in the template to avoid upload errors

Categories Subcategories
Flower Bulk Flower, Infused Bud, Infused Buds, Infused Shake, Pre-Ground, Premium, Shake/Trim, Small Buds, Smalls/Popcorn, Whole Flower
Pre-Rolls Blunts, Infused Pre-Rolls, Infused Pre-Roll Packs, Pre-Roll Packs, Shorties/Minies, Single Infused Pre-Roll, Singles
Vaporizers All-In-One, Cartridges, Cured Resin - Cartridge, Cured Resin - Disposable, Disposables, Live Resin, Live Resin - Cartridge, Live Resin - Disposable, Live Rosin, Live Rosin - Cartridge, Live Rosin - Disposable, Pods, Ratio, Specialty Pod, Bundles
Concentrate Applicators, Badder, Budder, Oil, Crumble, Cured Concentrates, Diamonds, Hash, Infused Flower, Isolate, Jam, Kief, Live Resin, Live Rosin, Rosin, RSO, Sauce, Shatter, Sugar, Wax
Edibles Baked Goods, Candy, Capsules/Tablets, Chews, Chocolates, Cooking/Baking, Dissolvables, Drink Mixes, Drinks, Frozen Treats, Gummies, Hard Candy, Live Resin Gummies, Live Rosin Gummies, Lozenges, Lozenges & Suckers, Mints, Savory Snacks, Soft Gels, Sublingual Products, Suckers, Troches
Topicals Balms, Bath Products, Lip Balms, Lotions, Lubricants, Topical Oils, Ratio, Soaps, Sticks/Roll-ons, Suppositories, Transdermals
Tinctures Flavored Tinctures, Herbal Tinctures, Pet Tinctures, Ratio, Sprays, Unflavored Tinctures
CBD n/a
Seeds n/a
Clones n/a
Accessories Batteries, Cleaning Solutions, Dab Tools, Devices, Gift Cards, Glassware, Grinders, Lighters, Papers/Rolling Supplies, Storage/Containers, Trays
Apparel n/a

Import your Dutchie Connect Catalog Template 

  1. Once your template is complete, it's time to convert and import your data
  2. Save each tab as a CSV: 
    1. a. Select a tab
      b. Click File > Download > Comma Separated Values (.csv)
      c. In the new CSV file, delete any empty rows to avoid import failures
      d. Save CSV
  3. Navigate to Catalog > Products, then click the Import button.
  4. While importing your file, you can view the progress of the data as it imports. 
  5. Data validation exists in the upload tool. For example, rows without product names, images, or descriptions will "fail" and prevent the entire row of data from importing. These failures will be captured in the "Failed Row" report with details on how to fix for a successful import. Please see "Correct errors after bulk upload" for more information.
  6. All successfully imported rows will be added to the catalog immediately.

Correct errors after bulk upload

Once the upload is complete, the Import Progress module will display will successfully added to the catalog as well as any rows that contained errors. View a list of errors here and how to correct them.

  1.  Download the failed rows
  2.  Correct the errors listed in the "ERRORS" column for each row
  3. Save updated CSV file

  4. Re-import the corrected products

    Tip: Downloading the failed rows will include only the products with errors, not successfully imported products.

View your Import History

The Import History tab displays import files that are "In Progress", "Completed" and "Failed" at the file level. You can click into each import to see which rows were successful or failed. You can also view the total rows or products under each outcome in the progress table.

Import history table with statuses and details

Was this article helpful?