AbleCommerce Shopping Cart Software

Posted: **Fri Dec 18, 2009 1:43 pm**

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?

Posted: **Sat Dec 19, 2009 12:53 am**

Here are the values for InventoryMode enumeration

Code: Select all

None = 0
Product = 1
Variant = 2

Posted: **Mon Dec 21, 2009 1:01 pm**

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?

AbleCommerce Shopping Cart Software

Custom report - question about Product, Inventory Tracking

Custom report - question about Product, Inventory Tracking

Re: Custom report - question about Product, Inventory Tracking

Re: Custom report - question about Product, Inventory Tracking