Displaying 1 result from an estimated 1 matches for "products_sizes".
2005 Oct 05
3
Shopping Cart: SKU and Product Confusion
...cific to the combination each product
offers. So, the related DB tables were essentially this:
Table Products:
===========
id | sku | title | price | etc...
Table Colors:
=========
id | color
Table Sizes:
=========
id | sizes
Table Colors_Products:
=================
color_id | product_id
Table Products_Sizes:
================
product_id | size_id
Everything was fine and dandy until I got to the point where I wanted each
combination of a product to appear as a separate line item in the shopping
cart (the natural way to display items). There was no way for me to
determine the uniqueness of a product, si...