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_36` 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(187)

Transparent & Invisible Tapes(87)

Privacy Filters(79)

Packaging Tapes(70)

Sponges & Scouring Pads(52)

Flags(50)

Masking Tapes(44)

Hooks & Hangers(35)

Dry-Erase Boards(31)

Hearing Protection(30)

Mounting Tapes(27)

Floor & Carpet Cleaner Accessories(27)

Tape Dispensers(26)

Laminating Supplies(23)

Eye Protection(22)

Easel Pads(18)

Index Tabs & Page Markers(15)

Double-Sided Tapes(14)

Notes Holders / Dispensers(13)

Packaging Tape(13)

Bandages & Wraps(12)

Top Tab Accessories(12)

Safety Masks(12)

Mops & Mop Refills(12)

Monitor Filters(12)

Glare/Radiation Filters(12)

Adhesive Corner(11)

Duct Tapes(10)

Mouse & Keyboard Wrist Rests(10)

Laminating Machines(9)

Filament Tape(9)

Keyboard/Mouse Platforms & Trays(9)

Lint Rollers(8)

Tapes(7)

Flag/Tab Dispensers(7)

Safety Tapes(7)

Packing List/Invoice Enclosed Envelopes(7)

Self-Stick Pads(6)

Scissors(6)

Light Bulbs & Tubes(6)

Cork/Fabric Bulletin Boards(5)

Air Respirator Accessories(5)

Monitor Arms(5)

Mailing Tubes(5)

Safety Helmets(5)

Glue Sticks & Pens(4)

Book Tapes(4)

Desktop Organizers(4)

Adhesives/Glues(4)

Glue Rollers(4)

Coat/Garment Hooks(4)

Cable Management(4)

Packing Tape(4)

Multipurpose Cleaners(4)

Correction Tapes(3)

Laptop Stands & Pads(3)

Copyholders(3)

Protectors(3)

Super Glues(3)

Spray Adhesives(3)

Monitor Stands/Risers(3)

Display Boards(3)

Mouse Pads(3)

Signs & Sign Holders(2)

Desktop Copyholders(2)

Shipping Tape Dispensers(2)

First Aid Kits & Supplies(2)

Labels(2)

Janitorial Cloths & Wipes(2)

Electrical Tapes(2)

Safety Vests(2)

Telephone Message Books & Pads(2)

Cleaning Wipes(2)

Mice(2)

Board Erasers(2)

Wound Care(2)

Tab Inserts(2)

All-Purpose Glues(2)

Spot & Stain Removers(2)

Dust Mop Frames(2)

Fabric Protectors(2)

Water Filters & Purifying Dispensers(2)

Medical File Tabs & Index Dividers(2)

Data Index Dividers(2)

Self-Stick Pad Dispensers(2)

Electronic Cleaners/Anti-Static Sprays(1)

Foot Rests(1)

Cleaning Sheets(1)

Computer Cloths/Wipes & Dusters(1)

Laminator Supplies(1)

Brooms & Sweepers(1)

Floor Pads(1)

Cleaners & Detergents(1)

Name Badge Holders(1)

Cleaning Equipment Parts & Accessories(1)

Hard Hats(1)

Hanging Accessories(1)

Photo Tape(1)

Hook & Loop Fasteners(1)

CPU Stands(1)

Workstations/Computer Desks(1)

Postal Wraps(1)

Letter, Legal & Jr. Pads(1)

Toilet Brushes(1)

Easel Boards(1)

Combination Bulletin/Dry-Erase Boards(1)

Respirators(1)

Specialty Cleaners/Lubricants(1)

Bathroom Cleaners(1)

Brushes & Dusters(1)

Bandages(1)

Tape Dispenser Replacement Cores(1)

Respirator Cartridges & Filters(1)

Outdoor Mats(1)

Wrist Supports(1)

Scouring Pads/Sticks(1)

File Inserts/Tabs(1)

Flag Pens(1)

Mounting Putty(1)

Safety Gear(1)

Safety/Caution Signs(1)

Multimedia Headphones(1)

Safety Glasses(1)

Boards(1)

Label Tapes(1)

Furniture Covers(1)

Binder Clips(1)

Pen-Style Highlighters(1)

Foil & Wraps(1)

Bubble Wraps(1)

Shipping & Moving Boxes(1)

Drawer Organizers(1)

 
Brand

3M(353)

Scotch(327)

Post-it®(319)

Scotch-Brite(58)

Command(53)

Highland(26)

E-A-R(15)

Tartan(13)

Nexcare(10)

Scotchgard(7)

Peltor(6)

Ace(6)

Tekk Protection(5)

Post-it(5)

O-Cel-O(4)

ScotchBlue(4)

Post-it Notes Super Sticky(3)

Aearo(2)

Post-it®(2)

Filtrete(2)

Post-it Pop-up Notes(1)

Post-it Pop-up Notes Super Sticky(1)

Scotch Magic(1)

Post-it Tabs(1)

Futuro(1)

Post-it Notes(1)

ACE(1)

 
Color

Clear(227)

Black(164)

Assorted(124)

White(114)

Yellow(77)

Matte(52)

Green(49)

Canary Yellow(47)

Blue(42)

Tan(38)

Matte Clear(36)

Red(35)

Silver(23)

Gray(20)

Glossy(18)

Multicolor(18)

Pink(18)

Orange(18)

Aqua(15)

Purple(12)

Clear Lens(11)

Gold(10)

Translucent(8)

Brown(7)

Lime(7)

Beige(6)

Bright Green(5)

Neon Yellow(4)

Bright Blue(3)

Black Frame(3)

Clear Hook(3)

Cream(3)

Bright Assorted(3)

Transparent(3)

Pastel(2)

Mint(2)

Charcoal(2)

Clear Temple(2)

Periwinkle(2)

Nickel(2)

Assorted Pastel(2)

Slate Blue(2)

Silver Stripe(2)

Limeade(2)

Aqua Wave(2)

Electric Blue(2)

Metallic Silver(2)

Clear Strip(2)

Gray Frame(1)

Smoke(1)

Bronze(1)

Charcoal Gray(1)

Electric Yellow(1)

Black Lens(1)

Orchid(1)

Maroon(1)

Rose(1)

Black/Green(1)

Gray Lens(1)

Mulberry(1)

Neon Pink(1)

Blue Stem(1)

Neptune Blue(1)

Periwinkle Blue(1)

Primary Red(1)

Clear Frame(1)

Primary Green(1)

Tan Tint(1)

Bright Pink(1)

Natural(1)

Black Temple(1)

Slate(1)

Tangerine(1)

Neon Orange(1)

Ebony(1)

Matte Light Green(1)

Matte Orange(1)

Lavender(1)

Metallic Black(1)

Neon Green(1)

Copper(1)

Lemon Lime(1)

 
Size

5" Width(2)

1.88" x 60 yds(2)

3/4" x 600"(1)

Small(1)

3/4" x 2592"(1)

1 1/2" x 15 yds(1)

2 2/5" x 3 4/5"(1)

3/4" x 300"(1)

1/2" x 1296"(1)

5" Width x 6" Length(1)

Medium(1)

1.88" x 49.2 yds(1)

Medium (M)(1)

1.88" x 10 yds(1)

8" Width(1)

8" Width x 6" Depth(1)

1/2" x 800"(1)

 
Size Supported

3" Width x 3" Length Note(12)

3" Width x 3" Length(1)

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

Yes(61)

 
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 Rhino Office Products, All Rights Reserved