Skip to main content

How to import products in Woocommerce

J
Written by Juul v Kessel
Updated this week

Export your optimized content to WooCommerce using the built-in CSV importer.

Exporting from Valuna

  • Go to Products

  • Select the products to export

  • Click "Export"

  • Choose "CSV for WooCommerce"

  • Download the file

The export includes WooCommerce-compatible column headers.

Importing to WooCommerce

  • In WordPress admin, go to Products

  • Click "Import" at the top of the page

  • Click "Choose File" and upload the CSV from Valuna

  • If your file uses semicolons instead of commas, enter ";" in the CSV Delimiter field under Advanced Options

  • Click "Continue"

  • Map columns to WooCommerce fields (most should auto-match)

  • Click "Run the importer"

Updating Existing Products

To update products instead of creating new ones:

  • Make sure SKU column is included in your export

  • Check "Update existing products" during import

  • Products with matching SKUs will be updated

CSV File Requirements

  • UTF-8 encoding required

  • Maximum file size: 2GB

  • Wrap values containing commas in quotes

  • Image URLs must be absolute and directly accessible

Recommended Plugins for Large Catalogs

  • WP All Import (supports CSV, XML, XLSX formats)

  • Product CSV Import Suite (official WooCommerce extension)

Tips: Export small batches first to test. Always backup before bulk imports. Use SKU as the unique identifier for updates.

Did this answer your question?