SleekView for CoinGate for WooCommerce: crypto orders as tables
Read directly from wc_orders filtered by payment_method=coingate and surface invoice metadata from wc_orders_meta. Sort, filter, and inline-edit Bitcoin and altcoin payments without opening each order.
♾️ Lifetime License available
Crypto orders deserve their own column set
CoinGate plugs into WooCommerce as a payment gateway with payment_method=coingate, then stores the invoice id, receive currency, and final amount as keys on wc_orders_meta (HPOS) or postmeta on legacy stores. The default Orders screen treats a CoinGate payment the same as a Stripe one: order number, status, customer, total. The receive currency, the BTC or ETH amount that actually settled, the CoinGate invoice id you need for support tickets, all stay hidden until you click into each order.
SleekView reads wc_orders with a saved filter on payment_method and exposes the CoinGate-specific wc_orders_meta keys (_coingate_invoice_id, _coingate_order_id, _coingate_receive_currency, _coingate_pay_amount) as first-class columns. Sort by pay amount, filter by receive currency, group pending invoices by created date.
Inline edits to order status route through WooCommerce's CRUD layer, so the woocommerce_order_status_changed hook still fires and downstream actions (license issuance, digital-product fulfilment, accounting webhooks) trigger normally. Mark a stuck pending order as failed in one click without losing the audit trail.
Workflow
How SleekView reads your CoinGate WooCommerce schema
Pick the source table
wc_orders on HPOS or shop_order on legacy. SleekView detects which path is active and exposes the matching columns plus joinable address and customer-lookup data.
Compose your CoinGate column set
wc_orders_meta keys: _coingate_invoice_id, _coingate_receive_currency, _coingate_pay_amount. The agent UI lists meta keys actually present in your installation.
Save and scope the view
Edit inline and bulk-update
Sample columns
A typical CoinGate orders view
wc_orders filtered by payment_method=coingate and joins wc_orders_meta for invoice and receive-currency columns.
wp_wc_orders + wp_wc_orders_meta (HPOS) or wp_posts (shop_order) + wp_postmeta
| Order # | Status | Customer | Total | Receive currency | Invoice ID | Date |
|---|---|---|---|---|---|---|
| #10428 | Pending | alex@studio.co | $184.00 | BTC | cg_8821 | Apr 24 |
| #10427 | Paid | ria@design.io | $72.50 | ETH | cg_8820 | Apr 24 |
| #10426 | Paid | tom@hello.dev | $312.00 | USDT | cg_8819 | Apr 23 |
| #10425 | Invalid | mia@brew.coop | $48.00 | BTC | cg_8818 | Apr 23 |
Comparison
Default CoinGate for WooCommerce admin vs SleekView
Default CoinGate for WooCommerce admin
- Standard Orders screen treats CoinGate orders the same as card payments, with no crypto-specific columns
-
Invoice id, receive currency, and pay amount live in
wc_orders_metaand stay hidden in the list -
Filtering by
payment_method=coingaterequires URL parameter tricks or a separate report - Stuck pending invoices need per-order inspection to identify
- Cross-currency reporting (BTC vs ETH vs USDT volumes) is not in the default admin
SleekView
-
Read
wc_orderswith a savedpayment_method=coingatefilter -
Expose
_coingate_invoice_id,_coingate_receive_currency, and_coingate_pay_amountas columns - Inline-edit status across stuck pending invoices in one pass
- Save filtered views ("BTC payments last 7 days", "Pending over 30 minutes")
- Switch between table and kanban grouped by receive currency
Features
What SleekView gives you for CoinGate for WooCommerce
Crypto-specific filters
Combine payment_method=coingate, receive currency, pay amount, and order status. Save the filter as "Stuck pending" or "USDT settled today" and your team reuses it every shift.
Inline status edits with hooks
Flip a stuck pending order to failed or completed right in the row. woocommerce_order_status_changed still fires, so digital-product fulfilment and accounting webhooks trigger as if a human clicked through each one.
Kanban by receive currency
Switch the same data to kanban grouped by BTC, ETH, USDT, or LTC. Drag cards between status columns and the CRUD layer fires the same status-change hooks as the table.
Audience
Who uses SleekView for CoinGate for WooCommerce
Finance teams
Crypto orders sorted by date with receive currency and pay amount columns. Filter completed CoinGate orders by month for accounting reconciliation against the CoinGate dashboard.
Customer support
Search by email or _coingate_invoice_id when a customer disputes a payment. Inline-edit order notes during the call without opening five tabs.
Store owners
Per-currency views showing volume in BTC, ETH, USDT, and stablecoins. Spot which currencies drive revenue and which have the highest pending-to-paid drop-off.
The bigger picture
Why crypto orders need a different admin surface
CoinGate is a clean WooCommerce gateway plugin that handles the hard parts of Bitcoin and altcoin checkout, but the moment your store accepts more than a handful of crypto payments a week, the WooCommerce default Orders screen stops being enough. It does not show receive currency, pay amount, or invoice id as columns. It does not let you filter by payment_method without URL hacks.
It does not group pending invoices by created time so you can spot which ones are stuck waiting for confirmations. Finance teams reconciling against the CoinGate dashboard end up exporting CSVs and joining them by hand. Support staff fielding a "my BTC payment did not go through" ticket open five orders before they find the one with the matching invoice id.
SleekView turns the same data into a workspace that respects how crypto actually flows: filter by currency, surface invoice ids as a column, inline-edit status without losing hook side effects. Same database, same WooCommerce CRUD, dramatically less per-order clicking.
Questions
Common questions about SleekView for CoinGate for WooCommerce
Yes. SleekView reads wc_orders and wc_orders_meta on HPOS (default since WooCommerce 8.2) and transparently switches to shop_order posts plus postmeta on legacy stores. The same CoinGate column set works across both schemas without rewriting the view.
Yes. CoinGate stores the invoice id under _coingate_invoice_id in wc_orders_meta. SleekView lists meta keys actually present in your installation, so you pick from a real list. Add it as a column and customer support can grep for it during disputes.
Inline edits route through WooCommerce's CRUD layer, so woocommerce_order_status_changed, woocommerce_payment_complete, and CoinGate's own status hooks fire as expected. Bulk operations iterate through CRUD so side effects are identical to manual admin edits.
Yes. CoinGate stores the receive currency under _coingate_receive_currency in wc_orders_meta. Expose it as a column, then add a filter on it. Save the filtered view as "USDT payments" or "BTC payments" and your team reuses it daily.
SleekView reads from the WordPress database, so it shows what CoinGate writes to wc_orders and wc_orders_meta. The CoinGate IPN log itself lives on CoinGate's side, not in your WP database. The order metadata SleekView surfaces (invoice id, pay amount, pay currency) is enough for most reconciliation workflows.
Yes. WooCommerce refunds are stored as shop_order_refund posts on legacy and parent-linked rows on HPOS. SleekView can show them inline as a related table per order or as their own view scoped by date range, useful for the rare crypto refund audit.
Queries hit indexed columns on wc_orders directly. Filtering by payment_method, status, and date_created_gmt uses HPOS indexes. Pagination is keyset where possible. Meta-based columns are opt-in per view since joins on wc_orders_meta are heavier.
SleekView is local: it reads and writes the same WordPress database your CoinGate plugin already uses. No customer data leaves your server. Per-role view scoping means support sees customer emails while finance sees only aggregated totals if you configure it that way.
 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
- Stripe For Woocommerce
- Shipperhq Woocommerce
- Gumroad Wp
- Edd Conditional Emails
- Woocommerce Purchase Orders
- Woocommerce Dpd Shipping
- Wc Vendors
- Winwar Aelia Currency Switcher
- Woocommerce Product Csv Import
- Woocommerce Stock Manager
- Woocommerce Measurement Price
- Woocommerce Shipping Canada Post
- Woocommerce One Page Checkout
- Woocommerce Frontend Manager
- Woocommerce Tiktok Pixel