Use the Product Uploader to create or update products in bulk. This tool supports detailed product setup, including tracking method, costs, ownership, and even initial inventory for certain product types.
✅ What You Can Do
Create new products with complete metadata
Update existing products using the Distru ID
Assign categories, groups, owners, strains, and unit types
Optionally:
Add images
Create initial inventory (product/batch-tracked only)
Generate default batches and menu listings
🧾 Preparing Your CSV File
🔻 Step 1: Download the Template
Go to Settings > Import Data > Products
Click Download Template
Template includes all supported fields with placeholders for up to 4 images.
🧩 Step 2: Fill in Product Fields
Column | Required | Notes |
Name | ✅ | Product name |
SKU / UPC | Optional | Unique identifiers |
Vendor / Brand | Optional | Must match existing company relationships |
Owner | Optional | Full name of a Distru user |
Featured / Inactive | Optional |
|
Product Category / Subcategory / Group / Strain | Optional | Auto-created if valid |
Leaflink Product | Optional | Must match a cached LL product name |
MSRP / Unit Cost / Unit Price / Wholesale Price | Optional | Supports multiple price types |
Unit Type Name | Optional | e.g. Each, Gram, etc. |
Net Quantity per Unit / Serving | Optional | Used for COGS calculations |
Tracking Method | Optional | One of: |
Units per Case | Optional | Numeric |
Thresholds (Min/Max) | Optional | Triggers stock alerts |
External Name | Optional | Alternative identifier |
Image Fields (Name + URLs) | Optional | Up to 4 images with rank, scope, etc. |
Initial Inventory + Location | Optional | Only for |
📤 Uploading Your File
Navigate to Import Products
Upload your CSV
Choose Create New or Update Existing
Map your fields
Submit
🎯 You’ll get a breakdown of inserted and updated products.
📎 Errors return an annotated CSV.
🔄 Update Mode Rules
Distru ID is required in each row to trigger updates
Fields left blank will be ignored
Cannot change the tracking method of an existing product
Initial inventory can only be added once, and not for
package-tracked productsDefault batch (
B1) will be created unless tracking method ispackageor product is updated
⚠️ Validation Notes
Company relationships (Vendor/Brand) must be uniquely named
Images must include names and valid URLs
Inventory Location must exist and be mapped to your license
Leaflink Products must match existing entries in your LL cache
Net Quantities and Serving Unit Type must be coherent and matched if used
💡 Pro Tips
Use
##to clear values (e.g. description or thresholds)Attach images by specifying their URL + name; optional ranking helps with ordering
Adding new categories, subcategories, or groups in the file will auto-create them
Default batches and menu listings are auto-generated unless disabled