Description
Managing WooCommerce orders often requires sharing live order data with fulfillment teams, delivery personnel, dropship suppliers, or accountants.
TSync Sheet for WooCommerce connects your WooCommerce store directly to your Google Spreadsheet via a fast, secure Webhook. Whenever a new order is placed, customer details, line items, and totals are automatically added as a new row in your Google Sheet in real time.
🚀 Key Features (Version 1.0.0)
- Real-Time Order Synchronization: New orders trigger an automated webhook that appends order data directly to your designated Google Sheet.
- Zero Checkout Delay: Uses asynchronous non-blocking background dispatch (
wp_remote_postwith non-blocking mode), ensuring customer checkout performance is never impacted. - Built-in Connection Tester: Test your webhook URL directly from the WordPress administration settings with the “Send Test Data” button before going live.
- Concurrency Safe: The included Google Apps Script code utilizes Google’s
LockServiceto prevent data collisions during high-traffic sales. - HPOS Compatible: Fully compatible with WooCommerce High-Performance Order Storage (Custom Order Tables).
- Order Deduplication: Includes built-in metadata safeguards to ensure that individual orders are synchronized without duplication.
💡 Direct & Self-Hosted Integration
TSync Sheet communicates directly between your WordPress server and your own Google Apps Script Web App. This eliminates intermediate third-party service dependencies, keeping your order data private and under your control.
Screenshots
Installation
Setting up TSync Sheet takes only a few minutes:
Step 1: Install the Plugin
- Go to your WordPress Dashboard.
- Navigate to Plugins > Add New Plugin.
- Click Upload Plugin and select
tsync-sheet.zip. - Click Install Now and then Activate.
Step 2: Set up your Google Sheet
- Open a new Google Sheet.
- Click Extensions > Apps Script in the top menu.
- Paste the provided script code from the plugin guide into the script editor.
- Click Deploy > New deployment, select Web app, set access to Anyone, and click Deploy.
- Copy the generated Web app URL.
Step 3: Connect WooCommerce
- In your WordPress admin, go to WooCommerce > TSync Sheet.
- Paste your Web app URL into the field and click Save Settings.
- Click Send Test Data to verify your setup.
FAQ
-
Does it support WooCommerce High-Performance Order Storage (HPOS)?
-
Yes! TSync Sheet is 100% compatible with HPOS (Custom Order Tables).
-
Will it slow down my website’s checkout page?
-
No. The plugin uses asynchronous non-blocking HTTP requests. WooCommerce creates the order and finishes checkout without waiting for Google’s HTTP response.
-
Which order fields are synced to Google Sheets?
-
The plugin synchronizes: Order ID, Order Number, Date, Status, Currency, Totals, Subtotals, Shipping Cost, Payment Method, Customer Name, Email, Phone, Shipping Address, Item Details (Product Name, SKU, Quantity, Price), and Customer Notes.
Reviews
There are no reviews for this plugin.
Contributors & Developers
“TSync Sheet for WooCommerce” is open source software. The following people have contributed to this plugin.
Contributors
Translate “TSync Sheet for WooCommerce” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
1.0.0
- Initial release.
- Automated order synchronization on order creation.
- Settings screen with instant Webhook test dispatch.
- Concurrency-safe Google Apps Script template.
- Full WooCommerce HPOS compatibility.