Need e-commerce database structure

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
posurreal
Forum Newbie
Posts: 7
Joined: Fri Oct 29, 2004 3:22 pm

Need e-commerce database structure

Post 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?
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Post 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]
posurreal
Forum Newbie
Posts: 7
Joined: Fri Oct 29, 2004 3:22 pm

1 Month Into Work

Post 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. :)
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Post 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.
posurreal
Forum Newbie
Posts: 7
Joined: Fri Oct 29, 2004 3:22 pm

I'll Do That

Post 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
Post Reply