Many thanks Ray! That's not far off what I have now. I'm wondering though whether AddPrice should go in the PRODUCTOPTIONS table, as it will depend on the product and the size. Many products will have small, med, large sizes but their price will be different depending on the item.
How would you handle accessories? I'm thinking I could add them to the PRODUCTS table but add an accessory field (1/0) to separate standalone products and accessories. Or would you put them in their own table? It would be very similar to the PRODUCTS table which is why I'm wondering if they should just go in there. However we don't want them showing up as products, only on their "parent" product page under the Accessories tab. E.g.:
Thanks again - great info.