✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

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

SleekView table view for WooCommerce Favorites

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

1

Pick the source

Choose wp_usermeta filtered to the plugin's favorites key. Join to wp_posts for product name and wp_wc_product_meta_lookup for stock.
2

Compose the column set

Add user, product, last-saved date, current price, and stock status. Optionally join order items for purchase history.
3

Save and scope the view

Name it ("Most favorited this month", "Favorites now out of stock") and gate it by capability so each team sees the right slice.
4

Edit inline or bulk

Remove stale favorites or move favorites onto different product variations. Writes go through the plugin's API so its hooks fire.

Sample columns

A typical favorites view

One row per user-product favorite with last-saved date and current price.
Source: 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_lookup are 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_usermeta into 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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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