Transfer Reviews to New Site

  • Resolved gggreggg

    (@gggreggg)


    3 years, 11 months ago

    We would like to transfer reviews to a new site. The “Export” feature in Customer Reviews for WooCommerce fails on attempting to export the first review.

    We have successfully transferred the “users” and “usermeta” tables from the database such that they’re showing up under “Comments” in WP. However, they are not linked to the Customer Reviews for WooCommerce reviews and do no show up in under the Review tab for individual products.

    Is there meta data in the database we can transfer or otherwise? Could the fact that we changed the product names be an issue?

    Thank you for your help.

    • This topic was modified 3 years, 11 months ago by gggreggg.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author cusrev

    (@ivole)

    Thanks for trying our plugin!

    Can you please share more details about the problem with export of reviews? Are there any JavaScript errors? Or perhaps, there is something in PHP error log?

    Our plugin uses the standard WooCommerce reviews format. It doesn’t store any review data in the “users” or “usermeta” tables.

    Thread Starter gggreggg

    (@gggreggg)

    Thank you for offering to help. After clicking to export, it says “Export is in progress (0/201 are completed). A few seconds later, and the message “Export failed” is displayed. I tried enabling WP_Debug in wp-config.php, but no error log was generated.

    Having said this, I did figure out how to transfer all the comments (includes product reviews) using phpMyAdmin. My notes are below. Thanks again for your offer of help ??

    Transfer Comments/Product Reviews
    1. New Site: install “Customer Reviews for WooCommerce” plugin.
    2. phpMyAdmin: select _comments>Export>Custom>Add Create Table & Add Create Procedure>Go
    3. phpMyAdmin: select _metacomments>Export>Custom>Add Create Table & Add Create Procedure>Go
    4. In new database, delete all entries in _comments and _metacomments.
    5. In new database, select _comments and Import .sql file. Repeat for _metacomments.
    6. Find the product IDs in on Old site and new site – point to each Woo product to see ID displayed below.
    7. phpMyAdmin New Site: select _database>Search>enter old product and select Exact Match Whole Field and all tables.
    8. Under _comments and _metacomments change the old product ID to the new product ID – simply double click entry to change.
    9. Repeat steps 7 and 8 for each product.
    10. On the old site, record the number of reviews for each product – Review tab on each product page.
    11. phpMyAdmin New Site: select _database>Search>wc_review_count and select At Least One Word and all tables.
    12. Under _postmeta, change the “metadata” (review count) based upon the new product IDs – simply double click entry to change.

    • This reply was modified 3 years, 11 months ago by gggreggg.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Transfer Reviews to New Site’ is closed to new replies.