Thread: Help including Manufacturer in Low Stock Report

Hello, I am working on a custom report to show all items with stock of less than 10, and list the product's manufacturer for ease of re-ordering.

Here is what I have so far:

Code:

INSERT INTO CustomReport (Name, Description, SQLCommand)
VALUES ('Low Inventory Report', 'Report based on product variant to display inventory with less than 10 items', 'select p.sku,p.name,pv.inventory,p.published from productvariant pv inner join product p on pv.productid=p.productid where inventory < 10 and p.published = 1')

However, I cannot figure out how to list the product's Manufacturer in the report. Help on this would be appreciated!

Let me know if this works or not. It should, i quickly tested it.

Code:

select m.Name, p.sku,p.name,pv.inventory,p.published
from productvariant pv 
inner join product p
on pv.productid=p.productid
inner join ProductManufacturer pm
on pm.ProductID = p.productid
inner join Manufacturer m
on m.ManufacturerID = pm.ManufacturerID
where inventory < 10 and p.published = 1
ORDER BY m.Name DESC

That's perfect! Thanks so much for the help!