[2026-04-19 13:00:45] LoyaltyLion launch: customer=test123, email=test@logan1330.com, points=1000, tier=gold
[2026-04-19 13:00:45] Created new member: test123
[2026-04-19 13:00:45] Redirecting to StockLoyal: https://app.stockloyal.com/?merchant_id=logan1330&member_id=test123&source=loyaltylion&points=1000&tier=gold
[2026-04-19 13:02:10] LoyaltyLion launch: customer=test123, email=test@logan1330.com, points=1000, tier=gold
[2026-04-19 13:02:10] Updated existing member: test123
[2026-04-19 13:02:10] Redirecting to StockLoyal: https://app.stockloyal.com/?merchant_id=logan1330&member_id=test123&source=loyaltylion&points=1000&tier=gold
[2026-04-19 14:15:19] LoyaltyLion launch: customer=cust123, email=jefflogan1330@gmail.com, points=1000, tier=gold
[2026-04-19 14:15:19] Updated existing member: rex1330
[2026-04-19 14:15:19] Redirecting to StockLoyal: https://app.stockloyal.com/?merchant_id=logan1330&member_id=cust123&source=loyaltylion&points=1000&tier=gold
[2026-04-19 14:22:00] LoyaltyLion launch: customer=cust123, email=jefflogan1330@gmail.com, points=1000, tier=gold
[2026-04-19 14:22:00] Updated existing member: rex1330
[2026-04-19 14:22:00] Redirecting to StockLoyal: https://app.stockloyal.com/?merchant_id=logan1330&member_id=cust123&source=loyaltylion&points=1000&tier=gold
[2026-04-19 18:32:41] [INFO] Received webhook payload: {"customer":{"email":"test@example.com"},"reward":{"points_cost":100}}
[2026-04-19 18:32:41] [INFO] Processing redemption: test@example.com (tier: bronze) -> Stock Investment Reward (100 points, $1)
[2026-04-19 18:32:41] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tier' in 'field list'
[2026-04-19 18:32:41] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tier' in 'field list'
[2026-04-19 18:35:22] [INFO] Received webhook payload: {"customer":{"email":"test@example.com"},"reward":{"points_cost":100}}
[2026-04-19 18:35:22] [INFO] Processing redemption: test@example.com (tier: bronze) -> Stock Investment Reward (100 points, $1)
[2026-04-19 18:35:22] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tier' in 'field list'
[2026-04-19 18:35:22] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tier' in 'field list'
[2026-04-19 18:40:59] [INFO] Received webhook payload: {"customer":{"email":"test@example.com"},"reward":{"points_cost":100}}
[2026-04-19 18:40:59] [INFO] Processing redemption: test@example.com (tier: bronze) -> Stock Investment Reward (100 points, $1)
[2026-04-19 18:40:59] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tier' in 'field list'
[2026-04-19 18:40:59] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tier' in 'field list'
[2026-04-19 18:42:40] [INFO] Received webhook payload: {"customer":{"email":"test@example.com"},"reward":{"points_cost":100}}
[2026-04-19 18:42:40] [INFO] Processing redemption: test@example.com (tier: bronze) -> Stock Investment Reward (100 points, $1)
[2026-04-19 18:42:40] [INFO] Created new member ll_test: $1 initial credit (points: 100, tier: bronze)
[2026-04-19 18:42:40] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transaction_type' in 'field list'
[2026-04-19 18:42:40] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transaction_type' in 'field list'
[2026-04-19 18:47:40] [INFO] Received webhook payload: {"customer":{"email":"test@example.com"},"reward":{"points_cost":100}}
[2026-04-19 18:47:40] [INFO] Processing redemption: test@example.com (tier: bronze) -> Stock Investment Reward (100 points, $1)
[2026-04-19 18:47:40] [INFO] Created new member ll_test: $1 initial credit (points: 100, tier: bronze)
[2026-04-19 18:47:40] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'event_data' in 'field list'
[2026-04-19 18:47:40] [ERROR] Redemption processing failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'event_data' in 'field list'
[2026-04-19 18:52:08] [INFO] Received webhook payload: {"customer":{"email":"test@example.com"},"reward":{"points_cost":100}}
[2026-04-19 18:52:08] [INFO] Processing redemption: test@example.com (tier: bronze) -> Stock Investment Reward (100 points, $1)
[2026-04-19 18:52:08] [INFO] Created new member ll_test: $1 initial credit (points: 100, tier: bronze)
[2026-04-19 18:52:08] [SUCCESS] Successfully processed redemption for test@example.com: $1
[2026-04-19 18:53:57] [INFO] Received webhook payload: {"customer":{"email":"test@example.com"},"reward":{"points_cost":100}}
[2026-04-19 18:53:57] [INFO] Processing redemption: test@example.com (tier: bronze) -> Stock Investment Reward (100 points, $1)
[2026-04-19 18:53:57] [INFO] Updated existing member ll_test: added $1 (points: +100, tier: bronze)
[2026-04-19 18:53:57] [SUCCESS] Successfully processed redemption for test@example.com: $1
[2026-04-19 19:25:38] [INFO] Received webhook payload: {"test":true,"customer_email":"example_customer@example.com","customer_id":0,"reward_id":0,"customer_merchant_id":"12345","reward_fulfilment_id":0,"reward_identifier":""}
[2026-04-19 19:25:38] [ERROR] Missing customer or reward data
[2026-04-19 19:30:45] [INFO] Received webhook payload: {"test":true,"customer_email":"example_customer@example.com","customer_id":0,"reward_id":0,"customer_merchant_id":"12345","reward_fulfilment_id":0,"reward_identifier":""}
[2026-04-19 19:30:45] [INFO] LoyaltyLion test call - returning success
[2026-04-19 19:37:03] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 19:37:03] [ERROR] Missing customer or reward data
[2026-04-19 19:37:13] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 19:37:13] [ERROR] Missing customer or reward data
[2026-04-19 19:37:23] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 19:37:23] [ERROR] Missing customer or reward data
[2026-04-19 19:37:44] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 19:37:44] [ERROR] Missing customer or reward data
[2026-04-19 19:38:24] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 19:38:24] [ERROR] Missing customer or reward data
[2026-04-19 19:39:24] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 19:39:24] [ERROR] Missing customer or reward data
[2026-04-19 19:42:25] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 19:42:25] [ERROR] Missing customer or reward data
[2026-04-19 19:47:25] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 19:47:25] [ERROR] Missing customer or reward data
[2026-04-19 19:57:25] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 19:57:25] [INFO] Processing redemption: robert.iannone@stockloyal.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 20:17:26] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 20:17:26] [INFO] Processing redemption: robert.iannone@stockloyal.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:17:26] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-19 21:17:26] [INFO] Processing redemption: robert.iannone@stockloyal.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:17:26] [DEBUG] About to call processStockInvestmentRedemption for: robert.iannone@stockloyal.com
[2026-04-19 21:17:27] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665864}
[2026-04-19 21:17:27] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:17:27] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:17:38] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665864}
[2026-04-19 21:17:38] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:17:38] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:17:48] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665864}
[2026-04-19 21:17:48] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:17:48] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:18:08] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665864}
[2026-04-19 21:18:08] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:18:08] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:18:48] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665864}
[2026-04-19 21:18:48] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:18:48] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:19:49] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665864}
[2026-04-19 21:19:49] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:19:49] [DEBUG] Database connection status: EXISTS
[2026-04-19 21:19:49] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:22:49] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665864}
[2026-04-19 21:22:49] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:22:49] [DEBUG] Database connection status: EXISTS
[2026-04-19 21:22:49] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:22:49] [DEBUG] Starting redemption processing for: reiannone@gmail.com
[2026-04-19 21:22:49] [DEBUG] Database transaction started
[2026-04-19 21:22:49] [DEBUG] Member lookup result: false
[2026-04-19 21:22:49] [DEBUG] Creating new member for reiannone@gmail.com
[2026-04-19 21:22:49] [DEBUG] Recording transaction for member: 
[2026-04-19 21:22:49] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 21:22:49] [DEBUG] Recording broker notification
[2026-04-19 21:22:49] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 21:22:49] [DEBUG] Database transaction committed successfully
[2026-04-19 21:22:49] [SUCCESS] Successfully processed redemption for reiannone@gmail.com: $10
[2026-04-19 21:23:08] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665868}
[2026-04-19 21:23:08] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:23:08] [DEBUG] Database connection status: EXISTS
[2026-04-19 21:23:08] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:23:08] [DEBUG] Starting redemption processing for: reiannone@gmail.com
[2026-04-19 21:23:08] [DEBUG] Database transaction started
[2026-04-19 21:23:08] [DEBUG] Member lookup result: false
[2026-04-19 21:23:08] [DEBUG] Creating new member for reiannone@gmail.com
[2026-04-19 21:23:08] [DEBUG] Recording transaction for member: 
[2026-04-19 21:23:08] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 21:23:08] [DEBUG] Recording broker notification
[2026-04-19 21:23:08] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 21:23:08] [DEBUG] Database transaction committed successfully
[2026-04-19 21:23:08] [SUCCESS] Successfully processed redemption for reiannone@gmail.com: $10
[2026-04-19 21:28:07] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665869}
[2026-04-19 21:28:07] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:28:07] [DEBUG] Database connection status: EXISTS
[2026-04-19 21:28:07] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:28:07] [DEBUG] Starting redemption processing for: reiannone@gmail.com
[2026-04-19 21:28:07] [DEBUG] Database transaction started
[2026-04-19 21:28:07] [DEBUG] Member lookup result: false
[2026-04-19 21:28:07] [DEBUG] Creating new member for reiannone@gmail.com
[2026-04-19 21:28:07] [DEBUG] Generated member_id: 
[2026-04-19 21:28:07] [DEBUG] Recording transaction for member: 
[2026-04-19 21:28:07] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 21:28:07] [DEBUG] Recording broker notification
[2026-04-19 21:28:07] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 21:28:07] [DEBUG] Database transaction committed successfully
[2026-04-19 21:28:07] [SUCCESS] Successfully processed redemption for reiannone@gmail.com: $10
[2026-04-19 21:29:33] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665871}
[2026-04-19 21:29:33] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:29:33] [DEBUG] Database connection status: EXISTS
[2026-04-19 21:29:33] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:29:33] [DEBUG] Starting redemption processing for: reiannone@gmail.com
[2026-04-19 21:29:33] [DEBUG] Database transaction started
[2026-04-19 21:29:33] [DEBUG] Member lookup result: false
[2026-04-19 21:29:33] [DEBUG] Creating new member for reiannone@gmail.com
[2026-04-19 21:29:33] [DEBUG] Generated member_id: 
[2026-04-19 21:29:33] [DEBUG] Recording transaction for member: 
[2026-04-19 21:29:33] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 21:29:33] [DEBUG] Recording broker notification
[2026-04-19 21:29:33] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 21:29:33] [DEBUG] Database transaction committed successfully
[2026-04-19 21:29:33] [SUCCESS] Successfully processed redemption for reiannone@gmail.com: $10
[2026-04-19 21:37:29] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":665873}
[2026-04-19 21:37:29] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:37:29] [DEBUG] Database connection status: EXISTS
[2026-04-19 21:37:29] [DEBUG] About to call processStockInvestmentRedemption for: reiannone@gmail.com
[2026-04-19 21:37:29] [DEBUG] Starting redemption processing for: reiannone@gmail.com
[2026-04-19 21:37:29] [DEBUG] Database transaction started
[2026-04-19 21:37:29] [DEBUG] Member lookup result: false
[2026-04-19 21:37:29] [DEBUG] Creating new member for reiannone@gmail.com
[2026-04-19 21:37:29] [DEBUG] Generated member_id: 
[2026-04-19 21:37:29] [DEBUG] Generated unique member_id: ll_reiannone
[2026-04-19 21:37:29] [INFO] Created new member ll_reiannone: $10 initial credit (points: 1000, tier: bronze)
[2026-04-19 21:37:29] [DEBUG] Recording transaction for member: ll_reiannone
[2026-04-19 21:37:29] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 21:37:29] [DEBUG] Recording broker notification
[2026-04-19 21:37:29] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 21:37:29] [DEBUG] Database transaction committed successfully
[2026-04-19 21:37:29] [SUCCESS] Successfully processed redemption for reiannone@gmail.com: $10
[2026-04-19 21:47:46] [INFO] Received webhook payload: {
    "test": false,
    "reward_id": 231686,
    "customer_id": 1374737110,
    "customer_email": "test-webhook@example.com",
    "reward_identifier": "stock_investment_reward",
    "customer_merchant_id": "9044524793880",
    "reward_fulfilment_id": 665865
  }
[2026-04-19 21:47:46] [INFO] Processing redemption: test-webhook@example.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:47:46] [DEBUG] Database connection status: EXISTS
[2026-04-19 21:47:46] [DEBUG] About to call processStockInvestmentRedemption for: test-webhook@example.com
[2026-04-19 21:47:46] [DEBUG] Starting redemption processing for: test-webhook@example.com
[2026-04-19 21:47:46] [DEBUG] Database transaction started
[2026-04-19 21:47:46] [DEBUG] Member lookup result: false
[2026-04-19 21:47:46] [DEBUG] Creating new member for test-webhook@example.com
[2026-04-19 21:47:46] [DEBUG] Generated member_id: 
[2026-04-19 21:47:46] [DEBUG] Generated unique member_id: ll_testwebhook
[2026-04-19 21:47:46] [INFO] Created new member ll_testwebhook: $10 initial credit (points: 1000, tier: bronze)
[2026-04-19 21:47:46] [DEBUG] Recording transaction for member: ll_testwebhook
[2026-04-19 21:47:46] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 21:47:46] [DEBUG] Recording broker notification
[2026-04-19 21:47:46] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 21:47:46] [DEBUG] Database transaction committed successfully
[2026-04-19 21:47:46] [SUCCESS] Successfully processed redemption for test-webhook@example.com: $10
[2026-04-19 21:47:46] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=test-webhook%40example.com&source=loyaltylion&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 21:48:23] [INFO] Received webhook payload: {
    "test": false,
    "reward_id": 231687,
    "customer_id": 1374737111,
    "customer_email": "redirect-test@example.com",
    "reward_identifier": "stock_investment_reward",
    "customer_merchant_id": "9044524793881",
    "reward_fulfilment_id": 665866
  }
[2026-04-19 21:48:23] [INFO] Processing redemption: redirect-test@example.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:48:23] [DEBUG] Database connection status: EXISTS
[2026-04-19 21:48:23] [DEBUG] About to call processStockInvestmentRedemption for: redirect-test@example.com
[2026-04-19 21:48:23] [DEBUG] Starting redemption processing for: redirect-test@example.com
[2026-04-19 21:48:23] [DEBUG] Database transaction started
[2026-04-19 21:48:23] [DEBUG] Member lookup result: false
[2026-04-19 21:48:23] [DEBUG] Creating new member for redirect-test@example.com
[2026-04-19 21:48:23] [DEBUG] Generated member_id: 
[2026-04-19 21:48:23] [DEBUG] Generated unique member_id: ll_redirecttest
[2026-04-19 21:48:23] [INFO] Created new member ll_redirecttest: $10 initial credit (points: 1000, tier: bronze)
[2026-04-19 21:48:23] [DEBUG] Recording transaction for member: ll_redirecttest
[2026-04-19 21:48:23] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 21:48:23] [DEBUG] Recording broker notification
[2026-04-19 21:48:23] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 21:48:23] [DEBUG] Database transaction committed successfully
[2026-04-19 21:48:23] [SUCCESS] Successfully processed redemption for redirect-test@example.com: $10
[2026-04-19 21:48:23] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=redirect-test%40example.com&source=loyaltylion&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 21:52:59] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665875}
[2026-04-19 21:52:59] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 21:52:59] [DEBUG] Database connection status: EXISTS
[2026-04-19 21:52:59] [DEBUG] About to call processStockInvestmentRedemption for: stockloyaldev@gmail.com
[2026-04-19 21:52:59] [DEBUG] Starting redemption processing for: stockloyaldev@gmail.com
[2026-04-19 21:52:59] [DEBUG] Database transaction started
[2026-04-19 21:52:59] [DEBUG] Member lookup result: {"member_id":"quantum","member_email":"stockloyaldev@gmail.com","cash_balance":"586.76","points":73345}
[2026-04-19 21:52:59] [DEBUG] Updating member quantum: current balance 586.76, adding 10
[2026-04-19 21:52:59] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 21:52:59] [INFO] Updated existing member quantum: added $10 (points: +1000, tier: bronze)
[2026-04-19 21:52:59] [DEBUG] Recording transaction for member: quantum
[2026-04-19 21:52:59] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 21:52:59] [DEBUG] Recording broker notification
[2026-04-19 21:52:59] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 21:52:59] [DEBUG] Database transaction committed successfully
[2026-04-19 21:52:59] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 21:52:59] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&source=loyaltylion&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:05:22] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665884}
[2026-04-19 22:05:22] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:05:22] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:05:22] [DEBUG] About to call processStockInvestmentRedemption for: stockloyaldev@gmail.com
[2026-04-19 22:05:22] [DEBUG] Starting redemption processing for: stockloyaldev@gmail.com
[2026-04-19 22:05:22] [DEBUG] Database transaction started
[2026-04-19 22:05:22] [DEBUG] Member lookup result: {"member_id":"quantum","member_email":"stockloyaldev@gmail.com","cash_balance":"596.76","points":74345}
[2026-04-19 22:05:22] [DEBUG] Updating member quantum: current balance 596.76, adding 10
[2026-04-19 22:05:22] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:05:22] [INFO] Updated existing member quantum: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:05:22] [DEBUG] Recording transaction for member: quantum
[2026-04-19 22:05:22] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:05:22] [DEBUG] Recording broker notification
[2026-04-19 22:05:22] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:05:22] [DEBUG] Database transaction committed successfully
[2026-04-19 22:05:22] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 22:05:22] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&source=loyaltylion&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:10:28] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665885}
[2026-04-19 22:10:28] [DEBUG] Mapped LoyaltyLion merchant 9044590395415 to StockLoyal merchant: unknown
[2026-04-19 22:10:28] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:10:28] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:10:28] [DEBUG] About to call processStockInvestmentRedemption for: stockloyaldev@gmail.com
[2026-04-19 22:10:28] [DEBUG] Starting redemption processing for: stockloyaldev@gmail.com
[2026-04-19 22:10:28] [DEBUG] Database transaction started
[2026-04-19 22:10:28] [DEBUG] Member lookup result: {"member_id":"quantum","member_email":"stockloyaldev@gmail.com","cash_balance":"606.76","points":75345}
[2026-04-19 22:10:28] [DEBUG] Updating member quantum: current balance 606.76, adding 10
[2026-04-19 22:10:28] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:10:28] [INFO] Updated existing member quantum: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:10:28] [DEBUG] Recording transaction for member: quantum
[2026-04-19 22:10:28] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:10:28] [DEBUG] Recording broker notification
[2026-04-19 22:10:28] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:10:28] [DEBUG] Database transaction committed successfully
[2026-04-19 22:10:28] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 22:10:28] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&source=unknown&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:19:01] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665896}
[2026-04-19 22:19:01] [ERROR] No merchant found for LoyaltyLion ID: 9044590395415
[2026-04-19 22:19:01] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:19:01] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:19:01] [DEBUG] About to call processStockInvestmentRedemption for: stockloyaldev@gmail.com
[2026-04-19 22:19:01] [DEBUG] Starting redemption processing for: stockloyaldev@gmail.com
[2026-04-19 22:19:01] [DEBUG] Database transaction started
[2026-04-19 22:19:01] [DEBUG] Member lookup result: {"member_id":"quantum","member_email":"stockloyaldev@gmail.com","cash_balance":"616.76","points":76345}
[2026-04-19 22:19:01] [DEBUG] Updating member quantum: current balance 616.76, adding 10
[2026-04-19 22:19:01] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:19:01] [INFO] Updated existing member quantum: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:19:01] [DEBUG] Recording transaction for member: quantum
[2026-04-19 22:19:01] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:19:01] [DEBUG] Recording broker notification
[2026-04-19 22:19:01] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:19:01] [DEBUG] Database transaction committed successfully
[2026-04-19 22:19:01] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 22:19:01] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&source=unknown&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:24:51] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665901}
[2026-04-19 22:24:51] [ERROR] No merchant found for LoyaltyLion ID: 9044590395415
[2026-04-19 22:24:51] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:24:51] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:24:51] [DEBUG] About to call processStockInvestmentRedemption for: stockloyaldev@gmail.com
[2026-04-19 22:24:51] [DEBUG] Starting redemption processing for: stockloyaldev@gmail.com
[2026-04-19 22:24:51] [DEBUG] Database transaction started
[2026-04-19 22:24:51] [DEBUG] Member lookup result: {"member_id":"quantum","member_email":"stockloyaldev@gmail.com","cash_balance":"626.76","points":77345}
[2026-04-19 22:24:51] [DEBUG] Updating member quantum: current balance 626.76, adding 10
[2026-04-19 22:24:51] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:24:51] [INFO] Updated existing member quantum: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:24:51] [DEBUG] Recording transaction for member: quantum
[2026-04-19 22:24:51] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:24:51] [DEBUG] Recording broker notification
[2026-04-19 22:24:51] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:24:51] [DEBUG] Database transaction committed successfully
[2026-04-19 22:24:51] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 22:24:51] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&merchant_id=unknown&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:25:09] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665902}
[2026-04-19 22:25:09] [ERROR] No merchant found for LoyaltyLion ID: 9044590395415
[2026-04-19 22:25:09] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:25:09] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:25:09] [DEBUG] About to call processStockInvestmentRedemption for: stockloyaldev@gmail.com
[2026-04-19 22:25:09] [DEBUG] Starting redemption processing for: stockloyaldev@gmail.com
[2026-04-19 22:25:09] [DEBUG] Database transaction started
[2026-04-19 22:25:09] [DEBUG] Member lookup result: {"member_id":"quantum","member_email":"stockloyaldev@gmail.com","cash_balance":"636.76","points":78345}
[2026-04-19 22:25:09] [DEBUG] Updating member quantum: current balance 636.76, adding 10
[2026-04-19 22:25:09] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:25:09] [INFO] Updated existing member quantum: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:25:09] [DEBUG] Recording transaction for member: quantum
[2026-04-19 22:25:09] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:25:09] [DEBUG] Recording broker notification
[2026-04-19 22:25:09] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:25:09] [DEBUG] Database transaction committed successfully
[2026-04-19 22:25:09] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 22:25:09] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&merchant_id=unknown&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:28:28] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142430,"customer_email":"jefflogan1330@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"5033283584023","reward_fulfilment_id":665904}
[2026-04-19 22:28:28] [DEBUG] Searching for merchant with ID: [5033283584023]
[2026-04-19 22:28:28] [DEBUG] Query result: false
[2026-04-19 22:28:28] [ERROR] No merchant found for LoyaltyLion ID: 5033283584023
[2026-04-19 22:28:28] [INFO] Processing redemption: jefflogan1330@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:28:28] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:28:28] [DEBUG] About to call processStockInvestmentRedemption for: jefflogan1330@gmail.com
[2026-04-19 22:28:28] [DEBUG] Starting redemption processing for: jefflogan1330@gmail.com
[2026-04-19 22:28:28] [DEBUG] Database transaction started
[2026-04-19 22:28:28] [DEBUG] Member lookup result: {"member_id":"rex1330","member_email":"jefflogan1330@gmail.com","cash_balance":"10.00","points":1000}
[2026-04-19 22:28:28] [DEBUG] Updating member rex1330: current balance 10.00, adding 10
[2026-04-19 22:28:28] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:28:28] [INFO] Updated existing member rex1330: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:28:28] [DEBUG] Recording transaction for member: rex1330
[2026-04-19 22:28:28] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:28:28] [DEBUG] Recording broker notification
[2026-04-19 22:28:28] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:28:28] [DEBUG] Database transaction committed successfully
[2026-04-19 22:28:28] [SUCCESS] Successfully processed redemption for jefflogan1330@gmail.com: $10
[2026-04-19 22:28:28] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan1330%40gmail.com&merchant_id=unknown&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:28:52] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665905}
[2026-04-19 22:28:52] [DEBUG] Searching for merchant with ID: [9044590395415]
[2026-04-19 22:28:52] [DEBUG] Query result: {"merchant_id":"9044590395415","merchant_name":"Logan1330"}
[2026-04-19 22:28:52] [DEBUG] Found merchant: Logan1330 (ID: 9044590395415) for LoyaltyLion ID: 9044590395415
[2026-04-19 22:28:52] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:28:52] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:28:52] [DEBUG] About to call processStockInvestmentRedemption for: stockloyaldev@gmail.com
[2026-04-19 22:28:52] [DEBUG] Starting redemption processing for: stockloyaldev@gmail.com
[2026-04-19 22:28:52] [DEBUG] Database transaction started
[2026-04-19 22:28:52] [DEBUG] Member lookup result: {"member_id":"quantum","member_email":"stockloyaldev@gmail.com","cash_balance":"646.76","points":79345}
[2026-04-19 22:28:52] [DEBUG] Updating member quantum: current balance 646.76, adding 10
[2026-04-19 22:28:52] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:28:52] [INFO] Updated existing member quantum: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:28:52] [DEBUG] Recording transaction for member: quantum
[2026-04-19 22:28:52] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:28:52] [DEBUG] Recording broker notification
[2026-04-19 22:28:52] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:28:52] [DEBUG] Database transaction committed successfully
[2026-04-19 22:28:52] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 22:28:52] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&merchant_id=9044590395415&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:33:22] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665911}
[2026-04-19 22:33:22] [DEBUG] Searching for merchant with ID: [9044590395415]
[2026-04-19 22:33:22] [DEBUG] Searching for merchant with ID: [9044590395415]
[2026-04-19 22:33:22] [DEBUG] Query result: {"merchant_id":"9044590395415","merchant_name":"Logan1330"}
[2026-04-19 22:33:22] [DEBUG] Query result: {"merchant_id":"9044590395415","merchant_name":"Logan1330"}
[2026-04-19 22:33:22] [DEBUG] Found merchant: Logan1330 (ID: 9044590395415) for LoyaltyLion ID: 9044590395415
[2026-04-19 22:33:22] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:33:22] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:33:22] [DEBUG] About to call processStockInvestmentRedemption for: stockloyaldev@gmail.com
[2026-04-19 22:33:22] [DEBUG] Starting redemption processing for: stockloyaldev@gmail.com
[2026-04-19 22:33:22] [DEBUG] Database transaction started
[2026-04-19 22:33:22] [DEBUG] Member lookup result: {"member_id":"quantum","member_email":"stockloyaldev@gmail.com","cash_balance":"656.76","points":80345}
[2026-04-19 22:33:22] [DEBUG] Updating member quantum: current balance 656.76, adding 10
[2026-04-19 22:33:22] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:33:22] [INFO] Updated existing member quantum: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:33:22] [DEBUG] Recording transaction for member: quantum
[2026-04-19 22:33:22] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:33:22] [DEBUG] Recording broker notification
[2026-04-19 22:33:22] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:33:22] [DEBUG] Database transaction committed successfully
[2026-04-19 22:33:22] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 22:33:22] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&merchant_id=9044590395415&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:33:43] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665912}
[2026-04-19 22:33:43] [DEBUG] Searching for merchant with ID: [9044590395415]
[2026-04-19 22:33:43] [DEBUG] Searching for merchant with ID: [9044590395415]
[2026-04-19 22:33:43] [DEBUG] Query result: {"merchant_id":"9044590395415","merchant_name":"Logan1330"}
[2026-04-19 22:33:43] [DEBUG] Query result: {"merchant_id":"9044590395415","merchant_name":"Logan1330"}
[2026-04-19 22:33:43] [DEBUG] Found merchant: Logan1330 (ID: 9044590395415) for LoyaltyLion ID: 9044590395415
[2026-04-19 22:33:43] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:33:43] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:33:43] [DEBUG] About to call processStockInvestmentRedemption for: stockloyaldev@gmail.com
[2026-04-19 22:33:43] [DEBUG] Starting redemption processing for: stockloyaldev@gmail.com
[2026-04-19 22:33:43] [DEBUG] Database transaction started
[2026-04-19 22:33:43] [DEBUG] Member lookup result: {"member_id":"quantum","member_email":"stockloyaldev@gmail.com","cash_balance":"666.76","points":81345}
[2026-04-19 22:33:43] [DEBUG] Updating member quantum: current balance 666.76, adding 10
[2026-04-19 22:33:43] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:33:43] [INFO] Updated existing member quantum: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:33:43] [DEBUG] Recording transaction for member: quantum
[2026-04-19 22:33:43] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:33:43] [DEBUG] Recording broker notification
[2026-04-19 22:33:43] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:33:43] [DEBUG] Database transaction committed successfully
[2026-04-19 22:33:43] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 22:33:43] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&merchant_id=9044590395415&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:34:03] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142430,"customer_email":"jefflogan1330@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"5033283584023","reward_fulfilment_id":665913}
[2026-04-19 22:34:03] [DEBUG] Searching for merchant with ID: [5033283584023]
[2026-04-19 22:34:03] [DEBUG] Searching for merchant with ID: [5033283584023]
[2026-04-19 22:34:03] [DEBUG] Query result: false
[2026-04-19 22:34:03] [DEBUG] Query result: false
[2026-04-19 22:34:03] [ERROR] No merchant found for LoyaltyLion ID: 5033283584023
[2026-04-19 22:34:03] [INFO] Processing redemption: jefflogan1330@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:34:03] [DEBUG] Database connection status: EXISTS
[2026-04-19 22:34:03] [DEBUG] About to call processStockInvestmentRedemption for: jefflogan1330@gmail.com
[2026-04-19 22:34:03] [DEBUG] Starting redemption processing for: jefflogan1330@gmail.com
[2026-04-19 22:34:03] [DEBUG] Database transaction started
[2026-04-19 22:34:03] [DEBUG] Member lookup result: {"member_id":"rex1330","member_email":"jefflogan1330@gmail.com","cash_balance":"20.00","points":2000}
[2026-04-19 22:34:03] [DEBUG] Updating member rex1330: current balance 20.00, adding 10
[2026-04-19 22:34:03] [DEBUG] UPDATE result: SUCCESS, rows affected: 1
[2026-04-19 22:34:03] [INFO] Updated existing member rex1330: added $10 (points: +1000, tier: bronze)
[2026-04-19 22:34:03] [DEBUG] Recording transaction for member: rex1330
[2026-04-19 22:34:03] [DEBUG] Transaction insert result: SUCCESS
[2026-04-19 22:34:03] [DEBUG] Recording broker notification
[2026-04-19 22:34:03] [DEBUG] Broker notification result: SUCCESS
[2026-04-19 22:34:03] [DEBUG] Database transaction committed successfully
[2026-04-19 22:34:03] [SUCCESS] Successfully processed redemption for jefflogan1330@gmail.com: $10
[2026-04-19 22:34:03] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan1330%40gmail.com&merchant_id=unknown&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:58:48] [INFO] Received webhook payload: {
    "test": false,
    "reward_id": 231687,
    "customer_id": 1374737112,
    "customer_email": "test-clean@example.com",
    "reward_identifier": "stock_investment_reward",
    "customer_merchant_id": "5033283584023",
    "reward_fulfilment_id": 665867
  }
[2026-04-19 22:58:48] [INFO] Processing redemption: test-clean@example.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:58:48] [INFO] Created new member ll_testclean: $10
[2026-04-19 22:58:48] [SUCCESS] Successfully processed redemption for test-clean@example.com: $10
[2026-04-19 22:58:48] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=test-clean%40example.com&merchant_id=logan1330&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 22:58:50] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665922}
[2026-04-19 22:58:50] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 22:58:50] [INFO] Updated existing member quantum: added $10
[2026-04-19 22:58:50] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 22:58:50] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&merchant_id=logan1330&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 23:02:01] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665930}
[2026-04-19 23:02:01] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 23:02:01] [INFO] Updated existing member quantum: added $10
[2026-04-19 23:02:01] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $10
[2026-04-19 23:02:01] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&merchant_id=logan1330&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 23:02:45] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142430,"customer_email":"jefflogan1330@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"5033283584023","reward_fulfilment_id":665923}
[2026-04-19 23:02:45] [INFO] Processing redemption: jefflogan1330@gmail.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 23:02:45] [INFO] Updated existing member rex1330: added $10
[2026-04-19 23:02:45] [SUCCESS] Successfully processed redemption for jefflogan1330@gmail.com: $10
[2026-04-19 23:02:45] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan1330%40gmail.com&merchant_id=logan1330&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-19 23:13:55] [INFO] Received webhook payload: {"test":false,"reward_id":999,"customer_email":"test@example.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"123"}
[2026-04-19 23:13:55] [INFO] Processing redemption: test@example.com -> stock_investment_reward (1000 points, $10)
[2026-04-19 23:13:55] [INFO] Updated existing member ll_test: added $10
[2026-04-19 23:13:55] [SUCCESS] Successfully processed redemption for test@example.com: $10
[2026-04-19 23:13:55] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=test%40example.com&merchant_id=logan1330&points=1000&tier=bronze&credit=10&welcome=true
[2026-04-20 14:26:45] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142430,"customer_email":"jefflogan1330@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"5033283584023","reward_fulfilment_id":666258}
[2026-04-20 14:26:45] [INFO] Processing redemption: jefflogan1330@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-20 14:26:45] [INFO] Updated existing member rex1330: added $1
[2026-04-20 14:26:45] [SUCCESS] Successfully processed redemption for jefflogan1330@gmail.com: $1
[2026-04-20 14:26:45] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan1330%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-20 14:26:53] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374746524,"customer_email":"stockloyaldev@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044590395415","reward_fulfilment_id":665925}
[2026-04-20 14:26:53] [INFO] Processing redemption: stockloyaldev@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-20 14:26:53] [INFO] Updated existing member quantum: added $1
[2026-04-20 14:26:53] [SUCCESS] Successfully processed redemption for stockloyaldev@gmail.com: $1
[2026-04-20 14:26:53] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=stockloyaldev%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-20 14:54:12] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142409,"customer_email":"jefflogan8@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"429751664663","reward_fulfilment_id":665975}
[2026-04-20 14:54:12] [INFO] Processing redemption: jefflogan8@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-20 14:54:12] [INFO] Updated existing member logan104: added $1
[2026-04-20 14:54:12] [SUCCESS] Successfully processed redemption for jefflogan8@gmail.com: $1
[2026-04-20 14:54:12] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan8%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-20 14:54:41] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142409,"customer_email":"jefflogan8@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"429751664663","reward_fulfilment_id":665976}
[2026-04-20 14:54:41] [INFO] Processing redemption: jefflogan8@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-20 14:54:41] [INFO] Updated existing member logan104: added $1
[2026-04-20 14:54:41] [SUCCESS] Successfully processed redemption for jefflogan8@gmail.com: $1
[2026-04-20 14:54:41] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan8%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-20 14:57:50] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142409,"customer_email":"jefflogan8@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"429751664663","reward_fulfilment_id":665978}
[2026-04-20 14:57:50] [INFO] Processing redemption: jefflogan8@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-20 14:57:50] [INFO] Updated existing member logan104: added $1
[2026-04-20 14:57:50] [SUCCESS] Successfully processed redemption for jefflogan8@gmail.com: $1
[2026-04-20 14:57:50] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan8%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-20 14:59:29] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142409,"customer_email":"jefflogan8@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"429751664663","reward_fulfilment_id":665979}
[2026-04-20 14:59:29] [INFO] Processing redemption: jefflogan8@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-20 14:59:29] [INFO] Updated existing member logan104: added $1
[2026-04-20 14:59:29] [SUCCESS] Successfully processed redemption for jefflogan8@gmail.com: $1
[2026-04-20 14:59:29] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan8%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-20 15:02:03] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142409,"customer_email":"jefflogan8@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"429751664663","reward_fulfilment_id":665986}
[2026-04-20 15:02:03] [INFO] Processing redemption: jefflogan8@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-20 15:02:03] [INFO] Updated existing member logan104: added $1
[2026-04-20 15:02:04] [SUCCESS] Successfully processed redemption for jefflogan8@gmail.com: $1
[2026-04-20 15:02:04] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan8%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-20 15:18:15] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":665810}
[2026-04-20 15:18:15] [INFO] Processing redemption: robert.iannone@stockloyal.com -> stock_investment_reward (100 points, $1)
[2026-04-20 15:18:15] [INFO] Updated existing member stockloyal: added $1
[2026-04-20 15:18:15] [SUCCESS] Successfully processed redemption for robert.iannone@stockloyal.com: $1
[2026-04-20 15:18:15] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=robert.iannone%40stockloyal.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-20 21:41:41] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":666583}
[2026-04-20 21:41:41] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-20 21:41:41] [INFO] Updated existing member ll_reiannone: added $1
[2026-04-20 21:41:41] [SUCCESS] Successfully processed redemption for reiannone@gmail.com: $1
[2026-04-20 21:41:41] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=reiannone%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-20 21:47:17] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374737109,"customer_email":"reiannone@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9044524793879","reward_fulfilment_id":666585}
[2026-04-20 21:47:17] [INFO] Processing redemption: reiannone@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-20 21:47:17] [INFO] Updated existing member ll_reiannone: added $1
[2026-04-20 21:47:17] [SUCCESS] Successfully processed redemption for reiannone@gmail.com: $1
[2026-04-20 21:47:17] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=reiannone%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-23 00:40:36] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":667911}
[2026-04-23 00:40:36] [INFO] Processing redemption: robert.iannone@stockloyal.com -> stock_investment_reward (100 points, $1)
[2026-04-23 00:40:36] [INFO] Updated existing member stockloyal: added $1
[2026-04-23 00:40:36] [SUCCESS] Successfully processed redemption for robert.iannone@stockloyal.com: $1
[2026-04-23 00:40:36] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=robert.iannone%40stockloyal.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-23 02:42:54] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374442986,"customer_email":"robert.iannone@stockloyal.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"9041257725975","reward_fulfilment_id":667964}
[2026-04-23 02:42:54] [INFO] Processing redemption: robert.iannone@stockloyal.com -> stock_investment_reward (100 points, $1)
[2026-04-23 02:42:54] [INFO] Updated existing member stockloyal: added $1
[2026-04-23 02:42:54] [SUCCESS] Successfully processed redemption for robert.iannone@stockloyal.com: $1
[2026-04-23 02:42:54] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=robert.iannone%40stockloyal.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-24 03:19:38] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142409,"customer_email":"jefflogan8@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"429751664663","reward_fulfilment_id":668582}
[2026-04-24 03:19:38] [INFO] Processing redemption: jefflogan8@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-24 03:19:38] [INFO] Updated existing member logan104: added $1
[2026-04-24 03:19:38] [SUCCESS] Successfully processed redemption for jefflogan8@gmail.com: $1
[2026-04-24 03:19:38] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan8%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-04-25 23:50:37] [INFO] Received webhook payload: {"test":false,"reward_id":231685,"customer_id":1374142409,"customer_email":"jefflogan8@gmail.com","reward_identifier":"stock_investment_reward","customer_merchant_id":"429751664663","reward_fulfilment_id":669766}
[2026-04-25 23:50:37] [INFO] Processing redemption: jefflogan8@gmail.com -> stock_investment_reward (100 points, $1)
[2026-04-25 23:50:37] [INFO] Updated existing member logan104: added $1
[2026-04-25 23:50:37] [SUCCESS] Successfully processed redemption for jefflogan8@gmail.com: $1
[2026-04-25 23:50:37] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=jefflogan8%40gmail.com&merchant_id=logan1330&points=100&tier=bronze&credit=1&welcome=true
[2026-05-02 00:01:18] [INFO] Received webhook payload: {"test": true}
[2026-05-02 00:01:18] [INFO] LoyaltyLion test call - returning success
[2026-05-02 00:01:18] [INFO] Received webhook payload: {"test": true}
[2026-05-02 00:01:18] [INFO] LoyaltyLion test call - returning success
[2026-05-02 00:25:48] [INFO] Received webhook payload: {"test": true}
[2026-05-02 00:25:48] [INFO] LoyaltyLion test call - returning success
[2026-05-02 00:27:41] [INFO] Received webhook payload: {
    "customer_email": "newuser@logan1330.com",
    "reward_identifier": "stock_investment_reward",
    "reward_id": 123,
    "customer_id": 456
  }
[2026-05-02 00:27:41] [INFO] Processing redemption: newuser@logan1330.com -> stock_investment_reward (100 points, $1)
[2026-05-02 00:27:41] [INFO] Determined merchant: logan1330 for email: newuser@logan1330.com
[2026-05-02 00:27:41] [INFO] Created new member lgnyw60cz7t via proper API: $1
[2026-05-02 00:27:41] [SUCCESS] Successfully processed redemption for newuser@logan1330.com (member: lgnyw60cz7t): $1
[2026-05-02 00:27:41] [SUCCESS] Redirecting user to: https://app.stockloyal.com/?email=newuser%40logan1330.com&merchant_id=logan1330&points=100&credit=1&welcome=true