This question has been flagged
1 Reply
4169 Views

I made a script to import sales order lines and I want that prices be calculated based on price list inthe csv file

I am trying to use price_get_multi but always get problem

At least one pricelist has no active version !
Please create or activate one.: ''>

 

 

Here is the code

The [1] is the pricelist id and I am sure it is ok and active with expiry date 2014-12-31

The 267 is a product id

and 1.0 is the quantity

 

args = [[1],267,1.0] #query clause
context = {
    'date':"2014-12-08"
    }

args2 = [context]
product_price_with_pricelist = sock.execute(dbname, uid, pwd, 'product.pricelist', 'price_get_multi', args,context)

Avatar
Discard
Author

Even if I have the pricelist version in the CSV, how to include that in the code ?

Can you post more from your code ?

According to the code in .../product/pricelist.py, it seems that there is at least 1 Pricelist without Pricelist Version. Check your Pricelists.

Author

Actually the problem is that I checked and made sure that all pricelists are active and I also made start date 1-12-2014 and end date 31-12-2014

Not the Pricelist, but the Pricelist Version

Author

Yes I checked the versions too, they are all active and I even put the id hard-coded. but still same error

Best Answer

In OpenERP each Pricelist is linked to a Pricelist Version: See under Sales --> Configurations --> Pricelists

I think you must include the Pricelist Version in your CSV.

Or try to use  sale_line_import  from https://github.com/Vauxoo/addons-vauxoo/tree/7.0

Avatar
Discard