Archives
Contributors
Re: Transfer/Migrate Product with Variants Keeping External
Identifier for product.product
It is not clear, but I feel that you are doing the export based on Product Template + Attributes, that will later trigger the Variant creation.
I suggest you to instead export/import the Product Variants (product.product), along with the related attribute data, and let the implicit Product Template record be automatically created.
For the record I did a quick test (14.0), and:
- if you import a "MYPRODUCT" Product Template, it has a __import__.MYPRODUCT XMLId and creates a related Product Variant with no XMLId.
- if you import a "MYPRODUCT" Product Variant, it has a __import__.MYPRODUCT XMLId and creates a related Product Template with XMLId __import__.MYPRODUCT_product_template.
This is helpful for that cases where you have relations to Product Template records (BoMs for example).
I hope this helps.
Thanks
Daniel
On 10/06/2021 08:57, Aires Silvestre wrote:
Hello everyone
I need to transfer products with variants from one Odoo database to another and have one requirement:
To keep the exact external identifier for both product.template and product.product records.
I need specially to preserve the external identifier for product.product (Product Variants) because later on I'll have to transfer stock moves and, yes, what is referenced in stock moves, sales, purchases, is product.product (and not product.template).
I've successfully exported products with variants (exported "attribute_line_ids/attribute_id/id" and "attribute_line_ids/value_ids/id") and import them in the destination database and everything is OK, products with variants are replicated but at the end variants (product.product records) have no external identifier, and I need them.
Can someone help, please?
Regards
--
Aires Silvestre
COO | Odoo Consultant
em.aires.silvestre@alien-group.com
tm.+244 913 728 650
Rua Doutor Agostinho Neto, 156, Bairro Azul, Luanda - Angola, Tel: +244 913 728 600 | +244 913 728 650,
Website: www.alien-group.com, Email: geral@alien-group.com
Não imprima este email caso não seja estritamente necessário. A Terra agradece-lhe!
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
| Daniel
Reis Managing Director |
|
|
|
| Av Doutor Desidério Cambournac 12 • 2710-553 Sintra, Portugal |
|
|
|
by Daniel Reis - 01:00 - 10 Jun 2021
Reference
-
Transfer/Migrate Product with Variants Keeping External Identifier
for product.product
Hello everyone
I need to transfer products with variants from one Odoo database to another and have one requirement:
To keep the exact external identifier for both product.template and product.product records.
I need specially to preserve the external identifier for product.product (Product Variants) because later on I'll have to transfer stock moves and, yes, what is referenced in stock moves, sales, purchases, is product.product (and not product.template).
I've successfully exported products with variants (exported "attribute_line_ids/attribute_id/id" and "attribute_line_ids/value_ids/id") and import them in the destination database and everything is OK, products with variants are replicated but at the end variants (product.product records) have no external identifier, and I need them.
Can someone help, please?
Regards
--
Aires Silvestre
COO | Odoo Consultant
em.aires.silvestre@alien-group.com
tm.+244 913 728 650
Rua Doutor Agostinho Neto, 156, Bairro Azul, Luanda - Angola, Tel: +244 913 728 600 | +244 913 728 650,
Website: www.alien-group.com, Email: geral@alien-group.com Não
imprima este email caso não seja estritamente
necessário. A Terra agradece-lhe!
by Aires Silvestre - 09:56 - 10 Jun 2021