Support » Plugin: WooCommerce » Creating an Upsell item – Searching is “super slow”

  • Resolved Krammig

    (@krammig)


    I am trying to enter Upsells and Cross-sells items into a Variable product on a website that has around 9,000 products and about 68,000 Variations.

    On entering characters into the field all I see is “Searching..” and it just sits there and sits there.

    Any suggestions would be appreciated

    thanks

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support Jesse Pearson

    (@jessepearson)

    Automattic Happiness Engineer

    @krammig This sounds like it could be a limitation of the server itself due to the amount of items that are needing to be searched. Can you go to WooCommerce > Status and copy/paste the System Status Report here for us to take a look at?

    Thank you for the swift reply Jesse. Report below.
    Cheers

    
    ### WordPress Environment ###
    
    Home URL: http://spiritclothing.com.au
    Site URL: http://spiritclothing.com.au
    WC Version: 3.3.5
    Log Directory Writable: ✔
    WP Version: 4.9.6
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: ✔
    WP Cron: ✔
    Language: en_US
    
    ### Server Environment ###
    
    Server Info: Microsoft-IIS/10.0
    PHP Version: 5.6.36
    PHP Post Max Size: 16 MB
    PHP Time Limit: -1
    PHP Max Input Vars: 2000
    cURL Version: 7.59.0
    OpenSSL/1.0.2o
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.39
    Max Upload Size: 16 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 2.6.14
    WC Database Prefix: 2pzughvr_
    MaxMind GeoIP Database: ✔
    Total Database Size: 528.10MB
    Database Data Size: 397.18MB
    Database Index Size: 130.92MB
    2pzughvr_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB
    2pzughvr_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
    2pzughvr_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
    2pzughvr_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.03MB
    2pzughvr_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
    2pzughvr_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB
    2pzughvr_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
    2pzughvr_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB
    2pzughvr_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
    2pzughvr_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB
    2pzughvr_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
    2pzughvr_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
    2pzughvr_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
    2pzughvr_woocommerce_log: ❌ Table does not exist
    2pzughvr_commentmeta: Data: 0.02MB + Index: 0.03MB
    2pzughvr_comments: Data: 0.02MB + Index: 0.08MB
    2pzughvr_datalist: Data: 0.02MB + Index: 0.00MB
    2pzughvr_ddp_log: Data: 0.02MB + Index: 0.00MB
    2pzughvr_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB
    2pzughvr_duplicator_pro_packages: Data: 0.03MB + Index: 0.02MB
    2pzughvr_links: Data: 0.02MB + Index: 0.02MB
    2pzughvr_odb_logs: Data: 0.02MB + Index: 0.00MB
    2pzughvr_options: Data: 18.45MB + Index: 2.55MB
    2pzughvr_pmxe_exports: Data: 0.02MB + Index: 0.00MB
    2pzughvr_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB
    2pzughvr_pmxe_posts: Data: 4.52MB + Index: 0.00MB
    2pzughvr_pmxe_templates: Data: 0.02MB + Index: 0.00MB
    2pzughvr_pmxi_files: Data: 0.02MB + Index: 0.00MB
    2pzughvr_pmxi_history: Data: 0.02MB + Index: 0.00MB
    2pzughvr_pmxi_imports: Data: 3.52MB + Index: 0.00MB
    2pzughvr_pmxi_posts: Data: 13.52MB + Index: 0.00MB
    2pzughvr_pmxi_templates: Data: 1.52MB + Index: 0.00MB
    2pzughvr_postmeta: Data: 290.97MB + Index: 101.25MB
    2pzughvr_posts: Data: 58.56MB + Index: 23.05MB
    2pzughvr_preloader_ultimate: Data: 0.02MB + Index: 0.00MB
    2pzughvr_revslider_css: Data: 0.13MB + Index: 0.00MB
    2pzughvr_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB
    2pzughvr_revslider_navigations: Data: 0.02MB + Index: 0.00MB
    2pzughvr_revslider_sliders: Data: 0.11MB + Index: 0.00MB
    2pzughvr_revslider_slides: Data: 1.52MB + Index: 0.00MB
    2pzughvr_revslider_static_slides: Data: 0.02MB + Index: 0.00MB
    2pzughvr_smush_dir_images: Data: 0.02MB + Index: 0.03MB
    2pzughvr_termmeta: Data: 0.22MB + Index: 0.33MB
    2pzughvr_terms: Data: 0.22MB + Index: 0.30MB
    2pzughvr_term_relationships: Data: 2.52MB + Index: 2.50MB
    2pzughvr_term_taxonomy: Data: 0.22MB + Index: 0.25MB
    2pzughvr_usermeta: Data: 0.06MB + Index: 0.03MB
    2pzughvr_users: Data: 0.02MB + Index: 0.05MB
    2pzughvr_wpmelon_advbedit_temp: Data: 0.02MB + Index: 0.00MB
    2pzughvr_yith_wcwl: Data: 0.02MB + Index: 0.02MB
    2pzughvr_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB
    
    ### Post Type Counts ###
    
    attachment: 33426
    jetpack_migration: 2
    kscf_faq: 17
    mc4wp-form: 2
    nav_menu_item: 459
    page: 52
    post: 2
    product: 4719
    product_variation: 87856
    revision: 54
    shop_order: 14
    woocollections: 4
    woocollect_cpt: 2
    woocollitems: 4
    wpcf7_contact_form: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ❌Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
    Hide errors from visitors: ✔
    
    ### Active Plugins (36) ###
    
    Admin Menu Editor Pro: by Janis Elsts – 2.4.3
    BackupBuddy: by iThemes – 8.2.3.4
    Breadcrumb NavXT: by John Havlik – 6.0.4
    Candy FAQ: by KonstruktStudio – 1.1.0
    Contact Form 7: by Takayuki Miyoshi – 5.0.1
    Custom Post Type UI: by WebDevStudios – 1.5.7
    Delete Duplicate Posts: by cleverplugins.com – 4.1.9.4
    Easy Theme and Plugin Upgrades: by Chris Jean – 2.0.0
    Image Widget: by Modern Tribe
    Inc. – 4.4.7
    
    WPBakery Page Builder: by Michael M - WPBakery.com – 5.4.5
    Legacy - White Label WordPress Admin Theme: by themepassion – 5.1
    MailChimp for WordPress: by ibericode – 4.2.1
    Max Mega Menu: by Tom Hemsley – 2.4.1.5
    Members: by Justin Tadlock – 2.1.0
    Meta Box: by MetaBox.io – 4.14.5
    PayPal for WooCommerce: by Angell EYE – 1.4.9
    Slider Revolution: by ThemePunch – 5.4.6.3.1
    RiverTheme Core: by Zootemplate – 2.0.2
    RiverTheme Core: by Zootemplate – 2.0.2
    Optimize Database after Deleting Revisions: by CAGE Web Design | Rolf van Gelder
    Eindhoven
    The Netherlands – 4.6.2
    
    Servebolt Optimizer: by Servebolt – 1.5.1
    SW Core: by Smartaddons – 1.4.0
    Sw Woocommerce: by SmartAddons – 1.5.3
    Transients Manager: by Pippin Williamson – 1.7.4
    WooCollect: by Smartik – 1.1 – Not tested with the active version of WooCommerce
    Woocommerce Advanced Bulk Edit: by George Iron – 4.2.1 – Not tested with the active version of WooCommerce
    Simple Registration for WooCommerce: by Astoundify – 1.5.2 – Not tested with the active version of WooCommerce
    WooCommerce: by Automattic – 3.3.5 – 3.4.2 is available
    WP All Export Pro: by Soflyy – 1.4.7
    WP All Import Pro: by Soflyy – 4.4.9
    WP-Optimize: by David Anderson
    Ruhani Rabin
    Team Updraft – 2.2.3
    
    WP Rocket: by WP Media – 2.9.8.1
    WP-Sweep: by Lester 'GaMerZ' Chan – 1.0.12
    WP All Import - WooCommerce Add-On Pro: by Soflyy – 2.3.4 – Not tested with the active version of WooCommerce
    YITH WooCommerce Compare: by YITHEMES – 2.3.0
    YITH WooCommerce Wishlist Premium: by Yithemes – 2.0.13 – Not tested with the active version of WooCommerce
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: AUD ($)
    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: outofstock (outofstock)
    rated-5 (rated-5)
    
    ### WC Pages ###
    
    Shop base: #4 - /shop/
    Cart: #44033 - /cart/
    Checkout: #6 - /checkout/
    My account: #7 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Revo
    Version: 1.4.1
    Author URL: http://www.smartaddons.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: revo/archive-product.php version - is out of date. The core version is 3.3.0
    revo/woocommerce/content-product.php version 2.6.1 is out of date. The core version is 3.0.0
    revo/woocommerce/content-single-product.php version 1.6.4 is out of date. The core version is 3.0.0
    revo/woocommerce/loop\loop-end.php
    revo/woocommerce/loop\loop-start.php version 2.0.0 is out of date. The core version is 3.3.0
    revo/woocommerce/loop\pagination.php version 2.2.2 is out of date. The core version is 3.3.1
    revo/woocommerce/loop\rating.php version 2.0.0 is out of date. The core version is 3.0.0
    revo/woocommerce/myaccount\dashboard.php
    revo/woocommerce/myaccount\form-login.php version 2.6.0 is out of date. The core version is 3.3.0
    revo/woocommerce/myaccount\my-account.php
    revo/woocommerce/single-product\meta.php version 1.6.4 is out of date. The core version is 3.0.0
    revo/woocommerce/single-product\price.php version 2.4.9 is out of date. The core version is 3.0.0
    revo/woocommerce/single-product\product-image.php version 2.6.3 is out of date. The core version is 3.3.2
    revo/woocommerce/single-product\product-thumbnails.php version 2.6.3 is out of date. The core version is 3.3.2
    revo/woocommerce/single-product\rating.php version 2.3.2 is out of date. The core version is 3.1.0
    revo/woocommerce/single-product\tabs\tabs.php
    revo/woocommerce/single-product-reviews.php version 2.3.2 is out of date. The core version is 3.2.0
    revo/single-product.php version - is out of date. The core version is 1.6.4
    
    Outdated Templates: ❌Learn how to update
    
    Plugin Support Amanda

    (@amandasjackson)

    Hi @krammig,

    looking through your System Status Report there are a number of items that you will want to look into updating as this may be the cause of the issue.

    To begin, the WooCommerce plugin as well as your database are both outdated. Here is how you can update those:

    https://docs.woocommerce.com/document/how-to-update-woocommerce/

    I noticed that your site is running PHP version 5.6.36.  WooCommerce does require a minimum of version 5.6 and WordPress now recommends version 7.0. This is something your host can help you with; here’s some more information to get you started:
    https://docs.woocommerce.com/document/how-to-update-your-php-version/

    Lastly, it looks like your theme is running a number of outdated templates, so you will want to update those as well: https://docs.woocommerce.com/document/fix-outdated-templates-woocommerce/

    Hello @amandasjackson

    Thanks for the reply. Yes I must say you are right in mentioning those outdated items. To be open I have just been too afraid of updating them as when I have done so on other sites in the past something invariably goes wrong. 🙂

    I will tackle that though and see how it goes.

    Cheers

    Plugin Support ryanr14

    (@ryanr14)

    Hi @krammig,

    Two other things I noticed in your systems status was…

    PHP Max Input Vars: 2000
    WC Database Version: 2.6.14

    The PHP Max Input Vars may not be causing trouble, but I think a good minimum would be 3000. My test site has it set to 6144. The most confusing thing though is that your WC Database Version is very old. That is supposed to match with the actual version of WooCommerce you are using as well.

    Since you have WooCommerce 3.3.5 your WC Database Version should also be 3.3.5. Also you may see improvements by updating WooCommerce to the current version and then let it update your database to match as well.

    Thanks @ryanr14

    I’ve just had another look at the php.ini file and I was surprised to see the following ;

    
    ; How many GET/POST/COOKIE input variables may be accepted
    max_input_vars = 3000
    
    ; Maximum amount of memory a script may consume (128MB)
    ; http://php.net/memory-limit
    memory_limit = 256M
    
    ; http://php.net/post-max-size
    post_max_size = 60M
    

    But as you say the Report shows PHP Max Input Vars: 2000 which is puzzling for me. I’m not WordPress guy I’m afraid so not sure where to look for why it would be sitting at 2000, thoughts appreciated ?

    Hi @ryanr14,

    I have just found that although I am running this on a dedicated server (Windows), it seems in the Plesk control panel there are settings for a number of items including max_input_vars which was set to 2000 and it seems that is overriding the 3000 set in the php.ini file.

    I have altered the Plesk setting for that site to 3000 and it seems to have made a noticeable improvement. Could be faster, but it certainly is faster than it was.

    Thanks for that.

    I am now planning to upgrade the rest of the items pointed out earlier .

    Cheers

    Plugin Support Jesse Pearson

    (@jessepearson)

    Automattic Happiness Engineer

    @krammig Thanks for letting us know updating that setting helped, please let us know if the other updates make a difference.

    Plugin Support Amanda

    (@amandasjackson)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Creating an Upsell item – Searching is “super slow”’ is closed to new replies.