Importing Your Products

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

Numbers for macOS

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.

Add Product Request Form

Let us add your product for you! Fill out this form, and our e-commerce manager will follow up within 2 business days.