A Acond Surrey 2250F2600W FrioCalor Wifi Vita Smart Grupo Nucleo
Inicio Hogar Climatizacion Aires Acondicionados
§ITEM_DESCUENTO§% OFF

§ITEMTIT§

§SYMB1§ §PRICE1§ {{ GBP_LIST; NAME:=FAVORITO_ADDED; SQLSCRIPT:= SELECT item_id, 'fa-heart favoritoAdded' FROM dbo.tbWebSiteII_Items_Favorites WHERE (wsif_isActive = 1) AND (item_id = 40081) AND (cust_id = -1) AND (ws_id = 'ba26ad9e-a9f9-4307-a82c-dc86b0a8a172'); SQLFIELDS4REPLACE:=§FAVORITO_ITEM_ID§,§FAVORITO_ITEM_CLASS§; ITEMSBYPAGE:=1; TEMPLATEPAGE:=FAVORITO_ITEM_HEART; }}
Sin stock momentaneo.
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 = 40081; 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 = 40081; SQLFIELDS4REPLACE:=§DEPOSITO§,§STOCK§,§STOCKA§; ITEMSBYPAGE:=50; TEMPLATEPAGE:=SEMAFORO1; }}

Codigo: §ITEMCODIGO§

§ITEMCOPETE§

§ITEMDESCORTA§

§ITEMDESCHTML§

Productos Relacionados

Ver todos {{ GBP_LIST; NAME:=NOV1; SQLSCRIPT:= select ti.Item_id, CASE WHEN avg(itr.wsq_rate)> 5 THEN 5 else isnull(avg(itr.wsq_rate),0) END [wsq_rate], isnull(ti.item_WebSite_desc,'VACIO'), SUBSTRING(dbo.afn_propercase(item_desc), 1, 50), dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.brand_id, ti.item_annotation2, ti.item_newness, ti.item_liquidation, isnull(ti.item_WebSite_vendorPage,'VACIO'), CASE WHEN -1 = -1 THEN (SELECT '') else convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price], tc.curr_symbol, LOWER(REPLACE(dbo.fnGetOnlyAlfaNumbers(ti.item_WebSite_desc), ' ', '-')), --case when isnull(tis470.itst_LastAvailableInRelalculation, 0) = 0 then 'conStock' else 'hidden' end as sinStock case when tpli.itst_LastAvailableInRelalculation <> 999888 then 'conStock' else 'hidden' end as sinStock FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 5 --AND tpli.ws_id = 'ba26ad9e-a9f9-4307-a82c-dc86b0a8a172' inner join taVariablesDetail tvd on tvd.var_id = 37 and tvd.cust_id = -1 and tvd.ws_id = tpli.ws_id INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id left JOIN tbWebSiteII_ItemRates itr ON itr.comp_id = ti.comp_id and itr.item_id = ti.item_id /* left join tbItemStorage tis470 with(nolock) on tis470.comp_id = ti.comp_id and tis470.item_id = ti.item_id and tis470.stor_id = case when tpli.ws_id = '0F0FF862-0571-4DB3-B4E2-ABC2EDF50B5B' then 470 else -1 end --depo stock ficticio and tis470.itst_LastAvailableInRelalculation > 0 */ WHERE ti.item_web = 'true' AND ti.item_id <> '§ITEMID§' and ti.subcat_id = '3846' Group by ti.item_id,ti.item_WebSite_desc,dbo.afn_propercase(item_desc), ti.item_code,ti.item_vendorCode,brand_id,item_annotation2,item_newness, item_liquidation,item_WebSite_vendorPage,prli_price,curr_symbol,item_markup_1,ti.comp_id,tpli.itst_LastAvailableInRelalculation ORDER BY NEWID(); SQLFIELDS4REPLACE:=§ITEMID2§,§STAR2§,§ITEMTIT2§,§ITEMCOPETE2§,§ITEMCODIGO2§,§ITEMCODPROV2§,§ITEMMARCA2§,§ITEMDESCORTA2§,§ITEMNOVEDAD2§,§ITEMOFERTA2§,§ITEMPAGINAFAB2§,§PRICE12§,§SYMB12§,§WSDESCURL§,§SINSTOCK2§; ITEMSBYPAGE:=3; TEMPLATEPAGE:=NOVITEM12; }}
{{GBP_INSERTSCRIPT; TEMPLATEPAGE:=FOOTER}}