www.gruponucleo.com.ar - Catálogo de Productos de Grupo Núcleo Distribuidora

59 artículos encontrados

Referencias

Nivel de stock
Stock alto
Stock medio
Confirmar stock

Centro Logístico
Mar del Plata
CABA
Cordoba

Impuestos
IVA 10,5%
IVA 21%
IVA 21% + Impuestos Internos 9,89%

Ordenar por: Nombre | Menor Precio | Mayor Precio
Mostrar Impuestos y Stock Mostrar Impuestos y Stock Comparar productos Comparar productos
0% OFF {{ GBP_LIST; NAME:=FAVORITO_ADDED; SQLSCRIPT:= SELECT tbItem.item_id, case when wsif_isActive = 1 then 'fa-heart favoritoAdded' when isnull(wsif_isActive, 0) = 0 then 'fa fa-heart-o favoritoHeart' end FROM tbItem LEFT JOIN tbWebSiteII_Items_Favorites ON tbWebSiteII_Items_Favorites.comp_id = tbItem.comp_id AND tbWebSiteII_Items_Favorites.item_id = tbItem.item_id AND (tbWebSiteII_Items_Favorites.cust_id = -1) AND (tbWebSiteII_Items_Favorites.ws_id = 'ba26ad9e-a9f9-4307-a82c-dc86b0a8a172') WHERE (tbItem.item_id = 44514); SQLFIELDS4REPLACE:=§FAVORITO_ITEM_ID§,§FAVORITO_ITEM_CLASS§; ITEMSBYPAGE:=1; TEMPLATEPAGE:=FAVORITO_ITEM_HEART; }}
Plancha a vapor inalámbrica Peabody

Plancha a vapor inalámbrica Peabody

{{ 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 = 44514 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' WHEN tit.tax_id = 86 OR tit.tax_id = 134 THEN '+II' ELSE '' END AS tax_letter from tbItemTaxes AS tit where tit.item_id = 44514 ORDER BY tit.tax_id DESC ) ttn; SQLFIELDS4REPLACE:=§TAXDESC§,§TAXLETTER§; ITEMSBYPAGE:=5; TEMPLATEPAGE:=TAXLI; }}
{{ GBP_LIST; NAME:=stockb; SQLSCRIPT:= SELECT CASE WHEN -1 = - 1 THEN ' ' WHEN stor_REPicking LIKE '%mar%del%plata%' THEN 'M' WHEN stor_REPicking LIKE '%caba%' THEN 'B' WHEN stor_REPicking LIKE '%cordoba%' THEN 'C' ELSE ' ' END AS Centro, (CASE WHEN -1 = - 1 THEN 'default stock-ocultar' WHEN SUM(itst_LastAvailableInRelalculation) < 4 THEN 'danger' WHEN SUM(itst_LastAvailableInRelalculation) > 10 THEN 'success' ELSE 'warning' END) AS Semaforo, (CASE WHEN -1 = - 1 THEN 'Ingrese' WHEN SUM(itst_LastAvailableInRelalculation) < 4 THEN CONVERT(VARCHAR(100), SUM(CONVERT(INT, itst_LastAvailableInRelalculation))) + ' Unidades (Confirme Stock)' WHEN SUM(itst_LastAvailableInRelalculation) > 10 THEN 'Stock Disponible' ELSE CONVERT(VARCHAR(100), SUM(CONVERT(INT, itst_LastAvailableInRelalculation))) + ' Unidades' END) AS Stock, dbo.tbStorage.stor_REPicking FROM dbo.tbItemStorage INNER JOIN dbo.tbStorage ON dbo.tbItemStorage.stor_id = dbo.tbStorage.stor_id AND dbo.tbItemStorage.comp_id = dbo.tbStorage.comp_id INNER JOIN dbo.tbStorageGroupDetail ON dbo.tbItemStorage.stor_id = dbo.tbStorageGroupDetail.stor_id AND dbo.tbItemStorage.comp_id = dbo.tbStorageGroupDetail.comp_id WHERE (dbo.tbStorageGroupDetail.storg_id = 23) AND (dbo.tbItemStorage.itst_LastAvailableInRelalculation > 0) AND (dbo.tbItemStorage.comp_id = 1) AND (dbo.tbItemStorage.item_id = 44514) GROUP BY dbo.tbStorage.stor_REPicking ORDER BY SUM(dbo.tbStorageGroupDetail.storg_order); SQLFIELDS4REPLACE:=§SUCURSAL§,§SEMAFORO§,§STOCK§,§CENTRO§; ITEMSBYPAGE:=3; TEMPLATEPAGE:=TEMPSTOCK; }}
Agregar
0% OFF {{ GBP_LIST; NAME:=FAVORITO_ADDED; SQLSCRIPT:= SELECT tbItem.item_id, case when wsif_isActive = 1 then 'fa-heart favoritoAdded' when isnull(wsif_isActive, 0) = 0 then 'fa fa-heart-o favoritoHeart' end FROM tbItem LEFT JOIN tbWebSiteII_Items_Favorites ON tbWebSiteII_Items_Favorites.comp_id = tbItem.comp_id AND tbWebSiteII_Items_Favorites.item_id = tbItem.item_id AND (tbWebSiteII_Items_Favorites.cust_id = -1) AND (tbWebSiteII_Items_Favorites.ws_id = 'ba26ad9e-a9f9-4307-a82c-dc86b0a8a172') WHERE (tbItem.item_id = 35827); SQLFIELDS4REPLACE:=§FAVORITO_ITEM_ID§,§FAVORITO_ITEM_CLASS§; ITEMSBYPAGE:=1; TEMPLATEPAGE:=FAVORITO_ITEM_HEART; }}
Plancha A Vapor Peabody PE-PV31

Plancha A Vapor Peabody PE-PV31

{{ 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 = 35827 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' WHEN tit.tax_id = 86 OR tit.tax_id = 134 THEN '+II' ELSE '' END AS tax_letter from tbItemTaxes AS tit where tit.item_id = 35827 ORDER BY tit.tax_id DESC ) ttn; SQLFIELDS4REPLACE:=§TAXDESC§,§TAXLETTER§; ITEMSBYPAGE:=5; TEMPLATEPAGE:=TAXLI; }}
{{ GBP_LIST; NAME:=stockb; SQLSCRIPT:= SELECT CASE WHEN -1 = - 1 THEN ' ' WHEN stor_REPicking LIKE '%mar%del%plata%' THEN 'M' WHEN stor_REPicking LIKE '%caba%' THEN 'B' WHEN stor_REPicking LIKE '%cordoba%' THEN 'C' ELSE ' ' END AS Centro, (CASE WHEN -1 = - 1 THEN 'default stock-ocultar' WHEN SUM(itst_LastAvailableInRelalculation) < 4 THEN 'danger' WHEN SUM(itst_LastAvailableInRelalculation) > 10 THEN 'success' ELSE 'warning' END) AS Semaforo, (CASE WHEN -1 = - 1 THEN 'Ingrese' WHEN SUM(itst_LastAvailableInRelalculation) < 4 THEN CONVERT(VARCHAR(100), SUM(CONVERT(INT, itst_LastAvailableInRelalculation))) + ' Unidades (Confirme Stock)' WHEN SUM(itst_LastAvailableInRelalculation) > 10 THEN 'Stock Disponible' ELSE CONVERT(VARCHAR(100), SUM(CONVERT(INT, itst_LastAvailableInRelalculation))) + ' Unidades' END) AS Stock, dbo.tbStorage.stor_REPicking FROM dbo.tbItemStorage INNER JOIN dbo.tbStorage ON dbo.tbItemStorage.stor_id = dbo.tbStorage.stor_id AND dbo.tbItemStorage.comp_id = dbo.tbStorage.comp_id INNER JOIN dbo.tbStorageGroupDetail ON dbo.tbItemStorage.stor_id = dbo.tbStorageGroupDetail.stor_id AND dbo.tbItemStorage.comp_id = dbo.tbStorageGroupDetail.comp_id WHERE (dbo.tbStorageGroupDetail.storg_id = 23) AND (dbo.tbItemStorage.itst_LastAvailableInRelalculation > 0) AND (dbo.tbItemStorage.comp_id = 1) AND (dbo.tbItemStorage.item_id = 35827) GROUP BY dbo.tbStorage.stor_REPicking ORDER BY SUM(dbo.tbStorageGroupDetail.storg_order); SQLFIELDS4REPLACE:=§SUCURSAL§,§SEMAFORO§,§STOCK§,§CENTRO§; ITEMSBYPAGE:=3; TEMPLATEPAGE:=TEMPSTOCK; }}
Agregar
0% OFF {{ GBP_LIST; NAME:=FAVORITO_ADDED; SQLSCRIPT:= SELECT tbItem.item_id, case when wsif_isActive = 1 then 'fa-heart favoritoAdded' when isnull(wsif_isActive, 0) = 0 then 'fa fa-heart-o favoritoHeart' end FROM tbItem LEFT JOIN tbWebSiteII_Items_Favorites ON tbWebSiteII_Items_Favorites.comp_id = tbItem.comp_id AND tbWebSiteII_Items_Favorites.item_id = tbItem.item_id AND (tbWebSiteII_Items_Favorites.cust_id = -1) AND (tbWebSiteII_Items_Favorites.ws_id = 'ba26ad9e-a9f9-4307-a82c-dc86b0a8a172') WHERE (tbItem.item_id = 43106); SQLFIELDS4REPLACE:=§FAVORITO_ITEM_ID§,§FAVORITO_ITEM_CLASS§; ITEMSBYPAGE:=1; TEMPLATEPAGE:=FAVORITO_ITEM_HEART; }}
Extractor de Jugos Peabody Max Juicer

Extractor de Jugos Peabody Max Juicer

{{ 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 = 43106 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' WHEN tit.tax_id = 86 OR tit.tax_id = 134 THEN '+II' ELSE '' END AS tax_letter from tbItemTaxes AS tit where tit.item_id = 43106 ORDER BY tit.tax_id DESC ) ttn; SQLFIELDS4REPLACE:=§TAXDESC§,§TAXLETTER§; ITEMSBYPAGE:=5; TEMPLATEPAGE:=TAXLI; }}
{{ GBP_LIST; NAME:=stockb; SQLSCRIPT:= SELECT CASE WHEN -1 = - 1 THEN ' ' WHEN stor_REPicking LIKE '%mar%del%plata%' THEN 'M' WHEN stor_REPicking LIKE '%caba%' THEN 'B' WHEN stor_REPicking LIKE '%cordoba%' THEN 'C' ELSE ' ' END AS Centro, (CASE WHEN -1 = - 1 THEN 'default stock-ocultar' WHEN SUM(itst_LastAvailableInRelalculation) < 4 THEN 'danger' WHEN SUM(itst_LastAvailableInRelalculation) > 10 THEN 'success' ELSE 'warning' END) AS Semaforo, (CASE WHEN -1 = - 1 THEN 'Ingrese' WHEN SUM(itst_LastAvailableInRelalculation) < 4 THEN CONVERT(VARCHAR(100), SUM(CONVERT(INT, itst_LastAvailableInRelalculation))) + ' Unidades (Confirme Stock)' WHEN SUM(itst_LastAvailableInRelalculation) > 10 THEN 'Stock Disponible' ELSE CONVERT(VARCHAR(100), SUM(CONVERT(INT, itst_LastAvailableInRelalculation))) + ' Unidades' END) AS Stock, dbo.tbStorage.stor_REPicking FROM dbo.tbItemStorage INNER JOIN dbo.tbStorage ON dbo.tbItemStorage.stor_id = dbo.tbStorage.stor_id AND dbo.tbItemStorage.comp_id = dbo.tbStorage.comp_id INNER JOIN dbo.tbStorageGroupDetail ON dbo.tbItemStorage.stor_id = dbo.tbStorageGroupDetail.stor_id AND dbo.tbItemStorage.comp_id = dbo.tbStorageGroupDetail.comp_id WHERE (dbo.tbStorageGroupDetail.storg_id = 23) AND (dbo.tbItemStorage.itst_LastAvailableInRelalculation > 0) AND (dbo.tbItemStorage.comp_id = 1) AND (dbo.tbItemStorage.item_id = 43106) GROUP BY dbo.tbStorage.stor_REPicking ORDER BY SUM(dbo.tbStorageGroupDetail.storg_order); SQLFIELDS4REPLACE:=§SUCURSAL§,§SEMAFORO§,§STOCK§,§CENTRO§; ITEMSBYPAGE:=3; TEMPLATEPAGE:=TEMPSTOCK; }}
Agregar
0% OFF {{ GBP_LIST; NAME:=FAVORITO_ADDED; SQLSCRIPT:= SELECT tbItem.item_id, case when wsif_isActive = 1 then 'fa-heart favoritoAdded' when isnull(wsif_isActive, 0) = 0 then 'fa fa-heart-o favoritoHeart' end FROM tbItem LEFT JOIN tbWebSiteII_Items_Favorites ON tbWebSiteII_Items_Favorites.comp_id = tbItem.comp_id AND tbWebSiteII_Items_Favorites.item_id = tbItem.item_id AND (tbWebSiteII_Items_Favorites.cust_id = -1) AND (tbWebSiteII_Items_Favorites.ws_id = 'ba26ad9e-a9f9-4307-a82c-dc86b0a8a172') WHERE (tbItem.item_id = 43211); SQLFIELDS4REPLACE:=§FAVORITO_ITEM_ID§,§FAVORITO_ITEM_CLASS§; ITEMSBYPAGE:=1; TEMPLATEPAGE:=FAVORITO_ITEM_HEART; }}
Extractor de Jugos Peabody

Extractor de Jugos Peabody

{{ 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 = 43211 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' WHEN tit.tax_id = 86 OR tit.tax_id = 134 THEN '+II' ELSE '' END AS tax_letter from tbItemTaxes AS tit where tit.item_id = 43211 ORDER BY tit.tax_id DESC ) ttn; SQLFIELDS4REPLACE:=§TAXDESC§,§TAXLETTER§; ITEMSBYPAGE:=5; TEMPLATEPAGE:=TAXLI; }}
{{ GBP_LIST; NAME:=stockb; SQLSCRIPT:= SELECT CASE WHEN -1 = - 1 THEN ' ' WHEN stor_REPicking LIKE '%mar%del%plata%' THEN 'M' WHEN stor_REPicking LIKE '%caba%' THEN 'B' WHEN stor_REPicking LIKE '%cordoba%' THEN 'C' ELSE ' ' END AS Centro, (CASE WHEN -1 = - 1 THEN 'default stock-ocultar' WHEN SUM(itst_LastAvailableInRelalculation) < 4 THEN 'danger' WHEN SUM(itst_LastAvailableInRelalculation) > 10 THEN 'success' ELSE 'warning' END) AS Semaforo, (CASE WHEN -1 = - 1 THEN 'Ingrese' WHEN SUM(itst_LastAvailableInRelalculation) < 4 THEN CONVERT(VARCHAR(100), SUM(CONVERT(INT, itst_LastAvailableInRelalculation))) + ' Unidades (Confirme Stock)' WHEN SUM(itst_LastAvailableInRelalculation) > 10 THEN 'Stock Disponible' ELSE CONVERT(VARCHAR(100), SUM(CONVERT(INT, itst_LastAvailableInRelalculation))) + ' Unidades' END) AS Stock, dbo.tbStorage.stor_REPicking FROM dbo.tbItemStorage INNER JOIN dbo.tbStorage ON dbo.tbItemStorage.stor_id = dbo.tbStorage.stor_id AND dbo.tbItemStorage.comp_id = dbo.tbStorage.comp_id INNER JOIN dbo.tbStorageGroupDetail ON dbo.tbItemStorage.stor_id = dbo.tbStorageGroupDetail.stor_id AND dbo.tbItemStorage.comp_id = dbo.tbStorageGroupDetail.comp_id WHERE (dbo.tbStorageGroupDetail.storg_id = 23) AND (dbo.tbItemStorage.itst_LastAvailableInRelalculation > 0) AND (dbo.tbItemStorage.comp_id = 1) AND (dbo.tbItemStorage.item_id = 43211) GROUP BY dbo.tbStorage.stor_REPicking ORDER BY SUM(dbo.tbStorageGroupDetail.storg_order); SQLFIELDS4REPLACE:=§SUCURSAL§,§SEMAFORO§,§STOCK§,§CENTRO§; ITEMSBYPAGE:=3; TEMPLATEPAGE:=TEMPSTOCK; }}
Agregar
  • Primero
  • Anterior
  • 1
  • 2
  • Próximo
  • Último
  • {{GBP_INSERTSCRIPT; TEMPLATEPAGE:=FOOTER}}