Custom report - question about Product, Inventory Tracking

[ksolito]

I am writing a custom report and I need to filter on the Product Inventory Tracking state.

I assmue this is the InventoryModeId field in the Products table. Where can I find the definintions for the InventoryModeId values?

[mazhar]

Here are the values for InventoryMode enumeration

Code: Select all

None = 0
Product = 1
Variant = 2

[ksolito]

Thanks Mazhar,

Now another question related to the report.

In this report, I need to show Product Name, SKU, Stock, and the Variant Name, SKU, and Stock. In the database the Variant Names values are all NULL and my attempt to include them using Products->Options->OptionChoices resulted in a complete set of Product/Variant rows for each Option Choice value so clearly I have a problem with both the table relations and the type of joins I used to get them.

My report looks great until I try to include the option names where I would have assumed the VariantName would have been the field I was looking for.

Any suggestions on what I am doing wrong and what the correct solution is?