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_38` 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','out_of_stock') 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

Monitor Filters(87)

Floor Mats(43)

Floor Pads(33)

Mouse Pads & Wrist Rests(30)

Tapes(28)

Respirators(28)

Ear Plugs(19)

Privacy Filters(18)

Cleaners & Detergents(17)

Mobile Device Accessories(16)

Keyboard Drawers/Platforms(15)

Boards(14)

Eye Protection(13)

Respirator Cartridges & Filters(10)

Safety Glasses(10)

Masking Tapes(7)

Copyholders(6)

AV Mounts, Arms & Hardware(6)

Desktop Stands(6)

Safety Tapes(6)

Safety Masks(6)

Dry-Erase Boards(5)

Safety Cones(5)

Dusters(5)

Glare/Radiation Filters(5)

Hearing Protection(5)

Ear Muffs(4)

Dust Mop Frames(4)

Duct Tapes(3)

Safety Helmets(3)

Hard Hats(3)

Laminator Supplies(3)

Sponges & Scouring Pads(3)

Scouring Pads/Sticks(3)

Sorbents(3)

Stethoscopes(3)

Packing List/Invoice Enclosed Envelopes(3)

Towels & Wipes(3)

Mice(2)

Light Bulbs(2)

Safety Headgear Accessories(2)

Lamps(2)

Packing Tape(2)

Scrub Pad Holders(2)

Adhesives/Glues(2)

CPU Stands(1)

Apparel(1)

Janitorial Cloths & Wipes(1)

Envelopes/Mailers(1)

Desks(1)

Workstations/Computer Desks(1)

Multimedia Headphones(1)

Air Cleaner Machines(1)

Desktop Supplies Organizers(1)

Multipurpose Cleaners(1)

Mops & Mop Refills(1)

Adhesive Corner(1)

Laptop Stands & Pads(1)

Sponges(1)

Paper Pads/Note Pads(1)

Board Erasers(1)

Photo Tape(1)

Footrests(1)

Mops(1)

Duster Refills(1)

Mop Heads(1)

Safety Vests(1)

 
Brand

3M(506)

Tekk Protection(3)

Peltor(3)

Scotch-Brite(2)

3M Safety-Walk(1)

E-A-R(1)

Scotch(1)

 
Color

Black(46)

Matte(19)

Clear(12)

Glossy(12)

White(9)

Tan(7)

Clear Lens(6)

Yellow(6)

Gray(3)

Silver(3)

Orange(2)

Black Frame(2)

Green(2)

Blue(2)

Black Temple(1)

Brown(1)

Gray Lens(1)

Gold(1)

Multicolor(1)

Beige(1)

Silver Stripe(1)

Slate Blue(1)

Pink(1)

Clear Frame(1)

Black/Green(1)

 
Brightness

415 lm(1)

760 lm(1)

 
Recycled

No(61)

 
Height

1"(21)

11.87"(5)

7.62"(5)

10.56"(5)

1/8"(4)

1/2"(4)

12.75"(4)

11.68"(4)

11.31"(4)

27"(4)

0.75"(4)

3/4"(4)

3"(4)

10.06"(3)

13.37"(3)

0.12"(2)

0.03"(2)

28"(2)

11.62"(2)

7"(2)

11.81"(2)

12.87"(2)

11.37"(2)

11.75"(2)

6.87"(2)

11"(2)

12.12"(2)

7.06"(2)

18"(2)

10.68"(2)

14"(2)

12"(2)

16 3/4"(2)

7.64"(2)

6.89"(2)

9.31"(2)

6.14"(2)

10.71"(1)

18.78"(1)

13.54"(1)

13.12"(1)

10.37"(1)

9.84"(1)

12.37"(1)

12.18"(1)

21.81"(1)

9.09"(1)

11.43"(1)

5 11/16"(1)

14.33"(1)

10 1/8"(1)

8.2"(1)

8.50"(1)

13.62"(1)

15.56"(1)

12.56"(1)

4.74"(1)

9.06"(1)

7.93"(1)

35.4"(1)

13.4"(1)

2"(1)

3/10"(1)

17"(1)

15.4"(1)

15.79"(1)

13.50"(1)

1.625"(1)

10.93"(1)

4.87"(1)

8.46"(1)

14 1/2"(1)

10.55"(1)

11.69"(1)

11.30"(1)

11.5"(1)

8"(1)

6"(1)

1.6"(1)

9.75"(1)

10"(1)

5.3"(1)

4" to 4 3/4"(1)

6.81"(1)

11.66"(1)

8 3/8"(1)

10.35"(1)

8.18"(1)

9"(1)

7.5"(1)

8 7/16"(1)

7 1/4"(1)

6.5"(1)

16"(1)

8.75"(1)

0.5"(1)

17.5"(1)

18.5"(1)

25.56"(1)

20.75"(1)

4 1/2"(1)

8.1"(1)

 
Color(s)

Black(53)

Yellow(17)

White(16)

Brown(15)

Blue(12)

Gray(10)

Orange(10)

Silver(7)

Clear(6)

Tan(6)

Red(4)

Green(4)

Pink(3)

Black/Clear(3)

Coral(3)

Pink/Yellow/Green(3)

Black/Gray(3)

#REF!(3)

Yellow/Red(2)

Horizon Blue(2)

Blue/Tan(2)

Natural(2)

Ebony(2)

Black/Silver Clip(2)

Black/Silver(2)

Green/Black(1)

Silver/Black(1)

Black/Gray/Silver(1)

Light Gray(1)

Gray/Black(1)

Black/White(1)

Pink/Gray(1)

Maroon(1)

Sky Blue(1)

Beige; Black(1)

Black; Red(1)

Charcoal Gray(1)

Granite(1)

Mocha(1)

Black/Yellow(1)

Chestnut Brown(1)

Slate Gray(1)

Blue/Yellow(1)

Yellow/Blue(1)

Slate Blue(1)

Off-White(1)

White/Amber(1)

Green/Amber(1)

Aqua(1)

Yellow/Black(1)

 
Depth

8"(7)

2.75"(6)

12"(4)

6.75"(4)

8 3/5"(3)

13"(3)

2"(2)

7"(2)

6 3/4"(2)

3"(2)

3 15/16"(2)

10.6"(2)

4.6"(2)

9"(2)

2.5"(1)

2 3/4"(1)

2.37"(1)

6.2"(1)

11.375"(1)

8.75"(1)

1"(1)

0.08"(1)

4.3"(1)

11"(1)

11 1/2"(1)

4.25"(1)

4"(1)

5.5"(1)

12 3/4"(1)

5 1/2"(1)

 
Quantity

1 each(1)

10 per case(1)

100 per carton(1)

 
Size

0.75" x 66 ft(8)

One Size Fits All(8)

Medium(6)

Large(6)

Standard(6)

48 mm x 54.8 m(3)

Small(2)

2.5" x 2"(1)

3.2"w x 4.12"d x 5"h(1)

8.5" x 100 ft(1)

25" x 250 ft(1)

10" x 4 5/8"(1)

12" x 100 ft(1)

1" x 36 yds(1)

3/4" x 66 ft(1)

1.5" x 44 ft(1)

4 5/8" x 10"(1)

5.2" x 4.05"(1)

 
Packing Type

Bottle(11)

Aerosol(5)

Box(2)

Bag(1)

Spray Bottle(1)

Roll - Box(1)

Spray Can(1)

 
Overall Width

4.5"(2)

5"(2)

4 1/2"(1)

33"(1)

 
Overall Depth

21.25"(2)

19.5"(1)

25 1/2"(1)

25.5"(1)

5.75"(1)

 
Closure

Self-Adhesive(1)

 
Diameter

20"(7)

19"(5)

17"(5)

21"(4)

13"(3)

12"(2)

18"(2)

27"(2)

14"(1)

16"(1)

15"(1)

10"(1)

2"(1)

4.05"(1)

 
Base Color

Black(1)

White(1)

 
Opening

Open Side(1)

 
 
 

© 2020-2021 NBJ Form & Function Inc. , All Rights Reserved