Addon installation PayPal/Order Issues

[dschwieg]

Hi,

I'm working with a company that has ZenCart 1.3.8a installed on a Linux server. Recently they requested a few add ons to be added to the site, Simple SEO URL and Recover Cart. I installed both add ons per the instructions and they both worked (well SEO had issues with adding items to the cart with sizes so we disabled it)

Since then ZenCart has been missing orders, not all of them just a few and I don't see a pattern to the ones missed. In trying to fix the problem I have removed the Recover Cart add on and turned on the PayPal IPN logging, this was about 1 week ago. Since then there have been 2 more missed orders. I can see in the PayPal log that it was sent we also got the notification of payment from PayPal. What I don't see is the response log from PayPal saying it was a success, the ones that did process do work. There isn't a record of the order in the Orders list either. Any guidance in what we should be looking at next?

As a side note, if the user is a new user to the site it is saving that information...

Thanks for any help!
Dave

[DrByte]

I would be surprised if the Recover Cart addon has any negative impact on PayPal functionality.

However, the various so-called SEO addons have been known to cause problems with IPN functioning. Merely turning them off doesn't always solve the problem. Sometimes it's necessary to remove the .htaccess alterations as well.

[dschwieg]

Thank you for the advice, I will reset that access to see if it solves the problem.

Thanks,
Dave

[dschwieg]

I would be surprised if the Recover Cart addon has any negative impact on PayPal functionality.

However, the various so-called SEO addons have been known to cause problems with IPN functioning. Merely turning them off doesn't always solve the problem. Sometimes it's necessary to remove the .htaccess alterations as well.

DrByte,

We had the "no order" issue happen again after I reverted the .htaccess change. Is there some sql I can run to possiblly see the orders that are not showing up?

Do you or anyone have any ideas what would be causing this sporatic issue?

Thanks for any help you can give,
Dave

[dschwieg]

I just checked the orders table and it is not in there and I do have the log in the paypal\logs directory.

Thanks again,
Dave

[DrByte]

I do have the log in the paypal\logs directory.

... and you're not sharing that info because ...?

[dschwieg]

Sorry, I have cleaned and personal/private info

the ... points to the actual urls

Feb 20 2009 10:36 -- Keys for submission: Array
(
[charset] => iso-8859-1
[lc] => US
[page_style] => Primary
[custom] => zenid=XXXXXXX4dc5b48a6ffd0cfd34faab2
[business] => [email protected]
[return] => .../storefront/index.php?main_page=checkout_process&referer=paypal
[cancel_return] => .../storefront/index.php?main_page=checkout_payment
[shopping_url] => .../storefront/index.php?main_page=shopping_cart
[notify_url] => .../storefront/ipn_main_handler.php
[redirect_cmd] => _xclick
[rm] => 2
[bn] => zencart
[mrb] => R-XXXX2H795591R
[pal] => XXXXXXBKKGPLQ
[first_name] => FName
[last_name] => LName
[address1] => 111 Main St
[city] => City
[state] => ST
[zip] => 11111
[country] => US
[email] => email######################
[H_PhoneNumber] => 111111
[night_phone_a] => 111
[night_phone_b] => 111
[night_phone_c] => 1111
[day_phone_a] => 111
[day_phone_b] => 111
[day_phone_c] => 1111
[no_shipping] => 1
[upload] => 1
[currency_code] => USD
[cmd] => _ext-enter
[item_name] => www. ... .com Purchase
[item_number] => Store Receipt
[amount] => 120.00
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00


Feb 20 2009 10:37 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com