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

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.