Hi, im new to the site and hoping someone can help.
I am looking at setting up a site to sell shoes online and I am building the website myself.
All payment stuff etc is all going to be handled by paypal or similar but looking to set a database behind the site to store details about the products and track stock levels etc but I am struggling to put together a schema for the database that I think will work.
I think the main issue I am having is deciding how to handle the fact that a certain product (shoe) can have multiple sizes as well as being either an adults or a kids product.
My experience in this kind of thing is so so - I have put together database driven sites before but I am by no means an expert.
Hoping someone can just give me a pointer on what would be a good way of setting this up in terms of tables etc.
Probably doesnt really matter as like I say its the ideal DB design im after at the moment but for the record I will be using PHP and MySQL.