Problem Importing Multiple Attributes from CSV

  • jsnowbusiness

    (@jsnowbusiness)


    8 years, 9 months ago

    When I build a CSV and import it, everything works great EXCEPT for one column of attributes with cells that contain multiple attributes separated by | such as USA|United Kingdom|Singapore.

    What happens is products imported from CSV then have a Location attribute of “USA|United Kingdom|Singapore” rather than “USA”, “United Kingdom”, and “Singapore”. To fix the products I just edit the product, go to attributes and click “Save Attribute” without actually changing anything and then it works fine!

    Is there any way to make the WooCommerce import attributes separated by | properly??

Viewing 2 replies - 1 through 2 (of 2 total)
  • PXCommerce

    (@glaing1987)

    8 years, 9 months ago

    When setting multiple values for one attribute, the values need to be separated by commas for the built-in CSV importer.

    Try replacing the USA|United Kingdom|Singapore with “USA, United Kingdom, Singapore” in your CSV.

    • This reply was modified 8 years, 9 months ago by PXCommerce.
    Thread Starter jsnowbusiness

    (@jsnowbusiness)

    8 years, 9 months ago

    I see lots of problems arising trying to put comma separated values in a CSV without changing the delimiter to semicolons, and that’s even more BS to deal with.

    Has to be something better.. I guess I’ll just keep opening and re-saving the products to make Locations attribute save properly.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Problem Importing Multiple Attributes from CSV’ is closed to new replies.