How to import a new fixed-price price list from Excel?

Question

Hello everyone,
I am new to Odoo. I have successfully imported all my products and prices using an Excel file. Now, I need to create a price list for my extensive list of items with a pricing function defined for each different article. How can I create a price list, for example, for a wholesaler, that includes all my references in Excel so that I can quickly modify the prices? In my case, using a percentage rule is not possible, as it varies for each product. I am struggling with this task and

Marc Bink · Accepted Answer

Hi, we had the same problem, having a fixed price for each product variant.
We did it like this:
1) Export the needed product variants
2) Fill in the values for the fixed price
3) Make a small product variant based price list and export this list
4) Add the exported product variants with their external ID and other values to the exported price list
5) Import the completed pricelist in your DB.
I hope this can help you.

Jacobs · Answer

Un immense merci pour votre réponse.

Pouvez-vous me confirmer ceci :
Lors de l’export de mes produits, dois-je le faire depuis le menu export du module vente ?
Je pense que mon problème vient du fait que je ne peux pas exporter tous mes produits "item_ids/product_id/id" tout de suite car ma liste de prix est vide et je n'y ai pas encore de produits. Je ne suis pas sûr de l'expliquer correctement. Merci encore pour votre aide et la capture d'écran que vous avez envoyée. Passe une bonne journée.

Adil Akbar · Answer

Hi, you can follow https://youtu.be/SgFmOD9Q2S4?si=46y7nPM_rumGs9NU [1]
I hope it helps, thanks

[1] https://youtu.be/SgFmOD9Q2S4?si=46y7nPM_rumGs9NU

Bài viết liên quan	Trả lời	Lượt xem
How to bulk import new prices into a price list using an Excel template import pricelist	1 thg 8 25	1837
Price List imports Đã xử lý import csv pricelist	7 thg 10 23	14030
Import pricelist items v8 import pricelist	0 thg 7 15	4619
How can I change all product prices? Đã xử lý import price pricelist	1 thg 3 15	8746
Issue with import and comma in Excel File (odoo 19) import	0 thg 9 25	234

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!