How to maintain Quantity of ProductVarient.

[vijjendra]

Hi,
I want to know how to maintain Quantity of ProductVarient.
Suppose We have a Product T-shirt with Quantity 200.
This Product Contains 1 option for color. Suppose we have 3 optionChoice for color Green,Red,Black. Now my question is that I have 50 T-Shirt of Color Green,100 of color Black and rest 50 are of Color Red,these Product Quantity with varient is in my Stock, now how I have Implemented it in Product Varient with Quantity,Which table you used for this,and you haandle this in fron end.

[mazhar]

in order to maintain inventory first you need to enable inventory tracking if its disabled from store settings page on merchant side. Once inventory tracking on store is enabled then you can edit some product and on edit screen set product inventory tracking to variants uncheck allow back order check-box. Then from left side menu pick Options and Variants link. Then create one option with three choices and click mange variants button. On manage variants screen specify in-stock value for each variant. Variants information is being stored in ac_ProductsVariants table.