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

Transparent & Invisible Tapes(72)

Packaging Tapes(64)

Sponges & Scouring Pads(57)

Flags(51)

Privacy Filters(50)

Masking Tapes(36)

Dry-Erase Boards(32)

Floor & Carpet Cleaner Accessories(31)

Hooks & Hangers(31)

Mounting Tapes(24)

Hearing Protection(24)

Tape Dispensers(22)

Laminating Supplies(20)

Eye Protection(19)

Easel Pads(15)

Double-Sided Tapes(15)

Top Tab Accessories(13)

Packaging Tape(13)

Notes Holders / Dispensers(13)

Mops & Mop Refills(12)

Safety Masks(11)

Bandages & Wraps(10)

Filament Tape(9)

Keyboard/Mouse Platforms & Trays(9)

Duct Tapes(9)

Index Tabs & Page Markers(8)

Packing List/Invoice Enclosed Envelopes(8)

Scissors(7)

Laminating Machines(7)

Cork/Fabric Bulletin Boards(7)

Lint Rollers(7)

Safety Tapes(6)

Super Glues(6)

Air Respirator Accessories(5)

Mouse & Keyboard Wrist Rests(5)

Safety Helmets(5)

Mailing Tubes(5)

Glue Sticks & Pens(5)

Mouse Pads(4)

Desktop Organizers(4)

Glare/Radiation Filters(4)

Book Tapes(4)

Monitor Stands/Risers(4)

Glue Rollers(4)

Flag/Tab Dispensers(4)

Multipurpose Cleaners(4)

Coat/Garment Hooks(4)

Bubble Mailers(3)

Ear Plugs(3)

Letter, Legal & Jr. Pads(3)

Desktop Copyholders(3)

Monitor Arms(3)

Cable Management(3)

Tab Inserts(3)

Protectors(3)

Safety Gear(3)

Display Boards(3)

Correction Tapes(3)

Spray Adhesives(3)

Electrical Tapes(2)

Tapes(2)

First Aid Kits & Supplies(2)

All-Purpose Glues(2)

Copyholders(2)

Dust Mop Frames(2)

Spot & Stain Removers(2)

Cleaning Equipment Parts & Accessories(2)

Board Erasers(2)

Laptop Stands & Pads(2)

Shipping Tape Dispensers(2)

Mice(2)

Furniture Covers(2)

Safety Vests(2)

Data Index Dividers(2)

Telephone Message Books & Pads(2)

Medical File Tabs & Index Dividers(2)

Wound Care(2)

Fabric Protectors(2)

Bubble Wraps(2)

Binder Clips(1)

Cleaning Wipes(1)

Foot Rests(1)

Signs & Sign Holders(1)

Hanging Accessories(1)

Flag Pens(1)

Specialty Cleaners/Lubricants(1)

Name Badge Holders(1)

Plain Tab Index Dividers(1)

Safety Glasses(1)

Hook & Loop/VELCRO Tapes(1)

Pen-Style Highlighters(1)

Wrist Supports(1)

Brooms & Sweepers(1)

Screen Protectors(1)

CPU Stands(1)

Mounting Putty(1)

Brushes & Dusters(1)

Janitorial Cloths & Wipes(1)

Combination Bulletin/Dry-Erase Boards(1)

Filing Labels & Systems(1)

Ear Muffs(1)

Safety Headgear Accessories(1)

Shipping & Moving Boxes(1)

Multimedia Headphones(1)

Foil & Wraps(1)

Electronic Cleaners/Anti-Static Sprays(1)

Computer Cloths/Wipes & Dusters(1)

Outdoor Mats(1)

Drawer Organizers(1)

Postal Wraps(1)

Tape Dispenser Replacement Cores(1)

Flat/Media Mailers(1)

Easel Boards(1)

 
Brand

Post-it®(299)

Scotch(288)

3M(279)

Scotch-Brite(58)

Command(49)

Highland(22)

Tartan(12)

E-A-R(12)

Nexcare(9)

Scotchgard(7)

Ace(5)

Tekk Protection(5)

Peltor(4)

O-Cel-O(3)

ScotchBlue(2)

Aearo(2)

Scotch Magic(1)

Futuro(1)

 
Color

Clear(205)

Black(138)

Assorted(113)

White(100)

Yellow(71)

Canary Yellow(48)

Green(44)

Blue(40)

Red(37)

Tan(34)

Matte(33)

Matte Clear(32)

Silver(22)

Gray(21)

Pink(19)

Purple(17)

Aqua(15)

Orange(15)

Multicolor(14)

Brown(7)

Clear Lens(7)

Lime(7)

Translucent(7)

Gold(7)

Beige(5)

Bright Green(5)

Manila(3)

Maroon(3)

Bright Blue(3)

Bright Assorted(3)

Black Frame(3)

Clear Hook(3)

Cream(3)

Clear Strip(2)

Aqua Wave(2)

Metallic Silver(2)

Electric Yellow(2)

Clear Temple(2)

Periwinkle(2)

Nickel(2)

Pastel(2)

Silver Stripe(2)

Transparent(2)

Limeade(2)

Electric Blue(2)

Assorted Pastel(2)

Coral Pink(1)

Neptune Blue(1)

Charcoal Gray(1)

Orchid(1)

Smoke(1)

Primary Red(1)

Primary Green(1)

Mint(1)

Black/Green(1)

Tangerine(1)

Gray Lens(1)

Mulberry(1)

Charcoal(1)

Bronze(1)

Slate Blue(1)

Lemon Lime(1)

Natural(1)

Neon Yellow(1)

Bright Pink(1)

Copper(1)

Metallic Black(1)

Slate(1)

Neon Pink(1)

Periwinkle Blue(1)

Mint Green(1)

Blue Stem(1)

 
Size

5" Width(2)

5" Width x 6" Length(1)

8" Width(1)

8" Width x 6" Depth(1)

Medium (M)(1)

 
Size Supported

3" Width x 3" Length Note(9)

3" Width x 3" Length(1)

4" Width x 4" Length Note(1)

1" Width x 1.75" Length(1)

1" Width x 1.75" Length Flag(1)

 
Recycled

No(802)

Yes(65)

 
Sheet Size

25" x 30"(13)

20" x 23"(5)

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 LOP Office Supply, All Rights Reserved