Home › Merge Guides › Wix + TikTok Shop › Multi-Channel Reconciliation walkthrough
The Best Way to Merge Wix and TikTok Shop Data for Multi-Channel Reconciliation
If you're doing multi-channel reconciliation 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 Wix file first. The first time you see this file shape, you map each of its columns to your target list.
- Import the TikTok Shop 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 multi-channel reconciliation.
What actually goes wrong if you do this by hand
Wix gives you a Date Created column, while TikTok Shop gives you an order creation time stamped in UTC — line those up manually across a few hundred rows and it's easy to miscount a week. On top of that, Wix's export product options (size, color) are appended into the item name rather than given their own column, and TikTok Shop's refunded and partially-refunded orders stay in the export with a status column instead of being removed, so totals can overstate revenue if you don't filter by status. Individually those are minor quirks; combined into one spreadsheet by hand, they're where most reconciliation errors for multi-channel reconciliation actually come from.
Why it matters for multi-channel reconciliation
Reconciling orders across channels means matching rows that were never designed to be compared side by side.
Just want the quick column-difference reference instead? See the short version.