Skip to Content
Menu
This question has been flagged
2 Replies
3494 Views

Hello,


I have to provide an easy way for my customer to import products with variants.

I prepared this import template:

Name

Brand

Product Category

Description long

Sales Description

Attribute Values

Barcode

Price

Name

Brand

MAIN / MAN / ALL

100% Pure leather

Fixed price, tot

Black,XXL

4123412

15.9797

If I import this as a product variant, odoo creates the product variant and the product template.

And they seem to be connected somehow, because the variant gets deleted with the product template.

However the variant doesn't show up in the product template, no tab "Variants".

Thank you for any help

Avatar
Discard
Best Answer

Hi,

follow this steps:

1. activate "variants" feature in Inventory Settings

2. use this steps to import products with variants:

2.1 create your attribute like this:


if you want to import variants in excel then use this template:

id name display_type create_variant value_ids/name
Size Radio Instantly L
XL

Note: you can add description row for your customer to define each column

2.2. import product template:

Notes:

 - you can not create product variant barcode from this

- some fields are generic for product like (UoM, inventory tab info,......)

- some fields are dedicated for each variant like(barcode , internal reference, cost, price ,.......)

excel template:

External ID name product category Product Type Product Attributes /Attributes Product Attributes /  Values Purchase UoM
product_template_1 pro 1 All product Size L,XL Units
Colour red
product_template_2 pro 2 All product Size L Units
Colour red,blue
product_template_3 pro 3 All product Size L,XL Units

also you can add custom fields to describe the meaning of particular fields but remove it before importing process

Avatar
Discard
Author

thank you very much :)

Best Answer

Hi, I think best way to do 2 imports. first import product template(it allready is as one single variant).
after that import variants, but in table of import, relate product template external id.

Avatar
Discard
Related Posts Replies Views Activity
1
Nov 24
1485
1
Nov 24
1193
2
Sep 24
1047
1
Aug 24
2454
3
Aug 24
2687