StoreSheet – Google Sheets Sync for WooCommerce
| 开发者 | mralaminahamed |
|---|---|
| 更新时间 | 2026年8月8日 01:21 |
| 捐献地址: | 去捐款 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 7.0 |
| 版权: | GPL-2.0-or-later |
| 版权网址: | 版权信息 |
详情介绍:
- 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.
- 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.
- Products — synced WooCommerce → Sheets.
- Orders — synced WooCommerce → Sheets (choose which statuses).
- Coupons — synced WooCommerce → Sheets.
- Overview — formula dashboard tab, left open for your own Sheets formulas.
- Reports — formula analytics tab, left open for your own Sheets formulas.
- StoreSeeder - Realistic test data for WooCommerce and Fluent Cart — a whole shop from a recipe, with one-click cleanup.
- Warranty Cart - Sell extended warranties on your products, then handle the claims and renewals that follow.
- Vendor Tasks for Dokan & ClickUp - Turn Dokan vendor events into ClickUp tasks — registrations, approvals, withdrawals.
- Swift Menu Duplicator - Duplicate menus in one click, snapshot revisions, export and import, WP-CLI and REST.
- Author Profile Blocks - Author and team profiles as Gutenberg blocks — grid, carousel, list and single.
安装:
- 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.
屏幕截图:
常见问题:
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.
Can I switch from another Google Sheets plugin?
Yes. StoreSheet detects competing WooCommerce → Google Sheets plugins and imports their configuration (spreadsheet target, sync settings) so you don't have to reconfigure by hand. Adopting the competitor's existing spreadsheet with historical-row reconciliation is a StoreSheet Pro feature.
更新日志:
- Added: choose a different spreadsheet after one is connected — the Connection tab now offers "Change" instead of only a link to the current sheet.
- Added:
storesheet_oauth_callback_urlfilter to override the OAuth redirect URI. Google refuses redirect URIs on reserved domains (.test, .local), so a local install could not complete the Google connection at all. - Added:
storesheet_suppress_admin_noticesfilter. Other plugins' admin notices are now hidden on StoreSheet's own screens by default. - Changed: the saved OAuth Client ID is masked in the admin. It is not a secret, but it identifies your Google Cloud project in support screenshots.
- Fixed: a spreadsheet you created yourself — including one imported from .xlsx — can be used. Earlier guidance said otherwise.
- Added: migrate from another WooCommerce → Google Sheets plugin — StoreSheet detects a competing plugin and imports its configuration in a few clicks (Migrate wizard + auto-detect banner).
- Added: built-in detection and config import for GSheetConnector, WPSyncSheets, FlexOrder, FlexStock, Spreadsheet Sync, Product Sync Master Sheet, and WPGSI, plus a generic fallback scanner for any other plugin.
- Added:
storesheet_import_adaptersfilter andstoresheet_import_adopt_sheetaction for extending the importer.
- Initial release.
- One-way WooCommerce → Google Sheets sync for Products, Orders, and Coupons.
- Google OAuth 2.0 connection with automatic access-token refresh.
- Real-time (WooCommerce event) and scheduled sync via Action Scheduler.
- Overview and Reports formula tabs.
- Admin email and Slack failure notifications.