Have a Question?
Create your CSV
What CSV editors do you recommend?
Online spreadsheet editor Google Drive / Docs
Free spreadsheet app in OpenOffice
Free Calc app in LibreOffice
AVOID Microsoft Excel due to formatting and character encoding issues.
Adding New Products
1/ Go to Store Manager > Products.
2/ Select Import at the top. The Upload CSV File screen displays.
3/ Select Choose File and the CSV you wish you use.
CSV delimiter (Advanced option): Generally CSV elements are separated by a comma. If you are using a different delimiter in your file, you can set it here.
4/ Continue.
The Column Mapping screen displays and WooCommerce automatically attempt to match or “map” the Column Name from your CSV to Fields.
5/ Use dropdown menus on the right side to adjust fields or indicate ‘Do not import.’
*Any unrecognized columns will not be imported by default.
6/ Select Run the Importer.
7/ Wait until the Importer is finished. Do not refresh or touch the browser while in progress.
Update Existing Products
1/ Make a CSV file as indicated in Create Your CSV, using the IDs and/or SKUs of products you wish to update.
The importer uses the ID and/or SKU to auto-match and auto-update whatever info you enter on each line.
2/ Go to Store Manager > Products.
3/ Select Import at the top right. The Upload CSV File screen displays.
4/ Select Choose File and the CSV you wish you use.
5/ Tick the checkbox for Update Existing Products.
6/ Continue.
The Column Mapping screen displays and WooCommerce automatically attempt to match or “map” the Column Name from your CSV to Fields.
7/ Use dropdown menus on the right side to adjust fields or indicate ‘Do not import.’
*Any unrecognized columns will not be imported by default.
8/ Select Run the Importer.
9/ Wait until the Importer is finished. Do not refresh or touch the browser while in progress.