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 (`brand_id` = "10628") 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 '%3M' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('3M' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+3M' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"3M"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"3M"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"3M"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"3M"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+3M' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='3M',`category_4` ='3M') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE '3M,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('3M', `pinfo`.`desc_title`)) DESC

Currently Filtered by


3M

Refine Search

  GO
 
Category Filter

Privacy Filters(67)

Eye Protection(13)

Glare/Radiation Filters(12)

Hearing Protection(12)

Safety Masks(8)

Mouse & Keyboard Wrist Rests(6)

Air Respirator Accessories(5)

Duster Refills(5)

Monitor Filters(4)

Safety Tapes(4)

Multipurpose Cleaners(4)

Cork/Fabric Bulletin Boards(3)

Respirators(3)

Keyboard/Mouse Platforms & Trays(3)

Safety Helmets(3)

Copyholders(3)

Monitor Arms(3)

Desktop Copyholders(3)

Packing List/Invoice Enclosed Envelopes(2)

Monitor Stands/Risers(2)

Screens & Filters(2)

Duct Tapes(2)

Dust Mop Frames(2)

Mouse Pads(1)

Mounting Kits(1)

Laptop Stands & Pads(1)

Easel Pads(1)

Sponges & Scouring Pads(1)

Tapes(1)

Laminating Machines(1)

Cleaning Wipes(1)

Towels & Wipes(1)

Workstations/Computer Desks(1)

Board Erasers(1)

Photo Tape(1)

Adhesive Corner(1)

Safety Gear(1)

Keyboard Drawers/Platforms(1)

Safety/Caution Signs(1)

Computer Cloths/Wipes & Dusters(1)

CPU Stands(1)

Mops & Mop Refills(1)

Mice(1)

Laminating Supplies(1)

Adhesive Note Pads(1)

Multimedia Headphones(1)

 
Brand

3M(179)

E-A-R(5)

Peltor(4)

Tekk Protection(3)

Scotch(1)

Aearo(1)

Post-it®(1)

 
Color

Black(91)

Matte(41)

Glossy(37)

Clear(22)

White(18)

Yellow(13)

Gold(13)

Silver(10)

Clear Lens(7)

Gray(6)

Pink(4)

Orange(3)

Clear Temple(2)

Aqua(2)

Blue(2)

Multicolor(2)

Brown(1)

Green(1)

Gray Lens(1)

Red(1)

Neon Yellow(1)

Gray Frame(1)

Black Frame(1)

 
Recycled

No(77)

Yes(5)

 
Height

7.64"(7)

11.77"(5)

11.30"(5)

10.55"(5)

6.89"(4)

11.69"(4)

3.4"(4)

11.57"(3)

13.27"(3)

12.80"(3)

3"(3)

6.14"(3)

0.8"(3)

11.65"(2)

8.74"(2)

11.89"(2)

4"(2)

9.33"(2)

8"(2)

10.04"(2)

1"(2)

14.33"(1)

13.54"(1)

21.81"(1)

12.13"(1)

9.84"(1)

12.36"(1)

10.31"(1)

18.78"(1)

13.11"(1)

12.09"(1)

13.90"(1)

2"(1)

13.62"(1)

9.09"(1)

7.05"(1)

5.71"(1)

8.50"(1)

12.56"(1)

5.67"(1)

35.4"(1)

13.50"(1)

15.79"(1)

13.19"(1)

17"(1)

24"(1)

2.8"(1)

12.1"(1)

5.3"(1)

6.85"(1)

6.87"(1)

0.9"(1)

23"(1)

3.2"(1)

18"(1)

8.46"(1)

12.76"(1)

10.06"(1)

11.75"(1)

7.24"(1)

7.87"(1)

8.35"(1)

10.67"(1)

6.5"(1)

0.7"(1)

10.3"(1)

13.9"(1)

5.8"(1)

5.5"(1)

10.93"(1)

 
Color(s)

White(2)

 
Depth

12"(3)

4.6"(2)

2"(2)

10.6"(2)

9"(1)

6.2"(1)

6"(1)

8.5"(1)

2.5"(1)

14.1"(1)

10.5"(1)

3"(1)

10"(1)

5.5"(1)

5"(1)

 
Size

5" Width(3)

Standard(2)

One Size Fits All(1)

1" x 36 yds(1)

8" Width(1)

 
 
 

© 2020-2021 Crawford Office Supply, All Rights Reserved