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 CASE WHEN ds.type='hot deals' THEN `ds`.`expiration_date` >= CURDATE() else CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` END 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 (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>office>offices)+(>supply>supply)' IN BOOLEAN MODE) OR (`category_name` LIKE 'office supplies') OR (`pinfo`.`manufacturer_prefix` LIKE '%office supplies%' OR `pinfo`.`manufacturer_name` LIKE '%office supplies%' OR `pinfo`.`sku` LIKE '%office supplies%' OR `pinfo`.`desc_long` LIKE '%office supplies%' OR `pinfo`.`desc_title` LIKE '%office supplies%' OR `pinfo`.`keywords` LIKE '%office supplies%') ) 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 ('office +supply' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+office +supply' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"office supply"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"office supply"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"office supply"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"office supply"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+office +supply' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='supply',`category_4` ='supply') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'supply,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('supply', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Office Supplies

Refine Search

  GO
Category

Paints(282)

Craft Supplies(131)

Crayons(89)

Art Markers(80)

Craft Kits(64)

Paint Brushes(47)

Creative Learning(47)

Modeling Clays(36)

Puzzles(32)

Printing Calculators(24)

Art Paper Rolls and Sheets(14)

Glitters(12)

Portable Storage Files & Bins(6)

Magnetic Shapes(6)

Bags(5)

Desktop Organizers(4)

Storage Boxes & Containers(4)

Bulletin Board Sets(3)

Paint Dispensing Pumps(3)

Shipping & Moving Boxes(3)

Tank-Style Highlighters(3)

Teaching Aids(2)

Vinyl Numbers & Letters(2)

Desktop Staplers(2)

Maps(2)

Teaching Flash Cards(2)

Storage Cabinets(2)

Non-Magnetic Letters & Numbers(2)

Art Portfolios(2)

Canvas/Nylon Mail Bags(2)

Hand Bags(1)

Paper Clips(1)

Classroom Decorations(1)

Push Pins(1)

Tool Storage & Organization(1)

Magnetic Push Pins(1)

Calculators(1)

Magnetic Letters & Numbers(1)

Markers(1)

Stickers(1)

Construction Paper(1)

Name Badges/Systems(1)

All-Purpose Glues(1)

Office Paper(1)

Chalks(1)

Brand

Crayola(235)

Creativity Street(175)

Handy Art(93)

Prang(49)

Roylco(41)

Dixon(23)

Hygloss(18)

Smart-Fab(15)

Pacon(15)

Learning Resources(15)

CLI(14)

Trend(12)

Carson-Dellosa(11)

Victor(11)

A Broader View(9)

Rust-Oleum(9)

RoseArt(8)

The Pencil Grip(8)

Mr. Sketch(8)

Mega Bloks(7)

Model Magic(7)

Spectra(7)

ECR4KIDS(7)

Sharp Calculators(7)

VELCRO® Brand(6)

Pentel Arts(6)

OIC(6)

MOLOTOW(6)

Canon(6)

Teacher Created Resources(5)

Sparco(5)

Children's Factory(5)

Helix(5)

Blum(4)

Tombow(4)

Armadillo Arts & Craft(4)

Berol(3)

Mead(3)

Prismacolor(3)

Advantus(3)

Staedtler(3)

Pentel(2)

Zinsser(2)

Storex(2)

basyx(2)

Swingline(2)

BeginAgain(2)

Akro-Mils(2)

Mind Sparks(2)

LYRA(2)

Derwent(2)

Anglers(2)

Bankers Box(2)

Playfoam(2)

Rainbow(2)

Educational Insights(2)

BIC(1)

Baumgartens(1)

Rainbow Fraction(1)

Artistic(1)

Boise(1)

Post-it®(1)

C-Line(1)

Plast'r Craft(1)

Casio(1)

Early Childhood Resources(1)

Trait-tex(1)

Sparmax(1)

Wax Works(1)

Sharpie(1)

ChenilleKraft(1)

dbest(1)

Business Source(1)

Color

Assorted(218)

White(79)

Black(65)

Blue(47)

Yellow(44)

Red(39)

Green(36)

Multicolor(30)

Orange(26)

Natural(22)

Multi(22)

Brown(20)

Clear(16)

Purple(14)

Gray(13)

Violet(11)

Pink(10)

Silver(9)

Yellow Green(6)

Green Blue(5)

Yellow-orange(5)

Red-violet(5)

Blue-violet(5)

Red Orange(5)

Neon(5)

Bright Assorted(5)

Off White(5)

Terra Cotta(4)

Gold(4)

Sky Blue(4)

Carnation Pink(3)

Dark Blue(3)

Dark Pink(3)

Turquoise(3)

Peach(3)

Cranberry(3)

Grass Green(3)

Putty(2)

Apple Green(2)

Apricot(2)

Dark Purple(2)

Cream(2)

Tan(2)

Assorted Bright(2)

Cobalt(1)

Blue Purple(1)

Brilliant Blue(1)

Red Brown(1)

Brilliant Green(1)

Cyanine(1)

Deep Black(1)

Leaf Green(1)

Light Peach(1)

Deep Purple(1)

Transparent(1)

Swirl(1)

Shamrock(1)

Lime Yellow(1)

Pale Orange(1)

Dark Green(1)

Cobalt Blue(1)

Pale Blue(1)

Black/White(1)

Metallic Gold(1)

Burnt Sienna(1)

Mahogany(1)

Metallic Silver(1)

Brick Red(1)

Goldenrod(1)

Forest Green(1)

Sepia(1)

Primary(1)

Translucent(1)

Aluminum(1)

Aqua(1)

Beige(1)

Light Blue(1)

Midnight Blue(1)

Sea Green(1)

Brilliant Red(1)

Yellow Ochre(1)

Deep Orange(1)

Crimson(1)

Light Brown(1)

Medium Blue(1)

Wood Grain(1)

Charcoal(1)

Sunglow(1)

Bisque(1)

Earth Tone(1)

Neon Assorted(1)

Burnt Umber(1)

Size

8 x 11(1)

Recycled

No(553)

Yes(18)

Price Range

$0-$499.99(924)

$500-$999.99(3)

$1000-$1499.99(1)

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