[ SOLVED ] PayPal Module and Orders Not Showing in Prestashop

[helpmeplease]

Hi,

I'm using Prestashop 1.3.1, with PayPal module v1.6

All has been working fine (or so I thought) for the last 10 days of the shop being live

My customer has been receiving all their orders without problem through PayPal

For the first 2 days (up to 9th September) I checked orders were going through and viewed them under the orders tab - absolutely fine.

Unfortunately I checked these yesterday, the orders tab is only showing the first couple of days worth of orders up to the 9th September - up to order 85 - Nothing for the last week!

It's also only showing 2 days worth of orders in the stats pages.

I checked with my customer and they are still getting orders through PayPal - approx 40 - 50 a day.

I've searched on the forum and can see people were having similar problems earlier in the year....but there didn't seem a definite solution apart from a quick fix of switching to PayPal API and that didn't always work?

I've tried uninstalling the PayPal 1.6 module and reinstalling.

Am I missing an obvious setting in the admin section? or could I have accidently overwritten an important file?

Are there specific files that control this functionality I could simply re-install to fix the problem?

Sorry if I'm clutching at straws!

Hope someone can help?

Thanks in advance

Best wishes

Brian

[Cal]

I don't know the solution but this can help you investigate :

Check if there is an error on the prestashop side by setting debugging in config/config.inc.php :

/* Debug only */
@ini_set('display_errors', 'on');
define('_PS_DEBUG_SQL_', true); 

In paypal account you can check or add the url to modules/paypal/validation.php in preferences > notification (don't remember exactly the name).

[helpmeplease]

Hi Cal,

Thanks for the note - but I think I've uncovered the problem...

It was only as I looked at the dates that the penny dropped!

It was my fault as I'd made a small change to the redirect.tpl file in the PayPal module folder

I was trying to get a reference number to show up in the PayPal Order

I'd updated two bits of code - the line below was the one I'd altered incorrectly (this is how it should look)

<input type="hidden" name="custom" value="{$cart_id}" />

Without this line of code, orders were going through PayPal but not updating in the orders tab

Anyway I've reverted this file back to the original and the orders are coming through!

Another example of me meddling and causing problems!

Thanks again for your help

Best Wishes

Brian

[shokinro]

I got the similar problems a few days ago. After search around, following post gave me a lot of help to solve my problem.

http://www.presto-changeo.com/content/10-fixing-paypal-problems

Even I fixed the problem, because there is no standard modules and functions to recover the missed orders. I had to do it manually by input to database table. Later I found a way to modify the AdminCarts.php to add function to "Create Order" from existing order. Here you can find the details on how to do this.

http://alvinjiang.blogspot.com/2010/09/prestashop-tips-how-to-create-order.html

Hope this could help you save some time.