CSV

Comma Separated Value files are often used due to their simplicity. You can easily prepare a CSV file using some Spreadsheet tool like Microsoft Excel© or LiberOffice Calc©

Basket

Name Description Format Example
Row marker Describes the type of the row - always B character(1) B
Basket number Basket / transaction number - should be unique character(20) 2562263
Store Name of the store the transaction did happen character(20) London North
Channel Transaction channel - POS / E-Shop / Mobile / Call Center character(20) POS
Sale date Date the transaction was performed date (YYYY-MM-DD) CASH
Payment type Payment type - Cash / Credit Card / Bank transfer / etc. character(20) CASH
Line items count Count of line items for this particular basket integer 6

Example

B;000000000000001;B2C Site;E-Shop;2012-09-21;CASH;4

Basket items

Name Description Format Example
Row marker Describes the type of the row - always I character(1) I
Product Name or code of product character(100) Soya Sauce 100ml
Quantity Quantity of product purchased decimal(10,2) 3.50
Unit price unit price for one item of particular product decimal(10,2) 3.99
Total price Total price for particular product decimal(10,2) 13.96

Example

I;Soy sauce;3.00;2.39;7.17

© www.ComOnAn.com 2018 Privacy Policy