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 ?
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
|Asked: 2/24/14, 4:58 AM|
|Seen: 719 times|
|Last updated: 3/16/15, 8:10 AM|