Search Result Sorting
-
Hello,
Is there any idea on why is my search result is not sorted correctly?
https://ibb.co/FbMQSHxThe result I want must be from the lowest size and alphabet. But, as you see on the image, products that I have, has multiple sizes that when I search for it the size is displayed in a wrong sorting (7,8,6) while it must be (6,7,8).
How do I resolve this issue?
Cheers,
SlimThe page I need help with: [log in to see the link]
Viewing 7 replies - 1 through 7 (of 7 total)
-
Hi @slimmz
The site is inaccessible due to maintenance mode but thanks for sharing the screenshot.
It seems that the product name is being treated as a string so the numbers within it are being treated as characters are not numbers, as a result they are not sorted as expected. You can test whether putting the number in the first position yields different results, for example
7" TANG KOMBINASI...Thanks for reaching out @margaretwporg
Yes, it is in maintenance mode.
I tried to rename 2 products that have size on them, but it won’t move the product anywhere good. It just stays where they were.
Take a look:
https://ibb.co/gWc4fVVIf you nee me to unlock the site for you so maybe you can inspect more, you can ask
Hi @slimmz
Thanks for checking that.
In order for us to get a better idea of your setup, could you please share a copy of your site’s System Status?
You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
### WordPress Environment ### WordPress address (URL): https://www.ptpasonline.com Site address (URL): https://www.ptpasonline.com WC Version: 6.0.0 REST API Version: ✔ 6.0.0 WC Blocks Version: ✔ 6.3.3 Action Scheduler Version: ✔ 3.4.0 WC Admin Version: ✔ 2.9.4 Log Directory Writable: ✔ WP Version: 5.8.2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.27 PHP Post Max Size: 128 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.32-MariaDB-cll-lve Max Upload Size: 128 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ❌ wp_remote_get() failed. Contact your hosting provider. ### Database ### WC Database Version: 6.0.0 WC Database Prefix: wpvt_ Total Database Size: 377.93MB Database Data Size: 260.78MB Database Index Size: 117.15MB wpvt_woocommerce_sessions: Data: 3.92MB + Index: 0.16MB + Engine MyISAM wpvt_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpvt_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpvt_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.05MB + Engine MyISAM wpvt_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpvt_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_actionscheduler_actions: Data: 0.23MB + Index: 0.09MB + Engine MyISAM wpstg0_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpstg0_actionscheduler_logs: Data: 0.11MB + Index: 0.09MB + Engine MyISAM wpstg0_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_comments: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpstg0_ewwwio_images: Data: 13.97MB + Index: 8.36MB + Engine MyISAM wpstg0_ewwwio_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_e_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_e_submissions_actions_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_e_submissions_values: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_fbv_attachment_folder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_getpaid_invoices: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpstg0_getpaid_invoice_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_import_postID: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_jet_post_types: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_jet_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_litespeed_img_optm: Data: 0.24MB + Index: 0.09MB + Engine MyISAM wpstg0_litespeed_img_optming: Data: 0.39MB + Index: 0.09MB + Engine MyISAM wpstg0_mclean_refs: Data: 0.19MB + Index: 0.08MB + Engine MyISAM wpstg0_mclean_scan: Data: 0.19MB + Index: 0.06MB + Engine MyISAM wpstg0_nextend2_image_storage: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wpstg0_nextend2_section_storage: Data: 0.05MB + Index: 0.01MB + Engine MyISAM wpstg0_nextend2_smartslider3_generators: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_nextend2_smartslider3_sliders: Data: 0.03MB + Index: 0.00MB + Engine MyISAM wpstg0_nextend2_smartslider3_sliders_xref: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.01MB + Engine MyISAM wpstg0_options: Data: 5.30MB + Index: 0.21MB + Engine MyISAM wpstg0_postmeta: Data: 82.77MB + Index: 47.59MB + Engine MyISAM wpstg0_posts: Data: 6.24MB + Index: 2.36MB + Engine MyISAM wpstg0_rank_math_404_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpstg0_rank_math_analytics_gsc: Data: 0.07MB + Index: 0.08MB + Engine MyISAM wpstg0_rank_math_analytics_objects: Data: 1.39MB + Index: 0.74MB + Engine MyISAM wpstg0_rank_math_internal_links: Data: 0.04MB + Index: 0.01MB + Engine MyISAM wpstg0_rank_math_internal_meta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpstg0_rank_math_redirections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_rank_math_redirections_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_realmedialibrary: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_realmedialibrary_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_realmedialibrary_posts: Data: 0.05MB + Index: 0.10MB + Engine MyISAM wpstg0_realmedialibrary_tmp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_termmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM wpstg0_terms: Data: 0.01MB + Index: 0.03MB + Engine MyISAM wpstg0_term_relationships: Data: 0.77MB + Index: 1.85MB + Engine MyISAM wpstg0_term_taxonomy: Data: 0.06MB + Index: 0.01MB + Engine MyISAM wpstg0_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_trp_gettext_id_id: Data: 0.53MB + Index: 0.63MB + Engine MyISAM wpstg0_trp_original_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_trp_original_strings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_usermeta: Data: 0.17MB + Index: 0.11MB + Engine MyISAM wpstg0_users: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpstg0_uwp_social_profiles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpstg0_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpstg0_wc_cancel_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpstg0_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wc_order_product_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wpstg0_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpstg0_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wc_product_meta_lookup: Data: 1.04MB + Index: 1.52MB + Engine MyISAM wpstg0_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpstg0_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wdr_order_discounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wdr_order_item_discounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wdr_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wfpklist_template_data: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpstg0_wgm_icons: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wgm_markers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.04MB + Engine MyISAM wpstg0_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpstg0_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_sessions: Data: 2.07MB + Index: 0.08MB + Engine MyISAM wpstg0_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpstg0_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_woof_query_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wpforms_tasks_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpstg0_wpinv_subscriptions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpmailsmtp_tasks_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpstg0_wpml_mails: Data: 7.65MB + Index: 0.01MB + Engine MyISAM wpstg0_wtbp_tables: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wt_iew_action_history: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpstg0_wt_iew_cron: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wt_iew_ftp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_wt_iew_mapping_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_yith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpstg0_zbscrm_api_keys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_admlog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_aka: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_zbs_companies: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpstg0_zbs_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_zbs_customfields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_zbs_dbmigration_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_zbs_dbmigration_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpstg0_zbs_events: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpstg0_zbs_event_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_externalsources: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_zbs_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_zbs_invoices: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wpstg0_zbs_lineitems: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_zbs_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_zbs_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_object_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_zbs_quotes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wpstg0_zbs_quotes_templates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_zbs_security_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_segments_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_zbs_sys_cronmanagerlogs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_sys_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_sys_email_hist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_zbs_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_tags_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_zbs_tax_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_temphash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_zbs_transactions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB wpvt_actionscheduler_actions: Data: 0.23MB + Index: 0.09MB + Engine MyISAM wpvt_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpvt_actionscheduler_logs: Data: 0.11MB + Index: 0.09MB + Engine MyISAM wpvt_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_comments: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpvt_ewwwio_images: Data: 13.97MB + Index: 4.87MB + Engine MyISAM wpvt_ewwwio_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_e_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_e_submissions_actions_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_e_submissions_values: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpvt_fbv_attachment_folder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_getpaid_invoices: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpvt_getpaid_invoice_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_import_postID: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_jet_post_types: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_jet_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_litespeed_img_optm: Data: 0.24MB + Index: 0.09MB + Engine MyISAM wpvt_litespeed_img_optming: Data: 0.39MB + Index: 0.09MB + Engine MyISAM wpvt_mclean_refs: Data: 0.19MB + Index: 0.08MB + Engine MyISAM wpvt_mclean_scan: Data: 0.19MB + Index: 0.04MB + Engine MyISAM wpvt_nextend2_image_storage: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wpvt_nextend2_section_storage: Data: 0.10MB + Index: 0.01MB + Engine MyISAM wpvt_nextend2_smartslider3_generators: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_nextend2_smartslider3_sliders: Data: 0.03MB + Index: 0.00MB + Engine MyISAM wpvt_nextend2_smartslider3_sliders_xref: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.01MB + Engine MyISAM wpvt_options: Data: 8.95MB + Index: 0.67MB + Engine MyISAM wpvt_postmeta: Data: 83.25MB + Index: 37.62MB + Engine MyISAM wpvt_posts: Data: 6.44MB + Index: 1.92MB + Engine MyISAM wpvt_rank_math_404_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpvt_rank_math_analytics_gsc: Data: 0.07MB + Index: 0.08MB + Engine MyISAM wpvt_rank_math_analytics_objects: Data: 1.45MB + Index: 0.67MB + Engine MyISAM wpvt_rank_math_internal_links: Data: 0.10MB + Index: 0.02MB + Engine MyISAM wpvt_rank_math_internal_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpvt_rank_math_redirections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_rank_math_redirections_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_realmedialibrary: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_realmedialibrary_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_realmedialibrary_posts: Data: 0.05MB + Index: 0.10MB + Engine MyISAM wpvt_realmedialibrary_tmp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_termmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM wpvt_terms: Data: 0.01MB + Index: 0.03MB + Engine MyISAM wpvt_term_relationships: Data: 0.84MB + Index: 1.66MB + Engine MyISAM wpvt_term_taxonomy: Data: 0.05MB + Index: 0.01MB + Engine MyISAM wpvt_tm_taskmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpvt_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_trp_gettext_id_id: Data: 0.53MB + Index: 0.83MB + Engine MyISAM wpvt_trp_original_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_trp_original_strings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_usermeta: Data: 5.39MB + Index: 0.12MB + Engine MyISAM wpvt_users: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpvt_uwp_social_profiles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpvt_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpvt_wc_cancel_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wc_customer_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wpvt_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wc_order_product_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM wpvt_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpvt_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wc_product_meta_lookup: Data: 1.06MB + Index: 1.56MB + Engine MyISAM wpvt_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wpvt_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wdr_order_discounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wdr_order_item_discounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wdr_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wfpklist_template_data: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpvt_wgm_icons: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wgm_markers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_woof_query_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wpforms_tasks_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpvt_wpinv_subscriptions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_wpmailsmtp_tasks_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpvt_wpml_mails: Data: 7.66MB + Index: 0.01MB + Engine MyISAM wpvt_wtbp_tables: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wt_iew_action_history: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wpvt_wt_iew_cron: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wt_iew_ftp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_wt_iew_mapping_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_yith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpvt_zbscrm_api_keys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_admlog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_aka: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpvt_zbs_companies: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpvt_zbs_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpvt_zbs_customfields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpvt_zbs_dbmigration_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpvt_zbs_dbmigration_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpvt_zbs_events: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpvt_zbs_event_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_externalsources: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpvt_zbs_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpvt_zbs_invoices: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wpvt_zbs_lineitems: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpvt_zbs_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpvt_zbs_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_object_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpvt_zbs_quotes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wpvt_zbs_quotes_templates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpvt_zbs_security_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_segments_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpvt_zbs_sys_cronmanagerlogs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_sys_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_sys_email_hist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpvt_zbs_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_tags_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpvt_zbs_tax_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_temphash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpvt_zbs_transactions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB ### Post Type Counts ### acf-field: 1 acf-field-group: 1 amp_validated_url: 1 attachment: 6808 b2bking_custom_role: 2 b2bking_group: 1 br_minmax_limitation: 1 bsf-sidebar: 1 clever_menu_theme: 1 ct_size_guide: 2 custom-css-js: 3 customize_changeset: 97 custom_css: 2 elementor_library: 3 erforms: 1 erforms_submission: 2 frm_form_actions: 3 frm_styles: 1 gfw_report: 4 header_builder: 2 language_switcher: 2 mailpoet_page: 1 nav_menu_item: 51 o-discount: 2 o-list: 1 oembed_cache: 4 page: 30 post: 5 product: 12020 revision: 68 sa_invoice: 1 sa_notification: 9 sa_record: 4 seedprod: 2 shop_order: 11 sliced_invoice: 1 snp_popups: 1 um_ctb: 1 um_directory: 1 um_form: 3 user_registration: 2 vc_grid_item: 5 vc_settings_preset: 2 watermark: 1 wc_product_table: 1 wpcf7_contact_form: 1 wpforms: 1 wpgmapembed: 1 wpi_invoice: 1 wpi_payment_form: 1 wpmm_theme: 3 wpt_product_table: 6 ywar_reviews: 11 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (51) ### Admin Menu Editor Pro: by Janis Elsts – 2.12.4 Allow Multiple Accounts: by Scott Reilly – 3.0.4 Astra Pro: by Brainstorm Force – 3.6.3 Astra Bulk Edit: by Brainstorm Force – 1.2.6 Astra Widgets: by Brainstorm Force – 1.2.9 Cloudflare: by Cloudflare Inc. – 4.7.0 Coming Soon Page, Maintenance Mode & Landing Pages by SeedProd: by SeedProd – 6.6.0 Contact Form 7: by Takayuki Miyoshi – 5.5.3 Customizer Search: by Brainstorm Force – 1.1.6 WooCommerce Discontinued Products: by Leon @ 211J – 1.1.5 Duplicate Page: by mndpsingh287 – 4.4.7 Elementor Pro: by Elementor.com – 3.4.1 Elementor: by Elementor.com – 3.5.3 Export Media URLs: by Atlas Gondal – 1.0 Font Awesome: by Font Awesome – 4.0.4 WP Google Map: by WP Google Map – 1.8.2 Image Widget: by Modern Tribe Inc. – 4.4.7 WPBakery Page Builder: by Michael M - WPBakery.com – 6.6.0 Max Mega Menu - Pro Addon: by megamenu.com – 2.2.3 Max Mega Menu: by megamenu.com – 2.9.5 Order Export for WooCommerce: by JEM Plugins – 3.2 Perfect Brands for WooCommerce: by QuadLayers – 2.0.2 Privileged Menu: by <a href="http://www.fuzzguard.com.au/"><strong>Benjamin Guy</strong></a> – 1.8.4 Privilege Widget: by <a href="http://www.fuzzguard.com.au/"><strong>Benjamin Guy</strong></a> – 1.7.3 Product CSV Import Export (BASIC): by WebToffee – 2.1.3 woo-inquire-us-and-disable-add-to-cart-button: by themelocation – 1.4.2 Rank Math SEO: by Rank Math – 1.0.79 Sidebar Manager: by Brainstorm Force – 1.1.7 TaxoPress: by TaxoPress – 3.4.3 Smart Slider 3: by Nextend – 3.5.1.2 Tidio Chat: by Tidio Ltd. – 4.5.1 WooCommerce Tiered Price Table: by bycrik – 2.6.0 Ultimate Carousel For WPBakery Page Builder: by Nasir – 2.6 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.16.69 Use Any Font: by Dnesscarkey – 6.1.8 User Role Editor: by Vladimir Garagulya – 4.61 WC Cancel Order: by Vikram S – 3.1.2 Quantity Plus Minus Button for WooCommerce: by CodeAstrology – 1.0.9 Widget Options: by Widget Options Team – 3.7.9 Min Max Quantity & Step Control for WooCommerce: by CodeAstrology – 2.1.0 WOO Product Table Pro: by CodeAstrology – 8.0.0 Product Table for WooCommerce - (wooproducttable): by CodeAstrology – 3.0.8 WOOF - WooCommerce Products Filter: by realmag777 – 2.2.3 WooCommerce: by Automattic – 6.0.0 WP Mail Logging: by Wysija – 1.10.2 WP Mail SMTP: by WPForms – 3.2.1 WP STAGING: by WP-STAGING – 2.9.2 WPForms Lite: by WPForms – 1.7.1.2 WR In Stock Alert: by WooRockets – 1.0.8 WR Live Search: by WooRockets – 1.0.10 YellowPencil: by WaspThemes – 7.5.4 ### Inactive Plugins (0) ### ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Must Use Plugins (1) ### WP STAGING Optimizer: by René Hermenau – 1.5.1 ### Settings ### API Enabled: ✔ Force SSL: – Currency: IDR (Rp) Currency Position: left Thousand Separator: . Decimal Separator: , Number of Decimals: 0 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) instock (instock) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: – ### WC Pages ### Shop base: #4899 - /shop/ Cart: ❌ Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block. Checkout: #12 - /checkout/ My account: #6236 - /account/ Terms and conditions: ❌ Page not set ### Theme ### Name: Astra Version: 3.7.6 Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ ### Templates ### Overrides: – ### Action Scheduler ### Complete: 312 Oldest: 2021-12-19 15:03:53 +0800 Newest: 2022-01-04 09:53:25 +0800 Pending: 7 Oldest: 2022-01-04 19:17:50 +0800 Newest: 2022-02-02 08:01:38 +0800 ### Status report information ### Generated at: 2022-01-04 18:39:13 +08:00Here it is
Hi @slimmz,
Thanks for your system status.
What terms are you using to search for those products? It appears that the search results are based on relevance and are sorted according to the order in which you entered the products in the backend.
These are the results when searching for “Product Sample” and it appears to be the same sorting as they are listed in the backend.
If you want more control over the search results I can recommend these extensions:
– https://woocommerce.com/products/woocommerce-product-search/
– https://woocommerce.com/products/ajax-instant-search/
– https://woocommerce.com/products/product-finder/There is a 30-day money back guarantee if you are unhappy with the products. More info on our refund policy can be found here: https://woocommerce.com/refund-policy/.
Thanks.
Thanks @rainfallnixfig
From those 3 extensions, can i achieve my purpose? i think the first option caught my attention
Can i put the search to my site header?
Hi @slimmz,
On this forum we only provide support for the WooCommerce core plugin, so you may want to contact us with your pre-sales questions via https://woocommerce.com/contact-us/#sales-form.
As the extensions are sold on the WooCommerce.com marketplace, you can make the most out of the WooCommerce.com 30-day refund policy to try them first. If you find the extensions don’t do what you want, you can get a full refund.
Thanks.
Viewing 7 replies - 1 through 7 (of 7 total)
The topic ‘Search Result Sorting’ is closed to new replies.
