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 ('CF902959','CF9025241','CF902524','CF900963','CF900962','CF900960','CF0980','CF0920','CF091200','CF0680','CF0620','CF061200','CF0480','CF0420','CF041200','CF0180','CF0120','CF011200','TCR77548','TCR77547','TCR77546','TCR77545','TCR77544','TCR77539','TCR77538','TCR77537','TCR77536','TCR77535','TCR77534','TCR77533','TCR77532','TCR77531','TCR77530','TCR77513','TCR77512','TCR77511','TCR77510','TCR77509','TCR77508','TCR77507','TCR77506','TCR77503','TCR77502','TCR77501','TCR77500','TCR77499','SPZ10111','FDP12931CL','FDP12930CL','FDP12929CL','MOR66347','SAF7503CL','SAF7565BL','R90052','BIB8797SS','WD991791','WD991789','WD991788','WD991787','WD991782','WD991764','WD991763','BIBTT8680','BIB8683','BIB8682','QRTWPS1000','QRT773630','6630MB','WPS1000','WPS2000','SB93513Q','QRTSB93513Q','HW300000','HW30LAV2228S3D','HW30LAV2228B3D','HW30KIOSK900WOOD','HW30KIOSK900DG','HW30PTDHS','GBC1703079','GBC3200717','GBC3200716','GBC3200715','GBC3200599','GBC3745003','QRTGDP186','QRTGDP186B','QRTG29648W','QRTG27248W','QRTG24836W','QRTG22418W','QRTG23624W','AVASPS25','AVASPA25W','CMPJNSMHYKT','CMPJNSMHAKT','CMPJMPMHAKT','CMPJMPMEYKT','CMPJMPMEAKT','CMPJNSMEYKT','CMPJNSMEAKT','9084','9083','WEB300','CB30','CEPOLC1','CEPCS700CLR','CEPCS7CLRDBL','CEPKT1B','CEPLWPSTC','CEPBBPSTC','CEPFTT732USB','CEPFTT732','CEPFTT726UV','CEPFTT724USB','CEPFTT724','CEPFTT718UV','CEPFTT706UV','CEPFTT706','CEPFTT700W','CEPFTT700','CEPFTTUV','CEPSCC202','CEPSCC200','CEPSCC102','CEPSCC100','CEPSANCC4068','DW260002','DW260001','DW260000','DW4801M','CEPCS7CLR','CEPSNK201','CEPSNK200','CEPSNK101','CEPSNK100','KD1509','KD1524','ZF2','ZP2','ZP4','SAF7515CL','BNBCHRCHGYBLBT','BNBCHRCHGYPRBT','SAF4755BL','SAF4755BU','FEL8032001','FEL8036601','MMMLX500','FEL0009901','VCTDCX760G','ERG24481003','LLR99531','SCXBFSL683','SCXBFSL685','SCXCFSL4011','SCXCFSL4013','SCXCFSL403','SCXCFSL405','SCXCFSL407','SCXCFSL409','SCXCFSL5011','SCXCFSL5013','SCXCFSL503','SCXCFSL505','SCXCFSL507','SCXCFSL509','SCXCFSL6011','SCXCFSL6011WBDX','SCXCFSL6013','SCXCFSL6013WBDX','SCXCFSL603','SCXCFSL603WBDX','SCXCFSL605','SCXCFSL605DG','SCXCFSL605WBDX','SCXCFSL607','SCXCFSL607WBDX','SCXCFSL609','SCXCFSL609WBDX','SCXCFSL6811','SCXCFSL6813','SCXCFSL683','SCXCFSL685','SCXCFSL687','SCXCFSL689','SCXCFSL7411','SCXCFSL7413','SCXCFSL743','SCXCFSL745','SCXCFSL747','SCXCFSL749','SCXCFSL8011','SCXCFSL8013','SCXCFSL803','SCXCFSL805','SCXCFSL807','SCXCFSL809','SCXCRD1','SCXCRD3','SCXCRDW1','SCXCRDW3','SCXCWM4011','SCXCWM4013','SCXCWM403','SCXCWM405','SCXCWM407','SCXCWM409','SCXCWM5011','SCXCWM5013','SCXCWM503','SCXCWM505','SCXCWM507','SCXCWM509','SCXCWM6011','SCXCWM6013','SCXCWM603','SCXCWM605','SCXCWM607','SCXCWM609','SCXCWM6811','SCXCWM6813','SCXCWM683','SCXCWM685','SCXCWM687','SCXCWM689','SCXCWM7411','SCXCWM7413','SCXCWM743','SCXCWM745','SCXCWM747','SCXCWM749','SCXCWM8011','SCXCWM8013','SCXCWM803','SCXCWM805','SCXCWM807','SCXCWM809','SCXHFSL6011','SCXHFSL6013','SCXHFSL603','SCXHFSL605','SCXHFSL607','SCXHFSL609','SCXHFSL7411','SCXHFSL7413','SCXHFSL743','SCXHFSL745','SCXHFSL747','SCXHFSL749','SCXWPD40','SCXWPD50','SCXWPD60','SCXWPD68','SCXWPD74','SCXWPD80','PBCTA2724P','PBCTPC2724P','PBCTA2724F','PBCTPC2724F','PBCTA3136P','PBCTPC3136P','PBCTA3136F','PBCTPC3136F','PBCTA3123B','PBCTPC3123B','LLR90276','LLR90277','LLR90278','LLR90279','LLR90280','LLR90281','LLR90272','LLR90271','LLR90273','LLR90274','LLR90275','BSXP6048GYGY','BSXP6036GYGY','BSXP6030GYGY','BSXP6024GYGY','BSXQC180GY','BSXQC90GY','BSXTBASEGY','SCXCFSL6013DG','SCXCFSL6011DG','SCXCFSL607DG','PPRCR01X235','PPRCR01X200','SAF8511BL','SAF8511GR','LLR55630','QRTWPS2000','BLT74764','CSIBCHX','KD115','KD123','KD125','KD589','KOR121','KOR2112','KOR591','KOR1500','KOR3100','KOR3102','KOR4200','KOR7600','SAF2276BL','SAF4755OR','xsta7033','xsta7034','xsta7035','xsta7036','xsta7037','xsta7038','xsta7039','xsta7040','xsta7041','xsta7042','xsta7043','xsta7044','xsta7045','xsta7046','xsta7047','xsta7048','xsta7049','xsta7050','xsta7051','xsta7052','xsta7053','xsta7054','xsta7055','xsta7056','xsta7057','xsta7058','xsta16001','xsta16002','xsta5123','xsta5124','xsta22603','xsta79001','xsta79002','xsta79003','xsta79004','xsta79005','xsta79006','xsta79007','xsta79021','xsta79022','xsta79023','xsta79024','xsta79025','xsta79026','xsta47324','xsta89001','xsta89002','USSRD010','USSE4750','XST11363','XST1211','XST1359','XST1XPN10','XST1XPN12','XST1XPN13','XST1XPN14','XST1XPN16','XSTN14','XSTN27','PBCHA2424','PBCHPC2424','PBCHA2436','PBCHPC2436','PBCHA3624','PBCHPC3624','71745P','BIBMA11','TT9701','TT9702','FAO750013','PFI524275000','FAO7009','FAO21008','FAOFAE6022','HYGENXVRAY','SPLHSTORVPACC','ALP40010BLA','ALP40010CHR','ALP40010COP','ALP40020SSB','ALP400RECESS','ALP40420GRY','ALP421GRY','ALP4231','ALP423SSB','ALP480','ALPSGN30','ALPSGNB5','CEPSAN100','CEPSAN101','CEPSAN001','CEPSAN003','CEPSAN002','CEPSAN200','CEPSAN102','CEPHSD1','CEPHSD2','CEPCS700AC','CEPCS700SAN','CEPSANTUB1','CEPSAN005','CEPSAN400','CEPSAN401','SAF7517CL','SAF7517FR','SAF7517WH','SAF7515FR','SAF7515WH','SAF7516CL','SAF7516FR','SAF7516WH','LER4360','LER4361','LER4362','LER4364','LER6085','LER6086','LER6088','LER6089','LER6090','FLP97056','FLP97058','FLP97060','FLP97062','FLP97064','FLP97066','FLP97068','FLP97070','FLP97072','FLP97074','FLP97076','FLP97078','FLP97080','FLP97082','FLP97084','FLP97086','FLP97088','FLP97090','FLP97092','FLP97094','FLP97096','FLP97098','FLP97100','FLP97102','FLP97024','FLP97026','FLP97028','FLP97030','FLP97000','FLP97002','FLP97004','FLP97006','FLP97008','FLP97010','FLP97012','FLP97014','FLP97016','FLP97018','FLP97020','FLP97022','FLP97044','FLP97046','FLP97036','FLP97038','FLP97048','FLP97050','FLP97040','FLP97042','FLP97052','FLP97054','CEPDIVFLR','CEPDIVL','CEPDIVRECT','CEPDIVU','CEPDIVX','WAL5606','WAL5607','WAL5705','WAL5667','WAL5668','WAL5669','WAL5626','WAL5627','WAL5646','WAL5647','WAL5701','WAL5700','WAL5691','WAL5692','WAL5693','WAL5686','WAL5687','WAL5680','KORFP9502','KORFP9605','KORFP9201','KORIRT3003','KORHS6001','KORDBP3004','CMPJGM1A','CMPJGM1Y','CMPMPMGA','CMPMPMGY','JON1369JC','JON1367JC','JON1375JC','JON9823JC','JON9824JC','JON9827JC','JON9828JC','JON9829JC','JON9834JC','JON9832JC','JON9833JC','JON9835JC','JON7082YT','TTWASH','')) 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 ('Covid19' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Covid19' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Covid19"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Covid19"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Covid19"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Covid19"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Covid19' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Covid19',`category_4` ='Covid19') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Covid19,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Covid19', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Covid19

Covid19

Refine Search

  GO
Category Filter

Stickers(22)

Partition & Panel Systems(17)

Carts & Organizers(14)

Hand Sanitizer Accessories(10)

Barriers(10)

Face Masks(7)

Hand Dryers(6)

Stamps(6)

Laminator Supplies(5)

Puzzles(5)

Desktop Stands(3)

Boards(3)

Soap Dispensers(3)

Classroom Management(3)

First Aid Kit Refills(3)

Partition & Panel Systems Hardware(3)

Resin Chairs(2)

Toasters/Toaster Ovens(2)

Hand Sanitizers(2)

Desks(2)

Chairs/Stools(2)

Cleaning tools(2)

Soft Seating(2)

Art & Craft Kits(2)

Stands(2)

Mouthwash(1)

Safety Center Kit(1)

CPR Masks(1)

Personal Soaps(1)

Classroom Theme(1)

Carts(1)

Accessories(1)

Supply Kits(1)

Teacher Resource(1)

Maintenance & Breakroom(1)

Laminators(1)

Other(1)

Towel Dispensers(1)

Apparel(1)

Brand

Safco(12)

HON(7)

GBC(6)

Quartet(5)

Xstamper(5)

First Aid Only(4)

Fellowes(3)

Trodat(1)

Special Buy(1)

3M(1)

Champion Sports(1)

Ergotron(1)

Johnson & Johnson(1)

Color

Gray(7)

White(4)

Clear(4)

Frosted(3)

Translucent Clear/Silver(2)

Gray/White(1)

Black/White(1)

Blue|0000FF(1)

White/Silver(1)

Black|000000(1)

Orange|FFA500(1)

Height

4.25"(1)

Color(s)

Clear(6)

Black/Silver(2)

Black(1)

Width

9"(5)

13"(1)

19.88"(1)

19 7/8"(1)

15 1/8"(1)

Depth

13"(1)

5.75"(1)

14 1/16"(1)

11 3/8"(1)

Size

9 x 11.5(5)

Packing Type

Pump Bottle(1)

Packet(1)

Overall Width

23.5"(3)

47.5"(3)

59.5"(3)

36"(2)

42"(2)

38"(1)

30"(1)

48"(1)

24"(1)

Overall Depth

2.5"(9)

21.5"(2)

64"(1)

48"(1)

Flavor

Cool Mint(1)

Ink Color(s)

Black; Blue; Green; Red; Violet(5)

Black; Blue; Red; Blue/Red(1)

Base Color

Silver(1)

Gray(1)

Color Family

White(2)

Gray(1)

Keyboard Platform Dimensions

32 x 12(1)

Layouts Available

324(1)

800(1)

323(1)

Product Name

COVID PPE Back-to-Work Kit(1)

Series Name

HON Verse´ Series(4)

Safco Impromptu(2)

Safco Runtz Series(1)

Special Features

Clear-Allows face-to-face interactions while helping limit physical contact.(3)

Frosted-Balance bolstered privacy with allowing more light into the workspace.(3)

White-For privacy.(3)

Three-Panel Display System(1)

Adjusts from 4" to 6"(1)

For Unitized and First Aid Stations(1)

Adjusts from 4" to 6 1/2"(1)

Assembles in less than 60 seconds. Includes student-friendly features: a hook to hang a backpack; cup holder, tablet slot and pencil tray integrated into the worksurface.(1)

Worksurface Platform Dimensions

32 x 8(1)

24w x 22d(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved