任务描述
暂无
需求描述

背景

虎鲸即时销量数据及时性较差,核心字段统计不严谨,数据不准确

需求
销量分析需ERP提供订单增量接口:
入参:customerId-商户号,orderSourceId-渠道ID(可选), lastUpdateTime最近更新时间
出参:排除大字段(Title,PromotionIds, GiftMessageText,PriceDesignation,CustomizedURLDesignation,CustomizedURLDesignationAgain,InvoiceDataContent,ConditionNote)

验收标准
暂无
历史记录  
  1. 2023-02-21 09:34:42, 由 刘超 创建。
  2. 2023-02-21 14:35:57, 由 刘超 启动。
    修改了 实际开始,旧值为 "0000-00-00 00:00:00",新值为 "2023-02-21 14:35:47"。
    修改了 任务状态,旧值为 "wait",新值为 "doing"。

    1. 查询时间不能超过7天

  3. 2023-02-21 14:38:14, 由 刘超 添加备注。

    2. 查询时间范围内有数据

  4. 2023-02-28 14:03:31, 由 刘超 添加备注。

    3. 接口返参解密显示

  5. 2023-02-28 14:04:14, 由 刘超 添加备注。

    入参:http://sale-prev.zhcxkj.com/webapi/Order/Order/GetAmazonPlatformOrdersPager

    {
        "customerId": 1,
        "startTime": "2023-02-13",
        "endTime": "2023-02-20",
        "ordersourceIds":[5046],
        "current": 1,
        "pageSize": 200
    }
    返参:

    {
        "data": {
            "orders": [
                {
                    "Id": 25086963,
                    "CustomerID": 1,
                    "OrderSourceID": 5046,
                    "AmazonOrderID": "200-9956325-5520399",
                    "SellerOrderId": null,
                    "PurchaseDate": "2023-02-16T05:00:00",
                    "LastUpdateDate": "2023-02-16T05:00:00",
                    "OrderStatus": "Shipped",
                    "FulfillmentChannel": "MFN",
                    "SalesChannel": "Amazon.com",
                    "OrderChannel": null,
                    "ShipServiceLevel": "Expedited2",
                    "AddressName": "Sachin Shokeen",
                    "AddressLine1": "41 Foxall Street",
                    "AddressLine2": "",
                    "AddressLine3": "",
                    "AddressCity": "RIVERSTONE",
                    "AddressCounty": "",
                    "AddressDistrict": null,
                    "StateOrRegion": "NSW",
                    "PostalCode": "2765",
                    "CountryCode": "US",
                    "Phone": "0416400705",
                    "OrderTotalCurrencyCode": "USD",
                    "OrderTotalAmount": 155.1800,
                    "NumberOfItemsShipped": 0,
                    "NumberOfItemsUnshipped": 1,
                    "PaymentExecutionDetailContent": null,
                    "PaymentMethod": "Other",
                    "MarketplaceId": "ATVPDKIKX0DER",
                    "BuyerEmail": "64568974@qq.com",
                    "BuyerName": "test",
                    "ShipmentServiceLevelCategory": "Expedited",
                    "ShippedByAmazonTFM": null,
                    "TFMShipmentStatus": null,
                    "CbaDisplayableShippingLabel": null,
                    "OrderType": "StandardOrder",
                    "EarliestShipDate": "2023-02-16T05:00:00",
                    "LatestShipDate": "2023-02-16T05:00:00",
                    "EarliestDeliveryDate": "2023-02-16T05:00:00",
                    "LatestDeliveryDate": "2023-02-16T05:00:00",
                    "IsBusinessOrder": false,
                    "PaymentMethodDetails": "Amazon-ExpressOrder",
                    "BuyerTaxInfos": "",
                    "IsProcess": true,
                    "ProcessTime": null,
                    "LastModificationTimeTimestamp": 1655171733262,
                    "IsSoldByAB": false,
                    "CheckStatusTime": null,
                    "ReplacedOrderId": null,
                    "CreatorId": 0,
                    "Creator": "sys",
                    "CreationTime": "2023-02-16T05:00:00",
                    "LastModifierId": null,
                    "LastModifier": null,
                    "LastModificationTime": "2023-02-17T16:32:56",
                    "AmazonOrderProductList": [
                        {
                            "Id": 25376145,
                            "CustomerID": 1,
                            "OrderSourceID": 5046,
                            "AmazonOrderID": "200-9956325-5520399",
                            "ASIN": "B09TK8HWYF2",
                            "SellerSKU": "YFGP49QDCV0OE1090DGCQW3",
                            "OrderItemId": "49230967025306",
                            "QuantityOrdered": 2,
                            "QuantityShipped": 0,
                            "ItemPriceCurrencyCode": "AUD",
                            "ItemPriceAmount": 55.9800,
                            "ShippingPriceCurrencyCode": null,
                            "ShippingPriceAmount": null,
                            "GiftWrapPriceCurrencyCode": null,
                            "GiftWrapPriceAmount": null,
                            "ItemTaxCurrencyCode": "AUD",
                            "ItemTaxAmount": 3.5000,
                            "ShippingTaxCurrencyCode": null,
                            "ShippingTaxAmount": null,
                            "GiftWrapTaxCurrencyCode": null,
                            "GiftWrapTaxAmount": null,
                            "ShippingDiscountCurrencyCode": null,
                            "ShippingDiscountAmount": null,
                            "PromotionDiscountCurrencyCode": "AUD",
                            "PromotionDiscountAmount": 0.0000,
                            "PromotionIds": null,
                            "CODFeeCurrencyCode": null,
                            "CODFeeAmount": null,
                            "CODFeeDiscountCurrencyCode": null,
                            "CODFeeDiscountAmount": null,
                            "GiftWrapLevel": null,
                            "ConditionId": "New",
                            "ConditionSubtypeId": "New",
                            "ScheduledDeliveryStartDate": null,
                            "ScheduledDeliveryEndDate": null,
                            "IossNumber": null,
                            "TaxFlag": null,
                            "IsBuyerRequestedCancel": false,
                            "BuyerCancelReason": "ITEMs_wOuLD_ARRIVE_TOO_LATEREASON_LEFT_UNSPECIFIED",
                            "CreatorId": 0,
                            "Creator": "sys",
                            "CreationTime": "2022-06-14T09:55:33",
                            "LastModifierId": null,
                            "LastModifier": null,
                            "LastModificationTime": null
                        }
                    ]
                }
            ]
        },
        "status": "success",
        "message": null
    }

  6. 2023-02-28 14:06:01, 由 刘超 完成。
    修改了 总计消耗,旧值为 "0",新值为 "0.001"。
    修改了 实际完成,旧值为 "",新值为 "2023-02-28 14:05:58"。
    修改了 任务状态,旧值为 "doing",新值为 "done"。
    修改了 预计剩余,旧值为 "0.001",新值为 "0"。
    修改了 由谁完成,旧值为 "",新值为 "liuchao"。
  7. 2023-03-08 09:41:08, 由 刘超 关闭。
    修改了 任务状态,旧值为 "done",新值为 "closed"。
    修改了 指派给 ,旧值为 "liuchao",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "liuchao"。
    修改了 关闭时间,旧值为 "0000-00-00 00:00:00",新值为 "2023-03-08 09:41:08"。
    修改了 关闭原因,旧值为 "",新值为 "done"。
所属迭代 技术研发中心 2月分支版本(2023年)
所属模块 /
相关需求 提供订单信息查询接口,供虎鲸模块使用
指派给 Closed 于 2023-03-08 09:41:08
任务类型 测试
任务标签 初始
开发组
任务状态 已关闭
进度 100%
优先级 P2
关键词
抄送给
由谁创建 刘超 于 2023-02-21 09:34:42
由谁完成 刘超 于 2023-02-28 14:05:58
由谁取消 暂无
由谁关闭 刘超 于 2023-03-08 09:41:08
关闭原因 已完成
最后编辑 刘超 于 2023-03-08 09:41:08
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 0.001工时
总计消耗 0工时
预计剩余 0工时
预计开始 0000-00-00
实际开始 2023-02-21
截止日期 0000-00-00