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

Craft Supplies(126)

Crayons(79)

Art Markers(73)

Craft Kits(55)

Puzzles(43)

Paint Brushes(39)

Creative Learning(34)

Modeling Clays(33)

Printing Calculators(27)

Art Paper Rolls and Sheets(14)

Glitters(12)

Portable Storage Files & Bins(6)

Magnetic Shapes(6)

Bags(5)

Desktop Organizers(4)

Bulletin Board Sets(3)

Paint Dispensing Pumps(3)

Shipping & Moving Boxes(3)

Teaching Aids(2)

Maps(2)

Vinyl Numbers & Letters(2)

Non-Magnetic Letters & Numbers(2)

Canvas/Nylon Mail Bags(2)

Teaching Flash Cards(2)

Art Portfolios(2)

Storage Boxes & Containers(2)

Office Paper(1)

Paper Clips(1)

Hand Bags(1)

Paper Rolls(1)

Push Pins(1)

Name Badges/Systems(1)

Magnetic Letters & Numbers(1)

Stickers(1)

Construction Paper(1)

Tool Storage & Organization(1)

Chalks(1)

All-Purpose Glues(1)

Brand

Crayola(223)

Creativity Street(167)

Handy Art(91)

Prang(48)

Roylco(41)

Dixon(24)

Hygloss(18)

BeginAgain(17)

Smart-Fab(15)

CLI(14)

Learning Resources(13)

Pacon(13)

Trend(12)

Victor(11)

Carson-Dellosa(11)

A Broader View(9)

Rust-Oleum(9)

The Pencil Grip(8)

Mega Bloks(8)

Sharp Calculators(7)

Spectra(7)

RoseArt(7)

Model Magic(7)

Pentel Arts(6)

Mr. Sketch(6)

OIC(6)

Canon(6)

Sparco(5)

Helix(5)

Teacher Created Resources(5)

Blum(4)

Casio(3)

Staedtler(3)

Anglers(2)

Zinsser(2)

Mind Sparks(2)

Storex(2)

Akro-Mils(2)

Prismacolor(2)

Pentel(2)

Playfoam(2)

Bankers Box(2)

Rainbow(2)

LYRA(2)

Baumgartens(1)

Rainbow Fraction(1)

Advantus(1)

C-Line(1)

Artistic(1)

ChenilleKraft(1)

BIC(1)

Post-it®(1)

Plast'r Craft(1)

dbest(1)

Trait-tex(1)

Wax Works(1)

Boise(1)

Business Source(1)

Color

Assorted(219)

White(73)

Black(63)

Blue(39)

Red(34)

Yellow(34)

Green(31)

Multicolor(25)

Orange(22)

Brown(19)

Natural(19)

Clear(15)

Multi(14)

Gray(12)

Purple(11)

Violet(8)

Pink(8)

Silver(6)

Off White(5)

Yellow Green(5)

Bright Assorted(5)

Red-violet(4)

Red Orange(4)

Yellow-orange(4)

Blue-violet(4)

Sky Blue(4)

Gold(4)

Neon(4)

Green Blue(4)

Terra Cotta(4)

Grass Green(3)

Dark Blue(3)

Cranberry(3)

Dark Pink(3)

Carnation Pink(3)

Apricot(2)

Tan(2)

Assorted Bright(2)

Turquoise(2)

Cream(2)

Apple Green(2)

Dark Purple(2)

Peach(2)

Cobalt Blue(1)

Pale Blue(1)

Black/White(1)

Pale Orange(1)

Aqua(1)

Deep Purple(1)

Light Blue(1)

Aluminum(1)

Swirl(1)

Transparent(1)

Lime Yellow(1)

Neon Assorted(1)

Brick Red(1)

Forest Green(1)

Goldenrod(1)

Sepia(1)

Metallic Silver(1)

Burnt Sienna(1)

Mahogany(1)

Translucent(1)

Metallic Gold(1)

Midnight Blue(1)

Earth Tone(1)

Primary(1)

Wood Grain(1)

Bisque(1)

Charcoal(1)

Sea Green(1)

Beige(1)

Sunglow(1)

Medium Blue(1)

Size

8 1/2 x 11(1)

Recycled

No(494)

Yes(18)

Price Range

$0-$99.99(832)

$100-$199.99(30)

$200-$299.99(5)

To  GO

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

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