Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
productimportinvoiceslines
4 Vastaukset
2776 Näkymät
Avatar
Arnaud Schittly

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.

Avatar
Hylkää
Avatar
Tuan Bui VKS
Paras vastaus

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.

Avatar
Hylkää
Thuy Ngoc

Thank you. This is a great way

Fahim Dawood

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

Avatar
weirdbonus
Paras vastaus

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.

 

Avatar
Hylkää
Avatar
Paliptim
Paras vastaus

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.

Avatar
Hylkää
Paliptim

With pricing rules, you can define conditions and actions that determine the price of a product based on various criteria such as customer, quantity, or date. By creating appropriate pricing rules, you can let Odoo automatically calculate the price during the invoice import process, reducing the need for manual input. https://basketballrandom.com

Avatar
Fahim Dawood
Paras vastaus

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

Avatar
Hylkää
Tuan Bui VKS

Hi Fahim,

I also use the price_unit field like Odoo. However, I write the value of this column in Excel as -1 and the value will be recalculated correctly through Odoo's create and write overrides.

Tuan Bui VKS

To override this function you need programming knowledge such as:
def create(self, vals):
if vals.get('price_unit',-1):
...

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Product import xslx Ratkaistu
product import
Avatar
Avatar
Avatar
Avatar
3
elok. 25
1466
Import Invoices - Invoice Address?
import invoices
Avatar
Avatar
Avatar
2
lokak. 23
4300
how to import lines to my invoice
invoice product import bottom lines
Avatar
Avatar
Avatar
Avatar
3
lokak. 23
3284
Import Products by SKU Ratkaistu
product import
Avatar
Avatar
2
maalisk. 24
5533
PRODUCT LISTS IMPORTING ISSUE Ratkaistu
product import
Avatar
Avatar
1
helmik. 22
2762