SleekView for AliExpress Dropshipping: imported items and orders as tables
Read the WooCommerce product post type joined with the AliExpress item id, store, and last-fetched timestamp the plugin stores in wp_postmeta. Audit which items are live, filter by store, and re-trigger sync inline.
♾️ Lifetime License available
Stop opening every imported item to check sync state
AliExpress Dropshipping plugins for WooCommerce pull listings from AliExpress into the product custom post type and stash the AliExpress item id, store id, and last-fetched timestamp in wp_postmeta. The default UI is an import dashboard and a settings page; the Products list still shows WooCommerce defaults, with AliExpress fields hidden in a metabox per product. There is no audit view, no roll-up by AliExpress store, and no inline way to spot items whose prices haven't refreshed in weeks.
SleekView reads wp_posts (post_type=product) and joins it with the plugin's meta keys, commonly _aliexpress_item_id, _aliexpress_store_id, and _aliexpress_last_fetched. Each row becomes one AliExpress-to-Woo mapping: item id next to WooCommerce price, store id next to stock, last-fetched timestamp next to category. Filter by store, sort by fetch age, save views per supplier.
Inline edits route through WooCommerce CRUD for product fields and through the plugin's hook for AliExpress-specific sync. Bulk re-trigger price sync for an entire store's catalogue in one pass, with the plugin's existing API client handling rate limits and signing.
Workflow
Audit AliExpress-to-Woo mappings
Pick the source
wp_posts (post_type=product) as the base and add the plugin's wp_postmeta keys as virtual columns. SleekView detects the AliExpress plugin and pre-fills the meta-key list.
Compose sync columns
_aliexpress_item_id, _aliexpress_store_id, _aliexpress_last_fetched, plus cost and retail for a full audit row.
Save the audit view
Re-sync and edit inline
Sample columns
A typical AliExpress imported items view
wp_posts with wp_postmeta keys the plugin writes, so each row pairs a WooCommerce product with its AliExpress item.
wp_posts (post_type=product) + wp_postmeta (_aliexpress_item_id, _aliexpress_store_id)
| Item | AliExpress ID | Store | Cost | Retail | Last fetched |
|---|---|---|---|---|---|
| Wireless earbuds, white | 100500338422 | AudioGearPro | $5.40 | €24.90 | Apr 24 |
| Yoga mat, eco | 100500227811 | FitLifeStore | $3.10 | €19.50 | Apr 14 |
| LED ring light, 10in | 100500091203 | BrightVision | $7.80 | €28.00 | Apr 23 |
| Magnetic phone mount | 100499845512 | GadgetHub | $1.20 | €9.90 | Mar 28 |
Comparison
Default AliExpress Dropshipping admin vs SleekView
Default AliExpress Dropshipping admin
- Import dashboard plus per-product metabox, no roll-up audit view
- No filter for "items not refreshed in 30 days" across the catalogue
- Margin updates require opening each item or running a full sync
- AliExpress store id and item id aren't surfaced as columns in the Products list
- Failed price syncs leave no obvious surface short of digging through logs
SleekView
-
Join
wp_posts (post_type=product)with AliExpress meta keys inwp_postmeta - Per-store roll-up view with item id, cost, retail, and last-fetched timestamp
- Filter by store, fetch age, or margin band and save the view
- Bulk re-fire the plugin's price-sync hook for a filtered cohort
- Save views per role ("stale > 14 days", "low margin items")
Features
What SleekView gives you for AliExpress Dropshipping for WooCommerce
AliExpress columns alongside Woo fields
Add _aliexpress_item_id, _aliexpress_store_id, and _aliexpress_last_fetched next to WooCommerce price and stock. One row per item, full sync context.
Re-fire price sync for a cohort
Select stale rows and re-fire the plugin's price-sync hook. The same code path that runs on a normal refresh runs again, so rate limits and signing stay on the plugin's existing client.
Store and freshness filters
Filter by AliExpress store, fetch-age window, and margin together. Save the view as "Store X, stale > 14 days" so the recovery cohort is one click away.
Audience
Who uses SleekView for AliExpress Dropshipping
Dropship operators
Audit which items map to which AliExpress stores, spot store concentration risk, identify stale-fetch items before customers see outdated prices.
Finance
Review margin distribution by store. Filter to items under target margin, bulk-update WooCommerce retail price, and let woocommerce_update_product fire.
Support
When a customer asks why a price moved, check the last-fetched column and confirm whether the sync ran. Re-fire the hook inline if it didn't.
The bigger picture
Why item audits matter for AliExpress dropshipping
AliExpress prices and stock change constantly, and a dropshipping store's margins live or die on how quickly the local catalogue reflects those changes. The default plugin admin is built around the import job: connect, browse items, click import, set markup. Everything that happens to those items afterwards (price changes at source, items going out of stock, stores closing) is invisible from that screen.
Catalogue managers end up running the full sync nightly even when only a handful of items have moved, or writing one-off queries against wp_postmeta to find stale rows. SleekView pairs each AliExpress item with its WooCommerce row in a single audit view and lets operators filter by store, fetch age, and margin. Re-syncs go through the plugin's own hook, so API access and rate limits stay where they belong.
The plugin keeps doing the AliExpress integration. SleekView is the operational surface for the relationship after the import.
Questions
Common questions about SleekView for AliExpress Dropshipping for WooCommerce
Imported items live in wp_posts (post_type=product), and the AliExpress item id, store id, and last-fetched timestamp live in wp_postmeta under keys like _aliexpress_item_id and _aliexpress_last_fetched. SleekView reads both and joins them per row.
No. SleekView reads the WordPress database and re-fires the plugin's own sync hook for refreshes. The plugin remains the integration point with AliExpress, so API access and rate limits stay on its existing client.
 
Filter by _aliexpress_last_fetched older than a chosen window (7, 14, 30 days) and save the view. SleekView refreshes the count each load so the cohort needing a refresh is always one click away.
Yes. Imported items are products, which stay on wp_posts regardless of HPOS. If you also audit AliExpress order routing, the plugin's per-order meta can be exposed on the HPOS wc_orders view.
If the plugin supports multiple connected accounts and writes the account id to wp_postmeta, SleekView exposes it as a column and filter. Build one view per account or a consolidated view with an account filter.
Re-sync iterates through the plugin's hook one row at a time, so the per-call rate matches a normal refresh. SleekView's bulk runner paces the queue so a large catalogue doesn't burst the API.
 
Yes. Any key the plugin writes to wp_postmeta for a product can be added as a column, including SKU mappings, shipping templates, or variation cost overrides.
No. The plugin's import flow, account connection, and order-routing logic remain in its own admin. SleekView is the audit and bulk-edit surface for what landed in WooCommerce.
 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 Shippo
- Woocommerce Shipworks
- Woocommerce Back In Stock
- Woocommerce Sezzle
- Woocommerce Shipping Canada Post
- Yith Woocommerce Anti Fraud
- Woocommerce Purchase Orders
- Woocommerce Mailchimp Discount
- Woocommerce Store Credit
- Woocommerce Variation Prices
- Woocommerce Gift Registry
- Wpc Fly Cart
- Woocommerce Wholesale Payments
- Woocommerce Variation Stock
- Woocommerce Customer Order Csv Export