Spreadsheet Sync For WooCommerce Wordpress Plugin - Rating, Reviews, Demo & Download
Plugin Description
Google Sheets Sync for WooCommerce enables seamless, real-time synchronization of your WooCommerce product and order data with Google Sheets. Effortlessly export, update, and manage your product catalog and orders from a Google Sheet, streamlining reporting, automation, and third-party integrations. The included Google Sheets Add-on provides advanced features for managing your store data directly within Google Sheets.
Features
- 🔹 Real-time and scheduled sync of WooCommerce products and orders to Google Sheets.
- 🔹 Export product fields: title, SKU, price, stock, categories, images, and custom fields.
- 🔹 Export order fields: order ID, status, customer details, products, totals, and more.
- 🔹 Supports simple and variable products.
- 🔹 Manual sync option.
- 🔹 Map WooCommerce fields to custom Google Sheet columns.
- 🔹 Secure OAuth 2.0 authentication with Google.
- 🔹 Google Sheets Add-on for enhanced management and automation.
- 🔹 Error logging and sync status notifications.
- 🔹 Compatible with major WooCommerce extensions.
- 🔹 Multisite and WPML support.
External Services
This plugin works with a Google Sheets Add-on service provided by the plugin owner. The Add-on uses a custom API created for this product to move data between the specific Google spreadsheet you configure and your WooCommerce store.
- Service: Google Sheets Add-on service and custom API provided by the plugin owner, plus Google authentication and Google Sheets infrastructure used by the Add-on.
- What it is used for: to sync and update selected WooCommerce product and order fields for the specific configured spreadsheet, and to validate the connection securely before passing data to the store.
- What data is sent: configured spreadsheet ID, connection/authentication metadata, and selected WooCommerce product/order fields. Product fields sent by the Add-on include type, parent_id, name, sku, attributes, regular_price, sale_price, stock, and status. Order fields sent include customer_name, customer_email, total_amount, status, and items.
- When it is sent: when you connect the Google Sheets Add-on, save the sheet settings, authorize access, run manual syncs, or when scheduled / automatic syncs occur.
- Where it is sent: to the Google Sheets Add-on service and the plugin owner’s central server, which checks the data and then forwards it only to the specific configured WooCommerce store for the selected spreadsheet.
- Conditions: this external service access only occurs after you configure a Google Sheet ID and connect the Google Sheets Add-on. The custom API is limited to the configured spreadsheet and store, and it does not poll or access other Google Sheets or stores.
- Google terms of service: https://acowebs.com/terms-conditions
- Google privacy policy: https://acowebs.com/privacy-policy
Source Code
The source code for the compiled JavaScript and CSS files in the admin/build/ directory is included in this plugin and can be found in the app/ directory.
Building from Source
This plugin uses Vite as a build tool. To rebuild the assets from source:
- Navigate to the
app/directory - Install dependencies:
npm install - Build for production:
npm run build
The build process will generate the compiled files in the admin/build/ directory.
For development with hot module replacement:
npm run dev
