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','out_of_stock') 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(242)

Art & Craft Kits(183)

Crayons(70)

Pens/Markers/Highlighters(61)

Paint Brushes/Rollers & Accessories(35)

Educational/Development Toys(30)

Calculators(24)

Decorative Characters & Shapes(24)

Puzzles(22)

Pins & Clamps(7)

Shipping & Storage Boxes/Tanks(6)

Educational Aids/Kits(5)

Carrying Cases(4)

Yarn/Thread(4)

Media Holders(4)

Racks & Organizers(3)

Holders(2)

Staplers(2)

Multifunction Writing Instruments/Sets(2)

Paint Dispensers/Pumps(2)

Hand Soaps/Cleaners(2)

Maps(1)

Liquid Soap / Sanitizer Dispensers(1)

Glues(1)

Wastebaskets & Trash Cans(1)

Public Address Systems(1)

Printing Media(1)

Board/Card Games(1)

Party Favors(1)

Miscellaneous Devices(1)

Brand

Crayola(195)

Creativity Street(153)

Handy Art(91)

Prang(40)

Roylco(29)

Dixon(13)

Hygloss(13)

CLI(13)

Learning Resources(12)

Trend(12)

Pacon(12)

Victor(10)

Carson-Dellosa(10)

Rust-Oleum(8)

Spectra(7)

Pentel Arts(7)

Model Magic(7)

Sharp Calculators(7)

RoseArt(6)

OIC(6)

A Broader View(6)

Canon(6)

Children's Factory(5)

The Pencil Grip(5)

Mr. Sketch(5)

Blum(4)

Mega Bloks(4)

Sparco(4)

Smart-Fab(4)

Tombow(4)

Business Source(3)

Rainbow(2)

Zinsser(2)

Akro-Mils(2)

Bankers Box(2)

Teacher Created Resources(2)

Advantus(2)

Swingline(2)

Playfoam(2)

Berol(2)

Helix(2)

Prismacolor(1)

Post-it®(1)

LYRA(1)

ECR4KIDS(1)

Early Childhood Resources(1)

BIC(1)

dbest(1)

ChenilleKraft(1)

Casio(1)

AmpliVox(1)

Artistic(1)

Plast'r Craft(1)

Wax Works(1)

Mind Sparks(1)

Trait-tex(1)

Boise(1)

IRIS(1)

Rainbow Fraction(1)

Pentel(1)

Color

Assorted(180)

White(60)

Black(57)

Blue(38)

Red(30)

Yellow(30)

Green(29)

Multicolor(27)

Orange(19)

Natural(17)

Brown(15)

Clear(13)

Purple(12)

Gray(12)

Multi(11)

Pink(7)

Violet(7)

Off White(5)

Silver(5)

Bright Assorted(5)

Yellow Green(5)

Green Blue(4)

Blue-violet(4)

Red-violet(4)

Yellow-orange(4)

Red Orange(4)

Neon(4)

Terra Cotta(3)

Gold(3)

Carnation Pink(3)

Sky Blue(2)

Apricot(2)

Kraft(2)

Turquoise(2)

Dark Pink(2)

Peach(2)

Tan(2)

Cranberry(1)

Apple Green(1)

Medium Blue(1)

Aluminum(1)

Dark Green(1)

Black/White(1)

Cobalt Blue(1)

Wood Grain(1)

Cream(1)

Dark Purple(1)

Grass Green(1)

Lime Yellow(1)

Pale Blue(1)

Pale Orange(1)

Dark Blue(1)

Bisque(1)

Light Blue(1)

Beige(1)

Translucent(1)

Primary(1)

Sepia(1)

Mahogany(1)

Burnt Sienna(1)

Metallic Silver(1)

Brick Red(1)

Sea Green(1)

Earth Tone(1)

Midnight Blue(1)

Metallic Gold(1)

Forest Green(1)

Goldenrod(1)

Neon Assorted(1)

Brightness

92(1)

Size

Letter(1)

Recycled

No(426)

Yes(13)

Price Range

$0-$499.99(740)

$500-$999.99(2)

$1000-$1499.99(1)

To  GO

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

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