I have exported my inventory to update some items such as cost. When I reimport it it created duplicate part numbers. Fortunately I tried it on a test db first. How can I get the db to update existing parts (unique internal reference number) and not create duplicates.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Księgowość
- Zapasy
- PoS
- Project
- MRP
To pytanie dostało ostrzeżenie
1
Odpowiedz
1394
Widoki
In the comments
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
0
lip 25
|
860 | ||
|
0
lut 25
|
889 | ||
|
1
lut 24
|
1802 | ||
|
1
sty 24
|
1324 | ||
|
0
sie 23
|
1339 |
If all I do is export then reimport the same file with no changes I get this error as well:
Unknown error during import: <class 'binascii.Error'>: Incorrect padding at row 2 (Channel, Stiffner FC510-LT)
Resolve other errors first
There are no other errors.
Second Update It is not updating because I did not set the ID field, just the Internal reference. I do not see where to display the ID field either on the form nor in studio to add it. How an I add the ID field to the forms?
3rd Update Solved: You have to add the ID column in the list view before exporting using studio. That way the ID gets exported so it has a reference on the import.