I have lots of Product Variants already in the database and I want to update their 'External ID' to their barcode. Therefor I have a few questions:
1. Is it a good idea to use the barcode as the 'External ID'?
2. How can I add the 'Database ID' to an import-compatible export?
- Is it 'ID (.id)'? If not, then which one is it?
- Why can't I add 'ID (.id)' to an import-compatible export? I can only add it if I uncheck 'import-compatible export'.
3. When I make a Product Variants import-compatible export with:
- 'ID (.id)' as 'Database ID'(?)
- 'ID (id)' as 'External ID'
- 'Barcode (barcode)'
and I try to re-import (update) it with:
- 'ID (.id)' as 'Database ID'
- 'ID (id)' as 'External ID' filled with the respective barcodes
then I can't find a matching Odoo Field 'Database ID'. How to select this?
