I’ve been using this awesome WooCommerce plugin since last few projects, worked flawlessly.
But suddenly in my current project I’ve been stuck at a point for which I cant find any solution, let me explain:
I am making a site for loose diamonds & it uses CARAT(s) as its weight unit. Now the problem is I can easily store all values in database, the values are in decimal form, for ex.: 1.5, 2.44, 3.67, etc, etc.
I am also using a plug-in: http://codecanyon.net/item/woocommerce-ajax-product-filter-wordpress-plugin/4640387
This plugin allows me to create a slider for the Weight, so the user can easily choose the desired weight & make a search.
But when I used it & came to know I cannot use the precision to decimal numbers! I asked the developer of the plugin & he replied mentioning that it is a limitation of WooCommerce & WordPress! Here’s what he wrote:
“There is limitation at WordPress Query to filter by decimal numbers, Because WordPress uses longtext data type to store post meta values and casting data as float will cut down numbers.”
Please can anyone out there help me out as the whole project is finished & I’m only stuck at this weight filtering.
Your help will be really greatly appreciated. Please shed some light on the issue.
Am looking forward for responses! 🙂
Thanks in advance!
- The topic ‘WooCommerce search query in decimal format.’ is closed to new replies.