Retrieve an excel list of active priducts

[Azi]

Hello,

 

Is there any way to export an excel list that filters per supplier level and shows all active products?

 

Specifically, I need a list showing only activated products from supplier X.

 

Thanks in advance.

[RogueWaveLimited]

You would need to write an SQL Query to accomplish this.  It would look something like this:

SELECT p.*, s.*
FROM ps_product p
LEFT JOIN ps_supplier s ON (s.id_supplier = p.id_supplier)
WHERE p.active = 1

 

[Azi]

Thanks Richard.

For a specific supplier, let's say supplier has ID = 5, how do I add that?

Maybe like this?

SELECT p.*, s.*
FROM ps_product p
LEFT JOIN ps_supplier s ON (s.id_supplier = p.id_supplier)
WHERE p.active = 1
WHERE id_supplier = 5