View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Planning a Database for E-Cart / E-Commerce

Thread began 5/21/2009 6:50 pm by vela1606379889 | Last modified 6/29/2009 1:51 pm by vela1606379889 | 2284 views | 6 replies

Stan

Ok, I did it over the weekend. The product inventory table is the central table with relationships to the options. So if you think of it like shirts (I'm not at liberty to say what the product is.) I have like 10 different shirt styles which are in essence options, and there are 15 different sizes, which again are options. There are many more options which may eventually be added but at present this is all. The inventory table is sparse, in that it doesn't have a record for anything not in stock. So if the record returns empty then the product can't be ordered. The weight is mostly related to size but there are some variations based on the shirt so the shipping weight is contained in the inventory table as well as the SKU and price all of which can then be unique. It actually wasn't that bad. I still have the flexibility selections list for options because the options are now just straight forward tables with one row for each option. The inventory table just has keys to the options. The inventory table has a quantity on hand which gets debited with purchases.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...