Banner1 Banner1
 
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(160)

Transparent & Invisible Tapes(60)

Packaging Tapes(57)

Flags(50)

Privacy Filters(49)

Hooks & Hangers(26)

Dry-Erase Boards(22)

Mounting Tapes(22)

Hearing Protection(21)

Tape Dispensers(19)

Eye Protection(19)

Masking Tapes(18)

Easel Pads(18)

Sponges & Scouring Pads(17)

Laminating Supplies(16)

Floor & Carpet Cleaner Accessories(16)

Index Tabs & Page Markers(14)

Glare/Radiation Filters(12)

Notes Holders / Dispensers(12)

Bandages & Wraps(12)

Tapes(12)

Double-Sided Tapes(12)

Packaging Tape(11)

Top Tab Accessories(11)

Safety Masks(11)

Keyboard/Mouse Platforms & Trays(9)

Laminating Machines(9)

Mouse & Keyboard Wrist Rests(8)

Flag/Tab Dispensers(7)

Filament Tape(7)

Cork/Fabric Bulletin Boards(6)

Safety Tapes(6)

Mouse Pads(5)

Packing List/Invoice Enclosed Envelopes(5)

Monitor Arms(5)

Mops & Mop Refills(5)

Air Respirator Accessories(5)

Glue Rollers(4)

Coat/Garment Hooks(4)

Cable Management(4)

Duct Tapes(4)

Desktop Organizers(4)

Mailing Tubes(4)

Copyholders(3)

Lint Rollers(3)

Protectors(3)

Book Tapes(3)

Safety Helmets(3)

Correction Tapes(3)

Monitor Stands/Risers(3)

Labels(3)

Display Boards(3)

Spray Adhesives(3)

Glue Sticks & Pens(3)

Desktop Copyholders(2)

Laptop Stands & Pads(2)

Cleaning Wipes(2)

Boards(2)

First Aid Kits & Supplies(2)

Hangers/Hooks(2)

Multipurpose Cleaners(2)

Water Filters & Purifying Dispensers(2)

Board Erasers(2)

Telephone Message Books & Pads(2)

Wound Care(2)

Tab Inserts(2)

Medical File Tabs & Index Dividers(2)

Shipping Tape Dispensers(2)

Signs & Sign Holders(2)

Data Index Dividers(2)

Computer Cloths/Wipes & Dusters(1)

Cleaning Sheets(1)

Cleaners & Detergents(1)

Safety Glasses(1)

Tape Dispenser Replacement Cores(1)

Mice(1)

Name Badge Holders(1)

Photo Tape(1)

CPU Stands(1)

Safety Gear(1)

Dust Mop Frames(1)

Spot & Stain Removers(1)

All-Purpose Glues(1)

Flag Pens(1)

Combination Bulletin/Dry-Erase Boards(1)

Easel Boards(1)

Bandages(1)

Fabric Protectors(1)

Letter, Legal & Jr. Pads(1)

Pen-Style Highlighters(1)

Electrical Tapes(1)

Multimedia Headphones(1)

Super Glues(1)

Adhesives/Glues(1)

Drawer Organizers(1)

Janitorial Cloths & Wipes(1)

Safety/Caution Signs(1)

Label Tapes(1)

Binder Clips(1)

Mounting Putty(1)

Electronic Cleaners/Anti-Static Sprays(1)

 
Brand

Post-it®(270)

3M(256)

Scotch(229)

Command(47)

Post-it®(33)

Scotch-Brite(18)

E-A-R(10)

Nexcare(10)

Tartan(9)

Ace(6)

Peltor(5)

Highland(5)

Tekk Protection(5)

Scotchgard(5)

Post-it(4)

ScotchBlue(3)

Filtrete(2)

Aearo(2)

Scotch Magic(1)

ACE(1)

O-Cel-O(1)

 
Color

Clear(180)

Black(145)

Assorted(110)

White(85)

Yellow(56)

Matte(50)

Canary Yellow(42)

Blue(32)

Green(30)

Red(29)

Matte Clear(26)

Tan(19)

Glossy(18)

Multicolor(18)

Pink(15)

Orange(15)

Silver(14)

Gray(14)

Aqua(12)

Gold(10)

Clear Lens(10)

Translucent(8)

Lime(7)

Purple(6)

Bright Green(5)

Beige(4)

Clear Hook(3)

Neon Yellow(3)

Black Frame(3)

Bright Blue(3)

Clear Temple(2)

Nickel(2)

Periwinkle(2)

Metallic Silver(2)

Cream(2)

Mint(2)

Aqua Wave(2)

Clear Strip(2)

Gray Frame(1)

Smoke(1)

Bronze(1)

Charcoal Gray(1)

Black Temple(1)

Mulberry(1)

Brown(1)

Rose(1)

Black/Green(1)

Gray Lens(1)

Electric Yellow(1)

Orchid(1)

Pastel(1)

Neptune Blue(1)

Lavender(1)

Bright Assorted(1)

Tan Tint(1)

Black Lens(1)

Clear Frame(1)

Bright Pink(1)

Blue Stem(1)

Transparent(1)

Natural(1)

Slate Blue(1)

Neon Orange(1)

Charcoal(1)

Neon Pink(1)

Electric Blue(1)

Ebony(1)

Metallic Black(1)

Neon Green(1)

Copper(1)

Limeade(1)

 
Size

5" Width(2)

3/4" x 2592"(1)

1 1/2" x 15 yds(1)

8" Width(1)

Medium(1)

1/2" x 800"(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(715)

Yes(51)

 
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 Penn Office Products, Inc., All Rights Reserved