Data specification

Bare Customer

NameRequiredData typeValueExample
email_hash✓Stringemail 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_id✓StringUnique id of order"ooxoh9Oogh0obi7E"
created✓StringDate and time of order creation in ISO 8601 format"2013-07-22T14:57:18+00:00"
approx_total_price✓NumberApproximate total price incl. VAT (without shipping): 1 = price ≤ 500 CZK, 2 = price > 500 CZK1
billing_address✓BareAddressBilling address of customer
delivery_addressBareAddressDelivery address of customer. Note: If its not specified you billing address
is_paid✓BooleanOrder has been paid. Orders via Twisto must always have set is_paid to falsetrue
is_shipped✓BooleanOrder 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"
zipcode✓StringZIP 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"
email✓StringEmail"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_id✓StringUnique ID of order"9JV72FUAC"
created✓StringDate and time of order creation in ISO 8601 formar"2013-07-22T14:57:18+00:00"
billing_address✓AddressBilling address of customer
delivery_addressAddressDelivery address of customer. Note: If its not specified you billing_address
total_price_vat✓NumberTotal amount of order incl. VAT406.07
is_paid✓BooleanOrder has been paid. Orders by Twisto needs is_paid to be set to false.true
is_shipped✓BooleanOrder has been shipped to customertrue
is_deliveredBooleanOrder has been delivered to customertrue
is_returnedBooleanOrder or its part has been returnedfalse
items✓Array<OrderItem>Purchased items from order

Address

NameRequiredData typeValueExample
name✓StringFull Name"Jan Novák"
street✓StringStreet"Karla Engliše 3208/5"
city✓StringCity"Praha 5"
zipcode✓StringZip code"15000"
countryStringCountry code in ISO 3166-1 alpha-2 format. Note If not specified, "CZ" will be used instead"CZ"
phones✓Array<String>Phone numbers of customer["+420733123456", "+420724123456"] or ["+420733123456"]

Order Item

NameRequiredData typeValueExample
quantity✓NumberQuantity4
name✓StringName of goods"Růžový šátek s ornamenty"
price_vat✓NumberCelková cena s DPH [4]406.07
vat✓NumberVAT 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_vat✓NumberTotal price incl. VAT406.07
billing_address✓AddressBilling address of customer
delivery_addressAddressDelivery address of customer. Note: If its not specified you billing_address
items✓Array<OrderItem>Individual order items