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

Storing Confirmation ID In orders.OrderTrackingNumber

Thread began 3/03/2012 5:49 am by rehuntjr435750 | Last modified 3/08/2012 1:39 pm by Jason Byrnes | 1744 views | 13 replies |

rehuntjr435750

Storing Confirmation ID In orders.OrderTrackingNumber

My business is selling pre-packaged services through eCart. As such I am not "shipping" physical products so I don't have to worry about UPS or FedEx and so on.

When a confirmation comes back from the payment processor (let's assume just PayPal for now), is there a way I can capture PayPal's Receipt No. XXXX-XXXX-XXXX-XXXX and store that in orders.OrderTrackingNumber ??

Or perhaps there's a better field in orders. I didn't see one so I thought I'd try to piggyback on the OrderTrackingNumber field since I'm not using it for shipping purposes.

Is there a session variable or some other container that holds that value after PayPal comes back with its confirmation screen ?

Thanks, Bob Hunt

Sign in to reply to this post

Jason ByrnesWebAssist

which paypal system? they all work differently

paypal standard?

or paypal express?

Sign in to reply to this post

rehuntjr435750

PayPal Express Checkout

I believe I'm using PayPal Express Checkout on the front end (my site) with Website Payments Pro on the PayPal end.

I hope that's enough information. If not, *please* let me know precisely what you need and where to look for it.

Thank you,

Bob Hunt

Sign in to reply to this post

Jason ByrnesWebAssist

the Checkout form on your site will use PayPal Direct payments, when the click the checkout with paypal button on the checkout page, this is using paypal express.


for direct payments:

open the confirm page, then go to the bindings panel, click the plus button and select eCart -> Checkout -> Local Checkout response. AFrom the gateway list, select "PayPal Direct Payment"

on the server behaviors panel, double click the store order summary behavior, then bind the orders.OrderTrackingNumber column to the transaction ID binding in the Local checkout response (PayPal Direct Payment) binding group.


For Express checkout it's very similar, except you will use the pp_confirm page. when adding the local checkout response binding group, select the "Paypal Process Express Checkout" option from the gateway list.

on the server behaviors panel, double click the store order summary behavior, then bind the orders.OrderTrackingNumber column to the transaction ID binding in the Local checkout response (Process Express Checkout) binding group.

Sign in to reply to this post

rehuntjr435750

Good to go on Direct Payments.

On Express Checkout, there is no Transaction ID in the Local Checkout Response.

Is there another value to look for?

Sign in to reply to this post

Jason ByrnesWebAssist

for express us the correlation ID

Sign in to reply to this post

rehuntjr435750

Thanks, but CorrelationID doesn't work. The string I'm looking to get from PayPal Express has this pattern ... all numbers ... 9999-9999-9999-9999. The CorrelationID came back as a strong of lower case letters plus a few numbers. The customer never sees that ID (whatever it is) so it's of no use storing in the database.

Any other suggestions?

Sign in to reply to this post

Jason ByrnesWebAssist

it doesn't look like express checkout returns that value, correlation ID is the only one included by express checkout.

Sign in to reply to this post

rehuntjr435750

Ouch, that's not good. Perhaps that's something that could go on the wishlist for a future version. I'm looking at this from a customer service and support perspective. Here's the scenario ...

eCart returns and displays the incrementing OrderID on the Confirmation page.
eCart does not return and display the PayPal transaction ID on the Confirmation page.

PayPal's e-mail message to the buyer displays the PayPal transaction ID (9999-9999-9999-9999).
PayPal's e-mail message to the buyer does *not* display the eCart OrderID.

Neither one has the information needed to fully support an incoming call for help. If they have their eCart OrderID, great. If they don't but they do have their PayPal transaction ID, then not so great.

Having and storing *both* in the database means I should be able to find any Order any of my customers need supported. Granted, I understand I can still find their Order given their name, address, date of sale and so on. But if you guys could look at this for a future release, that would be great.

Sign in to reply to this post

Jason ByrnesWebAssist

I was mistaken, the transaction ID is set in the Get Payer Profile behavior.

on the bindings tab, click the plus button and select eCart -> Checkout -> Local Checkout response. from the gateways list, select Get PayPal Express Checkout Payer Profile. and use the transaction ID binding from that binding group.

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