Version 1.5.6.4
Sometimes customers register but don't order. Is there a report to identify them, or an SQL query I can run?
Thanks
Mike
RainbowDogs wrote: ↑Mon Aug 06, 2018 12:57 amVersion 1.5.6.4
Sometimes customers register but don't order. Is there a report to identify them, or an SQL query I can run?
Thanks
Mike
Code: Select all
SELECT * FROM `oc_customer` `c` INNER JOIN `oc_order` `o` ON (`o`.`customer_id` = `c`.`customer_id`) LEFT JOIN `oc_customer_transaction` `oct` ON (`oct`.`customer_id` = `o`.`customer_id`);
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: Ahrefs [Bot] and 109 guests