πŸ›’
WooCommerce

Importing WooCommerce Products via CSV

πŸ“… 8 October 2026 ✏️ 8 October 2026 ⏱ 5 min leestijd

Learn step by step how to import WooCommerce products via CSV: preparing the file, mapping columns, importing, and resolving common errors.

With a CSV import, you can fill your WooCommerce store with dozens to thousands of products at once, without entering everything manually. You prepare a well-formatted CSV file, map the columns to the correct WooCommerce fields via the built-in Import Tool, and then check the result. Below you’ll read exactly how this works, including common mistakes and how to avoid them.

Preparing the CSV file

Before you import anything, your CSV file needs to be correct. WooCommerce expects specific column names and reads them best when they match the standard export structure. The most important columns are:

  • SKU – unique identifier per product, also important for updates
  • Name – product name
  • Description and Short description – long and short product description
  • Regular price and Sale price – normal and discounted selling price
  • Categories – product category, separated by a comma for multiple categories
  • Images – URLs to product images
  • Published – 1 for visible, 0 for draft
  • Stock – stock quantity, if you use stock management

Save the file as UTF-8 to avoid problems with accents and special characters. Avoid blank lines in between and check that each row has as many columns as the header. Test first with ten to twenty products before importing the entire file, so you catch errors early.

πŸ’‘ Tip: First export a few existing products from WooCommerce (Products β†’ Export) to see the exact column structure. This prevents mapping errors during import.

Importing via the WooCommerce Import Tool

WooCommerce has a built-in importer that lets you work without extra plugins.

1

Open the import function

In your WordPress dashboard, go to Products β†’ Import and click to select the CSV file.

2

Upload the CSV file

Select your prepared file and click Continue. WooCommerce automatically reads in the column headers.

3

Map the columns

Check that each CSV column is mapped to the correct WooCommerce field. Manually adjust any incorrect mappings before continuing.

4

Choose the import settings

Indicate whether existing products should be updated based on SKU and whether images should be downloaded automatically.

5

Start the import

Click Run the importer. With many products this can take several minutes; keep the browser window open.

6

Check the result

Go to Products β†’ All Products and check the prices, categories, and images of a few random products.

CSV fileMap columnsStore filled

Product images and variants

For images, add an Images column with direct URLs to the image files, separated by a comma for multiple images per product. WooCommerce automatically downloads these to your media library during import. Make sure the URLs are publicly accessible, otherwise WooCommerce will skip the image.

Product variants, such as size and color, are supported by the standard importer, but require a correct structure: a parent row with type variable product and separate rows per variation with type variation and the correct attribute values. This is more error-prone than with simple products, so always test this first with a small number of variants.

Common issues and solutions

Most import problems stem from an incorrectly formatted file or server limits. A CSV file that’s too large often gets stuck on PHP’s maximum upload size or execution time. Split the file into smaller batches of, for example, five hundred products if the import stops or times out.

Duplicate products usually arise because the SKU is missing or not unique. Give each product its own SKU, even if you’re not using stock management, so later imports update existing products instead of duplicating them.

On hosting environments with limited resources, large imports sometimes run slowly or fail halfway. Sufficient server performance and fast storage make a difference here; Tandata uses LiteSpeed servers with NVMe storage, which makes import processes noticeably faster than on slow disks. You can find your PHP settings, such as upload limit and execution time, in Plesk under the PHP settings of your domain.

Frequently Asked Questions

Can I import products twice without getting duplicates?

Yes, provided each product has a unique SKU and you select the option during import to update existing products based on SKU instead of creating new ones.

What is the maximum file size for a CSV import?

This depends on the upload limit and memory limit in your PHP settings, usually between 64 and 256 MB. Split large files into smaller batches if you run into the limit.

Does the CSV import also work for product categories that don’t exist yet?

Yes, WooCommerce automatically creates missing categories based on the values in the Categories column.

Can I also import a CSV from another webshop?

Yes, as long as you restructure the columns to the WooCommerce format. First export a sample file from WooCommerce to see the correct column names and order.

Do I need to take my website offline during the import?

This isn’t required, but with large imports, maintenance mode can prevent conflicts with visitors or other processes.

Conclusion

A well-prepared CSV file with the correct column names, unique SKUs, and correct image URLs forms the basis for a successful WooCommerce import. Always test first with a small batch, check the result, and split large files if problems occur. With fast server performance, even an import of thousands of products runs smoothly.

View web hosting β†’

Was dit artikel nuttig?