Shopify orders summary

A Shopify orders export (Orders → Export), which repeats each order once per line item.

Download the workflowOpen the Data Workspace

Processed locally in your browser. File contents are not uploaded. No account needed.

Before and after

Made-up rows from the sample file, run through the same code Rote Workspace runs, when this page was built. Removed rows are struck through; changed cells are highlighted — point at one for its old value.

Data Workspaceshopify-orders.csv3 rows · 15 columns · UTF-8 Processed locally

Original

Before: the sample file
RowNameTotalCreated at
2#100148.202026-09-01 10:20:11 -0500
3 (removed)#10012026-09-01 10:20:11 -0500
4#100215.122026-09-02 08:05:00 -0500

Result

After: Shopify orders summary
RowOrderTotalDateTime
2#100148.202026-09-0110:20:11 -0500
4#100215.122026-09-0208:05:00 -0500

2 rows × 16 columns after the fixes · was 3 × 15 · 0 cells changed

12 more columns are not shown; they pass through unchanged.

What it does

  1. Keep only the rows where "Total" is not blank; the other rows are removedOn the sample: 1 row removed
  2. Split "Created at" on " " into "Date", "Time"; the last column keeps the restOn the sample: added Date, Time; removed Created at
  3. Rename "Name" to "Order"On the sample: 1 header renamed

Your file needs these columns, spelled exactly: Total, Created at, Name. If one is missing or renamed, the workflow tells you which step it breaks and does not run.

The desktop version also keeps only ten columns. The browser has no step for “keep only these columns”, so every other column stays; remove the ones you do not need with Columns ▾ → Drop.

How to use it

  1. Download the workflow

    A small .json file with the steps above — no data. Want to try it first? Use the sample file (made-up rows).

  2. Open your export

    In the Data Workspace, choose your file. It is processed in your browser, not uploaded.

  3. Import, review, run

    Workflow → Import, choose the file — or skip the download: under Workflow → Templates, press Check & open. Each step is checked against your columns; press Run on this file, then Download.