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(264)

Craft Supplies(123)

Crayons(78)

Art Markers(69)

Craft Kits(55)

Paint Brushes(39)

Modeling Clays(32)

Creative Learning(30)

Puzzles(30)

Printing Calculators(24)

Art Paper Rolls and Sheets(14)

Glitters(12)

Portable Storage Files & Bins(6)

Magnetic Shapes(6)

Bags(5)

Desktop Organizers(4)

Tank-Style Highlighters(3)

Bulletin Board Sets(3)

Paint Dispensing Pumps(3)

Shipping & Moving Boxes(3)

Teaching Aids(2)

Maps(2)

Desktop Staplers(2)

Canvas/Nylon Mail Bags(2)

Non-Magnetic Letters & Numbers(2)

Teaching Flash Cards(2)

Vinyl Numbers & Letters(2)

Art Portfolios(2)

Magnetic Push Pins(1)

Hand Bags(1)

Paper Clips(1)

Storage Boxes & Containers(1)

Tool Storage & Organization(1)

Office Paper(1)

All-Purpose Glues(1)

Stickers(1)

Markers(1)

Construction Paper(1)

Name Badges/Systems(1)

Chalks(1)

Magnetic Letters & Numbers(1)

Brand

Crayola(219)

Creativity Street(171)

Handy Art(91)

Prang(41)

Roylco(40)

Smart-Fab(15)

Hygloss(14)

CLI(14)

Dixon(14)

Learning Resources(13)

Pacon(12)

Trend(12)

Carson-Dellosa(11)

Victor(10)

A Broader View(9)

Rust-Oleum(9)

Sharp Calculators(7)

The Pencil Grip(7)

RoseArt(7)

Pentel Arts(7)

Spectra(7)

Mega Bloks(7)

Model Magic(7)

MOLOTOW(6)

OIC(6)

Canon(6)

Mr. Sketch(6)

Teacher Created Resources(5)

Sparco(4)

Blum(4)

Helix(4)

Tombow(4)

Staedtler(3)

Berol(3)

Zinsser(2)

Bankers Box(2)

Mind Sparks(2)

Playfoam(2)

Prismacolor(2)

Storex(2)

LYRA(2)

Akro-Mils(2)

Anglers(2)

Swingline(2)

Rainbow(2)

Artistic(1)

Advantus(1)

BeginAgain(1)

Pentel(1)

Post-it®(1)

Casio(1)

Rainbow Fraction(1)

dbest(1)

Trait-tex(1)

Plast'r Craft(1)

Business Source(1)

Boise(1)

Wax Works(1)

ChenilleKraft(1)

BIC(1)

Color

Assorted(204)

White(69)

Black(61)

Blue(38)

Yellow(33)

Red(32)

Green(30)

Multicolor(25)

Orange(22)

Natural(19)

Brown(18)

Clear(14)

Multi(13)

Gray(12)

Purple(12)

Pink(8)

Violet(7)

Silver(6)

Off White(5)

Yellow Green(5)

Bright Assorted(5)

Red-violet(4)

Red Orange(4)

Neon(4)

Blue-violet(4)

Yellow-orange(4)

Gold(4)

Sky Blue(4)

Green Blue(4)

Terra Cotta(4)

Grass Green(3)

Dark Blue(3)

Cranberry(3)

Dark Pink(3)

Carnation Pink(3)

Turquoise(2)

Tan(2)

Assorted Bright(2)

Apricot(2)

Cream(2)

Peach(2)

Apple Green(2)

Dark Purple(2)

Cobalt Blue(1)

Pale Blue(1)

Black/White(1)

Pale Orange(1)

Dark Green(1)

Deep Purple(1)

Medium Blue(1)

Aluminum(1)

Swirl(1)

Transparent(1)

Lime Yellow(1)

Neon Assorted(1)

Brick Red(1)

Forest Green(1)

Goldenrod(1)

Primary(1)

Metallic Silver(1)

Burnt Sienna(1)

Mahogany(1)

Sepia(1)

Metallic Gold(1)

Midnight Blue(1)

Earth Tone(1)

Translucent(1)

Light Blue(1)

Bisque(1)

Charcoal(1)

Sea Green(1)

Beige(1)

Sunglow(1)

Wood Grain(1)

Recycled

No(482)

Yes(18)

Price Range

$0-$99.99(793)

$100-$199.99(32)

$200-$299.99(7)

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