0 Comments

Have a Question?

Categories
< All Topics
Print

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.

Table of Contents
Categories: Getting Started

Add a product

Select a product Quantity