{"id":40036,"date":"2023-05-30T16:00:23","date_gmt":"2023-05-30T16:00:23","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/?post_type=article&p=40036"},"modified":"2024-08-09T09:38:25","modified_gmt":"2024-08-09T09:38:25","slug":"sql-query-with-open-ai-dynamic-sale-notifications","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/","title":{"rendered":"How to Create Dynamic Sale Notifications for WooCommerce SQL Query with Open AI"},"content":{"rendered":"\n

This tutorial will show how to generate the SQL query with AI to show a notification of the most recent website sale: the product itself and the date\/time.<\/p>\n\n\n\n

Before you proceed further, ensure you have several completed orders on the website.\u00a0<\/p>\n\n\n\n

\"completed<\/div>\n\n\n\n

Create the SQL Query<\/h2>\n\n\n\n

Follow the JetEngine > Query Builder <\/em><\/strong>path and push the \u201cAdd New\u201d <\/strong>button.<\/p>\n\n\n\n

Give the query a Name<\/strong>, and select the \u201cSQL\/AI Query\u201d Query Type<\/strong>.<\/p>\n\n\n\n\"add\n\n\n\n

Enable the Advanced\/AI mode <\/strong>toggle, and you\u2019ll see that the settings are different than if you decided to write SQL query manually.<\/p>\n\n\n\n

To use AI, press the magic stick<\/strong> icon, and the pop-up for the SQL query generation will appear.<\/p>\n\n\n\n\"advanced\n\n\n

<\/svg><\/div>
Warning<\/div>

Currently, you can make 30 requests per month with the Lifetime subscription plan and 5 requests per month with other subscriptions.<\/p><\/div><\/div>\n\n\n\n

Now the critical thing is to write the correct prompt so the AI understands the request.<\/p>\n\n\n\n

I entered the \u201cWooCommerce. Select all product IDs from latest order. Add to the response product_ID and order_date. Limit 1.\u201d text into the Describe your query <\/strong>textarea.<\/p>\n\n\n\n\"describe\n\n\n\n

Hit the \u201cGenerate query\u201d <\/strong>button, and get a generated query.<\/p>\n\n\n\n

\"use\n\n\n\n

Check it and press the \u201cUse this query\u201d <\/strong>button. After that, you can see the generated query in the SQL Query <\/strong>field.<\/p>\n\n\n\n\"SQL\n\n\n\n

Return to the top of the page and enable the Preview results <\/strong>toggle.<\/p>\n\n\n\n\"preview\n\n\n\n

At the bottom of the preview pop-up, you can see the last order details. The order_item_name matches the last order (High waist denim shorts) on my website.<\/p>\n\n\n\n

\"preview<\/figure>\n\n\n\n

After you finish, press the \u201cAdd\/Update Query\u201d <\/strong>button.<\/p>\n\n\n\n

Create a Listing Item<\/h2>\n\n\n\n

Move to the JetEngine > Listings <\/em><\/strong>tab and click the \u201cAdd New\u201d <\/strong>button. <\/p>\n\n\n\n

In the Setup Listing Item <\/strong>pop-up, choose the \u201cQuery Builder\u201d Source<\/strong> and pick the needed Query <\/strong>as well. Enter the Listing item name <\/strong>and choose the \u201cElementor\u201d Listing view<\/strong>. Then, click the \u201cCreate Listing Item\u201d <\/strong>button.<\/p>\n\n\n\n\"listing\n\n\n\n

To show the \u201cSomeone purchased\u201d label, I used the Header <\/strong>widget.<\/p>\n\n\n\n

I used the Dynamic Field <\/strong>widget to display the order details. To learn more, proceed to the Dynamic Field Widget Overview<\/strong><\/a>.<\/p>\n\n\n\n

To show the product title, select the \u201cPost\/Term\/User\/Object Data\u201d Source<\/strong> and the \u201corder_item_name\u201d Object Field.<\/strong><\/p>\n\n\n\n\"order\n\n\n\n

To display how much time has passed since purchase, select the \u201cPost\/Term\/User\/Object Data\u201d Source<\/strong> and the \u201cpost_date\u201d Object Field<\/strong>.<\/p>\n\n\n\n\"post\n\n\n\n

Then, enable the Filter field output <\/strong>toggle and pick the \u201cHuman readable time difference\u201d Callback<\/strong>. Also, you can use the Customize field output <\/strong>option.<\/p>\n\n\n\n\"human\n\n\n\n

To show the product thumbnail, choose the \u201cPost\/Term\/User\/Object Data\u201d Source and the \u201cmeta_value\u201d Object Field. Enable the Filter field output <\/strong>toggle and pick the \u201cGet post\/page thumbnail\u201d Callback<\/strong>.<\/p>\n\n\n\n\"get\n\n\n\n

After you done customizing, press the \u201cUpdate\u201d <\/strong>button.<\/p>\n\n\n\n

Create a Pop-up<\/h2>\n\n\n\n

Proceed to the JetPopup > Create New Popup <\/em><\/strong>tab.<\/p>\n\n\n\n

In the Create a Popup <\/strong>window, select the \u201cElementor\u201d Content Type<\/strong>, pick the \u201cBordering\u201d Preset<\/strong>, and click the \u201cCreate\u201d <\/strong>button.<\/p>\n\n\n\n\"create\n\n\n\n

Drag-n-drop the Listing Grid <\/strong>widget to the container. Select the needed Listing <\/strong>in the drop-down menu, and set the \u201c1\u201d Columns Number <\/strong>and \u201c1\u201d Post Number<\/strong>.<\/p>\n\n\n\n\"listing\n\n\n\n

Click on the Settings <\/strong>icon.<\/p>\n\n\n\n

\"\"<\/div>\n\n\n\n

Open the Settings <\/strong>tab and customize the pop-up. I applied the \u201cOn page load(s) Open event<\/strong> \u2013 it opens a pop-up with a delay after the page loads.<\/p>\n\n\n\n

You can learn more about pop-up creation and pop-up settings from the How to Create a New Popup Template in Elementor<\/strong><\/a> tutorial.<\/p>\n\n\n\n

Then, press the \u201cEdit\u201d <\/strong>button near the Display Conditions <\/strong>option.<\/p>\n\n\n\n

\"\"<\/div>\n\n\n\n

Set the visibility conditions in the appeared window. I set the \u201cInclude,\u201d \u201cEntire,\u201d and \u201cEntire Site\u201d conditions. Learn more from the Popup <\/a><\/strong>Conditions Overview<\/strong><\/a>.<\/p>\n\n\n\n

When you finish, hit the \u201cSave Conditions\u201d <\/strong>button.<\/p>\n\n\n\n\"set\n\n\n\n

Return to the pop-up on the Elementor editing page and open the Style<\/strong> settings tab.<\/p>\n\n\n\n

Here you can customize the pop-up style setting. To learn more, go to the Popup Style Settings Overview in Elementor<\/strong><\/a>.<\/p>\n\n\n\n

For example, I changed the pop-up Width <\/strong>in the Popup Container <\/strong>tab.<\/p>\n\n\n\n\"popup\n\n\n\n

I changed the close button position with the Icon Transform <\/strong>option in the Close Button <\/strong>settings tab.<\/p>\n\n\n\n\"popup\n\n\n\n

Also, I disabled the Use Overlay <\/strong>option in the Popup Overlay <\/strong>settings tab. If enabled, it covers the screen beyond the pop-up by darkening the background.<\/p>\n\n\n\n\"popup\n\n\n\n

When you finish, hit the \u201cUpdate\u201d <\/strong>button.<\/p>\n\n\n\n

Proceed to the front end. According to my condition, the pop-up will open on the entire website, so I went to a random page. The pop-up appeared according to the open event settings.<\/p>\n\n\n\n\"dynamic\n\n\n\n

Let\u2019s make a new purchase. As you can see, the dynamic notification was changed immediately.<\/p>\n\n\n\n\"dynamic\n\n\n\n

That\u2019s all. Now you can generate the SQL query for the WooCommerce dynamic notification sale using OpenAI.<\/p>\n","protected":false},"excerpt":{"rendered":"

Learn how to show visitors the last sale on the website and when the order was completed.<\/p>\n","protected":false},"author":8,"featured_media":0,"template":"","format":"standard","builder-category":[],"article-category":[405],"yoast_head":"\nHow to Generate SQL Query with Open AI: Dynamic Sale Notifications | Crocoblock<\/title>\n<meta name=\"description\" content=\"Discover how to generate the SQL query using the power of OpenAI to display dynamic sale notifications for WooCommerce. Learn how to show visitors the last sale on the site and when the order was completed.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Generate SQL Query with Open AI: Dynamic Sale Notifications | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"Discover how to generate the SQL query using the power of OpenAI to display dynamic sale notifications for WooCommerce. Learn how to show visitors the last sale on the site and when the order was completed.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-09T09:38:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/05\/completed-order.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/\",\"name\":\"How to Generate SQL Query with Open AI: Dynamic Sale Notifications | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2023-05-30T16:00:23+00:00\",\"dateModified\":\"2024-08-09T09:38:25+00:00\",\"description\":\"Discover how to generate the SQL query using the power of OpenAI to display dynamic sale notifications for WooCommerce. Learn how to show visitors the last sale on the site and when the order was completed.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/articles\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Create Dynamic Sale Notifications for WooCommerce SQL Query with Open AI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"name\":\"Help Center\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\",\"name\":\"Help Center\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"contentUrl\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"caption\":\"Help Center\"},\"image\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Generate SQL Query with Open AI: Dynamic Sale Notifications | Crocoblock","description":"Discover how to generate the SQL query using the power of OpenAI to display dynamic sale notifications for WooCommerce. Learn how to show visitors the last sale on the site and when the order was completed.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/","og_locale":"en_US","og_type":"article","og_title":"How to Generate SQL Query with Open AI: Dynamic Sale Notifications | Crocoblock","og_description":"Discover how to generate the SQL query using the power of OpenAI to display dynamic sale notifications for WooCommerce. Learn how to show visitors the last sale on the site and when the order was completed.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/","og_site_name":"Help Center","article_modified_time":"2024-08-09T09:38:25+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/05\/completed-order.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/","url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/","name":"How to Generate SQL Query with Open AI: Dynamic Sale Notifications | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2023-05-30T16:00:23+00:00","dateModified":"2024-08-09T09:38:25+00:00","description":"Discover how to generate the SQL query using the power of OpenAI to display dynamic sale notifications for WooCommerce. Learn how to show visitors the last sale on the site and when the order was completed.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/sql-query-with-open-ai-dynamic-sale-notifications\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/crocoblock.com\/knowledge-base\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/crocoblock.com\/knowledge-base\/articles\/"},{"@type":"ListItem","position":3,"name":"How to Create Dynamic Sale Notifications for WooCommerce SQL Query with Open AI"}]},{"@type":"WebSite","@id":"https:\/\/crocoblock.com\/knowledge-base\/#website","url":"https:\/\/crocoblock.com\/knowledge-base\/","name":"Help Center","description":"","publisher":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization","name":"Help Center","url":"https:\/\/crocoblock.com\/knowledge-base\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/","url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","contentUrl":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","caption":"Help Center"},"image":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article\/40036"}],"collection":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/users\/8"}],"wp:attachment":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/media?parent=40036"}],"wp:term":[{"taxonomy":"builder-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/builder-category?post=40036"},{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article-category?post=40036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}