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(148)

Packaging Tapes(56)

Flags(51)

Transparent & Invisible Tapes(48)

Privacy Filters(44)

Hooks & Hangers(24)

Dry-Erase Boards(22)

Sponges & Scouring Pads(20)

Hearing Protection(20)

Eye Protection(19)

Tape Dispensers(18)

Mounting Tapes(18)

Floor & Carpet Cleaner Accessories(16)

Easel Pads(14)

Laminating Supplies(13)

Masking Tapes(13)

Double-Sided Tapes(12)

Top Tab Accessories(12)

Index Tabs & Page Markers(11)

Notes Holders / Dispensers(11)

Bandages & Wraps(11)

Glare/Radiation Filters(10)

Packaging Tape(10)

Safety Masks(10)

Tapes(10)

Laminating Machines(9)

Keyboard/Mouse Platforms & Trays(9)

Flag/Tab Dispensers(7)

Cork/Fabric Bulletin Boards(6)

Filament Tape(6)

Packing List/Invoice Enclosed Envelopes(5)

Mops & Mop Refills(5)

Safety Tapes(5)

Air Respirator Accessories(5)

Coat/Garment Hooks(4)

Glue Rollers(4)

Desktop Organizers(4)

Mailing Tubes(4)

Mouse & Keyboard Wrist Rests(4)

Cable Management(4)

Monitor Arms(4)

Safety Helmets(3)

Paper Pads/Note Pads(3)

Desktop Copyholders(3)

Protectors(3)

Book Tapes(3)

Correction Tapes(3)

Monitor Stands/Risers(3)

Mouse Pads(3)

Display Boards(3)

Spray Adhesives(3)

Duct Tapes(2)

Signs & Sign Holders(2)

Multipurpose Cleaners(2)

Shipping Tape Dispensers(2)

Water Filters & Purifying Dispensers(2)

Lint Rollers(2)

Board Erasers(2)

Copyholders(2)

Medical File Tabs & Index Dividers(2)

Tab Inserts(2)

Wound Care(2)

Telephone Message Books & Pads(2)

First Aid Kits & Supplies(2)

Laptop Stands & Pads(2)

Data Index Dividers(2)

Name Badge Holders(1)

Cleaning Wipes(1)

CPU Stands(1)

Photo Tape(1)

Spot & Stain Removers(1)

Mice(1)

Safety Gear(1)

Dust Mop Frames(1)

Glue Sticks & Pens(1)

All-Purpose Glues(1)

Combination Bulletin/Dry-Erase Boards(1)

Easel Boards(1)

Fabric Protectors(1)

Tape Dispenser Replacement Cores(1)

Electrical Tapes(1)

Binder Clips(1)

Flag Pens(1)

Super Glues(1)

Drawer Organizers(1)

Electronic Cleaners/Anti-Static Sprays(1)

Boards(1)

Multimedia Headphones(1)

Pen-Style Highlighters(1)

Mounting Putty(1)

Safety/Caution Signs(1)

Computer Cloths/Wipes & Dusters(1)

Brand

Post-it®(265)

3M(203)

Scotch(196)

Command(44)

Post-it®(19)

Scotch-Brite(19)

E-A-R(10)

Nexcare(9)

Tartan(9)

Ace(6)

Tekk Protection(5)

Peltor(5)

Scotchgard(5)

Highland(4)

ScotchBlue(3)

Post-it Notes Super Sticky(3)

Aearo(2)

Filtrete(2)

Scotch Magic(1)

Post-it(1)

O-Cel-O(1)

Color

Clear(156)

Black(110)

Assorted(109)

White(76)

Yellow(54)

Canary Yellow(42)

Matte(39)

Blue(34)

Red(29)

Green(29)

Matte Clear(22)

Tan(17)

Multicolor(15)

Pink(15)

Gray(13)

Orange(13)

Silver(13)

Aqua(12)

Clear Lens(10)

Translucent(7)

Lime(7)

Purple(6)

Gold(5)

Bright Green(5)

Beige(4)

Bright Blue(3)

Clear Hook(3)

Black Frame(3)

Clear Temple(2)

Glossy(2)

Mint(2)

Periwinkle(2)

Metallic Silver(2)

Clear Strip(2)

Neon Yellow(2)

Cream(2)

Aqua Wave(2)

Nickel(2)

Charcoal Gray(1)

Gray Frame(1)

Neptune Blue(1)

Smoke(1)

Black Temple(1)

Mulberry(1)

Rose(1)

Black/Green(1)

Brown(1)

Gray Lens(1)

Pastel(1)

Bronze(1)

Orchid(1)

Neon Pink(1)

Black Lens(1)

Bright Assorted(1)

Bright Pink(1)

Clear Frame(1)

Transparent(1)

Natural(1)

Tan Tint(1)

Copper(1)

Electric Blue(1)

Limeade(1)

Blue Stem(1)

Ebony(1)

Metallic Black(1)

Lavender(1)

Electric Yellow(1)

Size

5" Width(2)

8" Width(1)

1/2" x 36 yds(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(596)

Yes(51)

Price Range

$0-$499.99(811)

$500-$999.99(8)

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