# StoreSheet

_Google Sheets sync for WooCommerce_

Keep your WooCommerce products, orders and coupons up to date in Google Sheets, automatically and in the background, so you can build reports or share data without giving out a login.

Category: WooCommerce. Price: free, with StoreSheet Pro. Current version: 1.2.0.

## What is it?

StoreSheet copies your WooCommerce products, orders and coupons into a Google Sheet and keeps them current. Once your data is in a sheet you can build reports, hand a copy to someone who has no WordPress login, or use the formulas you already know.

It works in the background, so it never slows checkout or the admin. The free version sends data one way, from your store to Sheets. StoreSheet Pro adds editing in the sheet, so a price changed there is updated in your store.

## Who it is for

- Store owners who report in spreadsheets
- Teams that need store data without a WordPress login
- Agencies handing clients a live sheet of orders

## What you get

- **Products, orders and coupons in a sheet**: Every product, order and coupon is copied to its own tab, as it changes and on a schedule.
- **Never slows your store**: Syncing runs in the background, so checkout and the admin stay fast.
- **Reports on your own terms**: The Overview and Reports tabs are left open for your own formulas, so you can put revenue totals or margins wherever you want them.
- **You choose what is shared**: Pick which order statuses and which kinds of data are synced.
- **Safe connection to Google**: You connect with Google sign-in, and your credentials stay on your own server.
- **Told when something fails**: If a sync fails for good, you get an email, and a message in Slack if you set one up.
- **Easy to switch to**: StoreSheet can read the settings of other WooCommerce to Google Sheets plugins so you do not start over.

## How it works

1. **Connect your Google account**: Sign in with Google from the Connect tab. Your credentials stay on your server.
2. **Create your spreadsheet**: One click builds the sheet, with tabs for products, orders, coupons, an overview and reports.
3. **Choose what to sync**: Pick the order statuses and data you want. Changes then flow into the sheet automatically.

## Free and StoreSheet Pro

Turn the sheet into a control panel: change prices and stock in the sheet and have your store follow.

| What you get | Free | Pro |
|---|---|---|
| Products, orders and coupons synced to Google Sheets | Yes | Yes |
| Overview and Reports tabs for your own formulas | Yes | Yes |
| Email and Slack alerts when a sync fails | Yes | Yes |
| Edit prices, stock or coupons in the sheet and update your store | No | Yes |
| Variations and Customers tabs | No | Yes |
| Load your whole existing catalogue in one click | No | Yes |
| Choose who wins when both sides change | No | Yes |
| Review sheet edits before they reach your store, and undo them | No | Yes |
| Sync only the products and orders you choose | No | Yes |
| Hide personal data columns | No | Yes |
| Separate sheets for Dokan vendors | No | Yes |
| Daily summary email | No | Yes |

[See pricing](#pricing)

## You will need

- WooCommerce
- A Google account
- WordPress 6.6 or newer

## Questions

**How quickly does my store data reach the sheet?**
Individual changes go across as they happen, such as a new order or a saved product. A scheduled run every 15 minutes, which you can change, catches anything that was missed.

**Can I edit the sheet and update my store?**
Not in the free version, which syncs one way. Editing in the sheet is part of StoreSheet Pro.

**Is my Google information safe?**
Your credentials stay on your server and are never sent to the browser.

**What if Google is down?**
Failed jobs are tried again. If they still fail, you are emailed. Your store keeps running either way.

**Does it work with Dokan vendors?**
Sheets for each Dokan vendor come with StoreSheet Pro.

## Links

- Page: https://thewpsquad.com/plugins/storesheet
- WordPress.org: https://wordpress.org/plugins/storesheet/
- Download: https://downloads.wordpress.org/plugin/storesheet.1.2.0.zip
- Website: https://alaminahamed.com/projects/storesheet/
- Get help: https://app.thewpsquad.com/tickets/create