SleekView for Amazon Product Importer: ASIN-to-Woo mapping as tables
Read the WooCommerce product post type joined with the ASIN, marketplace, and last-fetched timestamp the importer stores in wp_postmeta. Audit which ASINs are live in Woo, filter by marketplace, and bulk-refresh prices inline.
♾️ Lifetime License available
Stop scanning the Products list for stale ASIN data
Amazon Product Importer tools pull listings from Amazon's PA-API into WooCommerce product posts and store the ASIN, marketplace, and price history in wp_postmeta. The default UI is built around the import job: paste ASINs or a category, click import, watch the queue. There is no per-product audit view that pairs the ASIN with the resulting WooCommerce row, no quick filter for "prices that haven't refreshed in 30 days", and no inline way to spot listings that fell out of the affiliate program.
SleekView reads wp_posts (post_type=product) and joins it with the importer's meta keys, typically _amzn_asin, _amzn_marketplace, _amzn_last_fetched, and _amzn_affiliate_url. Filter by marketplace, sort by last-fetched date, and surface the affiliate url next to the WooCommerce price and stock state. One table, every ASIN, no clicking into individual products to read postmeta.
Inline edits route through WooCommerce's CRUD where they touch product fields, and through the importer's hook where they touch ASIN-specific metadata. Bulk-refresh fifty stale listings in one pass, or filter by marketplace and re-fetch prices through the importer's own PA-API client so quotas and signing stay on the importer's code path.
Workflow
Audit ASIN-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 Amazon importer and pre-fills the meta-key list.
Compose audit columns
_amzn_asin, _amzn_marketplace, _amzn_last_fetched, and the affiliate url, plus WooCommerce price and stock for a full audit row.
Save the recovery view
Refresh and edit inline
Sample columns
A typical Amazon imported products view
wp_posts with wp_postmeta keys the importer writes, so each row pairs a WooCommerce product with its Amazon origin.
wp_posts (post_type=product) + wp_postmeta (_amzn_asin, _amzn_marketplace)
| Product | ASIN | Marketplace | Price | Last fetched | Affiliate |
|---|---|---|---|---|---|
| Noise-cancelling headphones | B09XS7DK11 | amazon.com | $249.00 | Apr 24 | Live |
| Mechanical keyboard, 60% | B08TLPV3MZ | amazon.de | €119.00 | Apr 22 | Stale |
| Travel backpack 25L | B0BYCXV2KP | amazon.co.uk | £68.00 | Apr 23 | Live |
| USB-C hub 7-in-1 | B07ZQH3T9X | amazon.com | $42.00 | Mar 30 | Dropped |
Comparison
Default Amazon Product Importer admin vs SleekView
Default Amazon Product Importer admin
- Job-runner UI focused on imports, not audits of imported state
-
No table view pairing ASINs with WooCommerce
productrows -
Stale-price detection requires manual queries against
wp_postmeta - Dropped affiliate links don't surface in the Products list at all
- Re-fetching for a filtered cohort means re-running the full job or clicking each product
SleekView
-
Join
wp_posts (post_type=product)with ASIN meta keys inwp_postmeta - Per-product audit view with ASIN, marketplace, and last-fetched timestamp
- Filter by marketplace, fetch age, or affiliate state in one query
- Bulk-refresh through the importer's own PA-API hook, no shadow API path
- Save views per role ("stale prices last 30 days", "dropped from program")
Features
What SleekView gives you for Amazon Product Importer
ASIN as a first-class column
Add _amzn_asin, _amzn_marketplace, and _amzn_last_fetched alongside WooCommerce price and stock. One row per imported product, no postmeta archaeology.
Re-fetch a filtered cohort
Select stale rows and re-fire the importer's PA-API fetch hook. Signing, quotas, and locale handling stay on the importer's existing client, so nothing about your Amazon configuration changes.
Marketplace and freshness filters
Filter by amazon.com, amazon.de, amazon.co.uk, fetch-age window, and affiliate state at once. Save the view as "DE stale > 14 days" so the recovery cohort is one click away.
Audience
Who uses SleekView for Amazon Product Importer
Affiliate operators
Spot dropped ASINs before they cost commission. Filter by affiliate state, sort by traffic if your analytics writes view counts to postmeta, and prioritise replacements.
Catalogue managers
Audit cross-marketplace coverage: which ASINs exist on amazon.com but not amazon.de, where prices have drifted. The marketplace column makes the gap obvious.
Support
When a customer reports a broken affiliate link, look up the ASIN, check _amzn_last_fetched and the affiliate-state column, and trigger a refresh inline without escalating.
The bigger picture
Why ASIN audits matter for Amazon affiliate stores
An Amazon affiliate store's catalogue isn't a one-time import. Prices change daily, listings get pulled from the program without warning, ASINs vanish when sellers retire products, and stale prices kill conversion. The default importer admin is built around the moment of import: connect, paste ASINs, click run.
Everything that happens to those listings afterwards is invisible from that screen. Operators end up writing custom queries against wp_postmeta, eyeballing the Products list for stale rows, or running scheduled cron jobs that refresh everything regardless of whether it needs it. SleekView pairs each ASIN with its WooCommerce row in a single audit view and lets affiliate operators filter by marketplace, fetch age, and affiliate state.
Refreshes go through the importer's own hook, so PA-API quotas and signing stay where they belong. The importer keeps doing what it does well, and the operational surface for what got imported lives next to it in WP Admin.
Questions
Common questions about SleekView for Amazon Product Importer
Imported products live in wp_posts (post_type=product), and the ASIN, marketplace, last-fetched timestamp, and affiliate url live in wp_postmeta under keys like _amzn_asin and _amzn_last_fetched. SleekView reads both and joins them per row.
No. SleekView reads the WordPress database and re-fires the importer's own fetch hook for refreshes. The importer remains the single integration point with PA-API, so request signing, quotas, and locale routing stay on its existing client.
If the importer writes an affiliate-state flag or last-error to wp_postmeta, SleekView exposes it as a filterable column. Where the importer doesn't persist state, you can flag stale-fetch rows and re-fire on them to surface drops via the next response.
Yes. If the importer writes _amzn_marketplace (or a similar key) per row, SleekView shows marketplace as a column and filter so amazon.com, amazon.de, and amazon.co.uk listings sit in one audit view.
Refreshes iterate through the importer's hook one row at a time, so the per-call rate matches a normal fetch. SleekView's bulk runner paces the queue so a large refresh doesn't burst against PA-API quotas.
If the importer maps a parent ASIN to a WooCommerce variable product and children to variations, SleekView can build either a parent-row view or a flat variation view. Both pull from wp_posts with their respective postmeta.
Yes. Any key the importer (or your own code) writes to wp_postmeta for the product row can be added as a column. Useful for star ratings, review counts, or other PA-API fields you choose to persist.
No. The importer's PA-API credentials, import jobs, and configuration remain in its own admin. SleekView is the audit and refresh surface for the products it has already imported 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 Extra Product Options
- Woocommerce Razorpay Pro
- Yith Woocommerce Quick View
- Yith Woocommerce Product Image Gallery Slider
- Woocommerce Truste Checkout
- Payu Money Woocommerce
- Woocommerce Multi Currency Switcher
- Woocommerce Measurement Price
- Bigcommerce
- Sliced Invoices
- Woocommerce Purolator
- Sprout Invoices
- Woocommerce Invoice System
- Pretty Links
- Yith Subscriptions