Hello friends..
It is possible to select dependent attribures.
consider Nop_ProductVariantAttributeValue Table
ProductVariantAttributeValueID int Unchecked (PK)
ProductVariantAttributeID int Unchecked
Name nvarchar(100) Unchecked
PriceAdjustment money Unchecked
WeightAdjustment decimal(18, 4) Unchecked
IsPreSelected bit Unchecked
DisplayOrder int Unchecked
Quantity int Checked ------> This column added by dipesh
consider 28 id for attribure color
select * from Nop_ProductVariantAttributeValue
Quantity
81 28 20 Mil 0.00 0.0000 0 1 500
82 28 30 Mil 2.00 0.0000 0 1 500
85 28 35 Mil 2.00 0.0000 0 1 500
83 28 20 Mil 0.00 0.0000 0 1 1000
84 28 30 Mil 2.00 0.0000 0 1 1000
when i will select 500 quantity at that time i need only 20 mil,30 mil, 35 mil in my color dropdownlist (which is genereted by nopcommerce code) . and when i will select 1000 quantity at that time i need only 20 mil and 30 mil .
now i am using nopcommerce 1.8.0 in wich all attributes values are fill in drop down list i.e for color attribure we get 20 mil,30 mil, 35 mil , all three value .
it is possible to get attribures values with respect to quantiry... eg..
case :1 suppose i take one quantity dropdownlist on product detail page and select 500 quantity then i nee this result in my product attributes dropdown list
Color : 20 Mil
30 Mil
35 Mil
case : 2 suppose i take one quantity dropdownlist on product detail page and select 1000 quantity then i nee this result in my product attributes dropdown list
Color : 20 Mil
30 Mil
it is possible then tell me in wich table we need to alter.
Dipesh Jade (India )