Exports · Shopify
Shopify orders export to dashboard
Upload the file you already download from Shopify. Every Number reads it with no setup, picks a screen, and puts a receipt on every number.
The question behind this fileWhat were orders, net sales and top products this week after discounts, refunds and cancellations?
What you get
Money over time
Money adding up through the month.
Subtotal is money and Created at dates each order, so it adds up sales through the period and sets this period against the last.
Click any number for its receipt: the rule, the rows it used, and the rows it left out.
Getting the file
Download it from Shopify
In Shopify admin, go to Orders and click Export. Choose the orders and CSV, then click Export orders. Bigger exports arrive by email.
Know what a row is
One row is one line item. An order with several line items spans several rows.
Upload it as it is
No cleanup first. Title rows, totals rows and repeated headers are skipped and listed in each receipt.
The 60 columns we tested with, from Shopify's documentation
Name · Phone · Email · Financial Status · Paid at · Fulfillment Status · Fulfilled at · Accepts Marketing · Currency · Subtotal · Shipping · Taxes · Total · Discount Code · Discount Amount · Shipping Method · Created at · Lineitem quantity · Lineitem name · Lineitem price · Lineitem compare-at price · Lineitem SKU · Lineitem requires shipping · Lineitem taxable · Lineitem fulfillment status · Billing Name · Billing Street · Billing Address1 · Billing Address2 · Billing Company · Billing City · Billing Zip · Billing Province · Billing Province Name · Billing Country · Billing Phone · Shipping Name · Shipping Street · Shipping Address1 · Shipping Address2 · Shipping Company · Shipping City · Shipping Zip · Shipping Province · Shipping Province Name · Shipping Country · Shipping Phone · Notes · Note Attributes · Canceled at · Payment Method · Payment Reference (deprecated) · Payment References · Refunded Amount · Vendor · Outstanding Balance · Employee · Location · Device ID · Id
How we know
This file is one of the 100 in our reading test. The column names are Shopify's; the rows were generated to fit them, since we don't have your file. Your export may have more or fewer columns, and Every Number shows how it read each one before you build.