Does it cost anything?
No. The plugin is completely free. A Google Cloud project with the Sheets API is free for this kind of use.
Can I add new products from the sheet?
No. Add products in WooCommerce and they appear in the sheet automatically. Rows without an ID are ignored.
Can I delete products from the sheet?
No, deleting a row does not delete the product. Trash the product in WooCommerce and its row disappears from the sheet.
Can I rename or move columns?
You can move columns, but keep the header names, because the sync finds columns by name. Choose which columns to show in WooCommerce > Sheet Sync > Settings.
Can I add my own columns?
Yes. Columns with other names are ignored by the sync, and formulas in them are not overwritten by instant sync. A full sync rewrites the rows in WooCommerce order, so keep notes that belong to a product in WooCommerce rather than next to its row.
Why does Google say the app is not verified?
When you run the Apps Script for the first time, Google warns that the script is not verified because it is your own script and not published by Google. Click Advanced, then Go to (project name) to allow it.
Edits in the sheet do not reach my store
- Your site must be reachable from the internet. Google cannot reach a local site such as
example.local. - Security plugins or firewalls must allow requests to
/wp-json/alss/v1/. - Run
alssInstallagain from the Apps Script editor; it reports whether the store could be reached. - Use Pull changes from Google Sheets on the dashboard to apply edits that were missed.
Can I test instant sync on a local development site?
Yes. Open a tunnel to the site (for example ngrok with a free static domain, or Cloudflare Tunnel) and add this line to wp-config.php:
define( 'ALSS_PUBLIC_URL', 'https://your-tunnel-address' );The Apps Script code shown in the plugin then sends edits through the tunnel. Developers can use the alss_public_url filter instead.