I would agree that is the best way to handle the products with options, it's extremely flexible. Just for the record, doing it this way requires some thought be put into how to do sorting of options. Can't have large above small in the list...
What about categories/subcategories though? I'm using a table something like this. However I'm always ears for a better way. category id, categoryName, parentid productCategory id, sku, categoryID -- jon mailto:[EMAIL PROTECTED] Wednesday, August 21, 2002, 3:54:27 PM, you wrote: PG> There are a great many books ... PG> I would layout a product table that has the basics for all the products PG> productTable PG> productId, Title, image, sku, price PG> optionTable PG> optionId, optionTitle PG> optionValues PG> optionValueId, optionId, optionValue, additionalPrice PG> That is just for your product and options ... not departments and such. PG> Basically you have a table for your products, a table for your options, and PG> a table for your option values. PG> Hope this helps PG> Paul Giesehagen PG> QuillDesign >> Quick question. Are there any books or articles out there that describe >> best practices for laying out product in a database? >> >> Say you have product like a t-shirt. You could layout a relational >> database like this, but is this the best method? Should sizes, and >> colors have their own table? >> >> Category >> T-shirts >> >> SubCategory >> Long Sleeve T-Shirts >> Short Sleeve T-Shirts >> >> Product >> Sears T-Shirt >> Lands End T-Shirt >> >> ProductOptions >> Blue Lands End T-Shirt L >> Blue Lands End T-Shirt XL >> Green Lands End T-Shirt XL >> >> I suppose this is a pretty tough question that may not have a cut and >> dry answer seeing how all product seem to have all kinds of different >> options and structure.... >> >> PG> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
