Importing Product Metadata from CSV – WooCommerce Product Import Export

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!

Metadata is a set of data that gives information about other data such as product data. Importing metadata is in the interest of business people who can use it to identify the total number of sold products, the total number of the products that are for sale, or any data about product data.

Metadata of a product must be entered in the CSV file which is to be uploaded.

For more information about CSV format, see Setting Up Product Import Export Plugin For WooCommerce.

Now, let’s understand importing metadata of a product through example.
Suppose, CSV file is as shown below:

sample CSV

Note: Click the Sample CSV of Importing Metadata to download it.

  1. Navigate to Admin settings (WooCommerce > Product Im-Ex) of the plugin. Under the Product tab, the Import window appears as shown below:

Import Products settings

  1. Click Choose File to browse a required CSV file from your computer.
  2. Click Upload file and Import. The import window appears as shown below:

map fieldYou can map the fields (Woocommerce fields) with column headings ( CSV file header). Map a particular field under Map to column by using the drop-down list for that particular Column header as shown below:

mapping field 1

Select a required option from the drop-down list. Here, Product Title is mapped to post_title.

Note: Mapping is very helpful if you are importing CSV from some other e-Commerce platforms like Magento.

  1. Evaluation field is used to fix/update the required value for a particular field. The Plugin provides various options to modify fields and they are as shown in the below screenshot:Evalution fieldNote: Hover the mouse on? (Help), you can see the above information about Evaluation field.
  2. Click Submit to import the products into your online store.  According to the CSV file, the product gets added to your online store. The import window appears as shown below:Import successThis plugin imports the metadata of the product which is specified in the CSV file.
  3. The products get imported as shown below:product page 2
  4. Here, is a page of an individual product.individual product page 1

In the above image, you can see the highlighted metadata is imported to WooCommerce as per specified row of 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 *