✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

SleekView for Affirm Payments for WooCommerce: charges & captures as tables

Affirm Payments for WooCommerce writes each order's Affirm charge ID and capture state into WooCommerce order meta. SleekView reads wc_orders joined with wc_orders_meta and renders Affirm orders as one queryable BNPL audit grid.

♾️ Lifetime License available

SleekView table view for Affirm Payments for WooCommerce

Affirm BNPL audit without the per-order panel

Affirm's WooCommerce gateway persists each transaction's Affirm charge ID, capture timestamp, and refund references on the order row via WooCommerce order meta. With HPOS enabled, that data lives in wc_orders_meta against wc_orders; on legacy stores it sits in wp_postmeta against shop_order posts.

The default WooCommerce orders screen treats Affirm-paid orders no differently from Stripe orders. There's no Affirm-only filter, no column for charge ID, and no built-in view for authorized-but-not-yet-captured loans waiting on settlement. Reconciliation against Affirm's merchant dashboard means CSV export plus spreadsheet joins, one row at a time.

SleekView reads wc_orders joined with wc_orders_meta and surfaces the Affirm charge ID, capture state, and refund references as first-class columns. Inline status edits route through WooCommerce's CRUD layer so Affirm's capture and refund hooks fire as expected. Finance reconciles by sorting on charge ID; ops captures authorized loans from one filtered view.

Workflow

Compose an Affirm audit view in minutes

1

Pick the order source

Point at wc_orders (HPOS) or shop_order posts and filter payment_method to the Affirm gateway slug. SleekView detects HPOS automatically.
2

Add Affirm meta columns

Drag the Affirm charge_id, capture state, and refund references from the column picker. Each is sortable and filterable from the column header.
3

Save the audit views

Build named views for authorized-not-captured, captured-this-week, refund-pending, and voided. Each is one filter combination saved per role.
4

Edit through the CRUD layer

Inline status changes route through WooCommerce order CRUD so Affirm's gateway hooks fire as expected. Bulk capture or void runs row-by-row through the same path.

Sample columns

A typical Affirm order view

Joins wc_orders with wc_orders_meta to expose the Affirm charge ID and capture state as sortable columns.
Source: wp_wc_orders + wp_wc_orders_meta (HPOS) or wp_posts (post_type=shop_order) + wp_postmeta
Order Status Customer Total Affirm charge ID Date
#62041 Captured alex@studio.co $248.00 X9YQ-2K4P Apr 24
#62040 Authorized ria@design.io $512.00 X9YQ-2K4N Apr 24
#62039 Captured tom@hello.dev $184.00 X9YQ-2K4M Apr 23
#62038 Voided mia@brew.coop $96.00 X9YQ-2K4L Apr 23

Comparison

Default Affirm Payments for WooCommerce admin vs SleekView

Default Affirm Payments for WooCommerce admin

  • Affirm charge ID is buried in per-order meta, not on the orders screen
  • No filter for authorized-but-not-captured Affirm loans
  • Reconciling against the Affirm merchant dashboard needs CSV exports plus spreadsheet joins
  • Refund references from Affirm aren't surfaced inline on wc_orders
  • Bulk capture or void runs through per-order screens one row at a time

SleekView

  • Read Affirm charge_id, capture timestamp, and refund references as real columns
  • Saved view for authorized-not-yet-captured Affirm loans before authorization expiry
  • Sort by Affirm charge ID to match merchant-dashboard exports row-for-row
  • Inline edits route through WooCommerce CRUD so gateway hooks fire as expected
  • Per-role saved views for finance, fulfilment, and support

Features

What SleekView gives you for Affirm Payments for WooCommerce

Affirm charge IDs as columns

Pivot the Affirm charge_id meta key into a named column. Filtering, sorting, and matching against Affirm's merchant dashboard exports become one click rather than a custom SQL query.

Authorized-not-captured filter

Build a saved view of Affirm orders authorized but not yet captured. Capture sweeps before authorization expiry run from one screen, with totals and customer email visible inline.

Inline edits through Woo CRUD

Status changes route through WooCommerce order CRUD so Affirm's capture, void, and refund hooks fire as the gateway expects. Bulk operations iterate per row through the same path, no skipped side effects.

Audience

Who uses SleekView for Affirm Payments for WooCommerce

Finance

Reconcile Affirm settlement against wc_orders sorted by Affirm charge ID. Filter by date range and currency for monthly close without leaving WP Admin.

Fulfilment

Filter to captured Affirm orders ready to ship with shipping address and line items visible inline. No per-order click-through for the daily pick list.

Support

Customer-rooted lookup: every Affirm-paid order for an email, with charge ID, capture state, and refund references on the row. Cuts the dispute call short.

The bigger picture

Why BNPL stores need joined order tables

BNPL gateways like Affirm record their own external charge IDs against each WooCommerce order, and the operational question for every store running one is which loans are authorized, which are captured, and which slipped through the authorization window without being captured. The default WooCommerce orders screen does not surface that distinction as a row-level column, so finance teams reconcile by exporting CSVs and joining them against the Affirm merchant dashboard in a spreadsheet. SleekView reads wc_orders joined with wc_orders_meta and puts the Affirm charge ID, capture state, and refund references on the row.

Authorized-not-captured becomes one saved filter. Reconciliation becomes a sort by charge ID. Inline edits route through the gateway's CRUD so capture, void, and refund hooks fire exactly as they would from the per-order screen.

The merchant still has the standard Orders screen if they prefer it; the BNPL audit surface is what changes for finance, fulfilment, and support.

Questions

Common questions about SleekView for Affirm Payments for WooCommerce

Yes. HPOS stores write to wc_orders plus wc_orders_meta; legacy stores write to wp_posts (shop_order) plus wp_postmeta. SleekView reads whichever store is active and keeps the Affirm column mapping identical so saved views survive the HPOS migration.

 

The Affirm charge_id meta key, capture-state flags, and any refund references the gateway writes per order. The column picker lists every Affirm-prefixed meta key actually present in your data, so you only see real fields.

 

Bulk status changes route through WooCommerce's order CRUD, so each row triggers Affirm's capture hook exactly like a manual capture in the order screen. No special bulk-mode that skips gateway side effects.

 

Yes. Refund rows linked to the parent order via WooCommerce's refund relationship appear as a joinable child table. Filter to orders with refunds in the last 30 days for the dispute queue.

 

Yes, when the gateway writes those fields to order meta. SleekView exposes any meta key with values present in your data, so multi-merchant or split-funded loan setups become a filterable column without code.

 

Currency lives on each order row. Filter or group by currency so Affirm reconciliation in USD stays separate from any other currencies your store accepts.

 

Yes. Saved views are gated by WordPress capability, so finance lands on a reconciliation view with Affirm charge IDs, fulfilment on a captured-ready-to-ship view, and support on a customer-rooted lookup.

 

Queries hit indexed columns on wc_orders (id, status, date_created_gmt). Joined meta filters use wc_orders_meta indexes. Keep heavier aggregates on detail views and lighter columns on triage views for fast pagination.

 

Pricing

More than 1000+
happy customers

Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

EUR

once

  • Unlimited websites
  • Lifetime updates
  • Lifetime support

...or get the Bundle Deal
and save €250 🎁

The Bundle (unlimited sites)

Pay once, own it forever

Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.

What’s included

  • SleekAI

  • SleekByte

  • SleekMotion

  • SleekPixel

  • SleekRank

  • SleekView