Emoji Import Issue with WP All Import: Excel Emoji Becomes Corrupted

Hello WP All Import Support,

I’m encountering an issue when importing data from an Excel file into WordPress. In my Excel file, I have emojis that display correctly, for example, a leaf emoji ??. However, after importing using WP All Import, the emoji gets converted into a string of characters _xD83C__xDF3F_ in both the frontend and backend, rather than displaying as an emoji.

Steps I’ve already taken to troubleshoot this include:

1. Ensuring my Excel file is saved with UTF-8 encoding.
2. Confirming that the WordPress database uses utf8mb4 character encoding.
3. Testing the “Decode HTML entities with html_entity_decode” option in WP All Import.
4. Searching online for similar issues and finding a snippet that disables stream filtering and removal of non-ASCII characters

add_filter('wp_all_import_is_enabled_stream_filter', 'wpai_wp_all_import_is_enabled_stream_filter', 10, 1);
function wpai_wp_all_import_is_enabled_stream_filter($enable_strem_filter) {
    return FALSE;
}

add_filter('wp_all_import_csv_to_xml_remove_non_ascii_characters', 'wpai_wp_all_import_csv_to_xml_remove_non_ascii_characters', 10, 1);
function wpai_wp_all_import_csv_to_xml_remove_non_ascii_characters($remove_non_ascii_characters) {
    return FALSE;
}

Unfortunately, none of these steps have resolved the issue. Could you provide any further guidance or steps I can take to ensure emojis are imported correctly and display as intended on the site?

+ I uploaded it in XLSX and CSV same story..
For precision the emoji is for text which are in “short description” field

Thank you for your assistance.

• This topic was modified 1 year, 4 months ago by selenaquintanilla.