SleekView for Paystack: gateway transactions as tables
Paystack for WooCommerce stores the transaction reference, payment channel, and gateway response against each order's meta. SleekView reads those fields directly so finance teams can reconcile against the Paystack dashboard without per-order clicks.
♾️ Lifetime License available
Paystack reconciliation as one screen
Paystack for WooCommerce records each successful payment with the Paystack transaction reference (often called txn_ref) and the channel (card, bank, USSD, mobile_money, qr) stored in the order's meta. On HPOS stores those values land in wc_orders_meta; on legacy stores they live in postmeta. The default Orders screen shows order number, status, total, and customer, but the gateway-side fields stay invisible until you click into each order.
SleekView reads the order tables alongside the Paystack meta keys and presents one row per order with the transaction reference, the payment channel, and the gateway response status where stored. Filter to Paystack-paid orders for a date range, group by channel to see what proportion of orders came in via card versus bank versus mobile money, scope to refunded orders to reconcile against the Paystack refund report. Inline-edit order status routes through WooCommerce's CRUD layer where supported, so the WooCommerce-side status stays consistent with the gateway-side hooks.
The view stops at what's stored against the order. Paystack's authoritative settlement and chargeback data still lives on the Paystack dashboard. SleekView's job is to make the WooCommerce side legible enough that reconciliation against Paystack becomes a side-by-side comparison rather than a per-order spelunking exercise.
Workflow
Compose Paystack reconciliation views from WooCommerce order data
Pick a base scope
payment_method = paystack for the reconciliation queue, or any order view with Paystack columns added conditionally.
Add gateway meta columns
Filter and group
Save per role
Sample columns
A typical Paystack orders view
wp_wc_orders + wp_wc_orders_meta (or postmeta on legacy stores)
| Order | Status | Reference | Channel | Total |
|---|---|---|---|---|
| #9214 | Complete | T_ref_2401_abc123 | card | ₦24,500 |
| #9213 | Complete | T_ref_2401_abc124 | bank | ₦18,000 |
| #9212 | On hold | T_ref_2401_abc125 | ussd | ₦9,500 |
| #9211 | Refunded | T_ref_2401_abc126 | card | ₦12,000 |
Comparison
Default WooCommerce admin vs SleekView
Default WooCommerce admin
- Order list shows total and status but not the Paystack reference or channel
- Reconciliation against Paystack requires opening each order to read the meta
- No cross-order view of Paystack-paid orders grouped by channel
- Refund-state audits walk through orders one at a time
- Cannot save a view scoped to Paystack as the payment method
SleekView
- Read WooCommerce orders joined with Paystack meta keys
- Show transaction reference and payment channel per row
- Filter and group by channel to see card, bank, USSD, and mobile money mix
- Inline-edit order status through WooCommerce's CRUD layer
- Save reconciliation views per finance owner
Features
What SleekView gives you for Paystack for WooCommerce
Reference and channel as columns
Paystack stores both on the order's meta. SleekView surfaces them so reconciliation against the Paystack dashboard is a side-by-side comparison and the channel mix is one sort away.
Group by Paystack channel
Group orders by card, bank, ussd, mobile_money, or qr to see channel mix at a glance. Stack with date range to track adoption of new channels week over week.
Inline status edits through WooCommerce CRUD
Status changes route through WooCommerce's CRUD layer, so woocommerce_order_status_changed and gateway-side hooks fire as expected. Bulk operations iterate per row through the same path.
Audience
Who uses SleekView for Paystack
Finance reconciliation
Paystack-paid orders for the day with reference and channel visible. Match against the Paystack dashboard's settlement report without opening each order in WordPress.
Payments analytics
Channel mix across the date range: share of card versus bank versus USSD versus mobile money. Useful for measuring adoption when Paystack rolls out a new channel.
Support
Customer asks for a transaction reference during a call. One view, search by order number, reference and channel visible without opening the order screen.
The bigger picture
Why gateway columns matter for African-market WooCommerce
Paystack-powered WooCommerce stores in Nigeria, Ghana, South Africa, and Kenya end up doing the reconciliation work that gateway-paid stores everywhere do, with one extra dimension: channel mix. Card, bank, USSD, mobile money, and QR each behave differently in settlement timing and in customer experience, and the share of each channel shifts as the local payments market evolves. WooCommerce knows the order, the customer, the total, and the WooCommerce-side payment status.
Paystack knows the transaction reference, the channel, the settlement timestamp, and the refund state. The plugin stores Paystack's view of the world against each WooCommerce order, but the default order list keeps those fields invisible. So reconciliation becomes "open every Paystack-paid order from yesterday, copy the reference, paste into the Paystack dashboard, confirm match" and channel mix becomes a quarterly export.
SleekView's job is to expose the meta as columns and let the team filter to the day's Paystack-paid orders, group by channel, and read the mix in one screen. The Paystack dashboard stays the source of truth for settlement and chargebacks. The WooCommerce side becomes legible enough that the side-by-side match is the only step finance has to perform manually.
Questions
Common questions about SleekView for Paystack for WooCommerce
No. It reads what the Paystack plugin already stored against each WooCommerce order: the transaction reference, the channel, and the gateway response. Live calls to Paystack for settlement or refund status would need an additional integration that the plugin itself does not provide. Most reconciliation work is the side-by-side match between what the order shows and what the Paystack dashboard shows, which is exactly what the table view enables.
 
Yes. On HPOS the gateway meta lives in wc_orders_meta; on legacy stores it lives in postmeta. SleekView detects the schema and reads from whichever the store uses. Joins to addresses, customer lookup, and operational data work identically.
Yes. Status changes route through WooCommerce's CRUD layer so any gateway-side hooks the Paystack plugin or your custom code listens to fire as expected. Bulk status changes iterate per row through CRUD so the side effects are identical to manual edits.
 WooCommerce-side refunds are visible (the order status, the refund total, the refund line items). Whether the gateway-side refund completed at Paystack is not stored in WooCommerce by default, so that confirmation still comes from the Paystack dashboard. A reconciliation view that flags WooCommerce-side refunded orders against Paystack-side refunded transactions becomes the actionable workflow.
 Yes. The Paystack plugin stores the channel on the order's meta when present, so a column-grouped view shows what share of orders came through card, bank, USSD, mobile money, or QR. Useful for tracking channel adoption, especially as Paystack ships new channels in supported regions.
 Failed Paystack attempts are typically not promoted to WooCommerce orders unless the plugin records a pending order first. Where the plugin does record them, the failure response is visible on the order's note history and can be exposed as a column. For full failed-attempt logging, server-side log files are the source of record.
 
Yes. The order's payment_method field stores the Paystack slug. A saved view filtered to that value scopes any join, sort, or bulk action to Paystack-paid orders only, useful when finance owns reconciliation across multiple gateways and wants one tab per gateway.
Order queries hit indexed columns on wc_orders and join meta through indexed lookups. Pagination is keyset where the schema allows. Aggregate columns (channel mix per customer, lifetime Paystack spend) are heavier and stay opt-in per view to keep the day-to-day reconciliation queue fast.
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.
Lifetime ♾️
Most popular
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
€749
Continue to checkout