Our products have both size and color under the same SKU. Here is my example.

I would like to verify how the shopping cart handles the sale of 1 Large Blue Example Product.

Realize that the Product Variant QtyOnHand field is in four records to start: (Blue, 7), (Red, 9), (Small, 5) and (Large, 11)

After the sale, the table looks like this or not?

With a change to two of the variant records.... (Blue, 6) and (Large, 10)?

Is this how multiple variants on one product works?

Regards,

Guy

We did not understand why there would be a Quantity On Hand field in the Product Variant record at first until we worked out this example. If you did decrement 1 from each variant record selected in the variant group (Blue and Large in Color and Size) then everything works out. Look at the quantity total in the lower right corner of the table. It went from 16 to 15.

Obviously, there is an assumption that all products have a color and a size (in other words the totals of variant quantities within each group must be the same, ie., match the number of products). In our case this is absolutely true.

There is no need for another table to track blue and large quantity. This database design is correct. It will handle even N-variant groups properly. Can we decrement the QtyOnHand ourselves after a sale if you are not doing so already?

I used the table to clear things up for us and yes, the numbers on the inside four cells are intersections and not in the database.

The important thing is that your table Smith_ProductVariant records quantities in their respective groups accurately... as long as a decrement occurs in each group for each sale.

You say that no such decrement occurs in the ProductVariant records now. I'd like to set that up because it makes sense and will allow us to accurately report the quantities in each variant.