Odoo Help


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.


Changing (bulk) providers sequence or changing 1 provider oerp 6.1.1 ?

on 2/24/14, 4:58 AM 719 views


We use a very large catalog (145000 items).

To maintain each category (each 'brand') we import one or twice a year new providers lists (new prices and/or new references) with Excel CSV files.

We have something like 30 brands. Some brands represents up to 20000 articles.

We are facing an issue when we NEED 2 providers for an item or to CHANGE a provider.

I can create a CSV file with ONE seller_ids/name/id . (containing the id of provider A).

This is or usual method.

So we decided to change the provider to swith for all concerned items to provider B (aiming not to have an lalternate provider)

But if I reimport a new list with this filed containing id of PROVIDER B, we see in OERP there are now 2 providers both with sequence "1" so it's alphabetically sorted and the default one is not necessary the right one.

The provider information is not replaced by the new data, it creates a second provider (or a third and so on) but all with sequence "1".

(provider A seq1| provider B seq 1)

So it's ok to get different providers BUT only if we can force the number 1 and number 2 to have the right default one. (provider B seq1| provider A seq 2)

I tried to export a test item with many fields And we saw a strange "2 lines per item csv" with a sequence, wich can be set to 1 or 2 ...

here's a sample:

id  default_code    name    standard_price  list_price  seller_ids/id   seller_ids/product_code seller_ids/delay    seller_ids/name/id  seller_ids/pricelist_ids/id seller_ids/pricelist_ids/name   seller_ids/pricelist_ids/price  seller_ids/pricelist_ids/min_quantity   seller_ids/product_name seller_ids/min_qty  seller_ids/company_id/id    seller_ids/sequence type    procure_method  supply_method   categ_id/id product_tmpl_id
__export__.product_product_72319    WAT041958   NEEDLE.HYPO. 17 GAGE SS | Waters | origin IRELAND   20.86   29.8    __export__.product_supplierinfo_210467      1   __export__.res_partner_277                      0   base.main_company   1   product make_to_order   buy __export__.product_category_7   
        NEEDLE.HYPO. 17 GAGE SS | Waters | origin IRELAND           __export__.product_supplierinfo_72324       1   base:f0105ce4-1691-11e2-9293-080027a32563.res_partner-4ZZM9aKkGWp0                      0   base.main_company   2   product make_to_order   buy __export__.product_category_7

**Reimporting this, led again to the creation of another set of providers with correct sequence data

* :But as it adds *again the same list of providers (provider B seq1| provider A seq 2) the original one is still there so we can't get a new correctly ordered list of providers. (provider A seq1| provider B seq1| provider A seq 2)

insteads of wanted : (provider B seq1| provider A seq 2)

What ca n I do ?

Thank you

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

1 follower(s)


Asked: 2/24/14, 4:58 AM
Seen: 719 times
Last updated: 3/16/15, 8:10 AM