Descripción
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
Capturas
Preguntas frecuentes
-
What is Spreadsheet Sync for WooCommerce?
-
Spreadsheet Sync for WooCommerce is a WooCommerce Google Sheets integration plugin that helps store owners export, manage, and sync WooCommerce products and orders using Google Sheets and the included WooSync Google Sheets Add-on.
-
What is WooSync?
-
WooSync is the official Google Sheets Add-on for Spreadsheet Sync for WooCommerce. It helps connect Google Sheets with WooCommerce stores for spreadsheet-based product and order management.
-
What data can Spreadsheet Sync for WooCommerce export to Google Sheets?
-
Spreadsheet Sync for WooCommerce can export WooCommerce product and order data including product title, SKU, stock quantity, regular price, sale price, categories, attributes, images, customer details, order totals, order status, and more.
-
Can I sync WooCommerce products to Google Sheets?
-
Yes. Spreadsheet Sync for WooCommerce allows WooCommerce product data to be synced and managed through Google Sheets.
-
Can I sync WooCommerce orders to Google Sheets?
-
Yes. Spreadsheet Sync for WooCommerce allows you to manually sync WooCommerce orders to Google Sheets whenever needed.
-
Can I edit WooCommerce products directly from Google Sheets?
-
Yes. You can update WooCommerce product data such as stock, SKU, prices, status, categories, and more directly from Google Sheets using the WooSync Google Sheets Add-on.
-
Can I bulk edit WooCommerce products using Google Sheets?
-
Yes. Spreadsheet Sync for WooCommerce makes it easy to bulk update WooCommerce products using a spreadsheet interface in Google Sheets.
-
Does Spreadsheet Sync for WooCommerce support WooCommerce variable products?
-
Yes. Spreadsheet Sync for WooCommerce supports simple products, variable products, and product variations.
-
Can I sync WooCommerce inventory and stock quantities?
-
Yes. Stock quantities and inventory-related fields can be updated and synced between WooCommerce and Google Sheets.
-
Does Spreadsheet Sync for WooCommerce support product categories and attributes?
-
Yes. Spreadsheet Sync for WooCommerce supports WooCommerce product categories, attributes, and variation-related data.
-
Can I manage WooCommerce prices from Google Sheets?
-
Yes. Regular prices and sale prices can be updated directly from Google Sheets and synced back to WooCommerce.
-
Can I export WooCommerce customer data to Google Sheets?
-
Yes. Spreadsheet Sync for WooCommerce can export WooCommerce customer details including customer names, email addresses, order totals, purchased items, and order statuses.
-
Can I map WooCommerce fields to custom Google Sheets columns?
-
Yes. Spreadsheet Sync for WooCommerce allows you to arrange and manage the order of WooCommerce fields and Google Sheets columns directly from the plugin interface for flexible spreadsheet mapping workflows.
-
Does Spreadsheet Sync for WooCommerce require coding knowledge?
-
No. Spreadsheet Sync for WooCommerce is beginner-friendly and designed for WooCommerce store owners without coding experience.
-
Is the WooSync Google Sheets Add-on included with the plugin?
-
Yes. The WooSync Google Sheets Add-on is included and works together with the Spreadsheet Sync for WooCommerce plugin.
-
Does Spreadsheet Sync for WooCommerce support manual synchronization?
-
Yes. You can manually trigger synchronization anytime from the WooSync Google Sheets Add-on dashboard.
-
Is Spreadsheet Sync for WooCommerce compatible with WooCommerce HPOS?
-
Yes. Spreadsheet Sync for WooCommerce is compatible with WooCommerce High-Performance Order Storage (HPOS).
-
Does Spreadsheet Sync for WooCommerce work with WPML and multilingual stores?
-
Yes. Spreadsheet Sync for WooCommerce supports WPML and multilingual WooCommerce websites.
-
Does Spreadsheet Sync for WooCommerce support WordPress multisite?
-
Yes. Spreadsheet Sync for WooCommerce supports WordPress multisite environments.
-
Can Spreadsheet Sync for WooCommerce handle large WooCommerce stores?
-
Yes. Spreadsheet Sync for WooCommerce is designed to work with WooCommerce stores containing large product catalogs and order data.
-
Does Spreadsheet Sync for WooCommerce slow down WooCommerce websites?
-
No. Spreadsheet Sync for WooCommerce is optimized for performance and designed to work efficiently with WooCommerce websites.
fds
Yes. Spreadsheet Sync for WooCommerce uses secure OAuth 2.0 authentication and protected API communication for secure data synchronization. -
Can I connect multiple Google Sheets with Spreadsheet Sync for WooCommerce?
-
Yes. Spreadsheet Sync for WooCommerce supports connecting and managing multiple Google Sheets for different workflows and stores.
-
Can I use Spreadsheet Sync for WooCommerce for WooCommerce inventory management?
-
Yes. Spreadsheet Sync for WooCommerce is useful for WooCommerce inventory management, stock tracking, and spreadsheet-based product management workflows.
-
Can I use Google Sheets as a WooCommerce product manager?
-
Yes. Spreadsheet Sync for WooCommerce allows Google Sheets to function as a lightweight WooCommerce product management interface.
-
Can Spreadsheet Sync for WooCommerce help with WooCommerce reporting and analytics?
-
Yes. Spreadsheet Sync for WooCommerce helps store owners create WooCommerce reports, inventory reports, sales tracking sheets, and analytics workflows using Google Sheets.
-
Is Spreadsheet Sync for WooCommerce suitable for WooCommerce dropshipping workflows?
-
Yes. Spreadsheet Sync for WooCommerce can help manage supplier sheets, dropshipping workflows, stock tracking, and spreadsheet-based WooCommerce operations.
-
Yes. Spreadsheet Sync for WooCommerce works on most WordPress hosting environments that support WooCommerce and outbound API connections.
-
What makes Spreadsheet Sync for WooCommerce different from other WooCommerce Google Sheets plugins?
-
Spreadsheet Sync for WooCommerce combines a WordPress plugin and the dedicated WooSync Google Sheets Add-on to provide a seamless WooCommerce spreadsheet management experience with product and order synchronization support.
Reseñas
No hay reseñas para este plugin.
Colaboradores y desarrolladores
Este software es de código abierto. Las siguientes personas han contribuido a este plugin.
Colaboradores
Traduce “Spreadsheet Sync for WooCommerce” a tu idioma.
¿Interesado en el desarrollo?
Revisa el código, echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.
Registro de cambios
1.0.1
- Bug Fixes and UI Improvements
1.0.0
- Initial release: Export WooCommerce products to Google Sheets, field mapping, manual and scheduled sync, OAuth 2.0 authentication, error logging.