Help CenterContact support
All Columna: Order Export & Sheets articles

How do I export sales totals by SKU, vendor, product or day?

Updated

On this page
  1. Turn a template into a summary
  2. Columns
  3. Dates and time zone
  4. Which orders are counted
  5. Orders in another currency
  6. Google Sheets syncs and scheduled exports
  7. Who created the order

A template can write a summary instead of one row per order or line item: one row per SKU, vendor, product type, product and variant, day, week or month, with the number of orders, the quantity sold and the sales totals. Use it for “sales by SKU” or “sales by day” reports, a vendor payout check, or a quick reorder list.

Turn a template into a summary

  1. Open Templates in the app and open a template, or click Create template.
  2. In the Summary report card, choose how to group the rows in Group rows:
    • One row per SKU
    • One row per vendor
    • One row per product type
    • One row per product and variant
    • One row per day
    • One row per week (Monday to Sunday)
    • One row per month
  3. The preview on the right shows the summary of your latest orders. Click Save.

Choose Off: one row per order or line item to go back to your columns. Your columns stay saved while the summary is on, so nothing is lost. Templates saved before this option existed export exactly as before.

The summary is saved in the template, so it applies wherever the template is used: an export from the Orders page, a scheduled email or SFTP export and a Google Sheets sync. It is also part of the template’s share code.

Columns

Column Meaning
SKU, Vendor, Product type, Product and Variant, Date, Week starting or Month The group. An empty cell groups the line items without a value, such as items without a SKU; that row comes last.
Currency Your store currency on the orders of the row.
Orders Number of orders with at least one line item in the group.
Quantity Units ordered.
Refunded quantity Units refunded.
Gross sales Unit price × quantity, before discounts.
Discounts Discounts allocated to the line items, including order discounts and discount codes.
Net sales Gross sales minus discounts. Refunds are not subtracted; see Refunded quantity.
Tax Tax charged on the line items.

Amounts are added up exactly to the cent. Shipping and order-level fees are not part of the summary, because they do not belong to a product.

Rows grouped by SKU, vendor, product type or product are sorted by net sales, largest first. Rows grouped by date are sorted from the oldest to the newest.

Dates and time zone

Day, week and month use the date the order was created, in your store’s time zone (Settings > General in Shopify). Weeks start on Monday, and the Week starting column shows that Monday. Date and Week starting use the date format of Settings > File format; Month is written as 2026-11.

Which orders are counted

The summary counts the same orders and line items an export with the template would write:

  • the order date range and every order filter of the export, such as payment status, tags, sales channel, shipping country or product type;
  • the SKU or Vendor line item filter, which keeps only the matching line items;
  • the template’s Bundle line items setting.

An export of selected orders summarizes just those orders.

Orders in another currency

Shopify keeps every amount in your store currency as well as in the currency the customer paid in. The summary uses the store currency amounts, converted at the rate Shopify used for the order, so a store selling in several currencies gets one total. If your store currency changed at some point, orders placed before and after the change are written in separate rows, one per currency, instead of being added together.

Google Sheets syncs and scheduled exports

A sync with a summary template appends the summary of the orders created since its last run, the same way the EU VAT report does. Rows already in the sheet are not changed later, so an order edited after it was synced does not change the totals there. For totals over a fixed period, use a scheduled export, which summarizes the whole period of each run.

Who created the order

Shopify shares the staff member of an order only with apps that Shopify approves for staff data, and only on Shopify Plus and Advanced stores. Columna does not ask for that access. To see where an order came from, add the Created by app column, which shows the app the order was placed through, such as Online Store or Point of Sale, and the POS location column for the store of a Point of Sale order.

Built and supported by StoreFleet, Shopify app developers since 2021.