CODEWITHSUNDEEP
wordpresswoocommercepaypal-ipn
Paul Yih
Paul Yih

Reputation: 39

PayPal IPN in WooCommerce

I am just wondering which table stored the PayPal IPN in WooCommerce. The dashboard in wordpress(woocommerce) can not see so much information in the PayPal IPN, only few of them like Payer first name,Payer last name,Payer PayPal address,Payment type,PayPal Transaction Fee. I want to see more about the IPN data such as if the paypal is verified, phone number, registered country, etc.

Upvotes: 0

Views: 733

Answers (2)

PPP
PPP

Reputation: 1

Some might need the IPN data from PayPal to feed into other in-house operational processes, like shop floor order processing, etc., rather than having woocommerce consume all the IPN data and only 'keep' part of it for display. Better to either save it all, or offer a configuration option to specify a 2nd IPN listener the data could be piped to, in order to facilitate automation of other order processing systems.

Upvotes: 0

Elad
Elad

Reputation: 894

In your dashboard You will see:

Order #ORDER_NUMBER details
Payment via PayPal (`PayPal Transaction ID`).

In your PayPal account access Instant Payment Notification (IPN) details page. profile -> selling preferences -> Instant Payment Notification Preferences. Click IPN History page and search the transaction id that you see in WooCommerce. You will see all the information about this IPN. HTTP response code, Delivery status, the actual message sent by PayPal.

You can also access the transaction id from WooCommerce table.

select meta_value
from wp_postmeta
where post_id=ORDER_NUMBER and meta_key='_transaction_id'

replace ORDER_NUMBER with your WooCommerce order number.

Upvotes: 1

Related Questions