I'm using the hosted version of Odoo 17.
I manually entered a couple dozen products from a vendor then added pictures, set categories for Sales and POS, etc.
Now I received a full price list from the vendor (and I will be receiving updated pricelists every 6 months).
I want to import the full price list without creating duplicate products. Reading through the docs, it seems the way to avoid creating duplicates is by using the External ID field. However, I have not found a way to export my current product list with the External ID.
How can I export my product list and include the External ID (as well as other fields that are not available in the column selector in the Products list view such as Ecommerce Shop/Categories)?
Perhaps an even better option would be if I could configure the import to prevent creating duplicate Internal Reference IDs. I already can't create a new product with the same Internal Reference in the UI, but Import doesn't enforce this constraint. Is it possible to configure Import to prevent duplicates?