This article lists every column the Google Sheets app can write into your spreadsheet, and covers what you can do with a configuration once it exists. To connect your Google account and create a configuration in the first place, see syncing your orders to Google Sheets.
Selected fields (columns)
A dual-panel picker chooses which columns appear, and in what order. Move items from Available fields to Selected fields with the arrow buttons (single arrows move the items you picked, double arrows move all), or drag them. Drag items inside Selected fields to change the column order. Available fields:
- Order: ID, Number, date, shipping method, weight, payment method, subtotal, discount, shipping, VAT, total, currency, market, market code, status, abandoned status, duplicated status, returning customer status, test status, URL.
- Product: ID, name, price, quantity, SKU, barcode, weight, variants, link.
- Customer: ID, full name, birthday, gender, company, address 1 and 2, national ID, neighborhood, district, apartment, floor, state / region, city, commune, province, postal code, country, connection country (the country of the visitor's internet connection), email, phone, WhatsApp, map link, color, note, browser, OS, device, IP, user agent, referer, VPN/Proxy status.
- UTM: source, medium, campaign, term, content.
- Store: name.
Managing existing configurations
The main panel lists every configuration with its spreadsheet name, creation date, markets, and Activated or Deactivated status. For each row you can:
- Click the row to open and edit it.
- Use the Export all orders button to push a full historical export of matching orders to the sheet. Only one export runs at a time; while it runs the button is disabled and shows Export already in progress.
- Use Duplicate spreadsheet to clone the configuration. The copy gets a "(Copy)" suffix and starts deactivated.
- Use Go to the spreadsheet to open the Google Sheet in a new tab.
- Tick a row's checkbox and use Delete spreadsheets to remove one or more configurations.
Editing a configuration
Click a row to open the edit form with every field pre-filled, change what you need, and click Save.
Good to know
- Completed orders are written in real time. Abandoned orders arrive only through Automator, after its recovery time.
- Disconnecting your Google account removes all credentials and configurations permanently.
Why is shipping missing in Google Sheets, or the total only the product price?
The app does send shipping. It has its own columns, Order's shipping and Order's total, next to Order's subtotal and Product's price. If you only see the product price, check these points:
- Add the columns. Open your configuration, move Order's shipping and Order's total into Selected fields, and click Save. Orders that arrive after that get the new columns. Rows already in your sheet do not change.
- Look at the first row of the order. When an order has several products, each product gets its own row, and the order amounts (subtotal, shipping, total) are written only on the first row. Turn on One line per order to get each order on a single row.
- The sheet copies the order as it was saved. Shipping and total are the same numbers you see on the order in Orders. If the order there also shows no shipping, the sheet is right and the order was placed without a shipping price.
An order is saved with no shipping when the buyer's market has no active shipping method, when the Shipping field of your checkout form is optional and the buyer leaves it empty (a disabled field charges your market's first shipping method), or when the method is free, Calculated later, or made free by a free shipping rule. Fix this in Shipping methods and in the checkout form under the checkout form settings. New orders will then carry the shipping price in Storeep and in your sheet.