I have a question about changing the Product ID. We integrated all the products in our website with a custom Product ID (CUSTOMIDENTIFIER001). Now this identifier is not valid anymore and we would want to use the default Dynamicweb identifier (PROD001) . We would want to change all the IDs in a single batch.
We don't know if we can change the ID of the products directly in the EcomProducts table of the database, because that would break the relations with other tables.
What do you think is the best option to modify the ID of all the products at the same time?