What is the best way to add suppliers to all of my products? I have an Excel list with all of my products and skus, which are also already in Odoo, but the link in between is missing. What is the best way to link suppliers with products programmatically?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Księgowość
- Zapasy
- PoS
- Project
- MRP
To pytanie dostało ostrzeżenie
OK guys, here is my solution in PHP:
function _createSupplierRelation($data){
$url = "xxx";
$db = "xxx";
$username = "xxx";
$password = "xxx";
$sku = $data[0];
$supplier_relation = $data[1];
$product_code = $data[2];
//connect
$common = ripcord::client("$url/xmlrpc/2/common");
$uid = $common->authenticate($db, $username, $password, array());
$models = ripcord::client("$url/xmlrpc/2/object");
//get odoo product id
$product = $models->execute_kw($db, $uid, $password,
'product.product', 'search_read',
array(array(array('default_code', '=', $sku)))
)[0];
//create supplier relation
$models->execute_kw($db, $uid, $password,
'product.supplierinfo', 'create',
array(array('name' => $supplier_relation, 'min_qty' => 0, 'delay' => 10, 'product_tmpl_id' => $product['id'], 'product_code' => $product_code))
);
}
Step 1. Define suppliers and read their IDS
Step 2. Export + Reimport products CSV with added suppliers IDS
Michael Aigner,
Its better if you write a script to read your excel file(that must have product_name, supplier_name, and qty_supplied) and
create a record for each supplier for respective product(for object "product.supplier_info") and tag these records to the corresponding product.
As there is a one2many for product.supplier_info in product.product, you can simply refer record to it.
Hope it help
Hi Pawan, that's exactly what I'm looking for! You don't have such a script by any chance? Thanks!
No micheal, i don't have any......
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj sięPowiązane posty | Odpowiedzi | Widoki | Czynność | |
---|---|---|---|---|
Last purchase date
Rozwiązane
|
|
2
wrz 21
|
3982 | |
Limit the product to a specific supplier
Rozwiązane
|
|
2
cze 17
|
4017 | |
|
0
paź 15
|
3446 | ||
|
1
lut 25
|
7531 | ||
|
2
mar 15
|
5220 |
let me confirm, do you want to add a unique supplier to all your products or you have a list suppliers with their products ?