Database design for ecommerce site

Hi Guys,

I am looking to design an ecommerce site with categorised products.
Once built, I want my client to be able to add additional categories and be abel to add their products into their chosen category.

Would I be best displaying this dynamnically after creating a table with the products category names in it or doing it static?

Also, if I wanted to show a different header / meta tags for weach category how would I best tie this in?

I have designed a few ecommerce sites in the past but have done it the hard way, creating each individual category page!

Any advice would be GREATLY appreciated