如何使用我的 sql 查询删除 woocommerce 中已完成的订单 [英] how to delete completed orders in woocommerce using a my sql query

问题描述

我想使用单个我的 sql 查询删除 woocommerce 中已完成的所有订单.因为，我的 WordPress Dashboard 有问题.我无法从后端查看已完成的订单.越来越空白了我有 7,823 个已完成的订单.我希望这就是我在查看 Completed Orders 时看到白页的原因.

I want to delete completed all orders in woocommerce by using a single my sql query. Because, I'm having a problem with my WordPress Dashboard. I can't view the completed orders from the back-end. It's getting blank. I have 7,823 Completed Orders. I hope that's why I seen white page when I'm going to view the Completed Orders.

有没有办法，我可以使用 MySQL 查询删除所有 Completed Orders.所以，我可以在 PHPMYADMIN 中运行它.

Is there have a way to, That I can delete all Completed Orders using MySQL query. So, that I can run it in PHPMYADMIN.

有任何建议.

推荐答案

Woocommerce 订单存储在 post 表、postmeta 表、woocommerce_order_items 表中> 和 woocommerce_order_itemmeta 表.订单的各个部分存储在不同的表中.除此之外，订单状态通过存储订单状态列表的 taxonomies 进行管理.任何正在/将要编写此查询的人都必须至少编写 5-6 个查询或单个大型连接查询.

Woocommerce orders are stored in the post table, postmeta table, woocommerce_order_items, and woocommerce_order_itemmeta tables. Various parts of an order are stored in different tables. addition to that the order status is managed through the taxonomies which stores the order status list. Anyone who is/will be writing this query have to write at least 5-6 queries minimum or single large join query.

因此，如果您没有更大的产品设置，我对您的建议应该卸载 WooCoomerce.为此，您可以点击此链接，这将删除数据

So, my suggestion to you should uninstall WooCoommerce, if you don't have much larger product setup. To do this you can follow this link which will delete the data

这篇关于如何使用我的 sql 查询删除 woocommerce 中已完成的订单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！