Introduction
CSV via FTP is the alternate method for EDI confirmation. This method provides delayed feedback to the customer about order status as it is reliant on the customer system polling the supplier’s FTP server on a periodic basis. Where possible we recommend Readysell CSV EDI orders via HTTP as it provides instant feedback to the customer on order status and does not reply on polling the supplier server, reducing network load.
...
Name | Description | Type | Example | Comment |
|---|---|---|---|---|
| order_line_number | The line number from the original order from the customer's system. | Integer | 1234567 | Unique per customer ERP system, not per customer order. |
| supplier_product_id | The product ID of the product in the supplier's system. | String | A1234 | |
| inner_barcode | The inner barcode the product. | String | 01234567890128 | |
| product_name | The name/description of the product. | String | A4 PAPER WHITE 100GSM | |
| qty | Unit quantity orderedinvoiced. | Integer | 6 | |
| pack_unit | Name of pack unit in which the invoice quantity is expressed. | String | BOX | |
| pack_quantity | Quantity of inners in each unit being ordered. | Integer | 10 | For example, if an order is being placed for 6 cartons and each carton contains 10 boxes (where a box is the sell/inner unit), this field will contain 10. |
| unit_price | The price for each unit ordered. | Decimal | 19.45 |
Sample message
| Code Block | ||
|---|---|---|
| ||
D,type,account_number,po_number,invoice_number,invoice_date,delivery_date,, H,Invoice,ABC123,12345,200001,2015-08-15,2015-08-21,, D,order_line_number,supplier_product_id,inner_barcode,product_name,qty,pack_unit,pack_quantity,unit_price L,1234567,TESTPROD1,12345678938,THIS IS A TEST PRODUCT,10,BOX,8,12.95 L,1234568,TESTPROD2,12345678905,THIS IS ANOTHER TEST PRODUCT,20,EACH,1,3.95 L,1234569,TESTPROD3,12345678916,THIS IS A THIRD TEST PRODUCT,5,CARTON,100,39.95 L,1234570,TESTPROD4,12345678949,THIS IS A FOURTH TEST PRODUCT,16,EACH,1,2.45 L,1234571,TESTPROD5,12345678927,THIS IS A FIFTH TEST PRODUCT,12,PACK,2,64.95 |