Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

Updating a pricelist from CSV

By
Jesua
on 5/23/13, 8:02 PM 2,897 views

Ok, here is the issue, I have tried to update a Pricelist from a exported CSV from Openerp v7.

But when trying to import the file I get this error:

warning -- ValidateError Error occurred while validating the field(s) date_start,date_end: You cannot have 2 pricelist versions that overlap!

Im trying a template that goes like:

id currency_id/id
name
type
version_id/items_id/id version_id/items_id/base
version_id/items_id/min_quantity
version_id/items_id/sequence
version_id/name version_id/items_id/product_tmpl_id version_id/items_id/product_id
version_id/items_id/price_surcharge

On the other hand, about the date issue, in the openerp book states that leaving the dates on blank will make the pricelists like "forever".

I don't understand how every pricelist work. I have created a pricelist for every shop I have, then I want to upload all the prices for every item. Every item is the same on every shop, how the pricelists versions affects to this? Do I need a rule for every item inside a pricelist?

Thanks in advanced...

seems to be a date issue between your pricelists!

AD LIBITOM, michel Guénard
on 5/23/13, 8:42 PM
2

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 5/23/13, 9:44 PM

Your issue is that for pricelist has got one or more pricelist versions. And there cannot be any overlap of dates for any of the versions.

So before you import your new version information, you have to end the old version, or give it an end date, which is on or before the start date of what you want to import.

I think it should even be possible to use your csv-file to give your old version an end date, but that is a bit tricky. You better do it manually, to keep things simple.

On version_id/items_id/id, when esporting the csv file I have a default content like __export__.product_pricelist_item_7. When I try to import, what should I put there?

Jesua
on 5/24/13, 12:32 PM

If you want to create a new version, I think you should remove this column. Now you refer to pricelist item 7.....

patrick
on 5/24/13, 4:36 PM

That make the trick... thanks a lot...

Jesua
on 5/24/13, 5:41 PM

You're welcome. Advantage of a forum like this. One person asks a question, other users respond, and yet another looks around and finds his question and the needed answer(s).

patrick
on 5/24/13, 7:39 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 5/23/13, 8:02 PM
Seen: 2897 times
Last updated: 3/16/15, 8:10 AM