How Do I Bulk Import WooCommerce Products via CSV?
Why a Small Test Batch Matters
A mapping mistake or encoding issue affecting the full import of thousands of products is far more painful to clean up than the same mistake caught in a 5-10 product test run first — testing small lets you verify the mapping, formatting, and resulting product pages look correct before committing to the full-scale import.
Practical WooCommerce CSV Best Practices
- Save the CSV with UTF-8 encoding explicitly, since certain spreadsheet software defaults to a different encoding that can corrupt special characters (accented letters, currency symbols) on import.
- Review the column-mapping step carefully rather than trusting automatic detection, especially for less standard column names that might not match WooCommerce's expected fields automatically.
- Include SKUs consistently to avoid accidental duplicate products if the import is run more than once, since SKU is often used to match existing products for updates rather than creating duplicates.
- Handle product images via URL references in the CSV (pointing to already-hosted image files) rather than expecting the importer to handle local file uploads directly, which isn't how the standard CSV import process works.
- Back up the site before a large import, since a large-scale import mistake affecting thousands of products is much easier to recover from with a proper backup than by manually fixing each affected product.
Running the Import Properly
- Back up the site first, especially for a large import.
- Test with a small sample batch, verifying the results before proceeding.
- Run the full import, carefully reviewing the column mapping each time.
- Spot-check a sample of imported products afterward for accuracy.
Need help with a large or complex product import? See custom WooCommerce development.