Home › Merge Guides › Faire + Bonanza › Google Sheets Import
Merge Faire and Bonanza Sales Data for Google Sheets Import
A clean Google Sheets dashboard across channels starts with a single sheet that already has matching columns.
Why Faire and Bonanza exports don't line up
- Faire: an order date shown alongside a separate ship date for wholesale orders; wholesale unit price plus a Faire commission column, distinct from retail-style totals; an order number tied to a retailer account rather than an individual consumer. Also, quantities are per case/pack rather than per unit, which throws off totals if merged as if it were a retail export.
- Bonanza: a sale date shown in the seller's account timezone; item price and a Bonanza final value fee that varies by advertising tier chosen per listing; an order ID unique to the marketplace. Also, fee amounts differ per listing based on optional ad placement, so two otherwise-identical sales can show different fee columns.
For google sheets import, that mismatch is exactly what causes hours of manual cleanup every period.
How to merge them in under a minute
- Open CSV Experts and set your target columns once (Date, Channel, Order ID, Total).
- Drop in your Faire export and map its columns once.
- Drop in your Bonanza export and map it the same way — both merge into one sheet, normalized.
- Export as CSV or Excel. Same-layout files merge automatically next time.
FAQ
Does this upload my sales data anywhere?
No. Everything runs in your browser using JavaScript — your files are never sent to a server.
Does it work for more than two channels?
Yes. Add as many source files as you want; each distinct file layout is mapped once and remembered.
Prefer a longer walkthrough of this pair? See the step-by-step version.
More Faire + Bonanza guides
- Faire + Bonanza for Bookkeeping
- Faire + Bonanza for Tax Prep
- Faire + Bonanza for QuickBooks Import
- Faire + Bonanza for Xero Import
- Faire + Bonanza for Profit Tracking
- Faire + Bonanza for Inventory Reconciliation