Download WooCommerce Product Import Template (CSV) - Free
Download a free WooCommerce product import CSV template with example data. Includes a column-by-column guide to help you bulk import products into WordPress.
Download WooCommerce Product Import Template (CSV)
Need a WooCommerce product CSV template that actually works? The built-in WooCommerce product importer expects a very specific CSV format - and the official documentation makes it harder than it should be to get right.
We've built a free WooCommerce product import CSV template based on the exact format WooCommerce's native importer expects. It includes 3 example products with real data so you can see exactly how every column should be filled in. Download it, replace the examples with your own products, and import directly into WordPress.
What's in the WooCommerce CSV template?
The WooCommerce product import template includes 38 columns matching WooCommerce's native product importer format, pre-filled with 3 example products:
- A simple product (Blue T-Shirt) with categories, tags, and an image
- A simple product (Wireless Mouse) with dimensions and weight
- A variable product (Running Shoes) ready for size variations
You can delete the example rows, replace them with your own data, and import directly into WooCommerce.
WooCommerce CSV column guide: every field explained
Here's what every column in the WooCommerce product import CSV template does and how to fill it in correctly:
Product identity
| Column | Required? | What it does |
|---|---|---|
| ID | No | Leave blank for new products. WooCommerce assigns an ID automatically. Only use this to update existing products. |
| Type | Yes | The product type: simple, variable, grouped, or external. Most products are simple. |
| SKU | Recommended | A unique identifier for the product. Used for inventory tracking and to prevent duplicate imports. |
| Name | Yes | The product title displayed on your store. |
Visibility & status
| Column | Values | What it does |
|---|---|---|
| Published | 1 or 0 | 1 = live on your store. 0 = saved as draft. |
| Is featured? | 1 or 0 | Whether the product appears in “Featured” collections. |
| Visibility in catalog | visible, catalog, search, hidden | Controls where the product appears. Use visible for most products. |
Content
| Column | Format | What it does |
|---|---|---|
| Short description | Plain text or HTML | A brief summary shown on category pages and at the top of the product page. |
| Description | Plain text or HTML | The full product description. Supports HTML for formatting, lists, and embedded images. |
Pricing
| Column | Format | What it does |
|---|---|---|
| Regular price | Number | The standard product price (e.g. 19.99). No currency symbol needed. |
| Sale price | Number | The discounted price. Leave blank if not on sale. |
| Date sale price starts | YYYY-MM-DD | When the sale begins. Leave blank for an immediate or permanent sale. |
| Date sale price ends | YYYY-MM-DD | When the sale ends. Leave blank for no end date. |
Inventory
| Column | Values | What it does |
|---|---|---|
| In stock? | 1 or 0 | Whether the product is in stock. |
| Stock | Number | The quantity in stock. Leave blank if not tracking inventory. |
| Low stock amount | Number | The threshold that triggers a low stock notification. |
| Backorders allowed? | 1 or 0 | Whether customers can order when out of stock. |
| Sold individually? | 1 or 0 | Limits purchases to one per order. |
Shipping & dimensions
| Column | Format | What it does |
|---|---|---|
| Weight (kg) | Number | Product weight in kilograms. Used for shipping calculations. |
| Length (cm) | Number | Package length in centimetres. |
| Width (cm) | Number | Package width in centimetres. |
| Height (cm) | Number | Package height in centimetres. |
| Shipping class | Text | A shipping class name (must already exist in WooCommerce). Leave blank for default shipping. |
Organisation
| Column | Format | What it does |
|---|---|---|
| Categories | Comma-separated | Product categories (e.g. Clothing, T-Shirts). New categories are created automatically. |
| Tags | Comma-separated | Product tags for search and filtering (e.g. cotton, organic, basics). |
| Images | Comma-separated URLs | Full image URLs. The first URL becomes the featured image. Separate multiple images with commas. |
Advanced fields
The remaining columns (Tax status, Tax class, Allow customer reviews?, Purchase note, Download limit, Download expiry days, Parent, Grouped products, Upsells, Cross-sells, External URL, Button text, Position) are used for specific product types and tax configurations. For most standard products, you can leave these blank.
How to import a product CSV into WooCommerce (step by step)
- Download the WooCommerce product CSV template above and open it in Google Sheets, Excel, or any spreadsheet editor.
- Replace the example products with your own data. Keep the header row intact.
- Save / export as CSV (UTF-8).
- In your WordPress admin, go to Products > Import.
- Upload your CSV file and click Continue.
- WooCommerce will auto-map most columns. Review the mapping, then click Run the importer.
- Once complete, check your products under Products > All Products.
WooCommerce CSV import tips: avoid common mistakes
- Always save as UTF-8 CSV - this prevents special characters (accents, currency symbols) from breaking.
- Use full image URLs - WooCommerce needs publicly accessible URLs (starting with
https://), not local file paths. - Leave the ID column blank for new products. WooCommerce assigns IDs automatically. Only populate it if you're updating existing products.
- Test with a small batch first - import 5-10 products to check formatting before uploading your full catalogue.
- Set Published to 0 if you want to review products before they go live. You can bulk-publish them later in WooCommerce.
A faster alternative: skip the WooCommerce CSV entirely
If formatting WooCommerce product CSV files isn't your idea of a good time, you can skip it altogether. Product Upload lets you paste any product URL from any supplier website and publishes directly to WooCommerce - no CSV template, no column mapping, no spreadsheet editing. The AI rewrites every listing with original, SEO-optimised content before it hits your store.
You can also use Product Upload to auto-generate WooCommerce-formatted product CSV files from any supplier website. Import products into the dashboard, select the ones you want, click “Send to Platform”, choose WooCommerce, and download a perfectly formatted CSV ready for WooCommerce's built-in product importer.
Either way, you never have to manually fill in a WooCommerce product import CSV template again.