Accounting Integration ( filterWithDateValidationConstraint )

Withdrawal of Accounting Records

You can fetch daily accounting records of your orders that occur in Trendyol system through integration with this service.

NOT: You can use this service just to follow your daily records through. You can make your reconciliation transactions from your Trendyol Seller Center.

NOTE 1: Start and end date should not be more than 15 days.

NOTE 2: transactionId refers to id value of accounting record. In that value, you can keep your accounting records as unique.

  • GET filterWithDateValidationConstraint

https://api.trendyol.com/sapigw/suppliers/{supplierId}/settlements?dateType={dateType}&endDate={endDate}&startDate={startDate}/

Parameter Parameter Value Definition Type Mandatory
barcode Used for based on barcode filtering. long No
dateType Order - Period - Delivery - Process The date range will be filtered according to the entered value. long Yes
startDate Returns orders after a certain date. It should be sent as Timestamp. int Yes
endDate Returns orders after a certain date. It should be sent as Timestamp. int Yes
page Returns information on specifed page only. int No
size Maximum 200 Specifies the maximum amount to list on a page. int No
supplierId The relevant supplier ID should be sent. long Yes
orderNumber Only by giving a specific order number, it returns that order's information. string Yes
shipmentPackageIds Shipment Packages Id It can request with package numbers. long No
transactionTypeName Sale - Return - Cancel - Discount - DiscountCancel - Coupon - CouponCancel It is an accounting record type. string No

Example of Service Response

{
    "totalElements": 1340,
    "totalPages": 268,
    "page": 0,
    "size": 5,
    "content": [
        {
            "settlementItems": [
                {
                    "transactionId": 3347473,
                    "productName": "Trendyol Milla T-shirt",
                    "barcode": "99999999",
                    "orderNumber": "218652221",
                    "price": 177.9,
                    "currencyCode": "TRY",
                    "settlementItemStatusName": "Paid",
                    "transactionTypeName": "Sale",
                    "operationDate": 1557469159834,
                    "commission": 44.475,
                    "commissionRate": 25,
                    "supplierRevenue": 133.425,
                    "supplierId": 1918,
                    "supplierName": "Mağaza Adı",
                    "currentAccountName": "Mağaza Cari Adı Ltd. Şti",
                    "paymentPeriod": 45,
                    "orderDate": 1557469156433,
                    "firstName": "Otomasyon",
                    "lastName": "Adressapi"
                },
                {
                    "transactionId": 3347474,
                    "productName": "Trendyol Milla T-shirt",
                    "barcode": "99999999",
                    "orderNumber": "218652221",
                    "price": 177.9,
                    "currencyCode": "TRY",
                    "settlementItemStatusName": "UnPaid",
                    "transactionTypeName": "Return",
                    "operationDate": 1557469159878,
                    "commission": 44.475,
                    "commissionRate": 25,
                    "supplierRevenue": 133.425,
                    "supplierId": {supplierId},
                    "supplierName": "Mağaza Adı",
                    "currentAccountName": "Mağaza Cari Adı Ltd. Şti",
                    "paymentPeriod": 45,
                    "orderDate": 1557469156433,
                    "firstName": "Trendyol",
                    "lastName": "Müşterisi"
                },
                {
                    "transactionId": 3347475,
                    "productName": "Trendyol Milla T-shirt",
                    "barcode": "99999999",
                    "orderNumber": "218652221",
                    "price": 177.9,
                    "currencyCode": "TRY",
                    "settlementItemStatusName": "UnPaid",
                    "transactionTypeName": "Cancel",
                    "operationDate": 1557469160062,
                    "commission": 44.475,
                    "commissionRate": 25,
                    "supplierRevenue": 133.425,
                    "supplierId": {supplierId},
                    "supplierName": "Mağaza Adı",
                    "currentAccountName": "Mağaza Cari Adı Ltd. Şti",
                    "paymentPeriod": 45,
                    "orderDate": 1557469156433,
                    "firstName": "Trendyol",
                    "lastName": "Müşterisi"
                },
                {
                    "transactionId": 3347477,
                    "shipmentPackageId": 4685454,
                    "productName": "Trendyol Milla T-shirt",
                    "barcode": "99999999",
                    "orderNumber": "218652226",
                    "price": 23.9,
                    "currencyCode": "TRY",
                    "settlementItemStatusName": "UnPaid",
                    "transactionTypeName": "Sale",
                    "operationDate": 1557469982350,
                    "commission": 5.975,
                    "commissionRate": 25,
                    "supplierRevenue": 17.924999999999997,
                    "supplierId": {supplierId},
                    "supplierName": "Mağaza Adı",
                    "currentAccountName": "Mağaza Cari Adı Ltd. Şti",
                    "paymentPeriod": 45,
                    "orderDate": 1557469977187,
                    "firstName": "Trendyol",
                    "lastName": "Müşterisi"
                },
                {
                    "transactionId": 3347478,
                    "shipmentPackageId": 4685456,
                    "productName": "Trendyol Milla T-shirt",
                    "barcode": "99999999",
                    "deliveryDate": 1557470500966,
                    "orderNumber": "218652227",
                    "price": 29.9,
                    "currencyCode": "TRY",
                    "settlementItemStatusName": "UnPaid",
                    "transactionTypeName": "Sale",
                    "operationDate": 1557470500966,
                    "commission": 7.475,
                    "commissionRate": 25,
                    "supplierRevenue": 22.424999999999997,
                    "supplierId": {supplierId},
                    "supplierName": "Mağaza Adı",
                    "currentAccountName": "Mağaza Cari Adı Ltd. Şti",
                    "paymentPeriod": 45,
                    "dueDate": 1561358500966,
                    "orderDate": 1557470466343,
                    "firstName": "Trendyol",
                    "lastName": "Müşterisi"
                }
            ]
        }
    ] 
}