Total:$0.00

QUICK VIEW 0
 

 
 
 
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_cost`=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(140)

Packaging Tapes(53)

Flags(52)

Transparent & Invisible Tapes(46)

Sponges & Scouring Pads(36)

Privacy Filters(34)

Hooks & Hangers(22)

Dry-Erase Boards(20)

Tape Dispensers(20)

Mounting Tapes(17)

Floor & Carpet Cleaner Accessories(16)

Hearing Protection(15)

Notes Holders / Dispensers(13)

Easel Pads(13)

Double-Sided Tapes(13)

Top Tab Accessories(12)

Packaging Tape(11)

Masking Tapes(11)

Eye Protection(11)

Safety Masks(10)

Laminating Supplies(10)

Bandages & Wraps(10)

Keyboard/Mouse Platforms & Trays(9)

Index Tabs & Page Markers(8)

Cork/Fabric Bulletin Boards(7)

Filament Tape(7)

Multipurpose Cleaners(7)

Packing List/Invoice Enclosed Envelopes(6)

Laminating Machines(5)

Mops & Mop Refills(5)

Air Respirator Accessories(5)

Mouse & Keyboard Wrist Rests(4)

Glue Rollers(4)

Coat/Garment Hooks(4)

Lint Rollers(4)

Desktop Organizers(4)

Mailing Tubes(4)

Screen Protectors(4)

Desktop Copyholders(3)

Tab Inserts(3)

Safety Helmets(3)

Cleaning Wipes(3)

Book Tapes(3)

Letter, Legal & Jr. Pads(3)

Monitor Arms(3)

Flag/Tab Dispensers(3)

Spray Adhesives(3)

Display Boards(3)

Safety Tapes(3)

Correction Tapes(3)

Cable Management(3)

Dust Mop Frames(2)

Mouse Pads(2)

Data Index Dividers(2)

Duct Tapes(2)

Board Erasers(2)

First Aid Kits & Supplies(2)

Shipping Tape Dispensers(2)

Copyholders(2)

Glue Sticks & Pens(2)

Wound Care(2)

Monitor Stands/Risers(2)

Telephone Message Books & Pads(2)

Fabric Protectors(2)

Medical File Tabs & Index Dividers(2)

Safety Gear(2)

Mice(1)

Name Badge Holders(1)

Signs & Sign Holders(1)

Laptop Stands & Pads(1)

Electrical Tapes(1)

Tape Dispenser Replacement Cores(1)

Spot & Stain Removers(1)

Drawer Organizers(1)

Mounting Putty(1)

Multimedia Headphones(1)

Pen-Style Highlighters(1)

Tapes(1)

All-Purpose Glues(1)

Flag Pens(1)

Super Glues(1)

Brushes & Dusters(1)

Electronic Cleaners/Anti-Static Sprays(1)

Computer Cloths/Wipes & Dusters(1)

Disinfectants(1)

Plain Tab Index Dividers(1)

Easel Boards(1)

CPU Stands(1)

 
Brand

Post-it(274)

Scotch(190)

3M(185)

Command(38)

Scotch-Brite(35)

Tartan(9)

Nexcare(9)

E-A-R(7)

Ace(5)

Tekk Protection(5)

O-Cel-O(3)

Scotchgard(3)

Highland(3)

Aearo(2)

Peltor(2)

ScotchBlue(1)

Scotch Magic(1)

 
Color

Clear(153)

Assorted(100)

Black(94)

White(72)

Yellow(54)

Canary Yellow(43)

Green(34)

Red(28)

Blue(28)

Matte Clear(23)

Pink(17)

Tan(16)

Gray(14)

Silver(13)

Multicolor(13)

Aqua(13)

Orange(12)

Purple(10)

Lime(7)

Translucent(5)

Bright Green(5)

Gold(4)

Clear Lens(4)

Beige(4)

Black Base(4)

Translucent Top(4)

Bright Blue(3)

Clear Hook(3)

Black Frame(3)

Periwinkle(2)

Electric Yellow(2)

Nickel(2)

Clear Strip(2)

Goldenrod(2)

Metallic Silver(2)

Aqua Wave(2)

Cream(2)

Charcoal Gray(1)

Neptune Blue(1)

Smoke(1)

Blue Stem(1)

Neon Yellow(1)

Orchid(1)

Pastel(1)

Mint(1)

White Base(1)

Brown(1)

Mulberry(1)

Matte(1)

Bronze(1)

Transparent(1)

Metallic Black(1)

Mint Green(1)

Copper(1)

Yellow Flag(1)

Handle(1)

Periwinkle Blue(1)

Lemon(1)

Limeade(1)

Bright Pink(1)

Electric Blue(1)

Neon Pink(1)

Natural(1)

Bright Assorted(1)

 
Size

16" Diameter(4)

12" Diameter(4)

17" Diameter(4)

20" Diameter(3)

5" Width x 30 ft Length(1)

5" Width x 125 ft Length(1)

8" Width x 125 ft Length(1)

20" Diameter x 1000 mil Thickness(1)

10" Width x 4.60" Depth(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)

 
Recycled

No(589)

Yes(54)

 
 
 

© 2017-2018 Alpine Office Products Inc., All Rights Reserved