Sort by price (Low to High) Bug

That happens to other pages as well! Also one more problem is that products with original and sale prices, the original price is shown without tax calculated and the visual outcome is for example 1235,68 (original price, price shown without tax(bug)) – 1500 (sale price, which is right).

Hi @sofianosorthopedika,

Before you go too deep into debugging this issue, can you try some simple conflict testing?

You’ll want to:
– Disable all plugins, except for WooCommerce.
– Activate a default theme, such as Storefront.

Once that’s done, do you still see the same issue?
Are WooCommerce and WordPress updated to their most recent versions?

Thank you,
Joey

Hello, thank you very much for your time, much appreciated!

I have enabled storefront theme as well as disable all plugins except woocommerce!
The problem of sorting products by price is still there unfortunately…

Can you help me with more ideas to try out?
Thank you!

Hi there,

Sorry for the wait on this! 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.

What this does is give us an idea of what is on the site exactly, so we can try to pinpoint what is going on. I look forward to hearing back from you!

### WordPress Environment ###

WordPress address (URL): https://sofianos-orthopedika.gr
Site address (URL): https://sofianos-orthopedika.gr
WC Version: 3.9.1
REST API Version: ? 1.0.7
Log Directory Writable: ?
WP Version: 5.3.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: el
External object cache: –

### Server Environment ###

Server Info: nginx/1.17.5
PHP Version: 7.4.0
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 10000
cURL Version: 7.47.0
OpenSSL/1.0.2g

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.6-MariaDB-1:10.4.6+maria~xenial
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.8.1
WC Database Prefix: wp_
Total Database Size: 298.31MB
Database Data Size: 214.59MB
Database Index Size: 83.72MB
wp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 1.52MB + Index: 0.30MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 6.52MB + Index: 5.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sib_model_contact: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sib_model_country: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_cartflows_ca_cart_abandonment: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
wp_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_comments: Data: 3.52MB + Index: 1.06MB + Engine InnoDB
wp_dgwt_wcas_index: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_dgwt_wcas_invindex_doclist: Data: 2.52MB + Index: 2.52MB + Engine InnoDB
wp_dgwt_wcas_invindex_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dgwt_wcas_invindex_wordlist: Data: 1.52MB + Index: 0.44MB + Engine InnoDB
wp_dgwt_wcas_tax_index: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
wp_dgwt_wcas_var_index: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_fg_redirect: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_hellaspay_data: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_import_detail_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_log_detail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_import_postID: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_access: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_archive_numeric_2020_01: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_matomo_archive_numeric_2020_02: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_matomo_brute_force_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_goal: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_locks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_logger_message: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_log_action: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_log_conversion: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_matomo_log_conversion_item: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_log_link_visit_action: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_matomo_log_profiling: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_log_visit: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_matomo_option: Data: 0.17MB + Index: 0.02MB + Engine InnoDB
wp_matomo_plugin_setting: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_privacy_logdata_anonymizations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_report: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_report_subscriptions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_segment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_sequence: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_session: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_site: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_site_setting: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_site_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_tagmanager_container: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_tagmanager_container_release: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_tagmanager_container_version: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_matomo_tagmanager_tag: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_tagmanager_trigger: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_tagmanager_variable: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_matomo_tracking_failure: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_twofactor_recovery_code: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_user: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_matomo_user_dashboard: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_matomo_user_language: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 16.31MB + Index: 4.72MB + Engine InnoDB
wp_phone_orders_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 86.61MB + Index: 26.06MB + Engine InnoDB
wp_posts: Data: 21.55MB + Index: 3.69MB + Engine InnoDB
wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_internal_links: Data: 1.52MB + Index: 0.19MB + Engine InnoDB
wp_rank_math_internal_meta: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_redirections: Data: 0.20MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_redirections_cache: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_sc_analytics: Data: 57.58MB + Index: 29.75MB + Engine InnoDB
wp_shipment_batch_process: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sib_model_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sib_model_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 1.52MB + Index: 1.86MB + Engine InnoDB
wp_terms: Data: 1.52MB + Index: 1.83MB + Engine InnoDB
wp_term_relationships: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wp_term_taxonomy: Data: 1.52MB + Index: 0.50MB + Engine InnoDB
wp_usermeta: Data: 2.52MB + Index: 2.00MB + Engine InnoDB
wp_users: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
wp_vivawallet_data: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_email_notify: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.34MB + Index: 0.59MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woo_shipment_status_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woo_shippment_provider: Data: 0.05MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

aiosrs-schema: 5
attachment: 5965
custom_css: 4
customize_changeset: 5
elementor_library: 5
gp_elements: 14
mc4wp-form: 2
nav_menu_item: 259
oembed_cache: 43
page: 26
post: 72
product: 2330
product_variation: 1461
revision: 4
sa_slider: 1
scheduled-action: 246
shop_coupon: 56
shop_order: 3760
soliloquy: 1
sp_wps_shortcodes: 1
tm_global_cp: 1
tm_product_cp: 195
wc_xml_feeds: 4
wcps: 1
wpcf7_contact_form: 3
wpmm_theme: 3
wysijap: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (33) ###

Advanced Database Cleaner PRO: by Younes JFR. – 3.1.0
AJAX Search for WooCommerce (Premium): by Damian Góra – 1.6.1
Akismet Anti-Spam: by Automattic – 4.1.3
Payment Gateway Based Fees and Discounts for WooCommerce: by Tyche Softwares – 2.6 – Not tested with the active version of WooCommerce
Contact Form 7: by Takayuki Miyoshi – 5.1.6
Customer Reviews for WooCommerce: by ivole – 3.95
Google Tag Manager for WordPress: by Thomas Geiger – 1.11.2 – Not tested with the active version of WooCommerce
Elementor Pro: by Elementor.com – 2.8.3
Elementor: by Elementor.com – 2.8.5
Enable Media Replace: by ShortPixel – 3.3.7
GP Premium: by Tom Usborne – 1.9.1
Lightweight Social Icons: by Thomas Usborne – 1.0.1
Sendinblue Subscribe Form And WP SMTP: by Sendinblue – 2.9.11
Ultimate WooCommerce Brands PRO: by MagniumThemes – 1.1.1 – Not tested with the active version of WooCommerce
Perfmatters: by forgemedia – 1.4.7
Phone Orders for WooCommerce: by AlgolPlus – 3.4.0
Rank Math SEO: by Rank Math – 1.0.38
ShortPixel Image Optimizer: by ShortPixel – 4.16.0
WooCommerce Skroutz Analytics: by Skroutz – 1.5.1 – Not tested with the active version of WooCommerce
Superfly Menu: by Looks Awesome – 5.0.7
WooCommerce Vivawallet Gateway: by Viva Wallet – 3.3.5 – Not tested with the active version of WooCommerce
Advanced Shipment Tracking for WooCommerce: by zorem – 2.8.5
WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.4
Woo Vat Price Fields: by Spyros Vlachopoulos – 1.0
Premmerce Permalink Manager for WooCommerce (Premium): by premmerce – 2.1.12 – Not tested with the active version of WooCommerce
Product Feed PRO for WooCommerce: by AdTribes.io – 7.4.3
WooCommerce Sendinblue Newsletter Subscription: by Sendinblue – 1.2.20 – Not tested with the active version of WooCommerce
WooCommerce Table Rate Shipping: by Bolder Elements – 4.1.3 – Not tested with the active version of WooCommerce
WooCommerce TM Extra Product Options: by themeComplete – 4.9.12.1
WooCommerce: by Automattic – 3.9.1
WP Crontrol: by John Blackbourn & crontributors – 1.7.1
WP Lazy Loading: by The WordPress Team – 1.0
WP Rocket: by WP Media – 3.4.4

### Inactive Plugins (1) ###

Matomo Analytics - Ethical Stats. Powerful Insights.: by Matomo – 0.4.1 – Not tested with the active version of WooCommerce

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (1) ###

Kinsta Must-use Plugins: by Kinsta Team – 2.3.2

### Settings ###

API Enabled: ?
Force SSL: –
Currency: EUR (€)
Currency Position: right
Thousand Separator: 
Decimal Separator: .
Number of Decimals: 2
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)
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: #126 - /shop/
Cart: #167 - /cart-2/
Checkout: #164 - /checkout-2/
My account: #162 - /account/
Terms and conditions: #3217 - /oroi-xrisis/

### Theme ###

Name: GeneratePress Child
Version: 0.1
Author URL: https://tomusborne.com
Child Theme: ?
Parent Theme Name: GeneratePress
Parent Theme Version: 2.4.1
Parent Theme Author URL: https://tomusborne.com
WooCommerce Support: ?

### Templates ###

Overrides: /www/sofianosorthopedikagr_789/public/wp-content/plugins/woocommerce-tm-extra-product-options/templates/cart/cart-item-data.php

### Ajax Search for WooCommerce ###

Ajax Search for WooCommerce - mbstring: ?
Ajax Search for WooCommerce - pdo_mysql: ?
Ajax Search for WooCommerce - Finding wp-load.php: ?
Ajax Search for WooCommerce - Multisite: disabled
Ajax Search for WooCommerce - Conflicts with plugins: no

### Action Scheduler ###

Complete: 246
Oldest: 2020-01-13 00:38:30 +0200
Newest: 2020-02-11 12:38:31 +0200

Pending: 0
Oldest: –
Newest: –

Canceled: 0
Oldest: –
Newest: –

In-progress: 0
Oldest: –
Newest: –

Failed: 0
Oldest: –
Newest: –

Hi @sofianosorthopedika

It appears the WooCommerce Database version doesn’t match the same version of WooCommerce that is installed. Manually update the WooCommerce database under WooCommerce > Status > Tools > Update database as a first step.

Next, it appears the child theme and plugins are still active. After switching back to a default theme like Twenty Twenty and disabling all plugins except for WooCommerce, can you fresh the permalinks under Settings > Permalinks > Save.

After doing that, edit a product’s price then back again and see if that makes any change to the pricing sorting on the shop page.

Thanks,

Hi @sofianosorthopedika

We’ll mark this thread as resolved now that we haven’t heard back. Please feel free to open a new thread if you have any additional questions or concerns.

Regards,