✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView table view for WooCommerce PDF Invoice Pro

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

1

Source the orders

Point SleekView at shop_order (or wc_orders on HPOS). All orders are candidates for an invoice, so no upfront filter.
2

Pivot the invoice meta

Add _wcpdf_invoice_number, _wcpdf_invoice_date, and any email-sent flags. A virtual column flags rows where the invoice number is empty.
3

Save the audit views

Missing-invoice view, monthly-close view, generated-but-not-emailed view, per-customer invoice history view. Bookmark them in the admin sidebar per role.
4

Bulk-regenerate

Select coverage-gap rows and trigger the plugin's regeneration action. Each row runs through the original document pipeline so templates and hooks behave normally.

Sample columns

Invoice generation status

One row per order with invoice number, PDF state, and email-sent flag from postmeta.
Source: 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_number is 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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