How to import product attributes exported using WooCommerce export tool?

The free version of the Product import export plugin for WooCommerce exports and imports all the WooCommerce products from one store to another. But, what if you want to import the WooCommerce products that were exported using the default WooCommerce export tool?

Well, we have a solution for that too! The latest version of the Product import export plugin lets you import all the WooCommerce products exported from the WooCommerce export tool. Due to the data format difference in the CSV, the plugin has certain restrictions for automatically mapping the attributes of a product, However, you can alter the attribute columns for successful  import.

The CSV exported from the default WooCommerce export tool will have 4 columns for attributes as shown below.

Sample CSV of products exported from WooCommerce export tool.

For the mapping to happen successfully during import, we must do the following:

1. For merging the columns: Attribute 1 name and Attribute 1 value(s):
   • Remove the column: Attribute 1 name from CSV.
   • Change the header name of the column: Attribute 1 values(s) to attribute:pa_color.
   • To separate the multiple values, use the pipe symbol (|) instead of commas.
2. Handling the visibility of attributes.
   • To map the visibility of the attribute, change the column name: Attribute 1 visible to attribute_data:pa_color.
   • Specify the value as 1 (if the attribute is visible on the product page) and 0(if the attribute is not visible on the product page).
     
     Attribute Values- attribute_data:pa_color – 0|1|0

     Value of attribute data is given in the format: position | visible | variation.

     • position: Defines the position of the attribute in the front-end.
       NOTE: Existing attribute will be moved down if you set a lower position value for the new attribute. Attributes with a low position value will be placed at the top and attributes with a bigger position value will be placed last.
     • visible: Displays 1, if the attribute is visible at the front end. Else, displays 0.
     • variation: Displays 1, If the attribute is used for variation. Else, displays 0.
3. Handling local and global attributes
   • To map the column: Attribute 1 global, you must know that the plugin considers the attributes with the prefix “pa_” as global attributes.

     Thus, if you mentioned the attribute color and data columns as: attribute:pa_color and attribute_data:pa_color, then its global attribute.

     
     

     For local attributes, mention the column name without the prefix ”pa_” as: attribute:color and attribute_data:color

   • Thus, you can remove the column Attribute 1 global from the CSV. 

Modified Sample CSV of products exported from WooCommerce export tool.

Save the changes in the CSV and import the same.