{{
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
{{
GBP_LIST;
NAME:=SLIDER1FULL;
SQLSCRIPT:=
SELECT tii.itimg_id ,ti.item_desc
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 35983;
SQLFIELDS4REPLACE:=§IMGID§,§ALT§;
ITEMSBYPAGE:=6;
TEMPLATEPAGE:=SLIDERITEMFULL;
}}
§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.
Producto de OUTLET: Esto significa que el producto puede contener defectos estéticos y/o en su packaging.
Producto con DESCUENTO: Este artículo tiene aplicado un descuento de §ITEM_DESCUENTO§%
Gestión Grupo Sellers
| MicroSitio |
Incremento |
Actual |
Sugerido |
Novedad |
Oferta |
{{
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;
}}
{{
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§