About the AIQ <> MJFreeway Pennsylvania Integration
Review our Integration Grid for supported features.
This article covers connection for AIQ Marketing + Loyalty.
How to Connect AIQ to MJFreeway Pennsylvania
Prepare your data
Prepare your data in a CSV file (Comma Separated Values) using the following headers.
Place the data in a folder in OneDrive. This folder should be at the top level; it should not be inside any other folders.
Header | Notes |
TransactionID | Required. Unique transaction ID |
Patient Number | Required. Unique patient ID |
LocationID | Unique location ID |
Item ID | |
Product Name | |
Product Category Name | |
VendorName | |
InventoryQuantity | |
Agg - Product Sales (subtotal) | |
AllocatedTax | |
Product Discount | |
TransactionDate | YYYY-MM-DD (ex. 2006-01-02) |
Completed Time | HH:MM:SS (ex. 15:04:05) |
Patient Postal Code | |
Patient Address | |
Patient Name | |
Patient email | |
Patient Phone Default | |
Patient Gender | |
Patient Age | YYYY-MM-DD (ex. 1990-01-02) |
Facility Name | Store name |
⚠️ Date format requirement — verify before uploading: The TransactionDate and Completed Time columns must remain in separate CSV columns. The required formats are YYYY-MM-DD for the date and HH:MM:SS for the time — with a single space between date and time if your export tool combines them in one field, not a T separator.
DOMO and Excel exports commonly corrupt this format by generating a combined timestamp like 2026-06-09T13:48:53 13:48:53 instead of the correct 2026-06-09 and 13:48:53 in their respective columns. Always open your exported CSV in a plain text editor (not Excel or DOMO preview) to verify the actual date format before uploading. Uploading a malformed file will produce a "parsing time" error.
AIQ Steps
Navigate to Settings > Integrations, search for MJFreeway - Pennsylvania and click on it to open the integration card.
Select "Connect Account via Oauth2" and follow the onscreen prompts.
Enter the OneDrive folder name in the field labeled "Folder"
Scroll down to the Loyalty section and check off the box next to Required All users from this source have passed an age gate compliant with my industry.
Lastly, click the purple Connect button in the top right.
How to Map a Store
Navigate to Settings -> Company Account > Retail Store
Click Edit on the store you wish to map
Under Store Mappings you'll see the MJ Freeway Pennsylvania symbol
Click on the empty field to the right of the symbol and a dropdown will appear to "map" the key
Click Save settings and you are done mapping the store. Keep in mind this must be repeated for any additional stores that you add to the account.
Additional AIQ Settings
The following additional settings are available on the MJFreeway Pennsylvania integration card in AIQ. To access them, navigate to Settings > Integrations, locate MJFreeway - Pennsylvania and click on it to open the integration card.
Use AIQ's last backup
Freezes data from this source at the last audience run and stops AIQ from hitting the MJFreeway Pennsylvania API for new data.
⚠️ Warning: Do not turn this on unless you are switching POS systems and want to retain existing data.
Send SMS double opt-ins to Personas who purchased after
Sends an SMS double opt-in request to shoppers with a phone number who had a sale on or after the date you specify. Takes 24 hours to trigger.
⚠️ Warning: If this setting is removed after it has been set, it can cause loyalty Personas to be lost if they only became a member through this setting and did not use a signup form. We do not recommend changing this after it is set.
Enroll Personas in loyalty program who purchased after
Automatically enrolls shoppers in the loyalty program if they had a sale on or after the date you specify. Enrolled shoppers earn points for sales on or after that date. Takes 24 hours to reflect.
FAQs
How long does it take before I start to see my POS data in AIQ?
Within 24 hours, you should see data populating in AIQ
How can I confirm that the integration is active and signups are being sent?
Look under your Personas page in AIQ. The integration is functioning properly if you see "mjfreeway" under the Sourced from column
I am getting an account notification that I have unmapped stores, how can I fix this?
Once you see data coming through AIQ, you must "map" the API key to the store(s) to assign a "favorite store" to the shopper. See How to Map a Store above for directions.
Need Help?
If you need assistance, reach out to AIQ Support anytime via chat widget within your AIQ Dashboard.