about product variants

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
Able-fans
Ensign (ENS)
Ensign (ENS)
Posts: 11
Joined: Mon Sep 03, 2012 8:45 pm

about product variants

Post by Able-fans » Tue Sep 18, 2012 12:40 am

Imported a load of product variants into Able Gold. Everything look alright exception into product page click the "Choose color" dropdown. It returns all colors in ac_optionChoices instead of colors in ac_productVariants. For instance:

There is prodcut which has black and white colors. ac_productVariants like this

product ID option1
1 20
1 21

there are five colors in system for all products. ac_optionchoice like this

optionchoiceId name
20 black
21 white
22 gold
23 green
24 yellow

in product page the dropdown lists all five options but the two belongs to the particular product. In practice there more than 300 colors in my system. It's not nice to list all hundreds colors with only two colors relevant for the product.

Post Reply