To correctly fill out the CSV file for WooCommerce, follow the instructions below. The CSV file is used to import products into your online store, so it is important to fill in all fields according to WooCommerce requirements.
We recommend using:
- Online spreadsheet editor Google Drive / Docs
- Free spreadsheet app in OpenOffice
- Free Calc app in LibreOffice
- Numbers for macOS
1. Column Headers
- The first row of the CSV file contains the column headers, which specify the information required for each product. Do not change these headers, as they are crucial for the correct import of products
2. Product Type
- In the Type column, specify the product type. This can be:
- simple – a simple product (e.g., a t-shirt, beanie)
- variable – a product with variants (e.g., a t-shirt in different colors and sizes)
- grouped – a group of products (e.g., a product bundle)
- external – an external product (e.g., a product sold on another website)
- downloadable – a downloadable product (e.g., a digital file)
- virtual – a virtual product (e.g., a service)
3. SKU
- In the SKU column, enter a unique product code. The SKU should be unique for each product.
4. Product Name
- In the Name column, enter the product name. The name should be descriptive and easy for customers to understand.
5. Product Description
- In the Short description column, enter a short description of the product, which will be visible on the product list
- In the Description column, enter the full product description, which will be visible on the product details page
6. Product Status
- In the Published column, enter 1 if the product should be visible in the store, or 0 if it should be hidden
- In the Is featured? column, enter 1 if the product should be featured, or 0 if not
- In the Visibility in catalog column, specify the product visibility:
- visible – the product is visible in the catalog and search results
- catalog – the product is visible only in the catalog
- search – the product is visible only in search results
- hidden – the product is hidden
7. Prices
- In the Regular price column, enter the regular price of the product.
- In the Sale price column, enter the promotional price if the product is on sale
- In the Date sale price starts and Date sale price ends columns, enter the start and end dates of the promotion (format: YYYY-MM-DD)
8. Stock Status
- In the In stock? column, enter 1 if the product is available, or 0 if it is out of stock
- In the Stock column, enter the quantity of available units
- In the Backorders allowed? column, enter 1 if backorders are allowed, or 0 if not
9. Product Attributes
- In the Attribute 1 name, Attribute 1 value(s), Attribute 2 name, Attribute 2 value(s), etc., columns, you can specify product attributes such as color, size, material, etc.
- Separate attribute values with commas (e.g., Blue, Green, Red)
10. Categories and Tags
- In the Categories column, enter the category to which the product belongs Categories can be separated by the > symbol (e.g., Clothing > Tshirts)
- In the Tags column, enter tags related to the product, separated by commas
11. Product Images
- In the Images column, enter the URLs of the product images, separated by commas The first image will be the main product image
12. Dimensions and Weight
- In the Weight (lbs), Length (in), Width (in), and Height (in) columns, enter the weight and dimensions of the product
13. Related Products
- In the Upsells and Cross-sells columns, enter the SKUs of products that should be displayed as related products (upsell) or additional products (cross-sell)
14. Virtual and Downloadable Products
- If the product is virtual or downloadable, fill in the Download 1 name, Download 1 URL, Download 2 name, Download 2 URL, etc., columns, providing the names and URLs of the downloadable files
15. External Products
- If the product is external, in the External URL column, enter the URL of the page where the product can be purchased, and in the Button text column, enter the button text (e.g., Buy now)
16. Grouped Products
- If the product is a group of products, in the Grouped products column, enter the SKUs of the products that should be part of the group
17. Product Position
- In the Position column, enter a number specifying the order in which the product should be displayed in the category
18. Saving the File
- After filling in all fields, save the file in CSV format (UTF-8). Make sure the file is correctly formatted to avoid errors during import
19. Importing the File
- Go to the WooCommerce admin panel, select Products > Import, and then upload the CSV file. Check if all products have been imported correctly
Example of a Filled Row:
ID,Type,SKU,Name,Published,"Is featured?","Visibility in catalog","Short description",Description,"Date sale price starts","Date sale price ends","Tax status","Tax class","In stock?",Stock,"Backorders allowed?","Sold individually?","Weight (lbs)","Length (in)","Width (in)","Height (in)","Allow customer reviews?","Purchase note","Sale price","Regular price",Categories,Tags,"Shipping class",Images,"Download limit","Download expiry days",Parent,"Grouped products",Upsells,Cross-sells,"External URL","Button text",Position,"Attribute 1 name","Attribute 1 value(s)","Attribute 1 visible","Attribute 1 global","Attribute 2 name","Attribute 2 value(s)","Attribute 2 visible","Attribute 2 global","Meta: _wpcom_is_markdown","Download 1 name","Download 1 URL","Download 2 name","Download 2 URL"
44,variable,woo-vneck-tee,"V-Neck T-Shirt",1,1,visible,"This is a variable product.","Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.",,,taxable,,1,,0,0,.5,24,1,2,1,,,,"Clothing > Tshirts",,,"https://woocommercecore.mystagingwebsite.com/wp-content/uploads/2017/12/vneck-tee-2.jpg, https://woocommercecore.mystagingwebsite.com/wp-content/uploads/2017/12/vnech-tee-green-1.jpg, https://woocommercecore.mystagingwebsite.com/wp-content/uploads/2017/12/vnech-tee-blue-1.jpg",,,,,,,,,0,Color,"Blue, Green, Red",1,1,Size,"Large, Medium, Small",1,1,1,,,,