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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` 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 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

Manufacturer

Currently Filtered by

Manufacturer

3m

Refine Search

  GO
Category

Adhesive Note Pads(158)

Privacy Filters(77)

Transparent & Invisible Tapes(58)

Packaging Tapes(56)

Flags(50)

Sponges & Scouring Pads(30)

Hooks & Hangers(24)

Dry-Erase Boards(21)

Hearing Protection(20)

Mounting Tapes(19)

Tape Dispensers(19)

Eye Protection(19)

Easel Pads(17)

Floor & Carpet Cleaner Accessories(16)

Index Tabs & Page Markers(13)

Laminating Supplies(13)

Masking Tapes(13)

Glare/Radiation Filters(12)

Bandages & Wraps(11)

Notes Holders / Dispensers(11)

Double-Sided Tapes(11)

Top Tab Accessories(11)

Safety Masks(10)

Packaging Tape(10)

Keyboard/Mouse Platforms & Trays(9)

Laminating Machines(9)

Adhesive Corner(9)

Flag/Tab Dispensers(7)

Mops & Mop Refills(6)

Safety Tapes(6)

Mouse & Keyboard Wrist Rests(6)

Filament Tape(6)

Packing List/Invoice Enclosed Envelopes(5)

Air Respirator Accessories(5)

Cork/Fabric Bulletin Boards(5)

Monitor Arms(5)

Glue Rollers(4)

Multipurpose Cleaners(4)

Lint Rollers(4)

Desktop Organizers(4)

Coat/Garment Hooks(4)

Cable Management(4)

Mailing Tubes(4)

Safety Helmets(3)

Protectors(3)

Copyholders(3)

Book Tapes(3)

Spray Adhesives(3)

Display Boards(3)

Duct Tapes(3)

Correction Tapes(3)

Medical File Tabs & Index Dividers(2)

Data Index Dividers(2)

Laptop Stands & Pads(2)

Board Erasers(2)

Dust Mop Frames(2)

First Aid Kits & Supplies(2)

Tab Inserts(2)

Shipping Tape Dispensers(2)

Wound Care(2)

Water Filters & Purifying Dispensers(2)

Desktop Copyholders(2)

Fabric Protectors(2)

Telephone Message Books & Pads(2)

Monitor Stands/Risers(2)

Mice(1)

Photo Tape(1)

Signs & Sign Holders(1)

Workstations/Computer Desks(1)

Cleaning Wipes(1)

Mouse Pads(1)

Easel Boards(1)

Spot & Stain Removers(1)

Name Badge Holders(1)

Bathroom Cleaners(1)

Binder Clips(1)

Safety Gear(1)

All-Purpose Glues(1)

Mounting Putty(1)

Electrical Tapes(1)

Pen-Style Highlighters(1)

Tape Dispenser Replacement Cores(1)

Flag Pens(1)

Glue Sticks & Pens(1)

Safety/Caution Signs(1)

Electronic Cleaners/Anti-Static Sprays(1)

Computer Cloths/Wipes & Dusters(1)

CPU Stands(1)

Drawer Organizers(1)

Cleaning Equipment Parts & Accessories(1)

Multimedia Headphones(1)

Super Glues(1)

Combination Bulletin/Dry-Erase Boards(1)

Brand

Post-it®(296)

3M(242)

Scotch(208)

Command(44)

Scotch-Brite(33)

E-A-R(10)

Tartan(9)

Nexcare(9)

Ace(6)

Scotchgard(6)

Peltor(5)

Tekk Protection(5)

Highland(4)

ScotchBlue(3)

O-Cel-O(2)

Aearo(2)

Filtrete(2)

Scotch Magic(1)

Color

Clear(169)

Black(134)

Assorted(109)

White(83)

Yellow(60)

Matte(60)

Canary Yellow(42)

Green(38)

Blue(36)

Red(29)

Matte Clear(25)

Multicolor(18)

Glossy(18)

Tan(17)

Pink(15)

Orange(15)

Silver(14)

Gray(13)

Aqua(13)

Clear Lens(10)

Gold(10)

Translucent(7)

Lime(7)

Purple(6)

Bright Green(5)

Beige(4)

Bright Blue(3)

Black Frame(3)

Clear Hook(3)

Clear Temple(2)

Nickel(2)

Mint(2)

Periwinkle(2)

Clear Strip(2)

Metallic Silver(2)

Aqua Wave(2)

Light Blue(2)

Neon Yellow(2)

Cream(2)

Dark Blue(2)

Charcoal Gray(1)

Smoke(1)

Black Temple(1)

Neptune Blue(1)

Bronze(1)

Gray Frame(1)

Brown(1)

Rose(1)

Black/Green(1)

Gray Lens(1)

Mulberry(1)

Pastel(1)

Orchid(1)

Lavender(1)

Bright Assorted(1)

Tan Tint(1)

Black Lens(1)

Clear Frame(1)

Bright Pink(1)

Natural(1)

Transparent(1)

Neon Orange(1)

Neon Green(1)

Neon Pink(1)

Electric Blue(1)

Limeade(1)

Ebony(1)

Blue Stem(1)

Copper(1)

Metallic Black(1)

Electric Yellow(1)

Size

5" Width(2)

8" Width(1)

Medium(1)

Size Supported

3" Width x 3" Length Note(11)

4" Width x 4" Length Note(1)

1" Width x 1.75" Length Flag(1)

1" Width x 1.75" Length(1)

Recycled

No(706)

Yes(50)

Price Range

$0-$499.99(902)

$500-$999.99(11)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2018-2019 Granite Office, LLC, All Rights Reserved