Support » Plugin: WooCommerce » Imported products not sorting by price

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Margaret S. woo-hc

    (@margaretwporg)

    Hi @mroandersons

    In order to check your configuration and assist you further, could you please share with us the following:

    • 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.
    • Fatal Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

    Thanks

    Thread Starter mroandersons

    (@mroandersons)

    Ok, here you go:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://legit.lv
    Site address (URL): https://legit.lv
    WC Version: 5.5.2
    REST API Version: ✔ 5.5.2
    WC Blocks Version: ✔ 5.3.3
    Action Scheduler Version: ✔ 3.4.0
    WC Admin Version: ✔ 2.4.4
    Log Directory Writable: ✔
    WP Version: ❌ 5.8.3 - There is a newer version of WordPress available (5.9)
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: ✔
    WP Cron: ✔
    Language: lv
    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: 10.3.32-MariaDB-cll-lve
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 5.5.2
    WC Database Prefix: wpnm_
    Total Database Size: 150.58MB
    Database Data Size: 115.94MB
    Database Index Size: 34.64MB
    wpnm_woocommerce_sessions: Data: 7.15MB + Index: 0.17MB + Engine MyISAM
    wpnm_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_order_items: Data: 0.24MB + Index: 0.10MB + Engine MyISAM
    wpnm_woocommerce_order_itemmeta: Data: 1.21MB + Index: 0.84MB + Engine MyISAM
    wpnm_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_actionscheduler_actions: Data: 0.29MB + Index: 0.17MB + Engine MyISAM
    wpnm_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_actionscheduler_logs: Data: 0.23MB + Index: 0.17MB + Engine MyISAM
    wpnm_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_comments: Data: 1.02MB + Index: 0.42MB + Engine MyISAM
    wpnm_gla_budget_recommendations: Data: 0.11MB + Index: 0.12MB + Engine MyISAM
    wpnm_gla_merchant_issues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_gla_shipping_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_gla_shipping_times: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_inbank_detail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpnm_inbank_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpnm_inbank_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpnm_inbank_payment_lang: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpnm_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_dynamic_segment_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_feature_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_mapping_to_external_entities: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_templates: Data: 1.03MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_scheduled_tasks: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_mailpoet_scheduled_task_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_segments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_sending_queues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_opens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_unsubscribes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_woocommerce_purchases: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_subscribers: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_mailpoet_subscriber_custom_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_subscriber_ips: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_subscriber_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_user_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_image_storage: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_section_storage: Data: 0.11MB + Index: 0.01MB + Engine MyISAM
    wpnm_nextend2_smartslider3_generators: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_smartslider3_sliders: Data: 0.08MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_smartslider3_sliders_xref: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_smartslider3_slides: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
    wpnm_options: Data: 4.44MB + Index: 0.29MB + Engine MyISAM
    wpnm_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_images: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_imports: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_postmeta: Data: 72.92MB + Index: 21.53MB + Engine MyISAM
    wpnm_posts: Data: 16.35MB + Index: 5.30MB + Engine MyISAM
    wpnm_rank_math_404_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_rank_math_analytics_ga: Data: 0.29MB + Index: 0.15MB + Engine MyISAM
    wpnm_rank_math_analytics_gsc: Data: 0.28MB + Index: 0.27MB + Engine MyISAM
    wpnm_rank_math_analytics_keyword_manager: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_rank_math_analytics_objects: Data: 1.04MB + Index: 0.58MB + Engine MyISAM
    wpnm_rank_math_internal_links: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
    wpnm_rank_math_internal_meta: Data: 0.14MB + Index: 0.12MB + Engine MyISAM
    wpnm_rank_math_redirections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_rank_math_redirections_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_snippets: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wpnm_termmeta: Data: 0.07MB + Index: 0.04MB + Engine MyISAM
    wpnm_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_term_relationships: Data: 0.57MB + Index: 1.19MB + Engine MyISAM
    wpnm_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpnm_usermeta: Data: 0.35MB + Index: 0.21MB + Engine MyISAM
    wpnm_users: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
    wpnm_wcpdf_invoice_number: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpnm_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_customer_lookup: Data: 0.07MB + Index: 0.07MB + Engine MyISAM
    wpnm_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_order_product_lookup: Data: 0.14MB + Index: 0.11MB + Engine MyISAM
    wpnm_wc_order_stats: Data: 0.08MB + Index: 0.05MB + Engine MyISAM
    wpnm_wc_order_tax_lookup: Data: 0.05MB + Index: 0.06MB + Engine MyISAM
    wpnm_wc_product_meta_lookup: Data: 0.91MB + Index: 1.63MB + Engine MyISAM
    wpnm_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wpforms_tasks_meta: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    wpnm_yoast_indexable: Data: 6.29MB + Index: 0.73MB + Engine MyISAM
    wpnm_yoast_indexable_hierarchy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_yoast_primary_term: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wpnm_yoast_seo_links: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
    wpnm_yoast_seo_meta: Data: 0.07MB + Index: 0.07MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    acf-field: 6
    acf-field-group: 2
    attachment: 25687
    custom_css: 1
    customize_changeset: 9
    mailpoet_page: 1
    nav_menu_item: 12
    oembed_cache: 81
    page: 17
    post: 4
    product: 5752
    product_variation: 15
    revision: 680
    shop_order: 1086
    shop_order_refund: 1
    wp_block: 3
    wpforms: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (27) ###
    
    ACF: Better Search: by Mateusz Gbiorczyk – 4.0.0
    Acme import: by Oskars Andersons – 1.0
    Advanced Cron Manager: by BracketSpace – 2.4.1
    Advanced Custom Fields: by Delicious Brains – 5.11.4
    All-in-One WP Migration: by ServMask – 7.52
    Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.2.1
    Elko import: by Oskars Andersons – 1.1
    Error Log Monitor: by Janis Elsts – 1.7
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.3.0
    Jetpack: by Automattic – 10.5
    WooCommerce Gateway - kevin.: by kevin. – 2.1.3
    Loco Translate: by Tim Whitlock – 2.5.5
    MouseWheel Smooth Scroll: by KubiQ – 5.7
    Omniva shipping: by Omniva – 1.8.3-new
    Product XML Feeds for WooCommerce Pro: by WPWhale – 2.2.6
    Product XML Feeds for WooCommerce: by WPWhale – 2.2.6.1
    Rank Math SEO PRO: by Rank Math – 3.0.4
    Rank Math SEO: by Rank Math – 1.0.81.1
    Smart Slider 3: by Nextend – 3.5.1.2
    Ultimate Addons for Gutenberg: by Brainstorm Force – 1.25.2
    Checkout Field Editor for WooCommerce: by ThemeHigh – 1.5.3
    Indivy Pay Later Platform by Inbank: by Inbank – 2.0.4
    WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.9.3
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.17 (update to version 1.25.22 is available)
    WooCommerce: by Automattic – 5.5.2 (update to version 6.1.1 is available)
    WP Fastest Cache: by Emre Vona – 0.9.3
    WPForms Lite: by WPForms – 1.6.8.1
    
    ### Inactive Plugins (1) ###
    
    Code Snippets: by Code Snippets Pro – 2.14.1
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: left
    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: #6 - /veikals/
    Cart: #7 - /grozs/
    Checkout: #8 - /pirkuma-veiksana/
    My account: #9 - /mans-konts/
    Terms and conditions: #3 - /privatuma-politika/
    
    ### Theme ###
    
    Name: YITH Proteo Child
    Version: 1.1.0
    Author URL: https://yithemes.com/
    Child Theme: ✔
    Parent Theme Name: YITH Proteo
    Parent Theme Version: 1.5.5 – 1.8.0 is available
    Parent Theme Author URL: https://yithemes.com
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: yith-proteo/woocommerce/checkout/form-checkout.php
    yith-proteo-child/woocommerce/checkout/payment.php
    yith-proteo-child/woocommerce/checkout/review-order.php
    yith-proteo/woocommerce/content-product.php
    yith-proteo/woocommerce/content-single-product.php
    yith-proteo/woocommerce/content-widget-product.php
    yith-proteo/woocommerce/single-product/meta.php
    
    ### Action Scheduler ###
    
    Complete: 1,285
    Oldest: 2022-01-21 11:57:04 +0200
    Newest: 2022-02-04 12:32:03 +0200
    
    Failed: 1
    Oldest: 2020-05-22 16:39:03 +0300
    Newest: 2020-05-22 16:39:03 +0300
    
    Pending: 7
    Oldest: 2022-02-05 02:18:00 +0200
    Newest: 2022-02-09 13:07:05 +0200
    
    ### Status report information ###
    
    Generated at: 2022-02-04 12:49:53 +02:00
    

    Fatal Errors log:

    2022-01-10T08:01:50+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in .../public_html/wp-includes/meta.php on line 1085
    
    2022-01-10T08:01:50+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in .../public_html/wp-includes/meta.php on line 1085
    
    2022-01-10T08:01:50+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in .../public_html/wp-includes/meta.php on line 1085

    Should I try to increase PHP Post Max Size from 128 MB to 256 MB ?
    Although I do not believe it is the real problem, because just today I tried to regenerate Lookup tables and no fatal error showed up.

    Plugin Support Igor H woo-hc

    (@ihereira)

    Hello,

    Thanks for sharing this information.

    WP Version: ❌ 5.8.3 – There is a newer version of WordPress available (5.9)

    Upon checking it appears the version of your WordPress is not up to date, can you please update it, then disable the cache plugin(WP Fastest Cache) then check again if the issue persists?

    To update securely please refer to this article.

    Once it is up to date you can perform more troubleshooting actions, please refer to this documentation:
    https://woocommerce.com/document/woocommerce-self-service-guide/

    Let us know how it goes.

    Thread Starter mroandersons

    (@mroandersons)

    Thank you for response. We are experiencing this problem for almost year now, so as I suspected, updating WP core and plugins was not a solution. New sys report:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://legit.lv
    Site address (URL): https://legit.lv
    WC Version: 6.1.1
    REST API Version: ✔ 6.1.1
    WC Blocks Version: ✔ 6.5.2
    Action Scheduler Version: ✔ 3.4.0
    WC Admin Version: ✔ 3.0.3
    Log Directory Writable: ✔
    WP Version: 5.9
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: ✔
    WP Cron: ✔
    Language: lv
    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: 10.3.32-MariaDB-cll-lve
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.1.1
    WC Database Prefix: wpnm_
    Total Database Size: 150.56MB
    Database Data Size: 115.89MB
    Database Index Size: 34.67MB
    wpnm_woocommerce_sessions: Data: 7.15MB + Index: 0.17MB + Engine MyISAM
    wpnm_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_order_items: Data: 0.24MB + Index: 0.10MB + Engine MyISAM
    wpnm_woocommerce_order_itemmeta: Data: 1.21MB + Index: 0.84MB + Engine MyISAM
    wpnm_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_actionscheduler_actions: Data: 0.30MB + Index: 0.17MB + Engine MyISAM
    wpnm_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_actionscheduler_logs: Data: 0.24MB + Index: 0.18MB + Engine MyISAM
    wpnm_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_comments: Data: 1.02MB + Index: 0.42MB + Engine MyISAM
    wpnm_gla_budget_recommendations: Data: 0.11MB + Index: 0.12MB + Engine MyISAM
    wpnm_gla_merchant_issues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_gla_shipping_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_gla_shipping_times: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_inbank_detail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpnm_inbank_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpnm_inbank_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpnm_inbank_payment_lang: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpnm_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_dynamic_segment_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_feature_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_mapping_to_external_entities: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_newsletter_templates: Data: 1.03MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_scheduled_tasks: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_mailpoet_scheduled_task_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_segments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_sending_queues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_opens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_unsubscribes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_statistics_woocommerce_purchases: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_subscribers: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_mailpoet_subscriber_custom_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_subscriber_ips: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_subscriber_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_mailpoet_user_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_image_storage: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_section_storage: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    wpnm_nextend2_smartslider3_generators: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_smartslider3_sliders: Data: 0.08MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_smartslider3_sliders_xref: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_nextend2_smartslider3_slides: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
    wpnm_options: Data: 4.45MB + Index: 0.29MB + Engine MyISAM
    wpnm_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_images: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_imports: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_pmxi_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_postmeta: Data: 72.92MB + Index: 21.53MB + Engine MyISAM
    wpnm_posts: Data: 16.35MB + Index: 5.30MB + Engine MyISAM
    wpnm_rank_math_404_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_rank_math_analytics_ga: Data: 0.29MB + Index: 0.15MB + Engine MyISAM
    wpnm_rank_math_analytics_gsc: Data: 0.28MB + Index: 0.27MB + Engine MyISAM
    wpnm_rank_math_analytics_keyword_manager: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_rank_math_analytics_objects: Data: 1.04MB + Index: 0.58MB + Engine MyISAM
    wpnm_rank_math_internal_links: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
    wpnm_rank_math_internal_meta: Data: 0.14MB + Index: 0.12MB + Engine MyISAM
    wpnm_rank_math_redirections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_rank_math_redirections_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_snippets: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wpnm_termmeta: Data: 0.07MB + Index: 0.04MB + Engine MyISAM
    wpnm_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_term_relationships: Data: 0.57MB + Index: 1.19MB + Engine MyISAM
    wpnm_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpnm_usermeta: Data: 0.35MB + Index: 0.21MB + Engine MyISAM
    wpnm_users: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
    wpnm_wcpdf_invoice_number: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpnm_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpnm_wc_category_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_wc_customer_lookup: Data: 0.07MB + Index: 0.07MB + Engine MyISAM
    wpnm_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_order_product_lookup: Data: 0.14MB + Index: 0.11MB + Engine MyISAM
    wpnm_wc_order_stats: Data: 0.08MB + Index: 0.05MB + Engine MyISAM
    wpnm_wc_order_tax_lookup: Data: 0.05MB + Index: 0.06MB + Engine MyISAM
    wpnm_wc_product_meta_lookup: Data: 0.91MB + Index: 1.63MB + Engine MyISAM
    wpnm_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_wpforms_tasks_meta: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
    wpnm_yoast_indexable: Data: 6.29MB + Index: 0.73MB + Engine MyISAM
    wpnm_yoast_indexable_hierarchy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpnm_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpnm_yoast_primary_term: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wpnm_yoast_seo_links: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
    wpnm_yoast_seo_meta: Data: 0.07MB + Index: 0.07MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    acf-field: 6
    acf-field-group: 2
    attachment: 25690
    custom_css: 1
    customize_changeset: 9
    mailpoet_page: 1
    nav_menu_item: 12
    oembed_cache: 81
    page: 18
    post: 4
    product: 5766
    product_variation: 15
    revision: 680
    shop_order: 1088
    shop_order_refund: 1
    wp_block: 3
    wpforms: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (26) ###
    
    ACF: Better Search: by Mateusz Gbiorczyk – 4.0.1
    Acme import: by Oskars Andersons – 1.0
    Advanced Cron Manager: by BracketSpace – 2.4.2
    Advanced Custom Fields: by Delicious Brains – 5.11.4
    All-in-One WP Migration: by ServMask – 7.53
    Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.2.1
    Elko import: by Oskars Andersons – 1.1
    Error Log Monitor: by Janis Elsts – 1.7
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.3.2
    Jetpack: by Automattic – 10.6
    WooCommerce Gateway - kevin.: by kevin. – 2.1.3
    Loco Translate: by Tim Whitlock – 2.5.8
    MouseWheel Smooth Scroll: by KubiQ – 5.9
    Omniva shipping: by Omniva – 1.8.3-new
    Product XML Feeds for WooCommerce Pro: by WPWhale – 2.2.6
    Product XML Feeds for WooCommerce: by WPWhale – 2.3
    Rank Math SEO PRO: by Rank Math – 3.0.5
    Rank Math SEO: by Rank Math – 1.0.81.1
    Smart Slider 3: by Nextend – 3.5.1.3
    Ultimate Addons for Gutenberg: by Brainstorm Force – 1.25.3
    Checkout Field Editor for WooCommerce: by ThemeHigh – 1.5.3
    Indivy Pay Later Platform by Inbank: by Inbank – 2.0.4
    WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.12.1
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.22
    WooCommerce: by Automattic – 6.1.1
    WPForms Lite: by WPForms – 1.7.2.1
    
    ### Inactive Plugins (1) ###
    
    WP Fastest Cache: by Emre Vona – 0.9.8
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: left
    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: #6 - /veikals/
    Cart: #7 - /grozs/
    Checkout: #8 - /pirkuma-veiksana/
    My account: #9 - /mans-konts/
    Terms and conditions: #3 - /privatuma-politika/
    
    ### Theme ###
    
    Name: YITH Proteo Child
    Version: 1.1.0
    Author URL: https://yithemes.com/
    Child Theme: ✔
    Parent Theme Name: YITH Proteo
    Parent Theme Version: 1.5.5 – 1.8.0 is available
    Parent Theme Author URL: https://yithemes.com
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: yith-proteo/woocommerce/checkout/form-checkout.php
    yith-proteo-child/woocommerce/checkout/payment.php
    yith-proteo-child/woocommerce/checkout/review-order.php
    yith-proteo/woocommerce/content-product.php
    yith-proteo/woocommerce/content-single-product.php
    yith-proteo/woocommerce/content-widget-product.php
    yith-proteo/woocommerce/single-product/meta.php
    
    ### Action Scheduler ###
    
    Complete: 1,320
    Oldest: 2022-01-21 11:57:04 +0200
    Newest: 2022-02-04 15:10:06 +0200
    
    Failed: 1
    Oldest: 2020-05-22 16:39:03 +0300
    Newest: 2020-05-22 16:39:03 +0300
    
    Pending: 7
    Oldest: 2022-02-05 02:18:00 +0200
    Newest: 2022-02-09 13:07:05 +0200
    
    ### Status report information ###
    
    Generated at: 2022-02-04 16:28:48 +02:00
    
    Thread Starter mroandersons

    (@mroandersons)

    Maybe I’m updating my price wrong?

    update_post_meta( $post_id, ‘_regular_price’, $prodPrice );
    update_post_meta( $post_id, ‘_price’, $prodPrice );
    and then
    wp_update_post(array(
    ‘ID’ => $post_id,
    ));

    Should I call some other function?

    If I open product in admin, change price and update, it goes in right place in sorting.

    Plugin Support Mirko P. woo-hc

    (@rainfallnixfig)

    Hi @mroandersons,

    On this page I see you’re filtering products by price: low to high but it doesn’t seem to properly work.

    What we recommend is checking if the filter works correctly when you switch your theme to Storefront and disable all plugins except for WooCommerce.

    If you’re not seeing the same behavior, then you know the problem was with the plugins and/or theme you deactivated.

    Reactivate the theme first and check again. Then, go on and reactivate your other plugins one by one, testing after each, until you find the one causing conflict.

    You can find a more detailed explanation on how to do a conflict test here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/.

    Thanks.

    Thread Starter mroandersons

    (@mroandersons)

    Hi!
    Thank you all for support.

    In the end problem was with import price – it came with thousands seperator as “1,234.50”.
    Solution -> number_format($price, 2, ‘.’, ”)

    Plugin Support Margaret S. woo-hc

    (@margaretwporg)

    Hi @mroandersons

    Thanks for the update! I am glad to hear that you found the cause of the problem.

    I’m marking this topic as resolved. Feel free to create a new topic if you have any other questions.

    Cheers!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Imported products not sorting by price’ is closed to new replies.