Migration assurance
Amazon settlement report amount-type mapping
Amazon settlement report amount-type mapping focuses on migration mapping and reconciliation evidence, not generic API copy. Use it to turn a vague migration into a reviewable test case.
- Target keyword: Amazon settlement report amount-type mapping
- Removed: legacy price/fee type columns
- Replacement: Flat File V2 amount-type, amount-description and amount
- Removal date: November 11, 2026
TL;DR
| Deprecated item | Removal date | Replacement | Migration risk | Scanner detection |
|---|---|---|---|---|
| legacy price/fee type columns | November 11, 2026 | Flat File V2 amount-type, amount-description and amount | Misclassifying amount-type or amount-description can move fees, refunds or promotion credits into the wrong ledger bucket. | AMZ-SET-AMOUNT-MAP-001, AMZ-SET-COLUMN-001 |
Official status
Amazon documentation lists legacy price/fee type columns as in-scope for this migration. Use the official source before code freeze because deadlines and replacement details can change.
Amazon settlement report removal changelog Amazon SP-API deprecation schedule
Production Settlement validation plan
Settlement migration is a finance parser rebuild. The production gate is not simply requesting the new report type; it is proving that amount rows, currencies, descriptions and totals reconcile under realistic sample files.
| Validation area | Production proof to collect |
|---|---|
| Report type | Confirm no code path still requests XML or the legacy flat-file report type. |
| Parser contract | Parse by header name and retain amount-type, amount-description, amount and currency together. |
| Locale handling | Validate decimal comma and decimal point samples with deterministic decimal arithmetic. |
| Accounting totals | Reconcile principal, fees, refunds and transfers before replacing close workflows. |
Mapping table
Amazon settlement report amount-type mapping should be implemented as a small, reviewable mapping table before release.
| Old field or behavior | New field or behavior | Validation rule |
|---|---|---|
| price type name / fee type name | amount-type | Use as the high-level bucket, not a ledger account by itself. |
| price type value / fee type value | amount-description | Use for the account-level discriminator. |
| price amount / fee amount | amount | Parse with decimal-safe logic and preserve currency. |
| transaction-type | transaction-type plus amount-description | Use both when classifying consolidated or disjointed amounts. |
Validation scenario
Validate one principal sale, one commission fee, one refund, one promotion and one transfer row before replacing accounting mappings.
| Input evidence | Expected proof |
|---|---|
| Source scan finding | AMZ-SET-AMOUNT-MAP-001, AMZ-SET-COLUMN-001 points to the old implementation. |
| Sample data | The migration sample covers the field, status, amount or identifier in this page. |
| Reviewer output | A short reconciliation note explains every accepted delta. |
Parser or reconciliation example
Use this as the shape of the unit test or review snippet; adjust names to your codebase.
const key = `${row['transaction-type']}|${row['amount-type']}|${row['amount-description']}|${row.currency}`;
ledger.add(key, toDecimal(row.amount));Removed resource and replacement
| Old resource | Replacement | Deadline | Validation outcome |
|---|---|---|---|
| legacy price/fee type columns | Flat File V2 amount-type, amount-description and amount | November 11, 2026 | Misclassifying amount-type or amount-description can move fees, refunds or promotion credits into the wrong ledger bucket. |
What breaks
| Area | Breakage |
|---|---|
| Code pattern | Code still assumes legacy price/fee type columns. |
| Payload or schema | The migration target is Flat File V2 amount-type, amount-description and amount, so shape, naming or grouping changes. |
| Permission or data access | Field visibility, role access or accounting availability can differ by marketplace and workflow. |
| Pagination, status or field mapping | Mapping mistakes can hide under successful HTTP responses unless samples are reconciled. |
Before/after example
The example is intentionally small so the migration shape is visible in a code review.
Before:
// Old assumption
legacy price/fee type columns
After:
const key = `${row['transaction-type']}|${row['amount-type']}|${row['amount-description']}|${row.currency}`;
ledger.add(key, toDecimal(row.amount));Scanner detection
| Rule ID | Severity | Evidence pattern | False positive condition | Validation step |
|---|---|---|---|---|
| AMZ-SET-AMOUNT-MAP-001, AMZ-SET-COLUMN-001 | HIGH when mapping drift affects accounting, PII or order state | legacy price/fee type columns | Documentation, comments, generated clients or test fixtures can require manual review. | Capture one production-like sample for legacy price/fee type columns. |
Migration checklist
- Capture one production-like sample for legacy price/fee type columns.
- Normalize it into Flat File V2 amount-type, amount-description and amount.
- Run the mapping table against the sample and record unmatched fields.
- Reconcile the expected totals, statuses, identifiers or access flags.
- Attach the mapping output to the migration ticket.
- Re-scan source and keep the sample evidence with the release gate.
Common mistakes
- Mapping field names without proving semantic equivalence.
- Using one happy-path sample instead of boundary samples.
- Skipping re-scan after the mapper or parser is patched.
Sample report preview
The public sample report shows the same evidence shape used by paid reports: rule ID, severity, file location, redacted evidence, migration mapping, validation step and quality gate.
FAQ
What should Amazon settlement report amount-type mapping prove?
It should prove that legacy price/fee type columns maps safely to Flat File V2 amount-type, amount-description and amount for the tested workflow.
What evidence belongs in the ticket?
The source finding, mapping table result, sample input, normalized output and reconciliation note.
Can the page replace production validation?
No. It gives the mapping contract and sample gate; production rollout still needs staged validation.
How does the scanner help?
It flags AMZ-SET-AMOUNT-MAP-001, AMZ-SET-COLUMN-001 evidence and links findings to the relevant mapping or validator page.
Official sources
Validate Amazon settlement report amount-type mapping in your source
Run a static scan, review the sample report shape, then unlock the detailed migration report when the evidence is useful.