SleekView for Spocket: imported supplier products as tables
Read the WooCommerce product post type joined with the Spocket product id, supplier id, and ship-from country the integration stores in wp_postmeta. Audit per-supplier coverage, filter by ship-from region, and bulk-edit categories inline.
♾️ Lifetime License available
Stop hunting for which Spocket supplier ships from where
Spocket's WooCommerce integration imports curated supplier products into the product custom post type and persists the Spocket product id, supplier id, and ship-from country in wp_postmeta. Spocket's own dashboard lives outside WP Admin; inside Woo, the Products list shows defaults plus a per-product metabox. There is no roll-up audit view, no filter for "US-shipped products only", and no inline way to bulk-categorise an entire supplier's imported catalogue.
SleekView reads wp_posts (post_type=product) and joins it with Spocket's meta keys, typically _spocket_product_id, _spocket_supplier_id, and _spocket_ship_from. Each row becomes a supplier-aware product entry: Spocket id next to Woo price, ship-from country next to stock, supplier id next to category. Filter by ship-from region, sort by import date, save views per supplier or per shipping zone.
Inline edits route through WooCommerce CRUD for Woo fields and through Spocket's hook where supported. Bulk-categorise a hundred imported products in one pass, or filter by ship-from country and bulk-update shipping class so storefront filters stay accurate.
Workflow
Audit Spocket-to-Woo imports
Pick the source
wp_posts (post_type=product) as the base and add Spocket's wp_postmeta keys as virtual columns. SleekView detects the integration and pre-fills the meta-key list.
Compose supplier columns
_spocket_product_id, _spocket_supplier_id, and _spocket_ship_from, plus WooCommerce price and stock for a full audit row.
Save the supplier view
Edit inline
Sample columns
A typical Spocket imported products view
wp_posts with wp_postmeta keys the integration writes, so each row pairs a WooCommerce product with its Spocket supplier.
wp_posts (post_type=product) + wp_postmeta (_spocket_product_id, _spocket_supplier_id)
| Product | Spocket ID | Supplier | Ships from | Cost | Stock |
|---|---|---|---|---|---|
| Linen tote bag | sp_82741 | Atlantic Crafts | US | $4.20 | In stock |
| Wool throw blanket | sp_82602 | NordicTextiles | EU | €12.50 | In stock |
| Ceramic planter, small | sp_82518 | Greenleaf Studio | US | $6.80 | Low |
| Bamboo cutlery set | sp_82411 | EcoLiving | EU | €3.10 | Out |
Comparison
Default Spocket integration admin vs SleekView
Default Spocket integration admin
- Per-product metabox in Woo; the main dashboard lives outside WP Admin
- No filter for "US-shipped products only" or per-supplier roll-up inside Woo
- Bulk category assignment requires the Woo Products list, with supplier info hidden
- Spocket supplier id and ship-from country aren't columns in the Products list
- Stale stock indicators only appear after a customer attempts to buy
SleekView
-
Join
wp_posts (post_type=product)with Spocket meta keys inwp_postmeta - Ship-from country as a filter for shipping-zone audits
- Filter by supplier, ship-from region, or stock state in one query
- Bulk-update categories and shipping classes through Woo CRUD
- Save views per role ("US suppliers only", "EU low stock")
Features
What SleekView gives you for Spocket
Ship-from country as a column
Add _spocket_ship_from alongside WooCommerce price and stock. Build US-only or EU-only views for stores that promise regional shipping, no metabox digging.
Supplier and stock filters together
Filter by Spocket supplier, ship-from region, and Woo stock state in one query. Save the view as "EU suppliers, low stock" so reorder candidates are one click away.
Bulk-categorise inline
Select an entire supplier's imports and assign categories or shipping classes in one pass. woocommerce_update_product fires per row, so search and storefront filters stay current.
Audience
Who uses SleekView for Spocket
Dropship operators
Audit per-supplier coverage and ship-from distribution. Spot supplier concentration risk and confirm regional shipping promises actually match the import mix.
International storefronts
Build separate views for US, EU, and rest-of-world catalogues. Each storefront's shipping zone gets its own scoped Spocket subset.
Support
When a customer asks where a product ships from, look up the Spocket supplier and ship-from column. Quote shipping time accurately based on the supplier's region.
The bigger picture
Why Spocket audits matter for regional storefronts
Spocket's pitch is supplier quality and regional fulfilment: US suppliers shipping to US customers, EU suppliers shipping to EU customers, fast and credible. The pitch only holds up if the catalogue mix actually matches the storefronts you're promising. The default Woo Products list doesn't expose ship-from country, supplier id, or Spocket product id, so confirming the promise means opening products one at a time.
SleekView turns that audit into a single filtered view. Operators see ship-from distribution at a glance, finance spots cost-versus-retail outliers across suppliers, and support quotes shipping times from the actual supplier metadata instead of a generic policy. Edits go through Woo CRUD, so storefront filters and search index hooks fire normally.
The Spocket dashboard keeps handling discovery and supplier connections. The in-WP audit surface lives inside SleekView, next to the rest of the product data.
Questions
Common questions about SleekView for Spocket
Imported products live in wp_posts (post_type=product), and the Spocket product id, supplier id, and ship-from country live in wp_postmeta under keys like _spocket_product_id and _spocket_ship_from. SleekView reads both and joins them per row.
No. SleekView reads the WordPress database. Spocket's external dashboard and API stay where they are; SleekView is the in-Woo audit surface for what the integration has imported locally.
Yes. Filter by _spocket_ship_from equals US (or EU, or any country code Spocket writes) and save the view. Useful for stores that promise local shipping for regional customers.
Yes. Spocket products live in wp_posts, which is unaffected by HPOS. HPOS only relocates orders, so the product audit view is identical on legacy and HPOS stores.
Build a view sorted by supplier id with a count column, or filter to a single supplier and review the row count. Useful for spotting catalogue dependencies on any single Spocket partner.
Yes. Edits to WooCommerce product fields go through CRUD, so woocommerce_update_product fires per row and downstream sync (search index, storefront filters) runs normally.
If the integration writes a stock or last-checked timestamp to wp_postmeta, SleekView shows it as a filterable column. Where Spocket relies on Woo's native stock fields, the standard Woo stock column covers it.
No. Spocket's product discovery, supplier connection, and external dashboard remain where they are. SleekView is the in-WP audit and bulk-edit surface for what the integration has already pushed into Woo.
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 Shipping Pickup Location
- Wcfm Delivery
- Woocommerce Extra Options
- Woocommerce Direct Checkout Pro
- Woocommerce Tax Toggle
- Woocommerce Wholesale Payments
- Restropress
- Trustpulse
- Automatewoo
- Yith Woocommerce Stripe
- Woocommerce Multistore
- Yith Woocommerce Ajax Product Filter
- Yith Woocommerce Deposits And Down Payments
- Stitchlabs Wp
- Woocommerce Cod Fee