Your account is limited to posting only in the Pre-Sales Questions forum.
Support forum access is limited to members with a purchase history.

If you are working on behalf of another member, please contact us with the name of the license holder and we will upgrade your account.
   
 
PayPal Transaction ID
Posted: 01 July 2010 11:12 AM   [ Ignore ]
Wallflower
Rank
Total Posts:  9
Joined  2010-05-09

Hi

We currently have an order confirmation template which looks like this (simplified version):

{exp:cartthrob:submitted_order_info}

    {if authorized}

        
<p>Your transaction is complete!</p>

    <
ul>
            <
li>Transaction ID{transaction_id}</li>
    </
ul>

        
{exp:weblog:entries weblog="orders" entry_id="{order_id}" show_future_entries="yes" status="Completed"}

    
<p>Number of items in this order{order_items:total_results} ({order_transaction_id})</p>

    
{/exp:weblog:entries}

    {
/if}

{
/exp:cartthrob:submitted_order_info} 

When using the PayPal Standard gateway, after the customer has paid and is returned to this order confirmation template, the first transaction ID variable

{transaction_id} 

is always empty, while the second one in between the weblog:entries contains the proper transaction id.

Any ideas?

Regards
Peter.

Profile
 
 
Posted: 01 July 2010 04:05 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRank
Total Posts:  3541
Joined  2009-05-29

PayPal Standard is a two step process: 1st) they redirect the user back to your site, 2nd) they ping your IPN url to tell the system that the transaction has processed. I believe that you can get redirected back to the site before the IPN goes through, and so at that point you wouldn’t have a transaction_id. I would say if you are having issues with the {transaction_id} tag, and the {order_transaction_id} tag works in your weblog:entries tag, you should go ahead and just use the weblog:entries tag to display your transaction_id.

{exp:cartthrob:submitted_order_info}

    {if authorized}

        
<p>Your transaction is complete!</p>
        
{exp:weblog:entries weblog="orders" entry_id="{order_id}" show_future_entries="yes" status="Completed"}

    
<ul>
            <
li>Transaction ID{order_transaction_id}</li>
    </
ul>


    <
p>Number of items in this order{order_items:total_results} ({order_transaction_id})</p>

    
{/exp:weblog:entries}

    {
/if}

{
/exp:cartthrob:submitted_order_info} 

This is just something we’ll have to monitor if we start hearing from a lot of people that this is happening to them, too.

Profile
 
 
Posted: 01 July 2010 04:36 PM   [ Ignore ]   [ # 2 ]
Wallflower
Rank
Total Posts:  9
Joined  2010-05-09

PayPal Standard is a two step process: 1st) they redirect the user back to your site, 2nd) they ping your IPN url to tell the system that the transaction has processed. I believe that you can get redirected back to the site before the IPN goes through, and so at that point you wouldn’t have a transaction_id.

Yes, this is indeed what I thought initially, but then it would not make sense that the {order_transaction_id} tag works (coming from an existing entry in the orders weblog, which means that the ping already came back from PayPal?), and {transaction_id} does not.  Or am I missing something?

Profile
 
 
Posted: 01 July 2010 04:38 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRank
Total Posts:  3541
Joined  2009-05-29

It’s certainly a bit odd. We’ll have to do some testing over here and see what we come up with.

Profile
 
 
Posted: 01 July 2010 06:41 PM   [ Ignore ]   [ # 4 ]
Administrator
Avatar
RankRankRankRankRank
Total Posts:  10256
Joined  2008-09-29

Yes, this is indeed what I thought initially, but then it would not make sense that the {order_transaction_id} tag works (coming from an existing entry in the orders weblog, which means that the ping already came back from PayPal?), and {transaction_id} does not.  Or am I missing something?

Your {order_transaction_id} is data stored with the entry. Entry data is not polled to display the {transaction_id}. So it’s entirely possible that paypal could update via IPN immediately, and the {order_transaction_id} would be stored without the {transaction_id} being shown.

That said, I’ve reviewed how we expect paypal to return the {transaction_id} and I’ll do some testing to see if we’re actually getting that value back correctly.

What country are you located in peschehimself?

 Signature 

We’re moving away from the forums, though not entirely and not immediately. Lack of support lately is coincidental to that. Unfortunately we’ve had a bad month with it, but we do not forsee that we will have any continued problems with support through our portal going forward, or on forums while we’re still transitioning. We will send out a newsletter and make additional notifications through twitter and other outlets over the coming weeks.

Moving forward; things returning to normal.

Profile
 
 
Posted: 01 July 2010 06:43 PM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRankRank
Total Posts:  10256
Joined  2008-09-29

I think I just figured something out. I’ll get back to you after I test.

 Signature 

We’re moving away from the forums, though not entirely and not immediately. Lack of support lately is coincidental to that. Unfortunately we’ve had a bad month with it, but we do not forsee that we will have any continued problems with support through our portal going forward, or on forums while we’re still transitioning. We will send out a newsletter and make additional notifications through twitter and other outlets over the coming weeks.

Moving forward; things returning to normal.

Profile
 
 
Posted: 26 July 2010 11:17 PM   [ Ignore ]   [ # 6 ]
Wallflower
Rank
Total Posts:  17
Joined  2010-06-14

Hi Chris,

Do you have any news on this issue?  I am experiencing the same problem - {transaction_id} is not outputting anything.  But the transaction id is being saved into the Orders weblog.  Not always before arriving at the confirmation page, but within about 5 seconds to 2 minutes.

It looks like PayPal is sending the tx= parameter in the return URL but CT is not outputting the {transaction_id}.

Just an FYI, with my experience on PayPal’s IPN - when PayPal is having issues (sometimes these can be major issues when they roll out upgrades on their live site) their IPN notifications become backlogged for hours.  I have seen delays of 12-14 hours on occasion.

Also, any thoughts on supporting Payment Data Transfer (PDT) from PayPal on the return URL?  PDT is turned on in my SandBox account.

Thanks
Tek

 Signature 

EE 1.6.8 | CartThrob v.0.9337

Profile
 
 
Posted: 27 July 2010 12:19 AM   [ Ignore ]   [ # 7 ]
Wallflower
Rank
Total Posts:  11
Joined  2010-04-08

I’m having the same issue I think… {transaction_id} stopped outputting, but it is saved to the Orders weblog. I had it working for a while before then it stopped. I haven’t had a chance to chase it down yet because I have a bunch of other things to deal with. I’ll report back with I can find, if I can find anything.

PS I’m in Canada if that helps.

Profile
 
 
Posted: 27 July 2010 11:03 AM   [ Ignore ]   [ # 8 ]
Administrator
Avatar
RankRankRankRankRank
Total Posts:  10256
Joined  2008-09-29

It looks like PayPal is sending the tx= parameter in the return URL but CT is not outputting the {transaction_id}.

Can you show me a sample of the return URL that paypal is sending.

 Signature 

We’re moving away from the forums, though not entirely and not immediately. Lack of support lately is coincidental to that. Unfortunately we’ve had a bad month with it, but we do not forsee that we will have any continued problems with support through our portal going forward, or on forums while we’re still transitioning. We will send out a newsletter and make additional notifications through twitter and other outlets over the coming weeks.

Moving forward; things returning to normal.

Profile
 
 
Posted: 27 July 2010 11:14 AM   [ Ignore ]   [ # 9 ]
Wallflower
Rank
Total Posts:  17
Joined  2010-06-14

Sure…

http://www.mydomain.com/?tx=7YP0753828954225Y&st=Completed&amt=34.00&cc=USD&cm;=&item;_number=&ACT;={AID:Cartthrob:payment_return}&gateway=paypal_standard&method=paypal_success&merchant_return_link=Return+to+Test+Account&form_charset=UTF-8 

The forum’s text parsing is screwing up the URL with semi colons.  You can remove them.

I have recently fixed “{AID:Cartthrob:Apayment_return}”  with Rob’s fix found here  (for anyone else reading this, note Rob’s correction 2 posts down that thread - “gateway=”)

 Signature 

EE 1.6.8 | CartThrob v.0.9337

Profile
 
 
Posted: 27 July 2010 11:20 AM   [ Ignore ]   [ # 10 ]
Wallflower
Rank
Total Posts:  17
Joined  2010-06-14

PS I’m in Canada if that helps.

Me too, if that makes a difference.  grin

But the transaction is in USD, on a US SandBox account, go live will be for a US PayPal Account.

 Signature 

EE 1.6.8 | CartThrob v.0.9337

Profile
 
 
Posted: 27 July 2010 11:36 AM   [ Ignore ]   [ # 11 ]
Administrator
Avatar
RankRankRankRankRank
Total Posts:  10256
Joined  2008-09-29

OK Tektraveler. I have support set up now for PDT & the tx field (we didn’t before)

I’ll need to test, but I should be able to get a new version with this set up within the week.

 Signature 

We’re moving away from the forums, though not entirely and not immediately. Lack of support lately is coincidental to that. Unfortunately we’ve had a bad month with it, but we do not forsee that we will have any continued problems with support through our portal going forward, or on forums while we’re still transitioning. We will send out a newsletter and make additional notifications through twitter and other outlets over the coming weeks.

Moving forward; things returning to normal.

Profile
 
 
Posted: 27 July 2010 11:42 AM   [ Ignore ]   [ # 12 ]
Wallflower
Rank
Total Posts:  17
Joined  2010-06-14

Wow, great - thanks.  I am happy to test if you need, when you are ready.

 Signature 

EE 1.6.8 | CartThrob v.0.9337

Profile