Orders from BOP integration

!! This is a non committed draft !!

This solution will go live in sandbox mode end of november 2025, and live in april 2026

This solution will replace the current solution for recieving orderdata from Bogportalen.

This solution is intended for non DBK expeditions and publishers to recieve orders from Bogportalen for their products, This solution is mainly optimized for publishers and expeditions that are having a large volume of orders from Bogportalen.

For publishers and expeditions with a lower order volume, the email order integration is recommended.

1. Overview

Purpose: Access order data from Bogportalen for non DBK publishers and expeditions.

Use cases covered: Retrieving orders from Bogportalen

2) Technical overview

Architecture diagram (optional) showing:
- Your platform → FTP server → customer system
Data flow in the order pipeline (how orders are generated, delivered, retrieved)

3) FTP Server details

Server address (host): TBA
Protocol: SFTP
Port number: TBA
Authentication method: username/password
Directory structure
- /orders/ for order retrieval
File naming conventions
- e.g., order_<ordernumber>_<timestamp>.xml

4) XML Format Specification

Reference to XSD file or documentation of the XML schema

Explanation of key fields:

Id: Order ID from Bogportalen
CompletedDate: Order date
TotalPrice: Order price, based on Bogportalen price engine rules. Including 25% VAT
Reference: Reference on the order
DeliveryName: Name of the bookstore that needs the order
DeliveryAddress: Delivery address for the order
DeliveryCity: Cityname for the order address
DeliveryZip: Zipcode for the order address
DeliveryCountryCode: Countro code for the address
DeliveryEmail: Email on the ordering bookstore
ProductEan:<to be added to the examle>: EAN code on the product
Quantity: Quantity on the order of the product
UnitPrice: Unit price, excluding VAT
DiscountPercentage: Discount percentage based on price engine rules for the order
Total price: Total price for the order line, including discount, excluding VAT

filename.xml

<SalesOrderBatch xmlns:json="http://bizbrains.com/json" xmlns="Bizbrains.Link.Initialize.InitializeSteps.Json" json:array="true">
    <Id>ORDER2797_3</ Id>
    <Type>Daglig ordre</Type>
    <CustomerNumber>170368</CustomerNumber>
    <CompletedDate>20240301</CompletedDate>
    <CurrencyCode>DKK</CurrencyCode>
    <ShippingMethodCode>FREE</ShippingMethodCode>
    <ShippingFee json:type="float">0</ShippingFee>
    <TotalPrice json:type="float">682.41</TotalPrice>
    <Reference>Daglig ordre DeliveryCompany</Reference>
    <OrderingUserDwId json:type="integer">97174</OrderingUserDwId>
    <OrderingUsername>SharedUser1050</OrderingUsername>
    <ImeprsonatedUserDwId json:type="integer">97186</ImeprsonatedUserDwId>
    <ImpersonatedUsername>Amager bogogide</ImpersonatedUsername>
    <CustomerName>Shared user for customer number 1050</CustomerName>
    <CustomerAddress/>
    <CustomerAddress2/>
    <CustomerCity/>
    <CustomerRegion/>
    <CustomerZip/>
    <CustomerCountryCode>DNK</CustomerCountryCode>
    <CustomerEmail>NA</CustomerEmail>
    <CustomerPhone/>
    <CustomerCompany/>
    <DeliveryName>DeliveryName</DeliveryName>
    <DeliveryAddress>Amager Centret 103</DeliveryAddress>
    <DeliveryAddress2/>
    <DeliveryCity>København S</DeliveryCity>
    <DeliveryZip>2300</DeliveryZip>
    <DeliveryCountryCode>DNK</DeliveryCountryCode>
    <DeliveryEmail>email@tst.xxx</DeliveryEmail>
    <DeliveryPhone/>
    <DeliveryCompany/>
    <SelfBillingRisc json:type="boolean">True</SelfBillingRisc>
    <ShippingTransportCode>FLEKS-796</ShippingTransportCode>
    <OrderLines json:array="true">
        <Id>OL85686</Id>
        <ProductNumber>123115</ProductNumber>
        <Quantity json:type="float">3</Quantity>
        <UnitPrice json:type="float">181.97</UnitPrice>
        <DiscountPercentage json:type="float">35</DiscountPercentage>
        <TotalPrice json:type="float">545.91</TotalPrice>
        <InvOwner>170368</InvOwner>
        <CustPaymTermId>10</CustPaymTermId>
    </OrderLines>
</SalesOrderBatch>

5) Sample files