Post by RainbowDogs » Mon Aug 06, 2018 12:57 am

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

Newbie

Posts

Joined
Sun Feb 11, 2018 5:48 am

Post by straightlight » Mon Aug 06, 2018 1:29 am

RainbowDogs wrote:
Mon Aug 06, 2018 12:57 am
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

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`);
in your PHPMyAdmin. This will display all matched customers between the registered customers and registered customers who have ordered prior. If using a different prefix table name than: oc_, ensure to change them accordingly in the query before executing it.

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 RainbowDogs » Mon Aug 06, 2018 3:28 pm

Thanks straightlight! Will give that a go.

Newbie

Posts

Joined
Sun Feb 11, 2018 5:48 am
Who is online

Users browsing this forum: Ahrefs [Bot] and 109 guests