{"id":4068,"date":"2017-10-20T15:53:05","date_gmt":"2017-10-20T15:53:05","guid":{"rendered":"https:\/\/demos.welaunch.io\/wordpress-cf7-paypal\/?post_type=faq&#038;p=516"},"modified":"2020-07-29T14:44:40","modified_gmt":"2020-07-29T12:44:40","slug":"paypal-variables-success-mail","status":"publish","type":"faq","link":"https:\/\/www.welaunch.io\/en\/knowledge-base\/faq\/paypal-variables-success-mail\/","title":{"rendered":"PayPal Variables for the Success Mail"},"content":{"rendered":"<h2>Enable PayPal Payment Data Transfer<\/h2>\n<p>In order to receive data back from PayPal make sure you return data to the return (success) URL.<\/p>\n<p>See: https:\/\/developer.paypal.com\/docs\/classic\/paypal-payments-standard\/integration-guide\/paymentdatatransfer\/ &gt; Activating PDT<\/p>\n<p>You can make sure, that it works, when you see some parameter in your URL like ?txn_id=XXX after a successfull payment.<\/p>\n<h2>Available Data from PayPal<\/h2>\n<p>The shortcodes for the emails, that can be used are:<\/p>\n<ul>\n<li>item_number<\/li>\n<li>txn_id<\/li>\n<li>payment_gross<\/li>\n<li>currency_code<\/li>\n<li>payment_status<\/li>\n<li>cf7_paypal_unique<\/li>\n<\/ul>\n<h2>Where is the Data stored?<\/h2>\n<p>In your database there will be a table called wp_cf7_paypal. Please look if the database table looks like this:<\/p>\n<figure id=\"attachment_5522\" aria-describedby=\"caption-attachment-5522\" style=\"width: 980px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5522\" src=\"https:\/\/www.welaunch.io\/en\/wp-content\/uploads\/sites\/8\/2017\/10\/paypal-database.jpg\" alt=\"paypal database\" width=\"980\" height=\"293\" srcset=\"https:\/\/www.welaunch.io\/en\/wp-content\/uploads\/sites\/8\/2017\/10\/paypal-database.jpg 980w, https:\/\/www.welaunch.io\/en\/wp-content\/uploads\/sites\/8\/2017\/10\/paypal-database-247x74.jpg 247w, https:\/\/www.welaunch.io\/en\/wp-content\/uploads\/sites\/8\/2017\/10\/paypal-database-510x152.jpg 510w, https:\/\/www.welaunch.io\/en\/wp-content\/uploads\/sites\/8\/2017\/10\/paypal-database-300x90.jpg 300w, https:\/\/www.welaunch.io\/en\/wp-content\/uploads\/sites\/8\/2017\/10\/paypal-database-768x230.jpg 768w\" sizes=\"auto, (max-width: 980px) 100vw, 980px\" \/><figcaption id=\"caption-attachment-5522\" class=\"wp-caption-text\">paypal database<\/figcaption><\/figure>\n<p><strong>If not:<\/strong> Drop the table and reactivate the plugin.<\/p>\n<h2>Flamingo DB<\/h2>\n<p>Entries will be stored in Flamingo DB plugin.<\/p>\n<p>If the flamingo database entry do not get updated, please provide the success URL (after payment) to support@welaunch.io. Also please send WP-Admin &amp; FTP and we will look into your issue \ud83d\ude42<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","product_cat":[],"class_list":["post-4068","faq","type-faq","status-publish","hentry","faq_topics-paypal-integration"],"_links":{"self":[{"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/faq\/4068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/types\/faq"}],"author":[{"embeddable":true,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/comments?post=4068"}],"version-history":[{"count":5,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/faq\/4068\/revisions"}],"predecessor-version":[{"id":5525,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/faq\/4068\/revisions\/5525"}],"wp:attachment":[{"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/media?parent=4068"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.welaunch.io\/en\/wp-json\/wp\/v2\/product_cat?post=4068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}