WooCommerce HPOS Certified • Native Microsoft Graph OAuth 2.0

Sync WooCommerce Orders to Microsoft Excel in Real-Time

Q: Does this plugin require an active Microsoft or Office 365 account?

Yes. You need a Microsoft account (Work/School or Personal) with access to OneDrive or SharePoint and Excel Online.

Q: How does in-place order status updating work?

When an order status changes (e.g. from Processing to Completed or Refunded), the plugin locates the existing row in Excel matching the Order Number and updates the status cell in place instead of creating duplicate rows.

Q: Can I export individual product line items on separate rows?

Yes. You can choose between Order Summary mode (1 row per order) or Product Details / Line Items mode (1 row per purchased item with SKU, quantity, and line totals).

Eliminate manual CSV exports and recurring monthly automation fees. Automatically stream your WooCommerce orders, customer details, and in-place status changes directly into Microsoft Excel Online with zero delay.

Get the Plugin Documentation

Direct Azure OAuth (Zero Middleman) In-Place Status Updates 1-Click Historical Batch Import Automated WP-Cron Retry Queue

Excel Online — WooCommerce_Orders_2026.xlsx (Sheet1)

Order #	Date	Customer	Status	Total	Items
1082	Oct 24	Alex Rivera	Completed	$89.00	Canvas Backpack (x1)
1083	Oct 25	Elena Rostova	Completed	$240.00	Studio Headphones (x2)
1084	Just now	Sarah Jenkins	Processing	$149.00	Ergonomic Keyboard (x1)

Row appended to Excel Table via Microsoft Graph API!

Why Direct Microsoft Graph?

Stop Overpaying for Third-Party Middlemen

Traditional webhook tools charge steep monthly subscriptions and clutter your spreadsheets with duplicate rows every time an order updates.

Third-Party Automation Platforms

Expensive task bills that multiply as your order volume scales.
Privacy risk: Third-party servers intercept, decrypt, and log customer PII.
Duplicate row mess: Adding a new row for every order status change.
No native historical bulk import: Painful to import thousands of past orders.

WP Prism Microsoft Excel Integration

Unlimited order syncs: One flat license with zero per-order charges.

100% Data Ownership: Direct server-to-Microsoft Azure connection.

Smart In-Place Updates: Automatically updates existing rows when status changes.

1-Click Historical Importer: Fast AJAX bulk sync with duplicate prevention.

Feature Suite

Engineered for High-Volume eCommerce Stores

Everything you need to automate your accounting, inventory reports, and order fulfillment spreadsheets.

Real-Time Instant Synchronization

Orders sync the exact instant they are placed or paid for. Bypasses delayed Action Scheduler queues to ensure your spreadsheets are always current.

Smart In-Place Row Updates

When an order changes status (e.g. Processing $\rightarrow$ Completed or Refunded), the plugin finds the existing row and updates it via Microsoft Graph PATCH rather than creating duplicates.

Summary & Line Items Dual Modes

Choose Order Summary mode (1 row per order with customer and total amounts) or Product Line Items mode (1 row per product item with SKU, quantity, and item pricing).

1-Click Historical Batch Importer

Bulk import existing WooCommerce orders into Excel. Filter by order status or custom date ranges, with automatic duplicate detection to prevent re-syncing previously logged orders.

Multi-Workbook & Multi-Sheet Routing

Create unlimited sync feeds targeting different Excel workbooks or multiple worksheets simultaneously using comma-separated tab names (e.g. Sheet1, Orders, Fulfillment).

Native Azure OAuth 2.0 Security

Authorize directly via Microsoft identity platform with your own Azure Application ID and Secret. Supports Personal OneDrive, Office 365, SharePoint, and Single-Tenant accounts.

Custom Column Heading Mapper

Select which order fields to export and rename the corresponding Excel column headings to match your existing spreadsheet headers without altering your Excel formulas.

Automated Retry Queue & Audit Log

Built-in WP-Cron retry mechanism automatically re-attempts failed entries if Microsoft Graph is temporarily unreachable, backed by a searchable activity log with 1-click manual retry.

WooCommerce HPOS Certified

Fully compliant with WooCommerce High-Performance Order Storage (HPOS) and legacy custom post order storage, guaranteeing lightning performance on stores of any scale.

Simple 4-Step Setup

Up and Running in Under 3 Minutes

No coding, webhook configurations, or complex server setups required.

Connect Microsoft Account

Paste your Azure Client ID and Secret, then click Connect to authorize via secure OAuth 2.0.

Select Excel Workbook

Paste your Excel Online browser URL or docId and specify the worksheet tab name.

Map Columns & Triggers

Choose which order statuses trigger syncs and customize your Excel table column headers.

Enjoy Real-Time Sync

Watch orders and status updates automatically stream into your cloud spreadsheets in real-time.

Freemius Protected

Simple, Transparent Pricing

One plugin to automate all your WooCommerce order and accounting reporting in Microsoft Excel.

Starter Monthly

$4/mo

Unlimited WooCommerce Orders
Native Azure OAuth 2.0
In-Place Row Status Updates
Summary & Line Items Modes
Historical Batch Order Importer
Automated WP-Cron Retry Queue
1 Site License & Standard Support

Frequently Asked Questions

Everything you need to know about syncing WooCommerce orders to Microsoft Excel Online.

Does this plugin require an active Microsoft or Office 365 account?

Yes. You need a Microsoft account (Work/School Office 365 or Personal OneDrive) with access to Excel Online. The plugin connects directly to your own account via Microsoft Azure App registration.

Do my Excel sheets need to be formatted as a Table?

Yes. Microsoft Graph API requires Excel spreadsheets to have headers formatted as a Table. In Excel Online, simply highlight your header row and click Home → Format as Table.

How does in-place order status updating work?

When an order status changes (for example, from Processing to Completed or Refunded), the plugin locates the existing row in Excel matching the Order Number and updates the status cell in place instead of creating duplicate rows.

Can I export individual product line items on separate rows?

Yes! You can choose between Order Summary mode (1 row per order) or Product Details / Line Items mode (1 row per purchased item with SKU, quantity, and line totals).

Is this plugin compatible with WooCommerce HPOS (High-Performance Order Storage)?

Yes, the plugin is 100% compatible with WooCommerce High-Performance Order Storage (HPOS) as well as traditional WordPress post storage.

Can I import past/historical WooCommerce orders?

Yes, the plugin includes a built-in historical order batch importer with date range filters, status filters, and duplicate prevention to sync existing orders in seconds.

Ready to Automate Your WooCommerce Accounting?

Streamline your order reporting and stop wasting hours manually copying data. Connect WooCommerce to Microsoft Excel Online today.

Get the Plugin Now