close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

adding product options

Thread began 8/08/2011 11:52 am by sjuno299871 | Last modified 8/09/2011 11:46 am by Jason Byrnes | 1253 views | 12 replies |

sjuno299871

adding product options

Does this work with static pages meaning I have to recreate the cart behaviors to all 9 product pages....correct

Sign in to reply to this post

sjuno299871

I also just noticed that

when adding produt options ie rsColor the part I pasted into the sql has optiongroupID ='color' I fill out the rest and the new one shown shows optiongroupID =1 mine does not show that..
it shows
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID

what did I do wrong.....

Sign in to reply to this post

Jason ByrnesWebAssist

since your product pages are static, you need to add a where clause to tell it what product to return the options for:

SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID WHERE productoptions.ProductOptionID = '1'

Sign in to reply to this post

sjuno299871

So where in these tutorials would I have found that out ?

and for the primere ticket. what would I do so I am prepared to do this in the least amount of time I am hoping if you can help me set up one out of the nine pages and then I could do the other 8 myself

What would you need for me to set up to be able to be guided through it all, would I need to star over?
one item looks like this....
1. Choose a size and add $2.00 to to the cart for each size bigger then XL ie 2XL +$2.00 3XL +4
2. Choose a color
3. Choose a charter (55 of them)
and then send it to the cart and checkout and ship using sandbox to test?
Then I should be able to just duplicate the other 8 pages? I cannot afford the $99 but I need to see how this is done!
If so what is the earliest time slot we could attempt this?

Sign in to reply to this post

sjuno299871

Tried the above sql and

it errored it out sql error ????

Sign in to reply to this post

sjuno299871

This is the error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE optiongroups.OptionGroupName = 'color' AND productoptions.ProductID = -1' at line 1

Sign in to reply to this post

Jason ByrnesWebAssist

the SQL i posted in my reply does not have anything to do with optiongroups.OptionGroupName = 'color' in it.

i tested the sql from my reply:
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID WHERE productoptions.ProductOptionID = '1'

and did not get any errors.

you will not need to start over. using what you have now, we will look at what you have done sop far, to see where the problems are, and how to correct them.

if you contact the sales department, they will be able to give you a time frame for when the next available appointment is.

Sign in to reply to this post

sjuno299871

You wrote

since your product pages are static, you need to add a where clause to tell it what product to return the options for:

SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID WHERE productoptions.ProductOptionID = '1'
Today 04:04 PM

Where does this stament go? I was building the product options for rsColor you told me I needed the above sql statement where does it go?

Sign in to reply to this post

sjuno299871

need help on knowing where the sql

statement you sent me goes....

Sign in to reply to this post

sjuno299871

Any answer

Trying to get this at least workable by noon....

Sign in to reply to this post
loading

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