StoreSheet – Google Sheets Sync for WooCommerce

开发者	mralaminahamed
更新时间	2026年7月18日 08:58
捐献地址:	去捐款
PHP版本:	7.4 及以上
WordPress版本:	7.0
版权:	GPL-2.0-or-later
版权网址:	版权信息

下载

1.0.0

详情介绍:

StoreSheet copies your WooCommerce products, orders, and coupons into a Google Spreadsheet and keeps them current. The work happens in the background on WordPress's own task scheduler, so it doesn't hold up the checkout or the admin. The free version syncs one way: WooCommerce to Google Sheets. Once the data is in a sheet, you can build reports on it or hand a copy to someone who doesn't have a WordPress login. What it does:

Syncs every product, order, and coupon into a Google Spreadsheet, both as they change and on a schedule.
Leaves the Overview and Reports tabs open for your own Sheets formulas, so you can put revenue totals or margin math wherever you want them.
Connects through Google OAuth 2.0. Your client secret stays on your server and is never sent to the browser.
Lets you pick which order statuses and which data types get synced.
Emails you, or pings a Slack channel, when a sync job fails for good.

How it works:

You connect a Google account with OAuth 2.0. The credentials stay on your server.
StoreSheet creates a spreadsheet with tabs for Products, Orders, Coupons, Overview, and Reports. (The Variations and Customers tabs are laid out but only filled in by StoreSheet Pro.)
When a WooCommerce event fires — a new order, a product edit, a new coupon — StoreSheet queues a job through Action Scheduler that writes that one row to the sheet.
A scheduled run (every 15 minutes by default) picks up anything the live jobs missed. Because it all runs on Action Scheduler in the background, the store keeps responding normally.

Sync coverage (free): | Tab | WC → Sheets | |---|---| | Products | ✓ | | Orders | ✓ (choose which statuses) | | Coupons | ✓ | | Overview | Formula dashboard | | Reports | Formula analytics | If a job fails for good, StoreSheet emails the site admin and, if you set one up, posts to a Slack webhook so you're not left guessing.

安装:

Upload the plugin folder to /wp-content/plugins/ or install via Plugins → Add New.
Activate the plugin (WooCommerce must be installed and active).
Go to StoreSheet.
On the Connect tab, enter your Google OAuth credentials and click Authorize.
On the Connect tab, click Create Spreadsheet — StoreSheet builds the full sheet structure.
Open the Sync tab to choose your interval, order statuses, and data types. Your WooCommerce data begins flowing into the spreadsheet.

屏幕截图:

升级注意事项:

1.0.0 Initial release. No upgrade steps required.

常见问题:

Does this plugin store my Google credentials?

Your OAuth refresh token is stored in the WordPress options table (encrypted at rest if you use a security plugin that encrypts options). The client secret is never sent to the browser.

Can I edit a cell in Google Sheets and have it update WooCommerce?

No, not in the free version. The free build only syncs one way, WooCommerce to Sheets. Editing in the sheet and having it push back to WooCommerce is a StoreSheet Pro feature that runs over a signed Apps Script webhook.

How often does WooCommerce sync to Sheets?

Individual changes go across in real time (a new order, a saved product, a new coupon). On top of that, a scheduled run every 15 minutes by default sweeps up anything the live jobs missed. You can change that interval on the Sync tab.

What happens if the Google Sheets API is down?

Action Scheduler retries the failed jobs. If they still fail after the last attempt, StoreSheet emails the admin (when notifications are on). Your store keeps running either way, since the sync never blocks a WooCommerce request.

Can I import my whole existing catalog at once?

New changes sync on their own, and the scheduled run keeps the sheet current from there. Loading a large existing catalog in one go (in chunks small enough not to time out) is the bulk backfill in StoreSheet Pro.

Does it work with Dokan vendors?

Per-vendor sheets for Dokan stores come with the StoreSheet Pro add-on.

更新日志: