How to massively change the "External code:" property and assign it an id value in 1s Bitrix?

Question

1C-Bitrix

To integrate with 1C, you need to massively change the "External code:" property and assign it the value "ID"

I tried to unload these properties through export, change the values ​​in the csv file and import it back to the site, it did not help.
How else can you change the properties?
"External ID:" stored in [XML_ID] and [EXTERNAL_ID]

Answer 1

Api APIs, but IMHO it's enough to
update b_iblock_element set xml_id = id where iblock_id = 'required infoblock'
Settings - tools - sql query

Answer 2

I tried to find through the standard filter in 1s-Bitrix, but I'm probably doing something wrong
So I wanted to find all the elements in which the ID is not equal to XML_ID

Answer 3

You can do this through the Bitrix API in 2 stages:
1. Pull out all the products using CIBlockElement::GetList
2. Go through them and update the XML_ID for each product in a loop using the CIBlockElement::Update method.