Home › Merge Guides › Faire + Mercari › Year-End Sales Summary walkthrough
The Best Way to Merge Faire and Mercari Data for Year-End Sales Summary
If you're doing year-end sales summary by hand right now, here's the fastest path from "two exports" to "one usable sheet," and why the manual version keeps breaking.
Step by step
- Decide your target columns once. Most people settle on Date, Channel, Order ID, and Total — set that up in CSV Experts and you won't redo it.
- Import the Faire file first. The first time you see this file shape, you map each of its columns to your target list.
- Import the Mercari file the same way. Its columns get mapped once too — after that, every future file with this shape merges with no extra clicks.
- Check the merged totals. Dates and numbers are normalized automatically, so a European "24,00" and a US "24.00" both land as the same value.
- Export. CSV or Excel, ready for year-end sales summary.
What actually goes wrong if you do this by hand
Faire gives you an order date shown alongside a separate ship date for wholesale orders, while Mercari gives you a sold date in the seller's local time — line those up manually across a few hundred rows and it's easy to miscount a week. On top of that, Faire's export quantities are per case/pack rather than per unit, which throws off totals if merged as if it were a retail export, and Mercari's like other reseller apps, the export is minimal with no tax breakdown and mixes cancelled orders into the same file. Individually those are minor quirks; combined into one spreadsheet by hand, they're where most reconciliation errors for year-end sales summary actually come from.
Why it matters for year-end sales summary
A year-end summary across channels means twelve months of exports from each platform, all needing the same cleanup before they can be totalled together.
Just want the quick column-difference reference instead? See the short version.