{"id":537,"date":"2021-01-26T08:09:12","date_gmt":"2021-01-26T08:09:12","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/?p=537"},"modified":"2022-12-27T13:13:20","modified_gmt":"2022-12-27T13:13:20","slug":"how-to-create-a-product-table-with-custom-query","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/how-to-create-a-product-table-with-custom-query\/","title":{"rendered":"How to create a product table with custom query in WooCommerce?"},"content":{"rendered":"\r\n<p>Product table with custom query is an ideal way to manage and control the specific features of your tables in an online shopping store.&nbsp;<\/p>\r\n\r\n\r\n\r\n<p>Would you like a simple way to create sortable, filterable and scalable WooCommerce Product Tables?&nbsp;<\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-product-table\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">WooCommerce Product Table plugin<\/span><\/a> is exactly what you need.<\/p>\r\n\r\n\r\n\r\n<p>In the &#8220;<strong>Query<\/strong>&#8221; section of this plugin, you can display products with a specific&nbsp;<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Category,&nbsp;<\/li>\r\n\r\n\r\n\r\n<li>Tag,&nbsp;<\/li>\r\n\r\n\r\n\r\n<li>Custom Taxonomy Term,&nbsp;<\/li>\r\n\r\n\r\n\r\n<li>Featured Product<\/li>\r\n\r\n\r\n\r\n<li>On-Sale<\/li>\r\n\r\n\r\n\r\n<li>Based on Stock Status<\/li>\r\n\r\n\r\n\r\n<li>Many more.&nbsp;<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p>The more scalable your WooCommerce store is,&nbsp;The more you can retain customers on your WooCommerce site.<\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p>In this tutorial, we will go through how to create custom product tables using WooCommerce Product Table plugin.<\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-query-tab-in-woocommerce-product-table-plugin\">Query tab in WooCommerce product table plugin<\/h2>\r\n\r\n\r\n\r\n<p>there are many fields to set and make your custom query in WooCommerce product table plugin. here is the fields you can set on query tab:<\/p>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-custom-query-by-woocommerce-product-id\"><strong>Custom Query by WooCommerce Product ID <\/strong><\/h3>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/1-choose-product-id.jpg\"><img fetchpriority=\"high\" decoding=\"async\" width=\"864\" height=\"354\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/1-choose-product-id.jpg\" alt=\"select products by ID to show in product table\" class=\"wp-image-539\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<p>You can choose to show products with a certain ID. All you need to do is to find a product\u2019s Title to rollover the product, and you will see each product&#8217;s title. <\/p>\r\n\r\n\r\n\r\n<p>Now you can choose which ID\u2019s you want to be shown in the product table.<\/p>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-custom-query-by-woocommerce-category\"><strong>Custom Query by WooCommerce Category<\/strong><\/h3>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/2-choose-product-category.jpg\"><img decoding=\"async\" width=\"808\" height=\"484\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/2-choose-product-category.jpg\" alt=\"select products by category to show in product table\" class=\"wp-image-540\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<p>Product categories are the primary way to group products with similar features. You can also add subcategories if desired. You can select the categories you want to show in the table using the query builder.<\/p>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-custom-query-by-woocommerce-tags\"><strong><strong>Custom Query by <\/strong>WooCommerce Tags<\/strong><\/h3>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/3-choose-product-tag.jpg\"><img decoding=\"async\" width=\"818\" height=\"439\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/3-choose-product-tag.jpg\" alt=\"select products by tag to show in product table\" class=\"wp-image-541\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<p>The tag option lets you display products based on their tags. Use the tag slug or the ID \u2013 you can find this in WordPress within the <strong>Products &gt; Tags<\/strong> section. You can choose several different tags to show in your custom product table.<\/p>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-custom-query-by-woocommerce-custom-taxonomy\"><strong>Custom Query by WooCommerce Custom taxonomy<\/strong><\/h3>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/4-choose-custom-taxonomy.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"807\" height=\"422\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/4-choose-custom-taxonomy.jpg\" alt=\"select products by custom taxonomies\" class=\"wp-image-542\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<p>WooCommerce custom taxonomies (taxonomies) are used to store arbitrary, one-off information about a product. A custom taxonomy is for grouping things together. <\/p>\r\n\r\n\r\n\r\n<p>By choosing to show products of certain taxonomies, you can better manage and organize your ecommerce website.<\/p>\r\n\r\n\r\n\r\n<p>For example Brand taxonomy that sorting the products based on their brand can help customers find their desired product easier. WooCommerce product table plugin support brand taxonomy and you can show it as a column on your table.<\/p>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-display-featured-products\"><strong>Display featured products<\/strong><\/h3>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/5-choose-product-status-feature.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"858\" height=\"257\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/5-choose-product-status-feature.jpg\" alt=\"display feature products only\" class=\"wp-image-543\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<p>Featured products are a great way to promote specific items on your website and are easy to setup in WooCommerce. <\/p>\r\n\r\n\r\n\r\n<p>To create featured products you have to mark them \u2018Featured\u2019 on the <strong>Add\/Edit<\/strong> Product screen. And you can choose to include \/ exclude these products in the query builder.&nbsp;<\/p>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-display-on-sale-products-display-only-in-stock-products\"><strong>Display on-Sale products \/ display only in-stock products<\/strong><\/h3>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/6-choose-product-status-onsale-stock.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"848\" height=\"255\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/6-choose-product-status-onsale-stock.jpg\" alt=\"display on sale or in stock products only\" class=\"wp-image-544\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<p>You can choose to show\/ hide on-sale products or only show products that are in stock. This helps customers navigate through products easily and saves their time, which means they will come back to your website again for future purchases.<\/p>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-custom-query-by-minimum-maximum-price\"><strong>Custom Query by Minimum &amp; maximum Price<\/strong><\/h3>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/7-choose-set-price.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"849\" height=\"313\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/7-choose-set-price.jpg\" alt=\"display products with minimum and maximum price\" class=\"wp-image-545\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<p>You can set a limit in the query builder, so that products with their price in a certain range are shown in the product table. This will allow the customers to find products according to their budget.&nbsp;&nbsp;<\/p>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-custom-query-by-product-attributes-such-as-color-size-and-etc\"><strong>Custom Query by Product attributes such as color, size and etc<\/strong><\/h3>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/8-choose-product-variation.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"817\" height=\"562\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/8-choose-product-variation.jpg\" alt=\"select custom variation of variable products\" class=\"wp-image-538\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<p>Furthermore, to create a custom product table you can also choose to exclude products with certain features (rather than including them).<\/p>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\" id=\"h-sort-custom-query-by-order\"><strong>Sort Custom Query by Order<\/strong><\/h3>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/9-order-by.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"824\" height=\"415\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/9-order-by.jpg\" alt=\"set product table order\" class=\"wp-image-552\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<p>Sort displayed products as ascending or descending based on some popular wooCommerce fields such as: ID, Title, Price, Date, SKU and etc. <\/p>\r\n\r\n\r\n\r\n<p>As you can see, creating custom product tables in WooCommerce Product Table plugin doesn\u2019t need any previous knowledge of coding, and with the simple and user-friendly interface of this plugin you can easily create tables based on your website\u2019s requirements in the &#8220;<strong>Query&#8221; <\/strong>section.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/8-choose-product-variation.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"817\" height=\"562\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-content\/uploads\/sites\/3\/2021\/01\/8-choose-product-variation.jpg\" alt=\"WooCommerce product table query section to make custom product table\" class=\"wp-image-538\"\/><\/a><\/figure>\r\n\r\n\r\n\r\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\"><strong>Conclusion<\/strong><\/h2>\r\n\r\n\r\n\r\n<p>Using WooCommerce Product Table plugin is the best choice for professional store managers. So many options are available in different sections of this plugin to help you customize your product table.<\/p>\r\n\r\n\r\n\r\n<p>Query is one of the useful options in the plugin which enable you to build any custom product table including different features.<\/p>\r\n\r\n\r\n\r\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\r\n<p>Customize your product table and attract more customers by WooCommerce Product Table plugin<\/p>\r\n<\/blockquote>\r\n\r\n\r\n\r\n<p>In addition to the mentioned options, a lot of more features are designed to fulfill any requirements of your ecommerce website. To discover more, just start a <a href=\"https:\/\/demo.ithemelandco.com\/woocommerce-bulk-product-editing\/\" target=\"_blank\" rel=\"noreferrer noopener\">live preview<\/a>.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Product table with custom query is an ideal way to manage and control the specific features of your tables in an online shopping store.&nbsp; Would you like a simple way to create sortable, filterable and scalable WooCommerce Product Tables?&nbsp; WooCommerce Product Table plugin is exactly what you need. In the &#8220;Query&#8221; section of this plugin, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-537","post","type-post","status-publish","format-standard","hentry","category-plugin-usage"],"_links":{"self":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/posts\/537"}],"collection":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/comments?post=537"}],"version-history":[{"count":9,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/posts\/537\/revisions"}],"predecessor-version":[{"id":1376,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/posts\/537\/revisions\/1376"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/media?parent=537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/categories?post=537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-product-table\/wp-json\/wp\/v2\/tags?post=537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}