Skip to main content

CSV Import Requirements & Recommendations

INTEGRATION REFERENCE

Written by Natalie Norell

Leaf Trade's CSV upload function closely resembles our other API integrations, giving you more flexibility when displaying inventory. All you need is an export of your “Ready for Sale” inventory from your S2S platform containing the required columns detailed below. Once uploaded, our integration process guides you through the setup in just a few steps. This import will build products, batches, and active inventory.

FORMATTING RULES

The CSV uploader does not accept $, %, or special characters within the lab or price fields. It also does not accept blank fields in any column that is being mapped.

Required Columns

Five fields are required to create products and inventory in Leaf Trade:

  • Product Name

  • Batch Numberalso called Harvest or Lot, correlates with test results

  • Pull Numberalso called Package ID, Tag Number, or Unique Variant ID. Must be unique to the package and should not repeat

  • Available Quantity on Handcounted in units, not cases

  • Package Size & Unit of Measuree.g. 1.0g, 3.5g, 500mg, 60mL

Recommended Columns

These additional fields aren't required, but they enrich each piece of inventory with more detail and unlock better filtering, reporting, and buyer experience downstream.

Product Details

  • Product ID

  • Registration Number

  • Case Size

  • Category

  • Price (Per Unit)

  • Strain

  • Batch Expiration Date

  • Harvest Date

  • Manufacture DateI

  • Lab Results Date

  • Cannabinoid Unit (%, MG)

Cannabinoid Data

  • THC Amount

  • THCA Amount

  • THC Delta 8 Amount

  • THCV Amount

  • CBD Amount

  • CBDA Amount

  • CBDV Amount

  • CBC Amount

  • CBG Amount

  • CBN Amount

  • TAC Amount

  • Total THC

  • Total Cannabinoids

  • Total Terpenes

Example

A properly formatted CSV row may look like this:

Product Name

Batch #

Unique Variant ID

Quantity

Package Size & Unit

THC

THCa

CBD

CBDa

Price

Lab Date

Sativa Pre-Roll 1g

1234

54321

620

1g

0

25.4

0

0.34

8

1/13/2024

Indica Gummies 50mg

1342

12345

400

50mg

84.3

0

0.33

0

12.50

12/1/2023

Did this answer your question?