EDI 850 Purchase Order Parser, SDQ Splitter & ERP Converter

Decode BEG headers, REF department codes, N1 ship-to DCs, PO1 product qualifiers, and SDQ cross-dock store splits—then export to Excel, QuickBooks, or Shopify.

Drop your file below, check the order, then download for Shopify Orders (CSV).

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.

Now showing

walmart-850-crossdock.edi

No file handy? Open a sample:

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.

Raw EDI Code Inspector

31 lines

1ISAISA*00* *00* *08*925485US00 *12*5551234567 *261109*0830*^*00501*000010850*0*P*:~

2GSGS*PO*925485US00*5551234567*20261109*0830*10850*X*005010~

3STST*850*0001~

4BEGBEG*00*SA*4500991288**20261109~

5CURCUR*BY*USD~

6REFREF*DP*0018~

7REFREF*MR*0020~

8REFREF*IA*123456789~

9FOBFOB*PP*OR*BENTONVILLE~

10CSHCSH*Y~

11SACSAC*A*D240***2500**********NEW STORE PROMO ALLOWANCE~

12ITDITD*01*3*2**10**30*****2/10 NET 30~

13DTMDTM*037*20261112~

14DTMDTM*038*20261118~

15N1N1*BY*WALMART STORES INC*UL*0078742000008~

16N1N1*ST*WALMART DC 6094G-RDC*UL*0078742035260~

17N3N3*5801 SW REGIONAL AIRPORT BLVD~

18N4N4*BENTONVILLE*AR*72712*US~

19N1N1*VN*ACME HOME GOODS LLC*92*123456789~

20PO1PO1*1*100*EA*12.50*WE*UP*012345678905*IN*554433221*VN*SKU-TOWEL-BLU-L*UK*10012345678902~

21PIDPID*F*08***ORGANIC COTTON BATH TOWEL ROYAL BLUE~

22PO4PO4*10*1*EA~

23SDQSDQ*EA*92*0101*25*0102*35*0103*40~

24PO1PO1*2*60*EA*18.00*WE*UP*012345678912*IN*554433299*VN*SKU-ROBE-WHT-XL~

25PIDPID*F*08***LUXURY WAFFLE ROBE WHITE XL~

26PO4PO4*6*1*EA~

27SDQSDQ*EA*92*0101*20*0102*20*0103*20~

28CTTCTT*2*160~

29SESE*27*0001~

30GEGE*1*10850~

31IEAIEA*1*000010850~

BEGBeginning Segment for Purchase Order (850)

Line #4

Primary header of an EDI 850 Purchase Order. BEG03 is the legal PO # that must be echoed on your 856 ASN and 810 Invoice.

BEG01Transaction Set Purpose Code

BEG02Purchase Order Type Code

BEG03Purchase Order Number

4500991288

BEG05Purchase Order Date

20261109

Purchase Order Summary & Line Items

Purchase Order #

4500991288

Order Date

11/09/2026

Dept # / Vendor #

Dept 0018 · Vendor 123456789

Order Total

$2,305.00 USD

Ship-To Warehouse / DC

WALMART DC 6094G-RDC

5801 SW REGIONAL AIRPORT BLVD

BENTONVILLE, AR 72712

Location Code: 0078742035260

Shipping Dates & Payment Terms

Earliest Ship Date:11/12/2026

Latest Ship Date:11/18/2026

Payment Terms:2/10 NET 30 · FOB PP

Multi-Store Order Detected: Automatically split items by store location

Split rows by Store # (6 rows)

Order / Store #	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

Total Units: 160 across 2 items

Items Subtotal: $2330.00

Allowance / Charge: -$25.00

Net Order Total: $2305.00

Download for your software

Pick where the order is going, then download. Files are ready for Excel, QuickBooks, Shopify or a thermal printer.

Import wholesale purchase orders directly into Shopify (compatible with Matrixify) with automatic per-store order splitting.

Field mapping table: which EDI segment fills which column (for IT & bookkeepers)

EDI 850 Purchase Order Core Segments & ERP 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
BEG00SA4500991288*20261109~	PO #4500991288	Order Name / PONUM	Maps BEG03 to PO Number and BEG05 to Order Date.
REFDP0018~ / REFIA123456789~	Dept 0018 / Vendor 123456789	Tags / Memo / 856 & 810 Echo	Preserves buyer department and vendor IDs for downstream ASN and Invoice turnaround.
N1STWALMART DC 6094GUL...	GLN 0078742035260	Ship-To Address & DC Code	Extracts receiving distribution center name, street (N3), city/state/zip (N4), and GLN.
PO1 + PID + PO4 + SDQ	100 EA @ $12.50 (Split 3 Stores)	Line Items / Store Orders	Resolves SKU/UPC qualifiers and optionally explodes SDQ store allocations.

Critical Chargeback & Import Pitfalls We Prevent

Common EDI mistakes that trigger $250+ retailer fines or accounting balance errors

Dropping SDQ Store Allocations When Importing to WMS

Risk: $250+ Cross-Dock Fine

Shipping bulk unallocated pallets when the 850 contains SDQ store splits results in manual sorting fees at the retailer DC.

Enable SDQ Store Explosion in the workbench to create per-store fulfillment rows.

Misinterpreting SAC05 Promotional Allowances

Risk: 810 Invoice Rejection

SAC05 uses N2 implied decimals ("2500" = $25.00). Ignoring it causes your invoice total to mismatch the PO.

Our parser automatically divides SAC05 by 100 and includes the discount row in QuickBooks exports.

Shipping Outside DTM037 and DTM038 Windows

Risk: OTIF Fine (3% of PO Value)

Delivering before DTM*037 (Ship Not Before) or after DTM*038 (Cancel Date) triggers automatic On-Time In-Full deductions.

Check the highlighted Shipping Window card in the right pane of our inspector.

How to Open & Convert an EDI 850 Purchase Order

Zero middleware setup — complete in under 60 seconds

1. Upload Your .EDI 850 File

Drop the file above to see the formatted Purchase Order and compliance report.

2. Choose Summary or SDQ Store-Split Mode

Toggle "Explode SDQ Store Rows" if fulfilling a cross-dock order.

3. Export to Excel, Shopify, QuickBooks, or Flip to 856/810

Download your preferred ERP import file or launch the Turnaround Wizard.

Frequently Asked Technical Questions

ANSI X12 specification details, retail companion rules, and ERP import answers

How do I open an EDI 850 file in Excel?

Drop your .edi file into the workbench above, scroll to the Exporter Panel, select "Excel Workbook (.XLSX)", and click Download.

Can I generate an 856 ASN and 810 Invoice directly from the 850?

Yes. Click the "850 → 856 ASN + 810 + 4x6 Labels" button in the top-right of the business view.