Paypal module Payment Status wrong

[Alan]

Hi,

I have an issue with the paypal module (5.4.5) where the order status is set to Awaiting cheque payment instead of payment accepted.  The payment has succesfully gone through on paypal.  I am also using the Stripe module with no issues.

I have looked through the module and also the database but couldn't see anything that stood out.  

Could anyone offer some advice?

 

[haylau]

This occasionally happened with us when a customer using Paypal used their 'e-cheque' system. So although the payment is on paypal it is actually a cheque and can take a few days to clear (and sometimes bounces) I think it was when a customer does not have enough paypal funds for the transaction, so it falls back to the attached credit / debit card, but if that has a problem (expired) then they go all the way back to the customers bank account. PayPal used to insist on this option being available, but it is now optional. 

If that is the problem, you can disable it in the paypal account settings (on Paypal itself not the module)

[datakick]

Look into database. table <prefix>_configuration and check value of configuration key PS_OS_PAYMENT

 

select name, value from tb_configuration where name = 'PS_OS_PAYMENT';
+---------------+-------+
| name          | value |
+---------------+-------+
| PS_OS_PAYMENT | 1     |
+---------------+-------+

The value contains ID of order status that will be used when paypay module process the payment. You can compare it with the value in table <prefix>_order_state_lang 

select id_order_state, name from tb_order_state_lang where id_lang = 1;
+----------------+--------------------------------------+
| id_order_state | name                                 |
+----------------+--------------------------------------+
|              1 | Payment accepted                     |
|              2 | Processing in progress               |
|              3 | Shipped                              |
|              4 | Delivered                            |
|              5 | Canceled                             |
|              6 | Refunded                             |
|              7 | Payment error                        |
|              8 | On backorder (paid)                  |
|              9 | Awaiting bank wire payment           |
|             10 | Awaiting PayPal payment              |
|             11 | Remote payment accepted              |
|             12 | On backorder (not paid)              |
|             13 | Awaiting Cash On Delivery validation |
|             20 | Awaiting Bitcoin Payment             |
|             21 | Waiting for 2 Confirmations          |
|             22 | Bitcoin Payment Confirmed            |
+----------------+--------------------------------------+

In my case, it matches the Payment accepted order state. I bet in your store this configuration option will point to different state. If that's the case, then update the configuration value to point to expected order state.

[Alan]

2 hours ago, datakick said:

Look into database. table <prefix>_configuration and check value of configuration key PS_OS_PAYMENT

 

......

......

In my case, it matches the Payment accepted order state. I bet in your store this configuration option will point to different state. If that's the case, then update the configuration value to point to expected order state.

This was exactly the problem, awaiting cheque payment was an extra line at the start of table <prefix>_configuration.  So I just amended all the values by 1 to ensure they matched table <prefix>_order_state_lang.

Thanks for the quick response!