Product name in cyrillic (product name getting messed up in the email)

[dmitrikartashov]

Hi there,

I have an issue when the product name is in cyrillic. When its added to the thank you email and on the thank you page it gets replaced.

In the email its replaced with spaces and on the page with � !

I think its something to do with charset.

The actual product name is – Отличная фигура – на всю жизнь!

Can you help?

[amin007]

Is your database created in UTF-8 format? You can log into your PHPMyAdmin and check the charset type for your database tables. If you never used PHPMyAdmin then this article should help:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[dmitrikartashov]

Yes, all tables are – utf8_general_ci.

When I go to product admin page, the name and descriptions all come out fine as they should. I also checked the product table and the ‘Name’ value is stored correctly.

The problem only appears when the product name is displayed in the email and thank you page.

[amin007]

I think I know what the issue is… when PayPal send the notification it sends the data using a different charset than UTF-8 so those names gets messed up. Not sure if you can set anything in your PayPal profile to tell PayPal to send the data back using UTF-8 format.

Anyway, here is a quick fix for you that should work:

1. Correct the product name in the email

Open the “paypal.php” file and search for the following line of code:

$cart_item_data_name = trim($current_cart_item['item_name']); //$retrieved_product->name;

Once you find it change it to the following:

$cart_item_data_name = $retrieved_product->name;

2. Correct the product name on the Thank You page

Open the “eStore_includes3.php” file and search for the following line of code:

$cart_item_data_name = trim($current_cart_item['item_name']); //$retrieved_product->name;

Once you find it change it to the following:

$cart_item_data_name = $retrieved_product->name;

This should make it to where it will use the product name from the database rather than the value sent from PayPal.

[dmitrikartashov]

Hi there,

This has fixed the issue. Many thanks for a quick fix and a great plugin.

Dmitri

[admin]

This should fix it:

https://support.tipsandtricks-hq.com/forums/topic/some-characters-and-text-not-recognizable-in-the-notification-email

[Author]

Posts