SleekView Charts for Sequential Order Numbers: prefix dashboards in WP
Sequential Order Numbers writes the formatted order number with prefix and suffix to _order_number on wc_orders_meta for every order. SleekView Charts reads that key alongside wc_orders fields and builds a dashboard of orders per prefix, sequential gaps, daily issuance, and prefix-revenue mix.
♾️ Lifetime License available
Read sequential order numbers as charts, not a long list
Sequential Order Numbers for WooCommerce stores every formatted order number on the order itself. Each new order gets _order_number on wc_orders_meta with the configured prefix, the sequential integer, and the optional suffix (for example, ORD-2024-001234). The base WooCommerce id on wc_orders stays untouched. The plugin admin shows the formatted number in the order list, but never aggregates by prefix or year segment.
SleekView Charts reads _order_number directly and lets the team chart by the prefix and year segment of each formatted number. A Bar ranks orders per prefix (ORD vs SUB vs WHL) for businesses that route different order types through different number ranges. A Number card sums revenue per prefix to see which channel earns the most. A Line chart plots the highest sequential number per day to confirm no gaps. An Area chart plots daily order issuance from date_created_gmt.
This is a reading layer, not a replacement for the numbering engine. The plugin still owns the actual sequence allocation and the formatted-number generation. SleekView Charts adds the dashboard the plugin admin does not lay out: prefix mix against revenue per prefix against daily issuance on one saved screen, scoped per role, embeddable for accounting that needs ordered, prefixed numbers without WooCommerce admin access.
Workflow
From _order_number meta to a numbering dashboard in four steps
Point SleekView at the order-number meta
Switch the view to Charts
Add prefix and sequence cards
Save and scope the dashboard
Sample dashboard
Charts you can build from Sequential Order Numbers data
Orders issued this month
Count(_order_number)
Orders per prefix
Count
group by _order_number_prefix
Revenue per prefix
Sum(total_amount)
group by _order_number_prefix
Daily order issuance
Count
group by date_created_gmt
Comparison
Default Sequential Order Numbers admin vs SleekView Charts
Default order numbers admin
- Formatted number is shown per row in the order list, never aggregated by prefix
- Revenue per prefix or per numbering range is invisible without a CSV export
- Daily order issuance pattern is buried in the orders list, not a single area chart
- Sequential gaps in numbering are not flagged by any dashboard view
- No saved per-role dashboards for accounting that need prefixed totals only
SleekView Charts
-
Chart cards built directly on the
_order_numbermeta the plugin writes on every order - Mix Number, Pie, Bar, Line, and Area cards on a single order-numbering dashboard
- Split orders by prefix, year segment, or sequential range at chart time
- Saved chart views scoped per role for accounting, ops, and management
- Embed the dashboard on a frontend page so accountants see prefixed totals without WC admin
Features
What SleekView Charts gives you for Sequential Order Numbers for WooCommerce
Real charts on _order_number
Number, Pie, Bar, Line, Area, Radar, and Radial cards built directly from the _order_number meta key the plugin writes to wc_orders_meta on every order created.
Complements the numbering plugin
The plugin still owns the actual sequence allocation, the prefix configuration, and the formatted-number generation. SleekView Charts adds the dashboard summary the admin screen does not lay out.
Prefix-level reporting
For stores routing retail, wholesale, or subscription orders through different number ranges, SleekView groups _order_number by its prefix segment so each channel reads as its own line of business.
Audience
Who builds Sequential Order Numbers dashboards with SleekView
Accountants
Track the issued-orders KPI and the prefix-revenue bar so the next filing reads with the same prefixed numbers the legal team expects on invoices.
Multi-channel store owners
Watch the orders-per-prefix donut to see how retail, wholesale, and subscription channels distribute orders across the custom number ranges.
Owners and managers
Use the daily issuance area chart to spot weekday patterns and confirm sequential numbering is firing on every order without gaps.
The bigger picture
Order numbering is data, not just a display field
Sequential Order Numbers for WooCommerce handles a problem every accountant and many tax authorities care about: orders with gapless, prefixed, formatted numbers that match the figures on invoices. The plugin already writes the formatted number to _order_number on wc_orders_meta for every order. What the plugin does not do is treat that number as data to chart by.
Multi-channel stores route retail through ORD, wholesale through WHL, and subscriptions through SUB but the only way to see how many orders sit in each range is to scroll the orders list and read the prefix. Accountants who want issuance volume per month use a CSV export. SleekView Charts reads _order_number directly and groups by its prefix and date segments.
Accounting sees the prefix-revenue bar and the issued-orders KPI. Owners see the daily issuance area chart. Multi-channel stores see the orders-per-prefix donut.
The plugin keeps owning the actual sequence allocation; SleekView adds the in-WordPress reading layer that turns the formatted number into a real dashboard.
Questions
Common questions about SleekView Charts for Sequential Order Numbers for WooCommerce
No. The numbering plugin still owns the actual sequence allocation, prefix configuration, and formatted-number generation. SleekView Charts is a reading layer on the _order_number meta the plugin writes to wc_orders_meta, so you can chart prefix and date patterns on one saved screen.
 Yes. SleekView reads wc_orders and wc_orders_meta directly when HPOS is enabled, including the _order_number key. Legacy stores fall back to shop_order postmeta with the same key name.
 Yes. SleekView splits the _order_number string into prefix, sequence, and optional year segments at chart time. A Donut on the prefix segment shows how many orders sit in each custom range (ORD, SUB, WHL, and so on).
 Yes. Group total_amount by the prefix portion of _order_number to get a revenue per channel bar, useful for stores routing retail, wholesale, and subscription orders through different ranges.
 Yes. A Line chart of the maximum integer portion of _order_number per day shows whether each day's highest sequence is one more than yesterday's; gaps surface as flat segments and the team can investigate the missing IDs.
 Yes. _order_number is a text field, so any prefix and suffix the plugin produces are read as is. Group-by parsing handles dashes, underscores, and year segments without issue.
 No. Chart queries run on demand when a user loads the dashboard, hit indexed columns on wc_orders, and use the same MySQL connection as WordPress. Order numbering and creation are untouched.
 Yes. Save the chart view, scope it to an accountant role, or embed the dashboard on a frontend page gated by that role. The team reads prefixed totals without ever touching WooCommerce admin.
 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 Search
- Flexible Shipping
- Woocommerce Advanced Product Labels
- Yith Woocommerce Product Countdown
- Woocommerce Clearpay
- Yith Woocommerce Quick View
- Woocommerce Deposits
- Woo Stripe Payment
- Woocommerce Shipping Pickup Location
- Wp Ecommerce
- Paypal Payments
- Yith Woocommerce Name Your Price
- Solid Affiliate
- Woocommerce Tax Toggle
- Yith Woocommerce Bookings