Spreadsheet Sync for WooCommerce

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:

1. Navigate to the app/ directory
2. Install dependencies: npm install
3. 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