ChimpSheets – WooCommerce Google Sheets Two-Way Sync Plugin

Stop wasting hours on manual bookkeeping and slow catalog edits!

ChimpSheets is a lightweight, robust, and secure WooCommerce to Google Sheets integration plugin. It allows you to synchronize your orders, products, and coupons in real-time or on a background schedule. Best of all, it features Two-Way Synchronization, meaning you can edit product details directly inside Google Sheets to update your live WooCommerce website instantly!

Say goodbye to expensive monthly SaaS fees from Zapier or Make. With ChimpSheets, you get lifetime automation with zero subscription costs.

⭐ Key Highlight Features

• Bi-directional (Two-Way) Sync: Edit Product Name, SKU, Regular Price, Sale Price, Stock Status, and Stock Quantity in Google Sheets, and WooCommerce updates within seconds.
• Dynamic Column Mapping: Absolute freedom over your spreadsheet. Map WooCommerce order and product fields to any column letter (A to Z). Gaps are automatically padded.
• WP Cron Background Sync (Queue): Prevent checkout lag on slow hosting. Queue your sync actions and process them smoothly in the background every 5, 15, or 60 minutes.
• Secure Connection Options: Choose between quick Google OAuth 2.0 (Google Sign-In) authorization or Service Account JSON file upload.
• Integrated Activity Logs: Troubleshoot connections easily. View real-time sync history with explicit success/failure logs and detailed error reports inside WordPress.

Full Feature List

1. Connection & Authorization

• OAuth 2.0 Sign-In (Method A): Securely authorize using your Google Account credentials. Stored refresh token ensures lifetime sync without disconnection.
• Service Account JSON (Method : Upload a credentials file to connect. Your private keys are stored securely directly in the database.

2. WooCommerce to Sheets (Outbound Sync)

• Real-time Order Sync: Automatically sends customer names, emails, product lists, totals, statuses, and order dates on checkout.
• Order Status Updates: Changing order status in WooCommerce (e.g., Processing to Completed) automatically updates the corresponding row in Sheets.
• Real-time Product Sync: Automatically appends new products or updates existing ones on product save actions.
• Coupon Sync: Sync coupon codes, discount types, amounts, usage limits, and expiry dates to a dedicated tab.

3. Sheets to WooCommerce (Inbound Two-Way Sync)

• Live Product Editor: Modify Name, SKU, Prices, Stock Status, or Stock Quantity in Sheets to update your site.
• Auto-Stock Management: If you set stock quantity in Sheets, the plugin automatically turns on “Manage Stock” in WooCommerce if it was disabled.
• Bangla-to-English Digits Converter: Automatically converts Bengali digits (১, ২, ৩…) to English digits before saving to database to prevent system crashes.
• Smart Loop Protection: Prevents infinite update loops between WooCommerce and Google Sheets, protecting your server bandwidth.

4. Advanced System & UI Tools

• One-click Bulk Export: Batch export all existing Products, Orders, or Coupons to Google Sheets.
• AJAX Progress Bar: Exports data in safe batches of 10 items to prevent server timeout crashes on cheap shared hosting.
• Interactive Settings & Help: Features a native WordPress tabbed UI with built-in step-by-step setup guides.

Why Choose ChimpSheets?

• Saves Money: A single one-time payment replaces expensive monthly automation subscriptions.
• Secure Webhooks: Webhook operations are guarded with a 32-character security token to prevent unauthorized access.
• Zero Server Overhead: Coded strictly following WordPress and WooCommerce development standards to remain lightweight.

System Requirements

• WordPress 5.8 or higher
• WooCommerce 6.0 or higher
• PHP Version 7.4 or higher
• Standard web hosting (REST API must be enabled)

What’s Included in the Download?

• ChimpSheets WordPress Plugin (.zip)
• Google Apps Script code for Google Sheets Integration
• Documentation & Setup Guide

Changelog

v1.0.0 – Initial Release (July 2026)

• Initial release containing all core MVP features, Two-Way Sync, Custom Column Mapping, Logging, and WP Cron Scheduler.