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)

Decorative Characters & Shapes(24)

Calculators(24)

Puzzles(22)

Pins & Clamps(7)

Shipping & Storage Boxes/Tanks(6)

Educational Aids/Kits(5)

Carrying Cases(4)

Media Holders(4)

Yarn/Thread(4)

Racks & Organizers(3)

Hand Soaps/Cleaners(2)

Paint Dispensers/Pumps(2)

Multifunction Writing Instruments/Sets(2)

Staplers(2)

Holders(2)

Miscellaneous Devices(1)

Party Favors(1)

Glues(1)

Liquid Soap / Sanitizer Dispensers(1)

Printing Media(1)

Wastebaskets & Trash Cans(1)

Maps(1)

Public Address Systems(1)

Board/Card Games(1)

Brand

Crayola(195)

Creativity Street(153)

Handy Art(91)

Prang(40)

Roylco(29)

CLI(13)

Hygloss(13)

Dixon(13)

Learning Resources(12)

Trend(12)

Pacon(12)

Victor(10)

Carson-Dellosa(10)

Rust-Oleum(8)

Pentel Arts(7)

Spectra(7)

Sharp Calculators(7)

Model Magic(7)

A Broader View(6)

RoseArt(6)

Canon(6)

OIC(6)

The Pencil Grip(5)

Children's Factory(5)

Mr. Sketch(5)

Mega Bloks(4)

Smart-Fab(4)

Tombow(4)

Sparco(4)

Blum(4)

Business Source(3)

Helix(2)

Berol(2)

Bankers Box(2)

Playfoam(2)

Advantus(2)

Swingline(2)

Rainbow(2)

Teacher Created Resources(2)

Zinsser(2)

Akro-Mils(2)

Prismacolor(1)

AmpliVox(1)

Artistic(1)

ChenilleKraft(1)

Pentel(1)

Mind Sparks(1)

Wax Works(1)

Plast'r Craft(1)

Post-it®(1)

Rainbow Fraction(1)

BIC(1)

IRIS(1)

Early Childhood Resources(1)

ECR4KIDS(1)

LYRA(1)

Boise(1)

dbest(1)

Casio(1)

Trait-tex(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)

Violet(7)

Pink(7)

Yellow Green(5)

Off White(5)

Bright Assorted(5)

Silver(5)

Red Orange(4)

Yellow-orange(4)

Red-violet(4)

Neon(4)

Green Blue(4)

Blue-violet(4)

Carnation Pink(3)

Gold(3)

Terra Cotta(3)

Dark Pink(2)

Kraft(2)

Sky Blue(2)

Turquoise(2)

Tan(2)

Apricot(2)

Peach(2)

Burnt Sienna(1)

Translucent(1)

Dark Green(1)

Cobalt Blue(1)

Pale Blue(1)

Pale Orange(1)

Lime Yellow(1)

Dark Blue(1)

Cream(1)

Black/White(1)

Dark Purple(1)

Grass Green(1)

Apple Green(1)

Cranberry(1)

Light Blue(1)

Primary(1)

Medium Blue(1)

Wood Grain(1)

Mahogany(1)

Aluminum(1)

Neon Assorted(1)

Earth Tone(1)

Bisque(1)

Sepia(1)

Sea Green(1)

Beige(1)

Metallic Gold(1)

Goldenrod(1)

Forest Green(1)

Brick Red(1)

Metallic Silver(1)

Midnight Blue(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