Convert EDI 850 Purchase Orders to Shopify Orders (Matrixify CSV & API)

Shopify Admin has no native Order CSV importer. EDIParse solves this with dual-track delivery: 1-click 29-column Matrixify Orders CSV export (with SDQ store split) and direct Shopify Draft Order API push.

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.

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 Segment to Shopify Matrixify Orders CSV (29 Columns) 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
BEG03 (+ SDQ03 Store #)	4500991288 / Store 0101	Name & Command	Sets Name="PO-4500991288-STORE-0101" and Command="NEW" (groups multi-line items under one order).
N1*ST + N3 + N4	WALMART DC 6094G-RDC	Shipping: Company, Address 1, City, Province Code, Zip	Maps distribution center name, street, state, and postal code to Shopify Shipping fields.
PO106..PO115 (VN / UP / IN)	SKU-TOWEL-BLU-L	Line: Type="Line Item" & Line: SKU	Applies your SKU Cross-Reference dictionary so buyer item numbers match your Shopify variant SKUs.
PO102 (or SDQ04) & PO104	25 EA @ $12.50	Line: Quantity & Line: Price	Populates wholesale unit price and store-allocated quantity with Financial Status="pending".

Critical Chargeback & Import Pitfalls We Prevent

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

Trying to Upload an Order CSV into Shopify Native Admin

Risk: Unsupported File Error

Shopify’s built-in CSV import only accepts Products, Customers, and Inventory—not Orders.

Use our 29-column Matrixify Orders CSV template or our 30-second Custom App Token Draft Order push.

Unmapped Retailer Item Numbers (DPCI / Walmart Item #)

Risk: Unlinked Shopify Inventory

If the 850 only contains Walmart Item #554433221, Shopify cannot deduct stock from your internal SKU.

Open the SKU Dictionary drawer to map buyer IDs to your exact Shopify variant SKUs.

Lumping Cross-Dock Store Splits into a Single Order

Risk: Warehouse Packing Confusion

Walmart cross-dock POs require separate packing slips and labels for each destination store in the SDQ segment.

Leave "Explode SDQ Store Rows" enabled to create a distinct Shopify order per store.

How to Import EDI 850 Orders into Shopify

Zero middleware setup — complete in under 60 seconds

1. Drop Your EDI 850 File into the Workbench

Verify line items, prices, and SDQ store splits.

2. Select "Shopify Matrixify Orders (CSV)" in the Exporter Panel

Download the pre-formatted 29-column CSV file.

3. Upload via Matrixify App or Push via Custom App Token

Drop the CSV into Matrixify in Shopify Admin (or use our Direct Draft Order API).

Frequently Asked Technical Questions

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

Why doesn’t Shopify allow importing orders via CSV natively?

Shopify’s core admin only provides CSV importers for catalog products and customer lists. For bulk B2B order creation, merchants either use the Matrixify app (which reads our exact 29-column CSV) or the Shopify Admin GraphQL draftOrderCreate API.

Does EDIParse group multiple PO1 lines into a single Shopify order?

Yes. In Matrixify format, rows sharing the same "Name" column (e.g., PO-4500991288) with Line: Type="Line Item" are imported as multiple line items inside a single Shopify order.