Before you start
Please review the standard Green Check fields below to ensure you send the necessary data in your CSV file.
Please note: A sale record missing any required fields will not successfully upload. Sales missing optional fields will upload successfully, but they may be marked as Unchecked.
| Field Name | Definition | Format |
| transaction_id | Unique identifier for a transaction | Required, alphanumeric |
| receipt_date | Date and time stamp of transaction | Required, ISO format, eg. 2021-02-27T12:30:00.000Z |
| customer_id_number | A unique ID number assigned to the customer record | Required, alphanumeric |
| customer_id_type | The type of ID provided | Optional, i.e. MMJ, Driver's License, Non-Driver State ID |
| customer_id_expiry_date | The expiration date provided on the customer's license | Optional, eg. 2021-02-27 |
| customer_dob | Date of birth of the customer | Optional, eg. 2021-02-27 |
| product_id | PoS ID number or SKU of the product sold | Optional, alphanumeric |
| product_name | Name of product sold | Optional, alphanumeric |
| product_grams | Grams of marijuana that an individual product sold contains | Optional, numeric, can be 0 |
| product_price_per_unit | Pre-tax price of one unit of a product sold | Optional, numeric |
| product_type | Type of product sold | Optional, eg., flower, edible, oil, accessory, etc |
| transaction_subtotal | Subtotal of all products sold within a transaction | Optional, numeric |
| transaction_tax | Subtotal plus tax on all products sold within a transaction | Optional, numeric |
| transaction_total | Subtotal plus tax on all products sold within a transaction | Required, numeric |
| transaction_cash_paid | Amount of cash paid during a transaction | Required, numeric, can be 0 |
| transaction_debit_paid | Amount put on a debit card during a transaction | Required, numeric, can be 0 |
| transaction_credit_paid | Amount put on a credit card during a transaction | Required, numeric, can be 0 |
| transaction_check_paid | Amount paid with a check during a transaction | Required, numeric, can be 0 |
| medical_or_adult_use | Whether a sale is medical or adult | Required, medical, adult |
| location_id | This is what we'll use to map your locations to our Org IDs | Required, alphanumeric |