Thread: Extracting list of products mapped to manufacturer

We are in the process of upgrading to version 8 of StoreFront. Meanwhile we are trying to extract a list of products assigned to a manufacturer.

I have tried looking in the SQL tables but cannot see this under the manufacturer, product and category but only see these themselves not the product.

Anyone know how to do this without using WSI (we have got this working but it does not extract what we need)

Cheers!

Could you specify exactly what output you are looking for? I would definitely take a look at it just need that information.

The SQL for this would be something like the following:

Select p.* From Product p
inner join ProductManufacturer pm on p.ProductID = pm.ProductID

Or if you have lots of variants

Select p.*, pv.* From Product p
inner join ProductVariant pv.ProductID = p.ProductID
inner join ProductManufacturer pm on pm.ProductID = p.ProductID
Where pm.ManufacturerID = whatevertheidis