Easy_Coder - 11:27 am on Apr 11, 2006 (gmt 0)

let the client manage the inventory so they would need to decide to list availability on a particular size or not... to do that you need to let them manage product attributes (size & color) by item. This is not that difficult with clothing as it is with something multi-dimensional like footwear.

If it's clothing you need to have a master colors table and you'll also need a item attributes table to manage colors by item

skuxyz comes in red and green:
colors
1 Red
2 Blue
3 Green

colorattributes
skuxyx 1
skuxyz 3

Same thing for sizes:
sizes
1 small
2 medium
3 large

sizeattributes
skuabc 1
skuabc 2