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

Packaging Tapes(53)

Flags(51)

Privacy Filters(46)

Transparent & Invisible Tapes(46)

Sponges & Scouring Pads(26)

Hooks & Hangers(24)

Dry-Erase Boards(22)

Tape Dispensers(20)

Mounting Tapes(17)

Floor & Carpet Cleaner Accessories(16)

Hearing Protection(16)

Easel Pads(13)

Notes Holders / Dispensers(13)

Eye Protection(13)

Bandages & Wraps(12)

Double-Sided Tapes(12)

Top Tab Accessories(12)

Packaging Tape(11)

Masking Tapes(11)

Laminating Supplies(10)

Safety Masks(10)

Keyboard/Mouse Platforms & Trays(9)

Index Tabs & Page Markers(8)

Cork/Fabric Bulletin Boards(7)

Filament Tape(7)

Packing List/Invoice Enclosed Envelopes(6)

Mops & Mop Refills(6)

Laminating Machines(5)

Air Respirator Accessories(5)

Glue Rollers(4)

Desktop Organizers(4)

Lint Rollers(4)

Screen Protectors(4)

Mailing Tubes(4)

Flag/Tab Dispensers(4)

Multipurpose Cleaners(4)

Coat/Garment Hooks(4)

Safety Tapes(4)

Mouse & Keyboard Wrist Rests(4)

Cable Management(4)

Display Boards(3)

Duct Tapes(3)

Desktop Copyholders(3)

Safety Helmets(3)

Protectors(3)

Spray Adhesives(3)

Correction Tapes(3)

Letter, Legal & Jr. Pads(3)

Monitor Stands/Risers(3)

Monitor Arms(3)

Book Tapes(3)

Tab Inserts(3)

Cleaning Wipes(2)

Copyholders(2)

Shipping Tape Dispensers(2)

First Aid Kits & Supplies(2)

Telephone Message Books & Pads(2)

Mouse Pads(2)

Data Index Dividers(2)

Board Erasers(2)

Safety Gear(2)

Dust Mop Frames(2)

Fabric Protectors(2)

Medical File Tabs & Index Dividers(2)

Wound Care(2)

Glue Sticks & Pens(2)

Mice(1)

Name Badge Holders(1)

Signs & Sign Holders(1)

Laptop Stands & Pads(1)

Tapes(1)

Plain Tab Index Dividers(1)

Flag Pens(1)

All-Purpose Glues(1)

Combination Bulletin/Dry-Erase Boards(1)

Electrical Tapes(1)

Easel Boards(1)

Tape Dispenser Replacement Cores(1)

Pen-Style Highlighters(1)

Electronic Cleaners/Anti-Static Sprays(1)

Computer Cloths/Wipes & Dusters(1)

Drawer Organizers(1)

Super Glues(1)

Mounting Putty(1)

Multimedia Headphones(1)

CPU Stands(1)

Brand

Post-it(277)

3M(211)

Scotch(190)

Command(42)

Scotch-Brite(25)

Nexcare(11)

Tartan(9)

E-A-R(8)

Ace(5)

Tekk Protection(5)

Scotchgard(4)

O-Cel-O(3)

Highland(3)

Aearo(2)

Peltor(2)

ScotchBlue(1)

Scotch Magic(1)

Color

Clear(150)

Black(127)

Assorted(100)

White(73)

Yellow(56)

Canary Yellow(43)

Green(32)

Red(28)

Matte(28)

Blue(27)

Matte Clear(23)

Tan(18)

Pink(17)

Gray(14)

Multicolor(13)

Silver(13)

Aqua(12)

Orange(12)

Gold(10)

Lime(7)

Translucent(7)

Clear Lens(6)

Purple(6)

Bright Green(5)

Bright Blue(3)

Clear Hook(3)

Beige(3)

Black Frame(3)

Goldenrod(2)

Clear Strip(2)

Aqua Wave(2)

Periwinkle(2)

Metallic Silver(2)

Nickel(2)

Clear Temple(2)

Electric Yellow(2)

Cream(2)

Smoke(1)

Charcoal Gray(1)

Mulberry(1)

Brown(1)

Mint(1)

Bronze(1)

Pastel(1)

Orchid(1)

Neptune Blue(1)

Mint Green(1)

Bright Pink(1)

Bright Assorted(1)

Natural(1)

Transparent(1)

Blue Stem(1)

Copper(1)

Metallic Black(1)

Electric Blue(1)

Neon Pink(1)

Periwinkle Blue(1)

Neon Yellow(1)

Limeade(1)

Size

5" Width(2)

8" Width(1)

Size Supported

3" Width x 3" Length Note(9)

3" Width x 3" Length(1)

4" Width x 4" Length Note(1)

1" Width x 1.75" Length(1)

1" Width x 1.75" Length Flag(1)

Recycled

No(582)

Yes(54)

Price Range

$0-$499.99(793)

$500-$999.99(8)

To  GO

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

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