Odoo Help


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

on 2/24/14, 4:58 AM 1,114 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

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


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