The marketing and loyalty system for small businesses.
Loyal2 and SQL Database Integration Guide

If you run a SQL database (for your ePOS, CRM or business system), you may be looking for an integrated loyalty solution to launch a loyalty program of your own. Loyal2 provides a complete loyalty solution for card-based, stamp-and-collect, semi-virtual and fully online loyalty programs - and best of all, our SQL integration tool will allow you to link the two together automatically.

To set up your SQL integration go to Dashboard > Integrated Products > SQL Integration


Connect your SQL database to Loyal2 by entering the server address details and the user/password for a read-only user on your database. Our connection checker will verify if the database is connected.

Next you must insert your SQL query which will product the merged array of customer and transaction data which we need to process your customer sales/activities into Loyal2:

An example of a SQL query would look like this:



Once you have your query tested and producing the correct results you can manually import your data using the data-range and button provided. Alternatively, the script will automatically run each day and load the transactions from the day before.

Finally there are a few settings at the bottom of the page which allow you to pause the daily automatic import and receive email notifications for each transaction that is imported.


 

Online Loyalty for Websites
ePOS and eStore Integrations
Voucher Management
Promotions and Campaigns
Product Reg. and Surveys
Measure Performance
Reward visitors online and in-store to bring them back again and again
QuickScan for mobiles and tablets - makes scanning member cards easy
Easily integrate or import your data from ePOS or other systems