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