EDI 850 PO1 Segment & Product Qualifiers (UP, IN, VN, BP, UK) Guide
Stop hardcoding column indexes when parsing PO1 segments. See how sliding-window qualifier extraction resolves UPCs, Target DPCIs, Walmart Item #s, and Vendor SKUs.
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.
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 linesPrimary header of an EDI 850 Purchase Order. BEG03 is the legal PO # that must be echoed on your 856 ASN and 810 Invoice.
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)
PO1 Segment Elements & Product Qualifier Dictionary
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 |
|---|---|---|---|
| PO101, PO102, PO103, PO104 | 1 * 100 * EA * 12.50 | Line #, Quantity, UOM, Unit Price | Defines ordered quantity and explicit-decimal wholesale unit price. |
| Qualifier UP / EN / UK | UP*012345678905 / UK*10012345678902 | UPC-12 / EAN-13 / GTIN-14 | UP = 12-digit Consumer UPC; EN = 13-digit European Article Number; UK = 14-digit Case GTIN. |
| Qualifier IN / BP / CB / SK | IN*554433221 / BP*B08N5WRWNW | Buyer Item # / DPCI / ASIN | Retailer’s internal catalog code (Walmart Item #, Target DPCI, Amazon ASIN). |
| Qualifier VN / VP / VA / VC | VN*SKU-TOWEL-BLU-L | Vendor’s Internal SKU / Style # | Supplier’s own catalog part number. |
Critical Chargeback & Import Pitfalls We Prevent
Common EDI mistakes that trigger $250+ retailer fines or accounting balance errors
Hardcoding PO107 as UPC and PO109 as SKU
Risk: Scrambled Order LinesOne retailer sends PO1*...*UP*123*VN*ABC~, while another sends PO1*...*IN*999*UP*123~. Fixed index parsers grab the wrong field.
Returning Partial Qualifiers on 856 LIN and 810 IT1
Risk: 824 Line Match ErrorIf the buyer sent IN and UP in PO1, omitting IN on your outbound 856 or 810 causes line matching to fail.
Missing Internal SKU When Buyer Only Sends IN & UP
Risk: Failed Shopify / QuickBooks ImportWalmart and Target often omit VN (your SKU) and only send their own Item #/DPCI and UPC.
How to Map PO1 Product Qualifiers to Your Internal SKUs
Zero middleware setup — complete in under 60 seconds
See every element (PO101–PO113) decoded side-by-side.
Click "Auto-Populate from Active EDI" to list all buyer IDs and UPCs.
Every exported row now uses your clean internal SKU.
Frequently Asked Technical Questions
ANSI X12 specification details, retail companion rules, and ERP import answers
What is the difference between UP and UK in a PO1 segment?
UP is a 12-digit UPC-A barcode printed on the individual retail unit. UK is a 14-digit GTIN-14 (ITF-14) barcode printed on the outer corrugated master case.
What qualifier does Target use for DPCI and Amazon use for ASIN?
Target transmits its 9-digit DPCI (XXX-XX-XXXX) using qualifier "IN" (Buyer’s Item Number). Amazon Vendor Central transmits its 10-character ASIN using qualifier "BP" (Buyer’s Part Number).
Related EDI Converters, Retailer Guides & X12 Segment References
- X12 referenceEDI 850 BEG Segment: Beginning Segment for Purchase Order Guide
- X12 referenceEDI 850 SDQ Segment: Cross-Dock Store Allocation Guide & Excel Splitter
- X12 referenceEDI 856 BSN Segment: Beginning Segment for Ship Notice Guide
- X12 referenceEDI 856 HL Segment: S→O→T→P→I Hierarchy Validator & Excel Flattener
- X12 referenceEDI 856 MAN Segment: MAN*GM SSCC-18 & Marks and Numbers Guide
- X12 referenceEDI 810 BIG Segment: Beginning Segment for Invoice Guide
- ToolsOnline ANSI X12 EDI Viewer & Human-Readable Inspector
- ToolsConvert EDI X12 Files (850 / 856 / 810) to Excel (.XLSX) & CSV
- ToolsConvert ANSI X12 EDI (850 / 856 / 810) to Normalized JSON