Jump to content

Retrieve an excel list of active priducts


Recommended Posts

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.

Link to comment
Share on other sites

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

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...