⚡ Quick Product Import
- Products → All Products → Import
- Upload CSV file
- Map columns
- Start import
Why CSV Import?
Creating hundreds of products manually? That takes forever. With CSV import, you upload 100, 1,000 or 10,000 products in minutes – including descriptions, prices, images and variations.
Typical use cases:
- New shop launch with many products
- Import from another shop system
- Bulk price updates
- Seasonal product updates
- Dropshipping catalog import
Preparing the CSV File
The CSV file is the heart of the import. It must contain certain columns for WooCommerce to map the data correctly.
Important columns:
- SKU – Product number (unique)
- Name – Product name
- Regular price – Regular price
- Sale price – Sale price (optional)
- Description – Long description
- Short description – Short description
- Categories – Categories (with > for subcategories)
- Images – Image URLs (comma-separated)
First export a few existing products to see the correct structure: Products → All Products → Export.
Running the Import
Start Import
Go to Products → All Products. Click "Import" at the top.
Upload CSV File
Select your CSV file. Important settings:
- Delimiter: Comma (default) or semicolon
- Update existing products: Enable if SKUs already exist
Column Mapping
WooCommerce tries to automatically map your CSV columns. Check and correct as needed.
Run Import
Click "Run the importer". With many products, this can take several minutes.
Variable Products Import
Products with variations (sizes, colors) require a special CSV structure:
Type,SKU,Name,Parent,Attribute 1 name,Attribute 1 value(s)
variable,SHIRT-VAR,"T-Shirt Variable",,"Size","S|M|L|XL"
variation,SHIRT-VAR-S,,SHIRT-VAR,"Size","S"
variation,SHIRT-VAR-M,,SHIRT-VAR,"Size","M"For more than 500-1000 products: Split the CSV into multiple files. This avoids timeout problems.
Common Import Problems
Special characters display wrong
CSV must be UTF-8 encoded. In Excel: "Save as" → "CSV UTF-8".
Prices have wrong format
Use period as decimal separator: 29.99 not 29,99
Categories not created
Check spelling. Separate hierarchy with >: "Clothing > Men > T-Shirts"