Wordpress/WooCommerce plugin to import customer reviews
We have a US site and some products have customer reviews. My manager exported them to an excel sheet for offshore to import them to our Canada site.
1. US site has different SKUs than Canada site. US site is in Java and not in WordPress
2. We have product Id we can use
3. We cutoff offshore so we have to do this ourselves
4. Offshore recommended this plugin https://www.webtoffee.com/how-to-import-export-woocommerce-product-reviews/
and they said we have to have SKUs because that's the required field for the plugin.
Before I go down the path of manually matching product Id or SKUs...is there a better plugin I can use? What is recommended? we kinda don't trust what offshore has suggested to us anymore.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@lenamtl's comment encapsulated this entire problem, "I'm not a fan of import/export tools as they may break the DB, but as Woo / WP DB is a mess I think I would use a plugin that depend of the qty and data."
How I've done this in the past is to produce text files, usually in the form of WordPress HTML-ish text, then use wp-cli to do a mass injection of all the products.
If the mass injection fails, destroy + recreate the database, fix the wp-cli wrapper script, then run again... repeat... until all posts (usually posts, sometimes pages) format as required.
Big Tip #1: Only do this type of work, whatever approach you take, on a pristine WordPress site first... so you can simply destroy/recreate the database or do a restore of a database, with no products.
Big Tip #2: If you have a large inventory, automate the process with a script.
If you have a small inventory, likely faster to just do a cut + paste clone from first site to the second site...
How I've done this in the past is to produce text files, usually in the form of WordPress HTML-ish text, then use wp-cli to do a mass injection of all the products.
If the mass injection fails, destroy + recreate the database, fix the wp-cli wrapper script, then run again... repeat... until all posts (usually posts, sometimes pages) format as required.
Big Tip #1: Only do this type of work, whatever approach you take, on a pristine WordPress site first... so you can simply destroy/recreate the database or do a restore of a database, with no products.
Big Tip #2: If you have a large inventory, automate the process with a script.
If you have a small inventory, likely faster to just do a cut + paste clone from first site to the second site...
ASKER
Thanks, guys. I'll try the plugins first on my local WP, not on QA.
>>then use wp-cli to do a mass injection of all the products.
It's not the products. It's the ratings that go with the products.
>>then use wp-cli to do a mass injection of all the products.
It's not the products. It's the ratings that go with the products.
Hi,
There will be another problem as usually reviews is linked to a user ID not only to a product.
Another solution would be to start from fresh and not importing all old reviews or keep only recent ones.
Make sure you have the user authorisation to display the user real name on the new store or marsk the family name
Jane Doe become Jane D. or J.D.
I turn off user reviews on WP/Woo for many reasons, security reason and store owner does not have the time to manage this. I do not read reviews except on very big site like Amazon.
Make sur to install Google reCaptcha ...
There will be another problem as usually reviews is linked to a user ID not only to a product.
Another solution would be to start from fresh and not importing all old reviews or keep only recent ones.
Make sure you have the user authorisation to display the user real name on the new store or marsk the family name
Jane Doe become Jane D. or J.D.
I turn off user reviews on WP/Woo for many reasons, security reason and store owner does not have the time to manage this. I do not read reviews except on very big site like Amazon.
Make sur to install Google reCaptcha ...
ASKER
>>There will be another problem as usually reviews is linked to a user ID not only to a product.
Yes, I read that in the plugin doc offshore has recommended.
>>Another solution would be to start from fresh and not importing all old reviews or keep only recent ones.
My manager says the new site will look more authentic and real and appealing if we have reviews for products. They are US customer reviews and not Canada but they still want them on the Canada site.
>>Make sur to install Google reCaptcha ...
I'll see how our US site works and mention it to my manager.
Yes, I read that in the plugin doc offshore has recommended.
>>Another solution would be to start from fresh and not importing all old reviews or keep only recent ones.
My manager says the new site will look more authentic and real and appealing if we have reviews for products. They are US customer reviews and not Canada but they still want them on the Canada site.
>>Make sur to install Google reCaptcha ...
I'll see how our US site works and mention it to my manager.
You will see that Avada has a general review option. Again, my take is much different. I agree with your manager, reviews are important and should be used. They don't have to be tied to a person or even a product. My preference is to have an array (or database) of the reviews and use your php code to show a random x amount of reviews at a time on just one page so the page is not always the same.
Woo does have the option for live reviews and I would just use the option or verified purchases. When people can tell they are real and not all good, it is more believable.
Woo does have the option for live reviews and I would just use the option or verified purchases. When people can tell they are real and not all good, it is more believable.
ASKER
We have the option for reviews turned on. I'll look at the links and see what I can do to import the existing reviews from our US site to the Canada site.
ASKER
Only this one is for importing data https://www.wpallimport.com/
Another one I found https://wpsheeteditor.com/woocommerce-import-product-reviews/
The rest are plugins for "reviews". We already have "reviews" turned on. I was looking for another import-plugin other than what offshore had suggested it.
Another one I found https://wpsheeteditor.com/woocommerce-import-product-reviews/
The rest are plugins for "reviews". We already have "reviews" turned on. I was looking for another import-plugin other than what offshore had suggested it.
But your question was about importing reviews?
What is it about the plugin the original developers suggested is not working? or the one you pointed it. I have used different plug ins for importing in the past and always just started at the WP plugin search https://wordpress.org/plugins/ and used the one with the top used plugins, with good reviews and was updated recently. Never had any issues.
The one you just pointed to has a trial. That is really the best way to go about it and see how it works. I have not had to import any data in the past 18 months and what I may have used back then is different now. You do also have export/import options within Avada, but that is for specific pages or templates that you create.
It sounds like your requirement may have changed though.
What is it about the plugin the original developers suggested is not working? or the one you pointed it. I have used different plug ins for importing in the past and always just started at the WP plugin search https://wordpress.org/plugins/ and used the one with the top used plugins, with good reviews and was updated recently. Never had any issues.
The one you just pointed to has a trial. That is really the best way to go about it and see how it works. I have not had to import any data in the past 18 months and what I may have used back then is different now. You do also have export/import options within Avada, but that is for specific pages or templates that you create.
It sounds like your requirement may have changed though.
ASKER
>>It sounds like your requirement may have changed though.
No, it hasn't. I want to import reviews. I think I misunderstood one of the links.
>>What is it about the plugin the original developers suggested is not working?
The one offshore has suggested has SKU as a required field. We want to go by Product info. At least that's what they told us but I need to verify it for myself.
I'll look into this more. Thanks for all the help.
No, it hasn't. I want to import reviews. I think I misunderstood one of the links.
>>What is it about the plugin the original developers suggested is not working?
The one offshore has suggested has SKU as a required field. We want to go by Product info. At least that's what they told us but I need to verify it for myself.
I'll look into this more. Thanks for all the help.
ASKER