SFTP Retail Headers

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.

A guide to sales status in Green Check

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