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.
Editing the CSV exported from WooCommerce export tool
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.
Merging columns
For the mapping to happen successfully during import, we must do the following:
- 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.
- 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|0Value 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.
- position: Defines the position of the attribute in the front-end.
- 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.
- To map the column: Attribute 1 global, you must know that the plugin considers the attributes with the prefix “pa_” as global attributes.
Modified Sample CSV of products exported from WooCommerce export tool.
Save the changes in the CSV and import the same.
Related Articles:
Comments (5)
Marcelo
October 11, 2022
Its possible import custom field values?
Alan
October 13, 2022
Hi,
Yes, you can import custom field values to the products using the premium version plugin.
Shayan
April 17, 2022
I’ve checked the visibility parameter several times, and it’s not working correctly. I have some hidden attributes in my database, and I use 0|1|0 value for them, but it is not changing.
Alan
April 20, 2022
Hi Shayan,
Could you please reach us via support with the importing CSV file so that we can check it.
Bas Rijnen
February 13, 2023
Hi there,
Did you find a fix for this problem? I’m encountering the same problem with this specific field – the values wont update while I never had any trouble with any other fields while updating.
I also reached out via support, really hoping for an answer on this issue! Thanks in advance