While Adding multiple simple or variable products in bulk with xlsx  is pretty easy and straight forward using WordPress Product Import Export with Excel for WooCommerce, sometimes the user needs to import product attributes where there is a comma in the attribute term, for example :

Let’s say you need to import a product that has an attibute PA SIZE where the value of the term has a comma for example 1,5 and not a dot.


This while importing programmatically would be replacing the comma (,) with a dot(.) in the name of sanitization for security reasons to avoid any harmful content to be imported in the database.

However, in this case the user actually needs the comma in the product attribute term  value as this is a necessity , therefore we need to bypass the audit.

The solution

The solution for saving an attribute term while importing the value through excel file and create a WooCommerce product is

escaping the comma with a backslash (\) .

This special character will allow the comma in the term value and will not replace it with a dot.

An example of a variable product import with comma in attribute value  with excel can be found here.

back to Tutorials