Post by srdjank » Fri Jun 25, 2021 4:11 am

Hi there,

Is there any way we can extract the reward points per customer and have them placed in a CSV file?

Thanks!
Srdjan

Newbie

Posts

Joined
Wed Mar 24, 2021 1:57 am

Post by straightlight » Fri Jun 25, 2021 9:45 am

OC version. Extension request.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by paulfeakins » Fri Jun 25, 2021 7:17 pm

srdjank wrote:
Fri Jun 25, 2021 4:11 am
Is there any way we can extract the reward points per customer and have them placed in a CSV file?
Try something like:

Code: Select all

SELECT c.customer_id, points 
FROM `oc_customer` c 
JOIN `oc_customer_reward` cr ON c.customer_id = cr.customer_id 
If done in phpMyAdmin, a CSV export button can be found at the bottom.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: No registered users and 64 guests