Orders not showing up in Paypal or ZC admin (PayPal IPN module)

[FONT=Arial]Hi folks,

The issue is the client orders item(s) and confirms order. They then proceed to Paypal for checkout. Paypal does not display ordered items, only the final amount for the item(s).

The order doesn't show up in the admin area either.

I've actioned the suggestions in posts,
http://www.zen-cart.com/forum/showthread.php?t=54041
http://www.zen-cart.com/forum/showthread.php?t=53784

[/FONT][FONT=Arial]but no luck. :([/FONT]
[FONT=Arial]
Any help or advice would be greatly appreciated[FONT=&quot][/FONT]!
[/FONT]
php 4.4.4
ZC 1.3.6
HTTP Server: Apache/1.3.37 on Linux

When you say the order does not show in your Zen Cart Admin ...

If you type in the orders_id on the search for order id:

Can you now see it?

If so, go to the Modules ... Order Totals ...

Is the Total ot_total installed?

If it is not installed, then the Order will not list on the display of Orders in the Admin ...

Hi Ajeh

Thanks for the quick response.

The orders don't show up in at all orders. The last test purchase didn't generate an order ID.

The ot_total module is installed

Thanks

And if you peek in your database in phpMyAdmin and look in the orders table you see nothing new?

What version Zen Cart?

Clean or Upgraded? If an upgrade, from what version and how?

Has this ever worked?

What changed since it last worked for you? Any chnages, add-ons, etc. by you? Any changes by your hosting site?

Nothing new on in the database re: orders. The site was upgraded from 1.3.5 to 1.3.6 with no major problems using the /zc_install. The orignal developer checked the setting to ensure all was well.

These would be the first round of test purchases.I also removed the tax application in paypal as per an archive thread to see if it was a conflict with PayPal. No luck.

I have yet to talk with the ISP, re: changes to any settings

It "could" be a PayPal system problem. They are doing system maintenance today and tomorrow, so I suppose it's possible that there could be intermittent glitches.

There are a number of debugging steps you can follow if you enable the debug support in the PayPal module. This is outlined here:
http://www.zen-cart.com/wiki/index.php/PayPal

Did you try to Remove, Install and Reconfigure PayPal IPN since your upgrade?

Did you check the PayPal site to ensure nothing changed on your settings there? Sometimes they do change mysteriously ... :eek:

Are you using your Primary email address?

I also starting having this problem about two weeks ago. First, my pending eChecks weren't posting as having been cleared, however now any orders placed and checked out using Paypal don't show up in my order history. I see a zenid in the PP transaction, but no order in ZC. The customer registration is successful, but nothing more. CC orders work just fine, my other modules all look to be in order....

This has occurred now about 6 times. I'm using ZC v1.2.7 and have made no changes to either my code or paypal settings in the last six months. Happy to give someone access to my site in order to rectify the problem. I hate to disable Paypal as a payment method (well, kind of;)), but probably will need to do so in the near future if the problem continues.

Removed and installed the PP IPN since the upgrade. Checked the PP settings. Made some minor changes ( like removing the PP tax module)

Double checked the emails in ZC and PP and both match....

I ran the "low-end" html version of the store, and was successful with PP, recording the orders.

I also went through the good DrByte's wiki PP guide ( thanks!!) - still no luck.:frusty:..could this be a misconfig with items the catalogue?

Quote:

---

Originally Posted by Ajeh

Did you try to Remove, Install and Reconfigure PayPal IPN since your upgrade?

Did you check the PayPal site to ensure nothing changed on your settings there? Sometimes they do change mysteriously ... :eek:

Are you using your Primary email address?

---

Quote:

---

Originally Posted by bi11i

I also starting having this problem about two weeks ago.

---

Did your web host make any server changes recently? namely related to firewall access and PHP fopen-wrappers settings?

Quote:

---

Originally Posted by Edgar

Removed and installed the PP IPN since the upgrade. Checked the PP settings. Made some minor changes ( like removing the PP tax module)

Double checked the emails in ZC and PP and both match....

I ran the "low-end" html version of the store, and was successful with PP, recording the orders.

I also went through the good DrByte's wiki PP guide ( thanks!!) - still no luck.:frusty:..could this be a misconfig with items the catalogue?

---

If you turn on debugging, what shows up in the logs?

Not that I'm aware of, but I'll certainly check it out. Any other details in the way of "firewall access and PHP fopen-wrappers settings" - I'm not literate in that area. Is there a certain port that needs to be open, etc?

Details here:
http://www.zen-cart.com/wiki/index.php/PayPal

I found the problem. I had to uninstall and reinstall the Paypal module. Once I did this, I had to use

Code:

---

www.paypal.com/us/cgi-bin/webscr

---

rather than

Code:

---

www.paypal.com/cgi-bin/webscr

---

. Once I did this, the ZC instructed IPN was different from that which I had setup in Paypal. I wish I would've written down what the previous set IPN in paypal was, but it wasn't https:// was http://. Anyway, back in working order. Wish I knew what caused it or what happened, but thanks for the help!

Thanks for the update that you have things working once more ... :smile:

Quote:

---

Originally Posted by bi11i

I found the problem. I had to uninstall and reinstall the Paypal module. Once I did this, I had to use

Code:

---

www.paypal.com/us/cgi-bin/webscr

---

rather than

Code:

---

www.paypal.com/cgi-bin/webscr

---

. Once I did this, the ZC instructed IPN was different from that which I had setup in Paypal. I wish I would've written down what the previous set IPN in paypal was, but it wasn't https:// was http://. Anyway, back in working order. Wish I knew what caused it or what happened, but thanks for the help!

---

Did you have to use https or http, for example http://mysite.com/onlinestore/ipn_main_handler.php?

Quote:

---

Originally Posted by Edgar

Did you have to use https or http, for example http://mysite.com/onlinestore/ipn_main_handler.php?

---

i had to use https

Tried the suggestions - no luck....:frusty:

Contacted ISP - ports opened

Contacted PP - here is response

went to your site at your site and tried to place an order to test the checkout process, but I couldn't get past the 'enter an address' screen. ( this problem happened once before and I can fix this)

I see from a previous order that the third party shopping cart that you are using is not passing over what the customer ordered with the payment information, typically called an 'aggregate' order. For instance, the only thing we see about the order is:

Payment For: mysite9 (<< my edit) Purchase

Typically with this kind of setup, you should be able to go to your cart and look up the order number to see specifically what the customer ordered. If you can't see it, I would suggest contacting your cart support (or forums) to see if you can get more information and perhaps change the order to an 'itemized' format so that the cart passes the items the customer ordered over to PayPal.
----

Arg.....

What is in your IPN debug logs?

I believe the wiki article already suggests this, but ... is your PayPal account "Verified" ?

I do have precisly the same problem.

That means IPN worked when I used 1.3.6. After I upgraded to 1.3.7 everythin was fine in the beginning but than started a problem. When Ordering through IPN custumer is directed to PayPal and pay as normal, he is than redirected to the Checkout-Success page without displaying an error. No Order is recorded and the basket is empty.

Here is my IPN log of my last try:

Code:

---


Jan 12 2007 12:40 -- Breakpoint: 1

Jan 12 2007 12:40 -- Breakpoint: 2

Jan 12 2007 12:40 -- Breakpoint: 3

Jan 12 2007 12:40 -- IPN WARNING::Could not find matched txn_id record in DB

Jan 12 2007 12:40 -- Breakpoint: 4 txn_type=unique ordersID =  IPN_id=

Jan 12 2007 12:40 -- IPN DEBUG::uniqueness-test.  Relevant data from POST:
txn_type = unique
parent_txn_id =
txn_id = 57J15009F9790130P

Jan 12 2007 12:40 -- IPN NOTICE::Set transaction type = pending-echeck
POST data:
mc_gross=34.95
&address_status=unconfirmed
&payer_id=AK2xxxxxxxxxxx
&tax=0.00
&address_street=Donxxxxxxxxxxxxxxx
&payment_date=03:39:15 Jan 12, 2007 PST
&payment_status=Pending
&charset=windows-1252
&address_zip=4710
&first_name=Ariane
&address_country_code=BE
&address_name=Dieter Brandenburger
&notify_version=2.1
&custom=zenid=f91f80f3fa2c9748889b225824c32266
&payer_status=unverified
&business=admin@txxxxxxxxxxxx
&address_country=Belgium
&address_city=Lontzen
&quantity=1
&verify_sign=AUaxvSoxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
&[email protected]
&txn_id=57J15009F9790130P
&payment_type=echeck
&last_name=Brxxxxxxxxxxx
&address_state=0
&receiver_email=admin@xxxxxxxxxxxxxxxx
&receiver_id=QGWEEHNU35J7S
&pending_reason=echeck
&txn_type=web_accept
&item_name=DREHMAHL - Shop Einkauf
&mc_currency=EUR
&item_number=1
&residence_country=DE
&payment_gross=
&shipping=0.00
&cmd=_notify-validate

Jan 12 2007 12:40 -- Breakpoint: 5 txn_type=pending-echeck

Jan 12 2007 12:40 -- IPN WARNING:: Could not establish txn type pending-echeck
 postdata=mc_gross=34.95
&address_status=unconfirmed
&payer_id=AK2CQ72SQDESS
&tax=0.00
&address_street=Doxxxxxxxxxxxxxxxxxxx
&payment_date=03:39:15 Jan 12, 2007 PST
&payment_status=Pending
&charset=windows-1252
&address_zip=4710
&first_name=Ariane
&address_country_code=BE
&address_name=Dietexxxxxxxxxxxxxx
&notify_version=2.1
&custom=zenid=f91f80f3fa2c9748889b225824c32266
&payer_status=unverified
&business=admin@xxxxxxxxxxxxxxx
&address_country=Belgium
&address_city=Lontzen
&quantity=1
&verify_sign=AUaxvSojqajxsiGA9qxxxxxxxxxxxxxxxxxxxxx
&[email protected]
&txn_id=57J15009F9790130P
&payment_type=echeck
&last_name=Bxxxxxxxxxxxxxxx
&address_state=0
&receiver_email=admin@xxxxxxxxxxxxxxxxxxx
&receiver_id=QGWEEHNU35J7S
&pending_reason=echeck
&txn_type=web_accept
&item_name=DREHMAHL - Shop Einkauf
&mc_currency=EUR
&item_number=1
&residence_country=DE
&payment_gross=
&shipping=0.00
&cmd=_notify-validate

---

I only find a warning

Jan 12 2007 12:40 -- IPN WARNING:: Could not establish txn type

but do not know what to do...

Thanks for any help
Dieter

Using phpMyAdmin ... look at the paypal table and the paypal_testing

Check the field length for:
payment_type varchar(40)

If smaller, raise to 40

Hi,

thanks for the reply, BUT.... not working :(

payment_type had been lower than 40, rising it to 1st 40 and 2nd to 64 did not make any change. Still the same Problem and the same error message in the IPN log.

:cry: Dieter

And you updated all of the files for:
/ipn_main_handler.php
/includes/modules/payment/paypal.php
/includes/modules/payment/paypal

in addition to the other changed files in v1.3.7 ...

You also checked the PayPal site and your settings to ensure PayPal did not reset anything?

I'll check this....

tomorrow.

(Have to go now)

CU and Thanks
Dieter :lamo:

Yes I checked the paypal.php file and the settings with paypal, but still there is no change. The file version is:
* @version $Id: paypal.php 5352 2006-12-22 21:35:58Z drbyte

One thing. When I confirm order I am redirected to paypal. Meanwhile the paypal_testing table is still empty... Maybe this helps?

Kind regards
Dieter

It is very strange the the code worked in v1.3.6 and work initially in v1.3.7 and then ... "changed its mind" ...

Code doesn't change its mind ...

Did something change on your server?

How long was it working in v1.3.7 before it "changed its mind" and stopped working?

For giggles and grins have you tried loading a clean v1.3.7 into a test directory with a test database and the demo data and just add a few cheap test products to see if that works?

Regarding the "software changing mind" thing:

Well as I just noticed, my error discription was not precise. I updated vom 1.3.6 to 1.3.7. Bevor PayPal IPN worked perfectly for all kind of transactions. Now the discribed error occures (only) on pending transactions. So if a PayPal custumer chooses "Bank Transfer" within paypal the order is not processed allthough he gets an oder success message. The cart is delete, but no order issued. On transaction that are payed directly (like Creditcard within Paypal) everything works fine.

What I did for now, I stoped accepting pending payment types within paypal.

Maybe this information helps somehow.

Thanks anyway
Dieter

Try running these in the Tools ... Install SQL Patches ...

PHP Code:

---

ALTER TABLE paypal CHANGE txn_type txn_type varchar(32) NOT NULL default '';
ALTER TABLE paypal CHANGE payment_type payment_type varchar(40) NOT NULL default '';
ALTER TABLE paypal_testing CHANGE txn_type txn_type varchar(32) NOT NULL default '';
ALTER TABLE paypal_testing CHANGE payment_type payment_type varchar(40) NOT NULL default ''; 


---

Then, get the updated file on post #19:
http://www.zen-cart.com/forum/showthread.php?t=54679

See it those help you ...

Is this fix only for paypal express users...

Im in the UK and noticed a user go through all the steps using user tracking module but there was no record of the order in admin area but i did get a confirmation from paypal via email to say they had received payment via echeque which would be cleared in 3 > 4 days.

For v1.3.7 ... this is a good patch to add in to ensure all is set right ...

http://www.zen-cart.com/forum/showthread.php?t=56216

As to is there an issue on your site due to the code ... well questions are:

1 Is this a clean v1.3.7 or an upgrade ...

2 if an upgrade, from what version and how ...

3 has this ever worked right? what about in all your testing before you went live?

4 any changes on your server? such as new php version, moving hosts, etc.

Thanks for the reply Ajeh...

Its a new install of 1.3.7 and it only went live about 2 weeks ago i've had 12 other standard paypal and 6 cheque/money order transactions and they have been comming through fine but this paypal echeque didnt come through.

I logged in using the master password to the customers account and there is no sign of the order so the user thinks it has gone through fine. I have emailed the customer to find out what they ordered but have had no reply yet.

I tested the cheque/money order and the paypal payments before going live but not paypal echeque payments.

MySQL 4.1.21-standard
Linux 2.6.9-42.ELsmp
PHP 4.4.3 (Zend: 1.3.0)
Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b

And did you add that update that I posted the link for? :smile:

We are also experienceing the same kind of issue. Ive followed the thred. From what ive seen the PP IPN is working, but not the Order number so all the orders are now # 0 - ive copied a few lines for people to see . If anyone finds a fix please email me at [email protected]
IT WAS working. Ill keep looking...
thanks
0 28 cleared-address
Adam xxx Completed
Parent Trans ID:
Trans ID:52Y15337AJ376045YUSD 25.99 0 27 cleared-address
xxx white Completed
Parent Trans ID:
Trans ID:8LV00585JN3030703USD 39.29 0 26 cleared-address
Howard xxx Completed
Parent Trans ID:
Trans ID:2JJ46916YU2895933USD 53.99 8 25 unique
leonard xxx
xxx Completed
Parent Trans ID:
Trans ID:35K975565F7182255USD 24.35 7

Thanks Ajeh...

I will FTP the patch that you posted and will also try and test it tonight just wasnt sure if the patch would do anything for non paypal express users.

Ive also noticed some strange PP behavor on their server - some Icons not showing and such last night. With the PP IPN working just last week and we have not know any changes to our systems im starting to think that they may be the issue for this bug. Ive looked at their status an altho its not reporting anything major - i suspect them at this time. A lot of people have the issue and not made a change. logic tells me that something is broken somewhere.

Ive spent about 3 weeks trying to get paypal IPN to work, it was a new install of 1.3.6, Dr Byte helped, but it worked some times and not others, checked with host all ports open etc. Driving me crazy!!

So gave up with 1.3.6

Fresh install of 1.3.7, paypal still not working, so installed the dr Byte patches and linda's sql update, and good news it is all working now

thanks for all the help given

Andy

Thanks for the update that loading the paypal patch for v1.3.7 was able to fix your issues ... :smile:

The current patch can be found at:
http://www.zen-cart.com/forum/showthread.php?t=56216

Hello,
I had the same problem with the orders not showing for the PayPal customers. I did the recommended patch (thank you).

After I did a test order, Admin does the show order, but when you look at the order, there are no line items listed. The totals show on the invoice (Sub-Total, UPS, Tax, and Total), but the products are not listed. I did not receive an e-mail with my order confirmation for my test order either. After I made my payment with PayPal, I could return to my store’s “Thank you” page.

My PayPal account did process the charge automatically.

I have version 1.3.7 for both the database and Zencart. I am not using the PayPal Express, just the PayPal IPN.

I have tried to cancel the PayPal IPN and re-install it.

Please help.

Katrina

Hello folks,

I had same problem and finally found out that this is a bug in ipn_main_handler.php: transaction type "pending-echeck" is missing in the switch statement, and therefore PayPal transactions with status "pending-echeck" cannot be processed.

Open ipn_main_handler.php file in your shop directory and look for:

PHP Code:

---

/**
 * take action based on transaction type and corresponding requirements
 */
switch ($txn_type) {
  case 'pending-address':
  case 'pending-intl':
  case 'pending-multicurrency':
  case 'pending-verify': 


---

Then insert following line after "switch (....":

PHP Code:

---

    case 'pending-echeck': 


---

Now it works!

Hope it helps,
Vygi

Quote:

---

Originally Posted by Ajeh

When you say the order does not show in your Zen Cart Admin ...

If you type in the orders_id on the search for order id:

Can you now see it?

If so, go to the Modules ... Order Totals ...

Is the Total ot_total installed?

If it is not installed, then the Order will not list on the display of Orders in the Admin ...

---

Kim, I have similar problem, the order do not show up in zc admin, but when I type order id on the search, the orders do show up, it just do not list there normally. and also, when coustomer login the order history is empty.

the Total ot_total is installed.

Do you know what possible went wrong? I use v1.3.7.

thank you!

When orders do not display in the Admin ... Customers ... Orders ... list but then do show if you type in the Orders # ... check the settings in:
Modules ... Order Totals ...

Do you have the Totals installed?

Without that, they will not show ...

NOTE: this will fix NEW orders not OLD orders ...

OLD orders could be fixed but would take a little manual work in the database tables ...

Quote:

---

Originally Posted by doubletiger

Kim, I have similar problem, the order do not show up in zc admin, but when I type order id on the search, the orders do show up, it just do not list there normally. and also, when coustomer login the order history is empty.

---

Additionally, the updated PayPal patch posted Feb 8 (and updated again on 15th) addresses some problems related to order-status not being set properly in isolated cases.
1. You should install the most recent patch files from this thread:
http://www.zen-cart.com/forum/showthread.php?t=56216

2. Then, turn ON the PayPal Express Checkout module. If it's already "on", then click Edit and save. If it was NOT already "on", then you can remove it again if you're not using it. Simply turning it on or editing its settings should apply some embedded fixes to the PayPal infrastructure.
The other files in the patch will help deal with the order-status updates being set.

3. You could further update "old" records by entering the following in the Admin->Tools->SQL Patch screen:

Code:

---

update orders set orders_status = 1 where orders_status=0;

---

This will set all the "missing" orders to "Pending" status. You can then manually update them appropriately.

Hi all,

Not to put a damper on these things but I have begun to get the same results as all of the previous posters.

I am using the latest version of zenCart, PayPal IPN, and followed the trouble shooting information in this entire thread.

What happens is when a customer selects the option to pay via credit card the order total is transferred but no data about the order. It does not appear in the database either under orders_products, but the transaction is stored under orders.

The log data shows one piece of information that may be helpful.
[SCR]Nov 09 2007 13:19 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us. [/SCR]

Any clue as to why this may be happening ?

Thank you

You said you're using "the latest version of Zen Cart".
Does that mean you're using "v1.3.7" or "v1.3.7.1" ?
Which PayPal Patch have you installed, if any?

I believe 1.3.7.1 - My admin module states "Your version of Zen Cart™ appears to be current"

I had installed the PayPal patch PPEC-137-patches-June17 when I was using 1.3.7

I have also enabled PayPal Express, but get the same results as with the IPN module. Only the price but no other transaction data is passed through to Paypal or stored in the database.


Thank you for the quick reply.

After looking at the screen, been working on this to long, I have verified that this store is using 1.3.7 which is what the link at the bottom of the admin pages tells me. Since I have already installed the patches, this is still an issue. I'll keep working on it.

I installed a fresh copy of 1.3.7.1 with no mods and setup my PayPal Express Checkout information. When i went through the order process, again there was no information on the order, just the total.

This leads me to believe that this is a paypal issue, is anyone else experiencing any similar issues?

Thank you

What addons/contributions do you have installed?
Can you post your PayPal debug logs?
http://www.zen-cart.com/forum/showthread.php?t=61199

The logs are located here, I posted one for expressCheckout and one for IPN. http://www.bostec.com/paypal_Logs.zip

The client is currently using the Environment Handling Fee module. Version 1.01 and the Auction Site attributes that goes with that module, version 1.06.

Thank you.

Paypal posted that they were having delays with the IPN today. But I do not know if that would still be affecting sites.

http://www.pdncommunity.com/blog?blog.id=mts_updates

The ipn log you shared is a transaction refund ... but the problem you were reporting seemed to be geared towards purchases, and not refunds.
Do you have logs from purchase transactions?

FYI ... there are often up to 8 log files with a given transaction. You only included one besides the ipn file.

I apologize for that,

I just grabbed two log files.

These are the files for an IPN and an ExpressCheckout.

I verified with IPNcheck.php and the curl check php file that my server is happy with Paypal. Everything checks out ok.


New logs http://www.bostec.com/paypal_log.zip

Thank you

I have to leave work, but I will log on in a couple of hours to see if those logs helped you out. I did not see any errors or warnings, but I do not look at paypal logs that often. My fresh install does not work either, is there something I may have configured wrong on PayPal?

Thank you,

Max

I'm not seeing anything useful in those logs.

I believe these IPN logs are more complete. http://www.bostec.com/ppLogs2.zip

Thank you again.

Unfortunately that's not a valid zip file, or is somehow corrupt.

Hello,

I apologize, but the last files did become corrupted some how. These IPN logs are not corrupt. http://www.bostec.com/payPal_logs2.zip

What tables can I look at in the database besides the orders table?

Thank you.

It seems the process of actually inserting the order record is failing. This is typically caused by changes to the order.php class or failure to load external scripts that are required by addons in the site that are not loaded during the IPN processing routines.

To turn on extra debug logging ...

create a new file:
/includes/extra_datafiles/ipn_debug_on.php

with this content:

Code:

---

<?php define('IPN_EXTRA_DEBUG_DETAILS', 'All');

---

Then do another IPN transaction, and post the IPN logs.

Hello Doc,

Thank you for your patience, it has been a hectic week so far at work. I have turned on the extra debugging features, and have posted the new logs here, http://www.bostec.com/payPal_logs3.zip

I looked at the orders.php and it was last modified as of 4/30/2007, that is when the store went live.

Thank you again for your help so far. I will see if I can track down any external scripts, though I do not believe there are any, as I do not get any javascript errors, but I will keep digging.

Can you go into your phpMyAdmin, select your store database, then select your "paypal" table, click on Export, choose "structure only" (ie: uncheck the "data" checkbox), click on Go.
This should give you your PayPal table structure.
Post that SQL output here.

I do not run PHP myAdmin but this should do the trick -- let me know if you need anything else.



-- Definition of table `bos_paypal`
--

DROP TABLE IF EXISTS `bos_paypal`;
CREATE TABLE `bos_paypal` (
`paypal_ipn_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`zen_order_id` int(11) unsigned NOT NULL DEFAULT '0',
`txn_type` varchar(32) NOT NULL DEFAULT '',
`reason_code` varchar(15) DEFAULT NULL,
`payment_type` varchar(7) NOT NULL DEFAULT '',
`payment_status` varchar(17) NOT NULL DEFAULT '',
`pending_reason` varchar(14) DEFAULT NULL,
`invoice` varchar(64) DEFAULT NULL,
`mc_currency` char(3) NOT NULL DEFAULT '',
`first_name` varchar(32) NOT NULL DEFAULT '',
`last_name` varchar(32) NOT NULL DEFAULT '',
`payer_business_name` varchar(64) DEFAULT NULL,
`address_name` varchar(32) DEFAULT NULL,
`address_street` varchar(64) DEFAULT NULL,
`address_city` varchar(32) DEFAULT NULL,
`address_state` varchar(32) DEFAULT NULL,
`address_zip` varchar(10) DEFAULT NULL,
`address_country` varchar(64) DEFAULT NULL,
`address_status` varchar(11) DEFAULT NULL,
`payer_email` varchar(96) NOT NULL DEFAULT '',
`payer_id` varchar(32) NOT NULL DEFAULT '',
`payer_status` varchar(10) NOT NULL DEFAULT '',
`payment_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`business` varchar(96) NOT NULL DEFAULT '',
`receiver_email` varchar(96) NOT NULL DEFAULT '',
`receiver_id` varchar(32) NOT NULL DEFAULT '',
`txn_id` varchar(17) NOT NULL DEFAULT '',
`parent_txn_id` varchar(17) DEFAULT NULL,
`num_cart_items` tinyint(4) unsigned NOT NULL DEFAULT '1',
`mc_gross` decimal(7,2) NOT NULL DEFAULT '0.00',
`mc_fee` decimal(7,2) NOT NULL DEFAULT '0.00',
`payment_gross` decimal(7,2) DEFAULT NULL,
`payment_fee` decimal(7,2) DEFAULT NULL,
`settle_amount` decimal(7,2) DEFAULT NULL,
`settle_currency` char(3) DEFAULT NULL,
`exchange_rate` decimal(4,2) DEFAULT NULL,
`notify_version` decimal(2,1) NOT NULL DEFAULT '0.0',
`verify_sign` varchar(128) NOT NULL DEFAULT '',
`last_modified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`date_added` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`memo` text,
PRIMARY KEY (`paypal_ipn_id`,`txn_id`),
KEY `idx_zen_order_id_zen` (`zen_order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Are there any PHP errors in your server's errorlog?

Unfortunately there are no php errors in the logs. I must have something configured incorrectly as the test install that I did on this same server is having the exact same issues. I will keep poking around trying to determine why this is not working. Thank you for your help so far.

Whatever's wrong is failing to insert records into the "paypal" table properly during the IPN processing stages.

I am having a very similar/same issue. This is my installation:

Zen Cart 1.3.7.1

Database Patch Level: 1.3.7.1

v1.3.7.1 [2007-09-18 10:31:48] (Fresh Installation)

I am using the PayPal IPN as my sole source of payment. I just made a test order - the PayPal part seemed to go fine - but - the order did not show up in Zen Cart anywhere that I can see, nor did it generate any emails, etc.

I am very new to Zen Cart and PayPal but have followed the instructions and everything seems okay. Again - the PayPal payment went through without issue.

Any ideas?

Quote:

---

Originally Posted by afinta

I am having a very similar/same issue. This is my installation:

Zen Cart 1.3.7.1

Database Patch Level: 1.3.7.1

v1.3.7.1 [2007-09-18 10:31:48] (Fresh Installation)

I am using the PayPal IPN as my sole source of payment. I just made a test order - the PayPal part seemed to go fine - but - the order did not show up in Zen Cart anywhere that I can see, nor did it generate any emails, etc.

I am very new to Zen Cart and PayPal but have followed the instructions and everything seems okay. Again - the PayPal payment went through without issue.

Any ideas?

---

I am having the same problem.

Rembrandt I am thinking 1 of 3 things - the port is not open that needs to be, the PayPal account has not been verified yet (since it is not mine but my client's), or - their is a permissions issue with the DB...

I like your avatar.

Quote:

---

Originally Posted by MuttOAOA

I am having the same problem.

---

Sorry for the scare... there was a typo in my PayPal address. My bad.

Quote:

---

Originally Posted by afinta

I like your avatar.

---

Thanks. It's a blending of my face and the painting. When I was at the Met I took a picture of me and the painting at the same time and got the same lighting. It was a fun little Photoshop exercise. ;)

Quote:

---

Originally Posted by afinta

I am using the PayPal IPN as my sole source of payment. I just made a test order - the PayPal part seemed to go fine - but - the order did not show up in Zen Cart anywhere that I can see, nor did it generate any emails, etc.

---

http://www.zen-cart.com/wiki/index.php/PayPal
Please post your debug logs.

Hi all,

I am still working on tracking this issue down.

Here is my server config

IIS 6 - up to date
PHP 5.2.1
MySQL 5.2.3

I installed the latest version of zenCart 1.3.7.1 with the sample store data

I then installed PayPal IPN per instructions yet I ended up with the same issue, of no order data being sent to paypal, just the order total. Could there be an issue with IIS that would prevent PayPal and zenCart from talking?

Thank you for all of the input and guidance so far:bigups:.