Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('258')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%AdhesivesGlues' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('AdhesivesGlues' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+AdhesivesGlues' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"AdhesivesGlues"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"AdhesivesGlues"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"AdhesivesGlues"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"AdhesivesGlues"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+AdhesivesGlues' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='AdhesivesGlues',`category_4` ='AdhesivesGlues') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'AdhesivesGlues,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('AdhesivesGlues', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Adhesives Glues

Refine Search

  GO
 
Brand

Elmer's(37)

Scotch(20)

Loctite(15)

Avery(11)

UHU(10)

Krazy Glue(8)

Tombow(8)

Universal(8)

Surebonder(5)

3M(2)

Chenille Kraft(1)

Stanley(1)

Creativity Street(1)

Universal One(1)

Nekoosa(1)

Misty(1)

Crayola(1)

Koh-I-Noor(1)

 
Packing Type

Stick(14)

Bottle(14)

Tube(4)

Aerosol(3)

Roller Refill(3)

Roller Applicator(3)

Can(2)

Bulk(1)

Jar(1)

 
Manufacturer Part Number

6055(1)

6055BNS(1)

6055ES(1)

6052-B(1)

6050(1)

6008-24-S(1)

6008CGS-5(1)

6055R(1)

6060(1)

AD121(1)

AD122(1)

AD119(1)

77(1)

6065(1)

6094(1)

6008-18(1)

56824(1)

1365734(1)

1365868(1)

1365882(1)

1364076(1)

1363589(1)

1255800(1)

1363131(1)

1503244(1)

1629134(1)

1713065(1)

230992(1)

1710908(1)

1710836(1)

1647358(1)

1661510(1)

AD124(1)

AD125(1)

62127(1)

62128(1)

74748(1)

62109(1)

62108(1)

62106(1)

62107(1)

74748VP(1)

74750(1)

75750(1)

76752(1)

75748VP(1)

75748(1)

74752(1)

75614(1)

52190(1)

52180(1)

99450(1)

99457(1)

42284(1)

SG1(1)

ADH669(1)

ADH670(1)

99648(1)

99649(1)

99835(1)

99840(1)

99831(1)

99830(1)

99653(1)

99655(1)

25900J01(1)

DT-25(1)

E1324(1)

E1326(1)

E301(1)

E1322(1)

E129(1)

233(1)

234(1)

E304(1)

E305(1)

E4055(1)

E451(1)

E4054(1)

E340(1)

E308(1)

E313(1)

231(1)

56-1135(1)

00226(1)

98071(1)

00216(1)

00196(1)

00134(1)

00166(1)

98073(1)

98079(1)

3375(1)

8562(1)

GS20DT(1)

98096(1)

98089(1)

98095(1)

E455(1)

E501(1)

KG58248SN(1)

KG58548R(1)

KG82548RW(1)

KG48348MR(1)

E904(1)

E623(1)

E7050(1)

KG82948MR(1)

KG86648R(1)

DT-20(1)

DT-2010(1)

CS-15(1)

711R510(1)

KG92548R(1)

KG94548R(1)

E605(1)

E599(1)

E517(1)

E524(1)

E5045(1)

E5044(1)

E503(1)

E5043(1)

E532(1)

E542(1)

E556(1)

E584(1)

E555(1)

E554(1)

E543(1)

E553(1)

A315-20CT(1)

 
Country of Origin

CN(43)

US(38)

DE(12)

IE(9)

JP(9)

MX(7)

TH(7)

KR(4)

GB(2)

VN(1)

 
Capacity (Volume)

0.28 oz(7)

4 oz(7)

0.14 oz(7)

0.26 oz(7)

1/3" x 472"(6)

0.07 oz(6)

0.77 oz(6)

0.74 oz(4)

1.41 oz(4)

0.24 oz(4)

1 gal(4)

0.88 oz(4)

1.27 oz(4)

10.25 oz(3)

3/10" x 49ft(3)

0.21 oz(3)

0.24 oz.(2)

0.29 oz(2)

1.3 oz(2)

13.5 oz(2)

8 oz(2)

3 g(2)

0.17 oz(2)

7.625 oz(2)

0.18 oz(2)

.29 oz (8.2g)(1)

1/3" x 393"(1)

3/8" x 396"(1)

1.6 oz(1)

13.57 oz(1)

0.017 oz(1)

1.69 oz(1)

32 oz(1)

1.25 oz (37ml)(1)

.74 oz (21 g)(1)

5 g(1)

5 oz(1)

1.5 oz.(1)

11 oz(1)

1.25 oz(1)

0.21 oz.(1)

.88 oz.(1)

1 qt(1)

10 oz(1)

4 g(1)

0.99oz(1)

1.75 oz.(1)

1.18 oz(1)

0.47 oz(1)

.07 oz(1)

12 oz(1)

7/8"(1)

0.27 oz(1)

 
Suggested Use

Cardboard; Fabrics; Papers; Photos(9)

Cardboard; Cloth; Leather; Paper; Wood(8)

Paper;Cardboard;Photos(8)

Cardboard; Fabrics; Paper; Photos(8)

Cardboard; Fabric; Paper; Photographs(8)

Ceramics; Glass; Metal; Plastics; Rubber; Wood(6)

All Types Of Paper;Cardboard;Display Board;Foam Board(4)

Cardboard;Fabrics;Papers;Photos(4)

Adhering Photos; Detailed Cut And Paste Projects(4)

Cardstock; Paper; Photos(4)

Cardstock; Cork; Fabric; Glass; Paper; Plastic; Rubber; Wood(2)

Applying Labels; Mounting Pictures Or Charts On Presentation Boards; Sealing Envelopes(2)

Cardboard;Foam;Foils;Paper;Plastics(1)

clear}(1)

Cardboard;Cork;Fabrics;Foils;Papers;Plastics(1)

Delicate Papers;Newspaper;Parchment Tissue(1)

Art Prints;Drawings;Maps;Valuable Photos(1)

Paper;Thermal Paper;Cardboard;Labels;Styrofoam(1)

Cardboard; Cardstock; Embellishments; Posterboard(1)

Cardstock; Embellishments; Paper; Photos; Posterboard(1)

Paper;Thermal Paper;Styrofoam;Cardboard;Labels(1)

Ceramics;Leather;Metal;Plastics(1)

For use with NCP carbonless papers to produce multi-part business form sets(1)

Ceramics; Leather; Metal; Vinyl; Wood(1)

Photos; Paper(1)

Variety Of Surfaces Including Plastics(1)

Felt; Craft Sticks, Googly Eyes, Cotton Balls(1)

Art Projects;Craft Projects(1)

Envelopes(1)

Dual-Temperature; Hot-Melt; Low-Temperature(1)

Cardboard; Fabric; Foil; Metal; Paper; Plastic; Wood(1)

Posters; Pictures(1)

Paper;Ribbon;Fabric;Wood(1)

Ceramics;Cork;Hard Plastics;Leather;Metal;Papers;Rubber;Vinyl;Wood(1)

Paper;Leather:Ribbon;Fabric;Foam;Metal;Ceramic(1)

Cardboard;Cloth;Leather;Most Plastics;Poly Sheeting(1)

General Projects; Hardwoods; Softwoods(1)

Glass; Metal; Plastics; Rubber; Wood(1)

Ceramics;Cork;Leather;Metal;Most Plastics;Papers;Rubber;Textiles;Vinyl;Wood(1)

 
Adhesive Type

Permanent Glue Stick(25)

General Purpose Glue Stick(17)

Liquid Super Glue(16)

Glue Stick(9)

Spray Adhesive(8)

Super Glue Gel(8)

School Glue(7)

Adhesive Roller(6)

Glue Gun Stick(6)

Roller(6)

Repositionable Rubber Cement(4)

Brush-On Super Glue(3)

Multi-Purpose Glue(3)

Liquid(2)

Office Glue(1)

Padding Compound(1)

Mounting Adhesive(1)

Repositionable Aerosol(1)

Mounting Glue Stick(1)

Liquid Glitter Glue(1)

Liquid Arts/Crafts Glue(1)

Colored Glue Stick(1)

Liquid Glue Pen(1)

Drafting Dots(1)

Wood Glue(1)

Epoxy(1)

 
Age Recommendation

Ages 3 and up(8)

For Adult Use(4)

All ages(2)

12 and over(1)

Ages 18 and Up(1)

 
Washable

Yes(66)

No(7)

Y(1)

 
Choking Hazard

Y(24)

Small Parts(1)

 
Color Dried

Clear(120)

Light Blue(2)

Light Green(2)

Transparent(1)

White(1)

Amber(1)

Pink; Yellow; Multi; Silver; Blue; Orange; Green; Red(1)

Blue; Orange; Pink; Yellow; Green(1)

Beige(1)

 
Color on Application

Clear(53)

White(25)

Purple(17)

Blue(5)

Opaque(4)

Light Blue(2)

Light Green(2)

Milky White(1)

Amber(1)

Blue; Orange; Pink; Yellow; Green(1)

Beige(1)

Pink; Yellow; Multi; Silver; Blue; Orange; Green; Red(1)

 
 
 

© 2019-2020 Onestop, Inc., All Rights Reserved