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

Transparent & Invisible Tapes(69)

Packaging Tapes(59)

Flags(50)

Privacy Filters(49)

Sponges & Scouring Pads(36)

Hooks & Hangers(29)

Dry-Erase Boards(26)

Hearing Protection(25)

Mounting Tapes(24)

Laminating Supplies(23)

Eye Protection(20)

Tape Dispensers(19)

Easel Pads(18)

Floor & Carpet Cleaner Accessories(18)

Masking Tapes(18)

Index Tabs & Page Markers(14)

Double-Sided Tapes(13)

Packaging Tape(12)

Glare/Radiation Filters(12)

Notes Holders / Dispensers(12)

Top Tab Accessories(11)

Safety Masks(11)

Bandages & Wraps(11)

Tapes(10)

Keyboard/Mouse Platforms & Trays(9)

Laminating Machines(9)

Mops & Mop Refills(8)

Mouse & Keyboard Wrist Rests(8)

Lint Rollers(7)

Filament Tape(7)

Flag/Tab Dispensers(7)

Safety Tapes(7)

Cork/Fabric Bulletin Boards(6)

Scissors(5)

Safety Helmets(5)

Air Respirator Accessories(5)

Monitor Arms(5)

Packing List/Invoice Enclosed Envelopes(5)

Mouse Pads(5)

Glue Rollers(4)

Multipurpose Cleaners(4)

Cable Management(4)

Book Tapes(4)

Mailing Tubes(4)

Desktop Organizers(4)

Monitor Stands/Risers(4)

Coat/Garment Hooks(4)

Laptop Stands & Pads(3)

Copyholders(3)

Super Glues(3)

Duct Tapes(3)

Protectors(3)

Display Boards(3)

Glue Sticks & Pens(3)

Correction Tapes(3)

Spray Adhesives(3)

Water Filters & Purifying Dispensers(2)

Board Erasers(2)

Dust Mop Frames(2)

Desktop Copyholders(2)

Shipping Tape Dispensers(2)

Signs & Sign Holders(2)

Mice(2)

First Aid Kits & Supplies(2)

Fabric Protectors(2)

Spot & Stain Removers(2)

Medical File Tabs & Index Dividers(2)

Tab Inserts(2)

Data Index Dividers(2)

Wound Care(2)

Telephone Message Books & Pads(2)

Brooms & Sweepers(1)

Letter, Legal & Jr. Pads(1)

Cleaning Equipment Parts & Accessories(1)

Binder Clips(1)

Light Bulbs & Tubes(1)

Foot Rests(1)

Cleaning Wipes(1)

Photo Tape(1)

Scouring Pads/Sticks(1)

Combination Bulletin/Dry-Erase Boards(1)

Name Badge Holders(1)

Easel Boards(1)

Drawer Organizers(1)

Wrist Supports(1)

Mounting Putty(1)

Tape Dispenser Replacement Cores(1)

All-Purpose Glues(1)

Safety Gear(1)

Flag Pens(1)

Pen-Style Highlighters(1)

Label Tapes(1)

Packing Tape(1)

Safety/Caution Signs(1)

Computer Cloths/Wipes & Dusters(1)

Cleaning Sheets(1)

CPU Stands(1)

Electronic Cleaners/Anti-Static Sprays(1)

Outdoor Mats(1)

Janitorial Cloths & Wipes(1)

Multimedia Headphones(1)

Electrical Tapes(1)

Specialty Cleaners/Lubricants(1)

 
Brand

3M(278)

Post-it®(274)

Scotch(255)

Command(47)

Scotch-Brite(40)

Post-it®(33)

Highland(18)

E-A-R(14)

Nexcare(9)

Tartan(9)

Scotchgard(7)

Ace(6)

Tekk Protection(5)

Peltor(5)

ScotchBlue(3)

Filtrete(2)

Aearo(2)

O-Cel-O(1)

Scotch Magic(1)

Futuro(1)

 
Color

Clear(195)

Black(158)

Assorted(111)

White(97)

Yellow(71)

Matte(50)

Canary Yellow(44)

Green(40)

Blue(34)

Red(34)

Matte Clear(32)

Tan(19)

Multicolor(18)

Glossy(18)

Silver(18)

Gray(18)

Pink(16)

Orange(15)

Aqua(14)

Gold(10)

Clear Lens(10)

Purple(8)

Translucent(8)

Lime(7)

Beige(5)

Bright Green(5)

Brown(4)

Neon Yellow(4)

Black Frame(3)

Bright Blue(3)

Clear Hook(3)

Cream(3)

Bright Assorted(3)

Nickel(2)

Clear Temple(2)

Periwinkle(2)

Charcoal(2)

Mint(2)

Assorted Pastel(2)

Transparent(2)

Aqua Wave(2)

Pastel(2)

Metallic Silver(2)

Clear Strip(2)

Charcoal Gray(1)

Smoke(1)

Clear Frame(1)

Neptune Blue(1)

Gray Frame(1)

Orchid(1)

Black Temple(1)

Rose(1)

Black/Green(1)

Maroon(1)

Gray Lens(1)

Black Lens(1)

Mulberry(1)

Bronze(1)

Limeade(1)

Blue Stem(1)

Neon Orange(1)

Tan Tint(1)

Bright Pink(1)

Natural(1)

Slate(1)

Neon Green(1)

Copper(1)

Neon Pink(1)

Electric Blue(1)

Ebony(1)

Lavender(1)

Metallic Black(1)

Electric Yellow(1)

 
Size

5" Width(2)

18 mm x 55 m(1)

8" Width(1)

Medium (M)(1)

Medium(1)

 
Size Supported

3" Width x 3" Length Note(12)

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

Yes(54)

 
Sheet Size

25" x 30"(13)

20" x 23"(6)

9" Width x 11" Length(1)

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

5" Width x 4" Length(1)

 
 
 

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