Hi there,
Is there any way we can extract the reward points per customer and have them placed in a CSV file?
Thanks!
Srdjan
OC version. Extension request.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
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
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Who is online
Users browsing this forum: No registered users and 17 guests