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

checkout page send as email attachment?

Thread began 7/07/2015 4:11 pm by John | Last modified 7/13/2015 2:16 pm by Ray Borduin | 969 views | 12 replies |

John

checkout page send as email attachment?

When pressing the "Continue" button to normally proceed to authorize.net, the merchant now wants the filled in billing/shipping and shopping cart information to be sent to him by email, and since the data seems to be cookie driven, is there a way to send all the page information in an email or perhaps as a PDF capture of the page as an attachment sent?

Sign in to reply to this post

Ray BorduinWebAssist

Are you looking to stop using authorize.net and only send the email?

That could be as easy as updating the form action to go to the success page and then applying the "send email message" server behavior on the success page.

Sign in to reply to this post

John

That is correct, only send the email of the billing/shipping & shopping cart information to the merchant salesperson.

Sign in to reply to this post

Ray BorduinWebAssist

You could run the wizard again and just choose "none" for the payment gateway.

Or you could use the existing pages and change the confirm form action to submit directly to the success page and then apply "send email message" to the success page.

Sign in to reply to this post

John

So to make sure I understand correctly, in the confirm.php page, I just change the action from
https://secure.authorize.net/gateway/transact.dll
to
checkout_success.php

I'm guessing I'll need to add something else since I'm getting the following message upon doing so:
Field 'OrderUserID' doesn't have a default value

Sign in to reply to this post

John

In further trying to troubleshoot the 'OrderUserID' not having a default value, I am guessing this is referring to a mySql table which I appear to not be using but rather as a cookie somewhere since I couldn't find 'OrderUserID' anywhere in my code. Anything further I need to tweak?

Sign in to reply to this post

John

update 2, I set fields such as OrderUserID & OrderFax in the thought to be unused Orders table but then got the following message:

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 'KG,'Ammonium Nitrate',118.2,1)' at line 1

The line item in order summary shows as:

Item Price Quantity Total
A1110-2.5KG Ammonium Nitrate 6484-52-2 $118.20 1 $118.20

Sign in to reply to this post

Ray BorduinWebAssist

Please attach a copy of the confirm page and success page to a reply and I'll take a look.

Sign in to reply to this post

John

attached as requested.

Sign in to reply to this post

Ray BorduinWebAssist

Do you want to store the order information in the database as well? If not you can just remove the "Store cart summary" and "Store cart details" server behaviors on the success page.

The error appears to be because you are using text values as the ProductID and the insert details server behavior has the ProductID field defined in the database and server behavior as numeric. You could probably fix it by updating the column type in the orderdetails table for the ProductID to be varchar(50) and then update the store cart summary in database server behavior to specify that field as a text data type on the php page as well.

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