close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Information on recordsets + ATC Function for items with size options that affect pric

Thread began 1/20/2010 4:28 pm by JLK | Last modified 1/28/2010 8:07 pm by JLK | 2275 views | 12 replies

Eric Mittman

The guide for the product options is not yet available, it is still in the works. I think that there is a bit going on in this post and it will be difficult to address all of these things in a single response. I think it would be best to concentrate on one part of this, like adding the items with multiple options into the cart first.

Once we get that down we can look into the design or other add to cart scenarios. So rite now you have items that can have two type of options. In your example you mentioned an item that had size and color. So the first thing to do is determine how you would like to make the options available. If all of the items have the same options available this would be easiest. If only certain options go with certain items then you may need an additional table or tables in your db to hold the relationship between the options and products.

Either way you go the key to having the items add to the cart correctly is creating the recordsets for all of the info you would need. For example, if you have a simple scenario where the user can select the size and color of an option you could have recordsets on the page for just the sizes and colors. You could then bind the recordsets to select lists to have the user select the options they would like. Then when you add the item to the cart you would use bindings from these select lists or you would filter recordsets on the selected values to get back more details like the price for the option.

So the next question is how are the prices for the items determined, do the options figure into the price? If so are you storing the price or additional cost of an option currently in your options tables? You will need to make this determination and have this part worked out before you will be able to start crafting your add to cart pages. Please post back with the details for how you would like this to work from the perspective of the user and how the prices are figured. I will use your info to help you come up with a strategy to implement this.

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





Ease of use


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...