wp all import review: 5 Powerful Reasons It’s the Best 2025

Import Reviews to WooCommerce Like a Pro

WP All Import Review Summary:
* Rating: 4.7/5 stars (based on 1,800+ reviews)
* Active Installs: 100,000+
* Best For: Importing WooCommerce reviews, products, users from CSV, XML, or Excel
* Pricing: Core plugin starts at $199/yr; WooCommerce add-on at $169/yr
* Key Features: Drag & drop interface, automatic scheduling, PHP function editor
* Pros: Handles large datasets, extensive plugin compatibility, detailed logs
* Cons: Steeper learning curve, higher upfront cost

Ever spent hours manually copying product reviews into your WooCommerce store? I’ve been there, and it’s not fun. That’s where WP All Import review tools come to the rescue. As someone who’s worked with WordPress sites for over 15 years, I can tell you this plugin has saved me (and my clients) countless headaches.

What makes WP All Import special is its incredible flexibility. Whether you need to import 10 reviews or 10,000, the process remains straightforward. Got reviews stored in CSV files? Excel spreadsheets? XML feeds? Even Google Sheets? No problem – WP All Import handles them all with equal ease.

The visual interface is where this tool really shines. Instead of puzzling over which field goes where, you simply drag and drop your data columns to match WooCommerce’s review structure. It’s like having training wheels for data migration!

For review imports specifically, WP All Import offers features you won’t find elsewhere. Need to match reviews to products using SKUs? Done. Want to preserve parent-child review threads? Easy. Need to maintain star ratings and verification status? Absolutely covered.

I’ve used this tool with clients ranging from small boutiques to major online retailers, and it scales beautifully. The batch size adjustments mean even shared hosting environments can handle substantial review imports without timing out.

Is there a learning curve? Yes. Is the investment worth it? Absolutely. When clients ask me how to preserve their hard-earned customer feedback during site migrations, WP All Import review processes are always my first recommendation. The upfront cost pays for itself the first time you need to import thousands of reviews without losing a single star rating or customer comment.

At wpOncall, we’ve helped numerous businesses migrate their valuable customer testimonials between systems. The peace of mind that comes from knowing your reviews are safely transferred – with all their metadata intact – is priceless for store owners who understand how critical social proof is for conversions.

Want to learn more about WordPress plugins and how they can improve your site? Check out our guides on Plugin reviews WordPress and importing Google reviews to WordPress.

WooCommerce Reviews 101

Let’s take a moment to understand what makes WooCommerce reviews tick before we jump into importing them. There’s a bit more going on behind the scenes than you might expect!

When customers leave those precious star ratings on your products, WooCommerce doesn’t treat them like regular comments. Yes, they live in the same WordPress wp_comments table as other comments, but they’re special creatures with their own unique characteristics.

Think of each review as having a little backpack of extra information that makes it valuable to your store:

The rating itself (those all-important 1-5 stars) gets stored as comment meta data – this is what creates those visual stars your customers love to see. Each review also carries an approval status flag that tells WooCommerce whether to display it (approved = 1) or hold it for moderation (pending = 0).

Another crucial bit of metadata is the verified status – that reassuring “Verified Purchase” badge that tells other shoppers this reviewer actually bought the product. Reviews can also have parent/child relationships, allowing conversations to develop when you or other customers reply to reviews.

Perhaps most importantly, each review needs a proper product association – it needs to know exactly which product it belongs to. Without this connection, the review simply has nowhere to live!

When importing reviews with WP All Import review tools, you’ll need to map your data to match this structure. The product association is particularly tricky – you can link reviews using:

• Product ID (the most direct method)
• Product name (works but can be problematic with duplicate names)
• Product SKU (requires a bit of custom code but often the most reliable)

I’ve seen many imports fail because of product association issues. If WP All Import review can’t find the matching product, you’ll see an error like this in your logs:

[15:59:10] SKIPPED: Review product not found by id `ROSÉ FAVORI 2020 - FAVORI - IGP MEDITERANEE`

Some reviews also contain custom fields – additional metadata that might be specific to your store or theme. These need special attention during imports to ensure nothing gets lost.

Understanding this underlying structure isn’t just technical trivia – it’s the foundation for a successful review import. When you know how WooCommerce organizes reviews in the database, you can prepare your import file correctly and troubleshoot any issues that pop up along the way.

WP All Import Review: Feature Deep Dive & Real User Praise

When I first finded WP All Import review capabilities for WooCommerce, I was honestly blown away by how it transforms the tedious task of data migration into something almost enjoyable. At its heart is a visual drag-and-drop interface that makes mapping complex data fields feel like child’s play.

The numbers speak for themselves – this plugin boasts an impressive 4.7-star rating from over 1,800 reviews and has been acceptd by more than 100,000 active users. This kind of widespread adoption isn’t just luck – it reflects genuine user satisfaction. As one happy customer on WordPress.org put it:

“I’ve imported hundreds of items into WooCommerce with ease. I also love their support.”

Another user’s experience mirrors what I’ve found working with clients:

“I’ve tried so many import/export plugins and WP All Import is the best. It’s easy to use right away.”

What makes WP All Import review imports truly shine are thoughtful features that solve real problems. The built-in PHP function editor lets you transform and format data on the fly – perfect for cleaning up messy review text or standardizing dates. When things don’t go as planned (and let’s be honest, with data imports, that happens!), the detailed logging becomes your best friend, showing exactly what happened with each record.

I particularly love how the plugin intelligently detects custom fields without manual setup, saving hours of configuration time. For reviews specifically, it preserves all the crucial bits like star ratings, verified purchase badges, and those parent-child relationships when customers reply to each other.

One small but mighty feature: the option to block email notifications during imports. Trust me, your customers will thank you for not flooding their inbox with notifications about their year-old reviews suddenly “appearing” on your site!

Whether you’re bringing in 10 reviews or 10,000, the process stays remarkably consistent. For larger imports, you can simply tweak the batch size in advanced settings to match your server’s capabilities – a lifesaver when working with shared hosting environments.

WP All Import Review vs Native WooCommerce Importer

I’ve used both tools extensively, and while WooCommerce’s built-in importer is handy for basic product imports, it simply falls flat when dealing with reviews. Here’s the real-world difference:

Feature	WP All Import	Native WooCommerce Importer
Review imports	✓ Full support	✗ No support
Custom field mapping	✓ Unlimited	✗ Limited
Image handling	✓ Multiple sources	✓ Basic URL import
Update existing records	✓ Selective field updates	✓ Basic overwrites
Taxonomy control	✓ Hierarchical, nested	✓ Basic
PHP customization	✓ Built-in editor	✗ Not available
Scheduling	✓ Automatic or manual	✗ Not available
File formats	✓ CSV, XML, Excel, Google Sheets	✓ CSV only

The native tool was clearly designed with simple product imports in mind, not the nuanced world of reviews, users, and complex relationships between data. For serious review imports, there’s really no contest – WP All Import is the tool for the job.

WP All Import Review for Large-Scale eCommerce Stores

For larger stores with thousands of products and reviews, this is where WP All Import truly earns its keep. I’ve worked with enterprise clients migrating massive datasets, and the plugin handles these challenges with surprising grace.

The batch processing feature is a game-changer for large imports. I typically recommend setting batch sizes between 500-1000 records for most servers – this sweet spot prevents timeouts while maintaining good speed. The plugin’s memory usage is remarkably efficient, which matters tremendously when you’re pushing the limits of shared hosting environments.

What has saved me countless hours is the robust error logging and retry mechanism. When an import hits a snag (and with large datasets, something always does), you can pinpoint exactly what went wrong and resume right where you left off. No starting over, no duplicate entries.

One store owner I worked with shared:

“We migrated 5000+ products without a single failed import. The detailed logs made it easy to identify and fix the few records that needed attention.”

For best results with mammoth datasets, I recommend running imports during quiet hours when your site has less traffic, temporarily disabling resource-heavy plugins, and testing your import thoroughly on a staging site first. If you’re dealing with truly enormous review collections (think 50,000+), breaking them into multiple files can make the process more manageable.

With these approaches, even the largest WooCommerce stores can successfully preserve their hard-earned customer feedback when migrating platforms or refreshing their site architecture.

Step-by-Step Guide: Importing Reviews from Any File

Ready to bring your reviews into WooCommerce? Let’s walk through exactly how to do it with WP All Import review tools. I’ve helped dozens of clients through this process, and it’s simpler than you might think!

Step 1: Create a New Import

First things first – head over to All Import › New Import in your WordPress dashboard. This is where the magic begins! Upload your file (whether it’s a CSV, XML, Excel spreadsheet, or even a Google Sheets URL), then select WooCommerce Reviews from the dropdown menu. Once you’ve done that, just click Continue to Step 2 to move forward.

Step 2: Review the Import File

Take a moment to look over your data and make sure everything appears correctly. This is your chance to be selective about what you import.

The Manage Filtering Options feature is particularly helpful here. Want to import only your glowing 5-star reviews? You can do that! Need to filter by date or specific products? That’s possible too. Once you’re happy with your selection, click Continue to Step 3.

Step 3: Map Data Elements to Review Fields

This is where WP All Import review mapping really shines with its intuitive drag-and-drop interface. You’ll see three main sections to work with:

In the Review Content section, you’ll map the essential details like the review text (this is required), rating (from 1-5 stars), the date it was posted, and whether it’s approved or not.

For Review Author information, you’ll map the reviewer’s name, email address, website URL if they provided one, and their IP address.

Finally, in the Review Meta section, you’ll indicate whether reviews are verified purchases and connect each review to its corresponding product.

The mapping process is wonderfully visual – simply drag your “rating” column to the Rating field, your “review_text” column to the Review Content field, and so on. It’s like connecting the dots!

For those tricky data formats, the built-in PHP function editor is a lifesaver. For example, if your ratings are text-based like “Excellent” instead of numbers, you can convert them with a simple script:

php
if(trim({rating[1]}) == "Excellent") {
return 5;
} elseif(trim({rating[1]}) == "Good") {
return 4;
} // and so on

Step 4: Configure Import Settings

Now it’s time to fine-tune how your import will run. Under Import Options, choose a unique identifier (I typically recommend using Auto-detect for best results).

You’ll need to decide how to handle existing reviews – should the system skip reviews that already exist, update them with new information, or create duplicates? Most store owners prefer the update option.

If you’re doing a bulk import, you’ll definitely want to check the option to block email notifications. Otherwise, your customers might suddenly receive a flood of “thank you for your review” emails!

For larger imports, don’t skip the advanced settings. Adjusting your batch size (I find 500-1000 works well for most servers), PHP memory limit, and import speed can prevent timeouts and make your import run smoothly.

Step 5: Run the Import and Check Results

Click Continue to start the import process. You’ll see a progress bar and a detailed log that shows exactly what’s happening. Keep an eye on this log – it’s your early warning system for any issues that might come up.

Once the import finishes, visit your WooCommerce products to verify that the reviews appear correctly. Take a moment to celebrate – you’ve just saved yourself hours of manual data entry!

Here’s a pro tip: If you need to match reviews to products by SKU instead of ID or name (which is common when migrating between systems), use this handy code snippet in the Product ID field:

php
[wc_get_product_id_by_sku({yourSku[1]})]

This function looks up the product ID based on the SKU from your import file, making product matching much more flexible.

For more detailed instructions, the official documentation on how to import reviews to WooCommerce is an excellent resource.

At wpOncall, we’ve helped countless clients through this process, and it’s always satisfying to see their valuable customer feedback successfully transferred to their store. The right reviews can significantly boost your conversion rates, so this import process is well worth the effort!

Advanced Scheduling, Bulk Updates & Troubleshooting

Once you’ve got the hang of basic imports, it’s time to explore some of WP All Import’s more powerful features. Trust me, this is where the magic really happens – automated schedules, smart updates, and problem-solving tricks that will save you hours of work!

Automatic Scheduling

Need your reviews to update automatically? WP All Import offers two great options:

1. Automatic Scheduling Service: This is the “set it and forget it” option. For $9/month, WP All Import handles everything without you needing to touch a line of code. Perfect if you’re not tech-savvy or don’t have server access.

2. Manual cron jobs: Free but requires some technical know-how and access to your server’s cron system or cPanel.

Here’s how they stack up against each other:

Feature	Automatic Scheduling Service	Manual Cron Jobs
Cost	$9/month	Free
Setup difficulty	Easy (no technical knowledge required)	Moderate (requires server access)
Reliability	High (managed by WP All Import)	Depends on server configuration
Control	Basic scheduling options	Full control over timing and parameters
Monitoring	Built-in	Requires separate monitoring

Setting up the Automatic Scheduling Service is straightforward – just head to All Import › Manage Imports, find your import and click Schedule. Choose how often you want it to run, enter your payment details, and you’re good to go!

For manual cron jobs, you’ll need to create a command that runs the wp-all-import.php file with the right parameters. This is more hands-on but gives you complete control over when and how your imports run.

Bulk Updates and Version-Safe Re-runs

One thing I absolutely love about WP All Import review tools is how safely they handle updates to existing content. This is incredibly useful when you need to:

• Update ratings or review text across multiple products
• Change approval status for a bunch of reviews at once
• Move reviews between your staging and live sites

The secret sauce here is the unique identifier. Think of it as a special tag that helps WP All Import match incoming records with existing ones. For reviews, I recommend using:

• The review ID itself (if available)
• A combination of product ID and reviewer email
• Date plus reviewer name (if the above aren’t options)

Here’s a pro tip: When running re-imports, enable “Skip records that have not changed” to make things run much faster. The system will check if anything’s actually different before processing each record – smart, right?

Troubleshooting Common Issues

Even with the best preparation, sometimes things don’t go exactly as planned. Here are solutions to issues I’ve encountered over the years:

When reviews aren’t matching up with products, first check that your product IDs or names match exactly what’s in your store. Sometimes the solution is as simple as using the SKU matching function: [wc_get_product_id_by_sku({sku[1]})]. Also, double-check that the products actually exist before trying to import reviews for them!

If you’re experiencing import timeouts, try reducing your batch size to 100-200 records, increase your PHP memory limit in wp-config.php, or temporarily disable resource-hungry plugins during the import process.

For character encoding issues (those weird symbols that sometimes appear), make sure your CSV files are saved in UTF-8 format. You can also use built-in PHP functions like html_entity_decode() or utf8_encode() to clean up text.

Having date format problems? Use PHP’s date functions to standardize everything: date('Y-m-d H:i:s', strtotime({date[1]})).

If you’re migrating between sites and need to maintain original IDs (crucial for preserving review relationships), check out the documentation on keeping old IDs when migrating.

And for the smoothest experience with large imports, follow our WordPress Optimization Guide to ensure your server is properly configured.

Common FAQs on Review Imports

Q: How can I import only 5-star reviews?
A: In Step 2 of the import process, use the filtering options to add a condition where “rating equals 5.” If you’re using XML files, you can use XPath filtering instead.

Q: Can I import reviews with plain text passwords?
A: Yes, but I don’t recommend it for security reasons. It’s much better to force password resets. WP All Import has an option to send password reset emails to imported users.

Q: How do I migrate reviews between WordPress sites?
A: The easiest way is to export reviews as a bundle (both data and import template) from your source site using WP All Export, then import that bundle on the destination site. This preserves all the relationships and metadata automatically.

Q: Will imported reviews trigger notification emails?
A: By default, yes – which could mean hundreds of emails going out at once! To prevent this, make sure to check the “Block email notifications during import” option in Step 4 of the setup.

Q: How do I handle parent-child review relationships?
A: Include the parent review ID in your import data and map it to the “Parent Review” field in Step 3. This preserves those threaded conversations in your reviews.

Best Practices Checklist

After helping dozens of clients with review imports, I’ve developed this checklist for the smoothest experience:

Always back up your database before starting any import. I can’t stress this enough – it’s your safety net if something goes wrong. Test on a staging site first, especially for large imports. This gives you a chance to work out any kinks before touching your live site.

Standardize your column headers in the import file and remove any duplicates from your source data. This prevents headaches later. For best performance, batch your imports into chunks of 1000 rows or fewer and disable any resource-intensive plugins during the process.

Make sure to set your PHP memory limit to at least 256MB and use UTF-8 encoding for all import files. I also recommend documenting your field mappings for future reference – you’ll thank yourself later when you need to run the import again.

Finally, monitor your server resources during large imports. This helps you catch and address any performance issues before they become problems.

Following these guidelines has helped me run smooth imports for everything from small boutique shops to massive eCommerce stores with thousands of products and reviews. With a little preparation, your review import can be just as successful!

Conclusion

Importing reviews to WooCommerce doesn’t have to be a headache. With WP All Import, you can seamlessly transfer product feedback from CSV, XML, or Excel files into your store, preserving all the critical metadata that makes reviews valuable.

I’ve seen how the plugin’s intuitive drag-and-drop interface saves hours of manual work. The powerful PHP function editor lets you transform your data on the fly, while the flexible scheduling options ensure your reviews stay up-to-date automatically. For store owners who truly value customer feedback, there’s simply no better choice on the market.

Think about it – whether you’re migrating from Shopify, combining multiple WooCommerce stores after an acquisition, or importing reviews collected through external surveys, WP All Import review tools handle it all with remarkable efficiency. No more copy-pasting reviews one by one or losing those precious star ratings in the process!

At wpOncall, we’ve guided countless clients through review migrations as part of our WordPress support services. One client recently moved 3,000+ reviews from an old platform, and watching their face light up when they saw all that social proof restored on their new site was genuinely rewarding.

What many store owners don’t realize is that importing large amounts of data is incredibly resource-intensive. Having a properly maintained WordPress installation creates the stable foundation needed for successful imports. That’s where our regular updates and backup services come into play – they ensure your site is ready for the task before you begin.

Beyond data imports, our team at wpOncall takes a security-first approach to WordPress maintenance. We provide daily updates, robust backup solutions, and unlimited support with the rapid response times you deserve. When something goes wrong during an import (and let’s be honest, something almost always does), you’ll want experts like us in your corner who can quickly diagnose and fix the issue.

We’re passionate about WordPress and genuinely committed to helping businesses keep their sites secure, fast, and functioning optimally. Our clients sleep better knowing their WordPress sites are in capable hands.

Ready to import your reviews or need help with other WordPress challenges? Learn more about our plugin expertise or reach out to discuss how we can support your WordPress needs.

With the right tools and support, your WooCommerce store can showcase authentic customer feedback that drives sales and builds trust—no matter where those reviews originally came from. And isn’t that what we all want? A thriving online store backed by genuine customer experiences that new visitors can trust.