The product
From export to discrepancy, order by order
merqori puts your orders next to your marketplace payout and shows, down to the cent, where the difference sits.
- Differences from one cent up
- Works with or without an API connection
- Every run saved for audit trail
- Scores per source, measured on real orders
How it works
Three steps, once a week
- 01
Connect or upload
Connect bol.com, Amazon, Zalando, Picqer, Channable or Exact with your own API keys, or upload the export as CSV, Excel or PDF. The free column mapping recognizes the format and suggests the columns itself.
- 02
Match order by order
Every order is tied to a line in the payout: first by order number, then by track & trace, then by email plus product within a time window. Duplicate matches are blocked.
- 03
The difference on the table
Per order you see what is off: an amount difference, a quantity difference, or an order that appears on one side only. Exportable as CSV, and every check is kept.
The engine
What happens under the hood
Not a language model guessing an amount, but fixed rules you can retrace.
Matching
- Matches by order number
- Fallback to tracking number
- Fallback to email + product within time window
- Prevents duplicate matches
Detection
- Amount differences (> €0.01)
- Quantity differences
- Orders present on only one side
Import & export
- Flexible column mapping per CSV
- Automatic column suggestions
- CSV export of discrepancies
Administration
- Every run saved for audit trail
- Overview of previous reconciliations
The comparison
Pick your marketplace on numbers, not on gut feel
Every source gets a score from 1 to 10 for the share of orders with a discrepancy between order and payout. As long as too few organizations contribute data that score is indicative; after that it is measured on real orders from the past 30 days.
Compare all- 10/10less than 1%
- 9/10less than 2%
- 8/10less than 3%
- 7/10less than 4%
- 6/10less than 6%
- 5/10less than 8%
- 4/10less than 10%
- 3/10less than 13%
- 2/10less than 20%
Fulfillment
Your shipments are counted too
The same approach for your carriers: what went wrong with a shipment is in the tracking events, not in a hunch.
Four kinds of problems
Loss, damage, return to sender and delay are pulled from your tracking events, with the same detector the dashboard uses.
Comparable per carrier
You see what share of shipments arrived without an issue, so one carrier can be put next to another.
Cases you can follow up
A problem shipment becomes a case with a deadline, so a claim does not expire while you wait for an answer.
Questions about the product
Do I need an API connection?
No. One export as CSV, Excel or PDF is enough to start. For bol.com, Amazon, Zalando, Picqer, Channable and Exact you can also connect with your own API keys, so merqori fetches the data itself.
What happens to orders that do not match?
They remain as a discrepancy: an order that appears on one side only is just as much a signal as an amount that is wrong. You see which side is missing it, so you know whether the payout or the export is lagging.
How is the score per source calculated?
The share of orders with at least one discrepancy falls into a fixed band, and each band is one point out of ten. Once enough organizations contribute data for a source, the score is measured instead of indicative.
Can I export the discrepancies?
Yes, as CSV. Every check is kept as an audit trail, so you can look up an earlier reconciliation and put the figures next to your bookkeeping.