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

Privacy Filters(86)

Transparent & Invisible Tapes(82)

Sponges & Scouring Pads(60)

Packaging Tapes(59)

Flags(52)

Masking Tapes(37)

Hooks & Hangers(32)

Hearing Protection(27)

Mounting Tapes(24)

Laminating Supplies(23)

Eye Protection(20)

Easel Pads(18)

Tape Dispensers(18)

Dry-Erase Boards(17)

Notes Holders / Dispensers(16)

Index Tabs & Page Markers(15)

Double-Sided Tapes(14)

Packaging Tape(13)

Top Tab Accessories(12)

Bandages & Wraps(12)

Glare/Radiation Filters(12)

Safety Masks(11)

Adhesive Corner(11)

Mouse & Keyboard Wrist Rests(10)

Duct Tapes(10)

Laminating Machines(9)

Keyboard/Mouse Platforms & Trays(8)

Filament Tape(8)

Safety Tapes(7)

Lint Rollers(7)

Flag/Tab Dispensers(6)

Scissors(5)

Air Respirator Accessories(5)

Duster Refills(5)

Cork/Fabric Bulletin Boards(5)

Safety Helmets(5)

Mops & Mop Refills(5)

Coat/Garment Hooks(4)

Glue Rollers(4)

Book Tapes(4)

Packing List/Invoice Enclosed Envelopes(4)

Floor & Carpet Cleaner Accessories(4)

Cable Management(4)

Multipurpose Cleaners(4)

Mailing Tubes(4)

Monitor Arms(4)

Super Glues(3)

Protectors(3)

Monitor Stands/Risers(3)

Laptop Stands & Pads(3)

Desktop Organizers(3)

Bubble Wraps(3)

Glue Sticks & Pens(3)

Cleaning Equipment Parts & Accessories(3)

Copyholders(3)

Desktop Copyholders(3)

Brooms & Sweepers(3)

Mouse Pads(3)

Spray Adhesives(3)

Cleaning Wipes(2)

Signs & Sign Holders(2)

Janitorial Cloths & Wipes(2)

Shipping Tape Dispensers(2)

Mice(2)

Data Index Dividers(2)

First Aid Kits & Supplies(2)

All-Purpose Glues(2)

Dust Mop Frames(2)

Board Erasers(2)

Medical File Tabs & Index Dividers(2)

Telephone Message Books & Pads(2)

Electrical Tapes(2)

Correction Tapes(2)

Fabric Protectors(2)

Toilet Bowl Cleaners(2)

Spot & Stain Removers(2)

Floor & Carpet Cleaners(1)

Bathroom Cleaners(1)

Easel Boards(1)

Letter, Legal & Jr. Pads(1)

Wrist Supports(1)

Wound Care(1)

Tape Dispenser Replacement Cores(1)

Hanging Accessories(1)

Workstations/Computer Desks(1)

Medical Equipment & Supplies(1)

Outdoor Mats(1)

Name Badge Holders(1)

Photo Tape(1)

Combination Bulletin/Dry-Erase Boards(1)

Water Filters & Purifying Dispensers(1)

Foot Rests(1)

Electronic Cleaners/Anti-Static Sprays(1)

Tapes(1)

Pen-Style Highlighters(1)

Flag Pens(1)

Safety/Caution Signs(1)

Postal Wraps(1)

Safety Gear(1)

Furniture Covers(1)

Foil & Wraps(1)

Label Tapes(1)

Tab Inserts(1)

Multimedia Headphones(1)

Shipping & Moving Boxes(1)

Computer Cloths/Wipes & Dusters(1)

Cleaning Sheets(1)

Drawer Organizers(1)

Specialty Cleaners/Lubricants(1)

PC Headsets & Accessories(1)

Safety Vests(1)

Screen Protectors(1)

CPU Stands(1)

 
Brand

Post-it®(325)

3M(286)

Scotch(283)

Scotch-Brite(63)

Command(49)

Highland(26)

E-A-R(13)

Tartan(10)

Nexcare(10)

Scotchgard(8)

Peltor(6)

Ace(6)

Tekk Protection(4)

O-Cel-O(4)

ScotchBlue(4)

Aearo(2)

Scotch Magic(1)

WorkTunes(1)

Futuro(1)

Filtrete(1)

 
Color

Clear(208)

Black(155)

Assorted(122)

White(101)

Yellow(73)

Blue(52)

Green(51)

Matte(48)

Glossy(47)

Canary Yellow(46)

Tan(33)

Matte Clear(32)

Red(29)

Gray(20)

Silver(20)

Multicolor(19)

Pink(17)

Orange(17)

Aqua(15)

Gold(13)

Translucent(11)

Clear Lens(10)

Purple(7)

Lime(6)

Bright Green(6)

Beige(6)

Neon Yellow(4)

Bright Assorted(4)

Bright Blue(4)

Assorted Pastel(4)

Brown(4)

Transparent(3)

Cream(3)

Black Frame(3)

Clear Temple(2)

Aqua Wave(2)

Metallic Silver(2)

Limeade(2)

Assorted Metallic(2)

Pastel(2)

Dark Blue(2)

Light Blue(2)

Charcoal(2)

Electric Blue(2)

Mint(2)

Neon Pink(2)

Nickel(2)

Bronze(1)

Matte Light Green(1)

Multi(1)

Electric Yellow(1)

Periwinkle(1)

Neptune Blue(1)

Orchid(1)

Gray Lens(1)

Maroon(1)

Charcoal Gray(1)

Smoke(1)

Black/Green(1)

Ebony(1)

Gray Frame(1)

Natural(1)

Lemon Lime(1)

Tangerine(1)

Primary Green(1)

Slate(1)

Blue Stem(1)

Clear Hook(1)

Black Temple(1)

Black Lens(1)

Clear Frame(1)

Bright Pink(1)

Tan Tint(1)

Neon Green(1)

Copper(1)

Metallic Black(1)

Neon Orange(1)

Light Gray(1)

Slate Blue(1)

Silver Stripe(1)

Dark Gray(1)

Lavender(1)

 
Size

5" Width(3)

8" Width(1)

Medium (M)(1)

Medium(1)

 
Size Supported

3" Width x 3" Length Note(11)

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

Yes(52)

 
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)

 
 
 

© 2019-2020 LOP Office Supply, All Rights Reserved