一手商城需求管理 » 一手商城后台优化

<p>由于是需要和华为那边对接，数据上报是否准确需要和华为的算法工程师磨合，所以，本需求不需要经过测试<br />
对接时有任何问题，都可以找阿童木协调<br />
接口119.8.10.165:6447/recommend/datacollection/import/iteminfo</p>

<p>取数逻辑（供参考）<br />
&nbsp;</p>

<p>SELECT</p>

<p>gs.sku as sku_id</p>

<p>,CONCAT(gs.goods_no,&#39;_&#39;,gs.sku) as goods_id</p>

<p>,gs.goods_no as spu_id</p>

<p>,gs.co_id as color_id</p>

<p>,gs.co_val as color</p>

<p>,gs.si_id as size_id</p>

<p>,gs.si_val as size</p>

<p>,gl.goods_name as spu_name</p>

<p>,CONCAT(gs.co_val,&#39;_&#39;,gs.si_val)&nbsp; as sku_name</p>

<p>,CONCAT(gs.co_val,&#39;_&#39;,gs.si_val)&nbsp; as goods_name</p>

<p>,gs.sale_stock as goods_stock</p>

<p>-- 价格类型</p>

<p>,gl.cat_id as min_class_id</p>

<p>,c.third_cat_name as min_class</p>

<p>,c.primary_cat_id as first_class_id</p>

<p>,c.primary_cat_name&nbsp; as first_class</p>

<p>,c.second_cat_id as second_class_id</p>

<p>,c.second_cat_name&nbsp; as second_class</p>

<p>,c.third_cat_id as third_class_id</p>

<p>,c.third_cat_name as third_class</p>

<p>,g.is_on_sale as online_flag</p>

<p>,CASE WHEN g.is_on_sale=1 THEN &quot;上架&quot; ELSE &quot;下架&quot; END as&nbsp; online_flag_name</p>

<p>,g.is_stockout as product_status_id</p>

<p>,CASE WHEN g.is_stockout=0 THEN &quot;在售&quot; ELSE &quot;售罄&quot; END&nbsp; as&nbsp; product_status</p>

<p>,g.goods_status as source_status</p>

<p>,CASE WHEN g.goods_status=1 THEN &quot;正常&quot; ELSE &quot;断货&quot; END as&nbsp; source_status_name</p>

<p>,g.shop_price as goods_price</p>

<p>,g.shop_price as market_price</p>

<p>,g.shoppe_discount as goods_dcn</p>

<p>,gl.goods_weight as shipping_weight</p>

<p>,CONCAT(&#39;https://img3.yishouapp.com/&#39;,gl.goods_img)&nbsp; as image_link</p>

<p>,b.goods_desc</p>

<p>,si.supply_name as cp_supply_name</p>

<p>,si.is_platform as cp_is_platform</p>

<p>,mi.market_name as cp_market_name</p>

<p>,gl.picker_group_code as cp_picker_group_code</p>

<p>FROM yishou_data.all_fmys_goods_sku gs</p>

<p>LEFT JOIN yishou_data.all_fmys_goods_lib gl on gl.goods_no = gs.goods_no</p>

<p>LEFT JOIN yishou_data.dim_cat_info c on gl.cat_id = c.cat_id</p>

<p>LEFT JOIN yishou_data.dim_supply_info si on si.supply_id = gl.supply_id</p>

<p>LEFT JOIN yishou_data.dim_market_info mi on mi.market_id = gl.market_id</p>

<p>LEFT JOIN yishou_data.all_fmys_goods_lib_ext gle on gle.goods_no = gs.goods_no</p>

<p>LEFT JOIN yishou_data.all_fmys_goods_id gi on gi.goods_no = gl.goods_no</p>

<p>LEFT JOIN yishou_data.all_fmys_goods g on g.goods_id = gi.goods_id</p>

<p>LEFT JOIN (</p>

<p>&nbsp; &nbsp; SELECT a.goods_no</p>

<p>&nbsp; &nbsp; ,wm_concat(&#39;;&#39;,a.goods_desc ) as goods_desc</p>

<p>&nbsp; &nbsp; FROM (</p>

<p>&nbsp; &nbsp; &nbsp; &nbsp; SELECT goods_no, CONCAT(prop_type_name,&quot;:&quot;, prop_value_name ) as goods_desc</p>

<p>&nbsp; &nbsp; &nbsp; &nbsp; FROM yishou_data.all_fmys_goods_prop_table</p>

<p>&nbsp; &nbsp; )a GROUP BY a.goods_no</p>

<p>)b on b.goods_no = gs.goods_no</p>

<p>WHERE g.auto_time &gt;= &quot;2021-06-01 00:00:00&quot;</p>

<p>;</p>

<p>head参数：</p>

<p>Accept:application/json<br />
Content-Type:application/x-www-form-urlencoded<br />
X-Apig-AppCode:test<br />
Authorization:testToken<br />
X-Kit-AppID:8</p>

<p>body公共参数：</p>

<p>{<br />
&nbsp; &nbsp; &quot;timestamp&quot;:1625206524,<br />
&nbsp; &nbsp; &quot;appid&quot;:8,<br />
&nbsp; &nbsp; &quot;requestid&quot;:1,<br />
&nbsp; &nbsp; &quot;industry_type&quot;:1,<br />
&nbsp; &nbsp; &quot;data_opt_type&quot;:1<br />
}</p>

<p>body 非公共参数部分请查看附件sheet中GoodsInfo</p>