How to export Wix orders to Google Sheets and keep them updated
By Jake Marsh · Updated
To export Wix orders to Google Sheets, open Rowstub in your Wix dashboard, connect Google, press New feed and choose store orders. Pick one row per order or one row per item, create or pick a spreadsheet, check the columns with Preview rows, switch the feed on and save. Then press Send past records to add your earlier orders. From then on each new order becomes a row within seconds, and when an order is paid, fulfilled, refunded or canceled, Rowstub rewrites that same row.
Why a one-time CSV isn't enough for orders
An order changes after checkout. It goes from Pending to Paid, from Not fulfilled to Fulfilled, sometimes to Refunded. A file exported on Monday still shows Monday's statuses on Friday, and exporting again means a new file and redoing your own notes. Rowstub keeps one row per order and updates it in place, so the sheet you share with a bookkeeper or a packer stays current.
Steps
- Connect Google. In Rowstub, go to Google & settings, press Connect Google and choose the account. Set the time zone there too, so order dates match your store's day.
- Press New feed on the Feeds tab and choose store orders.
- Choose the row shape:
| Shape | One order with 3 products becomes | Good for |
|---|---|---|
| One row per order | 1 row, items listed in an Items column like "2 x Mug (Blue); 1 x Tote" | Sales log, bookkeeping, order status board |
| One row per item | 3 rows, each with the order number plus Item, Item options, SKU, Quantity, Item price and Item total | Packing lists, units sold per product, SKU reports |
- Pick the spreadsheet and tab. Create spreadsheet makes a new file in your Drive; Pick one from your Drive uses an existing one. The tab starts as "Orders".
- Adjust the columns. Per-order feeds start with Order number, Date, Payment status, Fulfillment status, Customer name, Customer email, Items, Subtotal, Shipping, Tax, Discount, Total and Currency. You can add Phone, Company, Billing address, Shipping address, Delivery method, Coupon, Customer note, Sales channel, Order status and the Wix order ID.
- Add a filter if you want one. Only paid orders adds a rule "Payment status is Paid, Partially paid". Only fulfilled orders keeps the sheet to shipped orders.
- Press Preview rows, then tick Send new records and changes to the sheet as they happen and save.
- Press Send past records and choose how far back. Standard reaches 90 days, Pro your whole order history. Orders already in the sheet are updated, not added twice.
Sheets people build from this
- Still to ship: filter the Fulfillment status column to "Not fulfilled". As you fulfill orders in Wix, they drop out of the filtered view by themselves.
- Monthly sales: money columns are written as numbers, so
=SUMIFSon Total by month works without cleanup. Dates are written as YYYY-MM-DD HH:MM, which sorts correctly. - Units per product: with one row per item, a pivot table on Item and Quantity shows what sold.
- Refund check: filter Payment status to Refunded to see every refunded order with its total.
What happens when an order changes
| In Wix | In the sheet |
|---|---|
| Order placed | New row |
| Payment comes in | Payment status cell changes on the same row |
| Order fulfilled | Fulfillment status changes on the same row |
| Order refunded or canceled | The row shows the new status; it isn't removed |
| Item removed when an order is edited | That item's row is blanked (per-item feeds) |
| Order deleted | The row stays; Rowstub never deletes rows |
A filter only decides whether an order gets a new row. If an order matched "Only paid orders" and is later refunded, its row stays and shows Refunded.
What it costs
Rowstub is billed through Wix with your site, after a 14-day free trial that Wix runs. Standard is $24 a month ($20 a month billed yearly) with 3 feeds switched on and 2,000 new rows a month. Pro is $49 a month ($40 a month billed yearly) with 25 feeds and 25,000 new rows. Updates to rows already in the sheet are free on both.
Rowstub: Orders & Forms to Google Sheets
Orders, form entries, bookings and contacts in Google Sheets, kept up to date From $24 a month per site, or $20 a month billed yearly.
Questions
Does exporting past orders use up my monthly rows?
Past orders added as new rows count toward the month's new rows (2,000 on Standard, 25,000 on Pro). Rows that are only updated never count. If a big history doesn't fit, the rest wait as Held and go out on the 1st or after an upgrade.
Can I keep my own notes next to each order?
Yes. Add columns to the right of Rowstub's, such as "Packed by". Rowstub writes only under its own headers, and your notes stay on the right row when it updates, even after you sort.
Does this work with Wix eCommerce orders from other channels?
Rowstub reads orders through Wix eCommerce and has a Sales channel column, so you can see which channel each order came from. Check a few in Preview rows for your own setup.
Can I send orders to one sheet and items to another?
Yes. Make two feeds from store orders, one per order and one per item, each to its own tab or file.
What if Google is down when an order comes in?
Rowstub retries after 1 minute, 5 minutes, 15 minutes, 1 hour, 3 hours and 6 hours. Anything still not sent shows on the Activity tab with the reason and a Retry button, and a daily check catches orders that changed without Wix notifying Rowstub.
More Rowstub guides
More Wix guides
- How to add an evergreen countdown timer to Wix that can't be reset (Sandstub)
- How to create affiliate links for a Wix store (Repstub)
- How to change prices on many Wix products at once (by percent, with rounding) (Swathwell)
- How to remove prices on a Wix store and take quote requests instead (Quotestub)