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

Transparent & Invisible Tapes(79)

Privacy Filters(75)

Packaging Tapes(66)

Sponges & Scouring Pads(52)

Flags(50)

Masking Tapes(37)

Dry-Erase Boards(30)

Hooks & Hangers(30)

Hearing Protection(28)

Floor & Carpet Cleaner Accessories(23)

Mounting Tapes(23)

Eye Protection(21)

Laminating Supplies(20)

Tape Dispensers(19)

Easel Pads(18)

Index Tabs & Page Markers(14)

Double-Sided Tapes(13)

Glare/Radiation Filters(12)

Top Tab Accessories(12)

Packaging Tape(12)

Safety Masks(11)

Notes Holders / Dispensers(11)

Bandages & Wraps(11)

Mops & Mop Refills(11)

Adhesive Corner(11)

Keyboard/Mouse Platforms & Trays(9)

Laminating Machines(9)

Filament Tape(7)

Duct Tapes(7)

Lint Rollers(7)

Packing List/Invoice Enclosed Envelopes(7)

Flag/Tab Dispensers(7)

Mouse & Keyboard Wrist Rests(6)

Safety Tapes(6)

Cork/Fabric Bulletin Boards(5)

Scissors(5)

Air Respirator Accessories(5)

Light Bulbs & Tubes(5)

Monitor Arms(5)

Mailing Tubes(5)

Safety Helmets(5)

Monitor Filters(4)

Multipurpose Cleaners(4)

Cable Management(4)

Glue Rollers(4)

Coat/Garment Hooks(4)

Book Tapes(4)

Desktop Organizers(4)

Display Boards(3)

Laptop Stands & Pads(3)

Super Glues(3)

Monitor Stands/Risers(3)

Copyholders(3)

Correction Tapes(3)

Protectors(3)

Spray Adhesives(3)

Desktop Copyholders(2)

Spot & Stain Removers(2)

First Aid Kits & Supplies(2)

Mice(2)

Safety Vests(2)

Shipping Tape Dispensers(2)

All-Purpose Glues(2)

Glue Sticks & Pens(2)

Water Filters & Purifying Dispensers(2)

Dust Mop Frames(2)

Board Erasers(2)

Electrical Tapes(2)

Telephone Message Books & Pads(2)

Data Index Dividers(2)

Wound Care(2)

Fabric Protectors(2)

Medical File Tabs & Index Dividers(2)

Tab Inserts(2)

CPU Stands(1)

Hanging Accessories(1)

Brooms & Sweepers(1)

Mouse Pads(1)

Workstations/Computer Desks(1)

Cleaning Equipment Parts & Accessories(1)

Computer Cloths/Wipes & Dusters(1)

Name Badge Holders(1)

Cleaning Wipes(1)

Foot Rests(1)

Photo Tape(1)

Signs & Sign Holders(1)

Bubble Wraps(1)

Easel Boards(1)

Combination Bulletin/Dry-Erase Boards(1)

Specialty Cleaners/Lubricants(1)

Flag Pens(1)

Toilet Brushes(1)

Bathroom Cleaners(1)

Respirator Cartridges & Filters(1)

Outdoor Mats(1)

Wrist Supports(1)

Binder Clips(1)

Pen-Style Highlighters(1)

Postal Wraps(1)

Safety/Caution Signs(1)

Janitorial Cloths & Wipes(1)

Multimedia Headphones(1)

Drawer Organizers(1)

Mounting Putty(1)

Safety Gear(1)

Foil & Wraps(1)

Tape Dispenser Replacement Cores(1)

Shipping & Moving Boxes(1)

Furniture Covers(1)

Electronic Cleaners/Anti-Static Sprays(1)

 
Brand

Post-it®(315)

3M(311)

Scotch(273)

Scotch-Brite(54)

Command(48)

Highland(24)

E-A-R(15)

Tartan(12)

Nexcare(9)

Scotchgard(7)

Ace(6)

Peltor(6)

Tekk Protection(5)

O-Cel-O(4)

ScotchBlue(4)

Aearo(2)

Filtrete(2)

Scotch Magic(1)

Futuro(1)

 
Color

Clear(201)

Black(151)

Assorted(121)

White(100)

Yellow(75)

Matte(49)

Green(48)

Canary Yellow(47)

Blue(41)

Matte Clear(35)

Tan(35)

Red(34)

Silver(21)

Orange(18)

Gray(18)

Glossy(18)

Multicolor(18)

Pink(17)

Aqua(15)

Purple(12)

Clear Lens(10)

Gold(10)

Translucent(7)

Lime(7)

Brown(6)

Beige(6)

Bright Green(5)

Bright Blue(3)

Bright Assorted(3)

Transparent(3)

Clear Hook(3)

Neon Yellow(3)

Black Frame(3)

Cream(3)

Clear Strip(2)

Metallic Silver(2)

Clear Temple(2)

Nickel(2)

Silver Stripe(2)

Mint(2)

Assorted Pastel(2)

Pastel(2)

Electric Blue(2)

Periwinkle(2)

Aqua Wave(2)

Limeade(2)

Gray Lens(1)

Black/Green(1)

Charcoal(1)

Electric Yellow(1)

Bronze(1)

Gray Frame(1)

Mulberry(1)

Maroon(1)

Neon Pink(1)

Neptune Blue(1)

Orchid(1)

Smoke(1)

Charcoal Gray(1)

Rose(1)

Natural(1)

Tangerine(1)

Primary Green(1)

Primary Red(1)

Lemon Lime(1)

Blue Stem(1)

Black Temple(1)

Black Lens(1)

Clear Frame(1)

Slate(1)

Bright Pink(1)

Metallic Black(1)

Lavender(1)

Ebony(1)

Copper(1)

Neon Green(1)

Tan Tint(1)

Slate Blue(1)

Neon Orange(1)

Matte Light Green(1)

 
Size

5" Width(2)

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

Yes(57)

 
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