How can I get a simple list of every customers name, email and the total reward points they have so I can use to remind customers with an email they have points to spend in my store.
I have tried using tables _users and _reward_point_changes but I when I check against what I see in admin the total is sometimes the same and sometimes not.
Is there another table I need to use as well or is there another easier way.
Thanks
Paul