SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 (`pinfo`.`sku` IN ('GHECMD7438AT','ONSGSFS4','ONSGSTS','ONSGS1Q','GN1MS8008B','GN1MS8008P','GN1PE17336','GN1PE17337','GN1PE17338','GN124444923','GN124444923PK','GN124446905','GN1KN95ES','GN1MM005','GN1WXDKZ0005BX','GN1WXDKZ0005ES','GN1WXDKZ0007BX','GN1WXDKZ0007ES','GN1H17011CT','SBX77145CT','SBX77172CT','GRR60000202','GRR60000203','GN1IT0808','GN1IT0808EA','APH3984528772X3','APH3984528782X3','APH3984528792X3','APH3984528802X3','APH3984528842X3','APH3984528822X3','APH3984528832X3','GN1MFS384ESP','GN1MFS386ESP','GN1MFS388ESP','GN1MFS390ESP','GN1MFS464ESP','GN1MFS465ESP','GN1MFS466ESP','GN1MFS467ESP','TAB29201','TAB29203','TAB29507','TAB29512','TAB29513','DEFPSB181420H','DEFPSB221618H','DEFPSB221624H','TPG986CT','TPG988CT','TPG981','GHEDPSC2459F','GHEDPSC2429F','GHEDPSF2429F','GHEDPSF2459F','BVCDSP123046','BVCDSP273046','BVCGL0701393','BVCGL07019101','BVCGL0801393','BVCGL08019101','BVCGL2001393','BVCGL34019101','BVCGL3501393','DEFPBCTA2724F','DEFPBCTA2724P','DEFPBCTA3136F','DEFPBCTA3136P','DEFPBCTPC2724F','DEFPBCTPC2724P','DEFPBCTPC3123B','DEFPBCTPC3136F','GHECMD7438A','DBL558957','DBL481523','DBL481423','DEF68201','DEF68301','DEF69201','DEF69301','DEF69701','MMM471IWRED','MMM471IWYLW','MMM471ORG','MMMM1LANEMARK','PGC30314CT','PGC58775CT','SJN312620','SJN682266','GN1SA05024','GN1430LEA','GN1F1406ST','BKEBKSSPC10D','GN1F1406STS','GN112SAN24','GN1CBC1GALSAN','GN1E236SAN','SBX77141CT','XER008R08112','SBX77140CT','SBX77140EA','SBX77171CT','CPC98567','CPC98568','PGC02699','SBX00676CT','SBX77148CT','SBX77143CT','HONSTANDP8T','')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=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 MATCH(`desc_short`) AGAINST ('schoolsafe' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+schoolsafe' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"schoolsafe"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"schoolsafe"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"schoolsafe"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"schoolsafe"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+schoolsafe' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='schoolsafe',`category_4` ='schoolsafe') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'schoolsafe,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('schoolsafe', `pinfo`.`desc_title`)) DESC

Currently Filtered by

schoolsafe

Schoolsafe

Refine Search
  GO
Category Filter

Partition & Panel Systems(28)

Signs & Sign Holders(21)

Face Masks(14)

Hand Sanitizers(13)

Floor Mats(7)

Personal Soaps(6)

Cleaners & Detergents(4)

Hand Cleaner Dispensers(3)

Safety Tapes(3)

Stands(2)

First Aid Thermometer(2)

First Aid Kits(2)

Partition & Panel Accessories(1)

Towels & Wipes(1)

Tape Dispensers(1)

Thermal Imagers(1)

Brand

GN1(17)

deflecto(16)

Soapbox(9)

MasterVision(9)

Accuform(8)

Apache Mills(7)

Ghent(6)

Tabbies(5)

3M(4)

GEN(3)

OneScreen(3)

The Pencil Grip(3)

Durable(3)

Windex(2)

TEH TUNG(2)

Green Rabbit(2)

Softsoap(2)

BK Resources(1)

Xerox(1)

HON(1)

Alpine(1)

HAND HERO(1)

Safeguard Professional(1)

Comet(1)

Spic and Span(1)

Color

Clear(20)

Clear/Aluminum(6)

Silver/Black(2)

Frosted(2)

Height

12"(8)

17"(4)

18"(2)

11"(2)

8"(1)

9"(1)

11.66"(1)

0.63"(1)

8.5"(1)

43" - 50"(1)

Adjustable 40-60"(1)

9.5"(1)

40.5" - 46.5"(1)

11.1"(1)

Color(s)

Clear(14)

Yellow(3)

White(2)

White/Gray(2)

Red(1)

Silver(1)

Red/Black(1)

Brown(1)

Peach(1)

Orange(1)

Black; Yellow(1)

Blue(1)

Charcoal; Yellow(1)

Charcoal; Red(1)

Red; White(1)

Charcoal(1)

Silver; White; Black(1)

Red; Black(1)

Width

12"(9)

24"(7)

2"(4)

17"(4)

6"(3)

15"(2)

8.5"(2)

11"(2)

1"(1)

0.98"(1)

8.56"(1)

Depth

0.03"(8)

0.008"(3)

3.5"(2)

5.23"(1)

1"(1)

12"(1)

0.25"(1)

2.63"(1)

4.48"(1)

0.38"(1)

6"(1)

Size

12" dia(5)

17" dia(2)

1,200 mL Refillable Bottle(2)

12 x 12(2)

17 x 17(2)

12 x 18(2)

12 x 16 x 54(1)

8.56 x 2.63 x 11(1)

11 x 3.5 x 8.5(1)

15 x 50(1)

15 x 46.5(1)

40" to 60"(1)

8.5 x 0.25 x 12(1)

8.5 x 3.5 x 11(1)

11 x 0.38 x 9.5(1)

12 x 16 x 51(1)

Packing Type

Bottle(9)

Pump Bottle(5)

Spray Bottle(3)

Flip-Top Bottle(2)

Bottle with Dispensing Cap(1)

Sachet(1)

Overall Width

27"(4)

31.75"(3)

29"(2)

59"(2)

38.5"(2)

22"(2)

35.4"(2)

47.2"(2)

23.6"(2)

10.5"(1)

18.5"(1)

11.8"(1)

31"(1)

40.9"(1)

55.1"(1)

80.3"(1)

68.5"(1)

18"(1)

Overall Depth

0.16"(7)

6"(7)

5"(4)

23.75"(2)

22"(2)

16"(2)

9.5"(1)

11.8"(1)

1.49"(1)

5.8"(1)

14"(1)

14.5"(1)

Applicable Material

Aluminum; Glass; Granite; Marble; Plastic; Stainless Steel(1)

Ceramics; Enamel; Fiberglass; Finished/Sealed Wood; Glass; Laminates; Metal; Plaster; Plastic; Sealed/Engineered Stone; Vinyl(1)

Ceramics; Enamel; Fiberglass; Finished/Sealed Wood; Glass; Grout; Laminates; Metal; Plastic; Sealed/Engineered Stone; Vinyl(1)

Ceramics; Enamel; Fiberglass; Glass; Grout; Laminates; Metal; Plastic; Sealed/Engineered Stone; Vinyl(1)

Skin(1)

Application

Aisles; Entryways; Foyers; Hallways; Restrooms; Workstations(7)

Hand(6)

Disinfectant/Cleaner(3)

All Surfaces(1)

Personal Care(1)

Color Family

Silver(2)

Clear(1)

Physical Form

Liquid(4)

Read-Out Type

Digital(2)

Series Name

MasterVision Protector Series(9)

Personal Space Divider(2)

GoSafe(1)

Special Features

White(4)

Full Shield(4)

With Pass Thru(3)

Blue Mask(2)

Maintain 6 Feet Thank You(2)

Classic Image-Loads from the bottom.(2)

Pink Mask(2)

Blue(2)

Includes One Pump per Carton(1)

Includes Pump on Each Bottle(1)

Black Mask(1)

Black(1)

Full Shield with Feet(1)

Wear A Mask(1)

Stop Wash Your Hands(1)

Classic Image-Literature slides in from the side.(1)

Maintain Social Distance Stand Here(1)

Maintain 6 Feet Apart(1)

Wash Your Hands(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved

Powered by SITS Erp