Posted by Schraalhans Keukenmeester on 02/15/07 16:46

Daniele wrote:
> Hi
> I want to build a shop from scratch,
> i'm laying down all the possible problem i can find during the way.
> how can i structure the database to be able to add unlimited properties
> or attribute to different kind of product ?
> like if i sell a t-shirt i will hate to chose size and colour
> if i sell a plate probable the model and the colour
> i'm looking into other open source shop like oscommerce and the
> structure of the database is really to big for my knowledge so i cant
> really understand it.
> i now that i neet to divide all in table as much i can but how?
> thanks
> D

You'd first have to construct your data model, normalize it to get to a
working and practical database setup. Honestly, judgeing from the way
your question is formulated, you are way over your head here.

I could give you an ad hoc answer for the exact examples you mention but
I am afraid it would not be a serious step towards solving the bigger
problem here.

If I'm wrong, and you are in fact comfortable with the challenge ahead,
then it's silly not to 'steal with pride' from existing
scripts/packages. There's literally hundreds if not thousands of
solutions out there, varying from incredibly simple and feature limited
to full fledged high-tech online shopping systems including credit-card
processing features, advanced logistics modules and what have you.

Not the answer you hoped for I guess, but perhaps the one you knew was
coming?

Regards,
Sh.

[Back to original message]