Combine Etsy and Shopify Sales Into One View

If you sell on both Etsy and Shopify, the fastest way to combine sales into one view is to export each platform's order data on the same schedule, normalize it to a shared set of columns (order date, gross sales, platform fees, shipping, net payout), and feed both into a single dashboard keyed on a "channel" field. The hard part is not the chart. It is making the two platforms agree on what a sale actually is, because Etsy and Shopify report revenue, fees, and timing differently enough that a naive sum overstates what you actually keep.

This guide covers the reconciliation rules that make a combined Etsy and Shopify dashboard trustworthy, a four-column schema that travels across both, and a working example of a side-hustle seller who found a 9% reporting gap once the numbers shared one view.

Why two storefronts never add up cleanly

The instinct is to grab the headline sales number from each platform and add them. That number lies in three predictable ways.

First, gross versus net. Etsy's reports often surface gross order value, while your actual deposit is gross minus listing fees, transaction fees, payment processing, and any offsite ads fee. Shopify shows gross sales separately from payouts, and Shopify Payments deducts its processing cut before the money lands. If you combine the two gross figures, your "revenue" is real but your margin is fiction.

Second, timing. Etsy and Shopify both let you choose order date or payout date. A sale placed on the last day of the month but paid out three days later belongs to different months depending on which date you pick. Mix the two and your monthly trend line develops phantom dips and spikes.

Third, refunds and partial refunds. A refund issued in March against a February sale shows up differently across the two platforms' standard exports. Decide once whether refunds reduce the original sale's month or the month they were issued, and apply that rule to both.

The takeaway: a combined view is only as good as the rules you apply before the data meets. Get the rules right and one dashboard beats two browser tabs every time.

The four-column schema that travels across both platforms

You do not need every field each platform offers. You need a small shared spine that both can map into. This is the schema that keeps an Etsy and Shopify dashboard honest:

• Channel (Etsy or Shopify): the single field that lets you split, stack, or total either store.
• Order date: pick order date over payout date and use it consistently, so trends reflect when customers bought.
• Gross sales: item price plus shipping charged to the buyer, before any platform deduction.
• Platform fees: every deduction (listing, transaction, payment processing, offsite ads), summed into one number per order.
• Net payout: gross minus fees, which is the figure that actually matters for cash flow.

Everything else (SKU, customer location, coupon code) is optional enrichment you can layer on later. The five fields above are enough to answer the questions a multi-channel seller actually asks: which store drives more profit, not just more orders, and how the blended trend is moving month over month. Etsy publishes its current fee structure in its official seller fees and selling costs reference, which is worth checking when you build your fee column so the numbers match your statements.

A reconciliation method you can run in 20 minutes a week

Here is a repeatable weekly process, named the SAME method (Same dates, Aligned columns, Merged channels, Examined deltas) so it is easy to remember.

Same dates. Export both platforms for the identical date window. Etsy orders and Shopify orders both download as CSV from their respective admin areas; Shopify documents its order export in the Shopify Help Center. Always pull the same start and end date for both.

Aligned columns. Map each export into the five-column spine above. Etsy's "Order Value" becomes gross sales; its fee lines sum into platform fees. Shopify's "Total" becomes gross sales; the Shopify Payments fee and any app fees become platform fees. Tag every Etsy row with channel = Etsy and every Shopify row with channel = Shopify.

Merged channels. Stack the two normalized tables into one. Because both now share the same columns and a channel tag, they combine without conflict.

Examined deltas. Compare your combined net payout to the actual deposits that hit your bank. A gap larger than a percent or two usually means a fee line was missed or a refund was double-counted. Fix the rule, not the row.

Run SAME weekly and your combined view stays accurate instead of drifting until tax season forces a painful cleanup.

Mini case study: the 9% gap a single view exposed

Consider a one-person candle business selling on Etsy and running a Shopify store for repeat customers and wholesale. For most of a year, the seller eyeballed each platform separately and assumed roughly equal performance because order counts were close.

When the two were merged into one view using the five-column schema, the picture changed. Etsy's order count was higher, but its blended fee load (transaction fee plus offsite ads on a meaningful share of orders) pulled its net payout per order well below Shopify's. On a combined net-payout basis, Shopify was the stronger channel despite fewer orders, and Etsy's headline revenue had been overstating its real contribution by about 9% once fees and one double-counted refund were reconciled. The seller did not leave Etsy. Instead, they shifted their email and repeat-customer push toward Shopify, where each order kept more margin, and treated Etsy as a discovery channel. That decision was invisible in two separate dashboards and obvious in one.

Building the combined view without becoming an analyst

You can run the SAME method in a spreadsheet, and for a brand-new side hustle that is a fine start. The friction shows up later: the weekly export-and-paste is exactly the kind of task that quietly gets skipped, and a stale combined view is worse than no combined view because it invites confident wrong decisions.

The alternative is a dashboard built to hold both channels and refresh on a schedule, so the SAME method runs on top of a structure you did not have to design. MyDashBorg builds that combined Etsy and Shopify view for sellers from a starting template rather than handing over a tool to learn, and the "Ask your data" feature on every paid tier lets you ask plain-language questions like "which channel had higher net payout last month" against the merged data. You can review the small-business templates to see the multi-channel sales layout, or compare what is included on each pricing tier.

A combined view is not about prettier charts. It is about forcing two platforms that disagree on the definition of a sale to settle on one, so the number you act on is the number you actually keep. Decide your gross-versus-net, date, and refund rules once, apply them to both stores, and the rest is just keeping the data fresh.

Frequently Asked Questions

Can I combine Etsy and Shopify sales for free?

Yes, you can do it manually for free by exporting each platform's orders to CSV, normalizing both to a shared set of columns, and combining them in a spreadsheet. The cost is your time each week and the risk that a skipped export leaves the view stale. A scheduled dashboard removes that manual step, and MyDashBorg's Free tier includes one self-serve dashboard to start.

Should I use order date or payout date when combining the two?

Use order date, and use it for both platforms consistently. Order date reflects when customers actually bought, which keeps your trend line meaningful, whereas payout date is shifted by each platform's settlement schedule and the two schedules differ. The only time payout date is clearer is when your sole goal is matching deposits to your bank statement.

Why is my combined revenue higher than what hits my bank?

Almost always because you summed gross sales rather than net payout. Etsy and Shopify both deduct fees (transaction, payment processing, and in Etsy's case sometimes offsite ads) before depositing money, so your true take-home is gross minus those fees. Build a dedicated platform-fees column for each order so your combined view shows net payout, not just gross.

Do refunds get counted twice across platforms?

They can, if the original sale and the refund both appear in your exports without a clear rule. Decide once whether a refund reduces the original sale's month or the month it was issued, then apply that rule to every refund on both Etsy and Shopify. Checking your combined net payout against actual bank deposits each week catches double-counting fast.

Ready to stop juggling two storefronts in two tabs? See the small-business dashboard templates built to combine Etsy and Shopify into one accurate view.