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

Privacy Filters(76)

Transparent & Invisible Tapes(69)

Packaging Tapes(59)

Flags(50)

Sponges & Scouring Pads(36)

Hooks & Hangers(29)

Hearing Protection(25)

Dry-Erase Boards(25)

Mounting Tapes(24)

Laminating Supplies(22)

Eye Protection(20)

Tape Dispensers(19)

Masking Tapes(18)

Floor & Carpet Cleaner Accessories(18)

Easel Pads(18)

Index Tabs & Page Markers(14)

Double-Sided Tapes(13)

Glare/Radiation Filters(12)

Notes Holders / Dispensers(12)

Packaging Tape(12)

Safety Masks(11)

Top Tab Accessories(11)

Bandages & Wraps(11)

Mouse & Keyboard Wrist Rests(10)

Adhesive Corner(10)

Keyboard/Mouse Platforms & Trays(9)

Laminating Machines(9)

Mops & Mop Refills(8)

Lint Rollers(7)

Safety Tapes(7)

Flag/Tab Dispensers(7)

Filament Tape(7)

Monitor Arms(5)

Packing List/Invoice Enclosed Envelopes(5)

Cork/Fabric Bulletin Boards(5)

Safety Helmets(5)

Scissors(5)

Air Respirator Accessories(5)

Glue Rollers(4)

Mailing Tubes(4)

Desktop Organizers(4)

Book Tapes(4)

Coat/Garment Hooks(4)

Cable Management(4)

Multipurpose Cleaners(4)

Duct Tapes(3)

Copyholders(3)

Display Boards(3)

Laptop Stands & Pads(3)

Protectors(3)

Monitor Stands/Risers(3)

Spray Adhesives(3)

Correction Tapes(3)

Super Glues(3)

Mouse Pads(3)

Fabric Protectors(2)

Desktop Copyholders(2)

Spot & Stain Removers(2)

Shipping Tape Dispensers(2)

Signs & Sign Holders(2)

Water Filters & Purifying Dispensers(2)

Mice(2)

Wound Care(2)

First Aid Kits & Supplies(2)

Board Erasers(2)

Dust Mop Frames(2)

Data Index Dividers(2)

Tab Inserts(2)

Glue Sticks & Pens(2)

Telephone Message Books & Pads(2)

Medical File Tabs & Index Dividers(2)

Cleaning Wipes(1)

CPU Stands(1)

Cleaning Equipment Parts & Accessories(1)

Foot Rests(1)

Cleaning Sheets(1)

Brooms & Sweepers(1)

Name Badge Holders(1)

Photo Tape(1)

Light Bulbs & Tubes(1)

Workstations/Computer Desks(1)

Safety Gear(1)

Combination Bulletin/Dry-Erase Boards(1)

Specialty Cleaners/Lubricants(1)

Binder Clips(1)

All-Purpose Glues(1)

Easel Boards(1)

Letter, Legal & Jr. Pads(1)

Electrical Tapes(1)

Outdoor Mats(1)

Bathroom Cleaners(1)

Toilet Brushes(1)

Flag Pens(1)

Pen-Style Highlighters(1)

Multimedia Headphones(1)

Boards(1)

Drawer Organizers(1)

Electronic Cleaners/Anti-Static Sprays(1)

Janitorial Cloths & Wipes(1)

Safety/Caution Signs(1)

Label Tapes(1)

Tape Dispenser Replacement Cores(1)

Mounting Putty(1)

Computer Cloths/Wipes & Dusters(1)

 
Brand

Post-it®(305)

3M(277)

Scotch(252)

Command(47)

Scotch-Brite(40)

Highland(18)

E-A-R(14)

Nexcare(9)

Tartan(9)

Scotchgard(7)

Ace(6)

Peltor(5)

Tekk Protection(5)

ScotchBlue(3)

Aearo(2)

O-Cel-O(2)

Filtrete(2)

Post-it(1)

Scotch Magic(1)

 
Color

Clear(193)

Black(151)

Assorted(111)

White(96)

Yellow(72)

Matte(50)

Canary Yellow(44)

Green(41)

Red(34)

Blue(33)

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)

8" Width(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(802)

Yes(53)

 
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