Title: Problem Importing Multiple Attributes from CSV
Last modified: August 14, 2017

---

# Problem Importing Multiple Attributes from CSV

 *  [jsnowbusiness](https://wordpress.org/support/users/jsnowbusiness/)
 * (@jsnowbusiness)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/problem-importing-multiple-attributes-from-csv/)
 * 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](https://wordpress.org/support/users/glaing1987/)
 * (@glaing1987)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/problem-importing-multiple-attributes-from-csv/#post-9414755)
 * 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](https://wordpress.org/support/users/glaing1987/).
 *  Thread Starter [jsnowbusiness](https://wordpress.org/support/users/jsnowbusiness/)
 * (@jsnowbusiness)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/problem-importing-multiple-attributes-from-csv/#post-9418978)
 * 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.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [attributes](https://wordpress.org/support/topic-tag/attributes/)
 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 2 replies
 * 2 participants
 * Last reply from: [jsnowbusiness](https://wordpress.org/support/users/jsnowbusiness/)
 * Last activity: [8 years, 9 months ago](https://wordpress.org/support/topic/problem-importing-multiple-attributes-from-csv/#post-9418978)
 * Status: not resolved