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

Options in menu works for only one product

Thread began 8/09/2010 10:21 pm by wilyumcj205276 | Last modified 8/13/2010 4:45 pm by Eric Mittman | 648 views | 4 replies |

wilyumcj205276

Options in menu works for only one product

This is a continuation of a thread/ticket I opened 1 year ago that was closed,
but never resolved. I never closed the ticket, and the last post to the thread was in response to a question. Also one ticket in my account was mistakenly sent to me. Can u delete that ticket from my history?
Problem: I can only get the size list/menu to work for the first product
in my database.

With the DataAssist product detail page,
the menu displays all 4 size options and successfully passes price
to the shopping cart. However, the description in the cart is always
for the smallest size.

On the product detail page that I created (not using DataAssist)
everything is the same as above, but the price for each size increment
is not being passed to the cart, and the price is always
for the smallest size.

Here is the .sql zip file for my database set up,
and the zip file for my product detail page(not done with dataAssist.

How do I get options to display for all products and passed to the cart along with cart description? Thanks
William

Attached Files
detail.php.zip
money.sql.zip
Sign in to reply to this post

Eric Mittman

When I test out your page with your data I can see that whatever ID is in the URL is the item that will be selected and added to the cart. For the price of the item you are just binding to the price from the recordset, $row_rsDetail['ProductPrice']. I can see that you are adding a size and sizePrice from different recordsets. It seems that you must be adding the additional price with a calculation of some type. I do not have your cart files though so I do not have the calculation that you are using to add the sizePrice to the price.

When I test it out like it is currently I can see the item change with the id, then when I add the item to the cart the item is added according to the id specified. I tried this with three different items and was able to get them to all show in the cart without issue.

I also noticed that out of the items I tested, 1, 2, and 20 only 2 had size selections available for it.

Sign in to reply to this post

wilyumcj205276

Eric, I used the Product Option tutorial and substituted run-time values with my recordset. I only used the size option. I created the rsSize and rsLookup recordsets and I used the SQL script provided for each.

I realize that only one product (Threegether, the second one) gives me all size options in the list menu. I need to know why the rest won't. The list menu will only pass one price into the cart when there are 4 sizePriceInc 0,50,100,150 base price of $49. 9x9=$49, 16x16=$99, 24x24=$149 and 36x36=$199 The "calculations of some type" are from the Product option tutorial.

Question: How do I set up a product_detail page to display a product such as a T-Shirt with an options list/menu, and also show 3 or 4 other products with image thumbs that could go with the T-Shirt such as shorts and pants? When this additional product thumbs are clicked, they would link to product detail page. I don't know how to display thumbnails/productID's from 2 or more recordsets on the same page.


I'm so curious as to why tutorials for such fundamental functionality necessary fro ALL ecommrce sites, are not front and center, in complete detail for each type of database (asp, cold, mysql)

I've included zip files for the complete site and database sql

Attached Files
cart.php.zip
detail.php.zip
index.php.zip
money.sql.zip
Sign in to reply to this post

Eric Mittman

I have opened a ticket for you on this issue so that we can look into this further. To update the ticket login and visit your support history.

supporthistory.php

Sign in to reply to this post

Eric Mittman

We were able to get the page working. There was not one single issue, most of the recordset code and the way the detail page was setup needed to be redone. Once the recordsets were properly crafted to get the correct values and the form was submitting the correct values it seemed to work as it should.

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