RawType Order Exporter — Spreadsheet & CSV for WooCommerce
| 开发者 | rawtypedev |
|---|---|
| 更新时间 | 2026年5月5日 22:38 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 6.9 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
RawType Order Exporter — Spreadsheet & CSV for WooCommerce lets you build custom data queries visually and download WooCommerce orders, customers and products as Excel (.xlsx) or CSV files with smart filters — no coding required.
Whether you need a quick order report for your accountant, a filtered product list for inventory, or a full customer spreadsheet for your CRM, this plugin handles it in seconds.
Why Choose This Plugin?
- Visual Query Builder — drag, drop and configure fields without writing a single line of code
- Export to Excel & CSV — native .xlsx and .csv support, ready to open in Excel, Google Sheets or LibreOffice
- Woo Orders Export — download orders with all details: status, totals, line items, shipping, billing and custom fields
- Product & Customer Data — not just orders — get products with variations, stock, prices, and customers with purchase history
- Smart Filters — filter by date range, order status, product category, customer role and more before downloading
- Bulk Processing — handle thousands of rows efficiently with background processing
- Modern React Interface — fast, responsive admin panel powered by the WordPress REST API
- HPOS Compatible — fully compatible with WooCommerce High-Performance Order Storage
- Lightweight & Fast — minimal footprint, loads only on plugin pages
- Translation Ready — fully internationalized with translations for 10 languages included
- WooCommerce 8.2+ (including HPOS)
- WordPress 5.8+
- PHP 7.4+
- Excel, Google Sheets, LibreOffice, Numbers
- Scheduled automatic reports (daily, weekly, monthly)
- Direct Google Sheets integration
- Advanced calculated columns
- Email delivery of spreadsheet files
- Priority support
- View Pro features →
安装:
- Go to Plugins → Add New in your WordPress admin and search for "Export Orders to Excel".
- Click Install Now, then Activate.
- Navigate to WooCommerce → Export Excel to start building your first query.
- WordPress 5.8 or higher
- WooCommerce 8.2 or higher
- PHP 7.4 or higher
屏幕截图:
常见问题:
How do I export Woo orders to Excel?
Go to WooCommerce → Export Excel, select "Orders" as your data source, choose the fields you want to include (order number, status, customer name, totals, line items, etc.), apply any filters, and click Export to Excel. Your .xlsx file downloads instantly.
Can I export Woo orders to CSV?
Yes. When building your query, choose CSV as the output format instead of Excel. The CSV file is generated with the same visual query builder, filters and field selection.
What data can I export?
Three data types are available: orders (with line items, billing, shipping, totals, custom fields), products (with variations, stock, prices, categories, images), and customers (with purchase history, addresses, roles).
Does it support WooCommerce HPOS (High-Performance Order Storage)?
Yes, the plugin is fully compatible with WooCommerce HPOS. It works with both the legacy posts-based storage and the new custom order tables.
Can I filter orders before exporting?
Absolutely. The visual query builder includes smart filters: date range, order status (processing, completed, refunded, etc.), product category, customer role, payment method, and more. Only matching orders appear in your Excel or CSV report.
Does it work with large stores?
Yes. The engine handles large datasets efficiently. For very large stores, processing runs in the background so your browser stays responsive.
Is this plugin free?
The free version includes full functionality for orders, products and customers with the visual query builder. The Pro version adds scheduled reports, Google Sheets integration, calculated columns and email delivery.
Where can I get support?
Use the WordPress.org support forum for free plugin support. Pro users receive priority support at rawtype.dev.
更新日志:
1.0.7
- Fix: XLSX export failed in production with "Unable to create the export file." The Strauss build did not rewrite vendor namespace references in plugin source, so PhpSpreadsheet class checks always returned false against the prefixed
RawTypeOE\Vendor\namespace. Enable Straussupdate_call_sitesso call sites inincludes/andadmin/are updated at build time. - Fix: Repair Strauss-prefixed
vendor-prefixed/references where the rewriter collapsed self-named packages (e.g.\ZipStream\ZipStream) to a single segment. Without the trailing class name the return type resolved relative to the current namespace and XLSX writes failed at runtime withTypeError. - Performance: Custom-fields scanner now runs a single grouped scan with
COUNT(*)instead ofCOUNT(DISTINCT)plus a separate sample query. On large stores (100k+ orders) the previous shape blocked the REST request long enough for the browser to give up; the new query stays on the meta_key index and returns in well under a second.
- Dev: Ship the React/JSX sources (
src/admin/) and build tooling (webpack.config.js,package.json) inside the plugin ZIP so the bundled admin JavaScript is fully reproducible from public source, per WordPress.org guideline #4. - Dev: Update Plugin URI to
https://rawtype.dev/es/rawtype-order-exporter-woocommerce(now publicly resolvable). - Dev: Drop the vendored PhpSpreadsheet documentation file whose name contained a space (cross-filesystem compatibility).
- Dev: Ship a phpcs.xml.dist at the plugin root so IDE linters pick up the correct text domain (
rawtype-order-exporter-woocommerce) and stop reporting spurious TextDomainMismatch errors.
- Security: harden Content-Disposition header (RFC 6266) and strip CR/LF in download responses to prevent header injection.
- Security: drain all output buffers before streaming downloads so binary files cannot be corrupted by stale buffers.
- Security: reject null bytes and leading
../segments in download path resolution. - Security: neutralize spreadsheet formula injection in CSV and XLSX exports — cells starting with
=,@, tab, or non-numeric+/-are written as literal text, while negative prices stay numeric. - Fix: order/product/stock status codes are now translated in exported files (matching the preview) instead of leaking raw slugs like
wc-processing. - Fix: customer export resolves the most recent order via a single batched query (was one query per customer) and skips the lookup entirely when last-order columns are not selected.
- Fix: order pagination now sorts by ID instead of
date_created, so chunks remain stable when multiple orders share the same timestamp (no more duplicated/missing rows).
- Fix: Clean release packaging for WordPress.org by excluding development-only files from the distributable plugin.
- Fix: Harden custom field scanner queries and customer metric filters for better Plugin Check compatibility.
- Fix: Improve test/bootstrap stubs used during development to avoid false positives in preflight checks.
- Fix: Resolve all Plugin Check warnings — proper SQL prepare() usage and phpcs annotations.
- Fix: Include composer.json in build ZIP to satisfy Plugin Check vendor directory requirement.
- Fix: Minor improvements and compatibility checks.
- Initial release of RawType Order Exporter — Spreadsheet & CSV for WooCommerce.
- Visual query builder for orders, products and customers.
- Excel (.xlsx) and CSV formats.
- Smart filters: date range, order status, categories, customer roles.
- WooCommerce HPOS compatibility.
- Translations for 10 languages included.