Banner1 Banner1
 
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_16` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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` 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 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 `pinfo`.`sku` LIKE '%3M' THEN 1 ELSE 0 END DESC, 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

Currently Filtered by

Manufacturer

3M

Refine Search

  GO
 
Category

Adhesive Note Pads(159)

Transparent & Invisible Tapes(57)

Packaging Tapes(56)

Flags(50)

Privacy Filters(47)

Hooks & Hangers(22)

Dry-Erase Boards(21)

Mounting Tapes(20)

Hearing Protection(20)

Eye Protection(19)

Tape Dispensers(18)

Easel Pads(17)

Sponges & Scouring Pads(17)

Floor & Carpet Cleaner Accessories(16)

Laminating Supplies(13)

Masking Tapes(13)

Index Tabs & Page Markers(13)

Glare/Radiation Filters(12)

Top Tab Accessories(11)

Notes Holders / Dispensers(11)

Double-Sided Tapes(11)

Bandages & Wraps(11)

Packaging Tape(10)

Safety Masks(10)

Keyboard/Mouse Platforms & Trays(9)

Laminating Machines(9)

Tapes(9)

Flag/Tab Dispensers(7)

Cork/Fabric Bulletin Boards(6)

Filament Tape(6)

Packing List/Invoice Enclosed Envelopes(5)

Mops & Mop Refills(5)

Monitor Arms(5)

Safety Tapes(5)

Air Respirator Accessories(5)

Cable Management(4)

Mailing Tubes(4)

Mouse & Keyboard Wrist Rests(4)

Desktop Organizers(4)

Coat/Garment Hooks(4)

Glue Rollers(4)

Monitor Stands/Risers(3)

Mouse Pads(3)

Protectors(3)

Safety Helmets(3)

Book Tapes(3)

Spray Adhesives(3)

Correction Tapes(3)

Display Boards(3)

Copyholders(3)

Lint Rollers(2)

Desktop Copyholders(2)

Shipping Tape Dispensers(2)

Board Erasers(2)

Water Filters & Purifying Dispensers(2)

Laptop Stands & Pads(2)

Data Index Dividers(2)

Medical File Tabs & Index Dividers(2)

Tab Inserts(2)

Duct Tapes(2)

Wound Care(2)

First Aid Kits & Supplies(2)

Multipurpose Cleaners(2)

Telephone Message Books & Pads(2)

Cleaning Wipes(1)

Signs & Sign Holders(1)

Spot & Stain Removers(1)

Photo Tape(1)

Name Badge Holders(1)

Tape Dispenser Replacement Cores(1)

Fabric Protectors(1)

Mice(1)

Super Glues(1)

Pen-Style Highlighters(1)

Dust Mop Frames(1)

Safety Gear(1)

Flag Pens(1)

Binder Clips(1)

Glue Sticks & Pens(1)

All-Purpose Glues(1)

Mounting Putty(1)

Combination Bulletin/Dry-Erase Boards(1)

Drawer Organizers(1)

Electronic Cleaners/Anti-Static Sprays(1)

Computer Cloths/Wipes & Dusters(1)

Electrical Tapes(1)

Easel Boards(1)

Safety/Caution Signs(1)

Multimedia Headphones(1)

CPU Stands(1)

 
Brand

Post-it®(265)

3M(235)

Scotch(207)

Command(41)

Post-it®(33)

Scotch-Brite(16)

E-A-R(10)

Tartan(9)

Nexcare(9)

Ace(6)

Peltor(5)

Scotchgard(5)

Tekk Protection(5)

Highland(3)

ScotchBlue(3)

Aearo(2)

Filtrete(2)

Scotch Magic(1)

O-Cel-O(1)

 
Color

Clear(166)

Black(137)

Assorted(109)

White(76)

Yellow(55)

Matte(48)

Canary Yellow(42)

Blue(32)

Green(30)

Red(29)

Matte Clear(25)

Multicolor(18)

Glossy(18)

Tan(17)

Pink(15)

Orange(15)

Silver(13)

Gray(13)

Aqua(12)

Gold(10)

Clear Lens(10)

Translucent(7)

Lime(7)

Purple(6)

Bright Green(5)

Beige(4)

Black Frame(3)

Bright Blue(3)

Clear Hook(3)

Cream(2)

Mint(2)

Periwinkle(2)

Nickel(2)

Metallic Silver(2)

Aqua Wave(2)

Clear Temple(2)

Clear Strip(2)

Neon Yellow(2)

Bronze(1)

Smoke(1)

Gray Frame(1)

Charcoal Gray(1)

Black Temple(1)

Gray Lens(1)

Rose(1)

Black/Green(1)

Brown(1)

Mulberry(1)

Orchid(1)

Pastel(1)

Neptune Blue(1)

Metallic Black(1)

Bright Pink(1)

Bright Assorted(1)

Tan Tint(1)

Clear Frame(1)

Natural(1)

Transparent(1)

Blue Stem(1)

Black Lens(1)

Neon Orange(1)

Neon Pink(1)

Electric Blue(1)

Limeade(1)

Ebony(1)

Lavender(1)

Neon Green(1)

Copper(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(675)

Yes(51)

 
Sheet Size

25" x 30"(13)

20" x 23"(4)

9" Width x 11" Length(1)

5 7/8" Width x 3 7/8" Length(1)

5" Width x 4" Length(1)