Sorry, my bad Karma is not sufficient to attach the file. So, I describe the steps for a simple sample.
1Â° I export 2 products from Sale>Products>Products with the More>export button. I choose to export fields "Internal reference, ID, name"
2Â° I read the file and I see that the first product was manualy created ( not from a mass import) because the external ID have not the structure I usualy use.
__export__.product_product_40477,"BRI_24890313","40477","POUSSETTE ""Combi"" BLEU TURQUOISE - Nouveau"
PROD_BRI_24890321,"BRI_24890321","26897","POUSSETTE ""Combi"" NOIRE A POIS BLANCS"
So, I want to replace "__export__.product_product_40477" by "PROD_BRI_24890313" in order to respect my structure (and avoid problems during the mass product update I have to do).
In this module, the only identifier able to change the external identifier is the database id (.id). So, I manualy modify the external ID (id) and I try to read the file with the import module of this section (Sale>Products>Products), but the .id in not present in the available fields.
Currently, the only way I found is:
1) find the errors manualy in the Sale>Products>Products exported file.
2) correct them 1by1 in the Settings>Technical>Sequences & Identifiers>External Identifiers (because, from this section, I can't export sufficient data's to re-compose the external ID I need, and because from this section is the view empty when more than 50 products are to be "on screen".