任务描述
SELECT DISTINCT
asin,
msku
FROM
t_amazon_listing_N tN
INNER JOIN (
SELECT DISTINCT
( id )
FROM
t_amazon_listing_N
WHERE
browse_path_by_id_crc IS NOT NULL
AND browse_path_by_id_crc != N
AND browse_path_by_id_crc = ( SELECT browse_path_by_id_crc FROM t_amazon_listing_N WHERE source_id = N AND msku = N )
AND browse_path_by_id = ( SELECT browse_path_by_id FROM t_amazon_listing_N WHERE source_id = N AND msku = N )
) tN ON tN.id = tN.id
WHERE
tN.is_deleted = N
AND tN.source_id = N
AND tN.STATUS = N
AND tN.asin IS NOT NULL
AND tN.asin != N
AND tN.listing_method IN ( N, N, N )
AND tN.quality >= N
AND tN.quality <= N
AND tN.asin NOT IN ( N )
ORDER BY
tN.is_a_plus_attract,
需求描述
1.erp转fba listing同步listing管理V2数据源切换
2.对外查询listing接口新增 节日标签 数据
3.批量修改图片 调整
4.系统优化
验收标准
暂无