SleekView for WooCommerce PDF Invoice Pro: invoice generation as tables
PDF Invoice Pro stores invoice numbers, PDF generation state, and email-sent flags on each shop_order via postmeta. SleekView pivots them into proper columns so accounting can confirm coverage at a glance.
♾️ Lifetime License available
Confirm every invoice was sent
WooCommerce PDF Invoice Pro (and the broader family of WooCommerce PDF Invoices & Packing Slips plugins) writes invoice metadata to postmeta on each shop_order: _wcpdf_invoice_number, _wcpdf_invoice_date, and a sent flag often stored alongside the order's existing email-sent meta. The actual PDF is generated on demand, not stored.
The default Orders screen shows nothing of this. Accounting and AR teams have no way to confirm at the list level whether a particular order has an invoice number assigned, whether the PDF was generated, or whether the customer was emailed. Auditing a month's invoice coverage means clicking into every order or running raw SQL on postmeta.
SleekView reads the meta directly and exposes invoice number, invoice date, and email-sent state as proper columns. A saved view scoped to orders missing an invoice number flags coverage gaps. Bulk-trigger regeneration through the plugin's own action hook (where supported) and the original PDF formatter still runs.
Workflow
Build the invoice audit workspace
Source the orders
shop_order (or wc_orders on HPOS). All orders are candidates for an invoice, so no upfront filter.
Pivot the invoice meta
_wcpdf_invoice_number, _wcpdf_invoice_date, and any email-sent flags. A virtual column flags rows where the invoice number is empty.
Save the audit views
Bulk-regenerate
Sample columns
Invoice generation status
postmeta.
wp_posts (shop_order) + wp_postmeta (_wcpdf_invoice_number, _wcpdf_invoice_date)
| Order # | Invoice # | Customer | Total | Generated | Emailed | Date |
|---|---|---|---|---|---|---|
| #10428 | INV-0418 | alex@studio.co | €184.00 | Yes | Sent | May 16 |
| #10427 | INV-0417 | ria@design.io | €72.50 | Yes | Pending | May 16 |
| #10426 | — | tom@hello.dev | €312.00 | Missing | No | May 15 |
| #10425 | INV-0415 | mia@brew.coop | €48.00 | Yes | Sent | May 14 |
Comparison
Default PDF Invoice Pro admin vs SleekView
Default PDF Invoice Pro admin
-
Invoice number from
_wcpdf_invoice_numberis not a list column - PDF generation and email-sent state require opening each order
- No saved filter for "orders missing an invoice number"
- Bulk-regenerate is hidden behind row actions one at a time
- No grouping by month to audit invoice coverage
SleekView
- Pivot invoice number, generation state, and email-sent flag into columns
- Filter to orders missing an invoice number for coverage audits
- Bulk-trigger regeneration through the plugin's action hook
- Group by invoice-date month for accounting close
- Save per-role views with audit trail on regenerations
Features
What SleekView gives you for WooCommerce PDF Invoice Pro
Coverage audit
Filter to shop_order rows where _wcpdf_invoice_number is empty. That's the coverage gap. Bulk-trigger regeneration through the plugin's wpo_wcpdf_init_documents action.
Email-sent column
Cross-reference invoice generation with the order's email-sent meta (_billing_email_sent or plugin-specific flag) to spot invoices generated but never emailed.
Monthly accounting view
Group orders by month of _wcpdf_invoice_date and sum totals. Accounting close becomes one screen with paid vs unpaid splits if you also expose the order status.
Audience
Who uses SleekView for WooCommerce PDF Invoice Pro
Accounting
Monthly invoice audit: every order in the month, every invoice number, every total. Reconcile against the general ledger in one screen.
Customer support
Per-customer invoice history with generation and email state. Confirm a customer's invoice was sent without opening the order or the email log.
Admins
Coverage audit for orders missing an invoice. Bulk-regenerate through the plugin's own document init hook, with audit-log columns visible.
The bigger picture
Why invoice coverage needs a flat view
Invoice coverage is one of the silent failure modes of a busy WooCommerce store. An order ships, the customer pays, but the invoice never generates because the plugin failed to trigger on that specific status transition, or the customer email never went out because the SMTP relay hiccuped. Two months later, accounting hits the close and notices fifty orders missing invoice numbers.
The data has always been there in postmeta on each shop_order (invoice number, generation date, email-sent flag), but the default Orders screen shows none of it. SleekView turns the postmeta into proper columns, so coverage gaps surface in seconds instead of months. A saved view scoped to orders missing _wcpdf_invoice_number flags the gap continuously.
A monthly close view groups by invoice date and sums totals for the accounting reconciliation. A support team can confirm an invoice was emailed in one row instead of clicking into the order and the email log. The plugin already captures the data; SleekView just makes the audit operational.
Questions
Common questions about SleekView for WooCommerce PDF Invoice Pro
Yes. Invoice meta moves to wc_orders_meta on HPOS, with the same key names. SleekView reads whichever storage your store uses.
Yes. Multi-select rows and trigger the plugin's regeneration action (commonly wpo_wcpdf_init_documents). Each row runs through the plugin's own document pipeline so templates, hooks, and email triggers behave normally.
PDF Invoice Pro and its open-source siblings also handle packing slips, stored under separate _wcpdf_packing-slip_* meta keys. Add them as columns the same way for fulfilment audits.
PDFs are typically generated on demand and not stored as files. SleekView shows generation state (last-generated timestamp from postmeta) and links to the plugin's PDF endpoint per row, which renders the document fresh.
 
If your install logs regeneration to postmeta or to a custom audit table, SleekView surfaces it as a column. Otherwise enable lightweight audit logging through a custom wpo_wcpdf_init_documents hook listener.
Yes. SleekView never renders PDFs itself. It calls the plugin's existing generation pipeline, so your custom template, custom number format, and any third-party customisations all still apply.
 
The missing-invoice-number filter compiles to an indexed meta_query on _wcpdf_invoice_number. Even a half-million-order store completes the audit in seconds.
Yes. The monthly-grouped view exports to CSV with invoice number, total, and paid status. Accounting teams can import directly into their general ledger or reconciliation tool.
 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
- Spocket Dropshipping
- Presta Shop Bridge
- Woocommerce Conditional Shipping And Payments
- Woocommerce Blocks
- Woocommerce Tip Jar
- Woocommerce Invoice System
- Woocommerce Pricing Deals
- Woocommerce Print Invoices
- Woocommerce Amazon Pay
- Wcfm Delivery
- Woocommerce Etsy Integration
- Woocommerce Shipping Class Rates
- Mollie Payments
- Yith Woocommerce Deposits And Down Payments
- Wcfm Marketplace