EDI 846 Inventory Inquiry/Advice Parser & CSV Converter

Decode BIA headers, LIN product identifiers (UP, VN, IN), and QTY01/QTY02 on-hand inventory quantities for dropship and 3PL stock synchronization.

Drop your file below, check the order, then download for Excel (.XLSX) & 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.

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)

EDI 846 Inventory Segments (BIA, LIN, QTY) 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
BIA00DDINV-2026110920261109~	Report #INV-20261109	Report ID & Date	BIA02="DD" indicates Distributor-to-Dealer / Supplier-to-Retailer inventory advice.
LIN1UP012345678905VN*SKU-TOWEL-BLU-L~	UPC 012345678905	UPC / Vendor SKU / Buyer ID	Uses dynamic sliding-window qualifier extraction starting at LIN02.
QTY33250*EA~	250 EA Available	Available Quantity	QTY01="33" = Quantity Available for Sale; "01" = Discrete Quantity; "29" = Projected Available.
DTM01820261120~	2026-11-20	Next Restock Date	Indicates when out-of-stock SKUs will be replenished.

Critical Chargeback & Import Pitfalls We Prevent

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

Confusing QTY01 (On-Hand) with QTY33 (Available to Promise)

Risk: Dropship Overselling Fines

Reporting total warehouse stock without subtracting allocated safety stock leads to stockout cancellations on DSV orders.

Always report net sellable inventory under QTY*33.

Omitting Zero-Quantity SKUs from Full-Refresh 846 Feeds

Risk: Ghost Inventory Orders

If an item goes out of stock and you simply delete its LIN loop instead of sending QTY*33*0, the retailer portal keeps showing the old stock count.

Explicitly transmit QTY*33*0*EA~ for discontinued or depleted items.

Mismatched UPC Check Digits in LIN

Risk: Catalog Sync Failure

Sending 11-digit UPC-A codes without the leading 0 or check digit causes silent catalog rejection.

Verify 12-digit UP and 14-digit UK qualifiers in our inspector.

How to Inspect & Convert EDI Files to Spreadsheets

Zero middleware setup — complete in under 60 seconds

1. Drop Your .EDI File into the Workbench

Inspect every segment and element in the left AST tree.

2. Review Mapped SKUs & Quantities

Use the SKU Cross-Reference drawer to align retailer item numbers with your Shopify SKUs.

3. Export to CSV or Excel (.XLSX)

Download a clean spreadsheet ready for ERP or e-commerce inventory import.

Frequently Asked Technical Questions

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

How often do retailers require EDI 846 inventory feeds?

Dropship programs (Walmart DSV, Home Depot D2C, Lowe’s, Target Plus) typically require a daily full-catalog 846 feed plus hourly delta updates for fast-moving items.

What does QTY*33 mean in an EDI 846?

Qualifier 33 in QTY01 stands for "Quantity Available for Sale (stock quantity available to ship immediately)".