Add PayPal fee

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″;}}