SleekView for WooCommerce Octobat: invoices & tax records as tables
Read directly from wc_orders, wc_orders_meta, and Octobat's stored invoice references. Sort, filter, and inline-edit invoice status without opening each order, and surface VAT IDs as first-class columns.
♾️ Lifetime License available
Stop hunting Octobat invoice numbers in postmeta
WooCommerce Octobat connects WooCommerce orders to Octobat invoices and credit notes, but the link lives in wc_orders_meta (or postmeta on legacy stores) under keys like _octobat_invoice_id and _octobat_invoice_number. The default Orders list shows order columns; the invoice reference, customer VAT number, and credit-note status stay invisible until you open each order.
SleekView reads wc_orders together with the relevant wc_orders_meta keys so invoice number, Octobat status, VAT ID, and place-of-supply country become real sortable columns. Finance can pull every Invoiced order from last quarter, filter by EU country code, and reconcile against Octobat without leaving WordPress. Failed invoice generations show up at the top of a saved view instead of buried in a status filter that doesn't exist.
Inline edits to order status route through WooCommerce's CRUD layer, so the hooks Octobat listens to fire normally and invoice generation triggers as expected. Direct edits to invoice meta are guarded by conflict detection so a stale row never silently overwrites a fresh Octobat callback.
Workflow
How SleekView reads your Octobat setup
Pick the source
wc_orders for HPOS or shop_order posts on legacy. SleekView detects which path is active and exposes the matching column set plus joinable Octobat meta.
Compose Octobat columns
_octobat_invoice_number, _octobat_invoice_status, _octobat_vat_id, and country/currency from the column picker. Only meta keys present in your data show up.
Save and scope per role
Edit inline or in bulk
Sample columns
A typical WooCommerce Octobat invoice view
wc_orders with wc_orders_meta keys like _octobat_invoice_number and _octobat_vat_id.
wp_wc_orders + wp_wc_orders_meta (Octobat keys)
| Order # | Invoice # | Status | Country | VAT ID | Total | Date |
|---|---|---|---|---|---|---|
| #10428 | INV-2026-0418 | Invoiced | DE | DE123456789 | €184.00 | Apr 24 |
| #10427 | INV-2026-0417 | Pending | FR | FR987654321 | €72.50 | Apr 24 |
| #10426 | INV-2026-0416 | Invoiced | ES | ESB12345678 | €312.00 | Apr 23 |
| #10425 | CN-2026-0042 | Credited | IT | IT01234567890 | €48.00 | Apr 23 |
Comparison
Default WooCommerce Octobat admin vs SleekView
Default WooCommerce Octobat admin
-
Invoice number sits in
wc_orders_metaand never appears in the Orders list - No way to filter orders by Octobat invoice status (Invoiced, Pending, Credited)
- Customer VAT ID is stored as meta but isn't a column in the default screen
- Place-of-supply country requires opening each order to verify EU MOSS handling
- Credit notes are scattered across orders rather than viewable as a dedicated audit list
SleekView
-
Surface
_octobat_invoice_numberand_octobat_invoice_statusas real columns - Filter by EU country code and VAT ID for quarterly MOSS reconciliation
- Saved view for Failed invoice generation rows so they never get missed
- Inline-edit order status to trigger Octobat regeneration without opening the order
- Dedicated credit-notes view joined back to the parent order
Features
What SleekView gives you for WooCommerce Octobat
Invoice meta as first-class columns
Pull _octobat_invoice_number, _octobat_invoice_status, and _octobat_vat_id from wc_orders_meta straight into the table. Finance sees invoice context next to order context without per-row clicks.
MOSS-friendly filters
Combine country, VAT ID presence, currency, and date range for EU MOSS quarterly returns. Save the filter as Q2 EU B2B invoices and rerun it next quarter without rebuilding.
Inline edits trigger Octobat
Flip status through WooCommerce CRUD so woocommerce_order_status_changed fires and Octobat regenerates the invoice. No silent direct writes, no missed callbacks.
Audience
Who uses SleekView for WooCommerce Octobat
Finance ops
Quarterly view of completed orders joined with invoice number and VAT ID, filtered by country code. Export to CSV for the bookkeeper without leaving WP admin.
Customer support
Search by customer email, see all orders with their Octobat invoice numbers inline, and re-trigger invoice generation if a customer reports a missing PDF.
Compliance and audit
Saved view of every Credited row this fiscal year with parent-order link. The audit trail that an accountant actually wants, in WordPress.
The bigger picture
Why invoice ops outgrow the WooCommerce Orders screen
WooCommerce Octobat solves a real problem: keeping invoice numbering, VAT compliance, and credit-note handling in a dedicated invoicing system rather than inside WooCommerce's order screens. That separation works until the moment finance needs to audit, support needs to investigate, or compliance needs to file a quarterly MOSS return. At that point the data is in the right places (Octobat for invoices, wc_orders for orders, wc_orders_meta for the links) but the WordPress admin still shows one Orders list with a fixed column set.
Invoice numbers, VAT IDs, place-of-supply countries, and credit-note references are all stored, none of them are visible at the row level. SleekView's job is to compose the joined view: orders joined with their Octobat meta, filtered the way each team thinks about the data, saved as named views per role. Finance gets a quarterly audit table, support gets a per-customer invoice history, compliance gets a credit-note audit list.
Same database, same hooks, dramatically less hunting through individual order screens for a number that's already in the database.
Questions
Common questions about SleekView for WooCommerce Octobat
Yes. SleekView reads wc_orders and wc_orders_meta when HPOS is active (default since WooCommerce 8.2) and falls back to shop_order posts plus postmeta on legacy stores. The Octobat meta keys are the same on both schemas, so the same SleekView config works across both.
We recommend not editing the invoice number directly, since Octobat is the authoritative source. SleekView lets you edit order status, custom internal notes, and operational meta, then re-trigger invoice generation through Octobat's hooks. Direct writes to _octobat_invoice_number are possible but gated behind a per-view setting and conflict detection.
Yes. Octobat stores the credit-note reference in wc_orders_meta under a separate key. SleekView shows it as a column on the parent order row and also as its own view scoped to credit-note rows only, joined back to the parent through the order id.
Yes, if Octobat or a sibling plugin stores VIES validation in meta. SleekView lists meta keys actually present in your installation, so the keys it can surface depend on what Octobat (and your checkout plugins) write. Typical keys include _octobat_vat_id and _octobat_vat_valid.
Queries hit indexed columns on wc_orders directly. Meta-based filters use wc_orders_meta joins, which are indexed by order_id and meta_key on HPOS. Heavy aggregates like lifetime-invoice-count are opt-in per view so triage views stay fast.
Status edits routed through WooCommerce CRUD fire woocommerce_order_status_changed, which Octobat hooks into. Direct meta writes do not, by design, since they're internal corrections. Keep status-driven workflows on CRUD and reserve direct writes for back-office cleanups.
SleekView can render a column with the Octobat invoice URL or PDF link as a clickable cell, sourced from wc_orders_meta if Octobat stores it. We don't proxy the PDF; the link opens in Octobat's hosted UI or downloads the file directly from there.
VAT IDs of B2B customers are not personal data in most EU jurisdictions, but country-specific rules vary. Gate the VAT-ID column to roles that need it (finance, compliance) using WordPress capabilities, and exclude the column from views that other staff can access.
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
- Woocommerce Product Vendors Pro
- Woocommerce Coinbase Commerce
- Veeqo Wp
- Woocommerce Free Shipping Bar
- Woocommerce Name Your Price
- Variation Swatches
- Stripe For Woocommerce
- Wp Lister Lite
- Yith Woocommerce Deposits And Down Payments
- Paykickstart Bridge
- Woocommerce Tax Toggle
- Shipstation Woocommerce
- Woocommerce Stamps
- Woocommerce Amazon Pay Pro
- Woocommerce Dokan Pro