acowebs

<p>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.</p>
<h3>Features</h3>
<ul>
<li>🔹 Real-time and scheduled sync of WooCommerce products and orders to Google Sheets.</li>
<li>🔹 Export product fields: title, SKU, price, stock, categories, images, and custom fields.</li>
<li>🔹 Export order fields: order ID, status, customer details, products, totals, and more.</li>
<li>🔹 Supports simple and variable products.</li>
<li>🔹 Manual sync option.</li>
<li>🔹 Map WooCommerce fields to custom Google Sheet columns.</li>
<li>🔹 Secure OAuth 2.0 authentication with Google.</li>
<li>🔹 Google Sheets Add-on for enhanced management and automation.</li>
<li>🔹 Error logging and sync status notifications.</li>
<li>🔹 Compatible with major WooCommerce extensions.</li>
<li>🔹 Multisite and WPML support.</li>
</ul>
<h3>External Services</h3>
<p>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.</p>
<ul>
<li>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.</li>
<li>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.</li>
<li>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.</li>
<li>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.</li>
<li>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.</li>
<li>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.</li>
<li>Google terms of service: https://acowebs.com/terms-conditions</li>
<li>Google privacy policy: https://acowebs.com/privacy-policy</li>
</ul>
<h3>Source Code</h3>
<p>The source code for the compiled JavaScript and CSS files in the <code>admin/build/</code> directory is included in this plugin and can be found in the <code>app/</code> directory.</p>
<h4>Building from Source</h4>
<p>This plugin uses Vite as a build tool. To rebuild the assets from source:</p>
<ol>
<li>Navigate to the <code>app/</code> directory</li>
<li>Install dependencies: <code>npm install</code></li>
<li>Build for production: <code>npm run build</code></li>
</ol>
<p>The build process will generate the compiled files in the <code>admin/build/</code> directory.</p>
<p>For development with hot module replacement:<br />
    npm run dev</p>


Spreadsheet Sync for WooCommerce

Sync WooCommerce product and order data with Google Sheets in real-time. Export, update, and manage products and orders from a Google Sheet.

Olivier Bigras

<p>SFTP Sync for Google Sheets allows you to automatically export Google Sheets and upload them to any SFTP server. Use cases include:</p>
<ul>
<li>Daily inventory updates from Google Sheets</li>
<li>Automated data feeds for e-commerce</li>
<li>Syncing spreadsheet data to your server</li>
<li>Backing up Google Sheets to your own server</li>
</ul>
<p><strong>Features:</strong></p>
<ul>
<li><strong>Easy Setup</strong> – Configure everything from the WordPress admin</li>
<li><strong>Secure API</strong> – Auto-generated API keys protect your endpoint</li>
<li><strong>REST API Endpoint</strong> – Receives files from Google Apps Script</li>
<li><strong>SFTP Upload</strong> – Automatically uploads to your SFTP server</li>
<li><strong>Activity Logs</strong> – Track all uploads and errors</li>
<li><strong>Pre-built Script</strong> – Copy-paste Google Apps Script included</li>
<li><strong>No paid services required</strong> – Uses Google Apps Script and your SFTP server</li>
</ul>
<p><strong>How It Works:</strong></p>
<ol>
<li>Install and activate the plugin</li>
<li>Configure your SFTP credentials in Settings</li>
<li>Copy the provided Google Apps Script to your Sheet</li>
<li>Set up a daily trigger in Google Apps Script</li>
<li>Your sheet automatically syncs to your SFTP server</li>
</ol>


SFTP Sync for Google Sheets

Automatically receive Google Sheets exports and upload them to your SFTP server. Supports daily automated syncs.

Spreadsheet Sync for WooCommerce vs SFTP Sync for Google Sheets