[Skip to main content](#vessel-content) # Filter product by height, length and width. ## - **[The Wheaten Terrier](/forum/user/67902-the-wheaten-terrier "View The Wheaten Terrier's Profile")** - [![The Wheaten Terrier's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/67902-the-wheaten-terrier "View The Wheaten Terrier's Profile") Topic Author - [ Offline](/forum/user/67902-the-wheaten-terrier) - I'm trying my best! Less More - Posts: 14 - Thank you received: 1 - - - 5 months 3 weeks ago [\#371900](#371900) by [The Wheaten Terrier](/forum/user/67902-the-wheaten-terrier "View The Wheaten Terrier's Profile") *[Filter product by height, length and width.](/forum/45-filters-search/910518-filter-product-by-height-length-and-width#371900 "Hello, I thought this would be really easy but I can't get it to work. I want customers to be able to filter products by their height, length or width using the data from the product information, the fields just after the weight field on the backend product listing. I tried creating a custom field label height and sql query: select product_height from josii_hikashop_product Along with numerous variations but nothing works. I tried creating a new filter > Single drop down > Product Information > Height but this does nothing either. Suggestions gratefully received. Thanks!")* was created by *[The Wheaten Terrier](/forum/user/67902-the-wheaten-terrier "View The Wheaten Terrier's Profile")* Hello, I thought this would be really easy but I can't get it to work. I want customers to be able to filter products by their height, length or width using the data from the product information, the fields just after the weight field on the backend product listing. I tried creating a custom field label height and sql query: select product_height from josii_hikashop_product Along with numerous variations but nothing works. I tried creating a new filter > Single drop down > Product Information > Height but this does nothing either. Suggestions gratefully received. Thanks! --- Tolerence costs nothing. Intolerance is intolerable! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkxMDUxOC1maWx0ZXItcHJvZHVjdC1ieS1oZWlnaHQtbGVuZ3RoLWFuZC13aWR0aD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 5 months 3 weeks ago [\#371903](#371903) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Filter product by height, length and width.](/forum/45-filters-search/910518-filter-product-by-height-length-and-width#371903 "Hello, I thought this would be really easy but I can't get it to work. I want customers to be able to filter products by their height, length or width using the data from the product information, the fields just after the weight field on the backend product listing. I tried creating a custom field label height and sql query: select product_height from josii_hikashop_product Along with numerous variations but nothing works. I tried creating a new filter > Single drop down > Product Information > Height but this does nothing either. Suggestions gratefully received. Thanks!")* Hi, The right combination for this is: - Filter data: Product information - Information: Height (or Length, or Width) - Filter type: Cursor (the slider with two handles), not Single dropdown The cursor filter auto-detects the min and max value from your catalogue's product_height / product_length / product_width columns and lets the customer drag the two handles to narrow the range. The SQL it generates is a simple BETWEEN on the corresponding product column. The Single dropdown filter would have worked too but it expects you to predefine the ranges manually (for example 0-10 / 10-20 / 20-30), which is why nothing showed up when you tried it: with no ranges configured, the dropdown has no options to display. You do not need a custom field for any of this. Height, Length and Width are core columns on the product table, and the Product information filter data reads them directly. Custom fields are for adding new columns to your products that do not already exist; using them to mirror an existing core column would create a duplicate that does not auto-populate. As a bonus, the same Product information filter also has Surface and Volume options that compute width * length and width * length * height on the fly, so you can offer those as filters too if it makes sense for your catalogue. The following user(s) said Thank You: [The Wheaten Terrier](/forum/user/67902-the-wheaten-terrier "View The Wheaten Terrier's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkxMDUxOC1maWx0ZXItcHJvZHVjdC1ieS1oZWlnaHQtbGVuZ3RoLWFuZC13aWR0aD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.040 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)