CRE Loaded Community

Have been running CRE loaded now for the past 2 years.

Currently we have about 30 carts running and they are all experiencing the same issue. That is that invoices are randomly deleted. We have noticed it more recently after seeing customers paying via paypal and then having no matching invoice on the system. The invoice numbers are just missing.

We have moved server a few times in the past 2 years from a shared server/ VPS and now a dedicated quad core machine and the issue has been on all platforms

We currently run centos 5.6 and Mysql 5.1.56

We are running CRE loaded 6.4.1A on all carts.

Was just wondering if anyone else has seen anything like this or might have an suggestions.

When checking the following tables in mysql no entries are found for the missing invoices.

Orders
orders_products
orders_status
orders_total

Any feedback would be appreciated

do they all have the same payment method involved ? i'd be looking at that pattern, esp if it's a paypal module.

simon

No pattern to payment.

We only use paypal currently but we have had orders that haven't been completed and left pending that have been deleted.

Its sounds more database related to me but was hoping I wasn't the only one with the issue.

A further thought makes me think you could be on the right track. Although we get some invoices left at pending we only offer paypal as a payment method so all orders have been initiated using the paypal payment method.

We are using the

Module that comes with CRE "Paypal Website Payment standard"

Being the generic payment module that comes with the software I would have thought I wouldst be alone with the issue.

I will start my investigation there

generic and probably worked ok about 5 years ago, but times have changed and that module hasn't for cre.
main 6.4 feature is cre's move to it's own payment module (cresecure) so the free ones like PP WSP not likely to be supported again.

hv a look at your setup of the module too - i wrote this based on what works on my server:
http://www.codemehappy.com/2011/06/how- ... rd-module/

simon

I will check that out and let you know what I find.

Im was thinking about cutting over one of the sites to the paypal pro payment module to see if that stops the issue over the next week before seeing you reply but will go over your post first.

Thanks again for taking the time to reply

also worth optimizing tables in the database, making sure that the rows are in a row if you know what i mean.
one corruption back on row 1234 can stuff things up for the rest of the table (ie cumulative failure)

simon

Simon

Went over your post and compared to ours.

A few things to comment on. Unlike you we have the synchronize invoice option to TRUE.

This is because we use one paypal account to service 30 CRE installs. With the invoice information being passed to Paypal it makes the process of accounting and any manual cross checking done at a later time easier having the invoice number listed on paypal.

This initially caused a problem as you rightly mentioned. This is overcome by having payment receiving preferences for blocking accidental payments changed to allow multiple payments per invoice no. Without this option being selected in paypal the second a duplicate invoice number is created from any of the cre carts paypal throws up an error saying cant process transaction. This will allow this to be overridden.

With regards to the return URL for customer and IPN we have been using the ipn.php all this time under paypal settings. I was under the impression the return url and IPN url's had been sent via the IPN transaction as we have been successfully taking payments on multiple domains. If the static one listed with paypal had been used 29 of the 30 sites wouldn't have ever taken a transaction.

I have seen that the IPN paypal transaction has parameters for return URL ie "return" and "cancel_return".

Im going to check if this is getting passed correctly.

Thanks again for the input and any further ideas you might have

Lee

A little update.

I checked includes/modules/payment/paypal.php

I can see in there that the following are all handled withing and from our experience I am assuming these values being passed within the IPN call to paypal are overriding the setting made within the paypal admin console.

notify_url
return
cancel_return

FILENAME_IPN is used as the value for notify_url and is set as follows at line 18 of the paypal.php module shipped with the CRE Loaded v6.4.1a install

define('FILENAME_IPN','ipn.php');

Your posting implied that using the ipn.php is wrong so was just interested in your thoughts before I change to checkout_process.php as you suggested.

Lee