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

Transparent & Invisible Tapes(79)

Packaging Tapes(66)

Sponges & Scouring Pads(51)

Flags(50)

Privacy Filters(48)

Masking Tapes(38)

Dry-Erase Boards(30)

Hooks & Hangers(30)

Hearing Protection(28)

Floor & Carpet Cleaner Accessories(25)

Mounting Tapes(24)

Tape Dispensers(21)

Laminating Supplies(21)

Eye Protection(21)

Easel Pads(18)

Index Tabs & Page Markers(14)

Double-Sided Tapes(13)

Top Tab Accessories(12)

Glare/Radiation Filters(12)

Packaging Tape(12)

Bandages & Wraps(11)

Safety Masks(11)

Mops & Mop Refills(11)

Notes Holders / Dispensers(11)

Tapes(11)

Keyboard/Mouse Platforms & Trays(9)

Laminating Machines(9)

Flag/Tab Dispensers(7)

Packing List/Invoice Enclosed Envelopes(7)

Lint Rollers(7)

Filament Tape(7)

Duct Tapes(7)

Monitor Filters(6)

Cork/Fabric Bulletin Boards(6)

Safety Tapes(6)

Scissors(5)

Light Bulbs & Tubes(5)

Safety Helmets(5)

Air Respirator Accessories(5)

Monitor Arms(5)

Mailing Tubes(5)

Desktop Organizers(4)

Monitor Stands/Risers(4)

Cable Management(4)

Multipurpose Cleaners(4)

Book Tapes(4)

Coat/Garment Hooks(4)

Glue Rollers(4)

Mouse & Keyboard Wrist Rests(4)

Spray Adhesives(3)

Display Boards(3)

Mouse Pads(3)

Copyholders(3)

Super Glues(3)

Protectors(3)

Correction Tapes(3)

Laptop Stands & Pads(3)

Safety Vests(2)

Board Erasers(2)

Fabric Protectors(2)

Mice(2)

Shipping Tape Dispensers(2)

Medical File Tabs & Index Dividers(2)

First Aid Kits & Supplies(2)

All-Purpose Glues(2)

Desktop Copyholders(2)

Glue Sticks & Pens(2)

Dust Mop Frames(2)

Spot & Stain Removers(2)

Data Index Dividers(2)

Water Filters & Purifying Dispensers(2)

Electrical Tapes(2)

Telephone Message Books & Pads(2)

Tab Inserts(2)

Wound Care(2)

Safety Glasses(1)

Brooms & Sweepers(1)

Respirator Cartridges & Filters(1)

Cleaning Equipment Parts & Accessories(1)

Cleaning Wipes(1)

Signs & Sign Holders(1)

CPU Stands(1)

Name Badge Holders(1)

Hanging Accessories(1)

Photo Tape(1)

Outdoor Mats(1)

Foot Rests(1)

Mounting Putty(1)

Flag Pens(1)

Pen-Style Highlighters(1)

Postal Wraps(1)

Foil & Wraps(1)

Binder Clips(1)

Easel Boards(1)

Specialty Cleaners/Lubricants(1)

Combination Bulletin/Dry-Erase Boards(1)

Respirators(1)

Scouring Pads/Sticks(1)

Bubble Wraps(1)

Tape Dispenser Replacement Cores(1)

Janitorial Cloths & Wipes(1)

Multimedia Headphones(1)

Drawer Organizers(1)

Electronic Cleaners/Anti-Static Sprays(1)

Safety/Caution Signs(1)

Wrist Supports(1)

Shipping & Moving Boxes(1)

Furniture Covers(1)

Safety Gear(1)

Computer Cloths/Wipes & Dusters(1)

 
Brand

3M(318)

Post-it®(284)

Scotch(277)

Scotch-Brite(53)

Command(48)

Post-it®(33)

Highland(24)

E-A-R(15)

Tartan(12)

Nexcare(9)

Scotchgard(7)

Ace(6)

Peltor(6)

Tekk Protection(5)

ScotchBlue(4)

O-Cel-O(3)

Filtrete(2)

Aearo(2)

Scotch Magic(1)

Futuro(1)

 
Color

Clear(203)

Black(158)

Assorted(121)

White(101)

Yellow(74)

Matte(49)

Canary Yellow(47)

Green(46)

Blue(42)

Tan(36)

Matte Clear(35)

Red(34)

Silver(21)

Orange(18)

Gray(18)

Multicolor(18)

Glossy(18)

Pink(17)

Aqua(15)

Purple(12)

Clear Lens(10)

Gold(10)

Translucent(7)

Brown(7)

Lime(7)

Beige(6)

Bright Green(5)

Black Frame(3)

Bright Assorted(3)

Bright Blue(3)

Transparent(3)

Cream(3)

Clear Hook(3)

Neon Yellow(3)

Assorted Pastel(2)

Pastel(2)

Nickel(2)

Clear Temple(2)

Periwinkle(2)

Metallic Silver(2)

Mint(2)

Silver Stripe(2)

Limeade(2)

Aqua Wave(2)

Electric Blue(2)

Clear Strip(2)

Gray Frame(1)

Smoke(1)

Black Lens(1)

Bronze(1)

Electric Yellow(1)

Charcoal Gray(1)

Charcoal(1)

Orchid(1)

Maroon(1)

Rose(1)

Black/Green(1)

Gray Lens(1)

Mulberry(1)

Neon Pink(1)

Blue Stem(1)

Neptune Blue(1)

Mint Green(1)

Tan Tint(1)

Tangerine(1)

Clear Frame(1)

Bright Pink(1)

Primary Green(1)

Slate(1)

Primary Red(1)

Black Temple(1)

Slate Blue(1)

Lemon Lime(1)

Ebony(1)

Matte Light Green(1)

Natural(1)

Lavender(1)

Metallic Black(1)

Neon Orange(1)

Neon Green(1)

Copper(1)

Periwinkle Blue(1)

 
Size

5" Width(2)

Small(1)

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" Width x 1.75" Length Flag(1)

1" Width x 1.75" Length(1)

 
Recycled

No(891)

Yes(58)

 
Sheet Size

25" x 30"(13)

20" x 23"(5)

9" Width x 11" Length(1)

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

5" Width x 4" Length(1)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved