June 1, 2023

Creating Dynamic Sale Notifications for WooCommerce with JetEngine

Play Video

What is the Tutorial About?

Creating dynamic sale notifications for WooCommerce using the JetEngine advanced SQL query and AI is the focus of this tutorial. This is a feature available with JetEngine 3.2 and above, and it allows you to build an analogue of dynamic sale notifications for WooCommerce. These aren’t real-time notifications, but rather short notices of the most recent website sale, including the product and the date or time of sale.

Tutorial Steps

  1. Ensure you have the necessary plugins:
    Before starting, make sure you have the required plugins installed and activated. Also, ensure that you have several completed orders on your website.
  2. Create the SQL query:
    Go to your website dashboard, navigate to JetEngine > Query Builder, and create a new SQL/AI query. Name it something like “Dynamic Sale Notification”. Enable Advanced/AI mode and use the magic stick icon to generate the SQL query using AI. The prompt should be “WooCommerce select all product IDs from latest order add to the response product ID and Order date limit 1”.
  3. Build the listing:
    Go to JetEngine > Listings and create a new listing item. Choose the Query Builder source and pick the query you just created. Add a section and some heading that says “someone just purchased”. All the data will be pulled dynamically, so add the dynamic field widget to display the product title and purchase date.
  4. Style the listing:
    Style the listing as per your preference and hit update.
  5. Create a pop-up:
    Go back to the dashboard, navigate to Jet Pop-up, and create a new one. Delete the default widgets if there are any and add a listing grid widget. Select the listing you previously created and set columns and post number to one. Style the pop-up itself and set conditions for it.
  6. Set display conditions:
    Set the conditions for when and where the pop-up should be visible. You can set it to be shown on specific pages or the entire site.

Use Cases for this Tutorial

  • E-commerce websites:
    Displaying recent sales can create a sense of urgency and encourage visitors to make a purchase.
  • Bookstores:
    Showcasing recently sold books can pique the interest of book lovers visiting your site.
  • Fashion retailers:
    Highlighting recently purchased items can help promote trending fashion items.

Required Resources

WooCommerce Logo
Free Options
JetEngine Logo
Payment required
Credit to Crocoblock
Crocoblock is a YouTube channel dedicated to providing tutorials, tips, and insights on WordPress and web design. With a focus on the Crocoblock suite of plugins and themes, the channel offers valuable content for WordPress enthusiasts, developers, and designers looking to enhance their skills and create websites with their tools. Through step-by-step tutorials, product overviews, and expert advice, Crocoblock helps its audience master the art of WordPress website building and customization.
Creating Dynamic Sale Notifications for WooCommerce with JetEngine
Welcome back!
Enter your Helwp credentials to sign in.

No Account yet? Sign Up

My Account
Give Feedback
Describe your feedback *
Rate Helwp
Problem *
Describe the problem
Want us to reply?
Your E-Mail
Affiliate Disclosure

At Helwp, we’re committed to transparency and honesty. Therefore, we want to inform you that some of the links on our website are affiliate links. This means that, at no additional cost to you, we may earn a small commission if you click through and make a purchase.

We only promote products or services that we genuinely believe in. These affiliate commissions help us to maintain the website and continue to provide you with free, high-quality WordPress content.

If you are interested in how you can support us even further, check out our support page.