SleekView for Shopify Importer: imported products & mappings as tables
SleekView reads the importer's per-product postmeta (_shopify_product_id, _shopify_variant_id, _shopify_handle) and the import-run cache in wp_options. Sort by import status, filter by source store, and fix broken mappings inline.
♾️ Lifetime License available
Imports that don't disappear after "Done"
Shopify-to-WooCommerce importers move products, variants, images, and metadata across in batches. Once the import finishes, the relationship between the WooCommerce product and its Shopify origin lives in wp_postmeta on each product: _shopify_product_id, _shopify_variant_id, _shopify_handle, plus _shopify_imported_at for the timestamp. The standard Products screen ignores all of it.
SleekView reads wp_posts with post_type=product joined against those meta keys, plus the import-run cache in wp_options (shopify_importer_runs). The result is a single table showing the WooCommerce SKU, Shopify handle, source variant ID, and last import timestamp, sortable and filterable across the whole catalogue.
Inline edits to _shopify_handle or other Shopify keys go through update_post_meta(), so subsequent incremental imports match the corrected mapping. Bulk-trigger a re-import on a filtered subset by firing the importer's own shopify_importer_resync_product hook on each row.
Workflow
How SleekView reads your Shopify import state
Pick the source
wp_posts with post_type=product as the base. SleekView scans for Shopify meta keys actually written by the importer in use.
Compose columns
Save and scope per role
Edit inline or bulk-update
Sample columns
A typical Shopify import view
_shopify_product_id and _shopify_handle against the product post type so every row shows its origin mapping.
wp_posts (post_type=product) + wp_postmeta + wp_options
| WC SKU | Shopify handle | Variant ID | Source store | Import status | Imported |
|---|---|---|---|---|---|
| TEE-BLK-S | black-tee-shirt | 44218811 | main-store | Synced | Apr 24 |
| MUG-WHT | white-ceramic-mug | 44218812 | main-store | Partial | Apr 24 |
| POSTER-A2 | art-poster-a2 | wholesale-store | Image failed | Apr 23 | |
| TOTE-NAT | natural-tote-bag | 44218815 | main-store | Synced | Apr 23 |
Comparison
Default Shopify Importer admin vs SleekView
Default Shopify Importer admin
-
Import-origin meta in
_shopify_product_idand_shopify_handleisn't shown in the Products list - Import log is chronological, not joinable with the resulting products
- Partial imports (missing images, missing variants) need manual product-by-product inspection
-
Source-store value lives in
_shopify_source_store, hidden behind the product edit screen - No way to filter "products imported with errors this week" from the Products screen
SleekView
-
Reads
_shopify_product_id,_shopify_handle,_shopify_variant_idas columns - Filter partial imports by date and source store in one saved view
- Inline-edit the Shopify handle when a slug needs realignment
-
Bulk-trigger the importer's
shopify_importer_resync_producthook - Group by source store using kanban for multi-store consolidations
Features
What SleekView gives you for Shopify Importer for WooCommerce
Origin mapping as columns
Shopify handle, product ID, variant ID, and source store sit on every WooCommerce product row. The origin relationship the importer stored becomes visible without a single product edit click.
Fix mappings inline
Inline-edit _shopify_handle when the Shopify side renamed a product. Subsequent incremental imports use the corrected handle automatically.
Bulk re-import a filtered subset
Select partial imports and trigger shopify_importer_resync_product on each. The importer reuses its existing batching and rate-limit handling.
Audience
Who uses SleekView for Shopify Importer
Migration teams
During a Shopify-to-WooCommerce cutover, filter for partial imports each day and resync. Source-store column makes multi-store migrations traceable.
Catalogue managers
Sort by _shopify_imported_at to find recently changed products. Spot which variants didn't come across and add them by hand without opening every product.
Support
When a customer reports a missing product image after migration, search by Shopify handle and see import status and date in one row. Often resolves the ticket without an escalation.
The bigger picture
Why Shopify-to-Woo migrations strain default admin
A Shopify-to-WooCommerce import is rarely a one-and-done event. Stores typically run incremental syncs while teams compare catalogues, fix mismatched variants, and replace failed image imports. The importer writes a clean set of postmeta to track the relationship, but the default Products screen ignores it, so the migration lead ends up exporting CSVs to compare against the Shopify side.
SleekView turns that into a saved view: sort by import timestamp, filter by partial status, group by source store, fix slugs inline. Multi-store migrations especially benefit, because the source-store column tells you which Shopify origin each product came from without opening the edit page. None of this changes how the importer works, it just exposes the data the importer already saved.
The migration finishes faster and the team trusts that what's in WooCommerce matches what was in Shopify.
Questions
Common questions about SleekView for Shopify Importer for WooCommerce
Most Shopify importers write the same family of meta keys (_shopify_product_id, _shopify_handle, _shopify_variant_id). SleekView's agent UI scans your store and surfaces whichever keys are actually present, so the view config adapts to your specific importer.
Yes, if the importer exposes a hook like shopify_importer_resync_product or similar. SleekView calls that hook per selected row. If your importer doesn't expose one, the column still surfaces state but the resync button stays hidden.
Variant meta is stored on the product or as separate product_variation posts. SleekView can build a variants view sourced from product_variation with the Shopify variant ID as a column. Image-import state usually lives in _shopify_image_status on the product itself.
Yes. If the importer stores _shopify_source_store, that becomes a filterable column. Migrations consolidating two or three Shopify stores into one WooCommerce store get a clear per-store status without a separate dashboard.
Inline meta edits go through update_post_meta(), which fires the standard updated_post_meta action. Importers that listen on that hook will react; others ignore the change until the next scheduled run.
If the importer writes a log array to _shopify_import_history, SleekView can render the latest entry as a column. Full history is better viewed in a per-product detail panel rather than the table.
Importers do the heavy lifting; SleekView just reads what they wrote. Queries hit indexed postmeta keys; for very large catalogues, narrow the view with a date filter on _shopify_imported_at before adding heavier joins.
All Shopify identifiers stay in postmeta and are read-only by default in SleekView. Inline-edit is opt-in per column, so you can lock the origin IDs while leaving slug-style fields editable.
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 Quickbooks
- Woocommerce Zip Checkout
- Tradegecko Wp
- Woocommerce Authorize Net Cim
- Woocommerce Color Swatches
- Woocommerce Nowpayments
- Thrivecart Funnels
- Woocommerce Instamojo
- Shipstation Woocommerce
- Woocommerce Splitit
- Woocommerce One Page Checkout
- Woocommerce Pre Orders
- Linnworks Wp
- Gumroad Wp
- Shipperhq Woocommerce