SleekView for Blockonomics for WooCommerce: BTC orders & addresses as tables
Read directly from wc_orders and Blockonomics' own blockonomics_orders custom table. Surface BTC addresses, confirmation counts, and on-chain amounts as columns. Filter, sort, and inline-edit without per-order click-through.
♾️ Lifetime License available
Bitcoin addresses, finally as a column
Blockonomics is one of the few WooCommerce crypto gateways that stores data in its own custom table: blockonomics_orders, with rows mapping order id to the unique Bitcoin address the plugin generated, the expected amount in satoshis, and the confirmation count. The default WooCommerce Orders screen joins none of that. You see order number, status, customer, total in fiat. The receiving address, the on-chain BTC amount, the confirmation status, all require opening the order or hopping to the Blockonomics dashboard.
SleekView reads wc_orders and joins blockonomics_orders by order id so the table shows the BTC address (truncated for legibility), the expected satoshi amount, and the live confirmation count alongside the WooCommerce fields. Sort by confirmations to spot which payments are close to settling. Filter by payment_method=blockonomics and a status of "awaiting confirmations" for a focused fulfilment queue.
Inline status edits route through WooCommerce's CRUD layer so order-status hooks fire normally. Bulk-resolve a batch of orders that have hit six confirmations to completed in one pass, with the same hook side effects as the per-order admin flow.
Workflow
How SleekView reads your Blockonomics WooCommerce schema
Pick the source tables
wc_orders (or shop_order on legacy) as the base and add blockonomics_orders as a join on order_id. SleekView detects the active schema.
Compose your Bitcoin column set
btc_address, expected_btc, received_btc, confirmations, and the Blockonomics-internal status.
Save and scope the view
Edit inline and bulk-update
Sample columns
A typical Blockonomics orders view
blockonomics_orders with wc_orders by order_id to surface BTC addresses and confirmation counts.
wp_blockonomics_orders + wp_wc_orders (HPOS) or wp_posts (shop_order)
| Order # | BTC address | Status | Expected (BTC) | Confirmations | Customer | Date |
|---|---|---|---|---|---|---|
| #30521 | bc1q7…jx9 | Awaiting | 0.00421 | 0 | alex@studio.co | Apr 24 |
| #30520 | bc1qa…km4 | Completed | 0.00118 | 6 | ria@design.io | Apr 24 |
| #30519 | bc1qd…lt8 | Partial | 0.00712 | 2 | tom@hello.dev | Apr 23 |
| #30518 | bc1qe…pq3 | Expired | 0.00094 | 0 | mia@brew.coop | Apr 23 |
Comparison
Default Blockonomics for WooCommerce admin vs SleekView
Default Blockonomics for WooCommerce admin
-
WooCommerce Orders screen does not join
blockonomics_ordersat all -
BTC address, expected satoshi amount, and confirmations live in
blockonomics_ordersand are invisible in the list - Confirmation progress requires opening each order or the Blockonomics dashboard
- Partial payments need per-order inspection to spot
- No bulk-resolve path for orders that have crossed the confirmation threshold
SleekView
-
Join
blockonomics_orderswithwc_ordersbyorder_id - Surface BTC address, expected amount, and confirmation count as columns
- Filter by confirmation count to triage near-settled orders
- Save filtered views ("Partial payments", "Awaiting first confirmation")
- Inline-edit status with WooCommerce CRUD hooks still firing
Features
What SleekView gives you for Blockonomics Bitcoin Payments for WooCommerce
Joined BTC and order view
Build a single table that joins blockonomics_orders with wc_orders. BTC address, expected satoshi amount, confirmation count, and order status in one row.
Confirmation-aware filters
Filter by confirmation count to find orders that are one block away from settling, or save "Partial payments awaiting top-up" as a triage view that updates in real time.
Inline status edits with hooks
Flip a six-confirmation order to completed right in the row. woocommerce_order_status_changed still fires, so digital-product fulfilment and shipping notifications trigger normally.
Audience
Who uses SleekView for Blockonomics for WooCommerce
Fulfilment
Pending orders sorted by confirmation count so the team works on the next-to-settle first. Bulk-flip to completed once orders cross the confirmation threshold.
Support
Search by truncated BTC address or order id when a customer says "my payment is not arriving". See expected amount versus received and confirmation progress inline.
Finance
Completed Blockonomics orders by date for reconciliation against on-chain inflows. Export the filtered set with BTC amounts and addresses included for the bookkeeper.
The bigger picture
Why on-chain orders need their own admin surface
Blockonomics is unusual among WooCommerce gateways in that it generates a unique on-chain Bitcoin address per order rather than routing through a hosted invoice page. That gives merchants real self-custody, but it also gives them a piece of data the default WooCommerce admin has no idea what to do with. The BTC address, the expected satoshi amount, the live confirmation count, all live in blockonomics_orders and never reach the orders list.
Fulfilment teams cannot prioritise near-settled orders without opening each one. Support fielding a "my Bitcoin payment is stuck" ticket cannot search by partial address. Finance reconciling daily on-chain inflows against orders ends up exporting two CSVs and joining them in a spreadsheet.
SleekView reads the same database the Blockonomics plugin already writes to and joins the two tables once, so the operational view your team needs exists inside WP Admin instead of half a dozen tabs.
Questions
Common questions about SleekView for Blockonomics Bitcoin Payments for WooCommerce
Yes. blockonomics_orders is exposed as a joinable source. SleekView reads it directly and joins to wc_orders on order_id so BTC address, expected amount, and confirmation count surface as columns next to standard WooCommerce fields.
Yes. The confirmations column on blockonomics_orders is filterable, so you can build a view showing only orders with 6+ confirmations ready to flip to completed, or orders stuck at 0 confirmations past the timeout window.
Yes. On HPOS (default since WooCommerce 8.2) SleekView joins blockonomics_orders to wc_orders. On legacy stores it joins to shop_order posts. The same column configuration works across both schemas.
Inline edits route through WooCommerce's CRUD layer, so woocommerce_order_status_changed fires. Blockonomics actions hooked into status changes (digital-product delivery, license issuance) trigger as expected. Bulk operations iterate through CRUD.
Yes. Blockonomics marks orders as partial when the received amount is below expected. SleekView surfaces both expected and received columns so partial payments are obvious at a glance. Save a "Partial payments awaiting top-up" view for support triage.
No. SleekView reads only the WordPress database. The Blockonomics API itself is what your plugin uses to populate blockonomics_orders. SleekView reads what is already there, so confirmation counts are as current as the plugin's last poll or webhook.
Queries hit indexed columns. blockonomics_orders.order_id is indexed for the join, and wc_orders.status and date_created_gmt are HPOS indexes. Pagination is keyset where possible. Heavy aggregate columns (lifetime BTC volume per customer) are opt-in per view.
Yes. SleekView supports scoped CSV export of the current filtered view, so finance receives the slice they need with BTC address, expected amount, confirmation count, and standard order fields all in one file.
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 checkoutBrowse more
- Edd Active Campaign
- Woocommerce Tax Toggle
- Mollie Payments
- Woocommerce Direct Bank Transfer Pro
- Woocommerce Australia Post Pro
- Woocommerce Octanepay
- Woocommerce Iyzico
- Woocommerce Mirakl
- Authorize Net
- Edd Mailchimp
- Woocommerce Gift Cards
- Edd Commissions
- Winwar Aelia Currency Switcher
- Woocommerce Google Shopping
- Woocommerce Fast Checkout