Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Adding more product options

View all replies to this thread

Adding more product options

Thread began 4/12/2012 4:58 pm by phil107723 | Last modified 4/16/2012 9:07 am by phil107723 | 892 views | 3 replies

4/12/2012 4:58 pmphil107723

Adding more product options

Hi
I'm wanting to add more product options to my existing ecommerce website. I have worked my way through this tutorial product_options.php which is great and the your free database download very helpful . But I'm stuck on what kind of information to put in certain tables.

I have an item for sale at $200 at size 350mm the options are size 400mm for an extra $50, size 450mm for an extra $75 and another 2 sizes.
I have read this:
ecommerce-database/
but it didn't help.
So a product called Muffler1, code ADR001, that has the price $200 options 400mm for extra $50, 450mm for extra $75 what information would I enter into the tables on the database.

Table: optiongroups -OptionGroupID, OptionGroupName
Table: option - OptionID, OptionGroupID, OptionName
Table: productptions - ProductOptionID, ProductID, OptionID, OptionGroupID, OptionPriceIncrement
Table: productcategory - CategoryID, CategoryName

Have I said I think you're wonderful.
Thanks
Phil

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.