SleekView for WooCommerce Favorites: customer favorites as tables
WooCommerce Favorites stores each user's favorite product ids in wp_usermeta. SleekView expands the favorites list into one row per user-product pair so most-favorited reports and per-customer views live in one screen.
♾️ Lifetime License available
Favorites turned into reporting
WooCommerce Favorites takes a lightweight approach: each registered customer's favorite product ids live in wp_usermeta under a plugin-specific key (typically woocommerce_favorites) as a serialized array, and guest favorites are kept in a cookie that is migrated to user meta on login. The default admin renders a per-user list inside the user profile, which means there is no surface that ranks products by favorite count or that segments customers by what they have saved.
SleekView reads the user meta directly, expands the serialized array into one row per user-product pair, and joins to wp_posts for product name and price plus wp_wc_product_meta_lookup for stock status. Most-favorited views aggregate by product id, while per-customer views show every favorite for a given user without opening their profile.
Inline edits (removing a favorite, moving a favorite onto a different product variation) route through the plugin's API so any hooks the plugin fires on add/remove are respected. Bulk operations like clearing favorites for inactive users use the same path.
Workflow
How SleekView assembles the Favorites view
Pick the source
wp_usermeta filtered to the plugin's favorites key. Join to wp_posts for product name and wp_wc_product_meta_lookup for stock.
Compose the column set
Save and scope the view
Edit inline or bulk
Sample columns
A typical favorites view
wp_usermeta (woocommerce_favorites) + wp_posts (post_type=product) + wp_wc_product_meta_lookup
| User | Product | Last saved | Current price | Stock | Status |
|---|---|---|---|---|---|
| alex@studio.co | Linen tote | Apr 24 | $42.00 | In stock | Active |
| ria@design.io | Ceramic vase | Apr 21 | €38.00 | In stock | Active |
| tom@hello.dev | Wool blanket | Apr 02 | £89.00 | Low stock | Low stock |
| mia@brew.coop | Legacy mug | Feb 11 | $0.00 | Out of stock | Discontinued |
Comparison
Default WooCommerce Favorites admin vs SleekView
Default Favorites admin
- Favorites only show inside the per-user profile screen
- Most-favorited aggregation across customers is not built in
-
Stock joins to
wp_wc_product_meta_lookupare not surfaced -
Per-customer favorite history needs SQL on serialized
wp_usermeta - Bulk-tidy of favorites for inactive users is not built in
SleekView
-
Expand serialized favorites in
wp_usermetainto one row per pair - Join to product name, current price, and stock status
- Rank products by favorite count across all customers
- Filter to favorites pointing at out-of-stock or discontinued products
- Save views per marketer or merchandiser
Features
What SleekView gives you for WooCommerce Favorites
Most-favorited ranking
Aggregate user-product rows by product id to rank items by favorite count, with optional revenue weighting from wp_wc_product_meta_lookup for promotion planning.
Per-customer favorites
Filter rows by user id or email to see every favorite a customer has saved without opening their profile, perfect for support and one-to-one outreach.
Stale favorite filters
Filter to favorites that now point at out-of-stock or deleted products so the catalogue stays trustworthy for the customers who saved them.
Audience
Who uses SleekView for WooCommerce Favorites
Marketing
Identify customers whose favorites recently went on sale and trigger personalised outreach. Most-favorited rankings inform seasonal promotion picks.
Merchandising
Rank products by favorite count alongside sales count to spot items with high intent but low conversion, suggesting price or photography tests.
Support
During a chat, look up the customer's saved favorites and use that context to suggest similar in-stock alternatives when a favorite is out of stock.
The bigger picture
Why a favorites table matters
WooCommerce Favorites is a lightweight signal capture: every favorite is a customer telling the store what they like without buying yet, which is one of the cleanest intent signals a merchant gets. The default admin treats favorites as a profile-level detail, so the data sits in wp_usermeta with no surface that ranks products, segments customers, or flags stale favorites pointing at out-of-stock items. SleekView reads the user meta directly, joins to product and stock tables, and exposes favorites as a sortable, filterable, editable table.
Marketing can finally trigger personalised outreach when a favorited product changes price or comes back in stock. Merchandising can finally rank products by intent rather than only by sales. Support can finally pull a customer's saved items during a chat without opening their profile.
The plugin still owns the favorites mechanism; SleekView turns the captured signal into a working surface.
Questions
Common questions about SleekView for WooCommerce Favorites
Guest favorites live in a cookie until login, so they are not in the database. Once migrated to wp_usermeta on login, they appear in the view alongside registered favorites.
Yes. Favorites live in user meta and product tables, neither of which HPOS affects. Optional order-side joins read wp_wc_orders when HPOS is enabled.
Yes. The most-favorited view aggregates user-product rows by product id and sorts by count. Optional weighting by current price gives a rough revenue indicator.
 
Yes. Join wp_wc_product_meta_lookup for stock status and filter the view to favorites whose linked product is now out of stock or trash.
SleekView reads the current serialized array, so removed favorites disappear from the view as soon as the user removes them. There is no historical snapshot unless one is added separately.
 Yes. Select rows pointing at deleted or discontinued products and remove them via the plugin's API so its hooks fire.
 Yes. Filter by product or customer segment and export to CSV with the same columns the view shows including last-saved date.
 Yes. Each saved view is gated by WordPress capability so marketing, merchandising, and support can each have their own scoped views.
 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
- Surecart Subscriptions
- Woocommerce Aftership
- Woocommerce Shipping Canada Post
- Woocommerce Deutsche Post
- Woocommerce Wishlists
- Woocommerce Bulk Discounts
- Site Reviews
- Lemonsqueezy Wp
- Variation Swatches
- Wholesale Market
- Woocommerce Worldpay
- Woocommerce One Page Checkout
- Woocommerce Customizer
- Woocommerce Product Comparison
- Woocommerce Taxify