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

Custom checkout form info not flowing into order table

Thread began 3/21/2012 1:19 pm by dDog | Last modified 3/21/2012 4:55 pm by Jason Byrnes | 1311 views | 6 replies |

dDog

Custom checkout form info not flowing into order table

Hello,

We are trying to add unique form data from our checkout page to our success and email pages (UE), and store in the database (orders table). For some reason, the info does not show on the success page and email, and new orders do not store the unique data.

We created unique columns in the orders table to capture this unique data. On the confirm.php page, I have modified the "Store Cart Summary in Database" to bind the unique values to the new columns in the orders table.

I added "form data" from checkout.php page to the bindings panel and selected it for the new column value when storing the cart summary - but when I create a new order that field remains blank.

I followed the solution recipe for "ecart coupons" to set session values for the new fields (on checkout.php) that will carry to checkout_success.php and populate the email sent by UE. I changed the binding in "store cart summary in database" to the new session value, but when I generate a new order, the unique field still remains empty in the order table. Strange!

It seems like flowing this data on the pages and recording in the database should be simple, but there's something I'm missing.

Thank you in advance!!!

Sign in to reply to this post

toms016390756

+1 for learning




Sign in to reply to this post

Jason ByrnesWebAssist

for every form element that you add to the checkout page, you will need to add 2 things to the confirm page:

1) the confimr page has a collection of hidden form elements to capture the values posted from the checkout page, you need to add a new hidden form element with the same name as the one from the checkout page

2) Each form element has a corespondin set session value behavior on the confirm page.
on the sever behaviors panel, click the plus button and select eCart -> General -> Set Session Value.

see this thread for details:
showthread.php?t=22392

Sign in to reply to this post

dDog

Makes sense

Thank you, i read the attached thread and it explains it well.

If you don't mind I would like to lay out the steps to make this work:



1. Note the exact name of the added field names on checkout.php

2. Create session values for each new field:

(Server Behaviors -> "+" -> eCart -> General -> Set Session Value)

* Trigger: "Any Form Post"
* Session Name: "eCartCheckoutForm_[field name]"
* Value: "lightning bolt" -> "ecart_checkout_form (checkout.php)" -> [field name]

3. Hidden Dynamic Text Field at the bottom of confirm.php (with the others) for each new field:

* Name: [field name]
* Value: "lightning bolt" -> "eCartCheckoutForm_[field name]"

(I already added appropriate columns to the orders table via phpmyadmin)

4. Modify Store Summary in Database:

(Server Behaviors -> "eCart Store Summary in Database")

* Select Column to fill with correct data -> "lightning bolt" -> "eCartCheckoutForm_[field name]"


Am I missing any steps?

Sign in to reply to this post

Jason ByrnesWebAssist

that looks correct, one thing to note is that the hidden element and set session behaviors are added to the confirm page, not the checkout page.

Sign in to reply to this post

dDog

Success!!!

It worked! Excellent!

Yes, I should have mentioned step two on confirm.php (not checkout.php).

Thank you for your prompt attention and help.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

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