Data specification

Bare Customer

NameRequiredData typeValueExample
email_hashStringemail MDP hashed in normalize format*"bdd139eaa71daffb11b1133f5a9bd60e"
facebook_id_hashStringMD5 hash Facebook ID"202cb962ac59075b964b07152d234b70"
customer_idStringUnique id of registered customer"c9f0f895fb98ab9159f51fd0297e236d"

*small letters without spaces. Example (ondrej.s@example.com)

Bare Order

NameRequiredData typeValueExample
order_idStringUnique id of order"ooxoh9Oogh0obi7E"
createdStringDate and time of order creation in ISO 8601 format"2013-07-22T14:57:18+00:00"
approx_total_priceNumberApproximate total price incl. VAT (without shipping): 1 = price ≤ 500 CZK, 2 = price > 500 CZK1
billing_addressBareAddressBilling address of customer
delivery_addressBareAddressDelivery address of customer. Note: If its not specified you billing address
is_paidBooleanOrder has been paid. Orders via Twisto must always have set is_paid to falsetrue
is_shippedBooleanOrder has been shippedtrue
is_deliveredBooleanOrder has been deliveredfalse
is_returnedBooleanOrder, or its part has been returnedfalse

Bare Address

NameRequiredData typeValueExample
streetStringStreet"Karla Engliše 3208/5"
cityStringCity"Praha 5"
zipcodeStringZIP code"15000"
countryStringCountry code in ISO 3166-1 alpha-2 format. Note If not specified use "CZ""CZ"
phones_hashArray<String>MD5 hashes of customer's phone numbers["bdd139eaa71daffb11b1133f5a9bd60e", "202cb962ac59075b964b07152d234b70"] or ["bdd139eaa71daffb11b1133f5a9bd60e"]

Customer

NameRequiredData typeValueExample
nameStringFull name"Jan Novák"
emailStringEmail"jan.novak@example.com"
facebook_idStringFacebook ID"123456789"
date_registeredStringDate and time when customer has been registered in ISO 8601 format"2013-07-22T14:57:18+00:00"
customer_idStringUnique ID of registered customer"c9f0f895fb98ab9159f51fd0297e236d"

Order

NameRequiredData typeValueExample
order_idStringUnique ID of order"9JV72FUAC"
createdStringDate and time of order creation in ISO 8601 formar"2013-07-22T14:57:18+00:00"
billing_addressAddressBilling address of customer
delivery_addressAddressDelivery address of customer. Note: If its not specified you billing_address
total_price_vatNumberTotal amount of order incl. VAT406.07
is_paidBooleanOrder has been paid. Orders by Twisto needs is_paid to be set to false.true
is_shippedBooleanOrder has been shipped to customertrue
is_deliveredBooleanOrder has been delivered to customertrue
is_returnedBooleanOrder or its part has been returnedfalse
itemsArray<OrderItem>Purchased items from order

Address

NameRequiredData typeValueExample
nameStringFull Name"Jan Novák"
streetStringStreet"Karla Engliše 3208/5"
cityStringCity"Praha 5"
zipcodeStringZip code"15000"
countryStringCountry code in ISO 3166-1 alpha-2 format. Note If not specified, "CZ" will be used instead"CZ"
phonesArray<String>Phone numbers of customer["+420733123456", "+420724123456"] or ["+420733123456"]

Order Item

NameRequiredData typeValueExample
quantityNumberQuantity4
nameStringName of goods"Růžový šátek s ornamenty"
price_vatNumberCelková cena s DPH [4]406.07
vatNumberVAT in percentage21
is_shipmentBooleanThe item represents a shipping feefalse
is_paymentBooleanThe item represents the payment feefalse
is_discountBooleanItem represents discount or rounding item (price_vat must be negative)false
categoriesArray<String>Category tree["Laptops", "Apple"]
product_idStringID of product"c81e728d9d4c2f636f067f89cc14862c"
ean_codeStringEAN code of the product"8859094127591"

New Order

NameRequiredData typeValueExample
total_price_vatNumberTotal price incl. VAT406.07
billing_addressAddressBilling address of customer
delivery_addressAddressDelivery address of customer. Note: If its not specified you billing_address
itemsArray<OrderItem>Individual order items