Orders
The orders report aggregates payment attempts by the order identifier (order_id) and computes the final status from the last attempt recorded within the queried period.
Inclusion criteria
- Only orders whose first attempt occurred within the filter period are considered.
- Only attempts within the period are used to determine the final status.
- Orders without
order_idare ignored.
Example
Consider the payments below:
| Date | Payment | Order | Attempt | Status |
|---|---|---|---|---|
| 03/25/2024 | 1 | 1000 | 1st | Declined |
| 04/01/2024 | 2 | 1000 | 2nd | Approved |
| 04/05/2024 | 3 | 1001 | 1st | Approved |
| 04/10/2024 | 4 | 1002 | 1st | Declined |
| 04/11/2024 | 5 | 1002 | 2nd | Declined |
| 04/13/2024 | 6 | 1002 | 3rd | Approved |
| 04/13/2024 | 7 | 1003 | 1st | Declined |
| 04/28/2024 | 8 | 1004 | 1st | Declined |
| 05/01/2024 | 9 | 1004 | 2nd | Approved |
With a period filter between 04/01/2024 and 04/30/2024, the report shows:
- Approved: 2 orders
- Declined: 2 orders
- Total: 4 orders
Breakdown:
- Order 1000: disregarded — first attempt outside the period.
- Order 1001: approved — single attempt, within the period.
- Order 1002: approved — first attempt in the period and an approved retry also in the period.
- Order 1003: declined — single attempt, within the period.
- Order 1004: declined — first attempt in the period; the approved retry occurred after the end of the period.