问题描述:
同步ERP海外仓备货SKU信息错误
ERP不符合条件,ebay->sys_basicstocklist_fbaoversea可以查询到
select *from sys_basicstocklist_fbaoversea where
CustomerID=1
and ToWareHouseID in(17218,12513,16766,114,212,4891) and StockLabel=1
and (IFNULL(IsNeedStock,false)=true or IFNULL(MonitorStatus,false)=true)
and SKU IN ('20963589','17184396','19461410','6503462','2284209','16969539','4247494','16704972','17781839','17657681','21443801','21019227','3411163','17065443','18634604',
'18092016','17225328','17823603','20912889')


固定条件取ERP同步数据,可能数据变动了,智能刊登多数据。
修改设计:
新增字段,每次删除24以前的数据