11-05-2024, 03:23 AM
LoyLap.com
LoyLap is a software company that provides customizable closed loop payment systems including Gift Card, Loyalty, Online Ordering, Self Checkout N,\N,"1.00","0",\N
[code]"491","Denis Feigheryand Cashless systems. It is currently used by 3300 businesses.[/code]
In October 2024, LoyLap suffered a data breach which led to the exposure 233,658 rows of data, effecting their customers, transactions and users giftcard information.
Breached by @888
233662 rows
46204 customers
The Compromised Data Includes:
ID, First Name, Last Name, Email, Username, Status, Nickname, Photo, Phone Number, Date Birth, Date Add, Date Edit, Account Number, Gender, Card Brand, Expiry Date, Cash Balance, Stamp Balance and Role Name. Transaction Type, Loyalty Type, Business ID, Branch ID, Group ID, Employee ID, Customer ID, Refunded, Voided, Terminal ID, Smartpoints, Customer Amount, Unique Identifier, Account ID, Order ID, Reward Given, User ID, User First Name, User Last Name, Employee User ID, Employee First Name, Employee Last Name, Business Branch ID, Business Branch Name, Merchant ID, Merchant Name, Merchant Business Loyalty ID, Merchant Business Loyalty Reward Freebie, Custom Fields ID, Voucher Type and more.
Sample:
[code]
Customers.
"id","NAME","first_name","last_name","email","username","status","nickname","photo","phone_number","date_birth","date_add","date_edit","account_number","gender","card_brand","expiry_date","cash_balance","stamp_balance","role_name"
"0","guest 2 ","guest","2 ","[email protected]","3503520387","1","","https://www.gravatar.com/avatar/d8bf7f8a10b65df61faee44affaf5935?s=200&d=retro","thanks","1998-02-27","08/12/2023","08/12/2023","3503520387 90009802 90163599","male",\N,\N,"103.00","0",\N
"9","Patrick Garry","Patrick","Garry","[email protected]","11111111","1","Patrick Garry","https://www.gravatar.com/avatar/92927a0c6c8174b87abe4f1d637822a2?s=200&d=retro","123123123123","1990-01-01","18/10/2012","13/08/2023",\N,"male","visa","04/20","10000094.50","3","Joe's Friends"
"58","Conor OT","Conor","OT","[email protected]","21045781","1","","","","2006-01-01","30/11/2012","10/06/2024","9500143882 21045781","male","visa","12/25","25.32","44","Frequent users"
"62","Sinead Duggan","Sinead","Duggan","[email protected]","Cup Cakes Lingerie","1","Cup Cakes Lingerie","2012/12/f580b71bd1819ce34eeaa0376_83828.png",\N,"1980-00-00","03/12/2012","14/07/2023","46684833","male",\N,\N,"30.00","0",\N
"126","James Troy","James","Troy","[email protected]","67058997","2","James Troy","https://www.gravatar.com/avatar/7e8ea2033ff7e026506d9f95ee0c556c?s=200&d=retro",\N,"1959-06-11","06/12/2012","06/08/2019","67058997 92740077","female",\N,\N,"6.00","0","Managers"[/code]
[code]"195","Sue Rainsford","Sue","Rainsford","[email protected]","99267481","1","Sue R","https://scontent.xx.fbcdn.net/v/t1.0-1/p50x50/12795329_10153404943684327_1531953305455839934_n.jpg?oh=6728fdf0c41179cb74d990b9b40a2105&oe=57D62FDB",\N,"1988-03-17","12/12/2012","18/06/2019","99267481 45546 313","female",\","Denis","Feighery","[email protected]","","1","Dennis F","https://graph.facebook.com/1590728421/picture?type=large",\N,"1987-10-07","27/02/2013","03/10/2018","63101980","male",\N,\N,"5.64","0",\N
"1267","Daniel Wilson ","Daniel Wilson"," ","[email protected]","76163164","1","Customer 76163164","http://graph.facebook.com/1790785454/picture?type=large","0851018627","2022-02-03","30/10/2013","27/08/2024","80004893 76163164DW 94849260 83407922 83695594 69608990 90009682 D25674YH47 78874695","male","VISA","12/30","0.00","10","Joe's Friends"
"1531","Barry Bruen","Barry","Bruen","[email protected]","72581443","1","Barry B","https://s3-eu-west-1.amazonaws.com/loylap/users/2018/11/b20c2bbbc3ba413ca7ac86b76968e287_1541091611.png",\N,"1987-09-21","07/02/2014","12/02/2018","72581443","male",\N,\N,"9.26","0","Managers"
"1764","test account","test","account","[email protected]","75884612","1","Customer 75884612","https://www.gravatar.com/avatar/7da9e82fa1860a0de7f7764874937752?s=200&d=retro",\N,"1997-02-28","28/03/2014","07/08/2019","11111111","male",\N,\N,"111.10","23",\N
"1929","Jethrou Tull","Jethrou","Tull","[email protected]","80003529","2","Derek McCarthy","https://www.gravatar.com/avatar/708b1b9e8caa077d15589bcffa3091c2?s=200&d=retro",\N,"2000-07-23","25/04/2014","23/07/2020","80003529 455454545121 245454","female",\N,\N,"8.00","0",\N
"1939","Barry Bruen","Barry","Bruen","[email protected]","","1","Barry B","https://s3-eu-west-1.amazonaws.com/loylap/users/2018/07/a450951e56ffc76126b4b13631298d15_5b599fb28f67c.png","","1987-06-25","26/04/2014","27/01/2023","62785347 90009733 66127440 04AA7842F95C80 2282007160 4EDC7002F8FF12E0 4267E9CA C4904133 048EBC121257","female","visa","12/23","59.15","15",\N
Transactions.
"id","date add","date edit","transaction type","loyalty type","business id","branch id","group id","employee id","customer id","refunded","voided","terminal id","smartpoints","customer amount","unique identifier","account id","order id","reward given","user id","user first name","user last name","employee id","employee user id","employee id","employee first name","employee last name","business branch id","business branch name","merchant id","merchant name","merchant business loyalty id","merchant business loyalty reward freebie 1","merchant business loyalty reward freebie 2","merchant business loyalty reward freebie 3","merchant business loyalty reward freebie 4","custom fields id","custom fields"
"16733038","05/01/2024 - 12:05:40 - Europe/Dublin","05/01/2024 - 12:05:40 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"0.25","0.25","6597f0946efaf | Insertion time: 1704456340455 | Customer ID: 80004893 | Amount: 0.25","80004893",\N,"0.250","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","198","Booking Reference:HAY-1234566"
"16733039","05/01/2024 - 12:05:57 - Europe/Dublin","05/01/2024 - 12:05:57 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"0.25","0.25","o0yk8bt584pvkznt | Transaction type: Redeem Gift | Amount: 25 | Insertion time: 1704456356295 | Order ID: 20Y1Y2SM90CH8 | Order Total: 0 | Order Access time: 0 | Customer balance: 25 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@lo","80004893","20Y1Y2SM90CH8","-0.250","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733040","05/01/2024 - 12:06:17 - Europe/Dublin","05/01/2024 - 12:06:17 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"0.55","0.55","6597f0b9a910c | Insertion time: 1704456377693 | Customer ID: 80004893 | Amount: 0.55","80004893",\N,"0.550","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","199","Booking Reference:HAY-1111111"
"16733041","05/01/2024 - 12:06:43 - Europe/Dublin","05/01/2024 - 12:06:43 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"0.55","0.55","rznyixjwr2a13oex | Transaction type: Redeem Gift | Amount: 55 | Insertion time: 1704456402103 | Order ID: 20Y1Y2SM90CH8 | Order Total: 0 | Order Access time: 0 | Customer balance: 55 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@lo","80004893","20Y1Y2SM90CH8","-0.550","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733042","05/01/2024 - 12:07:45 - Europe/Dublin","05/01/2024 - 12:07:45 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"0.65","0.65","6597f111adddc | Insertion time: 1704456465712 | Customer ID: 80004893 | Amount: 0.65","80004893",\N,"0.650","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","200","Booking Reference:HAY-5595956"
"16733043","05/01/2024 - 12:07:53 - Europe/Dublin","05/01/2024 - 12:07:53 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"0.65","0.65","1e3ym7nsy079viw5 | Transaction type: Redeem Gift | Amount: 65 | Insertion time: 1704456471939 | Order ID: 20Y1Y2SM90CH8 | Order Total: 0 | Order Access time: 0 | Customer balance: 65 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@lo","80004893","20Y1Y2SM90CH8","-0.650","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733044","05/01/2024 - 12:15:49 - Europe/Dublin","05/01/2024 - 12:15:49 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"6.00","6.00","6597f2f59d20b | Insertion time: 1704456949644 | Customer ID: 80004893 | Amount: 6.0","80004893",\N,"6.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","201","Booking Reference:HAY-4656465"
"16733045","05/01/2024 - 12:16:12 - Europe/Dublin","05/01/2024 - 12:16:12 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"6.00","6.00","a8e0rgc9eiws8dno | Transaction type: Redeem Gift | Amount: 600 | Insertion time: 1704456971335 | Order ID: KX1E32TQ86APM | Order Total: 0 | Order Access time: 0 | Customer balance: 600 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@","80004893","KX1E32TQ86APM","-6.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733046","05/01/2024 - 12:29:28 - Europe/Dublin","05/01/2024 - 12:29:28 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"5.00","5.00","6597f628a0e6a | Insertion time: 1704457768659 | Customer ID: 80004893 | Amount: 5.0","80004893",\N,"5.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","202","Booking Reference:HAY-1234567"
"16733047","05/01/2024 - 12:29:38 - Europe/Dublin","05/01/2024 - 12:29:38 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"5.00","5.00","735x3aikmwa5komw | Transaction type: Redeem Gift | Amount: 500 | Insertion time: 1704457777374 | Order ID: RKS6VG9052EYA | Order Total: 0 | Order Access time: 0 | Customer balance: 500 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@","80004893","RKS6VG9052EYA","-5.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733048","05/01/2024 - 12:34:15 - Europe/Dublin","05/01/2024 - 12:34:15 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"4.00","4.00","6597f747944b5 | Insertion time: 1704458055607 | Customer ID: 80004893 | Amount: 4.0","80004893",\N,"4.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","203","Booking Reference:HAY-9595949"
"16733049","05/01/2024 - 12:34:22 - Europe/Dublin","05/01/2024 - 12:34:22 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"4.00","4.00","cxthmgailjba0d7b | Transaction type: Redeem Gift | Amount: 400 | Insertion time: 1704458061492 | Order ID: YVYNP0KWYFEXG | Order Total: 0 | Order Access time: 0 | Customer balance: 400 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@","80004893","YVYNP0KWYFEXG","-4.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733050","05/01/2024 - 12:35:43 - Europe/Dublin","05/01/2024 - 12:35:43 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"3.00","3.00","6597f79f1e9b0 | Insertion time: 1704458143125 | Customer ID: 80004893 | Amount: 3.0","80004893",\N,"3.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","204","Booking Reference:HAY-5959494"
"16733051","05/01/2024 - 12:35:50 - Europe/Dublin","05/01/2024 - 12:35:50 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"3.00","3.00","uuxq4fxvdjps051m | Transaction type: Redeem Gift | Amount: 300 | Insertion time: 1704458149395 | Order ID: 0Y5X5YGBSPQPY | Order Total: 0 | Order Access time: 0 | Customer balance: 300 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@","80004893","0Y5X5YGBSPQPY","-3.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733054","08/01/2024 - 22:03:29 - Europe/Dublin","08/01/2024 - 22:03:29 - Europe/Dublin","add","upfront","0","270","108","265","23700608","0",\N,\N,"1248.00","1200.00","Stripe Order ID: cs_test_a1X8UUaG91gNpPB4dtb3WcnM968j9lvdg6oWAjzWwNR77d56nasaiXCqu9 | Transaction type: Add Experience Voucher | Amount: 120000 | Time: 1704751409211 | Customer ID: 9760870045 | Note: Generated by retail order","9760870045",\N,"9.999","23700608","9760870045","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733055","08/01/2024 - 22:15:45 - Europe/Dublin","08/01/2024 - 22:15:45 - Europe/Dublin","add","upfront","0","270","108","265","23700610","0",\N,\N,"1248.00","1200.00","Stripe Order ID: cs_test_a1JkU3QuZGPJkypGSv0V57ss57Po9F0ItOXzrbvEwCAqrcYd9e9uVeGcOS | Transaction type: Add Experience Voucher | Amount: 120000 | Time: 1704752145762 | Customer ID: 9963172912 | Note: Generated by retail order","9963172912",\N,"9.999","23700610","9963172912","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733056","08/01/2024 - 22:18:36 - Europe/Dublin","08/01/2024 - 22:18:36 - Europe/Dublin","add","upfront","0","270","108","265","23700612","0",\N,\N,"1248.00","1200.00","Stripe Order ID: cs_test_a1aORD56DemtcvOH6qLZ40N8GGFNgLWC05fSpoFLE73KyMd2MAwXk1IT5R | Transaction type: Add Experience Voucher | Amount: 120000 | Time: 1704752316731 | Customer ID: 145635167 | Note: Generated by retail order","145635167",\N,"9.999","23700612","145635167","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733062","09/01/2024 - 15:19:19 - Europe/Dublin","09/01/2024 - 15:19:19 - Europe/Dublin","add","gift","0","270","108","265","23700614","0",\N,\N,"1.00","1.00","659d63f7dc9ad | Insertion time: 1704813559904 | Customer ID: 90009809 | Amount: 1.0","90009809",\N,"1.000","23700614","Customer","90009809","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","205","Booking Reference:HAY-1234567"
Giftcards.
"account_number","voucher_type","credited_balance","credited_at","credited_branch","debited_balance","debited_at","debited_branch","expiry_date","balance"
"45281640","physical","0.10","1417616960","Retail Excellence","30.00","1421844746","Retail Excellence",\N,"95.00"
"11111111","physical","0.25","1420723722","Retail Excellence","54.90","1691949232","Retail Excellence","2021-03-27","10000094.50"
"21045781","physical","2.00","1422618132","Retail Excellence","1.00","1717153121","Branch Name","2021-12-31","25.32"
"14723706","physical","2.00","1422891426","Retail Excellence",\N,\N,\N,\N,"31.50"
"3503520387","physical","0.60","1429366693","Retail Excellence",\N,\N,\N,\N,"103.00"
"69608990","physical","1.00","1439916182","Retail Excellence",\N,\N,\N,\N,"1.00"
"80260227","physical","1.00","1440625305","Retail Excellence",\N,\N,\N,\N,"1.00"
"32080453","physical","0.10","1441371852","Retail Excellence",\N,\N,\N,\N,"0.90"
"21045783","physical","2.00","1446398009","Retail Excellence",\N,\N,\N,\N,"2.00"
"73830384","physical","1.00","1446399110","Retail Excellence",\N,\N,\N,\N,"2.00"
"96417103","physical","20.00","1446821162","Retail Excellence",\N,\N,\N,\N,"20.00"
"38941869","physical","20.00","1446823039","Retail Excellence",\N,\N,\N,\N,"20.00"
"89777711","physical","20.00","1447869040","Retail Excellence","20.00","1447869141","Retail Excellence",\N,"0.00"
\N,"physical","20.00","1447870338","Retail Excellence","8.00","1447870681","Retail Excellence",\N,"0.00"
\N,"physical","50.00","1447870852","Retail Excellence","15.00","1447870922","Retail Excellence",\N,"35.00"
\N,"physical","50.00","1447945944","Retail Excellence","15.00","1447945977","Retail Excellence",\N,"35.00"
"34205319","physical","1.00","1448375922","Retail Excellence",\N,\N,\N,\N,"1.00"
"75690954","physical","5.00","1448555590","Retail Excellence","10.00","1591706990",\N,\N,"0.60"
"82431965","physical","1.00","1448559486","Retail Excellence",\N,\N,\N,\N,"21.60"
\N,"physical","20.00","1448559806","Retail Excellence","10.00","1448559921","Retail Excellence",\N,"0.00"
"90009338","physical","10.00","1452268242","Retail Excellence",\N,\N,\N,\N,"10.00"
"90009567","physical","20.00","1452282231","Retail Excellence",\N,\N,\N,\N,"0.00"
"90009568","physical","1.50","1452798103","Retail Excellence",\N,\N,\N,\N,"20.00"
\N,"physical","10.00","1453232479","Retail Excellence",\N,\N,\N,\N,"10.00"
\N,"physical","20.00","1453232592","Retail Excellence","12.00","1453232718","Retail Excellence",\N,"18.00"
\N,"physical","10.00","1453295089","Retail Excellence","10.00","1453295260","Retail Excellence",\N,"0.00"
"35125901","physical","0.20","1454090500","Retail Excellence",\N,\N,\N,\N,"0.40"
"48897875","physical","0.20","1454090657","Retail Excellence",\N,\N,\N,\N,"0.20"
"90009645","physical","20.00","1454092236","Retail Excellence","5.00","1469020955","Retail Excellence",\N,"-35.00"
"90009646","physical","50.00","1454356496","Retail Excellence","9.60","1454356591","Retail Excellence",\N,"30.80"
[/code]
LoyLap is a software company that provides customizable closed loop payment systems including Gift Card, Loyalty, Online Ordering, Self Checkout N,\N,"1.00","0",\N
[code]"491","Denis Feigheryand Cashless systems. It is currently used by 3300 businesses.[/code]
In October 2024, LoyLap suffered a data breach which led to the exposure 233,658 rows of data, effecting their customers, transactions and users giftcard information.
Breached by @888
233662 rows
46204 customers
The Compromised Data Includes:
ID, First Name, Last Name, Email, Username, Status, Nickname, Photo, Phone Number, Date Birth, Date Add, Date Edit, Account Number, Gender, Card Brand, Expiry Date, Cash Balance, Stamp Balance and Role Name. Transaction Type, Loyalty Type, Business ID, Branch ID, Group ID, Employee ID, Customer ID, Refunded, Voided, Terminal ID, Smartpoints, Customer Amount, Unique Identifier, Account ID, Order ID, Reward Given, User ID, User First Name, User Last Name, Employee User ID, Employee First Name, Employee Last Name, Business Branch ID, Business Branch Name, Merchant ID, Merchant Name, Merchant Business Loyalty ID, Merchant Business Loyalty Reward Freebie, Custom Fields ID, Voucher Type and more.
Sample:
[code]
Customers.
"id","NAME","first_name","last_name","email","username","status","nickname","photo","phone_number","date_birth","date_add","date_edit","account_number","gender","card_brand","expiry_date","cash_balance","stamp_balance","role_name"
"0","guest 2 ","guest","2 ","[email protected]","3503520387","1","","https://www.gravatar.com/avatar/d8bf7f8a10b65df61faee44affaf5935?s=200&d=retro","thanks","1998-02-27","08/12/2023","08/12/2023","3503520387 90009802 90163599","male",\N,\N,"103.00","0",\N
"9","Patrick Garry","Patrick","Garry","[email protected]","11111111","1","Patrick Garry","https://www.gravatar.com/avatar/92927a0c6c8174b87abe4f1d637822a2?s=200&d=retro","123123123123","1990-01-01","18/10/2012","13/08/2023",\N,"male","visa","04/20","10000094.50","3","Joe's Friends"
"58","Conor OT","Conor","OT","[email protected]","21045781","1","","","","2006-01-01","30/11/2012","10/06/2024","9500143882 21045781","male","visa","12/25","25.32","44","Frequent users"
"62","Sinead Duggan","Sinead","Duggan","[email protected]","Cup Cakes Lingerie","1","Cup Cakes Lingerie","2012/12/f580b71bd1819ce34eeaa0376_83828.png",\N,"1980-00-00","03/12/2012","14/07/2023","46684833","male",\N,\N,"30.00","0",\N
"126","James Troy","James","Troy","[email protected]","67058997","2","James Troy","https://www.gravatar.com/avatar/7e8ea2033ff7e026506d9f95ee0c556c?s=200&d=retro",\N,"1959-06-11","06/12/2012","06/08/2019","67058997 92740077","female",\N,\N,"6.00","0","Managers"[/code]
[code]"195","Sue Rainsford","Sue","Rainsford","[email protected]","99267481","1","Sue R","https://scontent.xx.fbcdn.net/v/t1.0-1/p50x50/12795329_10153404943684327_1531953305455839934_n.jpg?oh=6728fdf0c41179cb74d990b9b40a2105&oe=57D62FDB",\N,"1988-03-17","12/12/2012","18/06/2019","99267481 45546 313","female",\","Denis","Feighery","[email protected]","","1","Dennis F","https://graph.facebook.com/1590728421/picture?type=large",\N,"1987-10-07","27/02/2013","03/10/2018","63101980","male",\N,\N,"5.64","0",\N
"1267","Daniel Wilson ","Daniel Wilson"," ","[email protected]","76163164","1","Customer 76163164","http://graph.facebook.com/1790785454/picture?type=large","0851018627","2022-02-03","30/10/2013","27/08/2024","80004893 76163164DW 94849260 83407922 83695594 69608990 90009682 D25674YH47 78874695","male","VISA","12/30","0.00","10","Joe's Friends"
"1531","Barry Bruen","Barry","Bruen","[email protected]","72581443","1","Barry B","https://s3-eu-west-1.amazonaws.com/loylap/users/2018/11/b20c2bbbc3ba413ca7ac86b76968e287_1541091611.png",\N,"1987-09-21","07/02/2014","12/02/2018","72581443","male",\N,\N,"9.26","0","Managers"
"1764","test account","test","account","[email protected]","75884612","1","Customer 75884612","https://www.gravatar.com/avatar/7da9e82fa1860a0de7f7764874937752?s=200&d=retro",\N,"1997-02-28","28/03/2014","07/08/2019","11111111","male",\N,\N,"111.10","23",\N
"1929","Jethrou Tull","Jethrou","Tull","[email protected]","80003529","2","Derek McCarthy","https://www.gravatar.com/avatar/708b1b9e8caa077d15589bcffa3091c2?s=200&d=retro",\N,"2000-07-23","25/04/2014","23/07/2020","80003529 455454545121 245454","female",\N,\N,"8.00","0",\N
"1939","Barry Bruen","Barry","Bruen","[email protected]","","1","Barry B","https://s3-eu-west-1.amazonaws.com/loylap/users/2018/07/a450951e56ffc76126b4b13631298d15_5b599fb28f67c.png","","1987-06-25","26/04/2014","27/01/2023","62785347 90009733 66127440 04AA7842F95C80 2282007160 4EDC7002F8FF12E0 4267E9CA C4904133 048EBC121257","female","visa","12/23","59.15","15",\N
Transactions.
"id","date add","date edit","transaction type","loyalty type","business id","branch id","group id","employee id","customer id","refunded","voided","terminal id","smartpoints","customer amount","unique identifier","account id","order id","reward given","user id","user first name","user last name","employee id","employee user id","employee id","employee first name","employee last name","business branch id","business branch name","merchant id","merchant name","merchant business loyalty id","merchant business loyalty reward freebie 1","merchant business loyalty reward freebie 2","merchant business loyalty reward freebie 3","merchant business loyalty reward freebie 4","custom fields id","custom fields"
"16733038","05/01/2024 - 12:05:40 - Europe/Dublin","05/01/2024 - 12:05:40 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"0.25","0.25","6597f0946efaf | Insertion time: 1704456340455 | Customer ID: 80004893 | Amount: 0.25","80004893",\N,"0.250","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","198","Booking Reference:HAY-1234566"
"16733039","05/01/2024 - 12:05:57 - Europe/Dublin","05/01/2024 - 12:05:57 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"0.25","0.25","o0yk8bt584pvkznt | Transaction type: Redeem Gift | Amount: 25 | Insertion time: 1704456356295 | Order ID: 20Y1Y2SM90CH8 | Order Total: 0 | Order Access time: 0 | Customer balance: 25 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@lo","80004893","20Y1Y2SM90CH8","-0.250","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733040","05/01/2024 - 12:06:17 - Europe/Dublin","05/01/2024 - 12:06:17 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"0.55","0.55","6597f0b9a910c | Insertion time: 1704456377693 | Customer ID: 80004893 | Amount: 0.55","80004893",\N,"0.550","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","199","Booking Reference:HAY-1111111"
"16733041","05/01/2024 - 12:06:43 - Europe/Dublin","05/01/2024 - 12:06:43 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"0.55","0.55","rznyixjwr2a13oex | Transaction type: Redeem Gift | Amount: 55 | Insertion time: 1704456402103 | Order ID: 20Y1Y2SM90CH8 | Order Total: 0 | Order Access time: 0 | Customer balance: 55 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@lo","80004893","20Y1Y2SM90CH8","-0.550","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733042","05/01/2024 - 12:07:45 - Europe/Dublin","05/01/2024 - 12:07:45 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"0.65","0.65","6597f111adddc | Insertion time: 1704456465712 | Customer ID: 80004893 | Amount: 0.65","80004893",\N,"0.650","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","200","Booking Reference:HAY-5595956"
"16733043","05/01/2024 - 12:07:53 - Europe/Dublin","05/01/2024 - 12:07:53 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"0.65","0.65","1e3ym7nsy079viw5 | Transaction type: Redeem Gift | Amount: 65 | Insertion time: 1704456471939 | Order ID: 20Y1Y2SM90CH8 | Order Total: 0 | Order Access time: 0 | Customer balance: 65 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@lo","80004893","20Y1Y2SM90CH8","-0.650","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733044","05/01/2024 - 12:15:49 - Europe/Dublin","05/01/2024 - 12:15:49 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"6.00","6.00","6597f2f59d20b | Insertion time: 1704456949644 | Customer ID: 80004893 | Amount: 6.0","80004893",\N,"6.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","201","Booking Reference:HAY-4656465"
"16733045","05/01/2024 - 12:16:12 - Europe/Dublin","05/01/2024 - 12:16:12 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"6.00","6.00","a8e0rgc9eiws8dno | Transaction type: Redeem Gift | Amount: 600 | Insertion time: 1704456971335 | Order ID: KX1E32TQ86APM | Order Total: 0 | Order Access time: 0 | Customer balance: 600 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@","80004893","KX1E32TQ86APM","-6.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733046","05/01/2024 - 12:29:28 - Europe/Dublin","05/01/2024 - 12:29:28 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"5.00","5.00","6597f628a0e6a | Insertion time: 1704457768659 | Customer ID: 80004893 | Amount: 5.0","80004893",\N,"5.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","202","Booking Reference:HAY-1234567"
"16733047","05/01/2024 - 12:29:38 - Europe/Dublin","05/01/2024 - 12:29:38 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"5.00","5.00","735x3aikmwa5komw | Transaction type: Redeem Gift | Amount: 500 | Insertion time: 1704457777374 | Order ID: RKS6VG9052EYA | Order Total: 0 | Order Access time: 0 | Customer balance: 500 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@","80004893","RKS6VG9052EYA","-5.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733048","05/01/2024 - 12:34:15 - Europe/Dublin","05/01/2024 - 12:34:15 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"4.00","4.00","6597f747944b5 | Insertion time: 1704458055607 | Customer ID: 80004893 | Amount: 4.0","80004893",\N,"4.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","203","Booking Reference:HAY-9595949"
"16733049","05/01/2024 - 12:34:22 - Europe/Dublin","05/01/2024 - 12:34:22 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"4.00","4.00","cxthmgailjba0d7b | Transaction type: Redeem Gift | Amount: 400 | Insertion time: 1704458061492 | Order ID: YVYNP0KWYFEXG | Order Total: 0 | Order Access time: 0 | Customer balance: 400 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@","80004893","YVYNP0KWYFEXG","-4.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733050","05/01/2024 - 12:35:43 - Europe/Dublin","05/01/2024 - 12:35:43 - Europe/Dublin","add","gift","0","270","108","265","23700226","0",\N,\N,"3.00","3.00","6597f79f1e9b0 | Insertion time: 1704458143125 | Customer ID: 80004893 | Amount: 3.0","80004893",\N,"3.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","204","Booking Reference:HAY-5959494"
"16733051","05/01/2024 - 12:35:50 - Europe/Dublin","05/01/2024 - 12:35:50 - Europe/Dublin","remove","gift","0","2557","108","265","23700226","0",\N,\N,"3.00","3.00","uuxq4fxvdjps051m | Transaction type: Redeem Gift | Amount: 300 | Insertion time: 1704458149395 | Order ID: 0Y5X5YGBSPQPY | Order Total: 0 | Order Access time: 0 | Customer balance: 300 | Customer ID: 80004893 | Employee: Lite - No employee | Email: conor@","80004893","0Y5X5YGBSPQPY","-3.000","23700226","Hjjuj","","265","Patrick Garry","2467","Owner","Person","2557","Oak Fire GEC","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733054","08/01/2024 - 22:03:29 - Europe/Dublin","08/01/2024 - 22:03:29 - Europe/Dublin","add","upfront","0","270","108","265","23700608","0",\N,\N,"1248.00","1200.00","Stripe Order ID: cs_test_a1X8UUaG91gNpPB4dtb3WcnM968j9lvdg6oWAjzWwNR77d56nasaiXCqu9 | Transaction type: Add Experience Voucher | Amount: 120000 | Time: 1704751409211 | Customer ID: 9760870045 | Note: Generated by retail order","9760870045",\N,"9.999","23700608","9760870045","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733055","08/01/2024 - 22:15:45 - Europe/Dublin","08/01/2024 - 22:15:45 - Europe/Dublin","add","upfront","0","270","108","265","23700610","0",\N,\N,"1248.00","1200.00","Stripe Order ID: cs_test_a1JkU3QuZGPJkypGSv0V57ss57Po9F0ItOXzrbvEwCAqrcYd9e9uVeGcOS | Transaction type: Add Experience Voucher | Amount: 120000 | Time: 1704752145762 | Customer ID: 9963172912 | Note: Generated by retail order","9963172912",\N,"9.999","23700610","9963172912","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733056","08/01/2024 - 22:18:36 - Europe/Dublin","08/01/2024 - 22:18:36 - Europe/Dublin","add","upfront","0","270","108","265","23700612","0",\N,\N,"1248.00","1200.00","Stripe Order ID: cs_test_a1aORD56DemtcvOH6qLZ40N8GGFNgLWC05fSpoFLE73KyMd2MAwXk1IT5R | Transaction type: Add Experience Voucher | Amount: 120000 | Time: 1704752316731 | Customer ID: 145635167 | Note: Generated by retail order","145635167",\N,"9.999","23700612","145635167","","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","",\N,\N
"16733062","09/01/2024 - 15:19:19 - Europe/Dublin","09/01/2024 - 15:19:19 - Europe/Dublin","add","gift","0","270","108","265","23700614","0",\N,\N,"1.00","1.00","659d63f7dc9ad | Insertion time: 1704813559904 | Customer ID: 90009809 | Amount: 1.0","90009809",\N,"1.000","23700614","Customer","90009809","265","Patrick Garry","2467","Owner","Person","270","Retail Excellence","108","Paddy's Pizza","179","free reward","","","","205","Booking Reference:HAY-1234567"
Giftcards.
"account_number","voucher_type","credited_balance","credited_at","credited_branch","debited_balance","debited_at","debited_branch","expiry_date","balance"
"45281640","physical","0.10","1417616960","Retail Excellence","30.00","1421844746","Retail Excellence",\N,"95.00"
"11111111","physical","0.25","1420723722","Retail Excellence","54.90","1691949232","Retail Excellence","2021-03-27","10000094.50"
"21045781","physical","2.00","1422618132","Retail Excellence","1.00","1717153121","Branch Name","2021-12-31","25.32"
"14723706","physical","2.00","1422891426","Retail Excellence",\N,\N,\N,\N,"31.50"
"3503520387","physical","0.60","1429366693","Retail Excellence",\N,\N,\N,\N,"103.00"
"69608990","physical","1.00","1439916182","Retail Excellence",\N,\N,\N,\N,"1.00"
"80260227","physical","1.00","1440625305","Retail Excellence",\N,\N,\N,\N,"1.00"
"32080453","physical","0.10","1441371852","Retail Excellence",\N,\N,\N,\N,"0.90"
"21045783","physical","2.00","1446398009","Retail Excellence",\N,\N,\N,\N,"2.00"
"73830384","physical","1.00","1446399110","Retail Excellence",\N,\N,\N,\N,"2.00"
"96417103","physical","20.00","1446821162","Retail Excellence",\N,\N,\N,\N,"20.00"
"38941869","physical","20.00","1446823039","Retail Excellence",\N,\N,\N,\N,"20.00"
"89777711","physical","20.00","1447869040","Retail Excellence","20.00","1447869141","Retail Excellence",\N,"0.00"
\N,"physical","20.00","1447870338","Retail Excellence","8.00","1447870681","Retail Excellence",\N,"0.00"
\N,"physical","50.00","1447870852","Retail Excellence","15.00","1447870922","Retail Excellence",\N,"35.00"
\N,"physical","50.00","1447945944","Retail Excellence","15.00","1447945977","Retail Excellence",\N,"35.00"
"34205319","physical","1.00","1448375922","Retail Excellence",\N,\N,\N,\N,"1.00"
"75690954","physical","5.00","1448555590","Retail Excellence","10.00","1591706990",\N,\N,"0.60"
"82431965","physical","1.00","1448559486","Retail Excellence",\N,\N,\N,\N,"21.60"
\N,"physical","20.00","1448559806","Retail Excellence","10.00","1448559921","Retail Excellence",\N,"0.00"
"90009338","physical","10.00","1452268242","Retail Excellence",\N,\N,\N,\N,"10.00"
"90009567","physical","20.00","1452282231","Retail Excellence",\N,\N,\N,\N,"0.00"
"90009568","physical","1.50","1452798103","Retail Excellence",\N,\N,\N,\N,"20.00"
\N,"physical","10.00","1453232479","Retail Excellence",\N,\N,\N,\N,"10.00"
\N,"physical","20.00","1453232592","Retail Excellence","12.00","1453232718","Retail Excellence",\N,"18.00"
\N,"physical","10.00","1453295089","Retail Excellence","10.00","1453295260","Retail Excellence",\N,"0.00"
"35125901","physical","0.20","1454090500","Retail Excellence",\N,\N,\N,\N,"0.40"
"48897875","physical","0.20","1454090657","Retail Excellence",\N,\N,\N,\N,"0.20"
"90009645","physical","20.00","1454092236","Retail Excellence","5.00","1469020955","Retail Excellence",\N,"-35.00"
"90009646","physical","50.00","1454356496","Retail Excellence","9.60","1454356591","Retail Excellence",\N,"30.80"
[/code]
This field is hidden, you must comment below to open it.
Note: If the comment field is not visible, your topic may be in the VIP or Business area.
Upgrade your account now!
