Allocating Shop Pay Installments Fees In Per-Order CM
Shop Pay Installments costs 5.99%+30¢ per order versus 2.9%+30¢ for cards. Here's how to segment contribution margin by payment method so installment-heavy cohorts don't silently drag blended CM down.
Quick answer
Tag every Shop Pay Installments order at ingest with its payment method, then charge that order the full 5.99% + 30¢ fee (not your blended card rate) inside the contribution-margin calculation. Report CM segmented by payment method — installments vs cards — so a rising BNPL mix can't hide inside a blended average.
Allocating Shop Pay Installments Fees In Per-Order CM
Assigning the true 5.99% + 30¢ Shop Pay Installments processing fee to each BNPL order when computing contribution margin.
Shop Pay Installments is Shopify's Affirm-powered split-pay option. Shopify charges the merchant 5.99% + 30¢ per installment order — roughly double the 2.9% + 30¢ standard card rate on Shopify Payments. If your per-order CM formula uses a blended processing rate, every installment order is under-costed and every card order is over-costed. Segmenting CM by payment method means tagging each order with the fee schedule that actually applied, so you can see the true margin on BNPL volume, spot cohorts where installments erode profitability, and price-in the fee delta when planning promotions on high-AOV SKUs.
Most Shopify P&L exports report processing fees as one line — a blended number that hides the BNPL premium. That's fine for the bank reconciliation. It's actively misleading for CM analysis, promo planning, and paid-CAC ceilings.
The fee delta looks small in isolation: about 3.09 percentage points. On a €180 apparel order that's €5.56 of extra fee. On a €900 furniture order it's €27.81 — enough to flip a promo campaign from profitable to loss-making without anyone noticing in a weekly dashboard.
Why the blended rate quietly breaks
Shop Pay Installments skews toward higher-AOV orders — that's the whole reason shoppers use it. So the orders paying the higher fee are also the orders with the largest absolute fee impact. Blended reporting averages them into the pool and dilutes the signal.
The failure mode is gradual. Installments share creeps from 6% to 14% of orders over two quarters. Blended CM ticks down 40-70 basis points. Finance flags it as "mix shift" and moves on. The real story — that a specific payment method is eating margin on your best orders — never surfaces.
The silent drag
If installments share doubles from 8% to 16% and you don't re-allocate fees, blended CM drops roughly 25 bps with zero change in unit economics, discounting, or product mix. It's a pure reporting artefact — but it looks identical to a real margin problem, so teams often over-correct by cutting ad spend.
Tagging orders at ingest
The cleanest fix is to tag the payment method on every order the moment it lands in your warehouse or analytics store. Shopify's Order API exposes `payment_gateway_names` and the transaction-level `gateway` field; for installments the value is `shopify_payments` with a `payment_method_details.type` of `shop_pay_installments`.
From there, your CM job branches: if the order is installments, apply 0.0599 × gross + 0.30. Otherwise apply your standard Shopify Payments rate. Store the fee as its own column on the order row — don't recompute it every time you query.
The reason to persist the fee, not derive it, is that Shopify's rate cards change. When you renegotiate, you want historical CM to reflect the fee that actually cleared, not what today's rate would imply. This matters even more for cross-border orders where Shop Pay Installments layers on additional FX handling.
What the CM drag looks like by category
Estimated CM drag from unallocated Shop Pay Installments fees, by vertical and installments share
| Vertical | Avg AOV | Installments share | Blended CM drag (bps) | Effective fee delta per BNPL order |
|---|---|---|---|---|
| Apparel | €95 | 9% | 12 bps | €3.24 |
| Beauty & skincare | €65 | 6% | 6 bps | €2.31 |
| Footwear | €145 | 12% | 22 bps | €4.78 |
| Home & decor | €310 | 18% | 48 bps | €9.88 |
| Furniture | €780 | 24% | 95 bps | €24.40 |
| Consumer electronics | €420 | 15% | 38 bps | €13.28 |
Furniture stores see roughly 3× the CM drag of apparel because both drivers stack: higher AOVs mean larger absolute fee gaps, and higher installments share means more orders paying that gap. If you sell furniture and your CM report is blended, you're probably reading a number 80-100 bps kinder than reality.
Where the segmented number goes
Two numbers, two audiences. Blended CM stays in the CFO deck because it matches bank statements and P&L exports. Payment-method-segmented CM lives in the growth and merchandising dashboards, where the decisions that touch payment mix actually get made — paid-CAC ceilings, free-shipping thresholds, promo eligibility, and financing surface placement.
The paid-CAC ceiling is the most important consumer. If 20% of your orders come through installments at a 300 bps fee premium, your effective ceiling on those orders is lower — even if lifetime value is identical. A rising installments share should mechanically pull your target CAC down, not stay flat.
Detecting the leak in your current setup
Run this diagnostic: pull the last 90 days of orders, split by payment method, compute average processing fee per order in each group. If your installments group averages under €4-5 on a €200+ AOV, your CM job is applying a blended rate and under-costing every BNPL order in the file.
A second check: compare month-over-month blended CM against installments share. If blended CM moves in near-perfect inverse to BNPL mix — with no other explanation — you're watching a reporting artefact, not a margin problem. The fix is allocation, not a discount pullback.
Experiments worth running once you can segment
Segmented CM unlocks tests that were previously unreadable. The obvious one: raise the AOV threshold where Shop Pay Installments appears on the PDP — hide it below €150, say — and measure whether cannibalised card conversions offset the recovered fee margin. Without segmentation you can't tell if you won or lost.
A second experiment: compare Shop Pay Installments against Klarna or Afterpay on effective fee after chargeback shift. Different providers absorb different risk, and the effective fee — not the sticker rate — is what belongs in CM. Once the tagging pipeline exists, swapping one provider comparison for another is trivial.
Frequently asked questions
5.99% + 30¢ per successful installment order in the US market, versus 2.9% + 30¢ for standard online card transactions on Shopify Payments. The merchant is paid in full upfront by Affirm; the fee premium covers Affirm's risk and financing cost.
Because Shop Pay Installments skews to high-AOV orders, the fee premium compounds on your most profitable orders. A blended rate under-costs BNPL orders and over-costs card orders, which distorts promo ROI, paid-CAC ceilings, and any decision that depends on true per-order margin.
In Shopify's Order API, check the transaction gateway. Installment orders come through `shopify_payments` with a `payment_method_details.type` of `shop_pay_installments`. Persist a boolean or enum on the order row so your CM job can branch cleanly on it.
Usually no — CFOs want the number that matches bank statements and the P&L. Segmented CM goes to growth, merchandising, and pricing teams. The two should reconcile at the total-fee level; they should intentionally diverge at the per-order level.
It depends on your incremental conversion lift. As a rough anchor: on a 3% conversion lift assumption, installments are net-positive up to around €400-500 AOV in apparel and beauty. Above that the fee delta grows faster than most realistic lift assumptions can offset — furniture and large-ticket electronics are the usual break points.
The break-even lift is roughly (fee delta) ÷ (contribution margin per order without installments). On a €200 order with 40% CM, a €5.86 fee delta needs about a 7.3% incremental conversion lift on the BNPL-eligible cohort. Below that, installments are a margin donation.
Sticker rates are similar — Klarna and Afterpay charge in the 5.5-6.5% range plus a fixed fee. Effective rates differ once you factor in chargeback shift, refund handling, and settlement timing. Compare on effective fee per settled order, not the rate card.
Sum your per-order allocated fees for the payout window and compare against the payout's fee total. Small variances come from refund timing and cross-border FX; large variances (>1%) usually mean your tagging is missing a payment method or your rate assumption is stale.
Not automatically. First confirm whether blended CM is dropping because of a real margin problem or because rising BNPL mix is dragging the average through unallocated fees. The right response to a reporting artefact is fixing the allocation, not pulling paid spend.
No. Regular Shop Pay is a checkout accelerator on top of Shopify Payments — it uses your standard card rate (2.9% + 30¢). Only the installments product carries the 5.99% + 30¢ fee. Tag the two separately so you don't accidentally penalise the accelerator.
Get an AI expert review of your site
Paste your URL — Metricuno's AI runs the same heuristic checks a senior CRO consultant would, scoring your page and prioritising the fixes that'll move conversion fastest.