Camara Hikvision IP Bullet 2mp Lente 4mm Ir 30mtrs Grupo Nucleo
§ITEM_DESCUENTO§% OFF

§ITEMTIT§

Agregar

Gestión Grupo Sellers

{{ GBP_LIST; NAME:=CAT1; SQLSCRIPT:= SELECT dbo.tbWebSiteII_Names.ws_desc AS MicroSitio, CONVERT(nvarchar(20), CONVERT(decimal(16, 2), ISNULL(dbo.tbWebSiteII_ItemsData.prli_price, 0))) AS Precio, CONVERT(nvarchar(40), dbo.tbWebSiteII_Names.ws_id) AS ws_id, CASE tbWebSiteII_microSites.wsmsp_priceType WHEN 1 THEN '% ' ELSE '$ ' END + CONVERT(nvarchar(20), CONVERT(decimal(16, 2), ISNULL(dbo.tbWebSiteII_microSites.wsmsp_value, 0))) AS incremento, dbo.tbWebSiteII_ItemsData.item_id, CASE WHEN tbWebSiteII_Items_NoveltyAnd4Sale.wssn_isNovelty = 1 THEN 'true' ELSE 'false' END AS wssn_isNovelty, CASE WHEN tbWebSiteII_Items_NoveltyAnd4Sale.wssn_is4Sale = 1 THEN 'true' ELSE 'false' END AS wssn_is4Sale, dbo.tbWebSiteII_Items_NoveltyAnd4Sale.wssn_disabled, CEILING(ISNULL(dbo.vi_PrecioVentaItemsLista1_Final.Precio1Final, 0)) AS Precio1Final FROM dbo.tbWebSiteII_Names LEFT OUTER JOIN dbo.tbWebSiteII_ItemsData ON dbo.tbWebSiteII_Names.comp_id = dbo.tbWebSiteII_ItemsData.comp_id AND dbo.tbWebSiteII_Names.ws_id = dbo.tbWebSiteII_ItemsData.ws_id LEFT OUTER JOIN dbo.tbWebSiteII_microSites ON dbo.tbWebSiteII_microSites.comp_id = dbo.tbWebSiteII_Names.comp_id AND dbo.tbWebSiteII_microSites.ws_id = dbo.tbWebSiteII_Names.ws_id AND dbo.tbWebSiteII_ItemsData.item_id = dbo.tbWebSiteII_microSites.item_id LEFT OUTER JOIN dbo.vi_PrecioVentaItemsLista1_Final ON dbo.tbWebSiteII_ItemsData.item_id = dbo.vi_PrecioVentaItemsLista1_Final.item_id LEFT OUTER JOIN dbo.tbWebSiteII_Items_NoveltyAnd4Sale ON dbo.tbWebSiteII_ItemsData.ws_id = dbo.tbWebSiteII_Items_NoveltyAnd4Sale.ws_id AND dbo.tbWebSiteII_ItemsData.item_id = dbo.tbWebSiteII_Items_NoveltyAnd4Sale.item_id WHERE tbWebSiteII_Names.cust_id4MicroSites = -1 AND tbWebSiteII_ItemsData.item_id = 44778; SQLFIELDS4REPLACE:=§1§,§2§,§3§,§4§,§ITEM_ID§,§ES_NOVEDAD§,§ES_OFERTA§,§DISABLED§,§PRECIO1§; ITEMSBYPAGE:=5; TEMPLATEPAGE:=MSITEM3; }}
MicroSitio Incremento Actual Sugerido Novedad Oferta
{{ GBP_LIST; NAME:=SEMAFORO; SQLSCRIPT:= SELECT (CASE WHEN -1 = - 1 THEN '.' ELSE vi_WebStockporCentro.Centro END) AS SUCURSAL, (CASE WHEN -1 = - 1 THEN 'N' WHEN vi_WebStockporCentro.Stock < 4 THEN 'A' WHEN vi_WebStockporCentro.Stock > 10 THEN 'C' ELSE 'B' END) AS STOCK, (CASE WHEN -1 = - 1 THEN '.' WHEN vi_WebStockporCentro.Stock < 4 THEN CONVERT(NVARCHAR(20), CONVERT(DECIMAL(16, 0), vi_WebStockporCentro.Stock)) + ' (Confirme Stock)' WHEN vi_WebStockporCentro.Stock > 10 THEN '.' ELSE CONVERT(NVARCHAR(20), CONVERT(DECIMAL(16, 0), vi_WebStockporCentro.Stock)) END) AS STOCKA FROM vi_WebStockporCentro WHERE item_id = 44778; SQLFIELDS4REPLACE:=§DEPOSITO§,§STOCK§,§STOCKA§; ITEMSBYPAGE:=50; TEMPLATEPAGE:=SEMAFORO1; }}

Codigo: §ITEMCODIGO§

§ITEMCOPETE§

§ITEMDESCORTA§

§ITEMDESCHTML§

{{GBP_INSERTSCRIPT; TEMPLATEPAGE:=FOOTER}}