{"id":24848,"date":"2019-03-04T05:31:59","date_gmt":"2019-03-04T05:31:59","guid":{"rendered":"https:\/\/www.knowband.com\/blog\/?p=24848\/"},"modified":"2019-03-13T14:23:26","modified_gmt":"2019-03-13T04:53:26","slug":"show-products-search-blank-opencart-2-3-x","status":"publish","type":"post","link":"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/","title":{"rendered":"Show all products when search is blank (Opencart 2.3.x)"},"content":{"rendered":"<h2><strong>Objectives of the blog<\/strong><\/h2>\n<p>After reading this blog you will be able to display all products when the search is blank.<\/p>\n<h3><strong>Problem Statement<\/strong><\/h3>\n<p>Currently in Opencart, when user search for any string using search functionality, then no products are returned if no search product found in database. We want to make it return all the products when search is empty.<\/p>\n<h3><strong>Code Implementation <\/strong><\/h3>\n<p>To achieve this, we will have to make some changes in the model function which we are using to fetch products from database on the basis of entered search keyword.<\/p>\n<p>Here we are making changes in <strong>getProducts()<\/strong> \u00a0function of model <strong>catalog\/model\/catalog\/product.php<\/strong> as we are using this function to display results on the basis of search keyword.<\/p>\n<p><strong>Note:<\/strong> you can make same changes in the model function which you are using to fetch products.<\/p>\n<p>Here is the code which we have added in the model:<\/p>\n<pre class=\"brush: actionscript3; gutter: true\">\/*Checked if the result empty (affected rows 0) of query which is running to fetch data on the basis of search keyword.\r\n* If yes then added new query to fetch new added products and executed same.  \r\n* By doing this we will display our new products on the search page instead of showing blank page.\r\n*\/\r\nif($query-&gt;num_rows == 0){\r\n   $sql = &quot;SELECT DISTINCT p.product_id  \r\n           FROM &quot; . DB_PREFIX . &quot;product p  \r\n           LEFT JOIN &quot; . DB_PREFIX . &quot;product_description pd ON (p.product_id = pd.product_id)  \r\n           LEFT JOIN &quot; . DB_PREFIX . &quot;product_to_store p2s ON (p.product_id = p2s.product_id)  \r\n           WHERE p.status = &#039;1&#039; AND p.date_available &lt;= NOW() AND p2s.store_id = &#039;&quot; . (int)$this-&gt;config-&gt;get(&#039;config_store_id&#039;) . &quot;&#039;  \r\n           GROUP BY p.product_id ORDER BY p.product_id DESC LIMIT 20&quot;;\r\n   $query = $this-&gt;db-&gt;query($sql);\r\n}<\/pre>\n<p>Add this code just after executing main query or just after line<strong> ($query = $this-&gt;db-&gt;query($sql))<\/strong>.<\/p>\n<p>In this code first we have checked the number of affected row by the main query (used to fetch data on the basis of search keyword). If the affected row is 0 <strong>($query-&gt;num_rows == 0)<\/strong> then added our query to fetch new added products.<\/p>\n<p>By doing this we will display our new products on the search page instead of showing blank page.<\/p>\n<p><strong>Note:<\/strong> here we have written query to fetch new added products from the database if search is empty. You can also add query to fetch special or best seller products according to your requirement.<\/p>\n<h3><strong>Summary<\/strong><\/h3>\n<p>After making the following changes in the model file, new added products will be shown when the search is empty.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Objectives of the blog After reading this blog you will be able to display all products when the search is blank. Problem Statement Currently in Opencart, when user search for any string using search functionality, then no products are returned if no search product found in database. We want to make it return all the [&hellip;]<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kbui_enabled":"","footnotes":""},"categories":[7],"tags":[8885,9190,8883,8884,9189,9188],"class_list":["post-24848","post","type-post","status-publish","format-standard","hentry","category-opencart-tutorials","tag-blank-search","tag-opencart-product-display-on-blank-search","tag-opencart-tutorial","tag-product-display","tag-product-display-on-blank-search-in-opencart-2-3-x","tag-show-all-products-on-blank-search-for-opencart"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Show all products when search is blank (Opencart 2.3.x) | Knowband Blog<\/title>\n<meta name=\"description\" content=\"By reading this &quot;Show all products when search is blank (Opencart 2.3.x)&quot; blog you can display all products when the search is blank.\" \/>\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.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Show all products when search is blank (Opencart 2.3.x) | Knowband Blog\" \/>\n<meta property=\"og:description\" content=\"By reading this &quot;Show all products when search is blank (Opencart 2.3.x)&quot; blog you can display all products when the search is blank.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowband Blog | Ecommerce Modules\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Knowband\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-04T05:31:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-13T04:53:26+00:00\" \/>\n<meta name=\"author\" content=\"Shivika Tomar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@KnowbandPlugin\" \/>\n<meta name=\"twitter:site\" content=\"@KnowbandPlugin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shivika Tomar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/opencart-tutorials\\\/show-products-search-blank-opencart-2-3-x\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/opencart-tutorials\\\/show-products-search-blank-opencart-2-3-x\\\/\"},\"author\":{\"name\":\"Shivika Tomar\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#\\\/schema\\\/person\\\/cc28589f6431305d8aa3fbb75ce97415\"},\"headline\":\"Show all products when search is blank (Opencart 2.3.x)\",\"datePublished\":\"2019-03-04T05:31:59+00:00\",\"dateModified\":\"2019-03-13T04:53:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/opencart-tutorials\\\/show-products-search-blank-opencart-2-3-x\\\/\"},\"wordCount\":295,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#organization\"},\"keywords\":[\"blank search\",\"OpenCart Product display on blank search\",\"opencart tutorial\",\"product display\",\"Product display on blank search in OpenCart 2.3.x\",\"Show all Products on blank search for OpenCart\"],\"articleSection\":[\"Opencart Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/opencart-tutorials\\\/show-products-search-blank-opencart-2-3-x\\\/\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/opencart-tutorials\\\/show-products-search-blank-opencart-2-3-x\\\/\",\"name\":\"Show all products when search is blank (Opencart 2.3.x) | Knowband Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#website\"},\"datePublished\":\"2019-03-04T05:31:59+00:00\",\"dateModified\":\"2019-03-13T04:53:26+00:00\",\"description\":\"By reading this \\\"Show all products when search is blank (Opencart 2.3.x)\\\" blog you can display all products when the search is blank.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/opencart-tutorials\\\/show-products-search-blank-opencart-2-3-x\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knowband.com\\\/blog\\\/opencart-tutorials\\\/show-products-search-blank-opencart-2-3-x\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/opencart-tutorials\\\/show-products-search-blank-opencart-2-3-x\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Show all products when search is blank (Opencart 2.3.x)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/\",\"name\":\"Knowband Blog | Ecommerce Modules\",\"description\":\"Magento, Prestashop, Opencart, Shopify\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#organization\",\"name\":\"Knowband Blog | Ecommerce Modules\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/cropped-knowband_logo-v2.png\",\"contentUrl\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/cropped-knowband_logo-v2.png\",\"width\":153,\"height\":61,\"caption\":\"Knowband Blog | Ecommerce Modules\"},\"image\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Knowband\",\"https:\\\/\\\/x.com\\\/KnowbandPlugin\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#\\\/schema\\\/person\\\/cc28589f6431305d8aa3fbb75ce97415\",\"name\":\"Shivika Tomar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/bio_pic-150x150.jpg\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/bio_pic-150x150.jpg\",\"contentUrl\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/bio_pic-150x150.jpg\",\"caption\":\"Shivika Tomar\"},\"description\":\"Shivika Tomar is a passionate PHP developer. Her area of interest is website development. She loves to bring healing to stressful and sad peoples.\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/author\\\/stomar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Show all products when search is blank (Opencart 2.3.x) | Knowband Blog","description":"By reading this \"Show all products when search is blank (Opencart 2.3.x)\" blog you can display all products when the search is blank.","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.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/","og_locale":"en_US","og_type":"article","og_title":"Show all products when search is blank (Opencart 2.3.x) | Knowband Blog","og_description":"By reading this \"Show all products when search is blank (Opencart 2.3.x)\" blog you can display all products when the search is blank.","og_url":"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/","og_site_name":"Knowband Blog | Ecommerce Modules","article_publisher":"https:\/\/www.facebook.com\/Knowband","article_published_time":"2019-03-04T05:31:59+00:00","article_modified_time":"2019-03-13T04:53:26+00:00","author":"Shivika Tomar","twitter_card":"summary_large_image","twitter_creator":"@KnowbandPlugin","twitter_site":"@KnowbandPlugin","twitter_misc":{"Written by":"Shivika Tomar","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/#article","isPartOf":{"@id":"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/"},"author":{"name":"Shivika Tomar","@id":"https:\/\/www.knowband.com\/blog\/fr\/#\/schema\/person\/cc28589f6431305d8aa3fbb75ce97415"},"headline":"Show all products when search is blank (Opencart 2.3.x)","datePublished":"2019-03-04T05:31:59+00:00","dateModified":"2019-03-13T04:53:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/"},"wordCount":295,"commentCount":0,"publisher":{"@id":"https:\/\/www.knowband.com\/blog\/fr\/#organization"},"keywords":["blank search","OpenCart Product display on blank search","opencart tutorial","product display","Product display on blank search in OpenCart 2.3.x","Show all Products on blank search for OpenCart"],"articleSection":["Opencart Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/","url":"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/","name":"Show all products when search is blank (Opencart 2.3.x) | Knowband Blog","isPartOf":{"@id":"https:\/\/www.knowband.com\/blog\/fr\/#website"},"datePublished":"2019-03-04T05:31:59+00:00","dateModified":"2019-03-13T04:53:26+00:00","description":"By reading this \"Show all products when search is blank (Opencart 2.3.x)\" blog you can display all products when the search is blank.","breadcrumb":{"@id":"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.knowband.com\/blog\/opencart-tutorials\/show-products-search-blank-opencart-2-3-x\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knowband.com\/blog\/fr\/"},{"@type":"ListItem","position":2,"name":"Show all products when search is blank (Opencart 2.3.x)"}]},{"@type":"WebSite","@id":"https:\/\/www.knowband.com\/blog\/fr\/#website","url":"https:\/\/www.knowband.com\/blog\/fr\/","name":"Knowband Blog | Ecommerce Modules","description":"Magento, Prestashop, Opencart, Shopify","publisher":{"@id":"https:\/\/www.knowband.com\/blog\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knowband.com\/blog\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.knowband.com\/blog\/fr\/#organization","name":"Knowband Blog | Ecommerce Modules","url":"https:\/\/www.knowband.com\/blog\/fr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knowband.com\/blog\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/cropped-knowband_logo-v2.png","contentUrl":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/cropped-knowband_logo-v2.png","width":153,"height":61,"caption":"Knowband Blog | Ecommerce Modules"},"image":{"@id":"https:\/\/www.knowband.com\/blog\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Knowband","https:\/\/x.com\/KnowbandPlugin"]},{"@type":"Person","@id":"https:\/\/www.knowband.com\/blog\/fr\/#\/schema\/person\/cc28589f6431305d8aa3fbb75ce97415","name":"Shivika Tomar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2019\/02\/bio_pic-150x150.jpg","url":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2019\/02\/bio_pic-150x150.jpg","contentUrl":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2019\/02\/bio_pic-150x150.jpg","caption":"Shivika Tomar"},"description":"Shivika Tomar is a passionate PHP developer. Her area of interest is website development. She loves to bring healing to stressful and sad peoples.","url":"https:\/\/www.knowband.com\/blog\/author\/stomar\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/posts\/24848","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/comments?post=24848"}],"version-history":[{"count":1,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/posts\/24848\/revisions"}],"predecessor-version":[{"id":24849,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/posts\/24848\/revisions\/24849"}],"wp:attachment":[{"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/media?parent=24848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/categories?post=24848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/tags?post=24848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}