Total:$0.00

QUICK VIEW 0
 

 
 
 
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_1` 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(156)

Transparent & Invisible Tapes(61)

Packaging Tapes(57)

Flags(51)

Privacy Filters(49)

Sponges & Scouring Pads(41)

Hooks & Hangers(31)

Hearing Protection(29)

Dry-Erase Boards(28)

Laminating Supplies(23)

Tape Dispensers(22)

Mounting Tapes(22)

Eye Protection(20)

Floor & Carpet Cleaner Accessories(18)

Masking Tapes(16)

Easel Pads(15)

Notes Holders / Dispensers(14)

Double-Sided Tapes(14)

Packaging Tape(13)

Top Tab Accessories(12)

Bandages & Wraps(12)

Safety Masks(11)

Index Tabs & Page Markers(9)

Keyboard/Mouse Platforms & Trays(9)

Mouse & Keyboard Wrist Rests(9)

Filament Tape(8)

Mops & Mop Refills(8)

Super Glues(7)

Laminating Machines(7)

Safety Tapes(7)

Cork/Fabric Bulletin Boards(7)

Lint Rollers(7)

Packing List/Invoice Enclosed Envelopes(6)

Mouse Pads(6)

Safety Helmets(6)

Scissors(5)

Book Tapes(5)

Air Respirator Accessories(5)

Glue Rollers(4)

Desktop Organizers(4)

Glue Sticks & Pens(4)

Monitor Stands/Risers(4)

Glare/Radiation Filters(4)

Mailing Tubes(4)

Flag/Tab Dispensers(4)

Letter, Legal & Jr. Pads(4)

Filing Labels & Systems(4)

Multipurpose Cleaners(4)

Cable Management(4)

Coat/Garment Hooks(4)

Safety Gear(3)

Protectors(3)

Desktop Copyholders(3)

Monitor Arms(3)

Tapes(3)

Tab Inserts(3)

Duct Tapes(3)

Spray Adhesives(3)

Correction Tapes(3)

Display Boards(3)

Dust Mop Frames(2)

Laptop Stands & Pads(2)

First Aid Kits & Supplies(2)

Data Index Dividers(2)

Copyholders(2)

Shipping Tape Dispensers(2)

Signs & Sign Holders(2)

Mice(2)

Board Erasers(2)

Telephone Message Books & Pads(2)

Fabric Protectors(2)

Wound Care(2)

Cleaning Equipment Parts & Accessories(2)

Medical File Tabs & Index Dividers(2)

Wrist Supports(2)

Foot Rests(1)

Cleaning Wipes(1)

Binder Clips(1)

Brooms & Sweepers(1)

Spot & Stain Removers(1)

Light Bulbs & Tubes(1)

Name Badge Holders(1)

Specialty Cleaners/Lubricants(1)

Hook & Loop/VELCRO Tapes(1)

Safety Glasses(1)

Cleaning Sheets(1)

All-Purpose Glues(1)

Mounting Putty(1)

Safety/Caution Signs(1)

Outdoor Mats(1)

Plain Tab Index Dividers(1)

Flag Pens(1)

Pen-Style Highlighters(1)

Label Tapes(1)

Janitorial Cloths & Wipes(1)

Multimedia Headphones(1)

Cleaning Kits(1)

CPU Stands(1)

Electrical Tapes(1)

Computer Cloths/Wipes & Dusters(1)

Electronic Cleaners/Anti-Static Sprays(1)

Easel Boards(1)

Tape Dispenser Replacement Cores(1)

Drawer Organizers(1)

Combination Bulletin/Dry-Erase Boards(1)

 
Brand

Post-it®(292)

Scotch(253)

3M(242)

Command(50)

Scotch-Brite(44)

Highland(18)

E-A-R(16)

Nexcare(9)

Tartan(9)

Ace(7)

Peltor(6)

Scotchgard(6)

Tekk Protection(5)

Futuro(2)

Aearo(2)

O-Cel-O(1)

ScotchBlue(1)

Scotch Magic(1)

 
Color

Clear(191)

Black(140)

Assorted(101)

White(96)

Yellow(73)

Canary Yellow(45)

Green(37)

Red(34)

Matte(33)

Matte Clear(32)

Blue(31)

Gray(21)

Silver(18)

Pink(18)

Tan(18)

Aqua(14)

Multicolor(13)

Orange(13)

Purple(11)

Translucent(8)

Lime(7)

Clear Lens(7)

Beige(6)

Gold(6)

Bright Green(5)

Neon Yellow(4)

Brown(4)

Bright Assorted(3)

Black Frame(3)

Bright Blue(3)

Cream(3)

Maroon(3)

Clear Hook(3)

Electric Yellow(2)

Nickel(2)

Metallic Silver(2)

Clear Temple(2)

Periwinkle(2)

Clear Strip(2)

Charcoal(2)

Assorted Pastel(2)

Pastel(2)

Transparent(2)

Aqua Wave(2)

Orchid(1)

Neptune Blue(1)

Coral Pink(1)

Charcoal Gray(1)

Blue Stem(1)

Mulberry(1)

Black/Green(1)

Mint(1)

Natural(1)

Gray Lens(1)

Smoke(1)

Metallic Black(1)

Neon Pink(1)

Slate(1)

Periwinkle Blue(1)

Mint Green(1)

Electric Blue(1)

Limeade(1)

Bronze(1)

Bright Pink(1)

Copper(1)

Matte Green(1)

 
Size

5" Width(2)

8" Width(1)

Medium (M)(1)

 
Size Supported

3" Width x 3" Length Note(10)

3" Width x 3" Length(1)

4" Width x 4" Length Note(1)

1" Length Flag(1)

1" Width x 1.75" Length(1)

1" Width x 1.75" Length Flag(1)

 
Recycled

No(715)

Yes(57)

 
Sheet Size

25" x 30"(13)

20" x 23"(6)

22" x 22"(1)

9" Width x 11" Length(1)

15" x 15"(1)

5" Width x 4" Length(1)

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

11" x 11"(1)

 
 
 

© 2017-2018 2M Office Supplies, All Rights Reserved