1、项目：Zhcxkj.AutoChoose.Worker，Zhcxkj.Erp.Api，Zhcxkj.AutoChoose.Web，ErpWeb
2、erpdb增加字段，

ALTER TABLE [dbo].[RB_Product_CompeteAsin] ADD [NameCn] varchar(500) NULL
GO

ALTER TABLE [dbo].[RB_Product_CompeteAsin] ADD [Name] varchar(255) NULL
GO

ALTER TABLE [dbo].[RB_Product_CompeteAsin] ADD [ImgUrl] varchar(255) NULL
GO

ALTER TABLE [dbo].[RB_Product_CompeteAsin] ADD [IsRecommend] tinyint NULL
GO

EXEC sp_addextendedproperty
'MS_Description', N'中文标题',
'SCHEMA', N'dbo',
'TABLE', N'RB_Product_CompeteAsin',
'COLUMN', N'NameCn'
GO

EXEC sp_addextendedproperty
'MS_Description', N'标题',
'SCHEMA', N'dbo',
'TABLE', N'RB_Product_CompeteAsin',
'COLUMN', N'Name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'图片',
'SCHEMA', N'dbo',
'TABLE', N'RB_Product_CompeteAsin',
'COLUMN', N'ImgUrl'
GO


EXEC sp_addextendedproperty
'MS_Description', N'是否推荐',
'SCHEMA', N'dbo',
'TABLE', N'RB_Product_CompeteAsin',
'COLUMN', N'IsRecommend'

3、核心代码

4、自测效果

1、测试取的数据，先图搜

db.getCollection("AmzPhotoResult").find({ $and : [{"SelectedStatus" : "Y"}, {"Sku" : "17643072"}] }).sort({
    _id: -1
}).limit(100).skip(0)

2、erp通过接口获取数据，

post：http://autochoose.internal.zhcxkj.com/Keywords/GetAsinList
test
123456

入参
{
  "sku": "17643072",
  "nameCn": "女士背包",
  "top": 10
}

出参
{
  "data": [
    {
      "Asin": "B000LGKP8K",
      "Name": "Advantus Neck Lanyard with Clip for Badges",
      "NameCn": "Advantus 颈挂带，带徽章夹",
      "ImgUrl": "https://m.media-amazon.com/images/I/61c5gsXFwqL.jpg"
    },
    {
      "Asin": "B07L2DG8W5",
      "Name": "Hair Tinsel Kit with Tool 12 Colors 3000 Strands Hair Tinsel Kit Shiny Fairy Hair Tinsel Extensions Colord Party Highlights Glitter Hair Extensions Multi-Colors Hair Tinsel Kit (12 Colors, 45")",
      "NameCn": null,
      "ImgUrl": "https://m.media-amazon.com/images/I/81JlqpPgXRL.jpg"
    },
    {
      "Asin": "B07Q3CBLS4",
      "Name": "UPTOUP 46 inch Hair Tinsel Kit with Tools 12 Colors 2000 Strands Glitter Sparkling Shiny Hair Extensions Silk Fairy (12 colors)",
      "NameCn": "UPTOUP 46 英寸发丝套件带工具 12 种颜色 2000 股闪光闪闪发亮的接发丝绸仙女（12 种颜色）",
      "ImgUrl": "https://m.media-amazon.com/images/I/811ySriYv8L.jpg"
    },
    {
      "Asin": "B0885VQH4R",
      "Name": "19.7 Inch Clip In Hair Fairy Tinsel Kit Clips Clip On Glitter Hair Tinsel Extensions 12 Colors",
      "NameCn": "19.7 英寸夹式发仙金属丝套件夹夹闪光头发金属丝接发 12 色",
      "ImgUrl": "https://m.media-amazon.com/images/I/9189wur4U-L.jpg"
    },
    {
      "Asin": "B08LGSMKSR",
      "Name": "Hair Tinsel Kit 12 Colors, 2500 Strands 48 Inches Sparkling Tinsel Hair Extensions with Tool, Fairy Hair Tinsel for Birthday Halloween Christmas New Year Party",
      "NameCn": "金属丝发片套件 12 种颜色，2500 股 48 英寸闪亮金属丝接发带工具，仙女发丝金属丝，适合生日万圣节圣诞节新年派对",
      "ImgUrl": "https://m.media-amazon.com/images/I/81usyhHD8ZL.jpg"
    },
    {
      "Asin": "B09PVF92RW",
      "Name": "Hair Tinsel kit Fairy Hair Tinsel Kit 47 Inch Hair Extensions Hair Tinsel Kit Strands with Tool 12 Colors 2280 Strands Sparkling Glitter Fairy Hair Tinsel (12 Colors)",
      "NameCn": "头发金属丝套件 仙女头发金属丝套件 47 英寸接发头发金属丝套件 带工具的发丝 12 种颜色 2280 股闪闪发光的仙女发丝（12 种颜色）",
      "ImgUrl": "https://m.media-amazon.com/images/I/81EgJqkF4RL.jpg"
    },
    {
      "Asin": "B0B7DJJ1DR",
      "Name": "Hair Tinsel Kit 18 Colors, 3600 Strands 48 Inches Fairy Hair, Sparkling Hair Tensile for Christmas New Year Halloween Cosplay Party, Tinsel Hair Extensions with Tool",
      "NameCn": "金属丝头发套件 18 种颜色，3600 股 48 英寸仙女头发，闪闪发光的头发张力，适合圣诞节新年万圣节角色扮演派对，金属丝接发带工具",
      "ImgUrl": "https://m.media-amazon.com/images/I/91wkzxvSyIL.jpg"
    },
    {
      "Asin": "B08L4JJ17G",
      "Name": "Laptop Backpack for Women, BAGSMART Travel Backpacks 15.6 Inch Notebook Doctor Back pack for School College Work Business Trip (black)",
      "NameCn": "女士笔记本电脑背包，BAGSMART旅行背包15.6英寸笔记本医生背包学校大学工作商务旅行 (黑色)",
      "ImgUrl": "https://m.media-amazon.com/images/I/41cRrxmt93S.jpg"
    },
    {
      "Asin": "B094JG3Z34",
      "Name": "Backpack for Women LIGHT FLIGHT Laptop Backpacks Fits 15.6’’ Computer Travel School College Work Professional Bags Stylish Stitch Pattern Daypack Pink",
      "NameCn": "女式背包轻型飞行笔记本背包适合15.6英寸电脑旅行学校大学工作专业包时尚针脚图案背包粉色",
      "ImgUrl": "https://m.media-amazon.com/images/I/514FDkCOtgS.jpg"
    },
    {
      "Asin": "B07D71LF24",
      "Name": "UTO Women Backpack Purse PU Washed Leather Convertible Ladies Rucksack Tassel Zipper Pocket Shoulder Bag A Brown",
      "NameCn": null,
      "ImgUrl": "https://m.media-amazon.com/images/I/517zdGp+uyL.jpg"
    }
  ],
  "status": "success",
  "message": "成功"
}

3、图搜不足，以标题中文拓词补充到10个

4、图搜取sku，全部改到当前查询条件“非组合SKU状态为‘初级品’竞品ASIN”，这一点是和产品口头上确定的