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_36` 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 (`manufacturer_id` = "1700002") 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

Manufacturer

3M

Refine Search

  GO
 
Category

Adhesive Note Pads(175)

Transparent & Invisible Tapes(69)

Packaging Tapes(66)

Privacy Filters(61)

Flags(51)

Sponges & Scouring Pads(50)

Masking Tapes(43)

Hooks & Hangers(34)

Dry-Erase Boards(31)

Hearing Protection(29)

Floor & Carpet Cleaner Accessories(25)

Mounting Tapes(25)

Laminating Supplies(24)

Eye Protection(22)

Tape Dispensers(19)

Easel Pads(15)

Double-Sided Tapes(14)

Packaging Tape(13)

Top Tab Accessories(13)

Index Tabs & Page Markers(13)

Glare/Radiation Filters(12)

Bandages & Wraps(12)

Safety Masks(12)

Tapes(12)

Notes Holders / Dispensers(12)

Mops & Mop Refills(11)

Keyboard/Mouse Platforms & Trays(9)

Duct Tapes(9)

Laminating Machines(9)

Mouse & Keyboard Wrist Rests(8)

Lint Rollers(8)

Filament Tape(8)

Flag/Tab Dispensers(7)

Safety Tapes(7)

Packing List/Invoice Enclosed Envelopes(7)

Cork/Fabric Bulletin Boards(6)

Scissors(5)

Air Respirator Accessories(5)

Light Bulbs & Tubes(5)

Mouse Pads(5)

Book Tapes(5)

Mailing Tubes(5)

Safety Helmets(5)

Monitor Stands/Risers(4)

Super Glues(4)

Glue Rollers(4)

Coat/Garment Hooks(4)

Glue Sticks & Pens(4)

Cable Management(4)

Multipurpose Cleaners(4)

Desktop Organizers(4)

Monitor Arms(4)

Paper Pads/Note Pads(3)

Signs & Sign Holders(3)

Laptop Stands & Pads(3)

Spray Adhesives(3)

Display Boards(3)

Correction Tapes(3)

Desktop Copyholders(3)

Filing Labels & Systems(3)

Protectors(3)

Mice(2)

Janitorial Cloths & Wipes(2)

Copyholders(2)

Safety Vests(2)

Cleaning Wipes(2)

Shipping Tape Dispensers(2)

Data Index Dividers(2)

Wound Care(2)

First Aid Kits & Supplies(2)

Board Erasers(2)

Dust Mop Frames(2)

Tab Inserts(2)

Medical File Tabs & Index Dividers(2)

Telephone Message Books & Pads(2)

Water Filters & Purifying Dispensers(2)

Spot & Stain Removers(2)

All-Purpose Glues(2)

Electrical Tapes(2)

Fabric Protectors(2)

Easel Boards(1)

Letter, Legal & Jr. Pads(1)

Wrist Supports(1)

Foot Rests(1)

Outdoor Mats(1)

Binder Clips(1)

Cleaning Equipment Parts & Accessories(1)

Hanging Accessories(1)

Tape Dispenser Replacement Cores(1)

Brooms & Sweepers(1)

Combination Bulletin/Dry-Erase Boards(1)

Name Badge Holders(1)

Photo Tape(1)

Electronic Cleaners/Anti-Static Sprays(1)

Postal Wraps(1)

Mounting Putty(1)

Safety/Caution Signs(1)

Foil & Wraps(1)

Bubble Wraps(1)

Safety Gear(1)

Furniture Covers(1)

Shipping & Moving Boxes(1)

Pen-Style Highlighters(1)

Multimedia Headphones(1)

Computer Cloths/Wipes & Dusters(1)

Cleaning Sheets(1)

Cleaning Kits(1)

Label Tapes(1)

Drawer Organizers(1)

Flag Pens(1)

Specialty Cleaners/Lubricants(1)

CPU Stands(1)

 
Brand

3M(311)

Post-it®(290)

Scotch(284)

Scotch-Brite(54)

Command(52)

Highland(23)

Post-it®(19)

E-A-R(15)

Tartan(11)

Nexcare(10)

Scotchgard(7)

Ace(6)

Peltor(6)

Tekk Protection(5)

ScotchBlue(4)

O-Cel-O(3)

Post-it Notes Super Sticky(3)

Filtrete(2)

Aearo(2)

Scotch Magic(1)

Futuro(1)

 
Color

Clear(219)

Black(150)

Assorted(121)

White(111)

Yellow(75)

Matte(50)

Canary Yellow(47)

Green(46)

Blue(42)

Tan(38)

Matte Clear(37)

Red(34)

Silver(22)

Gray(19)

Multicolor(18)

Orange(18)

Pink(17)

Aqua(15)

Purple(12)

Clear Lens(10)

Translucent(8)

Brown(7)

Gold(7)

Lime(7)

Beige(6)

Glossy(6)

Bright Green(5)

Neon Yellow(4)

Bright Assorted(3)

Black Frame(3)

Clear Hook(3)

Transparent(3)

Bright Blue(3)

Cream(3)

Pastel(2)

Charcoal(2)

Periwinkle(2)

Clear Temple(2)

Nickel(2)

Silver Stripe(2)

Slate Blue(2)

Metallic Silver(2)

Mint(2)

Limeade(2)

Aqua Wave(2)

Electric Blue(2)

Assorted Pastel(2)

Clear Strip(2)

Smoke(1)

Gray Frame(1)

Clear Frame(1)

Bronze(1)

Charcoal Gray(1)

Blue Stem(1)

Orchid(1)

Rose(1)

Black/Green(1)

Black Temple(1)

Maroon(1)

Mulberry(1)

Gray Lens(1)

Neptune Blue(1)

Neon Pink(1)

Tan Tint(1)

Primary Red(1)

Bright Pink(1)

Slate(1)

Black Lens(1)

Natural(1)

Primary Green(1)

Tangerine(1)

Ebony(1)

Matte Light Green(1)

Lavender(1)

Metallic Black(1)

Lemon Lime(1)

Copper(1)

Electric Yellow(1)

 
Size

5" Width(2)

8" Width(1)

Medium (M)(1)

1/2" x 36 yds(1)

Medium(1)

 
Size Supported

3" Width x 3" Length Note(12)

4" Width x 4" Length Note(1)

1" Length Flag(1)

1" Width x 1.75" Length(1)

1" Width x 1.75" Length Flag(1)

 
Recycled

No(852)

Yes(58)

 
Sheet Size

25" x 30"(13)

20" x 23"(6)

22" x 22"(1)

9" Width x 11" Length(1)

15" x 15"(1)

5" Width x 4" Length(1)

5 7/8" Width x 3 7/8" Length(1)

11" x 11"(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved