SleekView for WooCommerce Stock Sync: sync history & SKU pairs as tables
Read sync logs from the plugin's history table (or wc_orders_meta for per-order sync state) and join to wp_posts (post_type=product). Audit which SKUs synced when, and which failed, without scrolling a flat log.
♾️ Lifetime License available
Sync history as a real audit table
WooCommerce Stock Sync plugins (Stock Sync for WooCommerce by various authors, Stock Synchronization for WooCommerce, plus the multistore plugins that include a sync feature) keep product stock numbers consistent across stores or between WooCommerce and an external system (Shopify, marketplace feeds, supplier CSVs). The data model varies: some write a sync log to a custom table like wc_stock_sync_log, some store last-synced timestamps in postmeta per product, some keep a SKU-pair mapping for multistore sync.
The default admin usually shows a flat log of recent sync runs and per-product sync timestamps on each product edit screen. There is no filterable audit table that says "these 312 SKUs synced successfully in the last hour, these 8 failed, these 47 are paired with a destination SKU but haven't been synced this week." SleekView reads the plugin's sync log table directly, joins to product post id, and surfaces source SKU, destination SKU, last-synced timestamp, and result as columns.
Inline edits to a SKU pair update the plugin's mapping through its API where exposed, or write the postmeta directly with conflict detection. Re-trigger a sync for selected rows from the same view, useful when an upstream API outage left a batch in failed state.
Workflow
How SleekView reads stock-sync data
Pick the source
wp_posts (post_type=product) joined to postmeta for the SKU-pair audit. SleekView detects the active sync plugin.
Compose columns
Save and scope per role
Edit inline or retry
Sample columns
Sync history view
postmeta sync timestamps) to wp_posts (post_type=product) via product id.
wp_wc_stock_sync_log (or plugin equivalent) + wp_postmeta (_stock_sync_*) + wp_posts (post_type=product)
| Product | SKU | Destination | Last sync | Result | Stock delta |
|---|---|---|---|---|---|
| Studio Lamp | SL-014 | shopify:7421 | 11:42 | Synced | +12 |
| Drafting Table | DT-022 | amazon:DT-022 | 11:40 | Throttled | 0 |
| Aluminium Tripod | AT-105 | shopify:7422 | 11:38 | Failed | -3 |
| Walnut Shelf | WS-301 | supplier-csv | 10:12 | Synced | +20 |
Comparison
Default Stock Sync admin vs SleekView
Default Stock Sync admin
- Sync log is a flat chronological list with no per-SKU filter and no result filter
-
Per-product last-synced timestamp lives in
postmetabut doesn't surface in the Products list - SKU pairs (source and destination) are visible per product but not as a list view
- Failed sync runs don't have a re-trigger action on the list level
- No way to spot SKUs that are mapped but haven't been synced this week
SleekView
- Sync log as a filterable audit table with source SKU, destination, result, and timestamp
- Sort by last-synced to find stale mappings
- Filter by result (synced, throttled, failed) and re-trigger failures from the view
- SKU-pair audit on the products view with destination as a real column
- Per-destination aggregate (count synced today per Shopify, Amazon, supplier CSV)
Features
What SleekView gives you for WooCommerce Stock Sync
Sync log as an audit table
Read the plugin's sync log table directly, join to wp_posts (post_type=product) via product id, and surface source SKU, destination, last sync, and result as sortable columns. Replaces the flat chronological log.
Filter failures and re-trigger
Filter the log by result (failed, throttled), select rows, re-trigger sync inline. Writes go through the plugin's sync API so retry counters, rate-limit timers, and notification hooks fire as expected.
SKU-pair audit on Products
Surface destination SKU and last-synced timestamp as columns on the Products list. Find SKUs that are mapped but haven't synced this week, or unmapped products that should be.
Audience
Who uses SleekView for WooCommerce Stock Sync
Inventory ops
Daily sync audit: synced today, failures pending retry, mappings missing. Triage from a single saved view instead of scrolling a flat log.
Multichannel managers
Per-destination aggregates: Shopify synced count, Amazon throttled count, supplier-CSV failures. Decide which channel needs attention this morning.
Site admins
Audit stale mappings, fix orphaned SKU pairs, and verify that recent product imports actually picked up their destination mappings.
The bigger picture
Why sync history needs a real audit view
Selling on more than one channel turns stock sync into a critical-path service. Shopify, Amazon, eBay, supplier CSV feeds, sister stores: each is a destination that has to receive accurate stock counts within minutes of an order. When sync works, nobody notices.
When sync breaks, the storefront oversells, customers churn, and ops scrolls a flat log trying to spot which destination is throttling and which SKUs are stuck. The default admin makes the audit hard: a chronological log without per-SKU filters, per-product timestamps that live in postmeta and never surface as columns, no list view that catches SKUs mapped but not synced in the last day. SleekView reads the same sync log the plugin already writes and turns it into a filterable, sortable, re-triggerable audit table.
Same database, same sync API, dramatically less log-scrolling for the inventory lead trying to find which destination ate the morning's stock updates.
Questions
Common questions about SleekView for WooCommerce Stock Sync
Plugins that write a sync log to a custom table or to postmeta per product. Stock Sync for WooCommerce, Stock Synchronization for WooCommerce, multi-store sync features in Aelia Foundation Classes, marketplace-feed plugins like WP-Lister: all expose a sync history that SleekView reads as a table.
Stock sync touches products, not orders, so HPOS does not change the schema. Some plugins also track per-order stock decrements; for those, the relevant table is wc_orders_meta on HPOS or postmeta on legacy, and SleekView joins automatically.
Yes. Filter the log to failed rows, select, click Retry. The retry routes through the plugin's sync API so retry counters and rate-limit timers behave the same as a normal retry, with no special bulk path that bypasses logic.
 Yes. Group the sync log by destination (Shopify, Amazon, supplier CSV) and aggregate counts per result type. The result is a per-destination dashboard built from the same log the plugin already writes.
 Yes. Show the destination-SKU column on the Products list and filter by NULL. The result is the list of products without a destination mapping, useful after a bulk product import where mappings were missed.
 Yes. SKU-pair edits route through the plugin's mapping API where exposed (most stock-sync plugins expose one), or write the meta directly with a conflict warning. Re-trigger requests go through the same code path as a manual retry.
 If the plugin writes the delta to its log (most do, including supplier-CSV importers), SleekView surfaces it as a column. Sort by delta to find the largest stock movements and audit them against expectations.
 
Sync logs grow fast. Index the log table on product_id, destination, and created_at (most plugins do this by default), and pin views to a date-range filter. SleekView uses keyset pagination on the primary key so large logs stay responsive.
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
- Gumroad Wp
- Woocommerce Octanepay
- Wpc Buy Now Button
- Currency Switcher
- Woocommerce Tip Jar
- Surecart Affiliates
- Samcart Bridge
- Woocommerce Xero
- Woocommerce Clearpay
- Woocommerce Composite Products
- Woocommerce Etsy Integration
- Woocommerce Correos
- Edd Convertkit
- Woocommerce Purolator
- Woocommerce Sage Accounting