供应商零售分析报告迁移指南

亚马逊SPAPI

# 综述

本文档解释了对vendor retail analytics reports的修改,并介绍了如何迁移以下报告

  • GET_VENDOR_DEMAND_FORECAST_REPORT (由GET_VENDOR_FORECASTING_REPORT)取代
  • GET_VENDOR_INVENTORY_HEALTH_AND_PLANNING_REPORT (由GET_VENDOR_INVENTORY_REPORT)取代 *GET_VENDOR_SALES_DIAGNOSTIC_REPORT (由GET_VENDOR_SALES_REPORT和GET_VENDOR_TRAFFIC_REPORT)取代

**重要的是:**GET_VENDOR_DEMAND_FORECAST_REPORT、GET_VENDOR_INVENTORY_HEALTH_AND_PLANNING_REPORT和GET_VENDOR_SALES_DIAGNOSTIC_REPORT报告类型将在2022年6月27日被废弃.更多信息,请参阅下面的映射报告类型表.

# 什么是供应商零售分析报告类型?

供应商零售分析报告类型是一组共享供应商业务时间序列数据的报告,包括历史销售、流量、库存和预测指标.

# 新报告和功能

2022年3月推出的新报告类型

  • get_vendor_sales_report
  • get_vendor_traffic_report
  • get_vendor_forecasting_report *获得供应商库存报告

新的报告类型包括以下变化,以改善开发者的体验 *从亚马逊零售类别团队使用的相同来源获取报告的数据

  • 允许集成商在其创建报告请求中指定不同的时间范围聚合
  • 扁平化整个JSON报告结构,以简化解析工作

# 迁移工作流程

使用以下步骤迁移GET_VENDOR_DEMAND_FORECAST_REPORT、GET_VENDOR_INVENTORY_HEALTH_AND_PLANNING_REPORT和GET_VENDOR_SALES_DIAGNOSTIC_REPORT报告类型.

# 步骤1.生成并下载新的报告

1.为四个新的报告(GET_VENDOR_SALES_REPORT, GET_VENDOR_TRAFFIC_REPORT, GET_VENDOR_FORECASTING_REPORT, 和 GET_VENDOR_INVENTORY_REPORT).提交一个createReport请求 2.使用getReport和getReportDocument API操作来下载报告. 3.查看报告的结构和内容.

# 步骤2.修改你的JSON解析器以识别新的报告版本和JSON结构

1.对于每个报告类型,审查报告的JSON结构.

**注意:**新的报告是 "扁平的",这简化了解析.

2.对于每个报告类型,注意报告中的不同数据元素.

# 步骤3.将你的生产管道切换到来自新报告类型的数据源.

1.修改你的createReport请求,使之与新的报告版本参数一致.

**注意:**大多数新的报告需要reportPeriod参数,然而,这个参数在GET_VENDOR_DEMAND_FORECAST_REPORT、GET_VENDOR_INVENTORY_HEALTH_AND_PLANNING_REPORT和GET_VENDOR_SALES_DIAGNOSTIC_REPORT中并不存在

  1. 更新你的createReport请求,使用新的报告类型值(例如,GET_VENDOR_SALES_REPORT).

3.测试你的管道.

# 第4步. (可选)回填历史数据

新报告的数据来源与GET_VENDOR_DEMAND_FORECAST_REPORT、GET_VENDOR_INVENTORY_HEALTH_AND_PLANNING_REPORT和GET_VENDOR_SALES_DIAGNOSTIC_REPORT.亚马逊零售类别团队也使用这个新来源.由于这个来源的变化,你可能想回填历史数据,以确保你没有混合多个来源的数据

# 映射报告类型

| | 旧| | | 新| | | 新 | ----------------------------------- | ----------------------------------------------- | ----------------------- | ------------------- | ----------------------------- | ------------------------------------------------------------ | | 名称 | 报告类型值 | 淘汰日期 | 名称 | 报告类型值 | 备注 | | 销售诊断报告 | GET_VENDOR_SALES_DIAGNOSTIC_REPORT | June 27, 2022年 | 销售报告和流量报告 | GET_VENDOR_SALES_REPORT 和 GET_VENDOR_SALES_TRAFFIC_REPORT | 新报告模仿了2022年晚些时候在Vendor Central推出的仪表板. 销售和流量指标被分割成不同的仪表板,因此被分割成不同的报告. | | | 库存健康和规划报告 | GET_VENDOR_INVENTORY_HEALTH_AND_PLANNING_REPORT | 2022年6月27日 | 库存报告 | GET_VENDOR_INVENTORY_REPORT | | | | 需求预测报告 | GET_VENDOR_DEMAND_FORECAST_REPORT | 2022年6月27日 | 预测报告 | GET_VENDOR_FORECASTING_REPORT | | | 纯净产品利润率报告 | GET_VENDOR_NET_PURE_PRODUCT_MARGIN_REPORT | 将不会被废弃 | | | 该报告使用新的数据源启动. 开发人员不需要从该报告中迁移. |

# 映射数据元素

OldNew
Report Type ValueData ElementReportData Element(s)Notes
GET_VENDOR_SALES_DIAGNOSTIC_REPORTpreOrderedReveuen/an/aDeprecated
GET_VENDOR_SALES_DIAGNOSTIC_REPORTpreOrderedUnitsn/an/aDeprecated
GET_VENDOR_SALES_DIAGNOSTIC_REPORTorderedRevenueGET_VENDOR_SALES_REPORTorderedRevenue
GET_VENDOR_SALES_DIAGNOSTIC_REPORTorderedUnitsGET_VENDOR_SALES_REPORTorderedUnits
GET_VENDOR_SALES_DIAGNOSTIC_REPORTshippedRevenueGET_VENDOR_SALES_REPORTshippedRevenue
GET_VENDOR_SALES_DIAGNOSTIC_REPORTshippedUnitsGET_VENDOR_SALES_REPORTshippedU 但可以计算orderedUnits / glanceViews
GET_VENDOR_SALES_DIAGNOSTIC_REPORTlostBuyBoxn/an/aDeprecated
GET_VENDOR_SALES_DIAGNOSTIC_REPORTcustomerReturnsn/an/aDeprecated
GET_VENDOR_SALES_DIAGNOSTIC_REPORTfreeReplacementsn/an/aDeprecated
GET_VENDOR_SALES_DIAGNOSTIC_REPORTorderedSubcategorySalesRankn/an/aDeprecated
GET_VENDOR_SALES_DIAGNOSTIC_REPORTshippedSubcategorySalesRankn/an/aDeprecated
GET_VENDOR_INVENTORY_HEALTH_AND_PLANNING_REPORTnetReceivedAmountGET_VENDOR_INVENTORY_REPORTnetReceivedAmount
GET_VENDOR_INV 查看 vendorConfirmationRate
GET_VENDOR_INVENTORY_HEALTH_AND_PLANNING_REPORToverallVendorLeadTimeoverallVendorLeadTime
GET_VENDOR_DEMAND_FORECAST_REPORTrelativeWeekGET_VENDOR_FORECASTING_REPORTstartDate 和endDate使用startDate 和endDate来计算相对于forecastGenerationDate
GET_VENDOR_DEMAND_FORECAST_REPORTdemandForecastType 和 demandUnitsGET_VENDOR_FORECASTING_REPORT

meanForecastUnits

p70ForecastUnits

p80ForecastUnits

p90ForecastUnits

# 示例库存报告(old)

get_vendor_inventory_health_and_planning_report 获取供应商库存报告

{
    "reportSummary": {
        "reportingDateRange": {
            " reportingDateFrom": "2021-08-01",
            "ReportingDateTo": "2021-08-01"
        },
        " distributorView": "制造商",
        "currencyCode": "USD"
    },
    "reportDetails": [
        {
            "sellingProgramName": "amazon_retail",
            " inventoryHealthMetricsByProgram": [{
                    "asin": "B123456789",
                    " inventoryHealthMetricsByAsin": [{
                            "ReportingDate": "2021-08-01",
                            " inventoryHealthMetricsByDate": {
                                "netReceivedAmount": {
                                    "金额": 0.00,
                                    "currencyCode": "USD"
                                },
                                "netReceivedUnits": 0,
                                "openPurchaseOrderQuantity": 0,
                                "sellThroughRate": 0.0000,
                                "可出售的手头存货": {
                                    "数额": 0.00,
                                    "currencyCode": "USD"
                                },
                                "sellableOnHandAmountTrailing30DayAverage": {
                                    "数额": 0.00,
                                    "currencyCode": "USD"
                                },
                                "sellableOnHandUnits": 0,
                                "无法出售的手头库存": {
                                    "数额": 0.00,
                                    "currencyCode": "USD"
                                },
                                "unsellableOnHandAmountTrailing30DayAverage": {
                                    "金额": 0.00,
                                    "currencyCode": "USD"
                                },
                                "unsellableOnHandUnits": 0,
                                "old90PlusDaysSellableInventory": {
                                    "数额": 0.00,
                                    "currencyCode": "USD"
                                },
                                "age90PlusDaysSellableAmountTrailing30DayAverage": {
                                    "数额": 0.00,
                                    "currencyCode": "USD"
                                },
                                "age90PlusDaysSellableUnits": 0,
                                "unhealthyInventory": {
                                    "数额": 0.00,
                                    "currencyCode": "USD"
                                },
                                "unhealthyUnitsTrailing30DayAverage": 0.00,
                                "unhealthyUnits": 0,
                                "unfilledCustomerOrderedUnits": 0,
                                "availableUnits": 0,
                                "几周在手": 0,
                                "receiveFillRate": 1.0000,
                                "overallVendorLeadTime": 7.26
                            }
                        }
                    ]
                }, { ... }
            ]
        }
    ]
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

# 示例库存报告 (new)

get_vendor_inventory_report

{
  "reportSpecification": {
    "报告类型": "get_vendor_inventory_report",
    "reportOptions": {
      "reportPeriod": "WEEK",
      "sellingProgram": "RETAIL",
      " distributorView": "制造"
    },
    "dataStartTime": "2022-05-22",
    "dataEndTime": "2022-05-28",
    "marketplaceIds": [
      "atvpdkikx0der"
    ]
  },
  " inventoryAggregate": [
    {
      "startDate": "2022-05-22",
      "endDate": "2022-05-28",
      "vendorConfirmationRate": 0.88,
      "netReceivedAmount": {
        "金额": 2345.50,
        "currencyCode": "USD"
      },
      "netReceivedUnits": 278,
      "openPurchaseOrderQuantity": 123,
      "overallVendorLeadTime": 10.2,
      "sellThroughRate": 0.88,
      "可销售的手头库存": {
        "数额": 43123.99,
        "currencyCode": "USD"
      },
      "sellableOnHandUnits": 5490,
      "unfilledCustomerOrderedUnits": 12,
      "无法出售的手头库存"{
        "金额": 2345.50,
        "currencyCode": "USD"
      },
      "无法出售的手数": 881,
      "老化的90天可销售库存": {
        "金额": 123.50,
        "currencyCode": "USD"
      },
      "age90PlusDaysSellableUnits": 2234,
      "unhealthyInventory": {
        "数额": 123.45,
        "currencyCode": "USD"
      },
      "unhealthyUnits": 114
    },
    { ...
    }
  ],
  " inventoryByAsin": [
    {
      "startDate": "2022-05-22",
      "endDate": "2022-05-28",
      "asin": "B123456789",
      "vendorConfirmationRate": 0.88,
      "netReceivedAmount": {
        "金额": 2345.50,
        "currencyCode": "USD"
      },
      "netReceivedUnits": 278,
      "openPurchaseOrderQuantity": 123,
      "overallVendorLeadTime": 10.2,
      "sellThroughRate": 0.88,
      "可销售的手头库存": {
        "数额": 43123.99,
        "currencyCode": "USD"
      },
      "sellableOnHandUnits": 5490,
      "unfilledCustomerOrderedUnits": 12,
      "无法出售的手头库存"{
        "金额": 2345.50,
        "currencyCode": "USD"
      },
      "无法出售的手数": 881,
      "老化的90天可销售库存": {
        "金额": 123.50,
        "currencyCode": "USD"
      },
      "age90PlusDaysSellableUnits": 2234,
      "unhealthyInventory": {
        "数额": 123.45,
        "currencyCode": "USD"
      },
      "unhealthyUnits": 114
    },
    { ...
    }
  ]
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
Last Updated: 2022/10/20 下午11:58:42