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:

• 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