[Résolu] order the results that the View gets not working

[Auteur]

Publications

[davidZ-4]

I am trying to: get a descending order of results based on a custom field value

Link to a page where the issue can be seen: lien caché

I expected to see: the products with the high score (custom filed as number) show in descending order

Instead, I got: products with no score at all showing in the results while other products that have higher score not showing.

the view is limited to five results

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - to check why ordering is not working on your install, I need to check your view's configurations and need to check what query build by view for that I need access to your 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.

[Minesh]

Sorry - I'm bit confuse here with your actual requirements.

I tried to check with following URL to display products with price less than 500 and its displaying and filtering the products correctly.
=> lien caché

Am I missing something here?

[davidZ-4]

Hi Minesh,

please try with lien caché
you will see 2 products not order in the right order
if you try lien caché
you should see 5 products but only 2 are in display
look at the woo commerce product list and see that there are 5 simple products under $10000
you can take a look at lien caché for all the grouped and simple products

Thanks,

David

[davidZ-4]

also, if you go to lien caché
you should see the top 5 products by score but only 2 are showing.

Thanks,

David

[Minesh]

also, if you go to lien caché
you should see the top 5 products by score but only 2 are showing.
==> Well - this is happening because we added view's filter to show "simple" products. Could you please tell me when you want to display only "simple" products?

[davidZ-4]

Hi Minesh,
yes, these are simple products. however there are other simple products n the store that don't show in the view for some reason.
see enclose screenshot products filter by type = simple in the woocommerce product list

on this page lien caché with the view in it i want to display only simple products.

Thanks,

David

[Luo Yang]

Dear David,

I have modified the view "test bootstrap table", in section "Ordering" change it to order by custom field "bike-score".
It should be same slug as the custom field "Bike Score" setting:
lien caché

Please check if it is fixed or not, thanks

[davidZ-4]

Thanks Luo.
It solved the issue 🙂 !

Just one more question.
For some reason I selected the field "bicycle-score" instead of "bike-score" in the view Ordering section.
When I check the "Post Field Control" I see that bicycle-score is not managed with Toolset and I'm not sure if this is something I created using Toolset or if its coming form a plugin.
The full slug is 'wpcf-bicycle-score' so I believe its a Toolset custom filed, created then deleted from the "Post fields" section and it stay in the DB. I guess that to fully remove it from the DB I need to "Manage with Types" then delete it.

Am I correct?

David

[Luo Yang]

Yes, you are correct, you can manage it with Types plugin then remove it.

[davidZ-4]

Thanks Luo.