CSV Import: Step by Step Tutorial

To import products into WordPress navigate to Prices By User Role section under WooCommerce, tab “Import Products” and folow the steps:

Step 1. Source Selection

If uploading data stored locally, you should paste path to it (browse local folder and choose import file). Also you can enter the URL where it’s uploaded

Check “First Row is Header” option if the first row in your file contains columns names

Note: If you include a Header row into the file, the plugin will attempt to map columns to product fields automatically. If you don’t you will need to map all columns manually.

Step 2. CSV Field Separator (Delimiters)

Data in .csv file are detached by delimiters and on this step you should indicate what exactly CSV field separators are used in your case.

Step 3. Category Hierarchy Separator

Enter characters used in your file to separate categories in a hierarchical structure

Step 4. Decimal Separator

Choose the character to use for the decimal separator used in your file.

While importing the decimails will be cut off if you do not choose correct decimal separator

Step 5. Map CSV columns to fields

Another precondition of efficient WooCommerce import is field associations determining. To be more precise, file columns must be assigned to proper WooCommerce database fields.

Beside each database table name you will find “source field” dropdown. Having expanded it you will get entire list of import file columns. Select the one to assign it to current database field.

If your datafeed column names and database field names coincide, they can be mapped automatically

Preview data to be uploaded and confirm procedure pressing “Confirm & Run Import” button below.

Prices by User role import from .csv being completed, you will get import logs, showing what changes have been implemented for each updated product.

If you see “error” opposite the product it means this product wasn’t added. In this case, remove the causes of the error described in the error message, and repeat all steps from the beginning.

If you uploaded the file but haven’t import it for some reasons, there is no need to upload it again. Just click on Upload and Preview button and the latest uploaded file will be loaded in preview mode. 

Update products notes:

• Existing simple product is detected by SKU. If you don’t include the SKU in the file, the new product will be added even if product with such name already exists.

• Existing variable product is detected by Parent SKU. If you don’t include the Parent SKU in the file new simple products will be added instead of updating variable product.

• The new attribute won’t be created if you import products with the attribute that already exists. New variations will be added to the existing attribute if they are present in the file.

• The image won’t be duplicated if the SKU and the image already exist and the option Skip Duplicate Images is checked.

You may be interest in:

How to export WooCommerce products

Prices by User Role CSV import: overview