1. Documentation /
  2. Follow-Ups /
  3. Follow-Ups FAQ /
  4. Helpful Queries

Helpful Queries

WooCommerce Follow-ups is a premium extension. The following queries can be helpful. We recommend using these queries only if you know what you are doing. As always, backup your database before attempting any of these queries against it.

Delete all Scheduled Emails for a specific email

↑ Back to top
Find your database prefix
  • Replace prefix with your prefix for your database
  • The default is wp_ – can be found in wp-config.php
Get the email_id
  • Replace the email_id with that of the email you wish to remove
  • To find this ID, hover over the email name in Follow-up Emails > Scheduled Emails
  • http://domain.com/wp-admin/post.php?post=12345&action=edit
  • email_id is the post=12345

Delete all Scheduled Emails

↑ Back to top
Find your database prefix
  • Replace prefix with your prefix for your database
  • The default is wp_ – can be found in wp-config.php
Make sure is_sent = 0
  • If is_sent = 1 then all history and reporting will be lost
Run the following SQL query