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.
You can download the plugin here:
Download Custom Database Tables Spreadsheet Plugin - or - Check the features
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.
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.
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.
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.
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.
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.
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.
This is a preview of the CSV file we have downloaded.
As you see, WP Sheet Editor allows you to find all the WooCommerce customers who have added products to their TI WooCommerce Wishlist.