i set the results to be in Products ordered by Field - views_woo_price, descending hidden link hidden link
shouldnt the results be in price descending order ?
*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.
I would additionally need your permission to de- and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important. If you agree to this, please use the form fields I have enabled below to provide temporary access details (wp-admin and FTP).
I have set the next reply to private which means only you and I have access to it.
Well - thank you for sharing access details but when I check the product with each product the views_woo_price is set as this text "Καλέστε για Τιμές".
Please check the following screenshot:
=> hidden link
Can you please confirm that the views_woo_price field has a numeric value first as I checked the query and query is correctly generated:
SELECT elA_posts.* FROM elA_posts INNER JOIN elA_postmeta ON ( elA_posts.ID = elA_postmeta.post_id ) WHERE 1=1 AND elA_posts.ID NOT IN (1151) AND ( ( elA_posts.post_title LIKE '{3e95cf4ba33675a3ad517efe7b5b5ead6dcca378803e94ce8fbda31dc7271069}WESTLAKE{3e95cf4ba33675a3ad517efe7b5b5ead6dcca378803e94ce8fbda31dc7271069}' ) ) AND (
elA_postmeta.meta_key = 'views_woo_price'
) AND elA_posts.post_type = 'product' AND ((elA_posts.post_status = 'publish' OR elA_posts.post_status = 'private')) GROUP BY elA_posts.ID ORDER BY elA_postmeta.meta_value+0 DESC
i really need to speed up the solution, your moto is Custom WordPress Development For Non-Coders, but this is not so true. To achieve a good working result i reallize i must pay for development.
Is there a solution for premium support to have solutions from your support team faster?
I tried once to get an offer from a contractor but it was way to expensive, could you finalize this at a per hour price?
Well - Can I perform few checks as it looks like due to the text added to the views_woo_price field the ordering is not working.
I change the order to with regular price DESC and I can see the sorting works correctly. That means the "views_woo_price" field must hold the numeric value in order to display the correct results.
As you can see with the following link results are displayed in correct sort order:
=> hidden link
What you need to do is - Go to:
=> Toolset => Settings => Front-end content => Hidden custom fields section => Click on button "Select custom fields" and find and checkmark the regular price field
Then go to your view, reload your view, if already open, and then regular price field will be available to display.
Can you please share problem URL and access details of your live site so I can check. Also, add what view you are using on live site.
*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.
I would additionally need your permission to de- and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important. If you agree to this, please use the form fields I have enabled below to provide temporary access details (wp-admin and FTP).
I have set the next reply to private which means only you and I have access to it.
