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, 1 month ago by  masternikos.
Viewing 4 replies - 16 through 19 (of 19 total)
  • Abdul Samad

    (@abdul-samad-k-t)

    I also have the same issue. Is there any solution, please?

    Abdul Samad

    (@abdul-samad-k-t)

    I also have the same issue. Is there any solution?

    no solution yet… tried almost everything available online 🙁

    If i run the following query on the SQL DB manually, it looses the connection.

    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

    If i just run it on post.title it works, looks like all those joins are making it fail….

    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%’) ORDER BY posts.post_parent ASC, posts.post_title ASC

    • This reply was modified 10 months, 4 weeks ago by  techjockey.

    The same issue. Made the downgrade from 3.5.1 to 3.3.0 and the search is working fine…

    • This reply was modified 8 months, 3 weeks ago by  antondrob.
    • This reply was modified 8 months, 3 weeks ago by  antondrob.
Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘Search in dashboard’ is closed to new replies.