PayPal Orders Made But Don't Show Up On Orders

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!

• 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/showthread.php?t=56216&goto=newpost
• Have you checked the PayPal troubleshooting guide at:
  http://www.zen-cart.com/wiki/index.php/PayPal

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

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?

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

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?

This is your problem:```
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?

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

DrByte:

This is your problem:```
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

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

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.

Hi,

Well I was going to do the order thing (just write into the itemname, item number fields) because the data wasn't getting written to the database before going to paypal.

I saw the final page (where the pay on paypal button is) yet nothing was in the db. Before I fixed the postage, nothing was in the db after either.

Of course I could have been looking in the wrong tables, I checked the orders and paypal ones only.

I forget which paypal field it is, but all I was going to do was write in the item name field in a way similar to a forum post I saw here earlier.

So instead of:

Item name: Your store name
Item number: Store receipt

You'd get something:

Item name: Your store name
Item a - qty 1
Item b - qty 2
Item number: Store receipt

Or even individually write the item name and item number fields for each product. Then add shipping as a final product to the list.

I'm not so attached to this idea that if it turns out a bad one I'd defend it to my dying days :). But as nothing was going in the db at the time, I wanted to ensure the order details were always available.

So if someone accidentally reconfigured their paypal and an order went through, there would be nothing to tell us what the order was.

I haven't had the time to research this further so if it turns out to be stupid then so be it :)

The details are stored serialized in the paypal_sessions table.
Once the IPN is received, those details are unserialized, and then parsed along with the IPN authentication data.

If you use PDT, it doesn't bother with the serialization ... it stores them in the active session, and once the PDT is completed, the data is transferred from the session into a live order in the system.

At the present time, Zen Cart doesn't record an order until the payment processor communications is complete, which is why you didn't see the data in the orders table before making payment.