Readysell CSV EDI confirmation via HTTP

Introduction

CSV via HTTP is the preferred method for EDI confirmation. This method provides instant feedback to the customer on order status and does not reply on polling the supplier server, reducing network load.

Overview

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)

Transport is performed by an HTTP(S) POST request to an endpoint URL that is unique per-customer. The endpoint will return an HTTP 200 response on success or an HTTP 500 response if there is a processing error.

Data specification

Header fields

Name	Description	Type	Example
type	Always "Invoice"	String	Order
account_number	The customer's account number at the supplier.	String	ABC123
po_number	The purchase order number as generated by the customer's system.	Integer	12345
invoice_number	The invoice number as generated by the supplier's system.	String	200001
invoice_date	The date of the invoice in the supplier's system.	ISO 8601 date	2015-08-15
delivery_date	The date on which the order is expected to be delivered.	ISO 8601 date	2015-08-21

Line data

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 invoiced.	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

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