{"id":4418,"date":"2024-11-15T22:26:36","date_gmt":"2024-11-15T16:56:36","guid":{"rendered":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/"},"modified":"2024-11-15T22:42:24","modified_gmt":"2024-11-15T17:12:24","slug":"import-emails-from-any-tables","status":"publish","type":"docs","link":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/","title":{"rendered":"Import Emails from Any Tables"},"content":{"rendered":"\n<p>The <strong>Import Emails from Any Tables<\/strong> feature provides advanced flexibility for importing email addresses directly from your OpenCart database. By leveraging this tool, admins can extract and import email addresses based on specific criteria, ensuring precision and efficiency in building email groups.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Fields in the Import Tool<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>From Table:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Displays a list of all tables available in your database.<\/li>\n\n\n\n<li>Select the table containing the email addresses you want to import (e.g., <code>customer<\/code>, <code>order<\/code>, etc.).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Column Name:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Lists all column names available in the selected table.<\/li>\n\n\n\n<li>Automatically selects the column named <code>email<\/code> if it exists.<\/li>\n\n\n\n<li>If your column has a different name, you can manually select it. Ensure the column contains valid email addresses. Selecting a non-email column will result in invalid imports.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Filter Query:<\/strong><em>(Optional)<\/em>\n<ul class=\"wp-block-list\">\n<li>Allows the use of a simple SQL <code>WHERE<\/code> clause (without joins) to filter records before importing.<\/li>\n\n\n\n<li>Use the <strong>Calculate<\/strong> button to check the number of records matching your filter query.<\/li>\n\n\n\n<li>Example filter queries:\n<ul class=\"wp-block-list\">\n<li>To fetch emails from a specific date range:<br><code>WHERE date_added BETWEEN '2023-01-01 00:00:00' AND '2024-12-31 23:59:59' AND status = 1<\/code><\/li>\n\n\n\n<li>To fetch customers based on a year range:<br><code>WHERE (YEAR(date_added) BETWEEN 2023 AND 2024) AND status = 1<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>To Group:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Select the target email group where the fetched email addresses will be imported.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">How to Use<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Navigate to the <strong>Import Emails from Any Tables<\/strong> section.<\/li>\n\n\n\n<li>Select the appropriate table from the <strong>From Table<\/strong> dropdown.<\/li>\n\n\n\n<li>Choose the column containing email addresses from the <strong>Column Name<\/strong> dropdown.\n<ul class=\"wp-block-list\">\n<li>Ensure the column has valid email data.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>(Optional) Use the <strong>Filter Query<\/strong> field to refine your selection.\n<ul class=\"wp-block-list\">\n<li>Click <strong>Calculate<\/strong> to view the total records matching the query.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Select the desired group from the <strong>To Group<\/strong> dropdown.<\/li>\n\n\n\n<li>Click <strong>Import<\/strong> to fetch and import the email addresses into the selected group.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Examples<\/h3>\n\n\n\n<p><strong>Example 1:<\/strong> Import emails from the <code>customer<\/code> table between the years 2023 and 2024.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>From Table: <code>customer<\/code><\/li>\n\n\n\n<li>Column Name: <code>email<\/code><\/li>\n\n\n\n<li>Filter Query: <code>WHERE (YEAR(date_added) BETWEEN 2023 AND 2024) AND status = 1<\/code><\/li>\n\n\n\n<li>To Group: [Select your target group]<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"134\" src=\"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5-1024x134.png\" alt=\"\" class=\"wp-image-4421\" srcset=\"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5-1024x134.png 1024w, https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5-300x39.png 300w, https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5-768x101.png 768w, https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5.png 1283w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Example 2:<\/strong> Import emails from the <code>customer<\/code> table for a specific date range.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>From Table: <code>customer<\/code><\/li>\n\n\n\n<li>Column Name: <code>email<\/code><\/li>\n\n\n\n<li>Filter Query: <code>WHERE date_added BETWEEN '2023-01-01 00:00:00' AND '2024-12-31 23:59:59' AND status = 1<\/code><\/li>\n\n\n\n<li>To Group: [Select your target group]<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-7.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"100\" src=\"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-7-1024x100.png\" alt=\"\" class=\"wp-image-4423\" srcset=\"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-7-1024x100.png 1024w, https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-7-300x29.png 300w, https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-7-768x75.png 768w, https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-7.png 1388w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Benefits of This Feature<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Precision:<\/strong> Enables admins to extract emails based on detailed filters.<\/li>\n\n\n\n<li><strong>Efficiency:<\/strong> Automates the process of importing emails directly from database tables.<\/li>\n\n\n\n<li><strong>Customization:<\/strong> Offers SQL-based filtering for advanced targeting.<\/li>\n\n\n\n<li><strong>Flexibility:<\/strong> Supports any table or column in your database containing valid email addresses.<\/li>\n<\/ul>\n\n\n\n<p>This feature is ideal for businesses that want to leverage their existing database for email marketing and communication purposes, ensuring that emails are imported with precision and aligned with business goals.<\/p>\n","protected":false},"featured_media":0,"parent":479,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-4418","docs","type-docs","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Import Emails from Any Tables - HuntBee Resources<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import Emails from Any Tables - HuntBee Resources\" \/>\n<meta property=\"og:description\" content=\"The Import Emails from Any Tables feature provides advanced flexibility for importing email addresses directly from your OpenCart database. By leveraging this tool, admins can extract and import email addresses based on specific criteria, ensuring precision and efficiency in building email groups. Fields in the Import Tool How to Use Examples Example 1: Import emails [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"HuntBee Resources\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/huntbee.opencart\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-15T17:12:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5-1024x134.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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/email-groups\\\/import-emails-from-any-tables\\\/\",\"url\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/email-groups\\\/import-emails-from-any-tables\\\/\",\"name\":\"Import Emails from Any Tables - HuntBee Resources\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/email-groups\\\/import-emails-from-any-tables\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/email-groups\\\/import-emails-from-any-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image-5-1024x134.png\",\"datePublished\":\"2024-11-15T16:56:36+00:00\",\"dateModified\":\"2024-11-15T17:12:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/email-groups\\\/import-emails-from-any-tables\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/email-groups\\\/import-emails-from-any-tables\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/email-groups\\\/import-emails-from-any-tables\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image-5.png\",\"contentUrl\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image-5.png\",\"width\":1283,\"height\":168},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/email-groups\\\/import-emails-from-any-tables\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Email Template Designer Pro\",\"item\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Email Groups\",\"item\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/docs\\\/email-template-designer-pro\\\/email-groups\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Import Emails from Any Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/#website\",\"url\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/\",\"name\":\"HuntBee Resources\",\"description\":\"OpenCart Extension Documentations - Guides - Blogs - Projects\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/#organization\",\"name\":\"HuntBee OpenCart\",\"url\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/cropped-mobile-logo-new.png\",\"contentUrl\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/cropped-mobile-logo-new.png\",\"width\":945,\"height\":200,\"caption\":\"HuntBee OpenCart\"},\"image\":{\"@id\":\"https:\\\/\\\/www.huntbee.com\\\/resources\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/huntbee.opencart\",\"https:\\\/\\\/www.instagram.com\\\/opencart.huntbee\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import Emails from Any Tables - HuntBee Resources","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:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/","og_locale":"en_US","og_type":"article","og_title":"Import Emails from Any Tables - HuntBee Resources","og_description":"The Import Emails from Any Tables feature provides advanced flexibility for importing email addresses directly from your OpenCart database. By leveraging this tool, admins can extract and import email addresses based on specific criteria, ensuring precision and efficiency in building email groups. Fields in the Import Tool How to Use Examples Example 1: Import emails [&hellip;]","og_url":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/","og_site_name":"HuntBee Resources","article_publisher":"https:\/\/www.facebook.com\/huntbee.opencart","article_modified_time":"2024-11-15T17:12:24+00:00","og_image":[{"url":"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5-1024x134.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/","url":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/","name":"Import Emails from Any Tables - HuntBee Resources","isPartOf":{"@id":"https:\/\/www.huntbee.com\/resources\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/#primaryimage"},"image":{"@id":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5-1024x134.png","datePublished":"2024-11-15T16:56:36+00:00","dateModified":"2024-11-15T17:12:24+00:00","breadcrumb":{"@id":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/#primaryimage","url":"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5.png","contentUrl":"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2024\/11\/image-5.png","width":1283,"height":168},{"@type":"BreadcrumbList","@id":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/import-emails-from-any-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.huntbee.com\/resources\/"},{"@type":"ListItem","position":2,"name":"Email Template Designer Pro","item":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/"},{"@type":"ListItem","position":3,"name":"Email Groups","item":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/"},{"@type":"ListItem","position":4,"name":"Import Emails from Any Tables"}]},{"@type":"WebSite","@id":"https:\/\/www.huntbee.com\/resources\/#website","url":"https:\/\/www.huntbee.com\/resources\/","name":"HuntBee Resources","description":"OpenCart Extension Documentations - Guides - Blogs - Projects","publisher":{"@id":"https:\/\/www.huntbee.com\/resources\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.huntbee.com\/resources\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.huntbee.com\/resources\/#organization","name":"HuntBee OpenCart","url":"https:\/\/www.huntbee.com\/resources\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.huntbee.com\/resources\/#\/schema\/logo\/image\/","url":"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2020\/04\/cropped-mobile-logo-new.png","contentUrl":"https:\/\/www.huntbee.com\/resources\/wp-content\/uploads\/2020\/04\/cropped-mobile-logo-new.png","width":945,"height":200,"caption":"HuntBee OpenCart"},"image":{"@id":"https:\/\/www.huntbee.com\/resources\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/huntbee.opencart","https:\/\/www.instagram.com\/opencart.huntbee\/"]}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/docs\/4418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/comments?post=4418"}],"version-history":[{"count":1,"href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/docs\/4418\/revisions"}],"predecessor-version":[{"id":4424,"href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/docs\/4418\/revisions\/4424"}],"up":[{"embeddable":true,"href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/docs\/479"}],"next":[{"title":"Video Demonstration - Email Groups","link":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/video-demonstration-email-groups\/","href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/docs\/1577"}],"prev":[{"title":"Adding email addresses to email group","link":"https:\/\/www.huntbee.com\/resources\/docs\/email-template-designer-pro\/email-groups\/adding-email-addresses-to-email-group\/","href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/docs\/1588"}],"wp:attachment":[{"href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/media?parent=4418"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.huntbee.com\/resources\/wp-json\/wp\/v2\/doc_tag?post=4418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}