Convert ANSI X12 EDI (850 / 856 / 810) to Normalized JSON
Skip brittle regex scripts. Parse raw X12 interchanges into strongly-typed JSON objects with pre-resolved product qualifiers, N1 party maps, and N2 decimal numbers.
Drop your file below, check the order, then download for JSON / ERP Webhook.
- 1Load your order file
- 2Check it and match your SKUs
Drop your EDI order file here
.edi, .x12 or .txt. The file is read on your computer and is not uploaded.
No chargeback risks found. This order passes every check.
Checked against the Walmart supplier guide for EDI 850.
- Detected Cross-Dock SDQ allocations (6 store-level splits verified against PO102).
- Walmart Dept #0018 & Vendor #123456789 verified.
Purchase Order Summary & Line Items
| Order / Store # | Your SKU | Retailer Item # / UPC | Item Description | Qty | Unit Price | Line Total |
|---|---|---|---|---|---|---|
| PO-4500991288-STORE-0101 | Item: 554433221 UPC: 012345678905 | ORGANIC COTTON BATH TOWEL ROYAL BLUE | 25 EA | $12.50 | $312.50 | |
| PO-4500991288-STORE-0102 | Item: 554433221 UPC: 012345678905 | ORGANIC COTTON BATH TOWEL ROYAL BLUE | 35 EA | $12.50 | $437.50 | |
| PO-4500991288-STORE-0103 | Item: 554433221 UPC: 012345678905 | ORGANIC COTTON BATH TOWEL ROYAL BLUE | 40 EA | $12.50 | $500.00 | |
| PO-4500991288-STORE-0101 | Item: 554433299 UPC: 012345678912 | LUXURY WAFFLE ROBE WHITE XL | 20 EA | $18.00 | $360.00 | |
| PO-4500991288-STORE-0102 | Item: 554433299 UPC: 012345678912 | LUXURY WAFFLE ROBE WHITE XL | 20 EA | $18.00 | $360.00 | |
| PO-4500991288-STORE-0103 | Item: 554433299 UPC: 012345678912 | LUXURY WAFFLE ROBE WHITE XL | 20 EA | $18.00 | $360.00 |
Download for your software
Pick where the order is going, then download. Files are ready for Excel, QuickBooks, Shopify or a thermal printer.
Field mapping table: which EDI segment fills which column (for IT & bookkeepers)
X12 Segment to JSON Object Property Mapping
Deterministic segment-to-column mapping rules enforced by our client-side X12 engine
| Source X12 Segment / Element | Sample Raw Value | Target ERP / CSV Column | Transformation & Validation Logic |
|---|---|---|---|
| ISA / GS / ST | ISA*00*...~ | transactionSet.delimiters | Exposes detected element, repetition, component, and segment delimiters. |
| PO1 / IT1 / LIN | PO1*1*100*EA*12.50**UP*... | productIds.allQualifiers | Builds a key-value map of all qualifier pairs plus resolvedSku. |
| HL*1**S -> HL*7*6*I | 5-Tier HL Tree | flattenedRows[] | Resolves parent-child pointers into a flat JSON array of carton/item objects. |
| TDS01 / SAC05 | 230500 / 2500 | tdsTotalInvoiceAmount | Converts N2 implied cent integers into standard IEEE floating-point dollar numbers. |
Critical Chargeback & Import Pitfalls We Prevent
Common EDI mistakes that trigger $250+ retailer fines or accounting balance errors
Hardcoding PO1 Element Positions in Custom Parsers
Risk: Silent SKU SwapsRetailers change the order of UP, IN, VN, and UK qualifiers between POs. Reading elements[7] blindly grabs the wrong ID.
Treating TDS01 as a Standard Float
Risk: 100x Overbilling BugParsing TDS*230500~ with parseFloat() without dividing by 100 turns $2,305.00 into $230,500.00.
Failing on Repetition Separators in 005010
Risk: Broken ISA Header ParseX12 005010 replaces the "U" in ISA11 with a repetition character like "^".
How to Export EDI to JSON for Your Webhook or ERP API
Zero middleware setup — complete in under 60 seconds
Paste raw X12 text into the live editor or drop a file.
Inspect the normalized JSON structure in real time.
Use the JSON payload directly in your Node.js, Python, or n8n/Make automation workflows.
Frequently Asked Technical Questions
ANSI X12 specification details, retail companion rules, and ERP import answers
Does the JSON output include both raw segments and normalized business fields?
Yes. You get both the normalized business model (PO header, parties, exploded lines) and the raw parsed segment AST.
Can I test malformed X12 payloads in the live editor?
Yes. Switch the left pane to "Raw X12 Editor" to modify segments and watch the JSON and linter update on every keystroke.
Related EDI Converters, Retailer Guides & X12 Segment References
- ToolsOnline ANSI X12 EDI Viewer & Human-Readable Inspector
- ToolsConvert EDI X12 Files (850 / 856 / 810) to Excel (.XLSX) & CSV
- ToolsConvert EDI 850 Purchase Order to Compliant EDI 856 ASN
- ToolsConvert EDI 850 Purchase Order to Compliant EDI 810 Invoice
- ToolsGS1-128 (UCC-128) 4x6" Carton Label PDF Generator for EDI 856 & 850
- ToolsSSCC-18 Check Digit Calculator & MAN*GM Batch Generator
- Transaction setsEDI 850 Purchase Order Parser, SDQ Splitter & ERP Converter
- Transaction setsEDI 856 Advance Ship Notice (ASN) Inspector, Excel Converter & Label Generator
- Transaction setsEDI 810 Commercial Invoice Inspector & QuickBooks / Xero Converter