[Skip to main content](#vessel-content) # Importing Products with accented names ## - **[cpctw](/forum/user/36693-cpctw "View cpctw's Profile")** - [![cpctw's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36693-cpctw "View cpctw's Profile") Topic Author - [ Offline](/forum/user/36693-cpctw) Less More - Posts: 13 - Thank you received: 0 - - 11 years 6 months ago [\#199020](#199020) by [cpctw](/forum/user/36693-cpctw "View cpctw's Profile") *[Importing Products with accented names](/forum/37-import-export-csv-xls/876449-importing-products-with-accented-names#199020 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.0 -- PHP version -- : 5.4.38 I'm importing products that come from various regions. A good portion of the names include accented text. The accents show in the CSV file, but they are removed when imported.")* was created by *[cpctw](/forum/user/36693-cpctw "View cpctw's Profile")* -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.0 -- PHP version -- : 5.4.38 I'm importing products that come from various regions. A good portion of the names include accented text. The accents show in the CSV file, but they are removed when imported. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzY0NDktaW1wb3J0aW5nLXByb2R1Y3RzLXdpdGgtYWNjZW50ZWQtbmFtZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26395 - Thank you received: 4077 - - [](http://obsi.dev) - 11 years 6 months ago [\#199142](#199142) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Importing Products with accented names](/forum/37-import-export-csv-xls/876449-importing-products-with-accented-names#199142 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.0 -- PHP version -- : 5.4.38 I'm importing products that come from various regions. A good portion of the names include accented text. The accents show in the CSV file, but they are removed when imported.")* Hi, Please check the encoding format of your file ; the best is to use UTF-8 encoding. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzY0NDktaW1wb3J0aW5nLXByb2R1Y3RzLXdpdGgtYWNjZW50ZWQtbmFtZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cpctw](/forum/user/36693-cpctw "View cpctw's Profile")** - [![cpctw's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36693-cpctw "View cpctw's Profile") Topic Author - [ Offline](/forum/user/36693-cpctw) Less More - Posts: 13 - Thank you received: 0 - - 11 years 6 months ago [\#199316](#199316) by [cpctw](/forum/user/36693-cpctw "View cpctw's Profile") Replied by *[cpctw](/forum/user/36693-cpctw "View cpctw's Profile")* on topic *[Importing Products with accented names](/forum/37-import-export-csv-xls/876449-importing-products-with-accented-names#199316 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.0 -- PHP version -- : 5.4.38 I'm importing products that come from various regions. A good portion of the names include accented text. The accents show in the CSV file, but they are removed when imported.")* I have checked the encoding on the CSV file and the database, and they are both UTF-8. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzY0NDktaW1wb3J0aW5nLXByb2R1Y3RzLXdpdGgtYWNjZW50ZWQtbmFtZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14296 - - 11 years 6 months ago [\#199330](#199330) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing Products with accented names](/forum/37-import-export-csv-xls/876449-importing-products-with-accented-names#199330 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.0 -- PHP version -- : 5.4.38 I'm importing products that come from various regions. A good portion of the names include accented text. The accents show in the CSV file, but they are removed when imported.")* Hi, HikaShop will not remove any accent during the import of UTF8 files. HikaShop itself, and Joomla, are both fully UTF8. If you import a UTF8 file, the accents won't be removed. So the only conclusion I can think of is that you think that the CSV you're trying to import is UTF8 when in fact it is not. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzY0NDktaW1wb3J0aW5nLXByb2R1Y3RzLXdpdGgtYWNjZW50ZWQtbmFtZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[cpctw](/forum/user/36693-cpctw "View cpctw's Profile")** - [![cpctw's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36693-cpctw "View cpctw's Profile") Topic Author - [ Offline](/forum/user/36693-cpctw) Less More - Posts: 13 - Thank you received: 0 - - 11 years 6 months ago [\#199495](#199495) by [cpctw](/forum/user/36693-cpctw "View cpctw's Profile") Replied by *[cpctw](/forum/user/36693-cpctw "View cpctw's Profile")* on topic *[Importing Products with accented names](/forum/37-import-export-csv-xls/876449-importing-products-with-accented-names#199495 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.0 -- PHP version -- : 5.4.38 I'm importing products that come from various regions. A good portion of the names include accented text. The accents show in the CSV file, but they are removed when imported.")* I took a second look at the way the file was being created. I have to use an Excel spreadsheet to build the import file, and if you don't save the file as Unicode Text, you don't actually encode. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzY0NDktaW1wb3J0aW5nLXByb2R1Y3RzLXdpdGgtYWNjZW50ZWQtbmFtZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14296 - - 11 years 6 months ago [\#199521](#199521) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing Products with accented names](/forum/37-import-export-csv-xls/876449-importing-products-with-accented-names#199521 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.0 -- PHP version -- : 5.4.38 I'm importing products that come from various regions. A good portion of the names include accented text. The accents show in the CSV file, but they are removed when imported.")* Unicode basically means UTF8. And if you don't use it, it means that you use your local language encoding, which indeed explains why it didn't work. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzY0NDktaW1wb3J0aW5nLXByb2R1Y3RzLXdpdGgtYWNjZW50ZWQtbmFtZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pbleiman](/forum/user/37789-pbleiman "View pbleiman's Profile")** - [![pbleiman's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37789-pbleiman "View pbleiman's Profile") - [ Offline](/forum/user/37789-pbleiman) Less More - Posts: 5 - Thank you received: 1 - - 11 years 4 months ago [\#208038](#208038) by [pbleiman](/forum/user/37789-pbleiman "View pbleiman's Profile") Replied by *[pbleiman](/forum/user/37789-pbleiman "View pbleiman's Profile")* on topic *[Importing Products with accented names](/forum/37-import-export-csv-xls/876449-importing-products-with-accented-names#208038 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.0 -- PHP version -- : 5.4.38 I'm importing products that come from various regions. A good portion of the names include accented text. The accents show in the CSV file, but they are removed when imported.")* I experienced the same issue when creating the CSV file directly from Excel (Mac OS version 2011). The issue can easily be solved by exporting the file as "Windows Comma Separated (.csv)". Other options do not seem to generate a proper UTF-8 file. The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzY0NDktaW1wb3J0aW5nLXByb2R1Y3RzLXdpdGgtYWNjZW50ZWQtbmFtZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.062 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)