Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Need Export Of Customers, Email Address And Total Reward Points Rate Topic   - - - - -

 
  • Pbraz
  • Advanced Member
  • Members
  • Join Date: 26-Aug 12
  • 99 posts

Posted 14 May 2017 - 02:26 AM #1

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


Paul
www.gohorse.com.au
Horse Rugs Store

 
  • Pbraz
  • Advanced Member
  • Members
  • Join Date: 26-Aug 12
  • 99 posts

Posted 14 May 2017 - 02:43 AM #2

I have remembered how to do this now, need to use data in cscart_user_data which has total points.


Paul
www.gohorse.com.au
Horse Rugs Store