Teclado Logitech K480 Inalambrico Blanco Bt Grupo Nucleo
{{ GBP_SQLREPLACE; SQLSCRIPT:= SELECT tc.cat_id, tc.cat_website_desc ,tsc.subcat_id, tsc.subcat_website_desc, tc.cat_website_id, TSCA.COMP_ID, TSCA.SUBCATAUX_ID, TSCA.subcataux_desc FROM tbitem ti INNER JOIN tbCategory tc ON tc.comp_id = ti.comp_id AND tc.cat_id = ti.cat_id INNER JOIN tbSubCategory tsc ON tsc.comp_id = tc.comp_id AND tsc.cat_id = tc.cat_id AND tsc.subcat_id = ti.subcat_id INNER JOIN TBSUBCATEGORYAUX TSCA ON tc.cat_WebSite_id = tsca.subcataux_id WHERE ti.item_id = 35983; SQLFIELDS4REPLACE:=§CAT_ID§,§CAT§,§SCAT_ID§,§SCAT§,§CATMAL_ID§,§COMP_ID§,§AUXCAT_ID§,§AUXCAT§; }} {{GBP_INSERTSCRIPT; TEMPLATEPAGE:=HEADER}}
§ITEM_DESCUENTO§% OFF

§ITEMTIT§

§SYMB1§ §PRICE1§ {{ GBP_LIST; NAME:=TAX; SQLSCRIPT:= select ttax.ret_RegimenDescription, ttn.tax_letter from ( SELECT STUFF(( SELECT concat(' + ', ttn.ret_RegimenDescription) from tbItemTaxes AS tit INNER JOIN tbTaxName AS ttn ON ttn.comp_id = tit.comp_id AND tit.tax_id = ttn.tax_id WHERE tit.item_id = §ITEMID§ FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)'), 1, 3, '') as ret_RegimenDescription ) ttax outer apply ( select top 1 CASE WHEN tit.tax_id = 1 THEN '+i' WHEN tit.tax_id = 2 THEN '+I' ELSE '+II' END AS tax_letter from tbItemTaxes AS tit where tit.item_id = §ITEMID§ ORDER BY tit.tax_id DESC ) ttn; SQLFIELDS4REPLACE:=§TAXDESC§,§TAXLETTER§; ITEMSBYPAGE:=5; TEMPLATEPAGE:=TAXLIDET; }} {{ GBP_LIST; NAME:=FAVORITO_ADDED; SQLSCRIPT:= SELECT item_id, 'fa-heart favoritoAdded' FROM dbo.tbWebSiteII_Items_Favorites WHERE (wsif_isActive = 1) AND (item_id = 35983) 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 = 35983; 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 = 35983; SQLFIELDS4REPLACE:=§DEPOSITO§,§STOCK§,§STOCKA§; ITEMSBYPAGE:=50; TEMPLATEPAGE:=SEMAFORO1; }}

Codigo: §ITEMCODIGO§

§ITEMCOPETE§

§ITEMDESCORTA§

§ITEMDESCHTML§

{{GBP_INSERTSCRIPT; TEMPLATEPAGE:=FOOTER}}