Introduction
CSV via FTP is the supported method for fully automated EDI ordering. Because customer data for small dealers can be inconsistent, we highly recommend Readysell hybrid EDI ordering over this approach. If you do, however, have the ability to reconcile data errors in your system after the order arrives, then CSV via FTP is a valid alternative.
Overview
The format include additional information including EZ-code, barcode and product description. We believe that it’s best to include this additional data as it can be used for validation or debugging purposes or to do manual matching to resolve data discrepancies (where required). The file is self-documenting and has 3 row types:
- D = Description (describes the purpose of the rows below)
- H = Header (header information, shown once per file)
- L = Line (line information, repeats for each line)
Dates are expressed in ISO 8601 date format. OrderLineNumber is unique per customer ERP system, not per customer order. CustomerProductCode is usually the Office Brands EZ Code – but could be a customer’s own code if the product is set up manually. SupplierProductCode and Barcode will be included in the order where possible, but only CustomerProductCode is guaranteed.
Transport is via an FTP server at the supplier side. Customers will upload orders to the FTP server when they are placed.
Data specification
Coming soon
Sample message
D,Type,Customer,Supplier,PurchaseOrderNumber,PurchaseOrderDate,,, H,Order,SATEX,AVERY,100001,2013-05-13,,, D,OrderLineNumber,CustomerProductCode,SupplierProductCode,Barcode,Description,Quantity,PackQuantity,UnitPrice L,1234567,7007123,TESTPROD1,,THIS IS A TEST PRODUCT,10,10,12.95 L,1234568,7007124,TESTPROD2,12345678905,THIS IS ANOTHER TEST PRODUCT,20,1,3.75 L,1234569,7007125,,12345678916,THIS IS A THIRD TEST PRODUCT,5,100,40.95 L,1234570,7007126,TESTPROD4,,THIS IS A FOURTH TEST PRODUCT,16,1,2.45 L,1234571,7007127,,12345678927,THIS IS A FIFTH TEST PRODUCT,12,2,64.95