SoftIcon Sheet Sync for WooCommerce

Updating stock or prices one product at a time is slow. SoftIcon Sheet Sync puts every product and variation in a Google Sheet, one row each. Edit the sheet and WooCommerce updates within seconds. Change something in WooCommerce, or sell something, and the sheet updates too.

Everything is free. There is no premium version, no product limit and no locked features.

Features

• Two-way sync between WooCommerce and Google Sheets.
• Instant updates from the sheet: a small Apps Script sends each edit to your store and writes the result in a Sync status column, so you see right away if a value was rejected.
• Automatic updates to the sheet a few seconds after a product is saved, trashed, deleted or its stock changes after an order.
• Simple and variable products: every variation gets its own row.
• Columns you choose: name, SKU, regular price, sale price, stock (quantity or In stock / Out of stock / On backorder), status, categories, short description, description, total sales and product URL.
• Bulk editing with everything a spreadsheet offers: paste a column, fill down, find and replace.
• Sheet menu with Fetch from WooCommerce and Send all rows to WooCommerce.
• Formatted sheet: frozen header, read-only columns greyed out with an edit warning, price formats and a status dropdown.
• Scheduled full sync every 10 minutes, 30 minutes, hour or day as a safety net.
• Checks before saving: prices must be numbers, a sale price must be lower than the regular price, SKUs must be unique and categories must exist.
• Activity log of every sync and every rejected value.
• Setup wizard that explains each step and tells you exactly what to fix when Google refuses a request.

How it works

The plugin connects through a Google Cloud service account, a robot Google user that can only open the sheets you share with it. No Google SDK is bundled; the plugin calls the Google Sheets REST API directly.

Edits made in the sheet reach your store through an Apps Script you paste into the sheet once. Its requests are signed with a secret key, and requests older than five minutes are refused.

External services

This plugin connects to Google services to read and write your Google Sheet. Nothing is sent until you connect a Google account in the setup wizard.

• Google OAuth 2.0 token endpoint (https://oauth2.googleapis.com/token): exchanges a token request signed with your service account key for a temporary access token. It receives the service account email and a signed token request. It is called when you connect and about once an hour while syncing.
• Google Sheets API (https://sheets.googleapis.com): reads and writes the rows of the sheet you connect. It receives the product data in the columns you choose (for example ID, name, SKU, prices, stock, status, categories and descriptions). It is called when products change, when you run a sync and on the schedule you set.
• Google Apps Script (in your own Google account): the script you paste into the sheet sends edited rows to your site’s REST API. That data goes from your Google account to your own website only.

Google’s terms of service: https://policies.google.com/terms
Google’s privacy policy: https://policies.google.com/privacy
Google APIs terms of service: https://developers.google.com/terms