Bestellungen auslesen¶

Felder¶

Feld	Beschreibung	Beispiel
erpID
erpName
erpNumber
erpLastUpdate		2018-03-01T05:59:03
erpCreation		0000-01-01T00:00:00
archived		0
oid		1044
orderDate		2018-03-01T05:59:03
orderState		57
orderLastStatusChange		2018-03-01T05:59:03
customerUID		48
customerNotice
deliveryAddressAID		43
deliveryNotice
deliveryName1
deliveryName2
deliveryAddress1
deliveryAddress2
deliveryZipcode
deliveryCity
deliveryCountry
billingAddressAID		43
billingName1
billingAddress1
billingAddress2
billingZipcode
billingCity
billingCountry
assigndTickets
resubmissionDate		0000-01-01T00:00:00
resubmissionInfo
acquisitionPartnerID
acquisitionInfo
acquisitionRedirect
acquisitionDate		0000-01-01T00:00:00
shippingNotice
retoureRID		0
companySHID		1
salesmanUID		0
channelOrderID	Bestellnummer bei einem anderen Anbieter , zum Beispiel Amazon
channelOrderState	Status der Bestellung bei dem Anbieter , exportiert / nicht exportiert
channelOrderDate	Datum wann die Channel Bestellung importiert wurde
channelOrderData	Original Daten vor dem Importieren der Channel Bestellung

Bestellung suchen¶

Über die URL /api/commerce/orders/search?q=[QUERY] können Bestellungen gesucht werden. mit dem Pagestepper kann durch die Daten navigiert werden.

Beispiel : /api/commerce/orders/search?q=order.customerUID%3D48&orderby=oid%20DESC&count=2

{
    "dataset": {
        "1044": {
            "erpID": "",
            "erpName": "",
            "erpNumber": "",
            "erpLastUpdate": "2018-03-01T05:59:03",
            "erpCreation": "0000-01-01T00:00:00",
            "archived": "0",
            "oid": 1044,
            "orderDate": "2018-03-01T05:59:03",
            "orderState": 57,
            "orderLastStatusChange": "2018-03-01T05:59:03",
            "customerUID": 48,
            "customerNotice": "",
            "deliveryAddressAID": 43,
            "deliveryNotice": "",
            "deliveryName1": "",
            "deliveryName2": "",
            "deliveryAddress1": "",
            "deliveryAddress2": "",
            "deliveryZipcode": "",
            "deliveryCity": "",
            "deliveryCountry": "",
            "billingAddressAID": 43,
            "billingName1": "",
            "billingAddress1": "",
            "billingAddress2": "",
            "billingZipcode": "",
            "billingCity": "",
            "billingCountry": "",
            "assigndTickets": "",
            "resubmissionDate": "0000-01-01T00:00:00",
            "resubmissionInfo": "",
            "acquisitionPartnerID": 0,
            "acquisitionInfo": "",
            "acquisitionRedirect": null,
            "acquisitionDate": "0000-01-01T00:00:00",
            "shippingNotice": "",
            "retoureRID": 0,
            "companySHID": 1,
            "salesmanUID": 0,
            "channelOrderID": "xxx-xxxx-xxxxx",
            "channelOrderState": "0",
            "channelOrderDate": "0000-01-01T00:00:00",
            "channelOrderData": {
                "positions": []
            }
        }
    },
    "sys": {
        "pagination": {
            "offset": 0,
            "objectsPerPage": 2,
            "total": 1
        },
        "message": "200 OK",
        "code": 200
    }
}