List of offline orders and online order sent by the datalake team
Must contain a minimum of 1
items
The order details schema
No Additional Propertiesthe order id known by the opco and the customer.
"4999569661752721026"
the list of logistic details related to this order
Must contain a minimum of 1
items
Information about the logistic details of the current cart (logistic method, logistic preferences, logistic options, delivery address, facility id)
{
"logisticMethod": "DELIVERY",
"facilityId": 395,
"deliveryAddress": {
"addressLine1": "chaussee Verlinden 22",
"addressLine2": "Apartment 2",
"city": "Bruges",
"country": "BEL",
"postalCode": "0287",
"addressName": "Building #2",
"companyName": "Easy Electric",
"contactFirstName": "John",
"contactLastName": "Doe",
"contactPhoneNumber": "+333746573829",
"deliveryIndication": "Please leave the parcel next the front door.",
"customerReference": "Ref 364361"
},
"logisticOption": {
"code": "STANDARD",
"title": "STANDARD delivery",
"description": "choose this option if you want a fast delivery",
"cost": {
"amount": 0,
"scale": 2,
"currency": "EUR"
},
"logisticScenario": {
"code": "1_DELIVERY",
"title": "1 DELIVERY",
"description": "choose this scenario if you want all your products to be delivered at the same time",
"cost": {
"amount": 0,
"scale": 2,
"currency": "EUR"
},
"shippingGroups": [
{
"status": "DELIVERED",
"deliveryDate": "2017-07-21T08:30:22.804Z",
"lineItems": [
{
"quantity": 1,
"lineItemId": "1",
"itemPrice": {
"amount": 1800,
"scale": 2,
"currency": "EUR"
}
}
]
}
]
}
}
}
Logistic method chosen for the cart
"PICK_UP"
Unique identifier of the locker related to the 'facilityId' where the customer want pick up his order. The facilityId still the place where the order will be prepared
"395"
Unique identifier of the facility used when logistic method is 'PICK_UP'.
"395"
The id of the CDC from where this cart should be delivered. Needed to compute the right stock into PLP/PDP ....In case of multi CDC, the OpCo may have dynamic computation of the CDC and not only a static relation between branch and CDC.
"2Z1"
The address used for delivery when logistic method is 'DELIVERY'
{
"addressLine1": "chaussee Verlinden 22",
"addressLine2": "Apartment 2",
"city": "Bruges",
"country": "BEL",
"postalCode": "0287",
"addressName": "Building #2",
"companyName": "Easy Electric",
"contactFirstName": "John",
"contactLastName": "Doe",
"contactPhoneNumber": "+333746573829",
"deliveryIndication": "Please leave the parcel next the front door.",
"customerReference": "Ref 364361"
}
OpCo internal system's unique identifier for the address. Will be empty of the address is not yet synced with the opco backend system
"237564557868778"
According to ISO 19160 the 1/3 component of the street address. This usually contains the whole address though
"chaussee Verlinden 22"
According to ISO 19160 the 2/3 component of the street address.
"1st floor"
According to ISO 19160 the 3/3 component of the street address.
"Apparment 2"
The city name
"Bruges"
The region name
"Frandre"
The department name
"N/A"
The ISO 3166-1 alpha-3 of the country
"Belgium"
Postal code
"0287"
Extra description about the address
"Building site 1"
Company name, it might differ from the account name
"Easy Electric"
Address contact's first name
"John"
Address contact's last name
"Doe"
Address contact's Phone number (The phone number of the person receiving the delivery)
"+330287345678"
Optional indications or instructions about the delivery
"Please leave the parcel next the front door"
Optional reference about the customer
"Reference 123"
the logistic option choosed for the selected logistic method (e.g a standard delivery is a logistic option).
{
"code": "STANDARD",
"title": "STANDARD delivery",
"description": "choose this option if you want a fast delivery",
"cost": {
"amount": 0,
"scale": 2,
"currency": "EUR"
},
"logisticScenario": {
"code": "1_DELIVERY",
"title": "1 DELIVERY",
"description": "choose this scenario if you want all your products to be delivered at the same time",
"cost": {
"amount": 0,
"scale": 2,
"currency": "EUR"
},
"totalPrice": {
"amount": 2300,
"scale": 2,
"currency": "EUR"
},
"totalPriceIncludingSurchargesAndShipping": {
"amount": 1900,
"scale": 2,
"currency": "EUR"
},
"shippingGroups": [
{
"lineItems": [
{
"quantity": 1,
"lineItemId": "1",
"itemPrice": {
"amount": 1800,
"scale": 2,
"currency": "EUR"
}
}
]
}
]
}
}
The code of the logistic option
"STANDARD"
The title of the logistic option to be displayed to the end user.
"STANDARD delivery"
The description of the logistic option to be displayed to the end user.
"choose this option if you want a fast delivery"
The cost of this logistic option
{
"amount": 0,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
this is a list of logistic scenarios available for the current logistic option.(e.g deliver all the products at the same time is a logistic scenario)
{
"selected": true,
"code": "1_DELIVERY",
"title": "1 DELIVERY",
"description": "choose this scenario if you want all your products to be delivered at the same time",
"cost": {
"amount": 0,
"scale": 2,
"currency": "EUR"
},
"totalPrice": {
"amount": 2300,
"scale": 2,
"currency": "EUR"
},
"totalPriceIncludingSurchargesAndShipping": {
"amount": 1900,
"scale": 2,
"currency": "EUR"
},
"shippingGroups": [
{
"status": "OPENED",
"deliveryDate": "2021-10-12T08:30:22.804Z",
"lineItems": [
{
"quantity": 1,
"lineItemId": "1",
"itemPrice": {
"amount": 1800,
"scale": 2,
"currency": "EUR"
}
}
]
}
]
}
The code of the logistic scenario
"1_DELIVERY"
The title of the logistic scenario to be displayed to the end user.
"1 DELIVERY"
The description of the logistic scenario to display to the end user.
"choose this scenario if you want all your products to be delivered at the same time"
The cost of this logistic scenario
{
"amount": 0,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
Total price of the logistic scenario including promotions, surcharges, shipping cost and taxes (vat)
{
"amount": 0,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
Total price of the logistic scenario including promotions, surcharges, shipping cost without taxes (vat)
{
"amount": 0,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
A list of groups of line items corresponding to the way the order will be fulfilled
No Additional ItemsOrder shipment
The status of the shipment.
"DELIVERED"
Will be true if the delivery date is selected by the customer. It will be false is the date is the one computed by the opco backend system.
[Deprecated - Use instead expectedDeliveryDate and expectedDeliveryTime].
Date on which the shipment expected to be delivered.
"2021-10-12T08:30:22.804Z"
Date on which the shipment expected to be delivered.
"2021-10-12"
Time on which the shipment expected to be delivered
"08:30:22.804Z"
The line items that are shipped.
No Additional ItemsOptional. The line items that are shipped.
a reference to a line item. This field is a 64-bit long number represented as a string to avoid unwanted conversions to scientific notation when dealing with the model inside js code
Must match regular expression:^[0-9]+$
"2196602318024039368"
The quantity that is shipped.
1
This is the line item price that the customer will pay to the OPCO, without taxes, after applying promotion. Equals (unitPrice * quantity) for items without promotion or (discountedUnitPrice * quantity) for items with promotion
{
"amount": 1800,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
[
{
"quantity": 1,
"lineItemId": "1",
"itemPrice": {
"amount": 1800,
"scale": 2,
"currency": "EUR"
}
}
]
Documents references associated with this shipping group
No Additional ItemsInformation identifying a document and potentially a line within the document for referencing purposes.
The type of the document
"INVOICE"
The id of the document
"4999569661752721026"
Date on which the document has been created, in ISO 8601 format.
"2017-07-21T08:30:22.804Z"
[
{
"type": "DELIVERY_NOTES",
"id": "4999569661752721026",
"createdAt": "2017-07-21T17:32:28Z"
}
]
[
{
"status": "OPENED",
"deliveryDate": "2021-10-12T08:30:22.804Z",
"lineItems": [
{
"quantity": 1,
"lineItemId": "1",
"itemPrice": {
"amount": 1800,
"scale": 2,
"currency": "EUR"
}
}
]
}
]
The total amount of all the items of the order after applying promotions, without taxes.
{
"amount": 13800,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
The total price of all items of the order applying promotions, including all taxes.
{
"amount": 17760,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
The total price of all items of the order including promotions and including surcharges.
{
"amount": 17760,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
The total amount of each tax.
No Additional Itemscontains the tax informations with both percentage or exact amount as preferable.
A tax with a fix amount
contains the amount informations based on the type of prices we might have
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
type of tax which is applicable to the underlying product.
"VAT"
This flag determines if the tax is a surcharge to be added to netPrice/promotionalNetPrice before applying Tax. The Tax computation happens on top of ((netPrice or promotionalNetPrice)+surcharges)
true
A tax represented by a percentage.
the percentage of the net price
20.0
type of tax which is applicable to the underlying product.
"VAT"
This flag determines if the tax is a surcharge to be added to netPrice/promotionalNetPrice before applying Tax. The Tax computation happens on top of ((netPrice or promotionalNetPrice)+surcharges)
true
[
{
"type": "VAT",
"isSurcharge": false,
"taxAmount": {
"amount": 320,
"scale": 2,
"currency": "EUR"
}
},
{
"type": "ECOTAXE",
"isSurcharge": true,
"taxAmount": {
"amount": 226,
"scale": 2,
"currency": "EUR"
}
}
]
Documents references associated with the order
No Additional ItemsInformation identifying a document and potentially a line within the document for referencing purposes.
The type of the document
"INVOICE"
The id of the document
"4999569661752721026"
Date on which the document has been created, in ISO 8601 format.
"2017-07-21T08:30:22.804Z"
[
{
"type": "INVOICE",
"id": "4999569661752721026",
"createdAt": "2017-07-21T17:32:28Z"
}
]
The order id generated by the spark plateform.
"4999569661752721026"
tenant identifier for an Opco in SPARK multitenant platform
"BEL-CEBEO"
The Cart or the open order identifier at opco backend system level
"1234"
Optional field, needed by OpCo organised with a regional model or commercial organisation. It can be used to filter or route based on the orgId.
"org123"
"SNE"
The sales channel where the order is placed
"ESHOP"
The global status of the order.
"DELIVERED"
The date when the order was placed
"2021-10-12T08:30:22.804Z"
The date when the order was last modified. This field will be used to ensure that only the latest update are being integrated to order history.
"2021-10-12T08:30:22.804Z"
The opco account id of the customer.
"12345"
The list of users that contribute on the creation if the cart and the order. The creator of the cart, the validator of the cart ...
No Additional Items[
{
"fullName": "John Smith",
"email": "john.smith@mycompany.com",
"creator": true
},
{
"fullName": "John Validator",
"email": "john.validator@mycompany.com"
}
]
The full name of a contributor.
"John Smith"
The email of a contributor. this is the identifier of the user on spark
"john.smith@mycompany.com"
A boolean that when is true means that the current contributor is the creator of the cart from where this order is created.
"false"
A boolean that when is true means that the current contributor is an associate doing the action on behalf of the end user.
"false"
The billing address
{
"opCoAddressId": "13543678",
"addressLine1": "chaussee Verlinden 22",
"addressLine2": "1st floor",
"addressLine3": "Apparment 2",
"postalCode": "0287",
"city": "Bruges",
"region": "Frandre",
"department": "N/A",
"country": "BEL"
}
OpCo internal system's unique identifier for the address.
"237564557868778"
Should contains the Given name, Surname, the name of the company
"235 Donaghy Ave"
Should contains the street No, street name, street type
Should contains the Floor
The postal code
"V7P 1E2"
The city in which the street address is, and which is in the adminDevison(region)
"North Vancouver"
The region in which the locality is, and which is in the country.
"BC"
The department in which the locality is, and which is in the country.
"BC"
The ISO 3166-1 alpha-3 of the country
"CAN"
Line items that are ordered.
Must contain a minimum of 1
items
The order line item
The ID of the line item.
Must match regular expression:^[0-9]+$
"4999569661752721026"
Number of items ordered.
10
Product data as seen by customer from the time of the order placement.
A unique identifier of the product
"9554961192345"
short description of the product
"LIGHT 274498 Metal Halide Lamp"
Brand name
"SASS"
Details of the promotion applied to this line item
{
"title": "Achete 3 articles et 2 gartuit",
"alternateProductId": "767867",
"campaignId": "234"
}
A readable description explaining the promotions eligibility received from opco, Send the title according to chosen language
"achetez 3 articles et obtenez 10% de réduction"
campaign id to which this promotion is associated to relative to the standard product id
"7575785"
the alternate product id (Since promotions in cebeo is handled by maintaining 2 different id for normal and promotional product), might not be required by other opco
"9898989"
Contains the detail of prices related to the current product and line item
This is the product unit price that the customer will pay to the OPCO, without taxes, before applying promotion.
{
"amount": 1000,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
A short title for this price into user language
"contract schneider"
an identifier of the contract related to this price
"7575785"
percentage of discount on net price, If we have this value then promotionalNetPrice is needed also
10.0
Precomputed promotional price on top of netPrice, This is the case when promotional percentage is not present and the promotional price is directly computed and available to show
{
"amount": 200,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
List of taxes to be applied to net price or promotional net price in case of promotion
No Additional Itemscontains the tax informations with both percentage or exact amount as preferable.
A tax with a fix amount
contains the amount informations based on the type of prices we might have
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
type of tax which is applicable to the underlying product.
"VAT"
This flag determines if the tax is a surcharge to be added to netPrice/promotionalNetPrice before applying Tax. The Tax computation happens on top of ((netPrice or promotionalNetPrice)+surcharges)
true
A tax represented by a percentage.
the percentage of the net price
20.0
type of tax which is applicable to the underlying product.
"VAT"
This flag determines if the tax is a surcharge to be added to netPrice/promotionalNetPrice before applying Tax. The Tax computation happens on top of ((netPrice or promotionalNetPrice)+surcharges)
true
[
{
"type": "VAT",
"isSurcharge": false,
"percentage": 20.0
}
]
[
{
"id": "4999569661752721000",
"orderedQuantity": 10,
"product": {
"productId": "4999569661752721000",
"productTitle": "SIEMENS Circuit Breaker",
"brandName": "Siemens"
},
"prices": {
"netPrice": {
"amount": 1000,
"scale": 2,
"currency": "EUR"
},
"promotionalNetPrice": {
"amount": 900,
"scale": 2,
"currency": "EUR"
},
"taxes": [
{
"type": "VAT",
"isSurcharge": false,
"percentage": 20.0
}
]
}
}
]
Payment terms associated with the order
No Additional ItemsTerms and conditions by which a payment has been or will be made.
The payment method type
"CREDIT_LINE"
The transaction payment id
"PAY0001"
The amount of the payment
{
"amount": 1800,
"scale": 2,
"currency": "EUR"
}
the actual unscaled amount based on list or customer
205987
the scale to be applied on the unscaled amount
2
the currency code following the ISO 4217 standard 3 letter in which the prices are being displayed
"EUR"
Date on which the payment transaction has been created
"2017-07-21T08:30:22.804Z"
[
{
"paymentMethod": "CREDIT_LINE",
"amount": {
"amount": 10000,
"scale": 2,
"currency": "EUR"
},
"paymentTransactionId": "12345",
"createdAt": "2017-07-21T17:32:28Z"
}
]
Additional information for the order.
The purchase order.
"XDFG334322"
The cart name.
"Site 1 Cart"
The project associated to the order
The identifier of the project
The name of the project to display to the customer
The quote associated to the order
The identifier of the quote
The name of the Quote
Contact first name for this order. This field is added by the customer to override the same field into delivery address.
"Robert"
Contact last name for this order. This field is added by the customer to override the same field into delivery address.
"Fox"
Contact phone number for this order. This field is added by the customer to override the same field into delivery address.
"+3333333333"
Contact email for this order.
"john.doe@sonepar.com"
Choice of showing or not the price on the logistics note.
false
An optional emails list that will be used as additional recipients to send the confirmation email of the order
No Additional ItemsThe notes related to the order.
No Additional ItemsObject representing a note
Choice of showing or not the note on the invoice.
true
Choice of showing or not the note on the logistics notes.
false
Note added to cart
"Morning delivery preference"
[
{
"noteOnInvoice": true,
"noteOnLogisticsNotes": false,
"noteText": "Morning delivery preference"
}
]
Additional order information filled by the customer when placing the order or added by the OpCo system during the order processing.
No Additional ItemsObject representing an additional reference.
Name of the additional reference
"warehouseName"
Value of the additional reference filled by the customer
"P570629"
[
{
"name": "warehouseName",
"value": "Z.I. Fourviere"
}
]