• Resolved elaxxl

    (@elaxxl)


    Hi there,

    I need products to be found/displayed based upon words/numbers when people use the search function.

    These products allready have all these numbers as variations (in this case different colors of paint) but when you type any of these numbers/words the corresponding products do not appear…
    I also gave 1 of them all tags with these numbers but still no results.
    How can i make this happen?

    Thank you in advance.

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support wpnomad a11n

    (@wpnomad)

    Hi @elaxxl,

    I also gave 1 of them all tags with these numbers but still no results.
    How can i make this happen?

    That’s strange, the tags should ideally show up in search result. For us to check this, 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.

    Do let us know so we can help further.

    Thread Starter elaxxl

    (@elaxxl)

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://spuitbuswinkel.nl
    Site address (URL): https://spuitbuswinkel.nl
    WC Version: 4.0.1
    REST API Version: ? 1.0.7
    WC Blocks Version: ? 2.5.14
    Action Scheduler Version: ? 3.1.4
    WC Admin Version: ? 1.0.3
    Log Directory Writable: ?
    WP Version: ? 5.3.2 - Er is een nieuwere versie van WordPress beschikbaar (5.4)
    WP Multisite: –
    WP Memory Limit: 2 GB
    WP Debug Mode: –
    WP Cron: ?
    Language: nl_NL
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2
    PHP Version: 7.3.16
    PHP Post Max Size: 2 GB
    PHP Time Limit: 120
    PHP Max Input Vars: 1000
    cURL Version: 7.62.0
    OpenSSL/1.0.2k
    
    SUHOSIN Installed: –
    MySQL Version: 10.2.31-MariaDB-cll-lve
    Max Upload Size: 2 GB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 3.8.1
    WC Database Prefix: wp_
    Totale databasegrootte: 7.98MB
    Database datagrootte: 6.20MB
    Database index grootte: 1.78MB
    wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 3.02MB + Index: 0.06MB + Engine InnoDB
    wp_postmeta: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
    wp_posts: Data: 0.33MB + Index: 0.13MB + Engine InnoDB
    wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_supsystic_tbl_columns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_supsystic_tbl_diagrams: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_supsystic_tbl_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_supsystic_tbl_tables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.03MB + Index: 0.09MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 238
    custom_css: 1
    customize_changeset: 40
    hbupro_banner: 1
    nav_menu_item: 33
    page: 10
    post: 2
    product: 9
    product_variation: 159
    revision: 28
    scheduled-action: 1
    tablepress_table: 1
    woo_discount: 2
    woo_discount_cart: 1
    wpcf7_contact_form: 1
    wpforms: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    					Jouw winkel gebruikt geen HTTPS. Leer meer over HTTPS en SSL-certificaten.
    Hide errors from visitors: ?
    
    ### Active Plugins (12) ###
    
    Contact Form 7: door Takayuki Miyoshi – 5.1.7
    Duplicate Page: door mndpsingh287 – 4.2
    GP Premium: door Tom Usborne – 1.10.0
    Quick Page/Post Redirect Plugin: door anadnet – 5.1.9
    WooCommerce Sisow Betaal Opties: door Sisow – 5.4.7
    TablePress: door Tobias B?thge – 1.11
    WooCommerce Weight Based Shipping: door weightbasedshipping.com – 5.3.4
    Woo Discount Rules: door Flycart Technologies LLP – 1.9.7
    Variation Swatches for WooCommerce: door Emran Ahmed – 1.0.80
    WooCommerce MyParcel: door Adem Demir – 3.2.0 – Niet getest met de actieve versie van WooCommerce
    WooCommerce Services: door Automattic – 1.23.0
    WooCommerce: door Automattic – 4.0.1
    
    ### Inactive Plugins (3) ###
    
    Classic Editor: door WordPress Contributors – 1.5
    Jetpack by WordPress.com: door Automattic – 8.4.2
    Spuitbuswinkel custom PHP: door  –
    
    ### 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 ###
    
    Winkelbasis: #8 - /
    Winkelmand: #9 - /cart/
    Afrekenen: #10 - /checkout/
    Mijn account: #11 - /my-account/
    Algemene voorwaarden: #69 - /algemene-voorwaarden/
    
    ### Theme ###
    
    Name: GeneratePress
    Version: 2.4.2
    Author URL: https://tomusborne.com
    Child Theme: ? – Als je wijzigingen aanbrengt in WooCommerce of in een hoofdthema dat je niet zelf gebouwd hebt
    raden we het gebruik van een child thema aan. Zie: Hoe maak je een child thema
    
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    In afwachting: 4
    Oldest: 2019-11-13 11:07:39 +0000
    Newest: 2020-04-22 15:23:41 +0000
    
    Geannuleerd: 1
    Oldest: 2019-11-13 11:11:48 +0000
    Newest: 2019-11-13 11:11:48 +0000
    
    
    Thread Starter elaxxl

    (@elaxxl)

    The site is not yet live, only accesible by putting the server IP address and domain name in your computers hostfile, i can provide this if needed.

    Plugin Support wpnomad a11n

    (@wpnomad)

    Hi @elaxxl ,

    Thanks for sending the status report. I see that your site has WooCommerce database version mismatch as seen in the screenshot:


    Link to image: https://i.ibb.co/2vnCZtz/db-version-issue.png

    Can you please go to WP Admin → WooCommerce → Status → Tools and select the Upgrade Database option from there?

    That should update your database. Once it is updated, please check and see if searching by tag works.

    Thread Starter elaxxl

    (@elaxxl)

    Hi there,

    Sorry for the late reply.
    Yes i know but i says that it has been updating the database now for over 3 weeks..
    Anyway to fix/complete the process?

    Thank you.

    Thread Starter elaxxl

    (@elaxxl)

    Hello there,

    I deleted the current que and started updating again but still it stays updating the database for 4 days now..
    How can we fix this?
    Normally it takes minutes and i need it to work offcourse.

    Thread Starter elaxxl

    (@elaxxl)

    Could we please get some help?
    Thank you.

    Thread Starter elaxxl

    (@elaxxl)

    Hello??? Come on some help shouldnt take weeks..

    Thread Starter elaxxl

    (@elaxxl)

    Opened a new one and the solution in 1 hour, for others who might have the same issue read this topic: https://www.ads-software.com/support/topic/search-results-based-upon-using-tags-2/

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Search results based upon/using tags’ is closed to new replies.