Is the Payment Gateway Fee identified in the order record?

  • Resolved webdad2000

    (@webdad2000)


    4 years, 10 months ago

    Site is up and running, and I have an export routine that exports the order details and the Order Item details.

    I’m trying to find the field in the database that represents the transaction processing fee for when the order was placed. Is that data available?

    I don’t charge any extra fees, so this isn’t a custom field. Basically, when PayPal clears the transaction they take their 2.x% and that associated fee is what I’m looking for.

    Haven’t been able to find that field yet.

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    Hi @webdad2000

    PayPal Standard and most payment gateways write to the wp_postmeta table. The PayPal fee is written as a meta_value to meta_key PayPal Transaction Fee. You can find this information by searching the postmeta using a specific order number.

    Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    Hi @webdad2000

    We’ll mark this thread as resolved now that we haven’t heard back. Please feel free to open a new thread if you have any additional questions or concerns.

    Regards,

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Is the Payment Gateway Fee identified in the order record?’ is closed to new replies.