SleekView for WooCommerce Purolator: Purolator shipments as tables
SleekView reads the Purolator service code, rate, tracking PIN and ship-date meta the plugin writes on each order and renders order, service, rate, destination and status as a queryable grid inside WP Admin.
♾️ Lifetime License available
Move Purolator shipments out of order screens and into an audit table
WooCommerce Purolator integrates the Purolator E-Ship Web Services API into Woo: rate quoting at checkout across Purolator Ground, Purolator Express, Purolator Express 9AM, Purolator Express 10:30AM and Purolator Express International services, plus label printing against the Canadian Purolator account. The plugin saves _purolator_service, _purolator_rate, _purolator_pin and _purolator_ship_date on each order. The data is there, but the WordPress order list shows none of it as columns.
SleekView reads the Purolator meta and renders one row per Purolator-shipped order with service mapped from code to friendly name, rate in Canadian dollars, Purolator PIN, ship date and status. Filter to Purolator Express 9AM for the priority queue. Filter to Purolator Express International for the cross-border cohort. Sort by _purolator_rate descending to surface the highest-charge shipments for contract review.
The plugin keeps owning the E-Ship API and the rate quoting. Inline edits to _purolator_pin route through WooCommerce CRUD so notification hooks fire. The table view owns the audit surface so the Purolator picture lives in the same WordPress screen as the rest of the order data, not in the Purolator E-Ship Online portal.
Workflow
How SleekView surfaces WooCommerce Purolator data
Point at the Purolator meta
wc_orders joined on _purolator_service, _purolator_rate, _purolator_pin and _purolator_ship_date. Add wc_order_addresses for shipping country.
Compose the columns
Filter and sort like a database
_purolator_rate for cost audits and by ship date for daily dispatch.
Save and gate the view
Sample columns
A typical Purolator audit view
wc_orders with the Purolator meta keys joined to the shipping address, service codes mapped to friendly labels via a derived column.
wc_orders + Purolator meta (_purolator_service, _purolator_rate, _purolator_pin, _purolator_ship_date)
| Order | Service | Rate | PIN | Destination | Status |
|---|---|---|---|---|---|
| #22841 | Purolator Ground | C$ 14.20 | 329812345678 | CA | Shipped |
| #22838 | Purolator Express 9AM | C$ 38.90 | 329812345679 | CA | Delivered |
| #22834 | Purolator Express | C$ 22.40 | 329812345680 | CA | In transit |
| #22829 | Purolator Express International | C$ 54.10 | US | Booking failed |
Comparison
Default WooCommerce Purolator admin vs SleekView
Default WooCommerce Purolator admin
- Purolator meta lives on the per-order screen, not in the orders list
- Purolator E-Ship Online requires a separate login outside WordPress
- Time-definite cohorts (Express 9AM vs 10:30AM vs Express) aren't a built-in filter
- Cross-border Canada-to-US cohorts aren't surfaced as a filter
- Failed bookings stay invisible until a customer chases or the order is opened
SleekView
- Every Purolator shipment as a queryable row
-
_purolator_servicemapped to a friendly-name column via a derived expression - Filter by service, destination country, rate band or ship date
- Saved views per role: ops, finance, Canadian customer support
-
Inline edits to
_purolator_pinroute through WooCommerce CRUD
Features
What SleekView gives you for WooCommerce Purolator
Purolator services as friendly rows
A derived column maps service codes to readable labels (Purolator Ground, Purolator Express, Purolator Express 9AM, Purolator Express 10:30AM, Purolator Express International). The Service column reads like E-Ship.
Composable Purolator filters
Stack filters on service, destination, rate band and status to assemble morning-priority queues, cross-border cohorts and booking-failure cleanup lists.
Rate inline for contract review
_purolator_rate sits on every row, so the Purolator contract review opens on filtered totals and per-service averages, not on an E-Ship CSV.
Audience
Who uses SleekView for WooCommerce Purolator
Shipping ops managers
Filter to today's Purolator Express 9AM orders for the morning-priority queue. Service-level drift surfaces as a filter result rather than an SLA escalation.
Finance and procurement
Export the month's Purolator shipments with rate and service for E-Ship invoice reconciliation. Service-tier averages feed the contract review.
Canadian customer support
Filter by destination and service for the where-is-my-package response. Cross-border US shipments inform customs-paperwork follow-up.
The bigger picture
Why Purolator integration deserves an in-WP table
A Canadian Woo store running Purolator is wiring two systems that rarely meet inside one screen: the WordPress order database and E-Ship Online. The plugin saves the right service, rate and PIN data on every order, but the WordPress admin keeps that data as per-order detail rather than as queryable signal. SleekView reads the same Purolator meta and renders one row per shipment with service (friendly-named), rate, PIN, ship date and status.
Filters stack into a single query so the Express 9AM queue, the cross-border US cohort and the contract-review prep all become saved views. Booking failures surface as an explicit filter rather than as customer escalations. E-Ship Online goes back to being a label-printing tool, and the audit lives where the rest of the order data already does.
Purolator keeps owning the API, SleekView owns the read-side picture inside WordPress.
Questions
Common questions about SleekView for WooCommerce Purolator
wc_orders joined with the _purolator_service, _purolator_rate, _purolator_pin and _purolator_ship_date meta keys, plus wc_order_addresses for shipping_country.
Yes. On HPOS the Purolator meta moves to wc_orders_meta. SleekView reads the active path, so the same view config works on legacy postmeta or HPOS.
Yes. _purolator_pin serves as the Purolator tracking number (PIN = Package Identification Number). The view renders it under a Tracking column and links to the Purolator tracking endpoint.
Yes. Build a view of orders in Processing with an empty _purolator_pin older than your sync interval. Save it as "Purolator booking gaps" for daily review.
Yes. Writes route through WooCommerce CRUD so woocommerce_order_status_changed and tracking-update hooks fire. Customer emails send as if from the per-order screen.
Yes. The SleekView table is the source the chart view aggregates, so a count-by-service or sum-of-rate chart pairs with the saved table view in one click.
Yes. Personal data columns (shipping address, customer email) respect WordPress capability scopes, so finance views can be locked to service and rate columns only.
SleekView paginates server-side and indexes on common meta keys. Filtered queries on _purolator_service and date ranges return in milliseconds at typical Canadian merchant scale.
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
- Paykickstart Bridge
- Yith Woocommerce Multi Vendor
- Wpc Product Quantity
- Woocommerce Freshbooks Sync
- Woocommerce Rewards Points
- Woocommerce Dhl Express
- Mvx Marketplace
- Yith Multi Vendor
- Woocommerce Gift Cards
- Woocommerce Multilingual Currency
- Woocommerce Wholesale Payments
- Woocommerce Product Vendors Pro
- Woocommerce Canpar Shipping
- Yith Woocommerce Zoom Magnifier
- Site Reviews