Sorting by price variable products

Hi there,

I understand that, when you try to use price sorting, it doesn’t really sort the variable products by price.

It will be great if you could share your current System Status Report. You can get it by navigating to the WooCommerce / Status section of your site. Once there, click on the Get system report button and then copy it by clicking on the Copy for support button. Then paste it here in a comment.

Best,

I digged a bit deeper in:

In WooCommerce are variants/variable products childs of a main Product. The Main Product will called for all general Product information and hast he attribute price. The Variants/Variables overwrite this price with the attribute (variant) price. The price in the shop gallary will shown as smalles Variant/Variable price – largest Variants/Variable price. The Price in the main product will be set to 0.

Let’s make an exemple.
? Main Product: phone
o Varient 1 yellow phone price 50,00€
o Varient 2 red phone price 150,00€
? Other product USB-Stick price 8,99€

In the shop frontend phone 50,00€ – 150,00€.
In the shop frontend USB-Stick 8,99€.

If you sort from Low to high
? expected order USB-Stick, phone
? real order phone, USB-Stick

The problem is that main product phone will set automatically attribut price = 0 because it self has no own price. For a right order the lowest variant price must be used.

Best Regards
Collie-IT

WooCommerce status

### WordPress Environment ###

WordPress address (URL): 
Site address (URL):
WC Version: 6.4.1
REST API Version: ? 6.4.1
WC Blocks Version: ? 7.2.2
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.3.2
Log Directory Writable: ?
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: de_DE
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.13
PHP Post Max Size: 32 MB
PHP Time Limit: 240
PHP Max Input Vars: 1500
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 5.7.25-28
Max Upload Size: 32 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.4.1
WC Database Prefix: wp_test_
Datenbank-Gesamtgr??e: 66.38MB
Datenbank-Datengr??e: 49.95MB
Datenbank-Indexgr??e: 16.43MB
wp_test_woocommerce_sessions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_woocommerce_api_keys: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_attribute_taxonomies: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_woocommerce_downloadable_product_permissions: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_test_woocommerce_order_items: Daten: 0.13MB + Index: 0.06MB + Engine InnoDB
wp_test_woocommerce_order_itemmeta: Daten: 0.52MB + Index: 0.53MB + Engine InnoDB
wp_test_woocommerce_tax_rates: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_test_woocommerce_tax_rate_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_shipping_zones: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_woocommerce_shipping_zone_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_shipping_zone_methods: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_woocommerce_payment_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_woocommerce_payment_tokenmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_log: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_actionscheduler_actions: Daten: 1.33MB + Index: 0.67MB + Engine InnoDB
wp_test_actionscheduler_claims: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_actionscheduler_groups: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_actionscheduler_logs: Daten: 1.39MB + Index: 0.36MB + Engine InnoDB
wp_test_c2c_config: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_commentmeta: Daten: 0.13MB + Index: 0.14MB + Engine InnoDB
wp_test_comments: Daten: 0.36MB + Index: 0.39MB + Engine InnoDB
wp_test_duplicator_packages: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_gla_budget_recommendations: Daten: 0.22MB + Index: 0.14MB + Engine InnoDB
wp_test_gla_merchant_issues: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_gla_shipping_rates: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_gla_shipping_times: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_content_status: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_core_status: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_flags: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_languages: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_icl_languages_translations: Daten: 0.20MB + Index: 0.17MB + Engine InnoDB
wp_test_icl_locale_map: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_icl_message_status: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_icl_mo_files_domains: Daten: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_node: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_icl_reminders: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_icl_strings: Daten: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_test_icl_string_batches: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_icl_string_packages: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_icl_string_positions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_string_status: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_string_translations: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_translate: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_translate_job: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_icl_translations: Daten: 0.39MB + Index: 1.08MB + Engine InnoDB
wp_test_icl_translation_batches: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_icl_translation_downloads: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_icl_translation_status: Daten: 0.11MB + Index: 0.06MB + Engine InnoDB
wp_test_itsec_bans: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_itsec_dashboard_events: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_itsec_distributed_storage: Daten: 11.02MB + Index: 0.02MB + Engine InnoDB
wp_test_itsec_fingerprints: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_itsec_geolocation_cache: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_itsec_lockouts: Daten: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_test_itsec_logs: Daten: 12.52MB + Index: 0.11MB + Engine InnoDB
wp_test_itsec_mutexes: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_itsec_opaque_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_itsec_temp: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_test_itsec_user_groups: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_links: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_custom_fields: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_dynamic_segment_filters: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_feature_flags: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_forms: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_mailpoet_log: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_mailpoet_mapping_to_external_entities: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_newsletters: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_mailpoet_newsletter_links: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_test_mailpoet_newsletter_option: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_newsletter_option_fields: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_newsletter_posts: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_newsletter_segment: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_newsletter_templates: Daten: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_test_mailpoet_scheduled_tasks: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_mailpoet_scheduled_task_subscribers: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_segments: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_mailpoet_sending_queues: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_mailpoet_settings: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_statistics_bounces: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_mailpoet_statistics_clicks: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_test_mailpoet_statistics_forms: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_statistics_newsletters: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_mailpoet_statistics_opens: Daten: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_test_mailpoet_statistics_unsubscribes: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_test_mailpoet_statistics_woocommerce_purchases: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_test_mailpoet_stats_notifications: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_mailpoet_subscribers: Daten: 0.02MB + Index: 0.13MB + Engine InnoDB
wp_test_mailpoet_subscriber_custom_field: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_subscriber_ips: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_subscriber_segment: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_mailpoet_user_agents: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_mailpoet_user_flags: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_options: Daten: 3.25MB + Index: 0.16MB + Engine InnoDB
wp_test_postmeta: Daten: 9.44MB + Index: 7.02MB + Engine InnoDB
wp_test_posts: Daten: 1.48MB + Index: 0.94MB + Engine InnoDB
wp_test_termmeta: Daten: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_test_terms: Daten: 0.09MB + Index: 0.16MB + Engine InnoDB
wp_test_term_relationships: Daten: 1.50MB + Index: 0.44MB + Engine InnoDB
wp_test_term_taxonomy: Daten: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_test_toolset_associations: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_test_toolset_connected_elements: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_toolset_post_guid_id: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_toolset_relationships: Daten: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_test_toolset_type_sets: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_usermeta: Daten: 0.34MB + Index: 0.34MB + Engine InnoDB
wp_test_users: Daten: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_test_wc_admin_notes: Daten: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_test_wc_admin_note_actions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_wc_category_lookup: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_wc_customer_lookup: Daten: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_test_wc_download_log: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_wc_order_coupon_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_wc_order_product_lookup: Daten: 0.11MB + Index: 0.06MB + Engine InnoDB
wp_test_wc_order_stats: Daten: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_test_wc_order_tax_lookup: Daten: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_test_wc_product_attributes_lookup: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_wc_product_meta_lookup: Daten: 0.22MB + Index: 0.47MB + Engine InnoDB
wp_test_wc_rate_limits: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_wc_reserved_stock: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_wc_tax_rate_classes: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_wc_webhooks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_test_woocommerce_gzd_dhl_im_products: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_gzd_dhl_im_product_services: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_gzd_packaging: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_woocommerce_gzd_packagingmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_gzd_shipmentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_gzd_shipments: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_test_woocommerce_gzd_shipment_itemmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_gzd_shipment_items: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_test_woocommerce_gzd_shipment_labelmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_gzd_shipment_labels: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_test_woocommerce_gzd_shipping_provider: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_test_woocommerce_gzd_shipping_providermeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 1836
customize_changeset: 2
itsec-dash-card: 9
itsec-dashboard: 2
mailpoet_page: 1
nav_menu_item: 37
page: 43
polylang_mo: 3
post: 3
product: 318
product_variation: 1634
revision: 45
seedprod: 1
shop_order: 419
shop_order_refund: 5
wp_global_styles: 1
wp-types-group: 1

### Security ###

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

### Active Plugins (21) ###

WPML Multilingual CMS: von OnTheGoSystems – 4.5.6
Akismet Anti-Spam: von Automattic – 4.2.3
iThemes Security: von iThemes – 8.1.2
Cart2cart: Magento to Woocommerce Plugin: von MagneticOne – 2.0.0
Coming Soon Page, Maintenance Mode, Landing Pages & WordPress Website Builder by SeedProd: von SeedProd – 6.10.0
Duplicator: von Snap Creek – 1.4.5
Nav Menu Roles: von Kathy Darling – 2.1.0
OTGS Installer: von OnTheGoSystems – 3.0.3
Perfect Brands for WooCommerce: von QuadLayers – 2.0.8
Suki Pro: von Suki WordPress Theme – 1.2.4
Toolset Types: von OnTheGoSystems – 3.4.15
Woo Align Buttons: von 320up – 3.6.7
Extra Product Options (Product Addons) for WooCommerce: von ThemeHigh – 3.1.1
Braintree for WooCommerce Payment Gateway: von WooCommerce – 2.6.4
Germanized für WooCommerce: von vendidero – 3.9.2
WooCommerce Multilingual: von OnTheGoSystems – 4.12.6
WooCommerce: von Automattic – 6.4.1 (Update auf Version 6.5.1 ist verfügbar)
WP-DBManager: von Lester 'GaMerZ' Chan – 2.80.5
WPC Composite Products for WooCommerce (Premium): von WPClever – 5.1.0
WPML String Translation: von OnTheGoSystems – 3.2.1

### Inactive Plugins (7) ###

Google Listings and Ads: von WooCommerce – 1.12.8
Jetpack: von Automattic – 10.9
MailPoet 3 (New): von MailPoet – 3.89.0
Payment Plugins Braintree For WooCommerce: von Payment Plugins
[email protected] – 3.2.34

Remove WPML Menu Sync: von SO WP – 1.2.2
WooCommerce Payments: von Automattic – 4.1.0
WooCommerce Shipping & Tax: von WooCommerce – 1.25.27 (Update auf Version 1.25.28 ist verfügbar)

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right_space
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: composite (composite)
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-Basis: #6 - /
Warenkorb: #7 - /warenkorb/
Kasse: #8 - /kasse/
Mein Konto: #9 - /mein-konto/
Allgemeine Gesch?ftsbedingungen: #38 - /agb/

### Theme ###

Name: Suki Child
Version: 1.0.0
Author URL: https://sukiwp.com/#about
Child Theme: ?
Parent Theme Name: Suki
Parent Theme Version: 1.3.7
Parent Theme Author URL: https://sukiwp.com/#about
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Abgeschlossen: 2.123
Oldest: 2022-04-19 13:33:49 +0200
Newest: 2022-05-17 08:08:24 +0200

Ausstehend: 2
Oldest: 2022-05-17 14:40:41 +0200
Newest: 2022-05-17 14:40:41 +0200

### Status report information ###

Generated at: 2022-05-17 14:31:25 +02:00

• This reply was modified 2 years, 6 months ago by Collie-IT, Anne K. Frey.

Hi @collieit,

I’ve performed a test on a staging environment and was unable to reproduce the issue you’re describing with a fresh install of WordPress 5.9.3, WooCommerce 6.5.1, and the default Storefront theme.

Full Size: https://i.imgur.com/LCV1oSq.png

Can you provide a screenshot of how the price and product sorting is displayed on your site? You can use https://snipboard.io for easily sharing screenshots – please follow the instructions on that page, then paste the URL in this thread.

Cheers.

Hi there,

It’s been a while since we last heard back from you. I’m going to mark this thread as resolved.

Hopefully, the above info was helpful. If you have further questions, please feel free to open a new topic.

Cheers.