SleekView for WooCommerce EU VAT Number
SleekView reads WooCommerce orders joined with the _vat_number, _vat_number_is_valid and _vat_number_is_validated meta WooCommerce EU VAT Number writes, then renders B2B orders as a queryable grid inside WP Admin instead of a mixed B2B and B2C order list.
♾️ Lifetime License available
Move EU B2B orders out of the generic order list into a real audit table
WooCommerce EU VAT Number adds the EU reverse-charge flow on top of WooCommerce: a VAT number field at checkout, a VIES validation call against the customer's VAT ID and order meta marking the validation result. Each B2B order ends up with _vat_number, _vat_number_is_valid and _vat_number_is_validated alongside the standard billing_country and order_total WooCommerce already records.
The default WooCommerce orders screen renders B2B and B2C orders together, hides the VAT meta off-row and offers no way to triage validation status across orders. Finance and operations teams end up clicking into each order to see whether the VAT number actually validated, or exporting CSVs and pivoting in spreadsheets quarter after quarter.
SleekView reads wp_wc_orders joined with wp_wc_orders_meta and renders the B2B slice as a sortable audit table. VAT number, validation status, billing_country and order_total sit on every row. Filter to last quarter, sort by validation_status to triage unvalidated exemptions and group by billing_country to see per-member-state cohorts. The chart dashboard aggregates the same dataset, the table view owns the row-level audit.
Workflow
How SleekView surfaces WooCommerce EU VAT Number data
Point at the order and VAT meta
Compose the columns
Filter and sort like a database
Save and gate the view
Sample columns
A typical WooCommerce EU VAT Number audit view
wp_wc_orders + wp_wc_orders_meta
| Order | VAT number | Billing country | Total | Validation | Paid |
|---|---|---|---|---|---|
| #48217 | DE327394821 | DE | 1,240.00 EUR | Valid | 2026-04-12 |
| #48205 | FR74832000291 | FR | 624.50 EUR | Valid | 2026-04-11 |
| #48191 | NL821739422B01 | NL | 3,180.00 EUR | Unvalidated | 2026-04-10 |
| #48184 | IT04211930728 | IT | 412.00 EUR | VIES failed | 2026-04-09 |
| #48172 | ES B83248171 | ES | — | Pending | 2026-04-09 |
Comparison
Default WooCommerce orders screen vs SleekView
Default WooCommerce orders list
- B2B and B2C orders render in the same list with no VAT column
- VAT number and validation status hide off-row in order meta
- Filtering to unvalidated exempt orders requires a custom SQL query
- Per-country B2B cohorts can only be assembled via CSV export
- No saved view for finance vs operations vs external accountant
SleekView
- Every B2B order row with VAT number and validation status inline
- billing_country and order_total as real columns for OSS triage
- Filter to unvalidated exemptions, a specific country or last quarter
- Saved views per role: finance OSS prep, ops audit, accountant export
- Same dataset the chart dashboard aggregates, so table and chart stay in sync
Features
What SleekView gives you for WooCommerce EU VAT Number
B2B orders as a real table
Render wp_wc_orders joined with the VAT meta as rows with VAT number, validation status, billing_country and order_total instead of clicking into each order to read its meta.
Validation status inline
_vat_number_is_valid sits in its own column so finance triages unvalidated exemptions before quarter-end without opening orders one by one.
Composable VAT filters
Stack filters on _vat_number, validation, billing_country and date_paid to assemble the OSS-ready cohort, the audit-risk cohort or the per-country slice in one query.
Audience
Who uses SleekView for WooCommerce EU VAT Number
Finance and accounting
Filter B2B orders to a quarter, sort by billing_country and export the rows OSS or MOSS filings actually need, instead of pivoting CSVs every three months.
Operations and compliance
Surface unvalidated exemptions and VIES-failed orders as their own saved view, then resolve them before refund disputes or audit letters arrive.
B2B sales teams
Group orders by billing_country and date_paid to spot which markets are growing, which are slipping and which accounts are placing repeat exempt orders.
The bigger picture
Why EU B2B orders deserve a real audit table
WooCommerce EU VAT Number sits in the most regulated path of an EU store: reverse-charge orders that are tax-exempt only when the VAT ID validates against VIES. The default order list buries that detail in per-row meta and finance ends up rebuilding the same OSS workbook every quarter. SleekView reads the same wp_wc_orders and the _vat_number meta the plugin already writes and renders the B2B slice as a queryable audit table with VAT number, validation status, billing_country and order_total on every row.
Filters stack into one query, saved views split the slice for finance, operations and external accountants and the dataset stays consistent with the chart dashboard. The plugin keeps owning the checkout, the VIES call and the exemption logic, while finance gets the per-row audit surface the data always deserved.
Questions
Common questions about SleekView for WooCommerce EU VAT Number
wp_wc_orders joined with wp_wc_orders_meta for _vat_number, _vat_number_is_valid, _vat_number_is_validated, billing_country, order_total and date_paid. On legacy storage the same meta lives on the order post and is read from postmeta.
Yes. SleekView reads either the new wp_wc_orders tables or the legacy post tables, so the same audit view works whether HPOS is enabled or not.
Yes. Apply a filter where _vat_number is non-empty (or where _vat_number_is_valid is true for the strict view), and every row in the table narrows to the B2B cohort.
Yes. _vat_number_is_valid becomes its own column and a one-click filter, so the unvalidated cohort exports as a CSV for follow-up or resubmission.
Yes, when explicitly enabled. Edits go through the WooCommerce orders API rather than direct SQL, so plugin hooks observe the writes exactly as they would from the orders screen.
Yes. The chart view and the table view share the dataset, so a quarterly or per-country filter narrows both surfaces. Finance pivots between row audit and chart rollup without rebuilding filters.
No by default. The audit table is read-only and the optional bulk-edit goes through the WooCommerce API. No checkout flow, no VIES call and no exemption logic is touched.
Yes. SleekView views can be private to a user or shared with specific roles. A common setup gives the accountant a read-only B2B audit view and a scoped CSV export.
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 checkout