Inserting Products into wa_ecommerce_db

[johna1964]

I have a few products with color options, but I need to be able to display them as individual items and also a separate page with color menu option. Do I create each item in the products table and again in the product options table, with each color selection?

Of course creating the product options column in eCart, but what is the preferred method for inventory control: same product displayed with menu list differently on separate pages?

Products with differenct colors have different sku's

I hope this question makes sense.

johna1964

[Jason Byrnes]

to have the items with different color choices display in the cart on a unique line, set the color cart column to be unique.


For inventory control, you will need to add another column to the product options table to set the inventory for that particular color and product combination. You will still use the product page with a color dropdown list on it as the product detail page