close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Order info not sent to merchant after PayPal payment

Thread began 9/05/2017 1:46 pm by jlowery | Last modified 9/05/2017 9:07 pm by Ray Borduin | 67 views | 7 replies |

jlowery

Order info not sent to merchant after PayPal payment

My client is getting a partial email after PayPal processes the order. She's getting the subtotal, shipping and total figures as well as the billing info, but the order details are not included. I've tried to locate the email doc that's sent to bind in additional details, but can't figure out which it is. What file should I look for and how do I proceed?

Okay, I think I found it in the webassist/email folder. I have muirhead_receipt.php but also muirhead_receipt 2.php and muirhead_receipt2.php, all with the same date. How do I tell which one is being used?

I've attached muirhead_receipt2.php which I think is the most likely.

And another issue... I just noticed that while it is including my "West of Mississippi" added charge in the total, it's not breaking it out on the cart. I can see where I would add that PHP statement on the checkout page, below Shipping and before Tax, but not sure of the syntax. Here's the rule from the eCart page (muirhead_PHP.php):

//eCart Rule
function WAEC_muirhead_WestoftheMississippi() {
$totalShipping = 0;
if (true && (((isset($_SESSION['toTheWest'])?$_SESSION['toTheWest']:"") == "1"))) {
$totalShipping += floatVal("3.50");//Result
}
return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);
}
//eCart Rule



Thanks - Joe

Sign in to reply to this post

Ray BorduinWebAssist

It looks like it would work to me. You are getting the information from the database and not from the cart directly. So it would only work if the information was saved correctly in the database before the email was generated... maybe it is in the wrong order on the confirm page and the order details haven't been stored when the email is sent?

Also since it is in the database, it probably doesn't know which shipping rule was used and it only stores the shipping total in the database. If you want to include all of that then it might make sense to get the information from the cart instead of the database when you send the email. The advantage of the email you have from the database is that it could also be used to re-send the receipt at any time from the admin back end. That of course wouldn't work if the email was built directly from the cart.

Sign in to reply to this post

jlowery

I'm not clear on the sequence I think - when is the email sent? I don't even see a reference to it on my checkout, checkout_success, confirm or pp_confirm pages (I've attached them for you to take a look at). Or is it somewhere else?

Attached Files
checkout_success.php
confirm.php
confirm_cart.php
pp_confirm.php
Sign in to reply to this post

Ray BorduinWebAssist

It is on the pp_confirm.php page below the store cart details in database, which is the correct location, so that wasn't the issue.

It looks like the email body is coming from: webassist/email/muirhead_receipt.php

Are you sure the database is being updated properly? Does the order_details table have the correct value in the product_id column and order_id column?

Sign in to reply to this post

jlowery

Think I figured out the problem - the details were being stored in the wrong table (orderdetails and not order_details). I'm recreating the Store Details in Database and after assigning values to all the db fields, get an error: You must set the value of the column specified as the Order ID. But I have. I have it as:<?php echo $_SESSION['muirhead_OrderID']; ?>.

I can't update the server behavior until I get past this error. What do I do?

Sign in to reply to this post

Ray BorduinWebAssist

You probably have the wrong column specified for the Order ID in the Order ID dropdown above the column bindings.

Sign in to reply to this post

jlowery

Doh! You're right.

Going back to the "West of the Mississippi" charge again. I need that to appear in the cart display in a couple places (the confirm page and the reciept). It's one of the shipping formulas - how do I break it out to show it if applied? Right now, it is included in the charge with no indication of what it is.

Sign in to reply to this post

Ray BorduinWebAssist

You will probably have to add a field for it into the orders table and then store it separately so you can display it properly from the database.

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