list of customers who bought items from specific category

[tanse]

Hello everyone!

Is there a way to create a list of customers who only bought products from a specific products catergory?

Thanks for the help.

[Daresh]

It should be possible with some SQL query of medium complexity, rather not something that you can find in the back office.

[ps8modules.com]

Hi.

Also functional in SQL Manager Prestashop admin->Advanced Parameters->Database->SQL Manager

E.g. for id category = 4:

SELECT  a.id_customer,
        a.firstname,
        a.lastname,
        a.email
FROM    ps_customer a
        LEFT JOIN ps_orders o
            ON a.id_customer = o.id_customer
        LEFT JOIN ps_order_detail b
            ON o.id_order = b.id_order
        LEFT JOIN ps_category_product c
            ON b.product_id = c.id_product
WHERE c.id_category = 4
GROUP BY a.id_customer

Edited November 23, 2022 by 4you.software (see edit history)

[tanse]

2 hours ago, 4you.software said:

I added the SQL here, but again the post is senselessly blocked 😄

 

Thank you. It gives me Undefined "checkedForm" error

[ps8modules.com]

And please, where does it give an error?
Can you make a screenshot?

Did you change the table prefix ps_ to your table prefix ?
Thank you

Edited November 23, 2022 by 4you.software (see edit history)

[tanse]

[ps8modules.com]

 

[ps8modules.com]

What is your version of Prestashop please?

[tanse]

1.7.5.2

Thank you for your help

[ps8modules.com]

I tested on my version 1.7.5.6 and everything works.
When you put sql in phpMyAdmin, does it work?

Edited November 23, 2022 by 4you.software (see edit history)

[tanse]

Not working 🤔

Nnot 

[knacky]

Please, you must first select the database and then insert the sql.

[ps8modules.com]

Thank you @knacky, I just wanted to write the same thing.

[tanse]

It worked! Thank you!

[ps8modules.com]

Hi.
You can see that it is not a complicated sql 😉

You just edit the category id.

I gladly helped.