Support » Plugin: WooCommerce » Migrating from one domain to another results with reviews leftover

  • Resolved ars111

    (@ars111)


    Hi,

    Do you maybe know why when I migrated webshop from one url to new one (one without any reviews) after I deleted all previously added reviews, there are still number of reviews for product pages that have previously reviews added (even thought I deleted them from a database itself)? Is there any way to delete (remove cache) of all reviews that are not on this product pages? I want this to be exact but because of previously added reviews on another shop this is not exact but is showing the same old number of reviews that was here before I deleted them.

    I’ve posted this here: https://wordpress.org/support/topic/migrating-from-one-domain-to-another-results-with-reviews-leftover/ but plugin devs said that this is pure woocommerce.com issue. How this can be truncated so it does not affect current reviews that are actually in database?

    Thank you.

Viewing 15 replies - 1 through 15 (of 17 total)
  • Hello,

    If you would like to clear the cache, please check:
    https://wordpress.com/support/clear-your-sites-cache/

    If that does not work please provide a URL to the product that is showing the issue.

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

    Please let us know.

    Thread Starter ars111

    (@ars111)

    Hi,

    Even before you give me this hint, I’ve cleared all cache – browser, website, cloudflare… and nothing is changed at all. So I’m posting system report here:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://outbackmotortek.ca
    Site address (URL): https://outbackmotortek.ca
    WC Version: 6.5.1
    REST API Version: ✔ 6.5.1
    WC Blocks Version: ✔ 7.4.3
    Action Scheduler Version: ✔ 3.4.0
    Log Directory Writable: ✔
    WP Version: 6.0
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 8.0.19
    PHP Post Max Size: 50 MB
    PHP Time Limit: 180
    PHP Max Input Vars: 6144
    cURL Version: 7.83.1
    OpenSSL/1.1.1o
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.38
    Max Upload Size: 10 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.5.1
    WC Database Prefix: outb_wp_
    Total Database Size: 123.65MB
    Database Data Size: 101.98MB
    Database Index Size: 21.67MB
    outb_wp_woocommerce_sessions: Data: 0.07MB + Index: 0.00MB + Engine MyISAM
    outb_wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    outb_wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    outb_wp_woocommerce_order_items: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
    outb_wp_woocommerce_order_itemmeta: Data: 0.25MB + Index: 0.18MB + Engine MyISAM
    outb_wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    outb_wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    outb_wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    outb_wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_actionscheduler_actions: Data: 10.52MB + Index: 5.56MB + Engine InnoDB
    outb_wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_actionscheduler_logs: Data: 5.52MB + Index: 3.03MB + Engine InnoDB
    outb_wp_ac_abandoned_cart_history_lite: Data: 0.36MB + Index: 0.01MB + Engine MyISAM
    outb_wp_ac_email_templates_lite: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_ac_guest_abandoned_cart_history_lite: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    outb_wp_ac_sent_history_lite: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_brb_business: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_brb_review: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    outb_wp_comments: Data: 0.16MB + Index: 0.07MB + Engine MyISAM
    outb_wp_error: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    outb_wp_icl_languages_translations: Data: 0.19MB + Index: 0.09MB + Engine InnoDB
    outb_wp_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    outb_wp_icl_mo_files_domains: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    outb_wp_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_icl_strings: Data: 0.44MB + Index: 0.41MB + Engine InnoDB
    outb_wp_icl_string_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_icl_string_packages: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    outb_wp_icl_string_positions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_icl_string_translations: Data: 0.20MB + Index: 0.03MB + Engine InnoDB
    outb_wp_icl_translate: Data: 6.52MB + Index: 0.34MB + Engine InnoDB
    outb_wp_icl_translate_job: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    outb_wp_icl_translations: Data: 1.52MB + Index: 2.61MB + Engine InnoDB
    outb_wp_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_icl_translation_status: Data: 7.52MB + Index: 0.14MB + Engine InnoDB
    outb_wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_options: Data: 13.13MB + Index: 0.20MB + Engine MyISAM
    outb_wp_postmeta: Data: 35.66MB + Index: 3.94MB + Engine MyISAM
    outb_wp_posts: Data: 4.69MB + Index: 0.91MB + Engine MyISAM
    outb_wp_pps_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_pps_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_pps_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_pps_popup: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    outb_wp_pps_popup_show_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_pps_popup_show_pages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_pps_statistics: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    outb_wp_pps_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_pps_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_stock_log: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    outb_wp_termmeta: Data: 0.49MB + Index: 0.09MB + Engine MyISAM
    outb_wp_terms: Data: 0.03MB + Index: 0.07MB + Engine MyISAM
    outb_wp_term_relationships: Data: 0.14MB + Index: 0.28MB + Engine MyISAM
    outb_wp_term_taxonomy: Data: 0.07MB + Index: 0.04MB + Engine MyISAM
    outb_wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    outb_wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_usermeta: Data: 4.05MB + Index: 0.34MB + Engine MyISAM
    outb_wp_users: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
    outb_wp_wcpdf_credit_note_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_wcpdf_packing_slip_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_wcpdf_proforma_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    outb_wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_wc_customer_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    outb_wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    outb_wp_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    outb_wp_wc_order_stats: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
    outb_wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    outb_wp_wc_product_attributes_lookup: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    outb_wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_wc_product_meta_lookup: Data: 0.07MB + Index: 0.07MB + Engine MyISAM
    outb_wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_wf301_404_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_wf301_linkhero: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_wf301_redirect_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_wf301_redirect_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_woocommerce_termmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    outb_wp_woodmart_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_woodmart_wishlist_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    outb_wp_wpmailsmtp_tasks_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    outb_wp_yoast_indexable: Data: 6.52MB + Index: 1.75MB + Engine InnoDB
    outb_wp_yoast_indexable_hierarchy: Data: 0.36MB + Index: 0.42MB + Engine InnoDB
    outb_wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    outb_wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    outb_wp_yoast_seo_links: Data: 0.34MB + Index: 0.08MB + Engine MyISAM
    outb_wp_yoast_seo_meta: Data: 0.07MB + Index: 0.07MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    amp_validated_url: 7
    attachment: 10558
    br_labels: 2
    brb_collection: 1
    cms_block: 116
    custom_css: 2
    customize_changeset: 1
    cwginstocknotifier: 200
    mailpoet_page: 1
    mc4wp-form: 1
    nav_menu_item: 183
    oembed_cache: 23
    page: 47
    post: 10
    product: 286
    product_variation: 586
    revision: 25
    shop_order: 181
    shop_order_refund: 40
    was: 1
    wccc: 40
    woodmart_sidebar: 2
    woodmart_slide: 11
    wp_global_styles: 1
    wpcf7_contact_form: 2
    wysijap: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (40) ###
    
    WPML Multilingual CMS: by OnTheGoSystems – 4.5.5
    WPML SEO: by OnTheGoSystems – 2.0.1
    AMP: by AMP Project Contributors – 2.2.4
    Antispam Bee: by pluginkollektiv – 2.11.0
    Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 2.7
    Business Reviews Bundle: by RichPlugins  – 1.9
    Contact Form 7 Multilingual: by OnTheGoSystems – 1.1.0
    Contact Form 7: by Takayuki Miyoshi – 5.5.6.1
    Customer Reviews for WooCommerce: by CusRev – 4.40
    Add-on: Ban Emails - Back In Stock Notifier for WooCommerce: by codewoogeek – 1.0
    Add-on: Custom CSS - Back In Stock Notifier for WooCommerce: by codewoogeek – 1.6
    Add-on: Double Opt-In - Back In Stock Notifier for WooCommerce: by codewoogeek – 1.7
    Add-on: Edit Subscribers - Back In Stock Notifier for WooCommerce: by codewoogeek – 1.1
    Add-on: Export CSV - Back In Stock Notifier for WooCommerce: by codewoogeek – 1.1
    Add-on: Track Sales - Back In Stock Notifier for WooCommerce: by codewoogeek – 1.2
    Add-on: Unsubscribe - Back In Stock Notifier for WooCommerce: by codewoogeek – 1.2
    Add-on: WPML - Back In Stock Notifier for WooCommerce: by codewoogeek – 2.0
    WooCommerce Discontinued Products: by Leon @ 211J – 1.1.5
    Duplicate Page: by mndpsingh287 – 4.4.8
    Insert Headers and Footers: by WPBeginner – 1.6.2
    WPBakery Page Builder: by Michael M - WPBakery.com – 6.9.0
    reSmush.it Image Optimizer: by reSmush.it – 0.4.2
    Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 5.12.0
    WooCommerce Conditional Content: by Lucas Stark – 2.1.8
    WooCommerce Stripe Gateway: by WooCommerce – 6.4.0
    WooCommerce Multilingual: by OnTheGoSystems – 4.12.6
    WooCommerce PayPal Payments: by WooCommerce – 1.8.0
    WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.14.5
    WooCommerce Sales Analysis: by itthinx – 1.12.0
    Stock Manager for WooCommerce: by StoreApps – 2.8.3
    WooCommerce: by Automattic – 6.5.1
    Woodmart Core: by  – 1.0.33
    Yoast SEO: by Team Yoast – 18.9
    WP Mail SMTP: by WPForms – 3.4.0
    WP-Optimize - Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.2.3
    
    WP reCaptcha Integration: by weDevs – 1.2.5
    WP Video Popup PRO: by David Vongries – 2.9
    WPML Sticky Links: by OnTheGoSystems – 1.5.4
    WPML String Translation: by OnTheGoSystems – 3.2.1
    WPS Hide Login: by WPServeur
    NicolasKulka
    wpformation – 1.9.6
    
    ### Inactive Plugins (5) ###
    
    Display PHP Version: by David Gwyer – 1.7
    Popup by Supsystic: by supsystic.com – 1.10.13
    WooCommerce Backorder Manager: by jeffrey-wp – 2.3
    WooCommerce Payments: by Automattic – 4.2.0
    WPML Media: by OnTheGoSystems – 2.7.0
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: ✔
    Currency: CAD ($)
    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)
    outofstock (outofstock-de)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    rated-5 (rated-5-de)
    
    Connected to WooCommerce.com: ✔
    Enforce Approved Product Download Directories: –
    
    ### WC Pages ###
    
    Shop base: #4 - /shop/
    Cart: #5 - /cart/
    Checkout: #6 - /checkout/
    My account: #7 - /my-account/
    Terms and conditions: #5059 - /terms-conditions/
    
    ### Theme ###
    
    Name: Woodmart Child
    Version: 1.0.0
    Author URL: http://xtemos.com
    Child Theme: ✔
    Parent Theme Name: Woodmart
    Parent Theme Version: 6.4.2
    Parent Theme Author URL: http://themeforest.net/user/xtemos
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: woodmart/woocommerce/archive-product.php
    woodmart/woocommerce/cart/cart-item-data.php
    woodmart/woocommerce/cart/cart.php
    woodmart/woocommerce/cart/cross-sells.php
    woodmart/woocommerce/cart/mini-cart.php
    woodmart/woocommerce/checkout/form-checkout.php
    woodmart/woocommerce/checkout/thankyou.php
    woodmart/woocommerce/content-product-cat.php
    woodmart/woocommerce/content-product.php
    woodmart/woocommerce/content-single-product.php
    woodmart/woocommerce/content-widget-product.php
    woodmart/woocommerce/global/breadcrumb.php
    woodmart/woocommerce/global/form-login.php
    woodmart/woocommerce/global/quantity-input.php
    woodmart/woocommerce/loop/add-to-cart.php
    woodmart/woocommerce/loop/loop-end.php
    woodmart/woocommerce/loop/loop-start.php
    woodmart/woocommerce/loop/no-products-found.php
    woodmart/woocommerce/loop/orderby.php
    woodmart/woocommerce/loop/pagination.php
    woodmart/woocommerce/loop/sale-flash.php
    woodmart/woocommerce/myaccount/form-login.php
    woodmart/woocommerce/product-searchform.php
    woodmart/woocommerce/single-product/add-to-cart/grouped.php
    woodmart/woocommerce/single-product/add-to-cart/variable.php
    woodmart/woocommerce/single-product/meta.php
    woodmart/woocommerce/single-product/product-attributes.php
    woodmart/woocommerce/single-product/product-image.php
    woodmart/woocommerce/single-product/product-thumbnails.php
    woodmart/woocommerce/single-product/rating.php
    woodmart/woocommerce/single-product/related.php
    woodmart/woocommerce/single-product/sale-flash.php
    woodmart/woocommerce/single-product/tabs/description.php
    woodmart/woocommerce/single-product/tabs/tabs.php
    woodmart/woocommerce/single-product/title.php
    woodmart/woocommerce/single-product/up-sells.php
    woodmart/woocommerce/single-product.php
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: ✔
    Shop country code: CA
    WooCommerce currency supported: ✔
    PayPal card processing available in country: ✔
    Pay Later messaging available in country: –
    Webhook status: –
    Vault enabled: ✔
    Logging enabled: –
    Reference Transactions: –
    Used PayPal Checkout plugin: –
    
    ### Action Scheduler ###
    
    Complete: 20,327
    Oldest: 2022-05-01 09:47:09 +0000
    Newest: 2022-05-30 16:20:02 +0000
    
    Pending: 6
    Oldest: 2022-05-30 16:20:04 +0000
    Newest: 2022-05-30 16:34:05 +0000
    
    ### Status report information ###
    
    Generated at: 2022-05-30 12:20:04 -04:00
    
    Mashi

    (@shaonback2)

    Hello @ars111!

    Can you please clear WooCommerce transients from the WooCommerce → Status → Tools area and see if that helps?

    Thread Starter ars111

    (@ars111)

    I’ve tried this but nothing. It still shows number of reviews without a single review.

    Mirko P.

    (@rainfallnixfig)

    Hi there,

    Can you confirm the review count is zero for all post ids in the database? You have to access the _postmeta table and filter by meta_value.

    Make sure to have a full backup in place before changing values in the database. More info at: Backing up WordPress content.

    Thanks.

    Thread Starter ars111

    (@ars111)

    Hello,

    I’ve checked this but seems that all of them have been NULL.

    https://prnt.sc/jPY_r9uI5vWN

    Check my screenshot please.

    Hi @ars111! Thanks for sharing more details with us!

    Let’s break it down a bit, just to be sure that I am following it correctly!

    The issue you’re reporting is that even after deleting the reviews they are showing up on your (single) product page, is that correct?

    If so, I went ahead and checked your site and a product, for reference it’s the ../product/tool-box/

    Image link: https://snipboard.io/zANkJo.jpg

    If the issue is about that “3 reviews for toolbox” which seems to be none yet, while checking your source code, it seems to be coming from your theme (WoodMart).

    Can you try to make a conflict test, just to be on the safe side?

    The best way to determine this is to:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Repeat the action that is causing the problem
    • If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated.

      To figure out which plugin is causing the problem, 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.

      Let us know how it goes! All the best,

    Thread Starter ars111

    (@ars111)

    Hello, I’ve performed what you told me… I performed and check it together with theme developer support. Conclusion is, you are wrong! This is not theme problem but pure woocommerce problem. Feel free to check my attachment. That is screenshot from storefront theme on product that I posted. And it also said 60 reviews with no reviews inside.

    Is it possible to send this to tier 2 or someone else who is dealing with programming stuff?

    Screenshot for the reference: https://prnt.sc/549o9CCVIgoh

    Mirko P.

    (@rainfallnixfig)

    Hi @ars111,

    Thanks for the screenshot. It’s helpful.

    Can you please head over to your database _postmeta table and search meta_key _wc_review_count and post_id 578?

    You should see meta_value 7 and that’s the review count for your product Honda CRF1000L Africa Twin – Upper Crash Bars. You can edit the table and delete the value.

    To clarify, this is a free open forum where any WooCommerce user and volunteers can help.

    If you need personalized attention, you can hire a freelance at Codeable.

    License holders of paid extensions sold in the WooCommerce.com marketplace have access to Premium Support via WooCommerce.com > My Account > Support..

    Read more about our Support Policy at https://woocommerce.com/support-policy/.

    Best regards.

    • This reply was modified 1 year, 3 months ago by Mirko P..
    • This reply was modified 1 year, 3 months ago by Mirko P..
    Thread Starter ars111

    (@ars111)

    Hi Mirko,

    I tried that. Check the result: https://prnt.sc/fKGOjzRF2Sv9

    Now, that’s rude because I’m asking you to see about plugin that you created called Woocommerce. If there are problem with something else than that, I’ll surely contact professional about that. But here if there are problem with Wocommerce I cannot do much since it is plugin that whole community is working on. Hope you understand.

    • This reply was modified 1 year, 3 months ago by ars111.
    Mirko P.

    (@rainfallnixfig)

    Hi there,

    I’ve updated my comment above. Take a look at it and see if you can manage to locate the review count.

    Notice that you’d have to use outb_wp_postmeta as your database prefix is different from mine. Also, the meta_key should be _wcml_review_count for what I see on your screenshot.

    This doesn’t have much to do with WooCommerce core itself. As mentioned earlier, data is stored in the _postmeta table which is a WordPress database table and not a WooCommerce database table. Here you can see a list of tables included with WooCommerce.

    https://github.com/woocommerce/woocommerce/wiki/Database-Description

    If the meta_value still appears as NULL instead of 7 there is something wrong that needs to be fixed on your DB or it’s due to a cache issue on your site. We don’t provide database support and it’s a bit out of scope on this forum. You may want to consult a database professional if you need further assistance to resolve this issue.

    Thanks.

    Thread Starter ars111

    (@ars111)

    I’ve updated my comment too.

    Thread Starter ars111

    (@ars111)

    Just for the record, what ever I put inside it gives me the same output. And btw. I’ve searched for same term manually (as you collegue suggested) and I’ve found none (and it is easy to search it via tables via phpmyadmin).

    Mirko P.

    (@rainfallnixfig)

    Hi @ars111,

    Can you give us feedback on this?

    If the meta_value still appears as NULL instead of 7 there is something wrong that needs to be fixed on your DB

    What do your see next to _wc_review_count in your outb_wp_postmeta table filtering for post_id 578?

    Thread Starter ars111

    (@ars111)

    Thank you for your reply.

    If I put post_id to be 578 then result is this:

    https://prnt.sc/7k4b4IZD0WJu
    https://prnt.sc/gIuTtUYxd5jr

    What do you think? I’ve edited what I uploaded.

    Thank you and I really do appreciate your help.

    • This reply was modified 1 year, 3 months ago by ars111.
Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘Migrating from one domain to another results with reviews leftover’ is closed to new replies.