WooCommerce – Find Customers Who Added Products to Wishlist

In this tutorial, we’ll show you how to find all customers who have added products to their TI WooCommerce Wishlist.

TI WooCommerce Wishlist is a WordPress plugin for WooCommerce that allows users to create a wishlist of products they would like to purchase or save for later.

Here’s where finding all the users who have added products to their wishlist can be a good idea. For example, you can create a special 5% OFF discount coupon for all users with items in their wishlist, and share the coupon via email.

Of course, you need to know which customers have added products to their wishlist, and this is where the WP Sheet Editor – Custom Database Tables plugin can be a great help.

WP Sheet Editor – Custom Database Tables allows you to edit the database tables of your site within WordPress. It’s a great way to view and manage database tables using an intuitive spreadsheet.

How to open the TI WooCommerce Wishlist table on WordPress

After installing and activating WP Sheet Editor – Custom Database Tables on your WordPress site, you can open the database tables added by the TI WooCommerce Wishlist plugin.

In this case, we’ll open the Wishlists database table.

  • Go to WP Sheet Editor > Edit Custom Database Tables
  • Find the Edit Wpey Tinvwl Lists button and click on it.

TI WooCommerce Wishlist table on WordPress

You’ll see a spreadsheet containing all the wishlists.

Except for the “Default Wishlist”, all the wishlists that appear in the spreadsheet belong to users who have added items to their wishlist.

This means that if a user has not added any products to their wishlist, the plugin does not create a wishlist for them, only when items are added to it.

You can find which users have added products to their wishlist by paying attention to the Author column.

The Author column displays the user ID, so you can export or copy the IDs.

woocommerce find customers who added products to their wishlist

Optional – Find the users by ID using “WP Sheet Editor – WordPress Users”

WP Sheet Editor – WordPress Users simplifies the process of finding your website users by using the user ID as a search parameter.

This can help you a lot if, for example, you want to find users to email them a discount coupon.

To find all the users who added products to their wishlist, you need to:

  • Open the users spreadsheet by going to WP Sheet Editor > Edit Users.
  • Click on Search.

Find Users Who Added Items to Wishlist

Once you’re on the Search tool:

  • Tick the Enable advanced filters checkbox.
  • Enter the IDs in the Find these IDs field. This field accepts IDs separated by commas, spaces, new lines, or tabs (|).
  • Click on Run search to find all the users with the selected IDs.

woocommerce find customers who added products to their wishlist

Once you run the search, you’ll see all the users that match the search filter displayed in the spreadsheet.

You can see the active search filters above the spreadsheet.

woocommerce find customers who added products to their wishlist

To find the email address of all the filtered users, you can go to the Email column.

You can also export the email addresses to a CSV file. Just click on Export.

Find Users Who Added Items to Wishlist

Once in the Export tool, you need to select these values to export the email address of all the users who added products to their wishlist.

  • What columns do you want to export: In this case, we will export the email addresses only.
  • Which rows do you want to export: All the rows from my current search
  • What app will you use to edit this file: In this case, we’ll select Older versions of Microsoft Excel
  • Click on Start new export.

woocommerce find customers who added products to their wishlist

This is a preview of the CSV file we have downloaded.

Find Users Who Added Items to Wishlist

As you see, WP Sheet Editor allows you to find all the WooCommerce customers who have added products to their TI WooCommerce Wishlist.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.