Jump to content

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

Email To Customers With Reward Points Rate Topic   - - - - -

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

Posted 09 June 2014 - 11:28 AM #1

I would like to send an email to all my customers with reward points and remind them that they have something of value and to come to my store to use them. Is there an easy way to export a list of customers and reward point balance or do I need to go digging in the database. I could not see reward points as an exportable field in the export data function.
Paul
www.gohorse.com.au
Horse Rugs Store

 

Posted 09 June 2014 - 01:58 PM #2

The only way to do it is export directly from the database via PhpMyAdmin.. Have to export customers(name, email) with id's and also reward points which only contain customer id's.. Then match them up with excel.. Really sucks and time consuming..

Elkhorn Graphics LLC
Cs-Cart 4.7.1  SP3


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

Posted 25 June 2016 - 05:42 AM #3

OK just got back to this and have a problem.

 

For some customers if I look at their points in the reward points log (see attached file) the the addition of the points on left does not equal what is shown on the screen on the right as the total for the customer.

 

If I look at this customer he actually has 4 orders (not 3) and the total of the points in the 4 orders is correct. Why does the 4th (oldest) order not show in the log.

 

I went to table cscart_reward_point_changes and can only find the three orders so Cscart must calculate the total points using data from another table but I can't find where.

 

Does anybody know whats going on here ?

 

Thanks

 

 

Attached Files


Paul
www.gohorse.com.au
Horse Rugs Store

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

Posted 26 June 2016 - 06:45 AM #4

I found cscart_user_data is where the total points for each customer is stored. This aligns with the number in the right hand side of my screen shot.

 

So its not possible to calculate the total points for each customer by adding all the points for each customer in table cscart_reward_point_changes as it does not include every order for me.

 

Paul


Paul
www.gohorse.com.au
Horse Rugs Store

 
  • amdowney
  • Senior Member
  • Members
  • Join Date: 22-Oct 14
  • 227 posts

Posted 23 January 2019 - 08:56 PM #5

A few years on,is there a solution?
Stores: CCTV Kits & www.jmtb.co.uk

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19159 posts

Posted 24 January 2019 - 06:39 AM #6

A few years on,is there a solution?

 

- create new subscriber list for these customers

 

- install our User points module

 

https://www.ecom-lab...nts-add-on.html

 

- export users with points

 

- open file by excel and sort users by reward points

 

- delete users without points

 

- add Mailing list column and fill it with the new mailing list data

 

- go to Administration -> Import data -> Subscribers and import this feed


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.