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	Total amount of taxes applied across all products on the 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 your unique identifier per location. We will map your ID to our CRB ID.	Required, alphanumeric