Thread: Creating an Inventory Query

I am trying to create an inventory report. I have been able to get everything I need except the complete SKU with color and size modifiers. If anyone has done this, could you please provide info on how you did it. Here is my query so far, in case anyone would like to do the same.

SELECT Product.ProductID, Product.SKU, ProductVariant.SKUSuffix, Product.Published, Product.Name, Inventory.Color, Inventory.Size, Inventory.Quan, Manufacturer.Name , ProductVariant.Colors, ProductVariant.ColorSKUModifiers, ProductVariant.Sizes, ProductVariant.SizeSKUModifiers
FROM Product INNER JOIN
ProductVariant ON Product.ProductID = ProductVariant.ProductID INNER JOIN
ProductManufacturer ON Product.ProductID = ProductManufacturer.ProductID INNER JOIN
Manufacturer ON ProductManufacturer.ManufacturerID = Manufacturer.ManufacturerID LEFT OUTER JOIN
Inventory ON ProductVariant.VariantID = Inventory.VariantID
ORDER BY Manufacturer.Name, Product.SKU

Are you sku's a combination of the product sku and the product variant sku?

It would be a combination of the Product SKU and SKU modifier from the variant attribute page.

Originally Posted by dfultz

It would be a combination of the Product SKU and SKU modifier from the variant attribute page.

Don't forget to take Color and Size SKU modifiers into consideration.

Originally Posted by sduffy77

Don't forget to take Color and Size SKU modifiers into consideration.

That is the whole purpose of this thread, the variant SKU modifier is easy to get, the part I am struggling with is the attribute modifier (i.e. Color and Size).

We are in need of the same info. Did you ever figure this out?

Thanks,

Andy