| How to import products with variants and attribute prices |
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
5
Replies
20276
Views
I don't have enough Karma to post a comment, so I have to put this as an answer.
For those who are finding this post, the accepted answer worked great but I didn't know how to create this menu item in step 6:
6. To import variant prices for more than one product template at one time, you will need to create a new menu item for product.template.attribute.value.
I was able to figure it out by doing the following (using Odoo Studio, Odoo Enterprise 16):
1. Open the Inventory module.
2. Open Odoo Studio using the icon in the top right bar.
3. Click on Edit Menu
4. Click New Menu
5. Give the menu a name, I chose "Product Template Attribute Value"
6. Select Existing Model
7. For the model, select "Product Template Attribute Value"
8. Hit Confirm.
9. You can drag and drop the new Menu Item wherever makes sense to you...I put it under Inventory -> Products. This new link will show up in the top menu area when you are on the Inventory module.
10. Visit the new menu item page. You won't be able to import from this page, yet!
11. Make sure you have debug mode enabled.
12. Click on the debug button, and go to Edit View: List
13. Change create="0" to create="1" and then click save.
14. Refresh the page. You'll now be able to Import Records from the Favorites menu on the page.
1. Create/Import Attributes and Values
2. Import Product Templates with Attributes and Values. This will create product variants. (Do not create variants directly).
3. Export your product variants
4. Fill out the internal reference, barcode, cost, and shipping weight fields on the exported variants csv
5. Import to update the existing variants
6. To import variant prices for more than one product template at one time, you will need to create a new menu item for product.template.attribute.value.
7. Once you have created the menu item, export all product.template.attribute.value records
8. Fill in the price extras and update the existing records via import. Take care not to create any new records.
As explained in the first step, I exported the attributes and values and imported them into a new DB.
However the second step, I do not know which fields I should export, to be able to import in the new DB
Which Fields do I need to export in order to import into a new DB?
you will be much appreciated if you can provide any demo vedio link or any vedio made by you
Hi Marko,
I can't comment so I post answer. I think this video can help you: https://www.youtube.com/watch?v=etMYrOJyaiU&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=2 (starting at minute 55 in this video)
hello, i wanted to test odoo and import my items. I have the problem that I have 3 different prices and cannot enter them when importing. I wanted to import an item with Price1, Price2 and Price3. Price 1 is in store, price 2 is normal customers on the web and price 3 is business customers on the web and in store. It should have business customers and normal customers, business customers have price3, normal customers have price1 in the store, normal customers have price2 in the web shop. Is this possible?
Hi Marko,
For that you should use price list feature. Once all your products are imported into odoo, you should create one price list for each price category you want to display on your SO.
Once your pricelist are created in odoon you can link them on the contact form of your customer. So everytime you'll create a SO for that customer, you will apply his/her specific pricelist
See this forum entry for importing product variant prices https://www.odoo.com/fr_FR/forum/aide-1/how-to-update-product-variant-prices-in-v15-in-bulk-via-export-196088
Hello, thank you very much for your answer. I understood the price lists and tried to do it that way. However, it is a question for me whom I zbsp. for 100 customers who are different from supplier, customer and dealer-customer to define them all at once via import. Is this possible? When exporting, I do not know how I zbsp. set an item to display the normal price and the prices in the price lists. I also don't know how to set up the export of customers that shows in the file whether and which price list they use. Whether he is a dealer-customer, supplier or normal customer.
Am Mo., 16. Mai 2022 um 10:15 Uhr schrieb Michel Hiertz (mihi) <mihi@odoo.com>:
Hi Marko,
For that you should use price list feature. Once all your products are imported into odoo, you should create one price list for each price category you want to display on your SO.
Once your pricelist are created in odoon you can link them on the contact form of your customer. So everytime you'll create a SO for that customer, you will apply his/her specific pricelist
See this forum entry for importing product variant prices https://www.odoo.com/fr_FR/forum/aide-1/how-to-update-product-variant-prices-in-v15-in-bulk-via-export-196088
I also present this problem and this was my solution:
1) The attributes value in both databases must have the same External_ids, in this sense it is necessary to copy the attributes from one database to the other, making sure to keep the attribute value external_id.
2) When exporting, activate the --> I want to update data (import-compatible export) option.
3) Export the following fields from the product's module:
External ID
Name
Product Attributes/Attribute
Product Attributes/Values/External ID
Any other that is necessary
For some reason, in my experience when exporting the external IDs of the attributes, they are placed in the output file separated by commas and not one below the other as in any other case.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Jun 24
|
4042 | ||
|
2
Oct 24
|
2376 | ||
|
1
Aug 24
|
2830 | ||
|
2
Aug 24
|
3611 | ||
|
3
Oct 23
|
7521 |
