Excel → Amazon ASN
Convert Excel to Amazon ASN without a brittle one-off script
Turn the first non-empty worksheet with a stable heading row into a confirmed canonical shipment, then render and validate Amazon ASN per partner route.
Direct answer
Direct answer
For the implemented Amazon route, the confirmed source is normalized to a shipment snapshot and rendered as an Amazon Vendor Shipments API shipment-confirmation payload. Vendor, ship-from, purchase-order, item, quantity, container and date fields must be provided by the account configuration or source; Shipment Sentry does not invent missing partner values. The Excel side is mapped once from a representative file and reused only when its exact heading signature matches.
Why mapping needs a controlled workflow
A direct Excel-to-Amazon ASN script usually mixes source parsing, partner identifiers, hierarchy rules and transport in one fragile job. Shipment Sentry separates them: source inspection, human-confirmed canonical mapping, versioned partner route, deterministic renderer and final validation. That separation makes a changed source fail visibly instead of corrupting a production ASN.
What the control should check
- 01Parse Excel as the first non-empty worksheet with a stable heading row.
- 02Confirm purchase order, shipment reference, item, quantity and container fields.
- 03Bind the route to the correct Amazon vendor and ship-from identifiers.
- 04Keep each purchase-order item and shipped quantity traceable to its source row.
- 05Validate required shipment and receive-by dates before API rendering.
- 06Treat a first-seen or changed source layout as confirmation-required.
- 07Validate the rendered payload again before handing it to the existing Amazon submission process.
Working example
Sheet: Dispatch
PO | Shipment | SKU | Qty | UOM | SSCC | Ship date
PO-77821 | ASN-1042 | SKU-104 | 12 | EA | 000123456789012343 | 2026-07-19
BECOMES
{"shipmentConfirmations":[{"shipmentConfirmationType":"Original","shipmentIdentifier":"ASN-1042","purchaseOrderNumber":"PO-77821"}]}The output is abbreviated to show the transformation boundary. Production rendering generates the complete envelope and validates its counts and controls.
Failure modes worth catching
- A formula is exported instead of its displayed value.
- Merged cells hide a shipment reference from later line rows.
- A partner identifier from one route leaks into another partner output.
- The output passes envelope checks but violates the current account implementation guide.
Put it into the dispatch workflow
- 1Create and test the Amazon ASN partner route.
- 2Analyze a representative Excel source and confirm the mapping.
- 3Submit up to 1,000 files using the same partner code over SFTP, email or API.
- 4Generate Amazon ASN separately for every admitted file.
- 5Download the output or inspect the per-file quarantine and validation result.
Questions
Implementation answers
Does the converter guess missing values?
No. Critical shipment fields require confirmation, and route-specific identifiers must be configured. Missing required output data fails closed.
Can I send many source files at once?
Yes. SFTP, authenticated email and the partner-batch API accept up to 1,000 routed files within channel size and plan limits.
Is partner compliance guaranteed?
No. The implemented renderer and public base checks reduce deterministic errors; the receiving account implementation guide and agreement remain controlling.
Sources and limits
Reviewed 2026-07-19. Public references cannot establish every partner-specific rule. Current implementation guides and agreements remain controlling.
Keep investigating