Diagnosing WP All Import Performance Issues with Scalability Pro

Dave Hilditch

January 14, 2026

1 View 0

Scalability Pro does a lot of work to optimise your WP All Import jobs, but sometimes users can still have slow imports. Scalability Pro provides a special query parameter that makes WP All Import’s execution visible in the browser, allowing you to monitor the import process with performance analysis tools like Query Monitor or Code Profiler Pro and provide feedback to us to help us optimise your imports further through Scalability Pro.

When running WP All Import jobs, identifying performance bottlenecks can be challenging because the import process typically runs through AJAX or CLI, making it difficult to monitor what’s happening behind the scenes. Scalability Pro provides a solution that allows you to analyze the performance of your imports.

WP All Import is a powerful tool, but when imports are slow or causing server issues, troubleshooting can be difficult because import processing happens in the background via AJAX, database queries are not visible during normal operation, performance bottlenecks are hard to identify, and server timeouts can occur without clear indication of the cause.

This guide assumes you already have a WP All Import job set up and ready to run. You’ll need the Import ID of your job, which you can find in the URL when editing your import or in the imports list.

Step 1: Trigger the Import Using the Direct URL

Use the following URL format to trigger your import:

https://your-site.com/wp-load.php?import_key=YOUR_IMPORT_PASSWORD&import_id=YOUR_IMPORT_ID&action=trigger

Replace YOUR_IMPORT_PASSWORD with your import password (found in WP All Import settings) and replace YOUR_IMPORT_ID with the ID of your import.

Step 2: Run a Batch with Scalability Pro’s Query Monitoring

To diagnose performance issues during your import:

1. Install Query Monitor plugin or Code Profiler Pro before proceeding
2. Modify the import URL by adding the spro_show_import_queries=yes parameter:https://your-site.com/wp-load.php?import_key=YOUR_IMPORT_PASSWORD&import_id=YOUR_IMPORT_ID&action=processing&spro_show_import_queries=yes
3. Load this URL in your browser. This will:
   • Run a single batch of the import in the browser
   • Display the WP All Import output directly in the page
   • Allow Query Monitor or Code Profiler Pro to analyze the execution

Step 3: Analyze the Results

With Query Monitor or Code Profiler Pro, you can now analyze:

1. All SQL queries executed during the import batch
2. Query execution times
3. Memory usage
4. Function calls
5. Hooks and filters that might be affecting performance

This information helps you identify:

• Slow or inefficient queries
• Parts of the import process taking the most time
• How WP All Import is processing your data
• Specific performance bottlenecks

Troubleshooting

If you analyse your import and find issues you cannot optimise, please contact us through our Discord support server and provide screenshots and your own judgement of your analysis and we’ll assist. Frequently, we can improve Scalability Pro to optimise your imports even further with more feedback provided by our customers.

Summary

Scalability Pro enhances WP All Import by providing a way to run import batches that can be analyzed with performance monitoring tools. By adding the spro_show_import_queries=yes parameter to your import processing URL, you can run batches in a way that makes them visible to tools like Query Monitor or Code Profiler Pro. This visibility is invaluable for diagnosing performance issues and understanding why imports might be slow or causing server problems.