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)

Privacy Filters(76)

Transparent & Invisible Tapes(60)

Packaging Tapes(57)

Flags(50)

Hooks & Hangers(26)

Sponges & Scouring Pads(25)

Mounting Tapes(22)

Dry-Erase Boards(22)

Hearing Protection(21)

Tape Dispensers(19)

Eye Protection(19)

Masking Tapes(18)

Easel 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)

Packaging Tape(12)

Double-Sided Tapes(12)

Top Tab Accessories(11)

Safety Masks(11)

Mouse & Keyboard Wrist Rests(10)

Laminating Machines(9)

Adhesive Corner(9)

Keyboard/Mouse Platforms & Trays(9)

Safety Tapes(7)

Flag/Tab Dispensers(7)

Filament Tape(7)

Mops & Mop Refills(6)

Duct Tapes(5)

Air Respirator Accessories(5)

Monitor Arms(5)

Packing List/Invoice Enclosed Envelopes(5)

Cork/Fabric Bulletin Boards(5)

Lint Rollers(5)

Mailing Tubes(4)

Desktop Organizers(4)

Safety Helmets(4)

Coat/Garment Hooks(4)

Cable Management(4)

Multipurpose Cleaners(4)

Glue Rollers(4)

Book Tapes(3)

Protectors(3)

Spray Adhesives(3)

Copyholders(3)

Correction Tapes(3)

Glue Sticks & Pens(3)

Mouse Pads(3)

Display Boards(3)

Shipping Tape Dispensers(2)

First Aid Kits & Supplies(2)

Desktop Copyholders(2)

Cleaning Wipes(2)

Water Filters & Purifying Dispensers(2)

Signs & Sign Holders(2)

Telephone Message Books & Pads(2)

Data Index Dividers(2)

Board Erasers(2)

Dust Mop Frames(2)

Fabric Protectors(2)

Tab Inserts(2)

Wound Care(2)

Medical File Tabs & Index Dividers(2)

Laptop Stands & Pads(2)

Monitor Stands/Risers(2)

Cleaning Sheets(1)

CPU Stands(1)

Name Badge Holders(1)

Workstations/Computer Desks(1)

Computer Cloths/Wipes & Dusters(1)

Photo Tape(1)

Mice(1)

Label Tapes(1)

Combination Bulletin/Dry-Erase Boards(1)

All-Purpose Glues(1)

Flag Pens(1)

Easel Boards(1)

Letter, Legal & Jr. Pads(1)

Electrical Tapes(1)

Bathroom Cleaners(1)

Binder Clips(1)

Pen-Style Highlighters(1)

Tape Dispenser Replacement Cores(1)

Super Glues(1)

Spot & Stain Removers(1)

Drawer Organizers(1)

Multimedia Headphones(1)

Janitorial Cloths & Wipes(1)

Safety Gear(1)

Mounting Putty(1)

Safety/Caution Signs(1)

Electronic Cleaners/Anti-Static Sprays(1)

 
Brand

Post-it®(301)

3M(260)

Scotch(227)

Command(45)

Scotch-Brite(27)

E-A-R(10)

Nexcare(10)

Tartan(9)

Ace(6)

Scotchgard(6)

Highland(5)

Peltor(5)

Tekk Protection(5)

ScotchBlue(3)

O-Cel-O(2)

Aearo(2)

Filtrete(2)

Scotch Magic(1)

 
Color

Clear(181)

Black(141)

Assorted(111)

White(90)

Yellow(61)

Matte(50)

Canary Yellow(42)

Green(36)

Blue(32)

Red(29)

Matte Clear(26)

Tan(20)

Multicolor(18)

Glossy(18)

Orange(15)

Pink(15)

Silver(15)

Gray(14)

Aqua(13)

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)

8" Width(1)

Medium(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(738)

Yes(50)

 
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 Panola Paper Co, All Rights Reserved