需求背景:
当前采集组采集的类目数据无法完全保证采集的类目数据的准确性,每次全量采集回来的类目数据都需要花费很大的人力进行比对校验才敢同步到ERP;亚马逊现在存在一份类目树的报告,而报告的数据的下载稳定性相对于采集来说会高一点,且也可以快速进行比对校验。
需求内容:
一、数据中心每周日下载Browse tree report,所有站点每站点下载一份
Browse tree repor报告参考数据:https://developer-docs.amazon.com/sp-api/docs/report-type-values#browse-tree-report
<Node>
<browseNodeId>248878031</browseNodeId>
<browseNodeAttributes count="1">
<attribute name="recommended_browse_nodes">248878031</attribute>
</browseNodeAttributes>
<browseNodeName>Automotive</browseNodeName>
<browseNodeStoreContextName>Automotive</browseNodeStoreContextName>
<browsePathById>248877031,248878031</browsePathById>
<browsePathByName>Automotive</browsePathByName>
<hasChildren>true</hasChildren>
<childNodes count="15">
<id>15594959031</id>
<id>60036031</id>
<id>303891031</id>
<id>3013843031</id>
<id>301308031</id>
<id>301309031</id>
<id>301310031</id>
<id>301311031</id>
<id>301314031</id>
<id>2901363031</id>
<id>301315031</id>
<id>303890031</id>
<id>2486235031</id>
<id>301313031</id>
<id>307675031</id>
</childNodes>
<productTypeDefinitions>AUTO_PART,AUTO_ACCESSORY,AUTO_BATTERY,AUTO_CHEMICAL,AUTO_OIL,CAR_ELECTRONICS,MOTORCYCLE_ACCESSORY,MOTORCYCLE_PART,MOTORCYCLES,POWERSPORTS_PROTECTIVE_GEAR,POWERSPORTS_RIDING_GLOVES,POWERSPORTS_RIDING_HELMET,POWERSPORTS_RIDING_SHOES,TIRE_AND_WHEEL_ASSEMBLIES,TIRES,WHEEL</productTypeDefinitions>
<refinementsInformation count="0"/>
</Node>
1、配置Browse tree report报告下载计划(1H)
2、从采集库拉取Browse tree report到ERP (6H)
3、增量拉取数据中心Browse tree report到ERP; 数据量较大需考虑去重等相关性能,解析、清洗、标记一级类目、标记末级类目、删除 (14)