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

Transparent & Invisible Tapes(46)

Sponges & Scouring Pads(28)

Hooks & Hangers(24)

Dry-Erase Boards(22)

Tape Dispensers(20)

Eye Protection(17)

Mounting Tapes(17)

Hearing Protection(17)

Floor & Carpet Cleaner Accessories(16)

Easel Pads(14)

Notes Holders / Dispensers(13)

Top Tab Accessories(12)

Double-Sided Tapes(12)

Masking Tapes(11)

Bandages & Wraps(11)

Packaging Tape(11)

Safety Masks(10)

Laminating Supplies(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)

Safety Tapes(6)

Air Respirator Accessories(5)

Laminating Machines(5)

Glue Rollers(4)

Desktop Organizers(4)

Mailing Tubes(4)

Glare/Radiation Filters(4)

Lint Rollers(4)

Flag/Tab Dispensers(4)

Multipurpose Cleaners(4)

Mouse & Keyboard Wrist Rests(4)

Coat/Garment Hooks(4)

Cable Management(4)

Duct Tapes(3)

Letter, Legal & Jr. Pads(3)

Book Tapes(3)

Safety Helmets(3)

Protectors(3)

Display Boards(3)

Tab Inserts(3)

Monitor Stands/Risers(3)

Desktop Copyholders(3)

Correction Tapes(3)

Monitor Arms(3)

Spray Adhesives(3)

Cleaning Wipes(3)

Copyholders(2)

Fabric Protectors(2)

Shipping Tape Dispensers(2)

First Aid Kits & Supplies(2)

Telephone Message Books & Pads(2)

Glue Sticks & Pens(2)

Medical File Tabs & Index Dividers(2)

Data Index Dividers(2)

Board Erasers(2)

Dust Mop Frames(2)

Wound Care(2)

Safety Gear(2)

Mouse Pads(2)

Laptop Stands & Pads(1)

Mice(1)

Signs & Sign Holders(1)

Name Badge Holders(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®(278)

3M(195)

Scotch(190)

Command(42)

Scotch-Brite(27)

Nexcare(10)

Tartan(9)

E-A-R(8)

Tekk Protection(5)

Scotchgard(5)

Ace(5)

Peltor(3)

O-Cel-O(3)

Highland(3)

Aearo(2)

Scotch Magic(1)

ScotchBlue(1)

Color

Clear(152)

Black(115)

Assorted(100)

White(75)

Yellow(56)

Canary Yellow(43)

Green(33)

Matte(32)

Red(28)

Blue(28)

Matte Clear(23)

Tan(17)

Pink(17)

Gray(14)

Aqua(13)

Multicolor(13)

Silver(13)

Orange(12)

Clear Lens(7)

Lime(7)

Translucent(7)

Gold(6)

Purple(6)

Bright Green(5)

Beige(3)

Bright Blue(3)

Clear Hook(3)

Black Frame(3)

Clear Strip(2)

Periwinkle(2)

Aqua Wave(2)

Cream(2)

Electric Yellow(2)

Clear Temple(2)

Metallic Silver(2)

Nickel(2)

Neptune Blue(1)

Charcoal Gray(1)

Smoke(1)

Orchid(1)

Mulberry(1)

Mint(1)

Black/Green(1)

Gray Lens(1)

Brown(1)

Pastel(1)

Copper(1)

Natural(1)

Bright Pink(1)

Blue Stem(1)

Neon Yellow(1)

Transparent(1)

Bright Assorted(1)

Metallic Black(1)

Electric Blue(1)

Limeade(1)

Neon Pink(1)

Periwinkle Blue(1)

Mint Green(1)

Bronze(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(588)

Yes(53)

Price Range

$0-$499.99(782)

$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