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

Privacy Filters(81)

Transparent & Invisible Tapes(73)

Flags(53)

Sponges & Scouring Pads(47)

Packaging Tapes(46)

Hooks & Hangers(26)

Mounting Tapes(24)

Laminating Supplies(22)

Hearing Protection(21)

Eye Protection(18)

Tape Dispensers(18)

Easel Pads(17)

Masking Tapes(17)

Notes Holders / Dispensers(16)

Index Tabs & Page Markers(14)

Packaging Tape(13)

Glare/Radiation Filters(12)

Double-Sided Tapes(12)

Bandages & Wraps(12)

Top Tab Accessories(11)

Mouse & Keyboard Wrist Rests(11)

Dry-Erase Boards(10)

Safety Masks(10)

Laminating Machines(9)

Adhesive Corner(9)

Keyboard/Mouse Platforms & Trays(8)

Duct Tapes(7)

Filament Tape(7)

Flag/Tab Dispensers(6)

Lint Rollers(6)

Safety Tapes(6)

Air Respirator Accessories(5)

Safety Helmets(5)

Duster Refills(5)

Cork/Fabric Bulletin Boards(5)

Floor Pads(4)

Scissors(4)

Coat/Garment Hooks(4)

Packing List/Invoice Enclosed Envelopes(4)

Cable Management(4)

Glue Rollers(4)

Mailing Tubes(4)

Monitor Arms(4)

Mops & Mop Refills(4)

Multipurpose Cleaners(4)

Book Tapes(4)

Monitor Stands/Risers(3)

Mouse Pads(3)

Brooms & Sweepers(3)

Protectors(3)

File Inserts/Tabs(3)

Super Glues(3)

Copyholders(3)

Desktop Copyholders(3)

Spray Adhesives(3)

Desktop Organizers(3)

Janitorial Cloths & Wipes(2)

Cleaning Wipes(2)

Shipping Tape Dispensers(2)

Telephone Message Books & Pads(2)

Data Index Dividers(2)

Signs & Sign Holders(2)

Toilet Bowl Cleaners(2)

Spot & Stain Removers(2)

Cleaning Equipment Parts & Accessories(2)

Electrical Tapes(2)

Self-Stick Pads(2)

First Aid Kits & Supplies(2)

Fabric Protectors(2)

Laptop Stands & Pads(2)

Board Erasers(2)

Dust Mop Frames(2)

Glue Sticks & Pens(2)

Correction Tapes(2)

Bubble Wraps(2)

Medical File Tabs & Index Dividers(2)

Wound Care(1)

Self-Stick Pad Dispensers(1)

Name Badge Holders(1)

Mice(1)

CPU Stands(1)

Cleaning Sheets(1)

Computer Cloths/Wipes & Dusters(1)

Electronic Cleaners/Anti-Static Sprays(1)

Workstations/Computer Desks(1)

Photo Tape(1)

All-Purpose Glues(1)

Drawer Organizers(1)

Combination Bulletin/Dry-Erase Boards(1)

Floor & Carpet Cleaner Accessories(1)

Hangers/Hooks(1)

Tape Dispenser Replacement Cores(1)

Respirator Cartridges & Filters(1)

Packing Tape(1)

Water Filters & Purifying Dispensers(1)

Floor & Carpet Cleaners(1)

Bathroom Cleaners(1)

Letter, Legal & Jr. Pads(1)

Easel Boards(1)

Tab Inserts(1)

Screen Protectors(1)

Flag Pens(1)

Pen-Style Highlighters(1)

Tapes(1)

Postal Wraps(1)

Foil & Wraps(1)

Label Tapes(1)

Safety Gear(1)

Safety/Caution Signs(1)

Multimedia Headphones(1)

PC Headsets & Accessories(1)

Safety Vests(1)

Medical Equipment & Supplies(1)

 
Brand

Post-it®(309)

3M(246)

Scotch(243)

Scotch-Brite(55)

Command(44)

Highland(25)

Nexcare(10)

E-A-R(10)

Scotchgard(8)

Tartan(7)

Ace(6)

Peltor(5)

Tekk Protection(4)

O-Cel-O(4)

ScotchBlue(3)

Post-it Tabs(3)

Aearo(2)

Scotch Magic(1)

Post-it Notes(1)

Filtrete(1)

WorkTunes(1)

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

Post-it Notes Super Sticky(1)

 
Color

Clear(183)

Black(139)

Assorted(114)

White(88)

Yellow(70)

Green(47)

Blue(46)

Matte(45)

Glossy(44)

Canary Yellow(42)

Matte Clear(30)

Red(28)

Tan(21)

Gray(19)

Multicolor(19)

Silver(17)

Pink(16)

Orange(15)

Gold(13)

Aqua(13)

Translucent(11)

Clear Lens(10)

Lime(6)

Purple(6)

Bright Green(6)

Beige(6)

Assorted Pastel(4)

Bright Assorted(4)

Bright Blue(4)

Black Frame(3)

Cream(3)

Neon Yellow(3)

Neon Pink(2)

Transparent(2)

Mint(2)

Brown(2)

Assorted Metallic(2)

Metallic Silver(2)

Clear Temple(2)

Aqua Wave(2)

Dark Blue(2)

Light Blue(2)

Nickel(2)

Smoke(1)

Bronze(1)

Black Temple(1)

Gray Frame(1)

Blue Stem(1)

Charcoal Gray(1)

Neptune Blue(1)

Electric Yellow(1)

Pastel(1)

Gray Lens(1)

Periwinkle(1)

Black/Green(1)

Orchid(1)

Metallic Black(1)

Limeade(1)

Silver Stripe(1)

Natural(1)

Clear Hook(1)

Clear Frame(1)

Bright Pink(1)

Black Lens(1)

Tan Tint(1)

Dark Gray(1)

Electric Blue(1)

Light Gray(1)

Neon Orange(1)

Copper(1)

Lavender(1)

Ebony(1)

Charcoal(1)

Multi(1)

 
Size

5" Width(3)

Large(1)

1.88" x 49.2 yds(1)

Medium(1)

8" Width(1)

 
Size Supported

3" Width x 3" Length Note(11)

1" Width x 1.75" Length(1)

1" Width x 1.75" Length Flag(1)

1" Length Flag(1)

4" Width x 4" Length Note(1)

 
Recycled

No(776)

Yes(45)

 
Sheet Size

25" x 30"(13)

20" x 23"(6)

5 7/8" Width x 3 7/8" Length(1)

5" Width x 4" Length(1)

9" Width x 11" Length(1)

 
 
 

© 2019-2020 Panola Paper Co, All Rights Reserved