Overview

We generally create order files whenever there are new, processed orders, but some customers prefer to receive files with orders for the last X days (then we can also add shipment tracking info, etc).
Product file(s) are generally created once a day.

EDI Order format

Unless you have specific requirements, our standard order file looks like this:

8; 2;
H; ; OrderID; 1; Order total; 137; Customer number; Company (billing); Address (billing); Department (billing); Attention (billing); ; Postcode (billing); City (billing); ; DealerCompanyName; DealerAddress; ; ; ; Dealer ZIP/City ; ; Order date (YYYYMMDD); ; ; ; ; ; ; Customer reference; Email; ; ; ; ; ; ; ; ; 1; ; ; ; ; ; ; ; ; ; Company (shipping); Address (shipping); Department (shipping); Attention (shipping); ; Postcode (shipping); City (shipping); OurRef; YourRef; ; ReqNo ; ; SalesPersonNo; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; -1;
L; 1; MfgSKU; Product name; Qty; Price; Cost; Cost; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ;Distributor number ; ; ; ; ;Internal user number Visma; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Manufacturer; Distributor; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
L; 2; VismaFreightSKU; FreightText; 1; Delivery cost; 0 ; 0 ; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
L; 3; -; Payment method; 1; ; 0 ; 0 ; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
L; 4; -; Admin comment; 1; ; 0 ; 0 ; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
L; 5; -; Customer comment; 1; ; 0 ; 0 ; ; ; ; ; ; ; Order date (YYYYMMDD); ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;

L1 - product - will be repeated as many times as there are product lines in the order.
Payment method, admin comment, customer comment are optional, and not that common to include.

Complete Order File Specs

Product file

short version

@Prod (ProdNo, Descr, ProdGr, ProdTp, StSaleUn, ProdPrGr, SpecFunc, ExcPrint, EditPref, EdFmt, ExpStr, PrM2b, WageSrt, DesMrg, NrmStc, ProcMt)

"417756-421" "HP ProLiant DL140 R03 Xeon 5110" "1" "0" "0" "0" "0" "16384" "512" "0" "0" "0" "" "0" "0" "67108864"

Complete Product file

@Prod (ProdNo, Descr, ProdGr, ProdTp, StSaleUn, ProdPrGr, SpecFunc, ExcPrint, EditPref, EdFmt, ExpStr, PrM2b, WageSrt, DesMrg, NrmStc, ProcMt, AgrAct, NWgtU, TareU, VolU, CusStNo, RepProd, R1, R2, R3, R4, R5, R6, Gr, Gr2, Gr3, Gr4, Gr5, Gr6, Inf, Inf2, Inf3, Inf4, Inf5, Inf6, ExArr, ExQty, NoteNm, CstPrAdd, GrSep, EUStatNo, ProdTp2, FrNo, ToNo, Factor3, InvoPlLn, Rsp, Buyer, ProdPrG2, ProdPrG3, LgtU, WdtU, HgtU, AreaU, Measure, StUnRt, Gr7, Gr8, Gr9, Gr10, Gr11, Gr12, Inf7, Inf8, ProdTp3, ProdTp4, TrInf1, TrInf2, Rsp2, PrUn, PrNo, DensU, TrTp, TrAm, PrM1b, PrM1c, PrM2c, PrM3b, PrM3c, PrM4b, PrM4c, PrM5b, PrM5c, PictNo, TrInf3, TrInf4, OldPNo, SPrAdd, EANItmNo, ProdPro, PrCatNo, PrCatNo2, NwProdNo, WebPg2, PgElNo, R7, R8, R9, R10, R11, R12, WfId, PLDNo, PLDFlow, Free1, Free2, Free3, Free4, PrCatNo3, PrCatNo4, PrCatNo5, PrCatNo6, AgrProc, NxtSerNo, WageRtNo, PrK)

"417756-421" "HP ProLiant DL140 R03 Xeon 5110" "1" "0" "0" "0" "0" "16384" "512" "0" "0" "0" "" "0" "0" "67108864" "0" "0" "0" "0" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "" "" "0" "0" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "0" "0" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "" "" "" "" "0" "" "0" "0" "0" "" "" "0" "" "" "" "" "" "" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0"

Customers

@Actor (=Custno, nm,ad1, ad2, ad3, ad4, Pno, PArea, Ctry, CustPrGR, Inf7, Phone, MailAd)
"20005" "testfirma AS" "GATE 1" "Postboks 1" "ad3" "ad4" "3200" "sandefjord" "47" "3" "webmercs" "33445566" "tst@kjlhok.no"