Duplicated Woocommerce Reviews

  • Resolved lamayas

    (@lamayas)


    3 years, 3 months ago

    Hello,

    I recently installed the plugin and imported my reviews from Woocommerce but I see several duplicated reviews. Is this a common issue?

    If I delete just the duplicated ones and repeat the import in the future, will they duplicate again?

    Thanks in advance.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Gemini Labs

    (@geminilabs)

    3 years, 3 months ago

    It shouldn’t be duplicating reviews.

    1. Did you use the “Import Product Reviews” tool?
    2. How many product reviews are there?
    3. Can you confirm that there are no duplicate product reviews in WooCommerce?

    Please try deleting the imported reviews in Site Reviews (and empty the trash!). Once you have done that, try importing them again using the “Import Product Reviews” tool.

    Thread Starter lamayas

    (@lamayas)

    3 years, 3 months ago

    Hi there,

    I did verify if they were duplicated on Woocommerce and they weren’t, I am using the Import Product Reviews option.

    The duplicated ones were only a few and after reimporting they’re not duplicated anymore but I can’t see all of them.

    Only 287 appear and I have 349 approved reviews on Woocommerce. I keep running the import again but I get a 0 imported reviews.

    Thanks for your help.

    Plugin Author Gemini Labs

    (@geminilabs)

    3 years, 3 months ago

    So this is how the Import Product Reviews tool works:

    1. Site Reviews searches the comments table in your database for reviews (WooCommerce saves reviews as comments).
    2. Any WooCommerce reviews that do not have the imported meta_key are imported into Site Reviews.
    3. Once a review has been imported, Site Reviews adds the imported meta_key to the WooCommerce review to prevent it from being imported again. This is what prevents duplicate reviews.

    Keep in mind that Site Reviews will only import the original WooCommerce reviews, but it will not import replies to those reviews.

    The review count in WooCommerce includes the review replies.

    The reason Site Reviews does not import review replies is because comments can have multi-threaded replies whereas reviews in Site Reviews can only have a single reply. Also, anyone can reply to a comment (i.e. WooCommerce review), so there is no way to ensure that your reply to a review is being imported and not someone else’s (in cases where a review has multiple replies).

    If you would like to redo the import to ensure that you have imported absolutely all of your WooCommerce reviews (minus the replies), then this is how to do it:

    1. Delete all of the reviews that you previously imported into Site Reviews and then empty the trash.
    2. Install the Code Snippets plugin
    3. Create a new snippet using the following code: https://pastebin.com/dqJNkzsX
    4. Activate the code snippet (it will run immediately after activation) and then deactivate it. The code snippet will delete all of the imported meta_keys from your commentmeta database table, allowing Site Reviews to import them again.
    5. Run the Import Product Reviews tool.

    If you followed the steps above correctly, all of your WooCommerce reviews should be imported into Site Reviews.

    If the number of imported reviews does not match the number of reviews in WooCommerce, it’s likely because some of those WooCommerce “reviews” were actually replies.

    Thread Starter lamayas

    (@lamayas)

    3 years, 3 months ago

    Thank you for the detailed response! I see now that some of them are replies.

    The snippet worked and I was able to re-import without duplicates.

    Thanks for your help.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Duplicated Woocommerce Reviews’ is closed to new replies.