Sorting based on Product average rating is incorrect in product page
-
Hi team, we are using your plugin
In product page, Sorting based on Product average rating is showing as incorrect. The rating based sorting don’t showing any effect. Can you please tell why?
Please reply as soon as possible
-
Hello @albyse,
No worries, we’ll help you figure it out. ??
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.
Look forward to hearing back from you.
Hi,
### WordPress Environment ### WordPress address (URL): https://lockmyseat.com/NGSale Site address (URL): https://lockmyseat.com/NGSale WC Version: 6.9.4 REST API Version: ? 6.9.4 WC Blocks Version: ? 8.3.3 Action Scheduler Version: ? 3.4.0 Log Directory Writable: ? WP Version: 6.1.1 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.33 PHP Post Max Size: 20 MB PHP Time Limit: 60 PHP Max Input Vars: 1000 cURL Version: 7.71.0 OpenSSL/1.1.1p SUHOSIN Installed: – MySQL Version: 5.7.40-cll-lve Max Upload Size: 20 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 5.7.2 WC Database Prefix: ngl_ Total Database Size: 59.33MB Database Data Size: 38.54MB Database Index Size: 20.79MB ngl_woocommerce_sessions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB ngl_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_woocommerce_order_items: Data: 0.22MB + Index: 0.08MB + Engine InnoDB ngl_woocommerce_order_itemmeta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB ngl_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_acfw_store_credits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_actionscheduler_actions: Data: 2.02MB + Index: 1.02MB + Engine InnoDB ngl_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_actionscheduler_logs: Data: 1.03MB + Index: 0.53MB + Engine InnoDB ngl_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_comments: Data: 0.41MB + Index: 0.44MB + Engine InnoDB ngl_EWD_OTP_Customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_EWD_OTP_Fields_Meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_EWD_OTP_Orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_EWD_OTP_Order_Statuses: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_EWD_OTP_Sales_Reps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB ngl_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_ig_actions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB ngl_ig_blocked_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_campaigns: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_ig_contactmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_ig_contacts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_ig_contacts_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_ig_contact_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_ig_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_ig_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_lists_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_ig_mailing_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_ig_queue: Data: 0.02MB + Index: 0.13MB + Engine InnoDB ngl_ig_sending_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_temp_import: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_unsubscribe_feedback: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_wc_cart: Data: 0.02MB + Index: 0.08MB + Engine InnoDB ngl_ig_wc_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_ig_workflows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_workflows_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_login_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_lws_wr_achieved_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_lws_wr_historic: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB ngl_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB ngl_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB ngl_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_myCRED_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_nextend2_smartslider3_sliders: Data: 0.05MB + Index: 0.03MB + Engine InnoDB ngl_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB ngl_nrp_accounts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_nrp_points_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_options: Data: 7.47MB + Index: 0.34MB + Engine InnoDB ngl_pantheon_sessions: Data: 0.05MB + Index: 0.03MB + Engine InnoDB ngl_pincode_checker: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_pmpro_memberships_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_pmpro_memberships_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB ngl_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_pmpro_membership_levels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_pmpro_membership_ordermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_pmpro_membership_orders: Data: 0.05MB + Index: 0.20MB + Engine InnoDB ngl_postmeta: Data: 14.48MB + Index: 9.81MB + Engine InnoDB ngl_posts: Data: 2.45MB + Index: 0.58MB + Engine InnoDB ngl_products_to_publish: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_product_restrictions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_termmeta: Data: 0.08MB + Index: 0.09MB + Engine InnoDB ngl_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_term_relationships: Data: 0.06MB + Index: 0.02MB + Engine InnoDB ngl_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_trackship_shipment: Data: 0.02MB + Index: 0.13MB + Engine InnoDB ngl_trackship_shipment_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_trackship_shipping_provider: Data: 0.08MB + Index: 0.00MB + Engine InnoDB ngl_type_restrictions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_usermeta: Data: 0.17MB + Index: 0.14MB + Engine InnoDB ngl_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB ngl_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB ngl_wc_cancel_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wc_order_product_lookup: Data: 0.19MB + Index: 0.19MB + Engine InnoDB ngl_wc_order_stats: Data: 0.14MB + Index: 0.14MB + Engine InnoDB ngl_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB ngl_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wdr_order_item_discounts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_woo_shippment_provider: Data: 0.09MB + Index: 0.00MB + Engine InnoDB ngl_wotv_woo_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wpf_meta_data: Data: 0.08MB + Index: 0.23MB + Engine InnoDB ngl_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wpf_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wpf_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wpf_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yasr_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yasr_log_multi_set: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yasr_multi_set: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yasr_multi_set_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yith_vendors_commissions: Data: 0.16MB + Index: 0.00MB + Engine InnoDB ngl_yith_vendors_commissions_notes: Data: 0.13MB + Index: 0.00MB + Engine InnoDB ngl_yith_vendors_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_vendors_payments_relationship: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wapo_addons: Data: 0.42MB + Index: 0.00MB + Engine InnoDB ngl_yith_wapo_blocks: Data: 0.06MB + Index: 0.00MB + Engine InnoDB ngl_yith_wapo_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_booking_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_external_bookings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_zorem_email_sms_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB ### Post Type Counts ### acf-field: 110 acf-field-group: 9 attachment: 1229 br_products_of_day: 1 br_suggestion: 1 copy-to-clipboard: 1 dflip: 4 es_template: 2 footerad: 5 lws-wre-event: 4 lws-wre-pool: 1 mailpoet_page: 1 mycred_rank: 1 page: 54 popup: 2 popup_theme: 8 post: 2 product: 193 product_variation: 98 pscw-size-chart: 8 revision: 253 shop_coupon: 271 shop_order: 2067 shop_order_refund: 65 sidead: 2 size-chart: 10 sliders: 7 wpcf7_contact_form: 1 yith_booking: 335 yith_wcan_preset: 1 ywcbk-extra-cost: 1 ywcbk-person-type: 2 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (50) ### Yet Another Stars Rating: by Dario Curvino – 3.1.5 Advanced Custom Fields: Repeater Field: by Elliot Condon – 2.1.0 Address correction autocomplete for Woo: by SAHU MEDIA ? – 1.1 Advanced Custom Fields: by Delicious Brains – 5.12.2 Advanced Product Search For WooCommerce: by aThemeArt – 1.1.1 Contact Form 7 Captcha: by 247wd – 0.1.2 Contact Form 7: by Takayuki Miyoshi – 5.6.3 Email Subscribers & Newsletters: by Icegram – 5.4.16 Empty Cart Button for WooCommerce: by ProWCPlugins – 1.3.5 Gift Wrapping for WooCommerce: by Pexle Chris Theo Gkitsos – 1.1 reCaptcha by BestWebSoft: by BestWebSoft – 1.68 Innozilla Conditional Shipping and Payments for WooCommerce: by Innozilla – 1.0.1 Kadence WooCommerce Email Designer: by Kadence WP – 1.5.7 Assign Product Types & Categories to Vendors: by Admin Nextgencia – 1.0.0 Paid Memberships Pro: by Paid Memberships Pro – 2.9.5 Perzonalization - AI Powered Personalization That Sells: by Perzonalization – 1.5.6 Paid Memberships Pro - Cancel on Next Payment Date: by Paid Memberships Pro – 0.5.1 Paid Memberships Pro - Roles Add On: by Paid Memberships Pro – 1.4.1 Paid Memberships Pro - Require Strong Passwords: by Stranger Studios – 0.5.0 Points and Rewards for WooCommerce: by WP Swings – 1.3.0 PWA for WP: by Magazine3 – 1.7.51 QR Code Tag for WC order emails, POS receipt emails, PDF invoices, PDF packing slips, Blog posts, Custom post types and Pages (from goaskle.com): by Goaskle.com – 1.9.7 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 Super Socializer: by Team Heateor – 7.13.41 TrackShip for WooCommerce: by TrackShip – 1.4.5 User Posts Limit: by Condless – 1.1.5 Voice Search: by Pascal Birchler – 1.4.0 WC Cancel Order: by WpExperts Hub – 3.1.8 Quantity Plus Minus Button for WooCommerce: by CodeAstrology – 1.1.1 White Label CMS: by www.videousermanuals.com – 2.2.9 WooCommerce Address Book: by Hall Internet Marketing – 2.2.0 Advanced Shipment Tracking for WooCommerce: by zorem – 3.4.7 Digital Goods for WooCommerce Checkout: by theDotstore – 3.6.4 Return Refund and Exchange for WooCommerce: by WP Swings – 4.0.6 Thank You Page Customizer for WooCommerce: by VillaTheme – 1.0.12 Braintree for WooCommerce Payment Gateway: by WooCommerce – 2.6.5 (update to version 2.9.0 is available) PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.2.4 WooCommerce: by Automattic – 6.9.4 (update to version 7.2.0 is available) WordPress Importer: by wordpressdotorg – 0.7 WP File Manager: by mndpsingh287 – 7.1.5 WP Mail SMTP: by WPForms – 3.4.0 WP-Optimize - Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.2.7 Social Share For WooCommerce: by kuldip_raghu – 1.0.3 ReCaptcha v2 for Contact Form 7: by IQComputing – 1.4.3 YITH WooCommerce Ajax Product Filter: by YITH – 4.10.0 YITH Booking and Appointment for WooCommerce Premium: by YITH – 2.1.23 YITH WooCommerce Compare: by YITH – 2.14.0 YITH WooCommerce Multi Vendor Premium: by YITH – 3.7.8 YITH WooCommerce Product Add-ons & Extra Options: by YITH – 2.9.0 YITH WooCommerce Wishlist: by YITH – 3.12.0 ### Inactive Plugins (27) ### 3D FlipBook : Dflip Lite: by DearHive – 1.7.33 Advanced Coupons for WooCommerce Free: by Rymera Web Co – 4.5.1.1 Cancel order request for WooCommerce: by PI Websolution – 1.2.92 Category Discounts for WooCommerce: by WildProgrammers – 1.0.8 Easy Loyalty Points and Rewards for WooCommerce: by Nujo Plugins – 1.4.0 Email Verification / SMS verification / Mobile Verification: by miniOrange – 3.9.2 Gift Wrapper: by Sagehen Studio – 5.2.7 Google Listings and Ads: by WooCommerce – 1.12.8 LoginWP (Formerly Peter's Login Redirect): by LoginWP Team – 3.0.6.0 Multi Order for WooCommerce: by WP Wham – 1.5.0 myCred: by myCred – 2.4.10 MyRewards: by Long Watch Studio – 4.9.8.1 NS Product Rating for WooCommerce: by NsThemes – 1.2.4 Order Splitter for WooCommerce: by Fahad Mahmood – 4.7.7 Product Filter by WooBeWoo: by WooBeWoo – 2.2.1 Product Size Chart for WooCommerce: by VillaTheme – 1.1.1 Product Slider Carousel: by wpqode – 1.2.0 Sky Login Redirect: by Utopique – 3.6.7 Split Order for WooCommerce: by SunArc – 1.0 Super Progressive Web Apps: by SuperPWA – 2.2.8 WooCommerce Payments: by Automattic – 4.4.1 (update to version 5.1.2 is available) Woo Discount Rules: by Flycart – 2.5.2 Woo Pincode Checker: by wbcomdesigns – 1.1.0 Woo Product Category Discount: by WooExtend – 4.4 WP Crontrol: by John Blackbourn & crontributors – 1.14.0 WP Rollback: by GiveWP.com – 1.7.2 YITH WooCommerce Multi Vendor Premium: by YITH – 4.4.0 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: – Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: booking (booking) external (external) grouped (grouped) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) 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: – Enforce Approved Product Download Directories: – ### WC Pages ### Shop base: #7 - /products/ Cart: #8 - /cart/ Checkout: #9 - /checkout/ My account: #10 - /my-account/ Terms and conditions: ? Page not set ### Theme ### Name: ngtheme Version: 1.4 Author URL: https://www.ads-software.com/ 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: ngtheme/woocommerce/archive-product.php ngtheme/woocommerce/auth/footer.php ngtheme/woocommerce/auth/form-grant-access.php ngtheme/woocommerce/auth/form-login.php ngtheme/woocommerce/auth/header.php ngtheme/woocommerce/cart/cart-empty.php ngtheme/woocommerce/cart/cart-item-data.php ngtheme/woocommerce/cart/cart-shipping.php ngtheme/woocommerce/cart/cart-totals.php ngtheme/woocommerce/cart/cart.php ngtheme/woocommerce/cart/cross-sells.php ngtheme/woocommerce/cart/mini-cart.php version 3.7.0 is out of date. The core version is 5.2.0 ngtheme/woocommerce/cart/proceed-to-checkout-button.php ngtheme/woocommerce/cart/shipping-calculator.php ngtheme/woocommerce/checkout/cart-errors.php ngtheme/woocommerce/checkout/form-billing.php ngtheme/woocommerce/checkout/form-checkout.php /home/tajso9mx6bh7/public_html/NGSale/wp-content/plugins/points-and-rewards-for-woocommerce/public/woocommerce/checkout/form-coupon.php ngtheme/woocommerce/checkout/form-login.php ngtheme/woocommerce/checkout/form-pay.php version 3.4.0 is out of date. The core version is 5.2.0 ngtheme/woocommerce/checkout/form-shipping.php ngtheme/woocommerce/checkout/order-receipt.php ngtheme/woocommerce/checkout/payment-method.php ngtheme/woocommerce/checkout/payment.php ngtheme/woocommerce/checkout/review-order.php version 3.8.0 is out of date. The core version is 5.2.0 ngtheme/woocommerce/checkout/terms.php ngtheme/woocommerce/checkout/thankyou.php ngtheme/woocommerce/content-product-cat.php ngtheme/woocommerce/content-product.php ngtheme/woocommerce/content-single-product.php version - is out of date. The core version is 3.6.0 ngtheme/woocommerce/content-widget-price-filter.php ngtheme/woocommerce/content-widget-product.php ngtheme/woocommerce/content-widget-reviews.php ngtheme/woocommerce/emails/admin-cancelled-order.php ngtheme/woocommerce/emails/admin-failed-order.php ngtheme/woocommerce/emails/admin-new-order.php ngtheme/woocommerce/emails/customer-completed-order.php ngtheme/woocommerce/emails/customer-invoice.php ngtheme/woocommerce/emails/customer-new-account.php version 3.7.0 is out of date. The core version is 6.0.0 ngtheme/woocommerce/emails/customer-note.php ngtheme/woocommerce/emails/customer-on-hold-order.php ngtheme/woocommerce/emails/customer-processing-order.php ngtheme/woocommerce/emails/customer-refunded-order.php ngtheme/woocommerce/emails/customer-reset-password.php ngtheme/woocommerce/emails/email-addresses.php version 3.9.0 is out of date. The core version is 5.6.0 ngtheme/woocommerce/emails/email-customer-details.php ngtheme/woocommerce/emails/email-downloads.php ngtheme/woocommerce/emails/email-footer.php ngtheme/woocommerce/emails/email-header.php ngtheme/woocommerce/emails/email-order-details.php ngtheme/woocommerce/emails/email-order-items.php ngtheme/woocommerce/emails/email-styles.php ngtheme/woocommerce/emails/plain/admin-cancelled-order.php ngtheme/woocommerce/emails/plain/admin-failed-order.php ngtheme/woocommerce/emails/plain/admin-new-order.php ngtheme/woocommerce/emails/plain/customer-completed-order.php ngtheme/woocommerce/emails/plain/customer-invoice.php ngtheme/woocommerce/emails/plain/customer-new-account.php version 3.7.0 is out of date. The core version is 6.0.0 ngtheme/woocommerce/emails/plain/customer-note.php ngtheme/woocommerce/emails/plain/customer-on-hold-order.php ngtheme/woocommerce/emails/plain/customer-processing-order.php ngtheme/woocommerce/emails/plain/customer-refunded-order.php ngtheme/woocommerce/emails/plain/customer-reset-password.php ngtheme/woocommerce/emails/plain/email-addresses.php version 3.4.0 is out of date. The core version is 5.6.0 ngtheme/woocommerce/emails/plain/email-customer-details.php ngtheme/woocommerce/emails/plain/email-downloads.php ngtheme/woocommerce/emails/plain/email-order-details.php ngtheme/woocommerce/emails/plain/email-order-items.php version 3.7.0 is out of date. The core version is 5.2.0 ngtheme/woocommerce/global/breadcrumb.php ngtheme/woocommerce/global/form-login.php ngtheme/woocommerce/global/quantity-input.php ngtheme/woocommerce/global/sidebar.php ngtheme/woocommerce/global/wrapper-end.php ngtheme/woocommerce/global/wrapper-start.php ngtheme/woocommerce/loop/add-to-cart.php ngtheme/woocommerce/loop/loop-end.php ngtheme/woocommerce/loop/loop-start.php ngtheme/woocommerce/loop/no-products-found.php ngtheme/woocommerce/loop/orderby.php ngtheme/woocommerce/loop/pagination.php ngtheme/woocommerce/loop/price.php ngtheme/woocommerce/loop/rating.php ngtheme/woocommerce/loop/result-count.php ngtheme/woocommerce/loop/sale-flash.php ngtheme/woocommerce/myaccount/dashboard.php ngtheme/woocommerce/myaccount/downloads.php ngtheme/woocommerce/myaccount/form-add-payment-method.php ngtheme/woocommerce/myaccount/form-edit-account.php ngtheme/woocommerce/myaccount/form-edit-address.php ngtheme/woocommerce/myaccount/form-login.php version 4.1.0 is out of date. The core version is 6.0.0 ngtheme/woocommerce/myaccount/form-lost-password.php ngtheme/woocommerce/myaccount/form-reset-password.php ngtheme/woocommerce/myaccount/lost-password-confirmation.php ngtheme/woocommerce/myaccount/my-account.php ngtheme/woocommerce/myaccount/my-address.php ngtheme/woocommerce/myaccount/my-downloads.php ngtheme/woocommerce/myaccount/my-orders.php ngtheme/woocommerce/myaccount/navigation.php ngtheme/woocommerce/myaccount/orders.php ngtheme/woocommerce/myaccount/payment-methods.php ngtheme/woocommerce/myaccount/view-order.php ngtheme/woocommerce/notices/error.php ngtheme/woocommerce/notices/notice.php ngtheme/woocommerce/notices/success.php ngtheme/woocommerce/order/form-tracking.php version 3.6.0 is out of date. The core version is 6.5.0 ngtheme/woocommerce/order/order-again.php ngtheme/woocommerce/order/order-details-customer.php version 3.4.4 is out of date. The core version is 5.6.0 ngtheme/woocommerce/order/order-details-item.php version 3.7.0 is out of date. The core version is 5.2.0 ngtheme/woocommerce/order/order-details.php ngtheme/woocommerce/order/order-downloads.php ngtheme/woocommerce/order/tracking.php ngtheme/woocommerce/product-searchform.php ngtheme/woocommerce/single-product/add-to-cart/external.php ngtheme/woocommerce/single-product/add-to-cart/grouped.php version 4.0.0 is out of date. The core version is 4.8.0 ngtheme/woocommerce/single-product/add-to-cart/simple.php ngtheme/woocommerce/single-product/add-to-cart/variable.php version 3.5.5 is out of date. The core version is 6.1.0 ngtheme/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php ngtheme/woocommerce/single-product/add-to-cart/variation.php ngtheme/woocommerce/single-product/meta.php ngtheme/woocommerce/single-product/photoswipe.php ngtheme/woocommerce/single-product/price.php ngtheme/woocommerce/single-product/product-attributes.php ngtheme/woocommerce/single-product/product-image.php ngtheme/woocommerce/single-product/product-thumbnails.php ngtheme/woocommerce/single-product/rating.php ngtheme/woocommerce/single-product/related.php ngtheme/woocommerce/single-product/review-meta.php ngtheme/woocommerce/single-product/review-rating.php ngtheme/woocommerce/single-product/review.php ngtheme/woocommerce/single-product/sale-flash.php ngtheme/woocommerce/single-product/share.php ngtheme/woocommerce/single-product/short-description.php ngtheme/woocommerce/single-product/stock.php ngtheme/woocommerce/single-product/tabs/additional-information.php ngtheme/woocommerce/single-product/tabs/description.php ngtheme/woocommerce/single-product/tabs/tabs.php ngtheme/woocommerce/single-product/title.php ngtheme/woocommerce/single-product/up-sells.php ngtheme/woocommerce/single-product-reviews.php ngtheme/woocommerce/single-product.php ngtheme/woocommerce/taxonomy-product-cat.php ngtheme/woocommerce/taxonomy-product-tag.php Outdated Templates: ? Learn how to update ### Braintree (Credit Card) ### Environment: Sandbox Tokenization Enabled: Debug Mode: Off ### Braintree (PayPal) ### Environment: Sandbox Tokenization Enabled: Debug Mode: Off ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products experimental-product-tour shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience settings Daily Cron: ? Next scheduled: 2022-12-15 18:15:42 +00:00 Options: ? Notes: 95 Onboarding: completed ### Action Scheduler ### Complete: 2,844 Oldest: 2022-11-15 07:54:01 +0000 Newest: 2022-12-15 08:22:01 +0000 Pending: 5 Oldest: 2022-12-15 08:53:45 +0000 Newest: 2022-12-16 07:02:01 +0000 ### Status report information ### Generated at: 2022-12-15 08:22:48 +00:00
Hello @albyse,
Checking your store page, the rating is sorted correctly. The first product is 5 stars, the second 4.7 and so on.That said since your theme is overriding some templates I recommend getting in touch with your theme author for any similar problems in the future.
Cheers!Hi team, Thank you for the support. Even after changing the theme, the sort by rating is not working. Also we have updated the woocommerce plugin in localhost website, but rating is still not working. Please check https://lockmyseat.com/NGSale/products/?orderby=rating. Can you just mention the query for listing products based on rating from table.
Expecting your reply.
Hi there @albyse
Thank you for reaching back about this. Upon visiting the site at https://lockmyseat.com/NGSale/products/ just now, it appears that a sorting issue exists.
To help you further, I’d like to understand more about your current setup, since some time has passed from our last correspondence here.
Could you please send me a copy of your site’s System Status? You can find it via
WooCommerce > Status
. SelectGet system report
and thenCopy for support
.Once you’ve done that, you can paste the text in https://gist.github.com/, or https://pastebin.com/, and feel free to change/remove your site URL in the report for privacy reasons.
You can paste the Gist/Pastebin link here in your reply, once you have that.
Furthermore, since a picture is worth a thousand words, as the saying goes, could you also share a full-screen screenshot of the Shop page edit screen, and another of the page at wp-admin > Settings > Permalinks, please? https://snipboard.io/ is a good (online) tool of choice for sharing it here.
Looking forward to your response.
Hi team, Thank you for the reply. Screenshot is uploaded in URLs https://snipboard.io/5m8vzi.jpg , https://snipboard.io/gm9nZi.jpg , https://snipboard.io/i3fC9g.jpg , https://snipboard.io/f96Wsr.jpg , and https://snipboard.io/UCQVcK.jpg . Status uploaded in https://pastebin.com/7wnMT3ec. Please note that In this development site, we didn’t updated the plugins. All plugins are updated in localhost website. But sorting result based on start rating is same as this in dev site. So do I need to paste that status of localhost site? Expecting your support
-
This reply was modified 2 years ago by
albyse.
Hi team, any progress? It is very urgent
Thank you
Hi @albyse
Thanks for sharing the requested information above.
Can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled and see if this works?
If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.
If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.
If this did not resolve the issue, please provide the fatal error logs (if any) under
WooCommerce > Status > Logs
.You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.
Let us know how it goes!
Hi team,
I tested the conflict by enabling only woocommerce plugins and disabling other plugins and switched to storefront theme. But there is no change in the result. So I’m pasting the URL of error log here for your reference. URL is https://gist.github.com/alby-beep/e6e9929586279c8504e5d88ca0b8e421
Expecting your support
Thank you
Hello @albyse,
I can see the error coming from this pluginYasr – Yet Another Stars Rating
which is related to the problem you’re describing.
Can you please make sure to disable it?
Could you also try moving your site to another server or local host to make sure this is not a server issue? Here’s a guide on how to do so: https://www.wpbeginner.com/wp-tutorials/how-to-move-live-wordpress-site-to-local-server/
Let us know how it goes!Hi, I checked it by disabling Yasr – Yet Another Stars Rating plugin and moving it to local host. But still, the product rating is not working correctly. Is there any reason for it? Please reply
Hi @albyse ,
I’m sorry to hear that the issue is still present on your site.
After reading the thread, I understand that “Sort by average rating” is incorrect, yes?
I have tried to reproduce this issue on my staging site which uses the latest version of WooCommerce and WordPress, and has the default Storefront theme active, however, the products sort by average rating without any issues:
Please can you ensure that the
Yasr – Yet Another Stars Rating
plugin is disabled and then navigate to WooCommerce → Status → Tools, and do the following:- WooCommerce transients –
Clear
- Expired transients –
Clear
- Clear template cache –
Clear
Next, please clear your browser cache again, and then check if the product sorting now displays correctly.
If this makes no difference, please can you share a more recent copy of your sites System Status Report so that we can have a better understanding of your sites current environment.
You can find it via WooCommerce → Status. Select
Get system report
and thenCopy for support
Once you have that, please share the results in your response here.
Cheers!
Hi, I tried all you mentioned. But not getting any result. Here, I am copying the system report as you mentioned.
WordPress Environment WordPress address (URL): https://localhost/NGSales Site address (URL): https://localhost/NGSales WC Version: 7.5.1 REST API Version: ?</img> 7.5.1 WC Blocks Version: ?</img> 9.6.6 Action Scheduler Version: ?</img> 3.5.4 Log Directory Writable: ?</img> WP Version: 6.2 WP Multisite: – WP Memory Limit: 1 GB WP Debug Mode: – WP Cron: ?</img> Language: en_US External object cache: – Server Environment Server Info: Apache/2.4.52 (Win64) OpenSSL/1.1.1m PHP/8.1.4 PHP Version: 8.1.4 PHP Post Max Size: 8 GB PHP Time Limit: 600 PHP Max Input Vars: 1000 cURL Version: 7.77.0 OpenSSL/1.1.1m SUHOSIN Installed: – MySQL Version: 10.4.24-MariaDB Max Upload Size: 8 GB Default Timezone is UTC: ?</img> fsockopen/cURL: ?</img> SoapClient: ?</img> Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected. DOMDocument: ?</img> GZip: ?</img> Multibyte String: ?</img> Remote Post: ?</img> Remote Get: ?</img> Database WC Database Version: 7.5.1 WC Database Prefix: ngl_ Total Database Size: 92.06MB Database Data Size: 45.37MB Database Index Size: 46.69MB ngl_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_woocommerce_order_items: Data: 0.38MB + Index: 0.11MB + Engine InnoDB ngl_woocommerce_order_itemmeta: Data: 3.52MB + Index: 5.03MB + Engine InnoDB ngl_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_acfw_store_credits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_actionscheduler_actions: Data: 1.02MB + Index: 0.16MB + Engine InnoDB ngl_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_actionscheduler_logs: Data: 0.16MB + Index: 0.13MB + Engine InnoDB ngl_alm: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_bp_activity: Data: 0.02MB + Index: 0.16MB + Engine InnoDB ngl_bp_activity_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_bp_invitations: Data: 0.02MB + Index: 0.14MB + Engine InnoDB ngl_bp_notifications: Data: 0.02MB + Index: 0.11MB + Engine InnoDB ngl_bp_notifications_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_bp_optouts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_bp_xprofile_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_bp_xprofile_fields: Data: 0.02MB + Index: 0.08MB + Engine InnoDB ngl_bp_xprofile_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_bp_xprofile_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_comments: Data: 1.52MB + Index: 0.73MB + Engine InnoDB ngl_ewd_otp_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ewd_otp_fields_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ewd_otp_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ewd_otp_order_statuses: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ewd_otp_sales_reps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB ngl_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_ig_actions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB ngl_ig_blocked_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_campaigns: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_ig_contactmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_ig_contacts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_ig_contacts_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_ig_contact_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_ig_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_ig_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_lists_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_ig_mailing_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_ig_queue: Data: 0.02MB + Index: 0.13MB + Engine InnoDB ngl_ig_sending_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_temp_import: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_unsubscribe_feedback: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_wc_cart: Data: 0.02MB + Index: 0.08MB + Engine InnoDB ngl_ig_wc_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_ig_workflows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_ig_workflows_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_login_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_lws_wr_achieved_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_lws_wr_historic: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB ngl_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB ngl_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB ngl_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_mycred_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_nextend2_smartslider3_sliders: Data: 0.05MB + Index: 0.03MB + Engine InnoDB ngl_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB ngl_nrp_accounts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_nrp_points_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_options: Data: 6.36MB + Index: 0.27MB + Engine InnoDB ngl_pantheon_sessions: Data: 0.05MB + Index: 0.03MB + Engine InnoDB ngl_pincode_checker: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_pmpro_memberships_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_pmpro_memberships_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB ngl_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_pmpro_membership_levels: Data: 0.02MB + Index: 0.09MB + Engine InnoDB ngl_pmpro_membership_ordermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_pmpro_membership_orders: Data: 0.06MB + Index: 0.20MB + Engine InnoDB ngl_postmeta: Data: 19.52MB + Index: 32.13MB + Engine InnoDB ngl_posts: Data: 2.50MB + Index: 2.00MB + Engine InnoDB ngl_products_to_publish: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_product_restrictions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB ngl_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_termmeta: Data: 0.08MB + Index: 0.09MB + Engine InnoDB ngl_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_term_relationships: Data: 0.06MB + Index: 0.06MB + Engine InnoDB ngl_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_trackship_shipment: Data: 0.02MB + Index: 0.13MB + Engine InnoDB ngl_trackship_shipment_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_trackship_shipping_provider: Data: 0.08MB + Index: 0.00MB + Engine InnoDB ngl_type_restrictions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_usermeta: Data: 0.25MB + Index: 0.17MB + Engine InnoDB ngl_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_wccs_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wccs_condition_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB ngl_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB ngl_wc_cancel_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wc_order_product_lookup: Data: 0.41MB + Index: 0.45MB + Engine InnoDB ngl_wc_order_stats: Data: 0.28MB + Index: 0.30MB + Engine InnoDB ngl_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB ngl_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wdr_order_item_discounts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB ngl_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_woo_shippment_provider: Data: 0.09MB + Index: 0.00MB + Engine InnoDB ngl_wotv_woo_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_wpmailsmtp_debug_events: Data: 0.14MB + Index: 0.00MB + Engine InnoDB ngl_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_wt_sc_coupon_lookup: Data: 0.11MB + Index: 0.03MB + Engine InnoDB ngl_yasr_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yasr_log_multi_set: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yasr_multi_set: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yasr_multi_set_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yith_vendors_commissions: Data: 0.19MB + Index: 0.00MB + Engine InnoDB ngl_yith_vendors_commissions_notes: Data: 0.30MB + Index: 0.00MB + Engine InnoDB ngl_yith_vendors_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_vendors_payments_relationship: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wapo_addons: Data: 1.52MB + Index: 0.00MB + Engine InnoDB ngl_yith_wapo_blocks: Data: 0.08MB + Index: 0.00MB + Engine InnoDB ngl_yith_wapo_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_booking_meta_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDB ngl_yith_wcbk_booking_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_booking_resources: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yith_wcbk_external_bookings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_global_availability_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_global_availability_rules_associations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_global_price_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_global_price_rules_associations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_yith_wcbk_product_resources: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB ngl_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ngl_youzify_activity_polls_votes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_youzify_bookmarks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_youzify_hashtags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_youzify_hashtags_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_youzify_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_youzify_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_youzify_social_login_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ngl_zorem_email_sms_log: Data: 0.03MB + Index: 0.11MB + Engine InnoDB Post Type Counts acf-field: 104 acf-field-group: 9 attachment: 1365 bp-email: 22 br_products_of_day: 1 br_suggestion: 1 copy-to-clipboard: 1 dflip: 4 es_template: 2 footerad: 5 lws-wre-event: 4 lws-wre-pool: 1 mailpoet_page: 1 mycred_rank: 1 page: 45 popup: 2 popup_theme: 8 post: 2 product: 162 product_variation: 104 pscw-size-chart: 8 revision: 272 shop_coupon: 415 shop_order: 2381 shop_order_refund: 69 sidead: 2 size-chart: 10 sliders: 6 ultp_builder: 1 wpcf7_contact_form: 1 yith_booking: 351 yith_wcan_preset: 1 ywcbk-extra-cost: 1 ywcbk-person-type: 2 Security Secure connection (HTTPS): ?</img> Hide errors from visitors: ?</img> Active Plugins (53) Advanced Custom Fields: Repeater Field: by Elliot Condon – 2.1.0 Address correction autocomplete for Woo: by SAHU MEDIA ? – 1.1 Advanced Custom Fields: by WP Engine – 6.1.3 Advanced Product Search For WooCommerce: by aThemeArt – 1.1.1 Akismet Anti-Spam: by Automattic – 5.1 Contact Form 7 Captcha: by 247wd – 0.1.2 Contact Form 7: by Takayuki Miyoshi – 5.7.4 Default featured image: by Jan Willem Oostendorp – 1.7.3 Icegram Express - Email Subscribers, Newsletters and Marketing Automation Plugin: by Icegram – 5.6.1 Empty Cart Button for WooCommerce: by ProWCPlugins – 1.3.6 Gift Pack for WooCommerce: by IT Path Solutions – 1.0.8 reCaptcha by BestWebSoft: by BestWebSoft – 1.70 Innozilla Conditional Shipping and Payments for WooCommerce: by Innozilla – 1.0.1 Jetpack: by Automattic – 12.0 Assign Product Types & Categories to Vendors: by Admin Nextgencia – 1.0.0 Paid Memberships Pro: by Paid Memberships Pro – 2.10.3 Perzonalization - AI Powered Personalization That Sells: by Perzonalization – 1.6.0 Paid Memberships Pro - Cancel on Next Payment Date: by Paid Memberships Pro – 0.5.1 Paid Memberships Pro - Roles Add On: by Paid Memberships Pro – 1.4.2 Paid Memberships Pro - Require Strong Passwords: by Stranger Studios – 0.5.0 Points and Rewards for WooCommerce: by WP Swings – 1.4.2 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 Super Socializer: by Team Heateor – 7.13.47 TrackShip for WooCommerce: by TrackShip – 1.5.2 Transients Manager: by WPBeginner – 2.0.3 User Posts Limit: by Condless – 1.1.7 Voice Search: by Pascal Birchler – 1.4.0 WC Cancel Order: by WpExperts Hub – 3.2 Quantity Plus Minus Button for WooCommerce by CodeAstrology: by CodeAstrology Team – 1.1.7 White Label CMS: by www.videousermanuals.com – 2.5 WooCommerce Address Book: by CrossPeak – 2.4.1 Advanced Shipment Tracking for WooCommerce: by zorem – 3.5.2 Checkout Field Editor for WooCommerce: by ThemeHigh – 1.8.2 Digital Goods for WooCommerce Checkout: by theDotstore – 3.7.0 Photo Reviews for WooCommerce: by VillaTheme – 1.2.9 Return Refund and Exchange for WooCommerce: by WP Swings – 4.1.1 Thank You Page Customizer for WooCommerce: by VillaTheme – 1.0.13 Braintree for WooCommerce Payment Gateway: by WooCommerce – 2.6.5 PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.5.1 WooCommerce: by Automattic – 7.5.1 WordPress Importer: by wordpressdotorg – 0.8 WP Mail SMTP: by WPForms – 3.7.0 WP Sitemap Page: by Tony Archambeau – 1.9.2 WP User Profile Avatar: by WP Event Manager – 1.0 Social Share For WooCommerce: by kuldip_raghu – 1.0.4 ReCaptcha v2 for Contact Form 7: by IQComputing – 1.4.3 Smart Coupons For WooCommerce Coupons: by WebToffee – 1.4.6 YITH WooCommerce Ajax Product Filter: by YITH – 4.20.0 YITH Booking and Appointment for WooCommerce Premium: by YITH – 5.0.2 YITH WooCommerce Compare: by YITH – 2.24.0 YITH WooCommerce Multi Vendor Premium: by YITH – 4.8.0 YITH WooCommerce Product Add-ons & Extra Options: by YITH – 2.20.0 YITH WooCommerce Wishlist: by YITH – 3.19.0 Inactive Plugins (6) Ajax Load More: by Darren Cooney – 5.6.0.4 BuddyPress: by The BuddyPress Community – 11.1.0 QR Code Tag for WC order emails, POS receipt emails, PDF invoices, PDF packing slips, Blog posts, Custom post types and Pages (from goaskle.com): by Goaskle.com – 1.9.7 Ultimate Reviews: by Etoile Web Design – 3.2.5 Yet Another Stars Rating: by Dario Curvino – 3.3.4 Youzify: by KaineLabs – 1.2.2 Settings API Enabled: – Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: booking (booking) external (external) grouped (grouped) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) 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: – Enforce Approved Product Download Directories: – Order datastore: WC_Order_Data_Store_CPT WC Pages Shop base: #7 - /products/ Cart: #8 - /cart/ Checkout: #9 - /checkout/ My account: #10 - /my-account/ Terms and conditions: ?</img> Page not set Theme Name: Storefront Version: 4.2.0 Author URL: https://woocommerce.com/ Child Theme: ?</img> – 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: ?</img> Templates Overrides: – Braintree (Credit Card) Environment: Sandbox Tokenization Enabled: Debug Mode: Off Braintree (PayPal) Environment: Sandbox Tokenization Enabled: Debug Mode: Off Admin Enabled Features: activity-panels analytics coupons customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience product-variation-management settings Daily Cron: ?</img> Next scheduled: 2023-04-17 18:15:42 +00:00 Options: ?</img> Notes: 117 Onboarding: completed Action Scheduler Canceled: 1 Oldest: 2023-04-17 13:56:02 +0000 Newest: 2023-04-17 13:56:02 +0000 Complete: 197 Oldest: 2023-03-23 05:40:54 +0000 Newest: 2023-04-17 14:02:18 +0000 Failed: 173 Oldest: 2023-02-15 04:47:15 +0000 Newest: 2023-04-17 13:57:21 +0000 Pending: 5 Oldest: 2023-04-18 00:00:00 +0000 Newest: 2023-04-20 06:50:56 +0000 Status report information Generated at: 2023-04-17 14:35:54 +00:00 `
please reply
Hi @albyse
Thanks for sharing the requested information above.
It could be due to caching. Can you please have your host purge the site cache? Furthermore, please try to clear your browser’s cache or try another browser or in incognito mode and see if that works?
-
This reply was modified 2 years ago by
- The topic ‘Sorting based on Product average rating is incorrect in product page’ is closed to new replies.