需求背景:排查刊登错误数据时发现亚马逊会通过一个错误提醒刊登类目不准确,核查确实存在类目错误的情况,需要导出这份数据,让上架部进行校验,并用于后续的多站点映射数据
需求实现:
1.遍历所有末节点,获取模版信息中的product_type保存到一个临时表
2.导出近3个月errorcode包含18367的数据,从错误msg里面解析出建议的product_type(标红部分),并通过product_type反查出该站点的有效类目(必须是末节点,如果有多个取第一个)
【Warning】Having the most applicable product type for a product enhances both the seller and customer experiences; therefore, we have amended the product_type of your submission from DECORATIVE_CUTOUT to COSTUME_EYEWEAR. To remove the warning attached to your product, simply accept our suggested Product Type and resubmit the SKU. Alternatively, if the original Product Type you selected is correct, you may change the SKU attributes, such as title, product description, and bullet points, so that your product more clearly matches that original Product Type. If you feel both the Product Type you had selected and the original SKU attributes are correct, please contact seller support.. To remove the warning attached to your product, simply accept our suggested product type and resubmit the SKU. Alternatively, if the original product type you selected is correct, you can change the SKU attributes such as title, product description and bullet points, so that your product matches the original product type more closely. If you feel both the product type you had selected and the original SKU attributes are correct, please contact Seller Support/Selling Partner Support.
3.通过刊登SKU获取主类目,再获取多站点的映射类目
4.最终数据按照主类目+站点维度去重,导出数据,导出字段包括:主类目、站点、映射类目全路径、映射类目ID全路径、亚马逊推荐类目全路径,亚马逊推荐类目ID全路径

