Order query api
Advertisers need to provide the Domai channel orders to the Domai League inquiries, and the Domai Alliance will regularly read the interface synchronous order data.
Api Description
- Support time granular query is second
- Support order update time dimension query and sorting
- Please contact Duori technicians for a whitelist IP
- Can be added to verify, and the advertisers provide a key (requiring interface signature documents)
Default query frequency
Adjustable frequency on request
- Query the data of the previous 5 minutes every 3 minutes
- Query the data of the previous 1 hour every 1 hour
- Inquiries 1 day before 1 day before 15 days of data
Api example
Advertisers can refer to the following examples to provide interfaces. If there is an interface and format, the interface document needs to be provided to Domai
https://www.yourdomain.com/cps/orders?union=duomai&stime=1373414581&etime=1373415181
Parameter | Parameter value Example | Parameter Type | Parameter Description |
---|---|---|---|
union | duomai | string | Which CPS league order is distinguished, and the UNION parameter value of the interface interface |
stime | 1373414581 | Timestamp | Query the start time of order data(2013-07-10 08:03:10),It is recommended to use order update time |
etime | 1373415181 | Timestamp | Query the end time of order data(2013-07-10 08:13:10),It is recommended to use order update time |
sn | 201303031111 | string | Order number |
Api return format example
Meaning | Corresponding parameters (distinguished or lowercase) | Required | Type | Exemplary | Detailed explanation |
---|---|---|---|---|---|
The label of the website transmitted by the access interface | euid | yes | string | 100261230dGVzdA0 | EUID parameter value passed in the access interface |
Advertiser ID of the website owner of the access interface | mid | no | string | 10026 | The MID parameter value of the access interface |
Order number | order_sn | yes | string | 2013060412779 | |
Sub order number | suborder_sn | no | string | 050601 | |
Order time | order_time | yes | datetime | 2013-06-04 12:05:00 | The time when users place orders on your website |
Click time | click_time | no | datetime | 2013-06-04 11:23:00 | The time when the user enters the access interface |
Order amount | orders_price | yes | float | 200.00 | The amount paid by the user (the amount of the amount that does not calculate the commissions such as the use of the coupon/cash coupon/cash ticket fee), please do not use the 19,999 statement |
Order status | order_status | yes | string | For example: effective, invalid, unpaid, payment, delivery, etc. | Description of order status of the merchant system |
Order channel | channel | no | int | 1 | 0 means the PC side, 1 indicates the WAP side, 3 means ROI orders, other values to be expanded, or the merchant can decide on its own |
Whether it is a new customer | is_new_custom | no | string | 1 | new customer:1 Non-new customers:0 |
Source link | referer | no | string | http://c.duomai.com/track.php?sid=10010&aid=123&euid=&t=http://www.yourdomain.com/ | Jump to the traffic source URL of the access interface |
Currency code | currency | Mandatory when non-RMB | string | CNY | For standard currency codes see:http://zh.wikipedia.org/zh/ISO_4217 |
Time zone code | timezone | Mandatory when not in Beijing time | string | UTC+8 | For standard time zone codes see: http://zh.wikipedia.org/zh/%E6%97%B6%E5%8C%BA%E5%88%97%E8%A1%A8 |
Whether to test data | test | no | int | 1 or 0 | When passing test=1, a detailed push report will be fed back after the request, and the data will be sent to the test order database of the Duomai cps alliance, but the data will not be returned to the official order database |
Product Number | goods_id | yes | string | 87154715 | Product SKUid |
Product Name | goods_name | yes | string | Balenciaga Women's Pre-Loved Black Calfskin Neoclassic Min | |
Product quantity | goods_ta | yes | int | 2 | |
Product Unit Price | goods_price | yes | int | 110 | |
Product Total price (net amount) | totalPrice | yes | int | 200 | The total price actually paid for the current product, coupons, shipping fees and other amounts need to be removed. This product has a discount of 20 yuan, then this value is 110*2-20=200 |
Product commission amount | commission | yes | float | 24.00 | commission on merchandise |
Product commission ratio | rate | yes | float | 0.12 | The ratio of commodity commission to commodity amount |
Product commission category | commission_type | no | string | A | Classification of commissions stipulated in the contract between the two parties |
Product classification number | goods_cate | yes | string | 104 | |
Product classification name | goods_cate_name | yes | string | clothing | |
Product detail | details | no | array | When there are multiple commodities, you can put commodity data in this field, and a single data object contains information such as the above commodity fields goodsid, goodsname, ......, goods_cate_name, etc. |