PayPal Orders Made But Don't Show Up On Orders

**SpiritDane** · 25 Jul 2007, 06:33 PM

Greetings,
I'm hoping someone can help me. When we have customers place orders and pay via paypal, they are directed to paypal and that whole process complete. However, their order does not show up in our customer orders, no invoice for them nor are they sent order confirmations.

Not sure what is going on with this and can't see anything to be wrong thru the admin panel.

Any ideas?

Thanks!

**DrByte** · 25 Jul 2007, 09:45 PM

- What PayPal module do you have enabled?
- What version of Zen Cart? What patches have you installed?
- If you're not using v1.3.7.1, have you installed the latest PayPal patch at: http://www.zen-cart.com/forum/showth...6&goto=newpost
- Have you checked the PayPal troubleshooting guide at:
http://www.zen-cart.com/wiki/index.php/PayPal

**simonproctor** · 30 Jul 2007, 02:14 AM

Hi,

I've spent the last few hours trying to crack this and I'm stuck too. The order confirmation sends 'Store reciept' to Paypal (IPN module), the order doesn't appear in any of the tables I can find and it doesn't send any emails.

The only emails I get are from paypal.

I've

renamed meta_tags.php to meta_tags.php.bak
I've ensured the emails are correct
I've enabled logging and debugging
The server can send emails as its sending me the paypal logs by mail
I've uninstalled and reinstalled the paypal modules and I've also ensured I downloaded the latest patch.

I'm totally baffled and I can't figure out whats wrong. Paypal is communicating ok (no firewall issues) but its complaining that there is no transaction. The error is:

IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new
to us.

Can anyone help?

I'm using 1.3.7 (new install but with customised templates).

Thanks!

Simon

**DrByte** · 30 Jul 2007, 07:42 AM

Originally Posted by simonproctor

IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new
to us.

that's normal.
1. What *else* is in the logs? or was that the last line?
2. What version of Zen Cart are you using? What patches have you applied?

**simonproctor** · 30 Jul 2007, 08:45 AM

Hi,

Thanks for the reply. As per my original post, I have applied the latest patch (June) and I'm using 1.3.7.

I've attached two log files. The store owner has two paypal email addresses so I've tried the system with both (ensuring that I set the store owner email to the same value each time too).

I've looked at the code and I can't see how the system would send anything other than 'store receipt' to paypal as its a hardcoded string.

Anyway, I'm totally baffled so any help you can offer is greatly appreciated! We just need those orders appearing!

Thanks,

Simon

**Merlinpa1969** · 30 Jul 2007, 12:47 PM

you need to make sure that

1.in the ZC paypal module you are using the Primary address at paypal.com and that its case sensitive

2. That you have the Auto return turned on in paypal
3. that you have the IPN turned on in paypal

what happens if you manually go to the paypal url?
Are you using any SEO modules?

**DrByte** · 30 Jul 2007, 04:53 PM

This is your problem:

Code:

Jul 29 2007 19:40 -- IPN WARNING :: Currency/Amount Mismatch.  Details: 
 | mc_currency = GBP
 | submitted_currency = GBP
 | order_currency = GBP
 | mc_gross = 1.44
 | converted_amount = 1.38
 | order_amount = 1.38

What currencies and exchange rates do you have set in Admin->Localisation->Currencies?

**simonproctor** · 30 Jul 2007, 07:37 PM

Ahh, I've been trying to get that changed but it isn't my account. I'll be able to use the guys account later this evening (he's going to log me in then make a cup of tea) so I'll check that out.

As to the other post, I've not installed any seo modules, the ipn_handler tells me there is nothing to process (no errors displayed) and my email addresses are ok as I've set the store owner and module email to both of his addresses when testing (and uninstalled and reinstalled each time).

He's let me know which is his primary (he was unavailable when I was testing which made things harder!!) so I'll provide some feedback later tonight.

As an aside, I think it a useful feature for the orders to be written into the paypal button, even if its just IPN. If there are any problems with the cart, your ISP or the connection (when IPN occurs) you will always have a record of what has been purchased.

Is that a useful thing do you think? I'm suggesting it regardless of my problems :). I'd be happy to supply a patch for initial approval if there is interest.

Thanks again to you both, I'll try out these latest suggestions and let you know how I get on

TTFN!

S

**simonproctor** · 30 Jul 2007, 09:09 PM

Originally Posted by DrByte

This is your problem:

Code:

Jul 29 2007 19:40 -- IPN WARNING :: Currency/Amount Mismatch.  Details: 
 | mc_currency = GBP
 | submitted_currency = GBP
 | order_currency = GBP
 | mc_gross = 1.44
 | converted_amount = 1.38
 | order_amount = 1.38

What currencies and exchange rates do you have set in Admin->Localisation->Currencies?

Yeah I fixed that and the orders now appear. I had to set all the postage preferences to zero (flat amount) for it to work.

So thanks for checking through everything.

I'm still keen to add the items to the paypal order so I'll work on that over the next few days. If you think its worth it, I'll post a link here for people to review?

Thanks again !!!

Simon

**DrByte** · 30 Jul 2007, 09:42 PM

Originally Posted by simonproctor

I'm still keen to add the items to the paypal order so I'll work on that over the next few days. If you think its worth it, I'll post a link here for people to review?

If you have a way of making it properly handle coupons, group discounts, sales, promos, and other price reductions and not "croak", then it would be interesting to see the code. PayPal doesn't handle those very well.

Zen Cart stores the entire order details prior to the "PayPal Standard" order being submitted. When the IPN is received, it resurrects all those details and assumbles them into the order which is then available in Zen Cart, both to the administrator and to the customer in their account history.
If you have PDT enabled in both your Zen Cart PayPal settings and your PayPal account profile, then the order information is stored immediately upon successful PDT handshake, minimizing the common problems associated with the delays introduced by waiting on the IPN for order-completion.

There are a number of troubleshooting steps one can follow and/or review to ensure their site is setup to minimize the potential of any IPN problems:
http://www.zen-cart.com/wiki/index.php/PayPal
Your postage issue is mentioned there also, along with tax issues, etc.