If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Product Based database

Im trying to design a database for a eCommerce style website that isnt interested in selling online yet. Its a flooring business with lots of different categories and iv tried to make it a few different ways but there are so many different things associated with each item i cant get a solid design down.
I intend for the database to handle a product search on the website.

The rest will be similar to the above but with slight differences and i would like to be able to add eCommerce support relatively easily in the future unless its more efficient to build it with the ability for eCommerce now.

A couple of Data MOdels that will help you ...

Hi

>>>The rest will be similar to the above but with slight differences and i would like to be able to add eCommerce support relatively easily in the future unless its more efficient to build it with the ability for eCommerce now.

having a template helps a lot. It gives me a solid base to start with although it shows me how little i really know about it.

Looking at the complex Model Complex Product Catalogs Data Model im not sure how i could fit the products into it and get the right output because of the different columns i need. Would i need to have a unique products table for each parent product (laminate, carpet, hardwood, ect..)?