WooCommerce使用WP All Import插件批量上传产品过慢问题求助

Hey there, let’s tackle that slow WP All Import issue with your 2000-product WooCommerce import. I’ve worked through dozens of similar cases, so here are actionable, tested steps to speed things up:

First, your server’s resources are often the bottleneck for large imports:

• Boost PHP Memory Limit: Most shared hosts cap this too low. Add this line to your wp-config.php file to raise it to at least 256MB (or 512MB if possible):

  define('WP_MEMORY_LIMIT', '256M');
  

• Enable PHP OPcache: This caches compiled PHP scripts to avoid re-processing them on every import step. You can enable it via your hosting control panel (like cPanel) or add these lines to your php.ini file:

  opcache.enable=1
  opcache.memory_consumption=128
  opcache.max_accelerated_files=10000
  

• Upgrade Server Resources (if needed): 2000 products might push shared hosting to its limits. Consider a temporary upgrade to a VPS or asking your host to allocate extra CPU/memory for the duration of the import.

Tweak the plugin’s settings to reduce unnecessary overhead:

• Adjust Batch Size: Instead of the default 50 records per batch, try increasing it to 100-200 (don’t go too high to avoid timeouts). Look for the "Records per batch" option in your import setup.
• Disable Non-Essential Plugins Mid-Import: Turn off all plugins except WooCommerce and WP All Import—this includes cache plugins, security tools, and WooCommerce add-ons like email notifications or inventory sync tools. Re-enable them once the import finishes.
• Skip Unnecessary Validations: If your source CSV/XML is already clean (no duplicate SKUs, valid price formats), disable extra checks in WP All Import. For example, turn off "Check for duplicate SKUs" if you’re sure your dataset has no duplicates.
• Optimize Your Import File: Remove any unused columns from your CSV/XML to reduce data processing. If the file is massive, split it into smaller chunks (e.g., 500 products per file) and import them sequentially.

Cut down on background processes that slow imports:

• Disable WooCommerce Auto-Actions: Temporarily turn off inventory updates, price recalculations, and order emails during imports. Add these snippets to your theme’s functions.php (remove them after import):

  // Disable new order emails
  add_filter('woocommerce_email_enabled_new_order', '__return_false');
  // Disable inventory checks
  add_filter('woocommerce_product_is_in_stock', '__return_true');
  

• Turn Off Auto-Saves & Revisions: WordPress saves revisions and auto-saves posts constantly during imports, which bogs down the database. Add these lines to wp-config.php:

  define('AUTOSAVE_INTERVAL', 86400); // 1 day instead of 1 minute
  define('WP_POST_REVISIONS', false); // Disable revisions entirely
  

• Pause Cache Plugins: Cache plugins (like WP Rocket or W3 Total Cache) will try to rebuild cache after every product import, which wastes resources. Disable them before starting the import, then clear cache and re-enable once done.

A slow database will kill import speeds—here’s how to fix it:

• Optimize WooCommerce Tables: Before and after importing, use a tool like WP-Optimize or phpMyAdmin to optimize tables like wp_posts, wp_postmeta, and wp_woocommerce_product_meta_lookup. This defragments tables and speeds up queries.
• Temporarily Disable Foreign Key Checks: If you’re using MySQL/MariaDB, run this query in phpMyAdmin before importing to skip foreign key validation (re-enable it afterward):

  SET FOREIGN_KEY_CHECKS=0;
  -- Run your import here
  SET FOREIGN_KEY_CHECKS=1;
  

  Note: Only do this if you’re 100% sure your import data is valid—broken foreign keys can cause database issues.

• Use WP All Import Pro: The pro version includes performance optimizations like bulk database inserts and faster API handling that can cut import time in half compared to the free version.
• Import via WP CLI: If your server supports SSH, use WP CLI to run the import from the command line—it’s more stable and faster than the web interface. The command looks like this:

  wp all-import run YOUR_IMPORT_ID
  

  You can find your import ID in the WP All Import dashboard URL.
• Host Images Locally: If you’re importing product images from remote URLs, download them to your server first and use local file paths instead. Remote image downloads add significant latency to each import step.

If none of these steps help, check your server error logs for specific timeouts or database errors—those can point to hidden bottlenecks. You can also reach out to WP All Import’s support team, as they know their plugin’s edge cases best.

内容的提问来源于stack exchange，提问作者Jalaj Kumar