Home › Merge Guides › Bonanza + Wayfair › Year-End Sales Summary walkthrough
The Best Way to Merge Bonanza and Wayfair 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 Bonanza file first. The first time you see this file shape, you map each of its columns to your target list.
- Import the Wayfair 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
Bonanza gives you a sale date shown in the seller's account timezone, while Wayfair gives you a purchase order date distinct from the ship date required by Wayfair's supplier terms — line those up manually across a few hundred rows and it's easy to miscount a week. On top of that, Bonanza's export fee amounts differ per listing based on optional ad placement, so two otherwise-identical sales can show different fee columns, and Wayfair's built for suppliers rather than direct-to-consumer sellers, so column names lean toward logistics (PO, ship window) rather than retail checkout fields. 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.