I'm having an issue importing a .csv file that has...
# general
j
I'm having an issue importing a .csv file that has Special Characters in it. It's a multi-select field on the item record. The items that did not have special characters imported just fine, but the rest did not. I found a topic stating I needed to save my .csv as Unicode (UTF-8) so I selected that on the encoding and saved as CSV UTF-8 (Comma delimited) (*.csv). I also selected Unicode (UTF-8) on character encoding in my import. I made sure my multi-select value delimiter was set to |. I still can't seem to get this to work. Here is a sample of one of them "Airports & Transportation-132". I have attached an image of the category name in Netsuite as well to show you it's exactly the same. Any ideas? If I can't figure it out I'll probably just have to switch my WooCommerce and Netsuite Category names to 'and' instead of '&'
l
do an export of value to internal id mapping, then find and replace with id in csv. import using id.
a
@Jordan Fitch - ALWAYS import the Internal ID for EVERYTHING. Personally I always select UTF-8 as the file code on the import. It would help a great deal if you shared what specific record you were trying to import. I am assuming that it is a custom field on the item record? I always try to move away from using multi-select fields because of the issues they can cause with scripting and saved searches. They are still workable but just require advanced config to work with them.