hi
Could you try >Setup Fields>Common>Add Field and seek for necessary key in the dropdown?
thanks, Alex
Thank you for your reply.
But I couldn’t find “PayPal fee” in the drop-down menu!
Which one should I select and which meta key should I write?
what PayPal plugin do you use ?
I’m using WooCommerce PayPal Payments
What I need to export : PayPal payout
Please see this picture
https://ibb.co/zsDBqhC
Thank you
try key _ppcp_paypal_fees
You must open section “Misc Settings” and add this code too
add_filter('woe_get_order_value__ppcp_paypal_fees',function ($value, $order,$fieldname) {
$data = maybe_unserialize($value);
if( isset($data['net_amount']['value']) )
$value = $data['net_amount']['value'];
return $value;
},10,3);
May I know where to open the section “Misc Settings”?
Hi
Please, scroll the page to bottom.
This section is just above button Preview.
Thank you so much! I added the code but I can not find the key _ppcp_paypal_fees.
Just type it in textbox.
Look at 1st screesnhot at page https://docs.algolplus.com/algol_order_export/fields/
It didn’t work. Please help me to check if I setup anything wrong
https://ibb.co/dgH220d
So you pressed “Confirm” and dragged new field to left column , but new column is empty?
do you use ” WooCommerce PayPal Payments” ?
Hi! Love this plugin! I wish to add PayPal Fee as well. I followed the instructions above which worked – sorta. I used the key _ppcp_paypal_fees in and added the extra code. But instead of giving the PayPal Fee in a column, it is giving the PayPal Payout. Weird. Is there a way to get the negative amount that I am looking for?
Also what is the proper Field format to use for this key? I am exporting to XLS. Thank you
Hello
1. please, run PhpMyAdmin , open table wp_postmeta , find meta_key = _ppcp_paypal_fees and copy/paste value to this ticket.
2. you should use Money.
thanks, Alex
Hi Alex, Well I tried to do #1. I’m lost. Don’t know a lot about PhpMyAdmin. Found it in site tools with my hosting company and tried a plugin to do the find meta_key = _ppcp_paypal_fees search and get the value. I cant figure out how to search, so I manually looked around and found something in the table wplt_postmeta. Cant find the wp_postmeta table, so not sure if it is right. From what I can see, this is the value given for one transaction. Can you pull what you need from it or do I need to look again? If I need to look again, may I please have some guidance?
a:3:{s:12:”gross_amount”;a:2:{s:13:”currency_code”;s:3:”USD”;s:5:”value”;s:5:”40.00″;}s:10:”paypal_fee”;a:2:{s:13:”currency_code”;s:3:”USD”;s:5:”value”;s:4:”2.49″;}s:10:”net_amount”;a:2:{s:13:”currency_code”;s:3:”USD”;s:5:”value”;s:5:”37.51″;}}
