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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`manufacturer_id` = "1700403") 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 MATCH(`desc_short`) AGAINST ('Pacon' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Pacon' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Pacon"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Pacon"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Pacon"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Pacon"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Pacon' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Pacon',`category_4` ='Pacon') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Pacon,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Pacon', `pinfo`.`desc_title`)) DESC

Manufacturer

Currently Filtered by

Manufacturer

Pacon

Refine Search

  GO
Category

Construction Paper(213)

Art Paper Rolls and Sheets(76)

Kraft Paper(59)

Poster Boards(53)

Sketch Pads & Drawing Paper(38)

Craft Kits(29)

Handwriting Paper(29)

Bulletin Board Borders(26)

Copy & Multi-use Colored Paper(23)

Craft Supplies(20)

Display Boards(18)

Charts(15)

Learning Boards(12)

Easel Pads(12)

Memo / Subject Notebooks(12)

Vinyl Numbers & Letters(10)

Filler Papers(10)

Card Stock(8)

Glitters(7)

Non-Magnetic Letters & Numbers(7)

Magnetic Letters & Numbers(7)

Dry-Erase Boards(6)

Tissue Paper(4)

Cover Stock(4)

Desktop Organizers(4)

Drafting & Tracing Paper(4)

Panels/Partitions(3)

Mailroom Sorters & Tables(3)

Creative Learning(3)

Rugs(3)

Stickers(3)

Teaching Flash Cards(3)

Teacher/Classroom Management(3)

Letter, Legal & Jr. Pads(2)

Art Paper Racks(2)

Bright Paper(2)

Quadrille Pads(2)

Aprons(2)

Wide Format Paper(2)

Bags(2)

Literature Organizers/Sorters(2)

Foam Boards(2)

Desktop File Sorters(1)

Puzzles(1)

Tapes(1)

Combination Bulletin/Dry-Erase Boards(1)

Shipping & Moving Boxes(1)

Hand Bags(1)

Frames(1)

Vinyl/Plastic Pockets & Sleeves(1)

Magazine Files(1)

Laminating Supplies(1)

Stretch Wrap & Dispensers(1)

Portable Storage Files & Bins(1)

Catalog Racks(1)

Brand

Pacon(332)

Tru-Ray(90)

Riverside(56)

Fadeless(55)

SunWorks(54)

Bordette(26)

Spectra ArtKraft(22)

Creativity Street(22)

Rainbow(19)

Classroom Keepers(13)

Decorol(12)

Art1st(11)

Zaner-Bloser(8)

Spectra(7)

Learn It By Art™(6)

Ecology(6)

GoWrite!®(5)

Mind Sparks(4)

Peacock(2)

Mavalus(1)

Ghostline(1)

KolorFast(1)

The Present-It(1)

Plast'r Craft(1)

Trait-tex(1)

Spectra Art Tissue(1)

Wax Works(1)

Color

Assorted(95)

White(71)

Blue(39)

Black(37)

Red(29)

Pink(21)

Orange(21)

Yellow(21)

Green(20)

Brown(17)

Gray(13)

Purple(11)

Violet(10)

Sky Blue(9)

Royal Blue(9)

Gold(9)

Dark Blue(8)

Manila(8)

Natural(8)

Tan(8)

Holiday Red(7)

Light Green(7)

Dark Brown(7)

Light Blue(7)

Holiday Green(7)

Magenta(6)

Brite Blue(6)

Silver(6)

Canary(6)

Lilac(6)

Festive Green(5)

Turquoise(5)

Scarlet(5)

Festive Red(5)

Dark Green(5)

Apple Green(4)

Slate Gray(4)

Assorted Neon(3)

Light Brown(3)

Shocking Pink(3)

Salmon(3)

Hot Pink(3)

Flame Red(3)

Brite Green(3)

Clear(3)

Bright White(3)

Woodgrain(3)

Lime(3)

Pumpkin(2)

Cherry(2)

Neon Red(2)

Neon Pink(2)

Pastel Lilac(2)

Rich Blue(2)

Emerald Green(2)

Flame(2)

Brilliant Lime(2)

Neon Yellow(2)

Raspberry(2)

Rojo Red(2)

Hyper Pink(2)

Lemon Yellow(2)

Lite Green(2)

Cobalt Blue(2)

Light Yellow(2)

Pewter(2)

Black/White(2)

Autumn Gold(1)

Porcelain White(1)

Hot Lime(1)

Blonde(1)

Cloud(1)

Metallic Gray(1)

Aqua(1)

Hot Blue(1)

Night Sky(1)

Azure Blue(1)

Assorted Drawer(1)

Rocker Magenta(1)

Nautical Navy(1)

Sassy Yellow(1)

Glorious Green(1)

Deep Purple(1)

Azure(1)

Outrageous Orange(1)

Nile Green(1)

Teal(1)

Jet Black(1)

Cosmic Blue(1)

Positively Purple(1)

Bright Blue(1)

Pumpkin Orange(1)

Lime Green(1)

Pastel Green(1)

Pastel Canary(1)

Pastel Pink(1)

Pastel Blue(1)

Bright Assorted(1)

Hyper Lime(1)

Marine Blue(1)

Violet Purple(1)

Turquoise Blue(1)

Hyper Yellow(1)

Hyper Orange(1)

Ivory(1)

Warm Brown(1)

Pastel Ivory(1)

Bright Yellow(1)

Dark Red(1)

Sunset Gold(1)

Emerald(1)

Pastel Gray(1)

Bright Lime(1)

Bright Orange(1)

Neon Green(1)

Pastel Watermelon(1)

Neon Orange(1)

Pastel Sky Blue(1)

Bright Pink(1)

Plaid(1)

Size

Letter(57)

Government-Letter(1)

Recycled

No(365)

Yes(314)

Price Range

$0-$499.99(760)

$500-$999.99(2)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2019-2020 Granite Office, LLC, All Rights Reserved