How to remove Russian characters from the XML_ID field in a property?

Question

1C-Bitrix

I took the site for alteration and ran into such a problem. It is necessary to change the XML_ID in the product properties to the prefix I need for a more convenient output. The fact is that when the site was filled in, in the XML_ID and VALUE product properties, everything was filled with Russian letters, and now they are not deleted or replaced. Can anyone come across this? How to decide?

Answer 1

You need to write a script that will go through the list of products
AND replace Russian characters with English ones (there are many such php functions in Google)

Answer 2

You can open the database and change it manually