DB Structure for a company store web site

[Curnzy]

I am currently developing a web site for a company store. They lady Im developing the site for wants to be able to update the site herself and weekly special offers, so I need to develop a database that stores all the different products, prices, sizes, colours, styles etc. There are a large amount of products and I'm not sure what fields I should use in what tables. Please, if anybody has a few ideas or knows how small e-commerce sites set up their dbs, let me know.
Thanks,
Curnzy

 

[wushutwist]

This really isn't enough information to even begin with. First thoughts are twofold:
1) This has already been done a thousand times and you could probably find a prebuilt "shopping cart" product to fit your needs.
2) If you really want to sit down and design this thing that I would assume (knowing 0 information about the data) that you would have one PRODUCTS table with a PRODUCT_ID, NAME, SHORT_DESCRIPTION, LONG_DESCRIPTION, QUANTITY, PRICE, etc. Then you would probably have a CUSTOMER table, a PRODUCT_SPECIALS table. The list could go on forever. Wushutwist