Skip to content
+

Combine WooCommerce with PayPal to get the real payment fee on every order

A WooCommerce store that takes PayPal payments from international buyers usually only knows the order total, while PayPal fees, currency conversion fees and refunds live in PayPal. With both sources combined, DataxLand links PayPal transactions to WooCommerce orders by order ID or transaction ID, and computes the real payment fee, net revenue after refunds and contribution margin for each order. You know exactly how much each PayPal order leaves you with, instead of estimating from the published fee rate.

Free plan with no time limit · No card required · Sample workspace ready in minutes

Why combine

  • PayPal fees vary by buyer country, currency and transaction type; estimating with one fixed rate is wrong.
  • Refunds and disputes are recorded in PayPal, sometimes weeks later.
  • Only combining the two lets you compute contribution margin after payment fees for each order.

Metrics you only get by combining

MetricHow it is computed
Payment feesTotal fees of the PayPal transactions linked to the orderMatched by the order ID or transaction ID that WooCommerce stores at checkout.
Net revenueRevenue after discounts and refunds
Contribution marginNet revenue − cost of goods − marketplace fees − payment fees − seller-paid shipping
Return rateReturned orders ÷ valid orders

Standard metrics from the analytics packs

Once both sources map to the same model, these metrics run on the joined data with one definition.

MetricDefinitionUnit
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Contribution marginNet revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return costCurrency
Return rateReturned orders divided by valid orders.= returned_orders / Valid ordersRatio (%)

Questions you can answer

QuestionWooCommerce onlyWooCommerce + PayPal combined
Payment fee per order?Not availableReal fee from the PayPal transaction
Late refunds?Only when updated by handFrom PayPal refund transactions
Contribution margin?Missing payment feesComplete

Steps

  1. 1

    Connect WooCommerce

    Enter your store domain plus the consumer key and consumer secret of the WooCommerce REST API (read access).

  2. 2

    Connect PayPal

    Enter the client ID and client secret of your PayPal REST app, choose the live environment and the start date for transactions.

  3. 3

    Review Si's mapping

    Si proposes which field in WooCommerce orders holds the PayPal transaction ID for matching; you check a few sample orders and approve.

  4. 4

    Build and read the dashboards

    The P&L overview and Sales channels dashboards show real payment fees and contribution margin; ask Si which months PayPal fees went up.

Frequently asked questions

What about orders not paid through PayPal?

Orders through other gateways have no PayPal transaction; their payment fees come from another source you connect, or stay blank and Si reports which orders have no fee yet.

What permissions does the PayPal key need?

A REST app in PayPal Developer with read access to transactions (Transaction Search). Paste the client ID and secret; DataxLand only reads and never creates or refunds transactions.

Which plan can combine two sources?

The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.

Dashboard templates that use this source

Connect WooCommerce →Connect Paypal Transaction →Ask Si about your WooCommerce data →Ask Si about your Paypal Transaction data →

Other combinations

Combine WooCommerce and Paypal Transaction in minutes

Free plan with no time limit · No card required · Sample workspace ready in minutes