如何在odoo 8中导入QOH [英] how to import QOH in odoo 8
问题描述
我想通过odoo前端或使用后端(postgres查询)更新odoo中的股票.
I want to update my stock in odoo either its by odoo frontend or using backend (postgres query).
csv文件中有我的股票价值.
I have my stock value in csv file.
最后,我想批量更新现有数量.
Finally, I want to update quantity on hand in bulk.
推荐答案
终于解决了,只需遵循以下步骤
It's finally solved, simply follow the step
步骤– 1;
1-> 在仓库模块中选择产品(在列表视图中打开).
1-> select product in warehouse module (open in list view).
2-> 选择要更新库存的产品.
2-> select the product which you want to update the inventory .
3-> 单击更多按钮并导出列
3-> click on more button and export column
i->产品名称,以及您需要的任何其他名称.
i-> product name and any other one if you needed .
您具有名称为 product.temlate.csv 的文件.
4-> 添加数量列并输入产品数量.
4-> Add a column qty and enter the quantity of product .
步骤– 2;
1-> 在仓库模块中选择库存调整.
1-> select inventory adjustment in warehouse module .
2-> (如果您已经有任何已创建的库存),请转到第3点(如果没有),然后创建库存并感受细节.并在-的库存中选择所有产品选项:
2-> if you already have any created inventory then go to 3rd point if not then create a inventory and feel the detail . and select all product option in Inventory of - :
3-> 现在再次单击库存调整并选择库存.
3-> now again click on inventory adjustment and select the inventory.
4-> 单击更多并导出以下列
4-> click on more and export the following column
库存/位置
Inventories/location
库存/产品
Inventories/product
库存/产品计量单位.
Invevtories/product Unit of Measure .
现在您还有一个名为 stock.inventory.csv
步骤-3->
1-> 现在在 stock.inventory.csv
第一个是 名称 ,第二个是 line_ids/product_qty .
First one is name and second is line_ids/product_qty.
并删除 id 列.
2-> 删除 stock.inventory.csv 的列 line_ids/product_id/id 的值文件.
2-> delete the value of column line_ids/product_id/id of stock.inventory.csv file .
现在从 product.template.csv 复制 id 列的值,然后粘贴到 line_ids/product_id stock.inventory.csv 的/id 列.
now copy the values of id column from product.template.csv and paste into the line_ids/product_id/id column of stock.inventory.csv .
3-> 现在从 product.template.csv 复制 qty 列的值并粘贴到 stock.inventory.csv 的 line_ids/product_qty 列.
3-> now copy the values of qty column from product.template.csv and paste into the line_ids/product_qty column of stock.inventory.csv .
4-> 在 名称 列中输入任何值以供参考.
4-> enter any value in name column for your reference .
步骤– 4-
确保您的文件看起来像这个文件:-
make sure your file look like this file:-
点击以下链接查看文件
这是成功导入的数据的示例
This is a sample of the succesfully imported data
导入后忘记开始库存
AFTER IMPORTING DONT FORGET START INVENTORY
这篇关于如何在odoo 8中导入QOH的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!