14/11/2023: Integrations - Loyalty bugs fix

🐛 Integrations

  1. Fixed issue with balances not syncing on balance adjustments

  2. Fixed issue where data wasn't being imported into interim loyalty database, due to invalid characters within the .CSV extracts

  3. Added the ability to run a historic import to SQL database (so it doesn't send it to REST). This will help with future troubleshooting and make it easier to catchup any missing data

  4. Added a delay into how fast the integration pushes the configs through, the recent updates to the REST node caused us to process the configs too quickly - resulting in unexpected behaviour

  5. Historic imports used to generate PoPs on the import date, we now only generate PoPs on a visit

  6. We used to generate PoPs based on a balance adjustment, but a balance adjustment might be for non-visit related purposes (i.e. Expired points). We now generate PoPs based on a Visit flag provided in a new file we consume - loyalty_transactions

👨‍💻 Rob II

Last updated