✨ 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 Zip Pay for WooCommerce: orders & charge IDs as tables

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

♾️ Lifetime License available

SleekView table view for Zip Pay for WooCommerce

Zip Pay BNPL audit without the per-order panel

The Zip Pay WooCommerce gateway persists each transaction's Zip charge ID, authorize/capture state, 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 Zip Pay orders the same as any other gateway. There's no column for the Zip charge ID, no filter for authorized-not-yet-captured Zip loans, and reconciling against Zip's merchant portal currently means CSV exports plus spreadsheet joins.

SleekView reads wc_orders joined with wc_orders_meta and surfaces the Zip charge ID, capture state, and refund references as first-class columns. Sort by charge ID to match Zip's portal row-for-row, filter for the capture queue, and inline-edit status with the gateway's hooks fully intact.

Workflow

Compose a Zip Pay audit view in minutes

1

Pick the order source

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

Add Zip meta columns

Drag the Zip 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 declined. One filter combination saved per role, gated by capability.
4

Edit through the CRUD layer

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

Sample columns

A typical Zip Pay order view

Joins wc_orders with wc_orders_meta to expose the Zip 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 Zip charge ID Date
#91503 Captured alex@studio.co $148.00 ch_5K7n2Lp9 Apr 24
#91502 Authorized ria@design.io $364.00 ch_5K7n2Lp8 Apr 24
#91501 Captured tom@hello.dev $92.00 ch_5K7n2Lp7 Apr 23
#91500 Declined mia@brew.coop $216.00 ch_5K7n2Lp6 Apr 23

Comparison

Default Zip Pay for WooCommerce admin vs SleekView

Default Zip Pay for WooCommerce admin

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

SleekView

  • Read the Zip charge ID and capture state as real columns
  • Saved view for authorized-not-captured Zip loans before authorization expiry
  • Sort by charge ID to match Zip's merchant portal row-for-row
  • Inline edits route through WooCommerce CRUD with gateway hooks intact
  • Per-role saved views gated by WordPress capability

Features

What SleekView gives you for Zip Pay for WooCommerce

Zip charge IDs as columns

Pivot the Zip charge ID meta key into a named column. Filtering, sorting, and matching against Zip's merchant portal exports become one click rather than a custom SQL join against wc_orders_meta.

Authorized-not-captured filter

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

Inline edits via Woo CRUD

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

Audience

Who uses SleekView for Zip Pay for WooCommerce

Finance

Reconcile Zip's merchant portal against wc_orders sorted by Zip charge ID. Filter by date range and currency for monthly close without leaving WP Admin.

Fulfilment

Filter to captured Zip 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 of every Zip-paid order for an email, with the charge ID and capture state on the row. Refund references surface inline during the call.

The bigger picture

Why ANZ BNPL stores need joined order tables

Zip Pay is one of the dominant BNPL gateways for Australian and New Zealand WooCommerce stores, and its lifecycle follows the same authorize-then-capture pattern as Affirm and Afterpay. Orders sit in authorized state waiting for merchant capture, and capture windows expire if not actioned. The default WooCommerce orders screen does not surface the Zip charge ID or capture state on the row, so finance teams reconcile by exporting CSVs and joining against Zip's merchant portal in a spreadsheet.

SleekView reads wc_orders joined with wc_orders_meta and puts the Zip charge ID, capture state, and refund references on the row. Authorized-not-captured becomes one saved filter that runs the daily capture sweep. 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 Zip Pay 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 Zip column mapping identical.

 

The Zip charge ID, capture-state flags, and any refund references the gateway writes per order. The column picker lists every Zip meta key with values actually present in your data.

 

Bulk status changes route through WooCommerce's order CRUD, so each row triggers Zip'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, and any Zip merchant-portal refund references the gateway writes are exposed as columns.

 

Currency lives on each order row. Filter or group by currency to keep AUD Zip reconciliation separate from NZD or USD where Zip operates.

 

Yes. Saved views are gated by WordPress capability, so finance lands on a reconciliation view with Zip 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 to keep query plans fast under load.

 

Yes, when the gateway writes them to order meta or as WooCommerce refund rows. Each appears as a column or joinable child row, so the audit view shows the full capture/refund history per order.

 

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