EDI 850 SDQ Segment: Cross-Dock Store Allocation Guide & Excel Splitter

In a Cross-Dock PO, N1*ST gives the Regional Distribution Center, while SDQ lists up to 10 (Store #, Quantity) pairs per line. Use the interactive workbench below to explode SDQ segments into store-level rows in one click.

Drop your file below, check the order, then download for Excel (.XLSX) & CSV.

Looking for the raw X12 segments (SDQ)? Orders open as a readable document. Select View raw EDI code (for IT) at the top right of the document to see the ANSI X12 segments side by side.

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.

Clean Excel spreadsheet with all order lines, store breakdown, quantities, and prices ready to open in Microsoft Excel or Google Sheets.

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

SDQ (Destination Quantity) Element Structure & Store Explosion Logic

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
SDQ01 & SDQ02	EA * 92	UOM & Store ID Qualifier	SDQ01 = Unit of Measure; SDQ02="92" = Store # assigned by buyer.
SDQ03 & SDQ04	0101 * 25	Store #1 ID & Quantity	Allocates 25 units of the parent PO1 line to Store #0101.
SDQ05/06 .. SDQ21/22	0102 * 35 * 0103 * 40	Stores #2 – #10 ID & Quantity Pairs	Sliding 2-element window extracts up to 10 stores per SDQ segment (multiple SDQ segments allowed per PO1).
Sum(SDQ Quantities) vs PO102	25 + 35 + 40 === 100	Cross-Dock Balance Check	Verifies that the sum of all store quantities equals PO102 ordered quantity.

Critical Chargeback & Import Pitfalls We Prevent

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

Shipping Bulk Pallets Without Store-By-Store Carton Breakdown

Risk: $250–$1,000+ Cross-Dock Fine

When an 850 contains SDQ segments, the retailer’s Regional DC merely cross-docks your pre-labeled store cartons onto outbound store trucks.

Keep "Explode SDQ Store Rows" checked so your warehouse packs by individual store.

Only Parsing SDQ03/SDQ04 and Ignoring SDQ05–SDQ22

Risk: 80% Short-Ship Disaster

A single SDQ segment can hold up to 10 stores (elements 03 through 22). Naive scripts only read the first store pair.

Our parser loops across all element pairs from index 3 to the end of every SDQ segment.

SDQ Sum Mismatch After Partial Inventory Allocation

Risk: 856 ASN Rejection

If you edit PO102 without updating the corresponding SDQ store quantities, the ASN fails validation.

Our linter and Auto-Fix engine keep PO102 and SDQ store sums 100% synchronized.

How to Split SDQ Segments into Store-Level Excel or Shopify Rows

Zero middleware setup — complete in under 60 seconds

1. Load Your Cross-Dock 850 PO Above

Notice the indigo "SDQ Cross-Dock Detected" bar in the right pane.

2. Toggle "Explode SDQ Store Rows" On or Off

Watch 2 summary PO1 lines expand into 6 store-specific order rows instantly.

3. Download Excel (.XLSX), Shopify Matrixify CSV, or ShipStation CSV

Every exported row includes the exact Store ID and store-allocated quantity.

Frequently Asked Technical Questions

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

How many stores can fit inside a single X12 SDQ segment?

Up to 10 (Store ID, Quantity) pairs can fit in one SDQ segment (elements SDQ03 through SDQ22). If an order is split across 50 stores, the PO1 loop will contain 5 consecutive SDQ segments.

Does EDIParse support multiple consecutive SDQ segments under one PO1?

Yes. Our parser accumulates all store allocations across any number of consecutive SDQ segments belonging to the active PO1 line.