odoo - 在 Odoo 10 中将产品数量设置为 0

Question

我们已准备好将实例部署到生产环境，我目前正在清理在此过程中生成的所有演示数据。

我通常按照以下步骤来清理主要样本数据:

通过 SSH 连接到服务器

su postgres
psql abc_db_name

delete from stock_pack_operation;
delete from stock_picking;
delete from stock_move;
delete from account_invoice;
delete from account_partial_reconcile;
delete from account_move;
delete from sale_order;
delete from account_payment;

我现在面临的主要问题是将所有产品数量设置为 0 而不删除产品。我需要运行什么查询来设置此设置以重置它们并从头开始库存？

Answer 1

你可以尝试:

UPDATE stock_quant SET qty=0;