深圳智汇创想科技有限公司

已完成。

MercadolibreAutoPublishJob
MercadolibreAutoPublishGroupJob
MercadolibreAutoPublishByMultiAttributeJob
MercadolibrePhoenixStrategyJob

初始化数据 SQL:

INSERT IGNORE INTO m_market_mercadolibre_upc (MarketId, OrderSourceId, Sku, Upc, CreatorId, Creator, CreationTime,  LastModifierId, LastModifier, LastModificationTime) SELECT 70,  t3.ProductId,  t3.Sku,  t3.Upc,  0,  '系统管理员',  NOW(),  0,  '系统管理员',  NOW() FROM (SELECT t1.CustomerId, t1.OrderSourceId, t1.ProductId, t1.Sku, t2.Upc FROM m_mercadolibre_listing AS t1 LEFT JOIN (SELECT CustomerId AS cus, ProductId AS proid, ValueName AS Upc FROM m_mercadolibre_listing_attribute WHERE AttributeId = 'GTIN') AS t2 ON t1.CustomerId = t2.cus AND t1.ProductId = t2.proid) AS t3;