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

Privacy Filters(70)

Flags(51)

Transparent & Invisible Tapes(49)

Packaging Tapes(35)

Sponges & Scouring Pads(23)

Hooks & Hangers(21)

Mounting Tapes(19)

Tape Dispensers(18)

Hearing Protection(17)

Easel Pads(15)

Eye Protection(15)

Masking Tapes(13)

Index Tabs & Page Markers(13)

Laminating Supplies(13)

Glare/Radiation Filters(12)

Notes Holders / Dispensers(11)

Bandages & Wraps(11)

Top Tab Accessories(11)

Double-Sided Tapes(11)

Packaging Tape(11)

Adhesive Corner(9)

Laminating Machines(9)

Keyboard/Mouse Platforms & Trays(8)

Safety Masks(8)

Flag/Tab Dispensers(6)

Mouse & Keyboard Wrist Rests(6)

Filament Tape(6)

Safety Tapes(5)

Mops & Mop Refills(5)

Air Respirator Accessories(5)

Mailing Tubes(5)

Duct Tapes(5)

Cork/Fabric Bulletin Boards(5)

Monitor Arms(4)

Coat/Garment Hooks(4)

Glue Rollers(4)

Cable Management(4)

Packing List/Invoice Enclosed Envelopes(3)

Copyholders(3)

Book Tapes(3)

Safety Helmets(3)

Desktop Organizers(3)

Desktop Copyholders(3)

Protectors(3)

Spray Adhesives(3)

Dry-Erase Boards(2)

Telephone Message Books & Pads(2)

First Aid Kits & Supplies(2)

Shipping Tape Dispensers(2)

Lint Rollers(2)

Safety Vests(2)

Laptop Stands & Pads(2)

Monitor Stands/Risers(2)

Wound Care(2)

Board Erasers(2)

Brooms & Sweepers(2)

Floor & Carpet Cleaner Accessories(2)

Correction Tapes(2)

Medical File Tabs & Index Dividers(2)

Data Index Dividers(2)

Multipurpose Cleaners(2)

Cleaning Wipes(1)

Signs & Sign Holders(1)

Medical Equipment & Supplies(1)

CPU Stands(1)

Mice(1)

Name Badge Holders(1)

Photo Tape(1)

Computer Cloths/Wipes & Dusters(1)

Mouse Pads(1)

Workstations/Computer Desks(1)

Safety Gear(1)

Combination Bulletin/Dry-Erase Boards(1)

Dust Mop Frames(1)

Glue Sticks & Pens(1)

Binder Clips(1)

Easel Boards(1)

Bathroom Cleaners(1)

Cleaning Equipment Parts & Accessories(1)

Water Filters & Purifying Dispensers(1)

Fabric Protectors(1)

All-Purpose Glues(1)

Tab Inserts(1)

Super Glues(1)

Spot & Stain Removers(1)

Electrical Tapes(1)

Drawer Organizers(1)

Multimedia Headphones(1)

Safety/Caution Signs(1)

Flag Pens(1)

Pen-Style Highlighters(1)

Tape Dispenser Replacement Cores(1)

Electronic Cleaners/Anti-Static Sprays(1)

Brand

Post-it®(285)

3M(196)

Scotch(179)

Command(39)

Scotch-Brite(24)

Highland(14)

E-A-R(9)

Nexcare(9)

Tartan(6)

Ace(6)

Tekk Protection(5)

Scotchgard(5)

O-Cel-O(3)

Peltor(3)

ScotchBlue(3)

Aearo(2)

Scotch Magic(1)

Filtrete(1)

Color

Clear(136)

Black(120)

Assorted(112)

White(65)

Yellow(57)

Glossy(50)

Matte(45)

Canary Yellow(41)

Blue(34)

Green(31)

Matte Clear(23)

Red(20)

Tan(18)

Multicolor(17)

Pink(16)

Orange(15)

Silver(13)

Aqua(12)

Gray(12)

Translucent(10)

Gold(7)

Clear Lens(7)

Purple(6)

Lime(6)

Bright Green(6)

Beige(5)

Bright Assorted(4)

Assorted Pastel(4)

Bright Blue(4)

Assorted Metallic(2)

Metallic Silver(2)

Nickel(2)

Mint(2)

Black Frame(2)

Clear Temple(2)

Silver Stripe(2)

Dark Blue(2)

Light Blue(2)

Neon Yellow(2)

Cream(2)

Aqua Wave(2)

Smoke(1)

Gray Frame(1)

Black Lens(1)

Bronze(1)

Charcoal Gray(1)

Brown(1)

Periwinkle(1)

Black/Green(1)

Gray Lens(1)

Pastel(1)

Orchid(1)

Neptune Blue(1)

Lavender(1)

Transparent(1)

Dark Gray(1)

Tan Tint(1)

Bright Pink(1)

Natural(1)

Clear Hook(1)

Light Gray(1)

Copper(1)

Electric Blue(1)

Limeade(1)

Neon Pink(1)

Ebony(1)

Metallic Black(1)

Blue Stem(1)

Electric Yellow(1)

Size

5" Width(2)

8" Width(1)

Medium(1)

Size Supported

3" Width x 3" Length Note(9)

4" Width x 4" Length Note(1)

1" Width x 1.75" Length Flag(1)

1" Width x 1.75" Length(1)

Recycled

No(621)

Yes(45)

Price Range

$0-$499.99(788)

$500-$999.99(2)

To  GO

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

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