PDA

View Full Version : Paypal IPN orders not being relayed to cart or emailed to owner or buyer


Pages : [1] 2

Pauls
12th May 2006, 06:07 PM
This PayPal problem has been discussed before, however I have tried the fixes and checked the settings, but PayPal will not send, or the cart will not allow PayPal to send the information required so that we know what the customer purchased. PayPal takes their money, paypal tells us that we have money, however paypal does not tell us what was bought or does any of this information appear anywhere in the cart.

Here are what I have tried so far

I have tried renaming the following file /includes/languages/english/lipstyle/meta_tags.php to meta_tags.php.bak but this did not seem to have an effect.

I then un-installed and re-installed the PayPal module from within Admin, this had no effect.

I have checked that the email matches perfectly the main email account in paypal.

I have this set (as suggested int the cart admin area) https://www.buystephenmackey.co.uk///ipn_main_handler.php ... this is pasted in the IPN place at paypal, only I am not convinced about the 3 ///'s ... however I left them like that in Paypal, as that is how the cart says they should be.

I have set the chmod settings on ipn_main_handler to 777 and it is in the root html folder of buystephenmackey.co.uk

I have set the autoreturn URL to this (suggested by the zen cart)
https://www.buystephenmackey.co.uk///index.php?main_page=checkout_process
this appears to work correctly as the shopper does get back to our site after paypal process.

I would be most grateful if someone could help in this regard, and suggest a fix as the shop is currently live, and we have had a couple of PayPal orders already and I am having to ask the customer for 'which items they bought' as I have no idea, only the amount they spent!

Please help if you can.

Ajeh
12th May 2006, 09:21 PM
Could you post from the server the /includes/configure.php without your username and password?

You appear to have errors in it ...

Pauls
12th May 2006, 09:28 PM
<?php
/**
*
* @package Configuration Settings
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/


// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
define('HTTP_SERVER', 'http://www.buystephenmackey.co.uk');
define('HTTPS_SERVER', 'https://wasp.xssl.net/buystephenmackey.co.uk');

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_CATALOG', '/');
define('DIR_WS_HTTPS_CATALOG', '/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

define('DIR_WS_PHPBB', '/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/var/www/html/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'buystephenmackey_co_uk_-_zen3');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'database');
define('DIR_FS_SQL_CACHE', '/var/www/html/cache');

?>

Ajeh
12th May 2006, 10:56 PM
Are you sure this is your path to your root directory?

define('DIR_FS_CATALOG', '/var/www/html/');

Also could you post your file, from the server, without your username and password for the:

/admin/includes/configure.php

Pauls
13th May 2006, 12:01 AM
Hi Linda, thanks for taking a look, I am not sure whether that would be the root, I am just taking the lead from my ftp client (smartFTP) and this is the path it reports /var/www/html ...... I can go lower than that of course, but that is where my zen cart installation folder is (index.php is there for example).

Below is the admin configure.php ... I am not convinced about the ///'s I added, I did ask a question about this the day the support site went offline, but due to the changes I never got a response ... I really hope you can help, thanks for trying.


<?php
//
/**
*
* @package Configuration Settings
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/


// Define the webserver and path parameters
// Main webserver: eg, http://localhost - should not be empty for productive servers
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
// HTTP_CATALOG_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_CATALOG_SERVER is your Secure webserver: eg, https://www.yourdomain.com
/*
* URLs for your site will be built via:
* HTTP_SERVER plus DIR_WS_ADMIN or
* HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or
* HTTP_SERVER plus DIR_WS_CATALOG or
* HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
* ...depending on your system configuration settings
*/
define('HTTP_SERVER', 'http://www.buystephenmackey.co.uk');
define('HTTPS_SERVER', 'https://wasp.xssl.net/buystephenmackey.co.uk');
define('HTTP_CATALOG_SERVER', 'http://www.buystephenmackey.co.uk');
define('HTTPS_CATALOG_SERVER', 'https://www.buystephenmackey.co.uk');

// Use secure webserver for catalog module and/or admin areas?
define('ENABLE_SSL_CATALOG', 'true');
define('ENABLE_SSL_ADMIN', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_ADMIN', '/mackey_admin/');
define('DIR_WS_CATALOG', '//');
define('DIR_WS_HTTPS_ADMIN', '/mackey_admin/');
define('DIR_WS_HTTPS_CATALOG', '///');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_CATALOG_LANGUAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_ADMIN', '/var/www/html/mackey_admin/');
define('DIR_FS_CATALOG', '/var/www/html/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', '*********');
define('DB_SERVER_PASSWORD', '****************');
define('DB_DATABASE', 'buystephenmackey_co_uk_-_zen3');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'database');
define('DIR_FS_SQL_CACHE', '/var/www/html/cache');

?>

Merlinpa1969
13th May 2006, 01:13 AM
define('HTTPS_SERVER', 'https://wasp.xssl.net/buystephenmackey.co.uk');

define('HTTPS_CATALOG_SERVER', 'https://www.buystephenmackey.co.uk');

these 2 lines are a problem as they dont match


define('DIR_WS_CATALOG', '//');

define('DIR_WS_HTTPS_CATALOG', '///');

these are lind of weird too....

Did you do this or did you let the installer autopopulate these fields

Pauls
13th May 2006, 07:48 AM
Thanks for looking Merlin, I added this

define('DIR_WS_CATALOG', '//');

define('DIR_WS_HTTPS_CATALOG', '///');

I don't know what they should be, I can tell you why I did it though. Basically when I was testing the cart I had the cart in a folder /zen3/ off the root, when I moved the cart to the root level I found some things didn't work, and those settings above made things work again. It was trial and error, and I did ask the question the day the old support site closed about these settings but nobody could answer because it closed. My question was could someone show me what the default settings are in those defines, on a site that is in the root folder.

https://wasp.xssl.net/buystephenmackey.co.uk that is the correct address for my secure SSL.

Pauls
13th May 2006, 02:28 PM
I corrected the SSL URL thanks for spotting that merlin, but still no joy ... it must be related to the forward slashes ... I reckon I broke it when dropping it to the root folder from the testing folder and manually changing the configs ... :(

Merlinpa1969
13th May 2006, 02:32 PM
I would suggest running the installer again,
point it to a NEW database,

then once the install is done manually change the database names in both config files,

that way the system sets the paths

Pauls
14th May 2006, 07:28 PM
Yes I did that and many other things, by the way the actual path to my secure server was as was but with only one / and NOT 3 of them ! :)

Still having problems, Ajeh has been trying to help me (she has the patience of a saint), but I am struggling now. In the 1.2.7 version I originally had a contrib installed, it was the min order contrib, I had this set up at 10UKP. Strangely I still find that the cart (v1.3.0.1) will not let me go to the checkout unless 10UKP or equivalent is spent. Its great, its what we needed but I think this may be the cause for the concern with PayPal. All the settings I have in my current cart are based on a *brand new* installation of 1.3.0.1 in another domain. Therefore I know my settings are correct, that is the one thing I do know.

However, I have looked using Beyond Compare, and other utilities at pretty much every file, and cannot see any remnants of the code above. I made the assumption that perhaps this was stowed in the database, but any searches within the database proved fruitless. I now have no idea what else to try, so I am opening this thread again to try and get other views.

I really don't want to have to delete everything, and start again that would be unaceptable but I do want to offer our customers the option to pay via PayPal. So my question is to anyone that might know ...

Which files are the files the cart uses to checkout with, I need to know all of the ones used in the process so I can scour them for any offending code left over from contribs, I am so frustrated, 3 whole days of trying various things and still no joy, I really hope someone can help in this complex matter, thanks for your time.

Pauls
15th May 2006, 10:46 AM
I have had a thought on what this problem might be, could it be that early on in my setting up of ZC I removed all of the zones in admin, would this affect PayPal IPN ? I need to get my zones back then ... how do I do that?

Pauls
15th May 2006, 05:26 PM
I fixed it !!!!!!!

The problem appeared to be related to the ipn_main_handler.php file, I took one that worked from my testing site, and replaced the one on my updated site. I am not sure why it worked, and it may have something to do with CHMOD settings. The ipn file that worked on my other server was CHMOD 644, yet I had been informed somewhere along the way that it should be set to CHMOD 777 or 755 hence my settings. It may have been that the file was not updated fully or correctly since i updated files manually in the first instance. I did previously however copy a brand new version from the v1.3.01 full installation zip but this didn't do any good.

So I have to say a massive thanks to Ajeh, and Merlinpa for their help in helping me try to isolate this problem.

I thought I should post the solution too, so that this post might be of use to others later.

Thanks.

Ajeh
15th May 2006, 08:10 PM
Thanks for the update ... it is always helpful to post the solution so that others on a similar quest can find an answer that may help them as well ... :smile:

megagumby
17th May 2006, 07:28 AM
Could someone please tell me where this 'ipn_main_handler.php' file is located as I want to see if mine is the same as Ive had exact same problems for weeks and happened out of nowhere where suddenly I had no record of orders only payments through paypal and customer was unable to go back to store after payment to download their product as the product would not show.

I have just upgraded my cart but still have the same problem. Have spoken to my server provider they said upgrade but still not working. So all you did was change the prermissions of that file and it was fine? Im hoping it is something as simple at that, although i never changed it in the first place.

Thanks,

Kirsten Smit
kirkyskreations.com/cart

megagumby
17th May 2006, 07:36 AM
ok i found file but mine is 644. .. so any other suggestions?

Pauls
17th May 2006, 09:06 AM
Did you try the known fix to this problem first? That is, rename the following file
includes/languages/english/YOURTEMPLATE/meta_tags.php to includes/languages/english/YOURTEMPLATE/meta_tags.php.bak ?

megagumby
17th May 2006, 10:10 AM
no i didn't Ill try this.. thanks

TheOracle
17th May 2006, 02:28 PM
@Pauls:

If this issue is about a contribution you recently installed on a previous version of Zen Cart, and is still installed under the newest version of Zen Cart, make sure it is fully compatible with the newests by readings the updates from the appropriate topic where the author originally posted his announcement on the forum. ;)

Perhaps there are more specific answers on that topic you'd be looking for. By reading, and posting, more definite answers could be returned to you.

This might simply be about an incompatible contribution subject. ;)

megagumby
18th May 2006, 07:24 AM
Did you try the known fix to this problem first? That is, rename the following file
includes/languages/english/YOURTEMPLATE/meta_tags.php to includes/languages/english/YOURTEMPLATE/meta_tags.php.bak ?

I dont seem to have 'my template' in this folder..

all I have is :

includes/languages/english/meta_tags.php

Sorry im not very experiennced with this I had alot of help setting up my cart.

Merlinpa1969
18th May 2006, 02:00 PM
make sure that your email address used in zen cart matches the primary email address used in paypal.com and that they are case equal
red Red and RED are all different in paypals eyes for purpose of IPN.

If this dosnt work try uninstalling and reinstalling paypal through your browser in admin-> modules-> payment

try replacing the ipn file located in your stores root file

TheOracle
18th May 2006, 02:32 PM
Also make sure to have followed the /docs folder's content correctly. It is possible you might of missed a step in the mean time.

As an alternative step, you can always read the FAQs on top of this site. :wink2:

Pauls
18th May 2006, 10:34 PM
make sure that your email address used in zen cart matches the primary email address used in paypal.com and that they are case equal
red Red and RED are all different in paypals eyes for purpose of IPN.

If this dosnt work try uninstalling and reinstalling paypal through your browser in admin-> modules-> payment

try replacing the ipn file located in your stores root file

Megagumby, you need to try each of the things posted above by merlinpa, and in that order, and TEST after each ... that is

email address must be accurate
UNINSTALL and then RE-INSTALL the paypal module from inside admin of your shop, this is very important as you have just upgraded to 1.3.x
last resort replace the ipn_main_handler file (search the install directory for it if you can't find it) from the original zip/archive.

I noticed something different with your method/problem too, you said your problem is the same as mine, well not quite. I never had a problem returning to the store, you appear to, this sounds like some return URL issue with paypal. This could be the problem, where does the paypal module in the cart tell you to set the IPN URL to?

Does the IPN URL above exactly correlate to the IPN URL you have set in PayPal?

giftbasketree
19th May 2006, 04:34 PM
I continue to have this problem and I have no idea how to fix it. I have tried everything suggested in this thread. I have not upgraded.

Also, when I go to the "Customers" drop down and go to "PayPal IPN" I see the following error:

1146 Table 'gbtree-zen.zen_paypal_payment_status_history' doesn't exist

I would appreciate any help that I can get. I feel the frustration of the other users. Not being able to see what the customer has purchased is almost laughable, unless you want to fill the order!!!

Thanks again.

megagumby
20th May 2006, 02:16 AM
OK totally stumped...

Ive reinstalled the paypal payment modules (TWICE)

I have changed that metatag.php file to metatag.php.bak (no difference)

I have gone into my paypal profile and done this -

Instant Payment Notification (IPN) URL: http://www.kirkyskreations.com/cart/ipn_main_handler.php


Website payment preferences - return URL: http://www.kirkyskreations.com/cart/index.php?main_page=checkout_process


I have also contacted paypal..

Here's what they have to say ( funny they sent me back to this exact forum topic)
-------------------
"Hi Kirsten,

I apologize for any inconvenience. I went to your site and put in a test order. 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: Kirky's Kreations
Amount: $10.00 USD

Typically with this kind of setup, you should be able to contact your cart support to see if you can get more information and perhaps change the order to an 'itemized' format so that they pass the items the customer ordered over to PayPal. However, if I remember correctly, Zen Cart is an Open Source cart, so there really isn't any support to contact.

I did a search on the Zen Cart forums and found this thread:

http://www.zen-cart.com/forum/showthread.php?t=35436&highlight=paypal

It seems that you can edit your current module to get it to pass over the order information, so you may want to read that thread to see if the fix works for you. If it doesn't, I would suggest searching for (or creating) a module that will pass over the individual item information to our server instead of the aggregate information. "

I was using my zencart fine for over a year, and this happened out of no where..
----------------

My cart has been not working for weeks now. Someone made an order yesterday in the time I was trying to fix the problem.. and I didnt even recieve the paypal verification this time... but everytime I test it I do recieve that.. The problem with my situation is because my products are downloadable zip files which they should be able to do straight after oder is made.. so im having to ask customers what they ordered and give them a coupon to make another order and download for free..

Sending out an SOS!

Kirsten Smit
http://www.kirkyskreations.com/cart

megagumby
20th May 2006, 02:24 AM
I noticed something different with your method/problem too, you said your problem is the same as mine, well not quite. I never had a problem returning to the store, you appear to, this sounds like some return URL issue with paypal. This could be the problem, where does the paypal module in the cart tell you to set the IPN URL to?


As for returning to the store it does return to the right place except the order it shows to download is dated in april, it's an old order.

The last known paid order that worked on my site was dated 25th April, since then the orders have stuffed up. My cart was working fine for over a year. And I made no changes to my cart during that time of april/may. Did paypal make changes during this time? I have just upgraded last couple of weeks.
:(

Pauls
21st May 2006, 03:11 PM
Your shop doesn't look like or appear to be ZenCart? It appears to be X-Cart or am I missing something ?

Regardless, I wish I could help you with your problem, but I don't have anything else to offer, sorry.

Kim
21st May 2006, 03:58 PM
Pauls-

Are you still having a problem? You know that payment modules will not work while a site is down for maintenance?

DrByte
21st May 2006, 10:33 PM
megagumby,

Your link to
http://www.kirkyskreations.com/cart/ipn_main_handler.php

took me to:
http://scrapbookbytes.com/store/manufacturers.php?manufacturerid=33/ipn_main_handler.php

So, either you have some odd redirects running, or your SEFU contribution is causing you troubles.

jeff
22nd May 2006, 12:45 AM
It seems that you can edit your current module to get it to pass over the order information, so you may want to read that thread to see if the fix works for you. If it doesn't, I would suggest searching for (or creating) a module that will pass over the individual item information to our server instead of the aggregate information. "


make the following changes in the paypal.php file:

includes/modules/payment/paypal.php

find the following line:

$telephone = preg_replace('/\D/', '', $order->customer['telephone']);

add the following code immediately following the above line:

$xx = '';
for ($i=0; $i<sizeof($order->products); $i++) {
$xx .= $order->products[$i]['qty'] . '-' . ($order->products[$i]['name']) . '**';
}


now change the following line:

zen_draw_hidden_field('item_name', STORE_NAME) .

to this:

zen_draw_hidden_field('item_name', STORE_NAME . ' ' . $xx) .


this will allow the cart contents (except for any attributes - I never figured out how to pass attributes) to be passed to PayPal so you will see a list of items ordered in yuor PayPal admin account activity listing

Justwade
22nd May 2006, 01:53 AM
Version 1.27

Before I try some of these suggestions, I would like to relay my own observations for whatever there worth, as I have not read the same somewhere else.
I been building my store for some time and have not gone live yet.
Last fall I set up Paypal IPN, did tests, and with kind help from this forum, got it working perfectly, email notifications and all. I have not changed the sight much since, other than things like Imagehandler, or usps shipping, and the upgrades from 1.26. Now I am testing everything again, want to go live soon.

I am noticeing when I use Zen cart with Explorer that paypal gives a choice of CC or sign on to Paypal. (I may have not tried this last year, as I prefer Firefox) I tried the CC side to see what happens, Paypal goes though the transaction, gives me the option "Return To Merchant", and test show it will return to Zen Checkout success page. but the admin does not get order. cart is still full, emails are only from paypal.

Firefox on a PC or a Mac will go to Paypal, "But there is no CC or Paypal choice". You get Paypal and sign in, go thru normal transaction and it auto returns to Zen like it should, cart is empty. But, then I "still do not get admin order", and only email from paypal.

Check or money order works fine.

I am still testing, but I wondered if Explorer always did offer a CC choice that other browsers did not, or ??. I am just trying to catch up.

Being I don't think I changed anything, (my /ipn_main_handler.php is chmod 644, the Primary email is exact) is it possible that Paypal IPN has made a change recently on their end?
Forgive me if this has been gone over somewhere, but I don't see it for the pixels.

Ajeh
22nd May 2006, 02:01 AM
For giggles ... jot down each setting before doing the remove and install ...

Go to Modules ... Payment ...

Remove, Install, Configure each Payment Module you have installed ...

WARNING: write down existing settings first ...

CAUTION: if you are not using it ... remove it and do not reinstall it ...


Go to Modules ... Shipping ...

Remove, Install, Configure each Shipping Module you have installed ...

WARNING: write down existing settings first ...

CAUTION: if you are not using it ... remove it and do not reinstall it ...


Go to Modules ... Order Totals ...

Remove, Install, Configure each Order Total Module you have installed ...

WARNING: write down existing settings first ...

CAUTION: if you are not using it ... remove it and do not reinstall it ...


Note: check the PayPal recommended settings for the PayPal site ... and confirm that you have them set correctly ...

Justwade
22nd May 2006, 02:12 AM
Wow Ajeh, that was fast, was that reply to me?

Your suggestions sound like my next step. I will let you know the outcome.

Wade

Ajeh
22nd May 2006, 02:35 AM
Yes Wade ... that one's for you ... let us know the results ... :smile:

Justwade
22nd May 2006, 03:37 AM
Well, I started by removing all module not used, even though they were set to false. Tried after that first, no luck.

Then it just hit me, and what is so frustrating is I have been down this road before.

I turned off password protection to my catalog. Jees.... the CC choice at Paypal worked perfect. Got all the emails, admin is showing order. Older I get the slower I learn.

Now I sorta remember from months ago reading that you should edit text to advice on making sure the customer "returns to merchant" when using a CC. I will test some more and not return to site to see what happens.

Thanks for your help, I needed the boost.

Wade


P.S. Does Paypal only show CC's or Paypal choice with Explorer on a PC?

Ajeh
22nd May 2006, 03:39 AM
PayPal does not show anything on the Zen Cart checkout_ pages other than a selection via Radio Button ...

All of the processing for Credit Card is done on PayPal Site ...

The Credit Card info you see in checkout_ is NOT PayPal but one of the Credit Card Payment Modules that you have installed ...

NOTE: I would still complete the save/remove/install on everything ...

Justwade
22nd May 2006, 05:10 AM
Just in case I have miscommunicated,

What I found in my earlier tests was after I confirmed a normal order on Zen cart, that is choosing to pay with paypal (no "credit card" choice shows because that module was installed in the past, then it was turned to false, and today after your suggestion removed) Then after the confirm you leave Zen and are "diffently" sent to Paypals website.

I do not have paypal pro.

When and only when I used Explorer as a browser the "Paypal website comes up with a window, "Checkout" left side says "Don't have a Paypal Account?", right side "Have a Paypal Account?". I used the don't have side, and the succesful transaction leaves you with a button to return to merchant at the end.

But Firefox or FF on a Mac does "not" give this choice, that is only a Paypal log in, payment choices then can be used, and is automatic to the end with auto return to zen. I havent tried more tests again yet, sorta got burned out. But I see your logic, sets up a good foundation. Some remnent of code allowing wrong page to show? I will push further.


Wade

giftbasketree
22nd May 2006, 10:21 PM
I have tried all the suggestions. With the help of Jeff I am able to see the name of the product. So, that's a good start, but not really the solution I'd like. I'm really new at this so I'm not sure what information I can give that would help you guys understand my problem. It's pretty much been identified by the other users. The one thing that does confuse me is some of the users are pointing to the ipn_main_handler file for the PayPal IPN notification. Mine says to use:

http://www.giftbasketree.com/index.php?main_page=checkout_process

So, is this part of my problem? I changed it to the ipn_main_handler.php too and tested it to no avail.

I'm so clueless. I get the email from PayPal saying the money is there, but like with others, no order and no email confirmations. I also had my email set up to send my cell phone a text message. That isn't happening either.

Thanks for all of those trying to help all of us who can't figure this out! We appreciate it.

megagumby
23rd May 2006, 10:44 AM
Your shop doesn't look like or appear to be ZenCart? It appears to be X-Cart or am I missing something ?

Regardless, I wish I could help you with your problem, but I don't have anything else to offer, sorry.

I had my store redirected to another store I sell products at because I have not had sales for almost a month now...

megagumby
23rd May 2006, 10:49 AM
make the following changes in the paypal.php file:

includes/modules/payment/paypal.php

find the following line:

$telephone = preg_replace('/\D/', '', $order->customer['telephone']);

add the following code immediately following the above line:

$xx = '';
for ($i=0; $i<sizeof($order->products); $i++) {
$xx .= $order->products[$i]['qty'] . '-' . ($order->products[$i]['name']) . '**';
}


now change the following line:

zen_draw_hidden_field('item_name', STORE_NAME) .

to this:

zen_draw_hidden_field('item_name', STORE_NAME . ' ' . $xx) .


this will allow the cart contents (except for any attributes - I never figured out how to pass attributes) to be passed to PayPal so you will see a list of items ordered in yuor PayPal admin account activity listing


Thanks... but ahm this is well and good .. but will the customer be shown their order after purchase? , my customers need to return to store so that they can download their product. In a way it is more important for them to be able to see what they ordered so they can get their product that they just paid for. I am not sending them their product they have to download their virtual products immediately after purchase or be able to return to store within 10 days or so to go back to their order and download it when they like...

:(

whocaresanyway
23rd May 2006, 01:12 PM
mega turn your PMs on.

in user cp
edit options

poosk
26th May 2006, 01:12 PM
glad to see someone else is struggling with this one aswell.
I've tried everything what is stated in this thread and probably much more and spent about hundred dollars for paypal fees. I'm using 127 and I've tried the earlier version paypal files aswell.
If anyone was able to solve this problem PLEASE post your solution to here. Is there anything else what should be configured in the paypal than return address and ipn_handler.php address?
The checkout success displays the order number as zero and no confirmations is sent from zen. and the orders doesnt display in the admin either...
Could this problem result from using ssl on zen. I tried to use url in paypal options with https and just http and it didnt help either

I tried jeff's solution aswell but it just led to error on the zen checkout

TheOracle
26th May 2006, 02:08 PM
I tried to use url in paypal options with https and just http and it didnt help either



Perhaps your web hosting service improperly configured your SSL settings over your site. I'd send them a support ticket message in order to resolve this problem. :wink2:

poosk
26th May 2006, 02:21 PM
nah i dont think so. i've had same ssl certificates and hosting for over two years and everything has been smooth to this very day.

TheOracle
26th May 2006, 02:23 PM
Strange. If you check your filters, from your cPanel access, or either your returned URL from your Paypal account, are you sure there both properly configured ?

whocaresanyway
26th May 2006, 02:57 PM
after reading old posts it dosnt matter what you have set in paypal for IPN and return url. it seems zen sends over ride information

also I have seen about 30 instances where the problem was the email address didnt match,

I have determined that the primary email address from paypal must be used in zen cart and that they must be spelled exactly the same ( including capital letters )

paramon
26th May 2006, 10:26 PM
Hi guys,

I have PHP version 5.0.4, MySQL version 4.1.18-standard
under Linux and zen_cart (1.3.0) also I have the same problem as Pauls had and now Kirsten Smit has - ipn_main_handler.php doesn't work properly.

I made the changes:
for ($i=0; $i<sizeof($order->products); $i++) {
$xx .= $order->products[$i]['qty'] . '-' . ($order->products[$i]['name']) . '**';
}

zen_draw_hidden_field('item_name', STORE_NAME) .
to this:
zen_draw_hidden_field('item_name', STORE_NAME . ' ' . $xx) .

but returned string can have only up to 128 characters(means 6-7 product names), all other truncated.

My question is the next, if somebody has working file ipn_main_handler.php could he or she send me this file on my e-mail mail_nz######################

I hope it will work as in Pauls case

Regards

Eugene

Vger
26th May 2006, 11:21 PM
I know you resolved your immediate problem, but you will have other occasional problems because of this setting:

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty

Your site is hosted on a Red Hat Enterprise Linux server, for which the correct setting is:

define('DB_SERVER', '127.0.0.1'); // eg, localhost - should not be empty

Set to 'localhost' it will work much of the time, but occasionally you'll find that your site won't connect.

Vger
I fixed it !!!!!!!

The problem appeared to be related to the ipn_main_handler.php file, I took one that worked from my testing site, and replaced the one on my updated site. I am not sure why it worked, and it may have something to do with CHMOD settings. The ipn file that worked on my other server was CHMOD 644, yet I had been informed somewhere along the way that it should be set to CHMOD 777 or 755 hence my settings. It may have been that the file was not updated fully or correctly since i updated files manually in the first instance. I did previously however copy a brand new version from the v1.3.01 full installation zip but this didn't do any good.

So I have to say a massive thanks to Ajeh, and Merlinpa for their help in helping me try to isolate this problem.

I thought I should post the solution too, so that this post might be of use to others later.

Thanks.

megagumby
28th May 2006, 12:06 PM
my PMS are on that is weird..

I am still having same problem.. so frustrating. What has changed to make this happen would be a start to solving this problem. I have contacted my server provider they said there's nothing that could have changed to affect it. Then I contacted paypal they told me what I posted a few messages ago. Im wondering if I create a whole new cart and test it if I will still have the problem. It's a shame cos I really don't want to take much more time on this..

Kirsten Smit
http://www.kirkyskreations.com/cart

Kim
28th May 2006, 02:50 PM
Are you trying to test and fix PayPal with your site down for maintenance?

tuffy
28th May 2006, 09:16 PM
I am having this issue as well with clean install of ZC...

you guys are saying that the email must be the same throughout zencart and your paypal email setting.

could you please be more specific...what email option in zencart?
the settings under configuration > e_Mail options

or the admin email under tools > admin settings> ??

Ajeh
29th May 2006, 12:42 AM
Modules ... Payment ... PayPal ...

Edit ...

It asks for your PayPal email address ...

If your email address is:

mYNameIsfReD@myDOMAin_NaME.com

You must type it exactly like that in the configuration on your Zen Cart PayPal Payment Modules ...

It is case sensative and must also be set as the PRIMARY email address ...

tuffy
29th May 2006, 01:25 AM
It is case sensative and must also be set as the PRIMARY email address ...

thanks for the quick reply, but can you specify PRIMARY email address? where is that option?....is it paypal option or what?

primary email of the cart?

email where the copys of the invoice are sent?

: [

Ajeh
29th May 2006, 01:34 AM
Go to your PayPal account ... which of course is a Business Account ...

Next, check your email addresses for this account ...

What is the one marked PRIMARY?

Copy and Paste this email address MakE_SUrE_yOu_wRiTe_it_CaSEsenSaTive in your Zen Cart settings for the PayPal Payment Modules ...

tuffy
29th May 2006, 01:37 AM
let me confirm also that the payment goes through great, but the cart does not take record of it, and it does not email the buyer or the store.

I have the email options of send copy to in email - options diffrent than the paypal email...is this the issue?

tuffy
29th May 2006, 02:06 AM
Go to your PayPal account ... which of course is a Business Account ...

Next, check your email addresses for this account ...

What is the one marked PRIMARY?

Copy and Paste this email address MakE_SUrE_yOu_wRiTe_it_CaSEsenSaTive in your Zen Cart settings for the PayPal Payment Modules ...

ok, that is all correct.

i'm lost :\

this is killing me

Kim
29th May 2006, 02:11 AM
in your /docs/ directory are complete instructions for setting up your PayPal module and your PayPal account to work together.

tuffy
29th May 2006, 03:04 AM
in your /docs/ directory are complete instructions for setting up your PayPal module and your PayPal account to work together.

i've got it all configured right apparently..the transactions go through, but just like the title of this thread, the orders are not being relayed to hte cart and no one is receving emails...you cant ever tell what people order!

Merlinpa1969
29th May 2006, 03:09 AM
tuffy

Open paypal.com
hit the profiles link on the right of th eheader nav bar

Now hit the email link at the top of the left column

You will see email addresses there
1 of them says primary beside it,

make sure that the email address that you see there is the one you are uising in the paypal module of your zen cart store.

Make sure that you have the return URL turned ON ( paypal.com )
make sure that you have the paypal IPN turned on ( paypal.com )

Try and re-upload your ipn_main_handler.php file

make sure that If you are using seo urls that you have added the fix for paypal..

make sure that your ipn_main_handler.php isnt password protected and that you are NOT down for maintenance

Ajeh
29th May 2006, 03:10 AM
If I were to make an order right now on your site utilizing PayPal ...

1 Would you see it at paypal.com

2 Would you get an email from paypal.com

3 Would I, the customer, get an email from your site?

4 Would you, the admin, get an email from your site?

5 Would you see the order at all in the Admin ... Customer ... Orders?

6 Would I, the customer, see on checkout_success, the completed order?

7 Would I, the customer, see the order in my Account History?

tuffy
29th May 2006, 03:21 AM
If I were to make an order right now on your site utilizing PayPal ...

1 Would you see it at paypal.com --- yes

2 Would you get an email from paypal.com --- yes

3 Would I, the customer, get an email from your site? --- no : [

4 Would you, the admin, get an email from your site? --- no : [

5 Would you see the order at all in the Admin ... Customer ... Orders? --- no : [

6 Would I, the customer, see on checkout_success, the completed order? --- yes

7 Would I, the customer, see the order in my Account History?--- no

with this being said and reviewing this thread, I'm assuming it is something wrong configured wiht the ipn_main_handler file, however I have replaced it with one from the zen-cart-v130-changed files only zip file.

I have tried it with the CHMOD set to 644 and 777.

I have deleted the includes/modules/payment/paypal directory and put the one from the full fileset in it.

I can not check the paypal settings, due to the fact that it is a customer and I dont have their info.

Ajeh
29th May 2006, 03:26 AM
1 use the right ipn_main_handler.php from the correct v1.3.0.1

2 write down all settings in the Modules ... Payment ... PayPal ...

3 Uninstall PayPal ...

4 Reinstall PayPal ...

5 Reconfigure PayPal using the settings you wrote down ...

If this still fails ... you will have to wait until you can get access to your customer's PayPal account to check the settings ...

tuffy
29th May 2006, 03:27 AM
tuffy
Try and re-upload your ipn_main_handler.php file

make sure that If you are using seo urls that you have added the fix for paypal..

make sure that your ipn_main_handler.php isnt password protected and that you are NOT down for maintenance

I re-upped the file, and I contacted the customer earlier to verify the details of the paypal profile.

it is entered correctly in the paypal ipn under admin>payment modules.

the ipn_main_handler should not be password protected, Id ont know how that would happne, neither do I know how to change that.

tuffy
29th May 2006, 03:37 AM
1 use the right ipn_main_handler.php from the correct v1.3.0.1

2 write down all settings in the Modules ... Payment ... PayPal ...

3 Uninstall PayPal ...

4 Reinstall PayPal ...

5 Reconfigure PayPal using the settings you wrote down ...

If this still fails ... you will have to wait until you can get access to your customer's PayPal account to check the settings ...

done and done, still failling

ill verify the settings with paypal in the morning

let me verify now however that SSL does not have to be enabled for this to work right : [
I dont see a reason it should be, but I was reading hte first posts and realized they had a certfiaget

Ajeh
29th May 2006, 03:51 AM
You do not need secure ... but customers are happier if your checkout is secure ...

Merlinpa1969
29th May 2006, 03:57 AM
Tuffy,

Alot of times customers say Yepp thats it with out ever checking the address,
I have seen that a bunch of times.. and then you will finally get them to look and they have

Red@red.com in paypal.com

and red@red.com in zen cart pay mod....

they say they are the same however paypal dosnt see it that way

For purposes of logging in and IPN these are 2 totally different things

tuffy
29th May 2006, 04:13 AM
Tuffy,

Alot of times customers say Yepp thats it with out ever checking the address,
I have seen that a bunch of times.. and then you will finally get them to look and they have

Red@red.com in paypal.com

and red@red.com in zen cart pay mod....

they say they are the same however paypal dosnt see it that way

For purposes of logging in and IPN these are 2 totally different things

yeah, when I talked to her and asked her to verify her primary email address seh said "blahblha@blah.com"

then I asked about the case and she said "the first letter, B, is the only one uppercase"...so, i'm pretty certain those are both right.
she said IPN is turned on by default when she inputted that field..so i dunno, im lost

Merlinpa1969
29th May 2006, 04:15 AM
You need to have them setup a temp user for you,.
Go in and VERIFY that IPN is turned ON,
its NOT turned on by default.
make sure auto return is turned on
and make sure that the email is correct.

Once you are done then they can remove the user account

tuffy
29th May 2006, 04:20 AM
ah, ok, I didnt want to ask the username/pass but I didnt know they could create a new account temporarliy..thanks for the input, that could be the whole issue (ipn not enabled)...i'll get an account created first thing in the morning and check everything out.

thanks for all your time, you guys are great.
i'll return back to this thread tom morning.

Jood
29th May 2006, 03:48 PM
Thanks Ajeh - your post about uninstalling and reinstalling modules got mine working. The problem I had was that I was testing it using free shipping. My shipping order total module wasn't set up to take free shipping.

Pauls
29th May 2006, 03:56 PM
I know you resolved your immediate problem, but you will have other occasional problems because of this setting:

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty

Your site is hosted on a Red Hat Enterprise Linux server, for which the correct setting is:

define('DB_SERVER', '127.0.0.1'); // eg, localhost - should not be empty

Set to 'localhost' it will work much of the time, but occasionally you'll find that your site won't connect.

Vger

Thanks Vger, fixed this on my new shopping cart venture ....

It's good to see many people fixing issues with paypal here, just as an aside the ipn_main_handler file (in version 1.3.01) should be 7k in size and CHMOD 644.

zohe
29th May 2006, 04:13 PM
Hello All

I too am having problems making this work.
Tried everything in this post and best i've got so far is Jeffs addtion of code that at least now in Pay Pal i know what product (s) people have ordered.

However
0. It does not register as a new order in Admin/ Order view
1. It does not register as a new order in Customer Account View
2. Customer gets no email of their order
3. Admin gets not confirmation of order
4. Don't get the IPN in admin
5 Inventory count for product(s) does NOT reduce/decrease

Nothing happens basically in Zen Cart Admin as if the order was not placed at all.

Now I don't know whether to leave pay pal option installed and watch my email / pay pal account like a hawk to see if any payments have been made

or just switch it all off and give up on pay pal.
I never got it working in 1.2.7 and am making no progress in 1.3.0.1

I have got the exact email address
I have got auto return on
I have installed and re installed pay pal module
I have got the most current version of ipn_main_handler.php
I have done everything else!

Any ideas anyone?

For all those that did not / could not get it working....

Did you / do you have the UK Switch payment module by NetworkDad installed?
Just wondering if they might be clashing? This is pure speculation on my part and i am no wear close to being a "coder". And the Switch Card module by NetworkDad is great!

Thanks
Zohe

Merlinpa1969
29th May 2006, 04:40 PM
how about a url to the store

zohe
29th May 2006, 04:48 PM
Dear Merlin

Oops! Might be useful mighn't it!

Here it is

www.epicheroes.com

Thanks
Zohe

tuffy
29th May 2006, 05:20 PM
For all those that did not / could not get it working....

Did you / do you have the UK Switch payment module by NetworkDad installed?
Just wondering if they might be clashing? This is pure speculation on my part and i am no wear close to being a "coder". And the Switch Card module by NetworkDad is great!

Thanks
Zohe

for the record, I do not have the "UK Switch payment module" installed, and I am having the same issue as you.

tuffy
29th May 2006, 05:41 PM
Thanks Vger, fixed this on my new shopping cart venture ....

It's good to see many people fixing issues with paypal here, just as an aside the ipn_main_handler file (in version 1.3.01) should be 7k in size and CHMOD 644.

paul, my ipn_main_handler is like 7.4k, however when I go to cPanel file manager, the file permissions on ipn_main_handler is set to 666, I change it to 644 and click save but it doesnt work, I go back and its still set to 666.

could this be the issue?

I see no way this could cause what is happening.

Merlinpa1969
29th May 2006, 06:04 PM
that dosnt matter tuffy,
your problem is either an email issue or a corupt file issue

how about a URL to look at
What zen cart version

tuffy
29th May 2006, 07:36 PM
Merlin, attempting to fix the issue I pretty much broke the entire cart.

luckily I have everything backed up and all the files I changed noted, thanks for your time, i'll get back when I get everythign re-installed and setup...hopefully that will fix the problem and I wont have to worry about it anymore : )

Merlinpa1969
29th May 2006, 08:09 PM
what were you messing with,
all settings needed to be changed in admin or in paypal.com

or by swapping out a file entirely

tuffy
29th May 2006, 08:46 PM
I swaped out the main_handler file entirely already with the correct one, I set everything up in admin correctly, and I obtained login to paypal and verified all the settings.

I uninstalled / reinstalled the paypal module, I deleted the entir epaypal directory and swaped out all those files with ones from the zip, and still no luck.

one consideration I just thought of that doesnt seem like it woudl effect anythign is the fact that I have cPanel configured to redirect the main domain to the sub directory (catalog) where the files are.

but I assume many people do that here.

the thing that broke it is me messing with folder permissions, dont ask what happened :P i'm newb.

either way, it'll be up tonight when I get out from the sun and re-configure the cart...hopefully working.

sbunny05
3rd June 2006, 06:19 AM
This is my email from PP:
Hi Molly,

I'm not aware of any issues with IPN currently, it sounds like the issue is being caused by the way the POST is being parsed or handled.

Are you not getting the IPN POSTs at all? Assuming your script is supposed to update your database, are you seeing any entries or nothing at all? What do your server access and error logs show?

I went to your site and put in a test order. When I look at the code your cart is sending to us, it looks like they are trying to send all of the items ordered in one item name, which can get truncated since there is a 127 character limit. I'm not too familiar with the different modules for ZenCart, so I am not sure if there is a module that will let you upload the individual item information. For more information on passing individual item information, please visit https://www.paypal.com/cgi-bin/webscr?cmd=p/pdn/howto_checkout-outside#methodtwo

Soooo.............. it looks as if all we need to do is add some code to a certain file or two. Anybody know which files within Zen we can try this on????????

Merlinpa1969
3rd June 2006, 03:21 PM
sbunny,

If you will please follow the instructions in the docs file of your distro for proper setup.

make sure that your PRIMARY email address from paypal exactly matches the one in the module

that you are NOT down for maintenance
NOT redirected
NOT using seo urls ( with out the patch )
and that your IPN file isnt corrupt...

The paypal module may seem like a PITA to set up but it works just fine,
so you will not have to add any extra code anywhere

IF you are sending all of the item names then you have already changed something,

because by default zen cart only sends the cart name as the item...

poosk
7th June 2006, 07:40 PM
So good to see you back in here with the magic Merlin!

well it wasnt so hard after all... I just missed the patch (can be found here: http://www.zen-cart.com/forum/showthread.php?p=152157&highlight=paypal#post152157)

I am so happy you can't believe...

although it directs back to store front page instead of checkout success and it doesnt empty the cart.. so if I'm using seo urls should I put different return address to paypla instead of https://www.cccc.com/shop/index.php?main_page=checkout_process
?

but it does send the zen confimation emails now and paypal ipn in the admin works!

Merlinpa1969
7th June 2006, 08:06 PM
you need to do the fix for seo and paypal

poosk
7th June 2006, 08:18 PM
you need to do the fix for seo and paypal

sorry for being dumb but how do I do that?

adris72
12th June 2006, 08:30 PM
Hello All

I too am having problems making this work.
Tried everything in this post and best i've got so far is Jeffs addtion of code that at least now in Pay Pal i know what product (s) people have ordered.

However
0. It does not register as a new order in Admin/ Order view
1. It does not register as a new order in Customer Account View
2. Customer gets no email of their order
3. Admin gets not confirmation of order
4. Don't get the IPN in admin
5 Inventory count for product(s) does NOT reduce/decrease

Nothing happens basically in Zen Cart Admin as if the order was not placed at all.

I have got the exact email address
I have got auto return on
I have installed and re installed pay pal module
I have got the most current version of ipn_main_handler.php
I have done everything else!


Those words exactly describe my situation too. I'm not using SEO url, I'm not down for manteinance, I deleted/installed paypal module several times, I replaced and chmod Ipn_main_handler.php and I've been sending money to my client paypal account all day, without it showing in the backend... I don't know what else to do!! (can be my hosting ... because I have several Zen Cart Installations in other hostings without problem)

http://www.herbtoseed.com

Zen Cart version: 1.3.0.1 fresh installation

Server Host: (69.45.6.155) Database Host: localhost (127.0.0.1)
Server OS: Linux 2.6.16-1.2108_FC4 Database: MySQL 4.1.19
Server Date: 06/12/2006 15:27:06 Database Date: 06/12/2006 14:27:06

Server Up Time:
PHP Version: 5.0.4 (Zend: 2.0.4-dev)
HTTP Server: Apache/1.3.34 (Unix) PHP/5.0.5 mod_accounting/0.5 FrontPage/5.0.2.2635 mod_perl/1.29 mod_deflate/1.0.21 mod_ssl/2.8.25 OpenSSL/0.9.7f

heidikfi
12th June 2006, 09:10 PM
Hi,

today I solved my similar problem.
Check with your server provider that the ports you use are open Both Ways.

Hope this helps.

andy
12th June 2006, 10:18 PM
Im have the same problem with Paypal as it seems everyone has, and i cant fix it, tried everything in this thread except the new ipn handler file, as i cant download the new version, ive tried for two days on and off and the download page just sits there with only the advert loaded

can this file be got from antwhere else?

thanks

Andy

Merlinpa1969
13th June 2006, 12:48 AM
http://sourceforge.net/project/showfiles.php?group_id=83781&package_id=171544

Ok....

and just for the record ( the most common cause of paypal and later embarassement )
is the email address that you have in zen cart paypal module the exact same as the one in www.paypal.com profiles email with the PRIMARY tag next to it and its case sensitive....

andy
13th June 2006, 06:24 AM
thanks for the link, but i get to the 2 files to down load, click eith link anf the next page loads the adverts at the top and nothing else

can the ipn handler be emailed?

mty primary email is correct

Andy

adris72
13th June 2006, 02:53 PM
For all the people that can't solve this, contact your hosting company.
This is what they told me:

"The problem seems to come from our firewall restrictions. Can you please specify the locations your shopping cart needs to connect remotely so that we can fix it."

Hope this can help someone in the future.

scrappy
14th June 2006, 09:06 PM
I have read this thread with interest, as I have three zen sites. I have set them all up the same way and they are all hosted on the same server. However, two of them have this paypal issue and the other doesn't!!

Strange. :down:

Merlinpa1969
14th June 2006, 10:59 PM
do they all use the same email address?

scrappy
15th June 2006, 10:09 AM
The one which works fine has its own email address, but the other two go to the same paypal account. Do you think this is the problem? I can always set up another paypal account for the third site.

Cheers!

Merlinpa1969
15th June 2006, 10:12 AM
you can point all three of them at the same paypal account.
just make sure that you are using the PRIMARY email address for all of them.

and that its case sensitive

scrappy
15th June 2006, 10:20 AM
They are pointed to the primary email address, and its all lower case anyway so thats all fine. It just seens really odd that as far as I know they are all configured the same and are hosted on the same server, use the same ISP and yet two don't work and one does.

Basically I get a payment notification, but the order doesn't exist in zen.

Merlinpa1969
15th June 2006, 10:22 AM
are they both business accounts?

you have something configured different in the 1 store

scrappy
15th June 2006, 10:29 AM
They are both business accounts. I guess there must be a difference somewhere, I will have to keep searching!

Merlinpa1969
15th June 2006, 10:41 AM
and you have the return url and IPN settings in the second paypal account active...

try this take one of the stores that dosnt work,
change the email address in the paypal module for that account to the same as the one thats in the working store...
run a quick $1 free shipping test and see if it works.

andy
15th June 2006, 10:12 PM
Hi
ive updated the ipn_main_handler.php, thanks for marianne who emailed it to me and it still does not work

what do i do, ive check and re checked the primary email address

thanks

Andy

franham
16th June 2006, 04:23 AM
I'm running version 1.2.4 (yes I know I need to upgrade). I haven't been having any problems until this week when two orders did the same as everyone has described above.

BUT most orders are being successfully processed. I only use paypal. So I asked myself what is different about these orders???

So I looked at the transaction details and the difference for the ones that are not being returned and entered into zencart are THEY ARE UNREGISTERED PAYPAL USERS - i.e. they are paying with their credit card but do not wish to have a paypal account.

So I would say it is a paypal issue but how do we fix this?

franham
16th June 2006, 04:46 AM
hmmm, but last week the same person successfully processed an order as an unregistered paypal user. So what has changed since last week??? Guess I'll be talking to my host.

heidikfi
16th June 2006, 01:41 PM
Hi,
make sure the host hasn't closed the outgoing traffic from the server to PayPal.
That was my problem, the host said the port is open, but it was open only for inbound traffic, not outbound.
As soon as they opened the port for outbound, my problems were over.

franham
17th June 2006, 03:15 AM
they said port 80 is open both ways

24#Karat_fan
17th June 2006, 03:16 AM
also check port 443 if you are using ssl

DrByte
17th June 2006, 04:56 AM
A collection of tips is posted here:
http://www.zen-cart.com/wiki/index.php/Admin_-_Modules_-_Payment#How_Do_I_Set_Up_The_PayPal_Payment_Module.3F

franham
17th June 2006, 06:01 AM
I'm having them check that right now. I just had another order processed by paypal that didn't return the info to the cart :(

rohitsax
17th June 2006, 08:12 AM
This really is frustating - after having the enrire cart setup and having paypal integrated as per the directions - no paypal order shows up in Admin.

I've tried (possibly) everything... the payment happens but nothing in the cart - so I dont know what was ordered.

PLEASE if someone has a CLUE please help!!!!

Ajeh
17th June 2006, 08:05 PM
Did this work for you when you were testing your site before you went live?

franham
17th June 2006, 10:59 PM
my cart has been up and live for several years running with no problems and now just this past week orders are not coming through. Paypal is receiving the orders and accepting payment, I receive notice from paypal that I have money but no orders show up in zencart. Why would this happen all of a sudden? I've checked with my host and they have made no changes at the server and I have made no changes to my cart. Seems to me it has to be a change at paypal as to how they are returning information.

Anyone have any ideas???

franham
18th June 2006, 02:12 AM
So I've been reading lots of boards and found this 'trick' somewhere.

I logged into paypal and I refunded a penny to the orders that didn't return to my shopping cart. Paypal then entered the orders into zencart for me!!!!

Any ideas??

It isn't because the didn't click on the button to return to website button because I did two test orders and made sure I clicked on the button to return to my store and those two orders didn't get entered into zencart either.

baffled

Ajeh
18th June 2006, 04:34 AM
I would really recommend an upgrade to at least v1.2.7 where a number of PayPal quirks were re-written and handled to avoid these issues ...

Probably it would be best to backup both your site and database ... then setup a test site with all of the Live Site files in it, then a new database and load a copy of the Live Site database into it ...

Update the 2 configure.php files for the new paths and new database ...

Make sure it works like the Live site ...

Then install v1.2.7 and run the /zc_install and upgrade your test database ...

Go to all Payment, Shipping and Order Total modules and write down the settings ... then uninstall and reinstall them ...

Test your test site ... does it work?

If so, then you can take the Live Site Down for Maintenance ... backup the Live site database ...

Drop the tables for the test site database ... and reload your fresh Live site backup ...

Again, run the /zc_install and upgrade the database ...

Again ... Go to all Payment, Shipping and Order Total modules and write down the settings ... then uninstall and reinstall them ...

Test all ... if working perfectly ... you can edit the 2 configuration files and set them to match your Live Site paths ... not the database as you are now switching the test database to be the new Live database ...

Rename the old site /old_shop

Rename the test site /what_ever_your_live_site_was

Test ...

If all is well you can take off the Down for Maintenance ...

rohitsax
18th June 2006, 06:26 AM
I use 1.3.0 version which I installed recently. And PayPal still doesn't work. I have made all settings as required.

In this thread there was a reference to some patch that is required to be used. That's the only option I haven't tried.

Can someone explain if that is required in 1.3.0 version also? If so where can I get it?

Thanks and regards
Rohit

jesphoto
18th June 2006, 07:06 AM
After I press the checkout button this is what I get.
I am trying to set for download pictures
https://jesphoto.net/zenshop/index.php?main_page=checkout_shipping
then show that page not found(404)
Any idea where I mess up?
Thanks

heidikfi
18th June 2006, 12:45 PM
Hi jesphoto,

at least your Euro is wrong. The euro is worth 1.2xxx dollars, not the other way around. And yes, I get the 404 error.
Either permission issue, wrong url or ssl port closed.

24#Karat_fan
18th June 2006, 02:27 PM
You have the wrong url for your SSL

jesphoto
18th June 2006, 04:24 PM
where do I fix the url for ssl?
Do I have to run install again?
I still have the dir just renamed.
Thanks

heidikfi
18th June 2006, 08:53 PM
http://www.zen-cart.com/forum/showthread.php?t=38526

jesphoto
19th June 2006, 02:09 AM
I had similar problem and fixed just as I look in someone else config.php
I noticed that in admin/include/config.php are 2 lines what do not exists in shop/include/config.php
tdefine('HTTP_SERVER', 'http://www.buystephenmackey.co.uk');
define('HTTPS_SERVER', 'https://wasp.xssl.net/buystephenmackey.co.uk');

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'true');
hose 2 lines applay to defineSSL

those are from admin/include/config.php
define('HTTP_SERVER', 'http://www.buystephenmackey.co.uk');
define('HTTPS_SERVER', 'https://wasp.xssl.net/buystephenmackey.co.uk');
define('HTTP_CATALOG_SERVER', 'http://www.buystephenmackey.co.uk');
define('HTTPS_CATALOG_SERVER', 'https://www.buystephenmackey.co.uk');

// Use secure webserver for catalog module and/or admin areas?
define('ENABLE_SSL_CATALOG', 'true');
define('ENABLE_SSL_ADMIN', 'true');

I do believe that the reason why shop/include/config.php are not correct because this file have 644 and can not be rewrite. Change to 777 fix the problem.
I fixed mine, but have another. Can not past the stage 2 of checkout.
MY hair are getting thiner from scratchin my head and I could use some help before I go bold.
Thanks

andy
20th June 2006, 10:09 PM
still paypal refuses to work.

Ive installed a new version 1.3.1 setup paypal as per your instructions, but it keeps going to /ipn_test.php on check out, what have i done wrong?

thanks

andy

Ajeh
20th June 2006, 10:10 PM
andy ... have you tried to uninstall and reinstall and configure it again?

24#Karat_fan
20th June 2006, 10:11 PM
you need to edit your paypal module settings for live store rather than test

Ajeh
20th June 2006, 10:12 PM
oh yeah ... and change that switch too ... :smile:

andy
20th June 2006, 10:23 PM
sorry, where is the switch?

Andy

Ajeh
20th June 2006, 10:29 PM
Sorry ... in the new Zen Cart v1.3.x ... that was removed from the configuration ...

Again, to make sure you have the right one loaded ... remove and reinstall and configure PayPal in the Modules ... Payments ...

andy
20th June 2006, 10:35 PM
Hi
thanks, it looks like it has worked, reloaded the paypal module

Andy

Ajeh
20th June 2006, 10:46 PM
Thanks for the update ... :smile:

It is always a good idea with new versions to write down the settings for the Payment, Shipping and Order Total Modules ... then do the remove/install and configuration ...

Some changes require new settings to the database and can cause things to run askew without it ... :blink:

andy
20th June 2006, 11:03 PM
Hi
you mean like this

as it should be

http://www.realraptors.co.uk/zen-cart-v1.1.3/

as it is now!!!!!

http://66.148.83.51/~realrapt/new/index.php?main_page=

no idea whats gone wrong!!

but paypal works

Andy

theodin
3rd August 2006, 09:03 PM
Hi all,

I've been banging my head with paypal scouring the forums to find what was going wrong. It would seem many fall into the traps of filling the dialogs correctly, and uninstalling/reinstalling, but those that had firewall issues left details out of their solutions: which host/ports to enable?

After having no answers, I assumed it was www.paypal.com But after fighting with my ISP to get this changed, it wasn't working. Until I found a link to this site:

http://www.zen-cart.com/wiki/index.php/Admin_-_Modules_-_Payment#How_Do_I_Set_Up_The_PayPal_Payment_Module.3F

This page lists 3 ip addresses for notify.paypal.com. I used nslookup to verify they were correct. So if anyone is looking for "what exactly must i ask of my ISP" i would reccommend giving them this document to look at. They should be wise enough to check the addresses before entering them into the firewall config

I'm still waiting on the new changes. if there are any probs i will post again.

THANKS ALL!!

theodin
3rd August 2006, 11:56 PM
ok... my test isp has said they have made the changes. our real isp has yet to reply. Testing my test ISP results in no information returning via ipn to zen cart. Let me explain the test situation:

1. I hesitated to play too much with the real site to close to going live so i copied the entire site files to another ISP (my personal one), copied the database, and reconfigured the two configure.php files. These guys are great and have 24/7 support. So i logged a support call with both ISPs at once and let the race begin.

1.5 - only the test ISP has replied. So i begun working on the test site.

2. I changed paypals IPN URL, and also the automatic return.

3. I checked checked and double checked that the case sensitive paypal username matches exactly the primary address in paypal. i checked the URLS and whathaveyou a second time.

4. I uninstalled and reinstalled paypal module in the site. (Oddly, it remembers the old settings that i used to have when i installed it again. is that how its supposed to work or is that a symptom of another problem?)

5. I then discovered the firewall problem and asked for www.paypal.com to be opened for traffic transfer. The test ISP responded and said they made the changes.

6. I replaced (with an original copy from the ZIP) the ipn_main_handler.php file. I set its perms to 777.

7. I then discovered that the IP addresses weren't those required, and asked for those associated with notify.paypal.com.

8. I repeated steps 1 through 5.

9. I sat in my chair for a bit completely depressed. There is a go live in a week, my css is getting worse the more time i spend on it, and there are rouge elements like the heading text for "shopping cart" sidebox is like 90px. I cant find its definition anywhere! This has plagued us since v1.2.7d.

About a month ago we removed our entire cart and started from scratch.

If this doesnt work for our go live date at our product convention, the people financing and trying to get this off the ground are going to pull the plug. Telecoms in my part of the world (New Zealand) are hideously expensive and service is terrible, especially compared with global standards. a few larger companies dominate the market and the telecoms providers really nail consumers and stifle development. (but I digress.)

My test url: is thoratparadise.net forwardslash store. Coffees (plus) to anyone who can help us get over this! My next test is a completely vanilla install on my test isp, just to prove the point. I will post how it goes.

Thanks for reading!
theodin

theodin
4th August 2006, 12:11 AM
PS: emails DO come to me and a transaction IS logged in paypal, BUT no transaction record exists in my cart, and the portion of the gift certificate used is not deducted. the return page says the transaction ID is that of the last successful order (one made using another payment method.)

Thanks!

DrByte
4th August 2006, 02:00 AM
PS: emails DO come to me and a transaction IS logged in paypal, BUT no transaction record exists in my cart, and the portion of the gift certificate used is not deducted. the return page says the transaction ID is that of the last successful order (one made using another payment method.)These are totally normal symptoms for cases when the IPN notification isn't coming back from PayPal successfully.

DrByte
4th August 2006, 02:00 AM
What currencies are active in your shop?
What currencies do you have your paypal module configure to accept (in ZC admin area)?

theodin
4th August 2006, 08:55 AM
The default currency of the site is New Zealand Dollars. (NZD). We actually have USD, EUR, CAD, and AUD enabled in addittion. In ZC Admin area, Paypal is configured to accept 'selected currency' and the correct amound in USD is displayed when the cart directs the user to the paypal site.

We already know that Paypal does not accept NZD directly. Should I change that to USD?

PS: if you are interested in seeing the config i can give you a username/pwd to the test cart by pm.

PSS: i did a completely new install from scratch to the ISP, (they said they have made the required firewall changes) configured just enough to make the paypal and the currencies work, and it also failed. I can give you rights on this test install too if you wish.

Your time is most appreciated!!

DrByte
4th August 2006, 09:15 AM
If the customer chooses USD for shopping and then checks out in USD, does the order come through properly?

theodin
5th August 2006, 12:06 PM
DrByte- that was a good call.

My isp filtered the weblog and we found the file being accessed with 'OK' http responses etc. My partner in crime here started looking at the currencies, and lo, it worked using USD. We currently use NZD as default currency (which Paypal doesnt natively support).

We are a bit stuck, however I will stop posting here and post testing results to http://www.zen-cart.com/forum/showthread.php?t=42600 instead.

THANKYOU!

DrByte
5th August 2006, 07:02 PM
We are a bit stuck, however I will stop posting here and post testing results to http://www.zen-cart.com/forum/showthread.php?t=42600 instead.


BETA BUGFIX CODE for multi-currency situations POSTED TO THE QUOTED THREAD. BETA ONLY

slobadog
12th August 2006, 05:14 AM
Righto, I have a similar problem. Here's the scenario:

1. version 1.2.7 of zencart works great with paypal.
2. version 1.3.0.2 of zencart does not work with paypal.

Both are on the same server (different domains) in AUD. The settings for the second instance have been triple checked, module re-installed and everything else tried as mentioned in these forums. Using express checkout or account still no go.

I have noticed that the first one sends an amount to the initial paypal page, the second one doesn't send an amount. The first one generates an order number and the order is viewable by both admin and customer. The second is successful in paying paypal only, no order number, no order details anywhere. I have even tried using all the paypal pages from the first version in the second one but still no go.

It would appear to me that the second version is simply not sending ANY info through to paypal.

Anyone got any clues? My brain hurts...

Ta

Ajeh
12th August 2006, 05:39 AM
If the v1.3.0.2 is an upgrade ... be sure that you used the Full Zen Cart v1.3.0.2 to upgrade and that you went to the Payment Modules ... removed/uninstalled PayPal ... Installed PayPal ... and Reconfigured it correctly ...

DrByte
12th August 2006, 06:49 AM
Slobadog,

You didn't say whether you tried the patch I referenced above. It should help you out.

slobadog
13th August 2006, 02:20 AM
Thanks but no cigar. It was a fresh install with cosmetic changes in the overrides only. I tried the patch but no go. I hadn't actually tried that patch previously as I thought AUD was a standard currency in paypal.

I actually have a version 1.2.6 on the same server with the same problem as well...

I am in the process of uploading a fresh copy of 1.3.0.2 and will run vanilla with a new database. It'll take a few hours to upload (I'm in the sticks here!) so I'll give you an update when it's online.

Thankyou so much for your suggestions. This latest shop is for myself (to pay for my forum). As soon as I turn a profit a donation to the zencart cause will be forthcoming.

DrByte
13th August 2006, 02:57 AM
on the same server with the same problem as well...
This would suggest some sort of block on the paypal server IP addresses and/or a misconfiguration of your settings on your paypal account.

http://www.zen-cart.com/wiki/index.php/Admin_-_Modules_-_Payment#How_Do_I_Set_Up_The_PayPal.E2.84.A2_Payment_Module.3F

slobadog
13th August 2006, 12:22 PM
I don't believe paypal is being blocked as one of the zencarts (1.2.7) on the same server works just fine. Interestingly, if I set the working one to point to the new paypal account, it works. If I point the new zencart (1.3.0.2) to the old paypal account, it does not work. Therefore through my amazing powers of deduction I have come to the conclusion that the new version of zencart somehow does not work for me.

The other version mentioned above that does not work has its own paypal account. It has been upgraded to 1.3.0.1 but paypal has never worked for that one. I figure if I can get the 1.3.0.2 working this one will follow...

I have done a vanilla install of 1.3.0.2, it does not work. I have added the "other currency patch", it does not work. I have checked the settings at paypal (remember this paypal account does work with the 1.2.7 version) it does not work.

My brain really hurts, any ideas? Anyone?

DrByte
13th August 2006, 07:13 PM
Interestingly, if I set the working one to point to the new paypal account, it works. If I point the new zencart (1.3.0.2) to the old paypal account, it does not work.
You are talking about two paypal accounts here, and you say that the "old paypal account ... does not work", but that "the new paypal account ...works"

So, what are the following pieces of information, for EACH paypal account. Please don't type them ... copy and paste them instead.
- email address entered in Zen Cart Paypal module
- primary email address from paypal profile on paypal.com
- Instant Payment Notification Preference URL from paypal.com

harlyman
13th August 2006, 07:39 PM
i have the same problem, have 2 sites, one for testing and one for production and have the same problem on both of them, and i know there can't be a firewall problem with blocked ip adresses, so there has to be something else...... paypal has worked on both this sites before

DrByte
13th August 2006, 08:19 PM
If you're using v1.3.0.2 and the patch I posted elsewhere, then do this:

1. Use your FTP program to enable read/write permissions (ie: CHMOD 777) on this folder:
includes/modules/payment/paypal/logs
2. Admin->Modules->Payment->PayPal ... edit ... at the bottom, choose Debug mode: Log
3. Test a paypal transaction.
4. use your FTP program to access the most recent file in includes/modules/payment/paypal/logs/*******.txt

Paste the contents of that file here.

harlyman
13th August 2006, 09:36 PM
If you're using v1.3.0.2 and the patch I posted elsewhere, then do this:

1. Use your FTP program to enable read/write permissions (ie: CHMOD 777) on this folder:
includes/modules/payment/paypal/logs
2. Admin->Modules->Payment->PayPal ... edit ... at the bottom, choose Debug mode: Log
3. Test a paypal transaction.
4. use your FTP program to access the most recent file in includes/modules/payment/paypal/logs/*******.txt

Paste the contents of that file here.

i don't use the patch, but will look it up and try, if i can find it:)

harlyman
13th August 2006, 09:55 PM
installed your pach and now it works great:) forgot to enable debug but guess thats not importent now:)

DrByte
13th August 2006, 10:11 PM
forgot to enable debug but guess thats not importent now:)
Correct - do not leave debug on for normal use. And do not leave the folder read/write unless debug is on and needed, or you leave yourself open to risks.

slobadog
14th August 2006, 10:27 AM
Dr Byte, sorry for the delay, a power pole fell down so had no power... Pasted as requested but @ replaced with at. When I say that a transaction works, I mean the amount of the product is sent to paypal and an order number and order are generated by zencart.

Account one - working
email address entered in Zen Cart Paypal module: shop at veganpet.com.au
primary email address from paypal profile on paypal.com: shop at veganpet.com.au
Instant Payment Notification Preference URL from paypal.com: off

Account two - not working
email address entered in Zen Cart Paypal module: shop at bladeslapper.com
primary email address from paypal profile on paypal.com: shop at bladeslapper.com
Instant Payment Notification Preference URL from paypal.com: http://www.bladeslapper.com/content/vanilla/ipn_main_handler.php

I tried turning IPN off on account two but no go. I'm not sure I explained myself properly before. I set the email address in account one to that of account two, paypal worked. Then I set the email address in account two to that in account one, paypal did not work.

I CHMOD'd the log directory in account two to 777 and set debug mode to log but no text file is generated.

slobadog
14th August 2006, 11:12 AM
Well here's a thing. I tried on a whim setting to USD and presto, it works. I re-installed the beta patch mentioned above, USD still works but AUD does not.
I also tried on my modified site (not the vanilla one) and USD works there too.

Getting closer...

DrByte
14th August 2006, 11:40 AM
This may or may not be obvious.... Do you have your paypal settings in Zen Cart configured to use "Selected Currency" or "USD"-only ?

DrByte
14th August 2006, 11:40 AM
Also, my bad ... the log files are ipn_xxxxxxx.log ... not .txt

slobadog
14th August 2006, 12:11 PM
I'm a ########head. In my haste I neglected to set AUD in Localization > Currencies.

All good now, sorry to waste your time. Hope someone else benefits from my last few days...

TMAInc
11th January 2007, 09:52 PM
I've been reading through all of these posts for many hours now and, having done everything recommended and checked everything recommended, PP is still not sending me emails of purchases and the sales are not showing up in Admin. PayPal itself (business account) is showing that the transactions are going through and is sending me email payment notifications, but the IPN Return is not working. Both email addresses are identical (PP admin and ZC admin). I have uninstalled and reinstalled the payment modules and shipping modules. My client is losing track of the orders because he can't fill what he doesn't know about!

This is a brand new install (not an upgrade), ver. 1.3.6, using only PayPal and Check/Money Order for payment options and Per Item & UPS as the only shipping options. I have installed four other ZC stores for other clients and they all work perfectly, especially the older versions. They are all hosted by the same company, so there are no ISP issues.

I've read the thread on the seo.url.php patch, but since I have not installed that add-on module, I don't have a file by that name (at least I don't think I do). I can't find where to modify this: "The solution: In the class file seo.url.php we just have to add a check for ipn_main_handler.php."

Will someone PLEASE help?! The store is located at http://www.bobfitts.com/store/index.php

Thanks,
Gary Stripling, President
The Management Agency, Inc. (TMAInc)

Kim
12th January 2007, 01:51 AM
Gary-

Please don't double post. See the answer in the separate thread.

lextechs
12th January 2007, 08:33 AM
If I were to make an order right now on your site utilizing PayPal ...

1 Would you see it at paypal.com

2 Would you get an email from paypal.com

3 Would I, the customer, get an email from your site?

4 Would you, the admin, get an email from your site?

5 Would you see the order at all in the Admin ... Customer ... Orders?

6 Would I, the customer, see on checkout_success, the completed order?

7 Would I, the customer, see the order in my Account History?

I am having the same problem since i upgraded from 1.3.6 to 1.3.7 i get the notice from paypal but the orders are not recorded in zencart and not invoices are sent to the customer or admin., This does not seem to be a local issue there seem to be many variables to this problem. Can we just use the old paypal mod from version 1.3.6 with version 1.3.7? since we know that 1.3.6 worked?

1. yes i would

2. yes i would

3. no you would not

4. no i would not

5. no
6. no it just took me to a page where pay pal is asking me to join
7. no

Ajeh
12th January 2007, 04:11 PM
Did you try going to the Payment Modules and writting down your settings and uninstalling and reinstalling it and then configure it?

No, the old v1.3.6 is very different from v1.3.7 you need to be sure that you updated all of the files in with the new files in v1.3.7 ...

lextechs
12th January 2007, 05:13 PM
Did you try going to the Payment Modules and writting down your settings and uninstalling and reinstalling it and then configure it?

No, the old v1.3.6 is very different from v1.3.7 you need to be sure that you updated all of the files in with the new files in v1.3.7 ...

Yes it did, this was working before i upgraded to version 1.3.7. i turned on the debug mod and here is what the e-mail sent me for a refund transaction,

It was send in 3 seperate e-mails so i am not sure if the order it correct but here is the debug message i got.

IPN NOTICE::ipn_application_top -> language files okay

IPN INFO - POST VARS
mc_gross=11.88
&address_status=confirmed
&payer_id=76VMG22AJJRGS
&tax=0.00
&address_street=425+e+embassy+dr
&payment_date=23%3A30%3A28+Jan+11%2C+2007+PST
&payment_status=Refunded
&charset=windows-1252
&address_zip=85243
&first_name=Adam
&mc_fee=0.64
&address_country_code=US
&address_name=Adam+Joseph
&notify_version=2.1
&custom=zenid%3D37a9af29c1e66cd8d59b342532ebaf81
&payer_status=unverified
&business=E-mail%40xxxx.xxx
&address_country=United+States
&address_city=queen+creek
&quantity=1
&verify_sign=ALBe4QrXe2sJhpq1rIN8JxSbK4RZAVGKEIK8vCBzhsdiFddmDqagH6JW
&payer_email=email%40something.something
&contact_phone=xxx-xxx-xxxx
&txn_id=53H70248A4893230K
&payment_type=instant
&last_name=Joseph
&address_state=AZ
&receiver_email=xxxx%40xxxxx.xxx
&payment_fee=0.64
&receiver_id=EH7728J4PM7DE
&txn_type=web_accept
&item_name=Lextechs+com+Purchase
&mc_currency=USD
&item_number=1
&residence_country=US
&receipt_id=1254-7366-4255-2574
&payment_gross=11.88
&shipping=0.00
&cmd=_notify-validate
IPN INFO - CURL INFO
HTTP/1.1 200 OK
,Date: Fri, 12 Jan 2007 09:04:59 GMT
,Server: Apache/1.3.33 (Unix) mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a
mod_ssl/2.8.22 OpenSSL/0.9.7e
,Set-Cookie: cookie_check=yes; expires=Mon, 09-Jan-2017 09:04:59 GMT;
path=/; domain=.paypal.com
,Set-Cookie: Apache=66.225.253.151.132901168592699661; path=/; expires=Sun,
04-Jan-37 09:04:59 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8
,VERIFIED
,0
,

Jeff_Mash
12th January 2007, 05:20 PM
Same problem is happening to my store, but it's not consistent. For example, I just noticed two paypal orders in a row were deposited into my paypal account but not relaying back to my ZenCart CP, so I have no idea what they bought. However, the paypal order after those DID work.

I am using the latest and greatest version of ZenCart, and I am stuck. I have also uninstalled and reinstalled the module many times as well.

Ajeh
12th January 2007, 05:46 PM
Go to the Tools ... Install SQL Patches ... and run these:
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 '';

lextechs
12th January 2007, 05:53 PM
Go to the Tools ... Install SQL Patches ... and run these:
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 '';


Is that for me, or everyone having this problem?

Ajeh
12th January 2007, 06:11 PM
Anyone using PayPal that is experiencing a problem ...

Jeff_Mash
12th January 2007, 06:27 PM
Ajeh,

I will try that patch to see if it helps. I just had another weird thing happen which may or may not be related, but I'm recording it here in case anyone else experiences the same thing.

A paypal customer just wrote me asking where his merchandise was. He emailed me a copy of the invoice, and the Order Number was for an order that happened MONTHS ago (early September) for a completely different customer, with completely different merchandise.

However, I do see a paypal deposit from him in our account on the day in question (December 31st).

My first thought is that I am being scammed, with someone spoofing our emails to look like they ordered something, especially since they have no customer account, and the invoice he provided is not even close to being accurate. But there is money deposited into our account from him for the amount of the item he wants.

lextechs
12th January 2007, 10:06 PM
Still no fix but i did download that paypal stuck veiwer mod. and read the readme file $Id: view_stuck_paypal_orders.php, v 1.0 2005/04/25 DrByte $

Sometimes paypal orders don't get returned by paypal's IPN feature reliably.
Yet, Zen Cart stores the information on these orders while waiting for confirmation from PayPal.
If PayPal never returns an IPN confirmation successfully, these orders sit in Zen Cart's database
waiting... and waiting...

The good news is that it's still in the database.

As such, the enclosed viewer will display the contents of the order information so that you can
still process the customer's order.

The display of information is rather cryptic, but after looking at it for a bit, you'll find
that all the information you need is usually right there.

Anyway installed this and sure enough the information came up when i ran the mod in admin. still cant see what the customer order but there is alot more detail than, that of what paypal sent. So from reading that and running the mod i am guessing paypal or ZenCart is stuck at some point . i hope this help someone figure out what the problem is .....

Jeff_Mash
20th January 2007, 06:28 PM
Yes, this is an ongoing thing. Happened twice yesterday. Incidentally, both paypal orders were eChecks. I had to contact the customer and ask what they bought, and then manually create the order for them. It's becoming a real nightmare because we are starting to miss orders.

We are not running the PayPal Express module, otherwise I would think that had something to do with it.

Ajeh
20th January 2007, 06:35 PM
Did you add this patch yet to your site?

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

Ajeh
20th January 2007, 06:36 PM
Note: there are a couple of files shared ... so update all your files with that patch file ...

Jeff_Mash
21st January 2007, 04:38 PM
Did you add this patch yet to your site?

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

I wasn't using the PayPal Express module....that is why I was wondering if this weird behavior was due to this NOT being enabled or something weird like that.

Ajeh
21st January 2007, 04:40 PM
No, but due to shared files I'd say load the patch to see if this helps the problem you are having ... at least then the code is on the same page ... :smile:

Spinner
23rd January 2007, 05:06 PM
I'm also having PayPal problems since upgrading from 1.3.5 to 1.3.7. I've tried the suggested patch (http://www.zen-cart.com/forum/showthread.php?t=56216) and Ajeh's SQL code, but to no avail. Order confirmations aren't going through to either the customer or the seller.

I'm confused as to why, since it was working fine before I upgraded this afternoon. I've uninstalled the PayPal module and re-installed it, but still no joy.
Any help would be greatly appreciated.

Spinner
23rd January 2007, 05:34 PM
Sorry for the double post, but I thought I'd better let you know that the site in question is www.beebasic.co.uk (http://www.beebasic.co.uk). I also am getting from time to time the warning "CURL functions not found - required for Linkpoint API payment module" at the top of the Admin screen, although I haven't got the Linkpoint module installed.

andy
24th January 2007, 12:09 AM
Hi
I have a new install 1.3.7, set all the setting as per this whole thread, i get redirected back, but no info is passed, and nothing in admin

temp url is www.realraptors.co.uk/synergy/

If i go to http://www.realraptors.co.uk/synergy/ipn_main_handler.php the page just hangs but no errors

what do i do? i would like to go live with the updated site

Andy

andy
24th January 2007, 12:30 AM
Sorry to miss lead, my version is 1.3.6

Andy

andy
24th January 2007, 12:51 AM
ipn dubugging, gave only this

IPN NOTICE::Got past language loads

no other text

Andy

andy
24th January 2007, 01:00 AM
just got these, all on seperate emails

IPN NOTICE::Got past language loads

IPN FATAL ERROR::Could not find stored session in DB, cannot re-create session

IPN FATAL ERROR::No saved session data available

IPN FATAL ERROR::No POST data available

IPN FATAL ERROR::Transaction did not validate

IPN WARNING::Transaction was not marked as VERIFIED. IPN Info = ,,,,,,,,,,,,,,

what have i missed? the account im testing with is verified

Andy

DrByte
24th January 2007, 07:01 AM
Can you zip up the log files in the /includes/modules/payment/paypal/logs folder (with a password on the zip), and post the zip here?
PM me with the password to the zip file so I can review it.


Note: you'll need to make that folder "read-write" ... ie: permissions of 777 ... or else the log files won't be saved.

andy
24th January 2007, 08:43 AM
To DrByte

PM Sent

Andy

DrByte
24th January 2007, 01:51 PM
IPN WARNING::Transaction was not marked as VERIFIED. IPN Info = ,,,,,,,,,,,,,,


"IPN Info = ,,,,,,,,,,,,,," ... is this literally what it says, or did you simply use the commas to remove potentially sensitive data from public posting?

I've never seen it only show a batch of commas like that ;)

andy
24th January 2007, 02:08 PM
Hi
As i posted it, was how it was in the emails

Andy

Jeff_Mash
31st January 2007, 05:11 PM
I don't know if this is any help, but the latest customer of ours has this happen with EVERY ORDER, where we get his PayPal deposit and nothing gets relayed to ZenCart......and he is paying with an ECHECK, so his status on paypal shows up as "uncleared."

Peter Homann
1st February 2007, 09:29 AM
"IPN Info = ,,,,,,,,,,,,,," ... is this literally what it says, or did you simply use the commas to remove potentially sensitive data from public posting?

I've never seen it only show a batch of commas like that ;)


OK, I'm experiencing the same problem. I upgraded to 1.3.7, removed the Paypal IPN module then added it in as instructed.

In my Paypal account I have set my default currency to AUD$. I also accept US$

In my ZenCart I have set my default currency to US$ as most of my customers are in the USA.

If I set the currency option in Zencart Paypal IPN to use selected currency all is well.

If I set it to only AUD$ I experience the problem where I rteceive a paypal payment but no order turns up in ZenCart.

So I turned on the debugging. The final debug message #13 says


IPN WARNING::Currency/Amount Mismatch. Details:
PayPal email address = homann@homanndesigns.com
| mc_currency = AUD
| submitted_currency = AUD
| order_currency = USD
| mc_gross = 15.98
| converted_amount = 15.99
| order_amount = 12.38


It appears that there is a rounding problem somwhere. The order was place with the currency set to US$ for the amount of US$12.38.

Then when checking out in the Paypal enter payment info page. (Before logging into paypal), the page shows the amount as. AUD$ 15.98

When I log into Paypal, the amount still shows AUD$15.98, and this is the amount that Paypal notifies me I been payed.


I presume that the order is rejected because the converted_amount of 15.99 does not mated the mc_gross amount of 15.98.

A rounding error somewhere?


I hope this helps.


Also in debug #8 I get the message

IPN WARNING::Could not find matched txn_id record in DB



Cheers,

Peter.

andy
1st February 2007, 10:16 AM
Not sure if this help, but

i couldnt get PayPal to put info from orders back into admin, zen ver 1.2.4, so upgraded to 1.3.6 for added features as well as PayPal, which we had not accepted before, still not working, so upgraded to 1.3.7 and still not working, after re reading this whole thread, added the patch files from Dr Byte and Linda, and all works ok.

The moment i updated the INP file, all the test transactions from earlier in that day, all desposited in admin!

You may need to add the updated files

Andy

Peter Homann
1st February 2007, 10:49 AM
Hi Andy,

Thanks for the reply. where can I find the patch files.

Cheers,

Peter.

andy
1st February 2007, 11:24 AM
Hi Peter
patches are here

http://www.zen-cart.com/forum/showthread.php?t=35436&page=16

last post from Ajeh for sql patch

and

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

I played with the PayaPal thing for over 4 weeks, hope it helps

Andy

Peter Homann
1st February 2007, 12:12 PM
Hi Andy,

Thanks. I installed the patch without success. From what I can see they are for Paypal express not Paypal IPN.

From the error message I get, it appears to be a problem that the converted currency of Zencart does not match that of Paypal. OUt by 1 cent.

Cheers,

Peter.

andy
1st February 2007, 12:21 PM
I think the main problem it fixed for me was the IPN handler page.

Andy

DonnaSOTB
7th February 2007, 10:34 PM
I recently upgraded to Zen Cart 1.3.7 - payments and orders are showing up in both pay pal and email order confirmations are showing up and the orders are in my admin in Zen Cart. The problem I'm having is if someone pays using an e-check - the order isn't being recorded in the Admin in Zen Cart so when the e-check clears, I don't have an order that I can approve. Can anyone help?

Ajeh
7th February 2007, 10:52 PM
Did you install the patch for this?
http://www.zen-cart.com/forum/showthread.php?t=56216

Are you using express or PayPal IPN?

DonnaSOTB
7th February 2007, 10:53 PM
I'm using Pay Pal IPN so I don't believe I need the patch.

Ajeh
7th February 2007, 10:56 PM
Humor me ... get the patch as there are shared files ...

Also ... even though you are not using it ...

Click on PayPal Express ... Click Install ... Click Update ... Then Click Remove ...

There is a database change I want to make sure is made for you that is in that patch ...

Then please try an e-check now and let us know if that works ... I know it takes a couple days but it would help you and us resolve your problem ... as this must be tested on a New e-check to know if it is fixed ...

13moons
8th February 2007, 06:45 PM
Linda,
I have the same problem. PayPal e-check orders are not showing in admin. Regular PayPal payments are. I applied the above fixes and will let you know if successful.
Jeff

DonnaSOTB
8th February 2007, 07:14 PM
Linda, I also tried your fix but I haven't had an e-check come through. I set up a separate pay pal account in an effort to test it using an e-check but it takes a couple of days as it wants me to confirm the account.

Ajeh
9th February 2007, 03:46 AM
Time is on my side ... :cool:

Let us know what you come up with ... thanks!

13moons
14th February 2007, 02:59 PM
A quick update. Regular PayPal orders are coming through fine. We have not received an echeck order through PayPal yet.
I looked over our past history and this a longer than normal gap for PayPal echeck orders for us. ???

Ajeh
14th February 2007, 03:01 PM
NOTE: there has been an update to the Patch on the 9th ...

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

Thanks for the info ...

13moons
14th February 2007, 04:02 PM
Linda
Missed that! Done now.
Thanks

DonnaSOTB
14th February 2007, 04:41 PM
Linda,
Thanks I did that one now I have an error in my admin section under Payment modules. Here's the error:
Warning: main(/home/sotbadmin/domains/scrapoutsidethebox.com/public_html/store/includes/languages/english/modules/payment/paypal_curl.php): failed to open stream: No such file or directory in /home/sotbadmin/domains/scrapoutsidethebox.com/public_html/store/admin/modules.php on line 174

Warning: main(): Failed opening '/home/sotbadmin/domains/scrapoutsidethebox.com/public_html/store/includes/languages/english/modules/payment/paypal_curl.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/sotbadmin/domains/scrapoutsidethebox.com/public_html/store/admin/modules.php on line 174

Fatal error: Call to undefined function: check() in /home/sotbadmin/domains/scrapoutsidethebox.com/public_html/store/admin/modules.php on line 179
What do I do now?

Ajeh
14th February 2007, 05:03 PM
Sounds like bad uploads ... try reloading the files again ...

DonnaSOTB
14th February 2007, 05:16 PM
I tried that - it didn't work? Any other ideas?

Ajeh
14th February 2007, 05:21 PM
Looks like you loaded the files incorrectly ...

Look at the file structure of your site vs the file structure of the Patch ...

You have loaded the paypal_curl.php in the wrong directory ...

Check that the files in:
/includes/modules/payment

are just payment files ...

Check that the files for:
/includes/modules/payment/paypal

are just the files for paypal ...

Do not mix up the directories as the:
/includes/modules/payment

directory should only contain files written to be payment modules ... this is a self loading directory and if you put the wrong files, copies, etc. in there it will throw errors ...

DonnaSOTB
14th February 2007, 05:27 PM
Linda,
You're absolutely right - I had a couple files that were in the wrong directory. Thanks so much. Hopefully the cart will now start recording my e-checks.

13moons
15th February 2007, 03:19 PM
I uploaded the latest update and finally got a pending echeck from PayPal. Unfortunately no email notification through our zen-cart and no record of the order in admin. We did get PayPal notification of the payment.
All regular PayPal payments are fine.
Should I have uninstalled and reinstalled any of the modules when I uploaded the last update?

DonnaSOTB
15th February 2007, 04:31 PM
I'm having the same problem - I get a notification from paypal saying there is a pending e-check. However, the order isn't being recorded in zen cart. So when the e-check clears - I don't have an order to approve. Any ideas?

rstamets
15th February 2007, 08:58 PM
I have read all the previous posts and hate to make this any longer but I just set up PayPal IPN and am getting the following message on the Log:

IPN NOTICE::Got past language loads

Have triple checked the module and paypal configs and they are correct. I have 2 other Zen Carts running fine with the Pay Pal IPN on the same server.

Pretty much straight v1.3.7 install.

Although emails are sent from paypal confirming the order to both the seller and the buyer, no order is added to admin.

It appears that ipn_main_handler is being contacted, but no data is getting inserted.

Any ideas?

rstamets
16th February 2007, 12:38 AM
I quadruple checked and ran a test order through the Paypal IPN. (it was a live transaction)

Customer receives email transaction confirmation from Paypal
Merchant receives email payment confirmation from Paypal
Customer is redirected back to the zc confirmation page

Everything works fine except nothing shows up in any of the order or paypal tables in the database, yet no errors are being thrown during the query.

Help...!

rstamets
16th February 2007, 03:07 AM
VOILA!!!

Dr Byte has a post with a patch link. It worked for my paypal IPN!

Paypal IPN orders are now being put in the order database and all is working fine.

If you are having the same problems with v1.3.7 as I was above, here is a link to the fix that worked for me.

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

Thanks All.... ron

13moons
16th February 2007, 03:18 AM
I applied this patch. All regular PayPal payments come through fine. It's the PayPal echeck orders that do not appear in admin.

13moons
21st February 2007, 01:23 AM
OK I keep doing the patches and following the instructions and no pending paypal payments are coming through. Regular paypal fine. Pending at paypal with paypal email but it does not show in admin.
I did the 2-15 patch, installed express, updated, and set it to not show. Just received a echeck through PayPal and no admin record. I have not done the 2-19 patch yet but I see nothing mentioned that would resolve this.
Am I the only one still having this problem? If so what am I missing?
Thanks

Ryk
21st February 2007, 06:02 PM
You're not alone 13moons. I've just had this e-check issue reported to me by a client. IS the latest patch supposed to take care of this?

DrByte
21st February 2007, 06:35 PM
OK I keep doing the patches and following the instructions and no pending paypal payments are coming through. Regular paypal fine. Pending at paypal with paypal email but it does not show in admin.
I did the 2-15 patch, installed express, updated, and set it to not show. Just received a echeck through PayPal and no admin record. I have not done the 2-19 patch yet but I see nothing mentioned that would resolve this.
Am I the only one still having this problem? If so what am I missing?
Thanks

IS the latest patch supposed to take care of this?

No, this has not been resolved yet... Working on it ...

Ryk
21st February 2007, 10:09 PM
Thanks for that DrByte. I shall pass that on.

tvadpro
23rd February 2007, 12:41 AM
I'm curious -- has anyone with a 1.3.7 installation gotten eCheck orders into the admin through the PayPal IPN? I'm in the same boat -- PayPal IPN works fine except when the customer pays with eCheck. When I called an eCheck customer in LA this afternoon to find out what he ordered (I called after his eCheck cleared), he mentioned he would be placing more orders with us in the weeks ahead. I gather he'll want to pay by eCheck again, so I'm eager to hear how this one progresses.

Godspeed, DrByte. :smile:
No, this has not been resolved yet... Working on it ...

Ryk
23rd February 2007, 09:02 AM
Don't know if this helps or hinders in the fixing, but my client was using Paypal Express.

13moons
23rd February 2007, 01:14 PM
Is there a way turn off PayPal echeck until this is fixed?

tvadpro
23rd February 2007, 03:30 PM
Good thinking, Ryk. I too don't know whether it helps, but I'm pretty sure it doesn't hinder. So for what it's worth, my site uses PayPal IPN and not PayPal Express.Don't know if this helps or hinders in the fixing, but my client was using Paypal Express.13moons, in your PayPal profile, there is a link for Payment Receiving Preferences under Selling Preferences heading. There you should find a checkbox to "Block payments from users who pay with eCheck for website and Smart Logo payments, or German bank transfer for all website payments except eBay." I have not tried, but if I wanted to disable eChecks, this would be my first guess.

tvadpro
27th February 2007, 01:27 AM
Just checking in to ask how repairs are coming on the PayPal IPN module. Has anyone heard anything? Does anyone need help testing? I feel like a concert violinist in an operating room. Should I go boil water? :dontgetit

DonnaSOTB
27th February 2007, 01:36 AM
I've been waiting for this one too - I believe they're working on it. I temporarily turned off the echeck option (hopefully we don't lose any customers). I look forward to the fix!

DrByte
4th March 2007, 09:20 AM
Patch posted today which addresses echeck issues vis a vis PayPal IPN payment module (v1.3.7)

http://www.zen-cart.com/forum/showthread.php?p=338031#post338031

tvadpro
5th March 2007, 02:53 AM
Thanks Doc! I just installed the patch, but testing is hung on eCheck not showing up on the PayPal order page. I'm not familiar with eCheck in general, but noticed "where available" text following the list of payment options on the first PayPal page. Since I don't have eCheck disabled in my PayPal web payment preferences, is it possible eCheck is unavailable because my billing address is in the wrong state? Patch posted today which addresses echeck issues vis a vis PayPal IPN payment module (v1.3.7)

http://www.zen-cart.com/forum/showthread.php?p=338031#post338031

misty
5th March 2007, 08:26 AM
Patch posted today which addresses echeck issues vis a vis PayPal IPN payment module (v1.3.7)

Does installing this patch retrieve existing lost PayPal ECheque payment/s?
If not, how to retrieve..either before or after installing patch?
TIA

DrByte
5th March 2007, 08:34 AM
No, the patch will not recover old transactions.
To release "stuck" transactions you'd need to use the PayPal Sessions Viewer (http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=84) contrib in the downloads section.

misty
5th March 2007, 08:39 AM
DrByte, thanks for info/link/prompt response..
:thumbsup:

tvadpro
5th March 2007, 09:54 PM
PayPal is making me crazy. :wacko:

I'm trying to understand whether eCheck payments are available through the "Don't have a PayPal account" option. When I test the IPN, there is no eCheck payment method in PayPal's dropdown on the second page. But on the first page, within the Don't-have-a-PayPal-account fieldset, there is an eCheck logo graphic and text that reads "Use your credit card or bank account (where available)."

I called PayPal support, and the rep told me eCheck is NEVER available via the Don't-have-a-PayPal-account option. She wouldn't tell me why the fieldset on the first page indicates otherwise.

I think she's full of crap, though what she said would explain why -- when I choose Don't-have-a-PayPal-account -- the only payment methods offered are credit cards.

I followed up with an email to PayPal customer support -- maybe they can explain it. Meanwhile, does anyone here understand this?

DrByte
5th March 2007, 10:35 PM
An eCheck is in essence an electronic request to process a debit against your bank account with all the same benefits/features as a regular check (ie: ability for stop-payment, service charges, etc).

As such, an eCheck can never be funded from a Credit Card.

Further, an eCheck requires that you supply your banking information. I believe that PayPal requires that your bank account be "verified" before it will offer eCheck services for you. If that's the case, you'll need to have an active PayPal account in order to use eChecks.

If your frustration is with the fact that an eCheck logo is displayed along with CC logos, keep in mind that you still have to posess the ability to pay via a given CC before you can use it. For example, while the Visa and Mastercard and Amex logos are displayed, you still have to actually *have* a Visa or MC or Amex account etc before you can *use* it to pay with. As such, the display of the echeck symbol isn't really that far off... gads now I sound like I'm defending them.


By the way, you've taken this discussion thread way off topic. ;)

tvadpro
5th March 2007, 11:08 PM
Thank you, DrByte. I'm starting to get the picture. :P

And for the record, I have nothing against PayPal -- in fact, I make a point of implementing PayPal IPN in every store whose owners permit.

My frustration is not with the fact that eCheck is displayed with credit card logos. My frustration is with the fact that eCheck is misrepresented as a payment method one can use in the absence of a PayPal account.

Picture the customer who has no PayPal account, sees the eCheck logo in the "Don't have a PayPal account" fieldset, and chooses that route. As soon as the next page loads and eCheck is nowhere to be found, it's probably time to shop elsewhere.If your frustration is with the fact that an eCheck logo is displayed along with CC logos, keep in mind that you still have to posess the ability to pay via a given CC before you can use it. For example, while the Visa and Mastercard and Amex logos are displayed, you still have to actually *have* a Visa or MC or Amex account etc before you can *use* it to pay with. As such, the display of the echeck symbol isn't really that far off... gads now I sound like I'm defending them.


By the way, you've taken this discussion thread way off topic. ;)

tvadpro
5th March 2007, 11:10 PM
Oh yeah -- sorry 'bout that! :blush: By the way, you've taken this discussion thread way off topic. ;)

tvadpro
6th March 2007, 12:30 AM
Okay -- after installing yesterday morning's PayPal IPN patch, I just performed an eCheck test (logging into my PayPal account, thank-you-very-much). The checkout_success page notes the order number as 1 (I know that's not right) and nothing new in Admin/Customers/Orders.

Did I miss something? :dontgetit I quadruple checked and ran a test order through the Paypal IPN. (it was a live transaction)

Customer receives email transaction confirmation from Paypal
Merchant receives email payment confirmation from Paypal
Customer is redirected back to the zc confirmation page

Everything works fine except nothing shows up in any of the order or paypal tables in the database, yet no errors are being thrown during the query.

Help...!

DrByte
6th March 2007, 12:37 AM
What's in your PayPal log files?

tvadpro
6th March 2007, 01:08 AM
In Customers/PayPal IPN, there's nothing new. Do you want to see the PayPal session info?What's in your PayPal log files?

DrByte
6th March 2007, 01:17 AM
No. Sorry -- I can't remember which of the hundreds of posts I've recorded those instructions in.
Turn on Debug Logging in Admin->modules->payment->PayPal IPN
Then make your /includes/modules/payment/paypal/logs folder writable
Then do a test transaction.

tvadpro
6th March 2007, 01:46 AM
I PM'd the session log. As for the log in modules/payment/PayPal/logs, the entire contents:Mar 05 2007 17:52 -- IPN PROCESSING INITIATED.
*** Originating IP: 216.113.188.202That's all of it.No. Sorry -- I can't remember which of the hundreds of posts I've recorded those instructions in.
Turn on Debug Logging in Admin->modules->payment->PayPal IPN
Then make your /includes/modules/payment/paypal/logs folder writable
Then do a test transaction.

DrByte
6th March 2007, 04:58 AM
Your SEO urls mod was throwing an error in html_output.php on line 22 because in v1.3.7 the ipn_application_top doesn't load all the initSystem overrides that the main core does.

Restoring the original html_output file allows IPN notices to work.
Of course, that breaks your SEO url support. :shocking:

schoolboy
6th March 2007, 10:40 AM
The stuck orders mod works very well - thanks!

BUT... if a customer proceeds through checkout and gets to the PayPal payment page (on PayPal's site), AND THEN decides to abandon everything, the "stuck order" is still on my database, but the customer has gone away and perhaps does not intend to return.

Am I right in thinking that a "stuck order" ought to FIRST be matched up somehow with successful PayPal payments?

In other words, check to see if the customer's payment went through to your paypal account FIRST - if it did, (and the record's stuck) only THEN move the order to the database?

You don't want to be moving stuck orders to the dbase if the customer vanished at the paypal stage.

... and then if we've got "stuck orders" in the list that (in reality) are orders that were ABANDONED at the paypal website level - how do we "delete" or "cancel" these, so that they stop showing on the list.

Could a button - "Cancel -- session abandoned at PayPal stage" - be put into the code (button that appears underneath the "Move to Orders database" button) ?

schoolboy
6th March 2007, 11:12 AM
As we all know, PayPal has a mind of its own sometimes and we too have had situations where the automatic re-direct to our shop (after payment), has not "worked" - resulting in "stuck orders".

I modified checkout_confirmation.php (in Languages->English>) to alert customers to the need to return to our site, once they'd finished up at paypal. If the auto-redirect works, they get back anyway... If not, we've told them they should do so! See the screen capture, below...

http://www.karenscakes.co.uk/images/checkout.jpg

tvadpro
6th March 2007, 03:32 PM
I really appreciate your looking at this and isolating the problem with eCheck orders not showing up. You rock, DrByte!

I have submitted a bug report on the SEO-URLs bug tracker so Dreamscape can seek a fix in the SEO-URLs mod.

I just now put the modified html_output file back in place, as the absence of modification prevents customers from logging in while SEO-URLs is running. I'm about to test to learn whether the modification in html_output impairs regular PayPal orders, or just eCheck orders.

Again, THANK YOU!

SeanYour SEO urls mod was throwing an error in html_output.php on line 22 because in v1.3.7 the ipn_application_top doesn't load all the initSystem overrides that the main core does.

Restoring the original html_output file allows IPN notices to work.
Of course, that breaks your SEO url support. :shocking:

dreamscape
6th March 2007, 03:39 PM
Your SEO urls mod was throwing an error in html_output.php on line 22 because in v1.3.7 the ipn_application_top doesn't load all the initSystem overrides that the main core does.

To be precise, it doesn't load any of the auto_loaders or init_includes.

How silly of me to assume that a core Zen Cart script would implement a core Zen Cart feature. :wacko:

tvadpro
6th March 2007, 04:33 PM
Regardless, Josh, the html_output patch you just posted on the bug tracker works like a charm. With the amended modification, I ran two successful tests just now -- one via instant payment, and one via eCheck.

Many thanks to you and to DrByte for your excellent work, the net result of which is a highly effective e-commerce solution.

Kudos!
SeanTo be precise, it doesn't load any of the auto_loaders or init_includes.

How silly of me to assume that a core Zen Cart script would implement a core Zen Cart feature. :wacko:

DrByte
6th March 2007, 07:08 PM
To be precise, it doesn't load any of the auto_loaders or init_includes.

How silly of me to assume that a core Zen Cart script would implement a core Zen Cart feature. :wacko:

The code to rework the ipn subsystem to use the initSystem infrastructure has been "in progress" for a couple weeks now and may be included in the next release if it passes testing in time.

schoolboy
6th March 2007, 07:26 PM
Could a button - "Cancel -- session abandoned at PayPal stage" - be put into the code (button that appears underneath the "Move to Orders database" button) ?

Anyone willing to comment on this??? See topic above...

tvadpro
6th March 2007, 09:16 PM
For whatever it's worth, I thought the same thing when I looked at my "stuck PayPal orders" records. This mod is useful, but would be even more useful if it could filter out records in which there was no payment.

Alternately (or perhaps additionally), I'd like to see the report clearly identify records with existing orders. These records are listed, but one can't really see at first glance which records already have orders in the database (versus which records do not).Anyone willing to comment on this??? See topic above...

DrByte
6th March 2007, 09:34 PM
Sorry folks, the stuck-orders tool doesn't know anything about what happened at PayPal ... it's just a snapshot of the order that was sent to PayPal.
The only way to know what happened at PayPal is to receive the IPN data from PayPal ... and if your server failed to do that ... too bad. You'll have to match things up manually.

As for adding a "cancel" or "delete" option in the Stuck Orders tool ... yes, you can add that sort of thing if you wish. All the tool is doing in the admin is showing you records from the paypal_sessions table. A simple delete of the selected record will stop them from being displayed to you ... permanently.

NOTE: These questions are more pertinent to that contribution than to this thread.

13moons
11th March 2007, 12:23 AM
Just to follow up my PayPal problems of not receiving echecks in admin or by email, it is fixed! The last update did indeed resolve it as we had our first pending echeck through paypal today. All happened as it should with both email and it is in the admin.
Thanks for the effort to get this resolved.

lextechs
15th June 2007, 04:29 PM
Has this problem been fixed i just got a order and the customer used paypal but no invoice was sent out to me or the customer nor those the order show up in admin area.

13moons
15th June 2007, 04:58 PM
For us the problem was resolved in the March Paypal update.

The only remaining problem I have is failed echecks go back to New status. However I only just installed the May update so it may be ok now.

lextechs
16th June 2007, 12:08 AM
Where are these updates i don't see a paypal payment mod in the down load section

Ajeh
16th June 2007, 01:10 AM
In the PayPal Express forum ... :smile:

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

johnd
7th July 2007, 12:17 AM
My stuck order viewer module isn't working. I am getting this:
Displaying 3 records...
PAYPAL SESSION INFO for record #1, which expires on 1181592332
Session_ID=42d2bf16702bc4e4e094153ab52b39a5
customers_host_address => localhost
cartID =>

Catchable fatal error: Object of class shoppingCart could not be converted to string in
rabbitinmyhat.com/admin/view_stuck_paypal_orders.php on line 71

I couldn't find anything that looked wrong on line 71, but I'm not that knowledgeable on php.
Ad, when I moved from this page to another admin choice, I got logged out of admin. Is that to be expected?

Thanks

johnd
7th July 2007, 07:38 PM
I tried 3 more test orders today Paypal IPN and still no record of orders in ZC admin.

First I re-uploaded the PP patch from May, removed PP IPN, then reinstalled PP IPN.

Ran the test orders.
I am getting paid okay and getting the PP email that the payment was received. The customer got the receipt from PP. But there is no sign of the orders. No confirmations, no copies of confirmations, no record in Customers-->Orders and the Stuck Order viewer won't work.

For the last test, I turned on the debugger for PP IPN. I have no idea what that does or where to look for a log. Will the debug log tell me anything?

johnd
7th July 2007, 10:46 PM
I found the June 17 patch for IPN and installed it. My IPN worked. Thank you.

But what about my stuck paypal orders view? Any suggestions?

pcdesigns
23rd July 2007, 05:13 PM
I'm confused....will this patch help with the seo mod not working correctly when trying to checkout with paypal?