轻松导出您的所有订单或注册客户,按价格、日期、客户、产品、产品变体、产品类别、订单状态过滤结果!
现场演示
https://www.codecanyondemo.work/wcoei/wp-admin/
用户:demo
通行证:演示
CSV 导出变得简单
WCOE 是一个快速而强大的工具,可让商店管理员一步导出订单或注册客户和访客客户。
强大的过滤器
您是否曾经需要只导出一个或一组客户的一些订单?包含一些特定产品的出口订单?
查找在一段时间内购买过或至少花费了一定金额的所有客户?导出完整的客户列表?
现在你可以了!
通过 WCOE 插件,您可以导出所有 shop orders 和注册/访客客户的筛选结果
- 订单状态
- 产品和变体
- 产品分类
- 客户
- 每个订单的总花费金额(范围值:最小值/最大值)
- 每位客户的总花费金额(仅当至少选择了一个客户时)
选择要导出的订单信息
商店管理员可以选择要导出的订单信息…他可以在 40 多个中进行选择!
产品自定义字段导出
WCOE 将选择性地导出产品自定义文本字段。它已经过 WooCommerce 产品附加组件 和WC Fields 工厂.其他插件尚未经过测试,可能不兼容。
Item custom fields 列将包含使用以下格式的所有自定义字段:
Product1 field label1: custom field1 value ***** Product1 field label2: custom field value2 | Product2 field label1: custom field1 value ***** Product2 field label2: custom field value2
有关详细信息,请参阅上面的示例文件链接。
订单和结帐自定义字段导出
WCOE 将选择性地导出使用 WooCommerce 自定义字段, 产品附加组件, WooCommerce 的订单交货日期 和 User Extra Fields (User Extra Fields:将仅导出标记为另存为订单额外字段的字段)。
Checkout 自定义字段列将包含使用以下格式的所有自定义字段:
Custom field label1: custom field1 value | Custom field label2: custom field2 value
导出的文件示例
生成的示例 订单 CSV
生成的示例 客户 CSV
客户出口 .CSV 与“WOOCOMMERCE CUSTOMER MANAGER”兼容
导出的客户.csv文件与 100% 兼容 WooCommerce 客户经理 插件。您可以毫无问题地导入整个客户列表!
如何导入 EXCEL
按照以下步骤,可以轻松地将生成的文件导入 excel:
- 运行 Excel
- 导入数据 数据 -> 导入外部数据(或从文本导入) -> 导入数据
- 选择 csv 文件类型并浏览.csv文件所在的目录
- 在导入向导中,选择 分隔 文件类型并更改文件来源 自65001 统一码 (UTF-8) (相当在列表的底部)
- 单击 Next 按钮并将分隔符更改为 逗点 (或分号,取决于您选择的分隔符)
- 点击 完成 按钮
WPML 兼容
WCOE 与 WPML 兼容
WooCommerce预售、时间优惠和到期系统
想要导出至少在预售商品上的客户或订单(通过WooCommerce预售、时间优惠和到期系统进行预售管理)吗?
只需在导出配置期间选中特殊选项,插件就会生成一个 csv,其中仅包含至少有一个预售商品的订单(或客户)!
产品过滤器
出口订单包括 OLNY 一些产品。搜索使用产品名称、SKU 或 ID!
日期筛选器
多选
客户筛选
要导出的 COLUMN/INFO
更改日志
= 5.1 - 30.05.25 = * Security improvements = 5.0 - 04.07.24 = * Support for HPOS = 4.9 - 17.01.22 = * Fixed an issue that prevented the invoice number to be properly exported (WooCommerce PDF Invoices & Packing Slips) = 4.8 - 04.12.21 = * Added invoice number (WooCommerce PDF Invoices & Packing Slips) * Minor bugfixes = 4.7 - 02.12.21 = * Added customer IP address option for order export = 4.6 - 07.07.21 = * Code redesign = 4.5 - 10.12.20 = * Fixed an issue due to order and customers were not properly exported = 4.4 - 05.09.20 = * CSV now reported country and state names instead of codes = 4.3 - 16.05.19 = * The plugin now exports order vat number (created using the WooCommerce Eu Vat & B2B plugin) = 4.2 - 17.07.17 = * Fixed an issue that may prevent order to be exported = 4.1 - 15.06.17 = * Added option to export orders that have at leat one item that was in pre-sale: https://codecanyon.net/item/woocommerce-presale-time-offer-expiring-system/13335433 = 4.0 - 07.05.17 = * Added support to WPUEF order fields = 3.9 - 07.04.17 = * Improved compatibility with WooCommerce 3.0.4 = 3.8 - 15.12.16 = * Minor bugfix = 3.7 - 29.11.16 = * Fixed an issue due to Shipping country and state were swapped = 3.6 - 27.06.16 = * Fixed an issue with WooCommerce 2.6 = 3.5 - 01.06.16 = * Added support to "Order Delivery Date for WooCommerce" plugin = 3.4 - 31.05.16 = * Fixed a bug due to the order date and user roles column were inverted = 3.3 - 21.01.16 = * Feature added: is now possible exporting filtering by product variations = 3.2 - 23.01.16 = * Support for WooCommerce Custom Fields & Product Add-ons = 3.1 - 23.01.16 = * Role reporting on csv = 3.0 - 20.01.16 = * Support for guest customers = 2.9 - 18.01.16 = * Bug fix on customer search field = 2.8 - 10.12.15 = * Added 2 new columns: order private notes and order notes to customer = 2.7 - 10.12.15 = * Css bugfix = 2.6 - 07.12.15 = * Bugfix = 2.5 - 26.11.15 = * Fixed a bug that could prevend the correct "order note" field exportation = 2.4 - 23.11.15 = * Bugfix = 2.3 - 18.11.15 = * Added "Orders note" column = 2.2 - 17.11.15 = * Bugfix on "Shipping method" column = 2.1 - 12.11.15 = * httpss Bugfix = 2.0 - 09.11.15 = * Bugfix = 1.9 - 26.10.15 = * Bugfix = 1.8 - 20.10.15 = * Bugfix = 1.7 - 20.10.15 = * Bugfix = 1.6 - 19.10.15 = * Added custom field exportation = 1.5 - 01.10.15 = * Added logic operators = 1.4 - 23.09.15 = * Added new column for products SKUs = 1.3 = * Is now possible select which columns to export = 1.2 = * bugfix with unicode to utf8 encoding * added order date column to csv = 1.1 = * New filter: by customer total amount spent (used only if at least one customer has been selected) = 1.0 = * Release