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

rating

Trouble with sizePriceInc in Product Options

Thread began 5/20/2012 10:05 pm by graham | Last modified 10/23/2013 12:06 pm by Jason Byrnes | 2731 views | 14 replies |

graham

Trouble with sizePriceInc in Product Options

Since purchasing eCart 5, I have found the forum support to be invaluable ... I have spent more than a couple of hours referencing issues, always finding a solution. Thank you for addressing all concerns in such a professional manner.

My issue - I have followed your eCart tutorials carefully, but cannot realize any sizePriceInc on my cart page. My details page creates an accurate select list from the options in my database, but only the base price registers with the "Add to Cart".

I put off submitting this, hoping to solve it myself, but I am stumped.

I have zipped my details and cart pages ... would appreciate some feedback.

Thanks in advance.

Attached Files
cart.zip
detailspage.zip
Sign in to reply to this post

Jason ByrnesWebAssist

please send a link where i can see your cart on the web and a copy of the WA_eCart/eCartPurpleEssentials_PHP.php page so I can see how the cart is configured.

Sign in to reply to this post

graham

uploading one now ... thanks for the quick response. I will email the link shortly.

Sign in to reply to this post

graham

MassageProductsMainPage.php

this is my test products/details/cart setup

I have attached the eCart setup as well

thanks for the quick reply, Jason

Attached Files
eCartPurpleEssentials_PHP.zip
Sign in to reply to this post

Jason ByrnesWebAssist

ok, I see the problem, there are 2 issues causing this to not work:

1) The size select list is not part of the add to cart form.

it is outside of the add to cart form tags, so not included as part of the form post when the add to cart button is pressed.


2) in the add to cart form, the element that passes the item ID is named eCartPurpleEssentials_1_ID_Add:

php:
<input type="hidden" name="eCartPurpleEssentials_1_ID_Add" value="<?php echo $row_DetailRS1["ProductID"]; ?>" >



in the Lookup recordset, you have set the run time value of the paramItem variable to a form element named eCart1_1_ID_Add:

php:
$_POST['eCart1_1_ID_Add']



the run time value should be changed to:

php:
$_POST['eCartPurpleEssentials_1_ID_Add']
Sign in to reply to this post

graham

Thanks for the quick analysis, Jason. I will give it a go.

Browsing the extensive WA forum boards, seeing the number of customers you interact with (newb and experienced), it must be said that you do an amazing job! It's nice for someone with limited experience, like me, to not be made to feel that their question(s) are silly or amateurish ... we all start somewhere!!

One more thing, if you have time to consider a solution ... direct me as to how I might tie the select size menu to the displayed product price on the details page. I have the base price listed, but would like it to change if a size option is selected.

Regards

Sign in to reply to this post

Jason ByrnesWebAssist

updating the price on change of the select list would require a custom ajax function to querythe database, then chage the price.

an easier way would be to add the increment to the select list, for example:

change:

php:
<option value="<?php echo $row_rsSize['ProductOptionID']?>"><?php echo $row_rsSize['OptionName']?></option>



to:

php:
<option value="<?php echo $row_rsSize['ProductOptionID']?>"><?php echo $row_rsSize['OptionName']?><?php if($row_rsSize['OptionPriceIncrement'] > 0) echo(" + ".$row_rsSize['OptionPriceIncrement']); ?></option>
Sign in to reply to this post

graham

... continued thanks.

Keep up the good work!

Sign in to reply to this post

graham

Updated product price on details page would be best

On my website, product options and price increments, are listed as suggested above. The select list indicates any additional price increment applicable, and it transfers to cart accurately. However, I would like the displayed product price to be updated on my details page after the select. This would require a custom ajax function. As I am near the completion of the website, and looking to move on to marketing, etc., I have less time to complete this task myself; I would like to have this small bit of code written for me. Would purchasing a ticket allow you to help me with the code to query my database and update product price based on selected product option? Thanks, guys.

Sign in to reply to this post

Jason ByrnesWebAssist

Yes, we could help you add this in a Premiere support appointment.

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