Skip to Content
This question has been flagged
importimportingVariants
1 Reply
4515 डेटा देखने का तरीका
अवतार
Luc Bernard

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?


अवतार
खारिज करें
अवतार
Chris TRINGHAM
Best Answer

You cannot update the External ID.

You can set it when you create a record, or Odoo will assign one when you first export it.

The database ID is a number.  It is assigned by Odoo and (as you'd expect) you can't update it either, so it makes sense that it is not included in an import-compatible export.

The normal use of External ID is for the record id from another system.  If your barcodes never change maybe you could use that, but there's already a barcode field in the database.

अवतार
खारिज करें
Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
Errors when importing the import-compatible-export Solved
import importing
अवतार
अवतार
1
नव॰ 25
4277
import in vcard format
import importing
अवतार
अवतार
अवतार
4
नव॰ 18
10061
Can I schedule importing from remote CSV over HTTP?
import importing
अवतार
0
मार्च 15
6114
Unable to import a class from sale package to stock package
import importing
अवतार
अवतार
1
मार्च 15
6140
How do I know what field to import in to?
import contacts importing
अवतार
अवतार
1
जन॰ 24
3493