Import products in Odoo 16 enterprise with more variants having each their own sku and prices
Budget: €8 – €30 EUR
Version used: Odoo 16 enterprise
The requirement is that each variant (with at least 2 attributes) must have a different SKU (Internal reference) and a different price.
Here a simple example with 2 attributes.
The Product Template is: T-Shirt
The Attributes are: Size (with values L and M) and Color (with values Green and Red)
For this Product Template and the declared 2 Attributes we want to have 4 Product Variant.
Variant 1:
Size L and Color Green
sku: SKU01LV
price: €3.00
Variant 2:
Size M and Color Green
sku: SKU02MV
price: €3.10
Variant 3:
Size L and Color Red
sku: SKU01LR
price: €3.20
Variant 4:
Size M and Color Red
sku: SKU01MR
price: €3.30
In a single file (xls or csv) we want to create from scratch the Product Template and these 4 Product Variant in a single import having each their own sku and price. In the same file should be possible to import in the Product Template all the others values as Product Type, Cost, Weight, Volume, Income Account
After that we need to have different prices for the variants.
Following the example above, the prices imported are valid until 31 dec 2022.
Starting from 01 jan 2023 the prices are different and the difference is not the same for each variant.
Here below the new prices for the 4 variants.
Variant 1:
Size L and Color Green
sku: SKU01LV
price: €3.12 ( = 3.00 + 0.12)
Variant 2:
Size M and Color Green
sku: SKU02MV
price: €3.10 ( = 3.10 + 0.00)
Variant 3:
Size L and Color Red
sku: SKU01LR
price: €3.05 ( = 3.20 - 0.15)
Variant 4:
Size M and Color Red
sku: SKU01MR
price: €3.60 ( = 3.30 + 0.30)
Assuming we can use the PriceList function, we need to have 2 different PriceList with different validity so we can prepare in advance the new PriceList to be used starting from 01 jan 2023.
If the initial prices are in PriceList2022, in a single file (xls or csv) we want to import all the new prices in a PriceList2023.
The requirement is that each variant (with at least 2 attributes) must have a different SKU (Internal reference) and a different price.
Here a simple example with 2 attributes.
The Product Template is: T-Shirt
The Attributes are: Size (with values L and M) and Color (with values Green and Red)
For this Product Template and the declared 2 Attributes we want to have 4 Product Variant.
Variant 1:
Size L and Color Green
sku: SKU01LV
price: €3.00
Variant 2:
Size M and Color Green
sku: SKU02MV
price: €3.10
Variant 3:
Size L and Color Red
sku: SKU01LR
price: €3.20
Variant 4:
Size M and Color Red
sku: SKU01MR
price: €3.30
In a single file (xls or csv) we want to create from scratch the Product Template and these 4 Product Variant in a single import having each their own sku and price. In the same file should be possible to import in the Product Template all the others values as Product Type, Cost, Weight, Volume, Income Account
After that we need to have different prices for the variants.
Following the example above, the prices imported are valid until 31 dec 2022.
Starting from 01 jan 2023 the prices are different and the difference is not the same for each variant.
Here below the new prices for the 4 variants.
Variant 1:
Size L and Color Green
sku: SKU01LV
price: €3.12 ( = 3.00 + 0.12)
Variant 2:
Size M and Color Green
sku: SKU02MV
price: €3.10 ( = 3.10 + 0.00)
Variant 3:
Size L and Color Red
sku: SKU01LR
price: €3.05 ( = 3.20 - 0.15)
Variant 4:
Size M and Color Red
sku: SKU01MR
price: €3.60 ( = 3.30 + 0.30)
Assuming we can use the PriceList function, we need to have 2 different PriceList with different validity so we can prepare in advance the new PriceList to be used starting from 01 jan 2023.
If the initial prices are in PriceList2022, in a single file (xls or csv) we want to import all the new prices in a PriceList2023.