Recarrega em 30 segundos.25-11-2024 00:59:45
habilitaUpdateProdutos - OK
SELECT DISTINCT TOP 20 p.codProduto,CAST(p.codLoja AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS codLoja,CAST(p.codLojaPrincipal AS NCHAR) collate SQL_Latin1_General_CP1_CI_AS AS codLojaPrincipal,CAST(p.Variacao AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS Variacao,CAST(p.LabelVariacao AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS LabelVariacao,CAST(p.URLAmigavel AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS URLAmigavel,CAST(p.NomeFoto AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS NomeFoto,CAST(p.NomeProduto AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS NomeProduto,p.ValorProduto,CAST(p.codCategoria AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS codCategoria,CAST(p.codSubCategoria AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS codSubCategoria,CAST(p.Categoria AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS Categoria,CAST(p.SubCategoria AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS SubCategoria,p.codFabricante,CAST(p.Fabricante AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS Fabricante,CAST(p.Garantia AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS Garantia,p.EstoqueIntegra, convert(varchar(20),p.UltimaAtualizacao,113) as UltimaAtualizacao,CAST(p.EAN AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS EAN,CAST(p.Habil AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS Habil,CAST(p.Descricao AS NVARCHAR(4000)) collate SQL_Latin1_General_CP1_CI_AS AS Descricao,p.Largura,p.Altura,p.Comprimento,p.LarguraFrete,p.AlturaFrete,p.ComprimentoFrete,p.PesoLiquido,p.PesoCorreio,p.PesoTransportadora,p.Correio,p.Margem, p.DataUltimaCompra,DATEDIFF(MONTH,p.DataUltimaCompra, CURRENT_TIMESTAMP) as Meses, p.VendaCasada, p.Cadastra, p.Atualiza,ma.flag_insert, ma.flag_update FROM dev.dbo.tbl_produtos as p inner join dev.dbo.tbl_marketplace_anuncio as ma on (ma.vc_sku = p.codLoja collate SQL_Latin1_General_CP1_CI_AS) WHERE (ma.flag_update is null OR ma.flag_update = 1) AND ma.id_status in (1,2) AND ma.id_marketplace = 3 AND p.Atualiza = 1 ORDER BY p.codProduto DESCimg_do_produto2= https://www.agrotama.com.br/upload/produtos_adc/.jpg
labelVariacao: Voltagem && variacao: 220v
groupId: 102061084 == vc_sku: 102061085
Cadastra: 1 | Atualiza: 1 || flag_insert: 2 | flag_update: 1
Atualizar:
retorno_update - SkyhubProduct::update_product(2):Array
(
[status] => 204
[response] =>
)
- Erro na query: UPDATE inventario.dbo.tbl_regua_anuncios SET StatusAnuncio = 'Concluido', Retorno = 2, DataAlteracao = '2024-11-25 00:59:54' WHERE Marketplace = 'SKYHub' and codLoja = '102061085'
- File: /home/agrotama/public_html/skyhub/Product/skyhub_rotina_atualiza_todos.php