Support » Plugin: WooCommerce » Search in dashboard

  • Resolved masternikos

    (@masternikos)


    Hi.I stay in version 3.3.0
    All others new version is slow in search to find a product.
    I have try all to disable plugins theme.I checked all.
    I have 12.000 products but work very well until version 3.3.0 after this version the search is terribly slow (Take 13 seconds to find a product).I ask for your help.Thanks

    • This topic was modified 1 year, 5 months ago by masternikos.
Viewing 15 replies - 1 through 15 (of 19 total)
  • Plugin Support Kenin

    (@kbassart)

    Automattic Happiness Engineer

    Hi there,

    There could me many causes for an issue like this. You may want to install Query Monitor ( https://wordpress.org/plugins/query-monitor/ ) and see if there are any errors or other notices that may shed light on the issue. You’ll want to do the test with all plugins disabled and a default theme as well.

    Also, 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.

    Ok.I install query monitor and i found this is slow in search products
    TIME: 31543
    what do you suggest?

    SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
    FROM wp_posts posts
    LEFT JOIN wp_postmeta postmeta
    ON posts.ID = postmeta.post_id
    WHERE posts.post_type IN (‘product’,’product_variation’)
    AND ( ( ( posts.post_title LIKE ‘%test%’)
    OR ( posts.post_excerpt LIKE ‘%test%’)
    OR ( posts.post_content LIKE ‘%test%’ )
    OR ( postmeta.meta_key = ‘_sku’
    AND postmeta.meta_value LIKE ‘%test%’ ) ))
    ORDER BY posts.post_parent ASC, posts.post_title ASC

    WP_Posts_List_Table->prepare_items()
    wp-admin/includes/class-wp-posts-list-table.php:136
    wp_edit_posts_query()
    wp-admin/includes/post.php:1073
    wp()
    wp-includes/functions.php:960
    WP->main()
    wp-includes/class-wp.php:713
    WP->parse_request()
    wp-includes/class-wp.php:364
    apply_filters(‘request’)
    wp-includes/plugin.php:203
    WC_Admin_List_Table->request_query()
    wp-content/plugins/woocommerce/includes/admin/list-tables/abstract-class-wc-admin-list-table.php:118
    WC_Admin_List_Table_Products->query_filters()
    wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
    WC_Data_Store->search_products()
    wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
    WC_Data_Store->__call()
    wp-content/plugins/woocommerce/includes/class-wc-data-store.php:203
    WC_Product_Data_Store_CPT->search_products()
    wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php:1426

    Plugin Support Kenin

    (@kbassart)

    Automattic Happiness Engineer

    Hi there,

    Can you also please provide a System Status report for this same install found under WooCommerce>Status?

    WordPress environment
    Home URL: https://www..com
    Site URL: https://www..com
    WC version: 3.3.0
    Log directory writable: /home/ucxwtbqy/public_html/wp-content/uploads/wc-logs/
    WP version: 4.9.6
    WP multisite: –
    WP memory limit: 256 MB
    WP debug mode: –
    WP cron: –
    Language: en_US
    Server environment
    Server info: Apache
    PHP version: 5.6.36
    PHP post max size: 70 MB
    PHP time limit: 90
    PHP max input vars: 1000
    cURL version: 7.54.0, OpenSSL/1.0.2k
    SUHOSIN installed: –
    Max upload size: 50 MB
    Default timezone is UTC:
    fsockopen/cURL:
    SoapClient:
    DOMDocument:
    GZip:
    Multibyte string:
    Remote post:
    Remote get:
    Database
    WC database version: 3.3.0
    Database prefix wp_
    Total Database Size 537.98MB
    Database Data Size 349.30MB
    Database Index Size 188.68MB
    wp_woocommerce_sessions Data: 0.87MB + Index: 0.04MB
    wp_woocommerce_api_keys Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_attribute_taxonomies Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_downloadable_product_permissions Data: 0.86MB + Index: 0.93MB
    wp_woocommerce_order_items Data: 1.53MB + Index: 0.66MB
    wp_woocommerce_order_itemmeta Data: 15.56MB + Index: 5.37MB
    wp_woocommerce_tax_rates Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_tax_rate_locations Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zones Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_methods Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokens Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokenmeta Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_log Data: 0.00MB + Index: 0.00MB
    wp_aiosc_cron Data: 0.00MB + Index: 0.00MB
    wp_aiosc_departments Data: 0.00MB + Index: 0.01MB
    wp_aiosc_premades Data: 0.00MB + Index: 0.00MB
    wp_aiosc_priorities Data: 0.00MB + Index: 0.01MB
    wp_aiosc_replies Data: 0.02MB + Index: 0.01MB
    wp_aiosc_tickets Data: 0.02MB + Index: 0.01MB
    wp_aiosc_uploads Data: 0.00MB + Index: 0.00MB
    wp_aiowps_events Data: 0.00MB + Index: 0.00MB
    wp_aiowps_failed_logins Data: 0.00MB + Index: 0.00MB
    wp_aiowps_global_meta Data: 0.00MB + Index: 0.00MB
    wp_aiowps_login_activity Data: 0.08MB + Index: 0.02MB
    wp_aiowps_login_lockdown Data: 0.00MB + Index: 0.00MB
    wp_aiowps_permanent_block Data: 0.00MB + Index: 0.00MB
    wp_asp_index Data: 0.02MB + Index: 0.04MB
    wp_asp_synonyms Data: 0.00MB + Index: 0.00MB
    wp_aws_index Data: 0.00MB + Index: 0.00MB
    wp_commentmeta Data: 0.04MB + Index: 0.05MB
    wp_comments Data: 2.77MB + Index: 1.42MB
    wp_duplicator_pro_entities Data: 0.01MB + Index: 0.00MB
    wp_duplicator_pro_packages Data: 0.00MB + Index: 0.00MB
    wp_links Data: 0.00MB + Index: 0.00MB
    wp_options Data: 23.09MB + Index: 4.02MB
    wp_postmeta Data: 259.47MB + Index: 156.88MB
    wp_posts Data: 34.11MB + Index: 8.35MB
    wp_signups Data: 0.19MB + Index: 0.02MB
    wp_sr_woo_abandoned_items Data: 0.01MB + Index: 0.01MB
    wp_termmeta Data: 0.02MB + Index: 0.02MB
    wp_terms Data: 2.20MB + Index: 2.31MB
    wp_term_relationships Data: 1.72MB + Index: 3.55MB
    wp_term_taxonomy Data: 1.46MB + Index: 2.29MB
    wp_un_termmeta Data: 0.00MB + Index: 0.01MB
    wp_usermeta Data: 3.47MB + Index: 2.02MB
    wp_users Data: 0.29MB + Index: 0.23MB
    wp_wc_comments_subscription Data: 0.00MB + Index: 0.00MB
    wp_wc_download_log Data: 0.07MB + Index: 0.06MB
    wp_wc_phrases Data: 0.00MB + Index: 0.00MB
    wp_wc_users_voted Data: 0.00MB + Index: 0.00MB
    wp_wc_webhooks Data: 0.00MB + Index: 0.00MB
    wp_wlo_order_log Data: 0.11MB + Index: 0.00MB
    wp_woocommerce_gpf_google_taxonomy Data: 0.95MB + Index: 0.00MB
    wp_woocommerce_order_status_action Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_termmeta Data: 0.00MB + Index: 0.00MB
    wp_wpcreviews Data: 0.01MB + Index: 0.00MB
    wp_wpc_comments_subscription Data: 0.03MB + Index: 0.02MB
    wp_wpc_phrases Data: 0.00MB + Index: 0.00MB
    wp_wpc_users_voted Data: 0.00MB + Index: 0.01MB
    wp_wpie_export_log Data: 0.00MB + Index: 0.00MB
    wp_wpmelon_advbedit_temp Data: 0.00MB + Index: 0.00MB
    wp_yoast_seo_links Data: 0.03MB + Index: 0.02MB
    wp_yoast_seo_meta Data: 0.29MB + Index: 0.29MB
    Post Type Counts
    attachment 6786
    customize_changeset 16
    cx_offline_msg 1
    documentation 1
    dt_testimonials 3
    export_template 2
    gema75_wc_badge 1
    mts_notification_bar 1
    nav_menu_item 262
    oembed_cache 128
    page 20
    paypal_ipn 2
    post 18
    postman_sent_mail 12
    product 12429
    product_variation 49375
    revision 37
    scheduled-action 250
    searchford 2
    shop_coupon 114
    shop_order 8074
    shop_subscription 3099
    un_feedback 3
    w4pl 2
    wishlist 8
    wpcr3_review 46
    wpdiscuz_form 1
    Security
    Secure connection (HTTPS):
    Hide errors from visitors
    Active plugins (12)
    All In One WP Security by Tips and Tricks HQ, Peter Petreski, Ruhul, Ivy – 4.3.3.1
    Autoptimize by Frank Goossens (futtta) – 2.3.4
    AIO Support Center by DiWave Coders – 2.21
    Duplicator Pro by Snap Creek – 3.7.1.1
    Toolset Access by OnTheGoSystems – 2.4.3.5
    WooCommerce Advanced Bulk Edit by George Iron – 4.4.1
    Woocommerce Limit Order by WP Friends – 2.6 – Not tested with the active version of WooCommerce
    WooCommerce Smart Coupons by WooCommerce – 3.4.1 – 3.4.4 is available
    WooCommerce Subscriptions by Prospress Inc. – 2.2.19 – 2.2.21 is available
    WooCommerce by Automattic – 3.3.0 – 3.4.2 is available
    Yoast SEO Premium by Team Yoast – 7.5
    WP Super Cache by Automattic – 1.6.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), 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)
    WC pages
    Shop base: #25886 – /shop/
    Cart: #4098 – /cart-2/
    Checkout: #4099 – /checkout-2/
    My account: #4100 – /my-account/
    Terms and conditions: #2 – /terms-of-service/
    Theme
    Name: Flatsome
    Version: 3.6.0
    Author URL: http://www.uxthemes.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 flatsome/woocommerce/archive-product.php,
    flatsome/woocommerce/cart/cart-empty.php,
    flatsome/woocommerce/cart/cart.php,
    flatsome/woocommerce/checkout/form-checkout.php,
    flatsome/woocommerce/checkout/form-coupon.php,
    flatsome/woocommerce/checkout/thankyou.php,
    flatsome/woocommerce/content-product.php,
    flatsome/woocommerce/content-product_cat.php,
    flatsome/woocommerce/content-single-product.php,
    flatsome/woocommerce/global/breadcrumb.php,
    flatsome/woocommerce/global/quantity-input.php,
    flatsome/woocommerce/global/wrapper-end.php,
    flatsome/woocommerce/global/wrapper-start.php,
    flatsome/woocommerce/loop/loop-end.php,
    flatsome/woocommerce/loop/loop-start.php,
    flatsome/woocommerce/loop/pagination.php,
    flatsome/woocommerce/loop/result-count.php,
    flatsome/woocommerce/loop/sale-flash.php,
    flatsome/woocommerce/myaccount/form-login.php,
    flatsome/woocommerce/myaccount/navigation.php,
    flatsome/woocommerce/notices/error.php,
    flatsome/woocommerce/notices/notice.php,
    flatsome/woocommerce/notices/success.php,
    flatsome/woocommerce/product-searchform.php,
    flatsome/woocommerce/single-product/photoswipe.php,
    flatsome/woocommerce/single-product/price.php,
    flatsome/woocommerce/single-product/product-image.php,
    flatsome/woocommerce/single-product/product-thumbnails.php,
    flatsome/woocommerce/single-product/rating.php,
    flatsome/woocommerce/single-product/related.php,
    flatsome/woocommerce/single-product/review.php,
    flatsome/woocommerce/single-product/sale-flash.php,
    flatsome/woocommerce/single-product/share.php,
    flatsome/woocommerce/single-product/short-description.php,
    flatsome/woocommerce/single-product/tabs/tabs.php,
    flatsome/woocommerce/single-product/title.php,
    flatsome/woocommerce/single-product/up-sells.php,
    flatsome/woocommerce/single-product-reviews.php,
    flatsome/woocommerce/single-product.php
    Subscriptions
    WCS_DEBUG: No
    Subscriptions Mode: Live
    Subscriptions Template Theme Overrides: –
    Report Cache Enabled: Yes
    Cache Update Failures: 0 failure

    Now just return in 3.3.0
    and try a second server but nothing.
    Thanks.

    Plugin Support wbrubaker

    (@wbrubaker)

    Howdy 🙂

    The first thing that jumps out at me in that system status report is the PHP version. Many people have experienced significant performance increases by updating to PHP 7. I would suggest working with your host to update the PHP version.

    Kind regards,

    Just update 7 but nothing.It’s slow again.

    Plugin Support ryanr14

    (@ryanr14)

    With the Query Monitor plugin, if you sort by time do you see anything that takes up an extreme amount of time?

    For example this is from a test site using the sample data.


    Link to image: http://cld.wthms.co/fPgXmj

    please read above
    TIME: 31543
    what do you suggest?

    SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
    FROM wp_posts posts
    LEFT JOIN wp_postmeta postmeta
    ON posts.ID = postmeta.post_id
    WHERE posts.post_type IN (‘product’,’product_variation’)
    AND ( ( ( posts.post_title LIKE ‘%test%’)
    OR ( posts.post_excerpt LIKE ‘%test%’)
    OR ( posts.post_content LIKE ‘%test%’ )
    OR ( postmeta.meta_key = ‘_sku’
    AND postmeta.meta_value LIKE ‘%test%’ ) ))
    ORDER BY posts.post_parent ASC, posts.post_title ASC

    WP_Posts_List_Table->prepare_items()
    wp-admin/includes/class-wp-posts-list-table.php:136
    wp_edit_posts_query()
    wp-admin/includes/post.php:1073
    wp()
    wp-includes/functions.php:960
    WP->main()
    wp-includes/class-wp.php:713
    WP->parse_request()
    wp-includes/class-wp.php:364
    apply_filters(‘request’)
    wp-includes/plugin.php:203
    WC_Admin_List_Table->request_query()
    wp-content/plugins/woocommerce/includes/admin/list-tables/abstract-class-wc-admin-list-table.php:118
    WC_Admin_List_Table_Products->query_filters()
    wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
    WC_Data_Store->search_products()
    wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
    WC_Data_Store->__call()
    wp-content/plugins/woocommerce/includes/class-wc-data-store.php:203
    WC_Product_Data_Store_CPT->search_products()
    wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php:1426TIME: 31543
    what do you suggest?

    SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
    FROM wp_posts posts
    LEFT JOIN wp_postmeta postmeta
    ON posts.ID = postmeta.post_id
    WHERE posts.post_type IN (‘product’,’product_variation’)
    AND ( ( ( posts.post_title LIKE ‘%test%’)
    OR ( posts.post_excerpt LIKE ‘%test%’)
    OR ( posts.post_content LIKE ‘%test%’ )
    OR ( postmeta.meta_key = ‘_sku’
    AND postmeta.meta_value LIKE ‘%test%’ ) ))
    ORDER BY posts.post_parent ASC, posts.post_title ASC

    WP_Posts_List_Table->prepare_items()
    wp-admin/includes/class-wp-posts-list-table.php:136
    wp_edit_posts_query()
    wp-admin/includes/post.php:1073
    wp()
    wp-includes/functions.php:960
    WP->main()
    wp-includes/class-wp.php:713
    WP->parse_request()
    wp-includes/class-wp.php:364
    apply_filters(‘request’)
    wp-includes/plugin.php:203
    WC_Admin_List_Table->request_query()
    wp-content/plugins/woocommerce/includes/admin/list-tables/abstract-class-wc-admin-list-table.php:118
    WC_Admin_List_Table_Products->query_filters()
    wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
    WC_Data_Store->search_products()
    wp-content/plugins/woocommerce/includes/admin/list-tables/class-wc-admin-list-table-products.php:426
    WC_Data_Store->__call()
    wp-content/plugins/woocommerce/includes/class-wc-data-store.php:203
    WC_Product_Data_Store_CPT->search_products()
    wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php:1426

    Plugin Support Jesse Pearson

    (@jessepearson)

    Automattic Happiness Engineer

    @masternikos We have another user that is experiencing similar issues, they increased their PHP max input vars to 3000 and this helped them with some of the speed issues. Would you mind trying this to see if this helps?

    Hi.Just try nothing.

    Plugin Support Jesse Pearson

    (@jessepearson)

    Automattic Happiness Engineer

    @masternikos Is it possible for you to make a full copy of your site and try either using the site locally or on another host? Just trying to rule out any and all problems.

    I try in 2 servers vps shared and local host.
    Nothing.
    I have stay in 3.3.0 version.
    Trying my self to find differents from 3.3.1 but is difficult

    Plugin Support ryanr14

    (@ryanr14)

    Hi @masternikos,

    I think at this point adding either Elasticsearch or Redis caching for the database should quite a bit. WooCommerce core is working on database and table improvements which will make performance better, but even when those come along a large database will see benefits from the two tools I mentioned above.

    Elasticsearch & Redis are technologies you’d have to install on your server, or ask your host if it’s possible they can install or enable these. If you can get one enabled and running with your host then there are plugins to help integrate WordPress into each of them.

    https://wordpress.org/plugins/elasticpress/
    https://wordpress.org/plugins/redis-cache/

    Plugin Support Kenin

    (@kbassart)

    Automattic Happiness Engineer

    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.

    Since the upgrade i am also facing the same search issues, i am on PHP 7.2, even the latest update did not help, please help.

    SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
    FROM wp_posts posts
    LEFT JOIN wp_postmeta postmeta
    ON posts.ID = postmeta.post_id
    WHERE posts.post_type IN (‘product’,’product_variation’)
    AND ( ( ( posts.post_title LIKE ‘%samsung%’)
    OR ( posts.post_excerpt LIKE ‘%samsung%’)
    OR ( posts.post_content LIKE ‘%samsung%’ )
    OR ( postmeta.meta_key = ‘_sku’
    AND postmeta.meta_value LIKE ‘%samsung%’ ) ))
    ORDER BY posts.post_parent ASC, posts.post_title ASC

    
    ### WordPress Environment ###
    
    Home URL: http://domain.com
    Site URL: http://domain.com
    WC Version: 3.4.4
    Log Directory Writable: ✔
    WP Version: 4.9.7
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.2.6
    PHP Post Max Size: 1 GB
    PHP Time Limit: 180
    PHP Max Input Vars: 1000
    cURL Version: 7.54.0
    OpenSSL/1.0.2k
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.39-cll-lve
    Max Upload Size: 1,000 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.4.4
    WC Database Prefix: wp4c_
    Total Database Size: 477.80MB
    Database Data Size: 411.07MB
    Database Index Size: 66.73MB
    wp4c_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB
    wp4c_woocommerce_attribute_taxonomies: Data: 0.03MB + Index: 0.03MB
    wp4c_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wp4c_abj404_redirects: Data: 0.00MB + Index: 0.02MB
    wp4c_amz_assets: Data: 0.55MB + Index: 0.21MB
    wp4c_amz_cross_sell: Data: 0.15MB + Index: 0.01MB
    wp4c_amz_products: Data: 0.15MB + Index: 0.16MB
    wp4c_amz_queue: Data: 0.00MB + Index: 0.00MB
    wp4c_amz_search: Data: 0.00MB + Index: 0.00MB
    wp4c_cegg_autoblog: Data: 0.01MB + Index: 0.00MB
    wp4c_cegg_price_alert: Data: 0.00MB + Index: 0.01MB
    wp4c_cegg_price_history: Data: 0.71MB + Index: 0.99MB
    wp4c_commentmeta: Data: 0.42MB + Index: 0.02MB
    wp4c_comments: Data: 0.40MB + Index: 0.03MB
    wp4c_failed_jobs: Data: 0.00MB + Index: 0.00MB
    wp4c_lgp_posts: Data: 0.15MB + Index: 0.00MB
    wp4c_links: Data: 0.03MB + Index: 0.02MB
    wp4c_mailchimp_carts: Data: 0.00MB + Index: 0.00MB
    wp4c_mclean_refs: Data: 12.08MB + Index: 5.45MB
    wp4c_mclean_scan: Data: 0.00MB + Index: 0.00MB
    wp4c_mts_locker_stats: Data: 0.00MB + Index: 0.00MB
    wp4c_options: Data: 15.48MB + Index: 1.03MB
    wp4c_pmxi_files: Data: 0.00MB + Index: 0.00MB
    wp4c_pmxi_history: Data: 0.00MB + Index: 0.00MB
    wp4c_pmxi_imports: Data: 0.23MB + Index: 0.00MB
    wp4c_pmxi_posts: Data: 0.10MB + Index: 0.02MB
    wp4c_pmxi_templates: Data: 0.42MB + Index: 0.00MB
    wp4c_postmeta: Data: 314.38MB + Index: 23.82MB
    wp4c_posts: Data: 61.51MB + Index: 28.63MB
    wp4c_price_alert: Data: 0.00MB + Index: 0.00MB
    wp4c_price_evolution: Data: 0.17MB + Index: 0.12MB
    wp4c_queue: Data: 0.00MB + Index: 0.00MB
    wp4c_relevanssi: Data: 0.00MB + Index: 0.00MB
    wp4c_relevanssi_log: Data: 0.00MB + Index: 0.00MB
    wp4c_relevanssi_stopwords: Data: 0.00MB + Index: 0.00MB
    wp4c_tdrd_redirection: Data: 0.12MB + Index: 0.01MB
    wp4c_termmeta: Data: 0.15MB + Index: 0.10MB
    wp4c_terms: Data: 0.18MB + Index: 0.32MB
    wp4c_term_relationships: Data: 2.88MB + Index: 5.18MB
    wp4c_term_taxonomy: Data: 0.21MB + Index: 0.18MB
    wp4c_usermeta: Data: 0.11MB + Index: 0.06MB
    wp4c_users: Data: 0.02MB + Index: 0.05MB
    wp4c_wc_download_log: Data: 0.00MB + Index: 0.00MB
    wp4c_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_termmeta: Data: 0.00MB + Index: 0.00MB
    wp4c_yoast_seo_links: Data: 0.25MB + Index: 0.08MB
    wp4c_yoast_seo_meta: Data: 0.18MB + Index: 0.17MB
    
    ### Post Type Counts ###
    
    aal_auto_insert: 2
    aal_button: 1
    amazon_auto_links: 2
    attachment: 22044
    content-locker: 2
    coupons: 1217
    custom_css: 1
    easy_affiliate_link: 5
    fetch_tweets: 3
    inc_popup: 1
    jp_img_sitemap: 13
    jp_img_sitemap_index: 1
    jp_sitemap: 4
    jp_sitemap_index: 1
    jp_sitemap_master: 1
    mts_notification_bar: 1
    nav_menu_item: 119
    oembed_cache: 84
    opanda-item: 4
    page: 23
    polylang_mo: 1
    post: 7949
    product: 12994
    pt_view: 1
    revision: 66
    safecss: 1
    schema: 2
    tablepress_table: 22
    thirstylink: 1
    wc_product_retailer: 20
    
    ### Security ###
    
    Secure connection (HTTPS): ❌
    					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
    Hide errors from visitors: ✔
    
    ### Active Plugins (16) ###
    
    Query Monitor: by John Blackbourn & contributors – 3.1.0
    Accelerated Mobile Pages: by Ahmed Kaludi
    Mohammed Kaludi – 0.9.97.8
    
    Akismet Anti-Spam: by Automattic – 4.0.8
    Bulk Move: by Sudar – 1.3.0
    Content Egg Pro: by keywordrush.com – 4.6.1
    Cuelinks - Affiliate Marketing Tool: by Cuelinks – 1.0.0
    Delete Expired Transients: by LittleBizzy – 1.0.2
    Jetpack by WordPress.com: by Automattic – 6.3.2
    MyThemeShop Connect: by MyThemeShop – 2.0
    SSL Insecure Content Fixer: by WebAware – 2.7.0
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.14.12
    
    W3 Total Cache: by Frederick Townes – 0.9.7
    WC Speed Drain Repair: by WP Fix It – 1.2 – Not tested with the active version of WooCommerce
    WooCommerce: by Automattic – 3.4.4
    Yoast SEO: by Team Yoast – 7.9
    WP External Links: by Victor Villaverde Laan – 2.2.0
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: INR (₹)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 0
    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)
    
    ### WC Pages ###
    
    Shop base: #3798 - /shop/
    Cart: #64935 - /cart/
    Checkout: #64936 - /checkout/
    My account: #3801 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: incognito
    Version: 1.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Coupon by MyThemeShop
    Parent Theme Version: 2.0.7
    Parent Theme Author URL: http://mythemeshop.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: mts_coupon/woocommerce/archive-product.php
    mts_coupon/woocommerce/single-product.php
    
    
Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘Search in dashboard’ is closed to new replies.