It is possible in Nopcommerce to provied discound on product variant attributevalue

Hello friends

It is possibel to provied Discound on productvariantattributevalue i.e

i have one attribute  : Color :
                  Variant  : ColorInfo:
                   Option  : Red Color ------------> 2%
                               : Blure Color ----------> 5%

                                  ......


In NopCommerece Database this is possible or not


                      


                        
Dipesh Jade (India)

Percentage discount is not possible.

Hello sir

i was just mantion 2% ,5 % but it is consider as interger i will calculate percentages by coding but my question is

===> I wan't to give discount on each product atributes variant values so the NopCommerce Database structure   support  this type of requirement..

i was added new entity in NopModel.edmx file and make the entity set and business loginc class for the perticular entiry but i was face some proble in NopObjectContext.cs file and some association relationship was not loaded ...

Just give me the aswer it is possible in NopCommerce or Not.

Sorry, this doesn't make a lot of sense.

nopCommerce team | retroviz wrote:


Question : Just Follow the Followint table in DB

(1) Nop_ProductAttribute : eg take one attributre Name = Color

(2) Nop_ProductVariantAttributeValue : eg we can set Color ---  (1) Red
                                                                                            (2) Blue
                                                                                            (3) Green
I wont to give discount on each ProductVariantAttributes values i.e

Color-------> Red = 2 % (strore only 2 in DB) discount
Color-------> Blue = 5 % (strore only 5 in DB) discount
Color-------> Red = 3.5 % (strore only 3.5 in DB) discount

for that i was created on New  table  TestTable

colum                                             datatype
Product_AttributeWise_DiscountID    int           Unchecked
ProductVariantAttributeValueID            int           Checked
ProductVariantAttributeID                    int           Checked
Discount                                            float   Checked
Quantity                                            int            Checked

Problem : i was add this class in NonModel.edmx file but ater adding this file errror come with Primary key and forign key .

This is possible in NopCommerce

Dipesh Jade (India)