Re: Shop online

Schraalhans Keukenmeester wrote:
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.
Hi
I resolve my problem on my own about the properties of the product

about the size of the project yes i agree with you is way to big but
is not the good way to learn that ?
no one born with the knowledge and we learn to walk drooping on the floor,i want to be realistic with myself so for this before write anything i want to lay down all the project
i want to be optimistic not an idiot
.

Relevant Pages

  • Re: Shop online
    ... I want to build a shop from scratch, ... how can i structure the database to be able to add unlimited properties ... like if i sell a t-shirt i will hate to chose size and colour ... You'd first have to construct your data model, normalize it to get to a ...
    (comp.lang.php)
  • Re: Shop online
    ... 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 ... like if i sell a t-shirt i will hate to chose size and colour ...
    (comp.lang.php)
  • Shop online
    ... i'm laying down all the possible problem i can find during the way. ... like if i sell a t-shirt i will hate to chose size and 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. ...
    (comp.lang.php)
  • how do I create a stock control database
    ... sIm running a small shop and I need to have database of all stocks ... sell an item, it reduces in the stocks. ... how do I make the stock database reduce as I make sales. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: "Anti-Potter mothers appeal considered"
    ... "A UK toy shop chain is refusing to sell Harry Potter merchandise over ... And this one is about a ban in a religious school. ...
    (alt.fan.harry-potter)