How to import invoices with default product price

Question

Hi,

I'm trying to import invoices in Odoo 15.
All works fine except for the product price. The price must be set into the import file but I want the default product price to be set automatically. I think Odoo should be able to retrieve the product price from the product itself without specifying it in that file?

Thanks for assistance.

Tuan Bui VKS · Accepted Answer

If you are a programmer, you can override Odoo's create and write functions to handle changing product prices if you change the product. You can set the value of the Price field in the import file to -1 to distinguish it from cases where you do not want to get the price from the price list.

weirdbonus · Answer

Ensure your import file (e.g., CSV or Excel) includes the necessary columns like Invoice Date, Customer, Product, Quantity, etc.
Do not include the Price column if you want Odoo to automatically fetch the default product price.

Paliptim · Answer

The default Odoo import functionality might not have automatic price retrieval built-in. If the above suggestions don't work, consider searching for Odoo modules specifically designed for invoice import. Some modules might offer features like automatic price assignment.

Fahim Dawood · Answer

HI Tuan,
I am facing similar issue, I want to upload invoice with the prices on excel sheet - But default it selects the Standard pricelist from Odoo.
What would be the name of the column with -1 value?
Thanks
Fahim

関連投稿	返信	ビュー
Product import xslx 解決済 product import	3 8月 25	1368
Import Invoices - Invoice Address? import invoices	2 10月 23	4068
how to import lines to my invoice invoice product import bottom lines	3 10月 23	3143
Import Products by SKU 解決済 product import	2 3月 24	5431
PRODUCT LISTS IMPORTING ISSUE 解決済 product import	1 2月 22	2678

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！