danrimer Posted April 13, 2022 Share Posted April 13, 2022 Hi there Before switching to the ps_checkout module I was able to track the transactionIDs for PayPal payments directly in the PrestaShop database. I use a remote db connection to check for new orders etc and as part of my process, I check the emails received from PayPal with the transaction IDs that are stored in the ps_paypal_order table. I've managed to spot a few missed orders over the years with this approach. Now I am using PrestaShop Checkout for all my transactions, I cannot find anything in the database that looks right! The values that are in the ps_pscheckout_cart and ps_pscheckout_order_matrice tables, under the heading 'id_order_paypal' don't match anything on PayPal's website (or the emails I have received). Can anyone tell me how to get the (correct) transactionID from the database please? Link to comment Share on other sites More sharing options...
Tárraga Posted January 19 Share Posted January 19 Hi there, have you found a solution for this? Best regards. Link to comment Share on other sites More sharing options...
Nickz Posted January 19 Share Posted January 19 (edited) On 4/13/2022 at 10:34 AM, danrimer said: Can anyone tell me how to get the (correct) transactionID from the database please? search the database for Paypal you might get that info. Depemding on version it could be PS_OS_PAYPAL Edited January 19 by Nickz (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now