Unmatched rows usually come from different identifier levels (order versus sub-order or item), formatting differences, split shipments or rows that fall in another period. Choose one stable matching key, normalise formats, map split orders to their parts and keep unmatched rows in a visible queue instead of counting them as payout differences.
Why identifiers fail to match
- Sales reports may use an order ID while settlements use a sub-order or item ID.
- Spreadsheet tools can strip leading zeros or convert long numbers to scientific notation.
- One order can be split into several shipments, each with its own line.
- The matching line may sit in a different settlement period.
Choose and normalise one key
Decide which identifier is stable across both reports for your marketplace, and store it as text, not a number. Trim spaces and keep the original value alongside any normalised one so you can trace back to the source file.
Keep a visible unmatched queue
Rows that still don't match after normalisation should be listed, counted and aged, not dropped. Report them separately from verified differences. MarketplaceMetrics shows accepted and rejected rows per upload so this queue is visible from the start.
Re-check after the next upload
Many unmatched rows resolve when the next period arrives. Re-run matching after each upload, and only escalate rows that stay unmatched beyond a reasonable window.
Worked example
Illustrative example only. A sales report lists order 000123456 while the settlement shows 123456 after a spreadsheet removed the leading zeros. Treated as numbers, they look different; stored as text with the original value preserved, they match.
Questions and answers
What is the difference between an order ID and a sub-order ID?
An order ID usually covers the whole customer order, while a sub-order or item ID identifies one item or shipment within it. Settlements often use the more detailed ID.
Should unmatched rows be counted as payout differences?
No. Keep them in a separate queue until they are matched or explained; otherwise data problems will be reported as money problems.
Why do my order numbers change in Excel?
Excel may treat long identifiers as numbers, removing leading zeros or rounding digits. Import identifier columns as text to keep them intact.