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

Product Option presents (PowerStore v2)

Thread began 2/18/2010 9:45 am by cj.tung395641 | Last modified 2/25/2010 5:24 pm by Dani Chankhour | 680 views | 3 replies |

cj.tung395641

Product Option presents (PowerStore v2)

Hello,
I would like to present available option combinations only.
For example,
Colour: Red, White, Black
Size: S, M, B

the available option combination I set to
Red available for size M and B

but when visitor choose Red, options will show all S M B, therefore I would like to know how to fix the code to just show M and B when visitor choose Red.

Thank you.

Sign in to reply to this post

Dani Chankhour

On your Product Detail page change line 429 to be this code:

$query_OptionValues = sprintf("SELECT options.OptionName, productoptions.ProductID, products.ProductLive FROM options INNER JOIN productoptions ON productoptions.OptionID = options.OptionID INNER JOIN products ON products.ProductID = productoptions.ProductID WHERE OptionGroupID = ".$row_ProductOptions['OptionGroupID']." AND GroupingID = (SELECT GroupingID FROM productoptions WHERE productoptions.ProductID = ".$PIDParam_ProductOptions." LIMIT 1) ".$AddToWhere. " AND products.ProductUnlimited <> 0 ORDER BY options.OptionID", GetSQLValueString($OGIDParam_OptionValues, "int"));

Sign in to reply to this post

cj.tung395641

Hi Dani,
Thank you again for your reply!
I have changed Product Detail page to the code you provided. However, the option still not present the way I need but only shows no choice for each option. I set the first value of each option to "---" (meas please select), and inventory is 0. Somehow this value effect on how it present.
Products_Detail.php?ProductID=38

Furthermore, I changed the last line of your code to "And products.ProductLive" and it still not showing the available options combination products.

Thank you.

Sign in to reply to this post

Dani Chankhour

Sorry for not responding sooner, but after some more testing, it seems that what you are trying to accomplish can't be done in PowerStore v2, because PowerStore depends on a default product, and if that default product is not presented, then all other options won't show as well.

I will try to see if there is another way to do this, but as of now i can't see how we could get the result you are looking for.

Sign in to reply to this post

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