TB.One > Order Data and Order Processing > Order Processing via CSV > Order Processing via CSV - Examples
Order Processing via CSV - Examples
1. ORDER FILE IN THE CSV FORMAT
Character set = WIN-latin1, separator = semicolon
TB_ORDER_ID;CHANNEL_KEY;CHANNEL_ORDER_ID;CHANNEL_ORDER_NR;ORDER_DATE;IDCODE_SHIP;GPLCODE;TOTAL_AMOUNT;SHIPPING_COSTS;PAYMENT_TYPE;PAYMENT_COSTS;PAYMENT_TRANSACTION_ID;PAYMENT_TRANSACTION_NR;PAYMENT_TRANSACTION_NAME;DIRECTDEBIT_ACCOUNTNAME;DIRECTDEBIT_ACCOUNTNR;DIRECTDEBIT_BANKNAME;DIRECTDEBIT_BANKCODE;CUSTOMER_COMMENT;TB_CUST_SHIP_ID;CHANNEL_CUST_SHIP_ID;CUST_SHIP_SALUTATION;CUST_SHIP_SURNAME;CUST_SHIP_FIRSTNAME;CUST_SHIP_EXTENSION;CUST_SHIP_STREET_NO;CUST_SHIP_ZIP;CUST_SHIP_CITY;CUST_SHIP_COUNTRY_CODE;CUST_SHIP_TEL_PRIV;CUST_SHIP_TEL_OFFICE;CUST_SHIP_EMAIL;CUST_SHIP_BIRTHDATE;TB_SELL_CUST_ID;CHANNEL_SELL_CUST_ID;CUST_SELL_SALUTATION;CUST_SELL_SURNAME;CUST_SELL_FIRSTNAME;CUST_SELL_EXTENSION;CUST_SELL_STREET_NO;CUST_SELL_ZIP;CUST_SELL_CITY;CUST_SELL_COUNTRY_CODE;CUST_SELL_TEL_PRIV;CUST_SELL_TEL_OFFICE;CUST_SELL_EMAIL;CUST_SELL_BIRTHDATE;POS_LFDNR;POS_TB_ID;POS_CHANNEL_ID;POS_A_ID;POS_ANR;POS_ANR2;POS_EAN;POS_TEXT;POS_QUANTITY;POS_DELIVERY_TIME;POS_SALESPRICE;POS_ANR_CHANNEL;DIRECTDEBIT_IBAN;DIRECTDEBIT_BIC;CUST_SHIP_TEL_MOBILE;CUST_SELL_TEL_MOBILE;ORDER_STATUS;POS_TRANSFER_PRICE;PAYMENT_DATA;IS_EXPRESS;SERVICE_Code{1};SERVICE_Desc{1};SERVICE_Price{1};SERVICE_Code{2};SERVICE_Desc{2};SERVICE_Price{2};SERVICE_Code{3};SERVICE_Desc{3};SERVICE_Price{3}
3;zade;104103000;11304000;30.03.2017;;;57.00;0.00;rede;0.00;;;;;;;;;8;8478043db00f2e649b506655;;Mustermann;Max;;Musterstraße 15;15423;Musterstadt;DE;;;onboarding@tradebyte.com;0000-00-00;8;8478043db00f2e649b506655;;Mustermann;Max;;Musterstraße 15;15423;Musterstadt;DE;;;onboarding@tradebyte.com;0000-00-00;;1;8;fegF01CTp-a018;;10-6-19-22|8;can 754 grau türkis 200x290;;Teppich Canvas;4;0;149.00;;;;;;Open;approved;149;;0;241250100;Batchnummer;0;2,87251E+12;Barcode;0;;;
3;zade;104103000;11304000;30.03.2017;;;79.00;0.00;rede;0.00;;;;;;;;;8;8478043db00f2e649b506655;;Mustermann;Max;;Musterstraße 15;15423;Musterstadt;DE;;;onboarding@tradebyte.com;0000-00-00;8;8478043db00f2e649b506655;;Mustermann;Max;;Musterstraße 15;15423;Musterstadt;DE;;;onboarding@tradebyte.com;0000-00-00;;2;10;dktW3VJWp-a139;;10-6-29-18|2;can 773 multi 80x150;;Teppich Canvas;1;0;33.00;;;;;;Open;approved;33;;0;241250100;Batchnummer;0;2,87251E+12;Barcode;0;;
A shortened example for better overview:
TB_ORDER_ID;CHANNEL_KEY;CHANNEL_ORDER_ID;CHANNEL_ORDER_NR;ORDER_DATE;IDCODE_SHIP;GPLCODE;TOTAL_AMOUNT;… 3;zade;104103000;11304000;2017-03-30;;;57.00; 3;zade; 104103000;11304000;2017-03-30;;;79.00; |
|---|
If you open the CSV in a spreadsheet software using the correct settings, you'll see the following table:
2. MESSAGE FILE IN THE CSV-FORMAT
Character set = WIN-latin1, separator = semicolon
TB_ORDER_ID;ORDER_PAID;TYPE;PARCEL_TYPE;SHIP_CODE;IDCODE_RETURN_PROPOSAL;COMMENT_INTERN 1310;1;return;DHL_STD;340434000000000000;440434000000000000; 1286;1;return;DHL_STD;340434000000000000;440434000000000000; 1296;1;ship;DHL_STD;;; 1298;1;ship;DHL_STD;;; |
|---|
If you open the CSV in a spreadsheet software using the correct settings, you'll see the following table:
For further information, see also:
•Order processing and messages via CSV - overview
•Files and naming conventions for orders and messages (CSV)
•Order data fields (CSV)
•Message data fields (CSV)