In my store I'm using the products table as basic products and I've created a separate table for SKU option variations.
The administrator adds options then adds SKUs that are for all the options variations. The productsku table is set up like so.
skuID, skuProductID, skuNumber, skuColor, skuSize, skuUDO1, skuUDO2, skuUDO3, skuAvailable (skuUDO1-3 can be defined by the administrator)
Each SKU is defined by it's options variable. So the patron might choose Large Cappuccino or Small Blue each would have it's own SKU number.
My problem is: I want when the patron chooses products options that it will look at the productssku table and see which SKU has the options selected (skuProductID, skuColor & skuSize) it will look at the productsku table and determine which table matches that combination and then it needs to see if the skuAvailable is set to "No" or "Yes". If yes then it goes to the shopping cart page but, If "No" it goes to this error message:
Any help is appreciated. Thanks.