Wanting to search for customers who purchased a product

[UncleSteve]

I've tried several add-ons, but not found what I'm looking for, so asking for help please?

 

I need to be able to search for customers who purchased a particular product, or search for orders that contain a particular product.

 

Can someone suggest a method or a suitable add-on to acheive the above please?

 

Thanks in advance

[burt]

SELECT DISTINCT op.products_name, o.customers_name, o.customers_email_address
FROM orders o
LEFT JOIN orders_products op
ON o.orders_id = op.orders_id
WHERE op.products_id = x
ORDER BY op.products_name

 

Change the x to the ID of the product you are searching on. Untested.

[Guest]

SELECT DISTINCT op.products_name, o.customers_name, o.customers_email_address
FROM orders o
LEFT JOIN orders_products op
ON o.orders_id = op.orders_id
WHERE op.products_id = x
ORDER BY op.products_name

 

Change the x to the ID of the product you are searching on. Untested.

 

Completely correct, but I think he'd want this wrapped in an admin page that shows up in the admin menu... I don't think this already exists, but it can be done by cloning one of the admin pages (like customers.php) and adjusting the queries and fields.

 

[♥toyicebear]

Find Customers by Product

[UncleSteve]

Hi Guy's,

 

So sorry for the late reply. I don't seem to be getting notifications.

 

Thanks for your posts, I'll go and try them out :)

[kru]

I tried that Find Customers By Product add-on and it didn't work...