SleekView for Etsy Shop Importer: imported listings as tables
Read the WooCommerce product post type joined with the Etsy listing id, shop id, and last-imported timestamp the importer stores in wp_postmeta. Audit which Etsy listings landed in WooCommerce, filter by Etsy section, and re-trigger import inline.
♾️ Lifetime License available
Stop matching Etsy listings to WooCommerce one tab at a time
Etsy Shop Importer plugins for WooCommerce pull listings from an Etsy shop into the product custom post type and stash the original Etsy listing id, image references, and shop identifiers in wp_postmeta. The default UI is a configuration screen plus a one-shot "Import now" button. There is no per-listing audit table, no view that pairs the Etsy id with the resulting WooCommerce product, and no inline way to see which listings imported with broken images or stripped tags.
SleekView reads the WooCommerce wp_posts (post_type=product) rows and joins them with the importer's meta keys (commonly _etsy_listing_id, _etsy_shop_id, _etsy_last_imported) so an owner can scan every imported listing in one table. Filter by Etsy section, sort by last-imported date, and surface stock state and price next to the original Etsy listing url.
Inline edits route through the importer's hooks where supported, or through WooCommerce's product CRUD so woocommerce_update_product still fires and any downstream sync stays consistent. Bulk-fix tag mismatches across a hundred imported listings in one pass, with the same hooks running as if a human had clicked through each one.
Workflow
Audit Etsy-to-WooCommerce imports
Pick the source
wp_posts (post_type=product) as the base and add the importer's wp_postmeta keys as virtual columns. SleekView detects the Etsy importer and pre-fills the meta-key list.
Compose audit columns
_etsy_listing_id, _etsy_shop_id, _etsy_last_imported, plus WooCommerce price, stock, and category for a full audit row.
Save the recovery view
Edit and re-import inline
Sample columns
A typical Etsy imported listings view
wp_posts with wp_postmeta keys the importer writes, so each row pairs a WooCommerce product with its Etsy origin.
wp_posts (post_type=product) + wp_postmeta (_etsy_listing_id, _etsy_shop_id)
| Listing | Etsy ID | Section | Price | Stock | Imported |
|---|---|---|---|---|---|
| Linen apron, sand | 1284561023 | Kitchen | €38.00 | In stock | Apr 24 |
| Ceramic mug, terracotta | 1284551884 | Drinkware | €22.00 | Low | Apr 24 |
| Hand-dyed scarf | 1284530112 | Accessories | €46.00 | In stock | Apr 23 |
| Beeswax taper set | 1284519028 | Home | €18.00 | Out | Apr 23 |
Comparison
Default Etsy Shop Importer admin vs SleekView
Default Etsy Shop Importer admin
- Settings page plus an import trigger, no per-listing audit table
- No view pairing the Etsy listing id with the resulting WooCommerce product
- Failed image or tag imports leave no obvious surface in WP Admin
-
Imported postmeta keys like
_etsy_listing_idaren't visible in the Products list - Re-triggering import for a filtered subset requires re-running the full job
SleekView
-
Join
wp_posts (post_type=product)with Etsy meta keys inwp_postmeta - Per-listing audit view with Etsy id, section, and last-imported timestamp
- Surface stock and price next to the Etsy origin url
- Filter by Etsy section, import date, or stock state and save the view
- Bulk re-fire the importer's hook for a filtered cohort, not the whole shop
Features
What SleekView gives you for Etsy Shop Importer
Etsy origin as first-class columns
Add _etsy_listing_id, _etsy_shop_id, and _etsy_last_imported as columns alongside WooCommerce price and stock. One row per imported listing, no detail tab required.
Re-import a filtered cohort
Select listings missing tags or with stale prices and re-fire the importer's hook. The same code path that runs on first import runs again, so downstream sync stays consistent.
Section and date filters together
Filter by Etsy section, last-imported window, and WooCommerce stock state in one query. Save the view as "Kitchen, imported last 7 days, low stock" so the operations cohort is one click away.
Audience
Who uses SleekView for Etsy Shop Importer
Shop owners
Confirm a fresh import actually landed: every Etsy listing has a matching WooCommerce row, prices match, images are present. Spot drift before customers do.
Catalogue editors
Bulk-fix tag and category mismatches inline. Filter by Etsy section, edit the WooCommerce category column for fifty rows at once, and let woocommerce_update_product fire normally.
Support
When a buyer asks about an Etsy variant that doesn't show on the WooCommerce store, look up the _etsy_listing_id column and confirm whether the listing imported or was filtered out by the importer's rules.
The bigger picture
Why import audits matter for Etsy-to-Woo stores
Etsy importers solve the easy case: an OAuth connection, an import button, a fresh set of WooCommerce products with their Etsy origin tucked away in wp_postmeta. The harder case is everything after that first import. Prices drift, listings get retired on Etsy and orphaned on Woo, tags imported into the wrong taxonomy, images that failed to download and left a placeholder behind.
The default importer admin is built around running a job, not auditing the result. Operators end up writing one-off queries against wp_postmeta to find listings that never imported, or eyeballing the Products list for missing items. SleekView gives shop owners, catalogue editors, and support a single table view that pairs each Etsy listing with its WooCommerce row, surfaces the meta keys that already exist, and lets them re-trigger the importer's own hooks for a filtered cohort.
The importer keeps doing what it does well. SleekView is the operational surface for confirming that what should be there actually is.
Questions
Common questions about SleekView for Etsy Shop Importer
Imported listings become standard WooCommerce product posts in wp_posts. The Etsy listing id, shop id, and import timestamp live in wp_postmeta under keys like _etsy_listing_id and _etsy_last_imported. SleekView reads both and joins them per row.
No. SleekView reads the local WordPress database and re-fires the importer's own hooks for re-imports. The importer remains the single integration point with the Etsy API, so OAuth tokens and rate limits stay where they are.
If the importer writes a failure flag or last-error to wp_postmeta, SleekView exposes it as a filterable column. Where it doesn't, you can still spot gaps by comparing the count of expected Etsy listings to actual WooCommerce product rows in the audit view.
Edits go through WooCommerce's CRUD layer, so woocommerce_update_product fires and downstream sync hooks run normally. SleekView doesn't bypass the importer's update path.
Yes. The importer writes to wp_posts for products regardless of HPOS, since HPOS only moves orders. Product imports remain on the post type and SleekView reads them the same way.
If the importer supports multiple shops and writes the shop id to _etsy_shop_id, SleekView shows shop id as a column and filter. Build one view per shop or a consolidated view with a shop filter.
Variable products and their variations both live in wp_posts. SleekView can build a parent-row view that aggregates variation stock, or a flat variation-level view that joins wp_postmeta keys per variation.
No. The importer's settings, OAuth flow, and import job runner remain where they are. SleekView is the audit and bulk-edit surface for what landed in WooCommerce after the import ran.
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 Loyalty Program
- Yith Woocommerce Product Slider
- Woocommerce Dhl Express
- Woo Direct Checkout
- Woocommerce Product Filter
- Woocommerce Bing Shopping
- Woocommerce Affiliatewp Integration
- Cartflows
- Woocommerce Octobat
- Charitable
- Woocommerce Bitpay
- Woocommerce Klarna Checkout
- Woocommerce Product Add Ons
- Woocommerce Quote Request
- Woocommerce Variation Prices
- Content Control Cm
- Woocommerce Memberships
- Super Socializer
- Wp Private Content Pro
- Wp Affiliate Platform
- Leaky Paywall
- User Registration
- Memberium Infusionsoft
- Thrive Apprentice
- Restrict Content
- Tva Thrive Apprentice
- Paid Memberships Pro Addons
- Userpro Pro
- Register Plus Redux
- Wp Private Content Plus