Importing Products in CSV File to Your WooCommerce Store

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

For importing products to your online store, our Product Import Export Plugin for WooCommerce takes CSV file as input. You must create a CSV(Comma-Separated Values) file which contains information about mapping fields in the tabular form.

You can create a CSV file by using a spreadsheet program, like  Excel or Google Spreadsheets. Save this file with the extension .csv. After entering all details about products in the spreadsheet, you can import product to your online store with images, categories, price, etc. You can also map each field of CSV file to the WooCommerce product field.

Let us understand this procedure with the help of the following example:

Suppose, you have following products on your spreadsheet, as shown in the screenshot below:

csv-1

Note: You can download a Product Import Sample CSV here.

Following are the steps to import products:

  • Navigate to WooCommerce > Product Im-Ex section of the plugin. Under Product > Import, move to Import Product in CSV Format section, as shown below:

Import-Products-settings

Import Products in CSV Format

The Import section helps in importing products using the CSV file. The Import section contains three methods for importing products.

Method 1: Select a file from your computer – The first method is to select a CSV file from your computer.

  1. Selecting a file from your computer: Click the Choose File button to select a CSV file for importing from your computer.

first-method-import

  • Method 2: Provide FTP Details – The second method is to select a CSV file from your FTP server. You need to provide your FTP information for importing products using this method.

FTPImport-2

The following FTP information has to be entered for importing products using this method:

  1. Enable FTP import/export: Check this option to enable FTP import/export.
  2. FTP Server Host/IP: Enter your FTP server hostname.
  3. FTP User Name: Enter your FTP username.
  4. FTP Password: Enter your FTP password
  5. FTP Server Path: Enter FTP server path.
  6. Use FTPS: Check this option to use FTPS. FTPS (File Transfer Protocol Secure) is a secured extension of FTP (File Transfer Protocol).

Method 3: Enter the URL of the file – In the third method, you can provide the URL of the CSV file from where it will be downloaded for importing the products.

product-import-method3-provide-url

The section below is the Advanced Options for import.

available-options

  • Select a mapping file: You can select an existing mapping file. Mapping files are created by mapping your imported columns to product data fields.
  • Update products if exists: Check this checkbox to update the existing products on your store with information from the CSV file. Existing products are identified by their SKUs.
  • Skip New Products: While updating existing products, tick this checkbox to skip products which are not already present in the store. If a new SKU is encountered in the imported CSV file, it will be skipped, and only the existing products will be updated.
  • Delimiter: In a delimited text file that is used to store data, each line represents a single entity, and has fields separated by the delimiterA delimiter is a character used to specify the boundary between separate entities in a text file. A popular example of delimiter is the comma character, which acts as a field delimiter in a sequence of comma-separated values (CSV). Enter a delimiter to separate the mapping values. By default, a comma is taken as the delimiter. In place of a comma, you can also use other characters like /, ” “, |, @, etc. You can also use the letter ‘t for parsing tab delimiter.
  • Merge Empty Cells: Check this option to merge empty cells when importing the CSV. If this option is not checked, empty cells will be ignored and can lead to issues when importing thing such as attributes for variable products.
  • Delete Existing Products: Check this option to delete the existing products that are not present in the importing CSV.
  • Use SKU to link up-sells and cross-sells: Check this option to use SKU to link the up-sells and cross-sells of a product. If this option is not checked, up-sells and cross-sells of a product will be linked using the Product ID.
  • Disable thumbnail generation: Check this option to avoid the regeneration of thumbnails on import.
  • New product status: This section allows you to change the status of all the new products imported to draft, pending, or published, overriding the existing status in the CSV.
  • Use SKU to link grouped products: Check this option to link the grouped items using SKU. If this option is not checked, the grouped products will be linked using product IDs.

Finally, click the Upload File and Import button to proceed further towards Map Fields.

Map Fields: This section allows you to map your imported columns to product data fields. You can select an existing mapping file or create a new one by naming the mapping file as shown below:

Import_Fields1

It is divided into the following three columns:

  • Map to: Represents WooCommerce product field names to which attributes will be mapped.
  • Column Header: Represents CSV headers which will be mapped to appropriate WooCommerce fields.

Column_Header

  • Evaluation Field: This column is used to fix/update the required value for a particular field.

Following are the possible values:

  1. Assign any required constant value to field –
    For example, to assign the value ‘cotton mixed’ to ‘attribute:pa_fabric’, enter the value =cotton mixed under Evaluation Field in the attribute:pa_fabric row.
  2. Add any required value to the field –
    For example, to add ‘2’ to ‘length’, write +2 under Evaluation Field in the Dimension: length row.
  3. Reduce any required value from the field –
    For example, to reduce ‘1’ from ‘width’, write -1 under Evaluation Field in the Dimension: width row.
  4. Multiply by any required value to the field –
    For example, to multiply ‘weight’ by ‘1.15’, enter the value *1.15 under Evaluation Field in the Dimension: Weight row.
  5. Divide by any required value to the field –
    For example, to divide ‘sale price’ by ‘2’, write /2 under Evaluation Field in the Price: Sale Price row.
  6. Append any field by required value –
    For example, to append ‘Product Title’ by ‘By HikeForce’, write &By HikeForce under Evaluation Field in the Product Title row.
  7. Prepend any field by required value –
    For example, to prepend ‘Product Description’ by ‘Description’, write &Description[VAL] under Evaluation Field in Product Description row.

Note: You can hover the mouse to the  sign, next to the header Evaluation Field column to see all the above value information. It is as shown in the screenshot below:

Evaluation_Field

 

  • After mapping all the required fields, save these mapping and evaluation fields in a file by specifying the filename in the Mapping file name field.
  • Click Submit to start importing.

Once the import is successful, a screen is displayed similar to the below screenshot:

imported-file

Simple Product

simple product

In the above image, you can see the simple product – Samsung Galaxy Ace Duos is imported to WooCommerce as specified in the CSV.

Variation Product

Variation_Product1

In the above image, you can see the variation product – Men’s Cotton T-Shirt is imported to WooCommerce with two variations – blue and red as specified in the CSV.

To know more about other features of the plugin, read the documentation.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

Your email address will not be published. Required fields are marked *