How to properly export and import product names with special characters?

[Ann07]

Hi All,

I am so desperate for help, please. Thank you in advance. 

So I have a bunch of products with special characters on their product name, an example is Jazz Band® Hearing Protectors. I need to export them all so I can bulk-edit the selling price.

In the exported file, the product name becomes like this: Jazz Band® Hearing Protectors. Well some of them become more special and become like this â„¢. Then I tried to import using the same CSV file after editing the selling price, thinking that it would just edit the selling price since there is a "Handle" column and I checked the overwrite products checkbox. but unfortunately, it created a new product, so I have now Jazz Band® Hearing Protectors and Jazz Band® Hearing Protectors. 

I am pretty sure that I checked the overwrite product checkbox because when I check the same file using the other products without any special character, the selling price are all updated properly without duplicates. Please see my screenshot, the 3rd product is in the same CSV file I exported but it is updated properly and do not have duplicate created. Only those with special characters created a duplicate product with special characters during the export/import.

Can someone help me on how to properly export a file that will not transform ® ™ and the like to a something like special characters or if not possible, can you help me to properly import back the file that I exported with those special character without creating a new products. Please note that I am only bulk editing them, no purpose of creating a new product here. Any help will be appreciated.

Thank you so much and Happy New Year, all!

[Jonathan-HA · Accepted solution]

Hey there Ann,

This was most likely due to the encoding/character set setting in your spreadsheet software.  You'd normally want to use UTF-8 encoding when opening CSV files for those characters to get displayed correctly.

If you're not sure how to set the encoding/character set in your spreadsheet software, you could try just using Google Sheets to open the CSV file which uses UTF-8 by default.

So you could do something like this:

1. Open the CSV file in Google Sheets (this will create a Google Sheets spreadsheet).

2. Do the edits directly in Google Sheets.

3. In Google Sheets, download a new CSV file after making your edits via File > Download > Comma Separate Values (.csv) option, which you can then use to import back into Shopify.

You might want to test it out on a handful of products first to make sure it works as expected.

[Jonathan-HA · Accepted solution]

Hey there Ann,

This was most likely due to the encoding/character set setting in your spreadsheet software.  You'd normally want to use UTF-8 encoding when opening CSV files for those characters to get displayed correctly.

If you're not sure how to set the encoding/character set in your spreadsheet software, you could try just using Google Sheets to open the CSV file which uses UTF-8 by default.

So you could do something like this:

1. Open the CSV file in Google Sheets (this will create a Google Sheets spreadsheet).

2. Do the edits directly in Google Sheets.

3. In Google Sheets, download a new CSV file after making your edits via File > Download > Comma Separate Values (.csv) option, which you can then use to import back into Shopify.

You might want to test it out on a handful of products first to make sure it works as expected.

[Ann07 · Accepted solution]

Hi Jonathan, 

Thank you for your reply, it helped! 

Thank you