Page 1 of 1
Need e-commerce database structure
Posted: Fri Oct 29, 2004 3:24 pm
by posurreal
Working on MySql database for e-commerce site. Need products to be applied to multiple categories. 4 or 5 tiers of categories. Different colors, sizes. Do you have the structure for a common e-commerce site already?
Posted: Fri Oct 29, 2004 4:09 pm
by Draco_03
posurreal
It's nice and all to ask for help but you should
1- search google by yourself
2- Search some more
3- Then post ask what you need with what step you
already took yourself. And be CLEAR!
Because right now it seems that you want to do 0% work (wich usually looks bad)
Okay then now e-commerce structure ?
You mean you need the shooping cart?
A merchant account ?
a gateway payment access ?
A cheesburger ?
all of the above ?
look into
this link for free php shopping cart
or just type it in google and browse around[/url]
1 Month Into Work
Posted: Fri Oct 29, 2004 4:20 pm
by posurreal
Ah... Actually, I have spent the past month creating a database. However, when I showed it to a php programmer with 6 years experience (over my 1 year), he noticed some fundamental errors with how I was handling table structure, thus causing a slower processing time. It occured to me that someone may have an e-commerce structure that I can model after instead of me recreating the wheel.
Then, I can customize it to my client's needs, which is why I cannot use Miva Merchant or similar turnkey solutions.
I have spent the past 8hours searching for tutorials on the matter. A guy named Rick Curtis from Princeton.edu had a two-part series on e-commerce database design. However, it did not show how to handle the "Available Size" and "Available Colors" vs. the "Size ID" and "Color ID". I didn't understand the difference to know how I could code most efficiently for products with multiple sizes, colors, prices (based upon who is viewing) and under multiple categories.
Thanks for replying. You are the first one out of 8 forums I posted to.

Posted: Fri Oct 29, 2004 5:07 pm
by Draco_03
I'm sorry from your first message i didn't understand it was Database structure.
Then that's different i'm leaving right now but, I could give you an advice
Take an actual shopping cart and look at the database it create, That should get you started.
I'll Do That
Posted: Fri Oct 29, 2004 5:22 pm
by posurreal
Thanks for the quickie advice. I accessed the client's site and noticed they used Miva Merchant, hoping I could look a that database, but, even working with tech support at the Web hosting company, we could not find it.
I will try downloading a cart and finding it that way.
Thanks
M