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

Craft Supplies(122)

Crayons(73)

Art Markers(66)

Craft Kits(55)

Paint Brushes(39)

Creative Learning(37)

Modeling Clays(31)

Puzzles(29)

Printing Calculators(24)

Art Paper Rolls and Sheets(14)

Glitters(12)

Portable Storage Files & Bins(6)

Magnetic Shapes(6)

Bags(5)

Desktop Organizers(4)

Paint Dispensing Pumps(3)

Shipping & Moving Boxes(3)

Bulletin Board Sets(3)

Tank-Style Highlighters(3)

Maps(2)

Teaching Aids(2)

Desktop Staplers(2)

Vinyl Numbers & Letters(2)

Non-Magnetic Letters & Numbers(2)

Art Portfolios(2)

Teaching Flash Cards(2)

Office Paper(1)

Storage Boxes & Containers(1)

Paper Clips(1)

Hand Bags(1)

Glue Sticks & Pens(1)

Name Badges/Systems(1)

All-Purpose Glues(1)

Magnetic Push Pins(1)

Tool Storage & Organization(1)

Canvas/Nylon Mail Bags(1)

Construction Paper(1)

Chalks(1)

Stickers(1)

Magnetic Letters & Numbers(1)

Brand

Crayola(200)

Creativity Street(168)

Handy Art(91)

Prang(41)

Roylco(40)

Smart-Fab(15)

Hygloss(14)

CLI(14)

Dixon(13)

Learning Resources(13)

Pacon(12)

Trend(12)

Carson-Dellosa(11)

Victor(10)

Rust-Oleum(9)

A Broader View(9)

RoseArt(7)

Pentel Arts(7)

Spectra(7)

Mega Bloks(7)

Sharp Calculators(7)

Model Magic(7)

OIC(6)

Mr. Sketch(6)

Canon(6)

The Pencil Grip(6)

MOLOTOW(6)

Children's Factory(5)

Teacher Created Resources(5)

Helix(4)

Blum(4)

Sparco(4)

Tombow(4)

Berol(3)

Mind Sparks(2)

Zinsser(2)

Akro-Mils(2)

Anglers(2)

Rainbow(2)

Playfoam(2)

Swingline(2)

LYRA(2)

Bankers Box(2)

Prismacolor(2)

Storex(2)

Staedtler(1)

Rainbow Fraction(1)

Business Source(1)

Boise(1)

ChenilleKraft(1)

BIC(1)

BeginAgain(1)

Artistic(1)

Advantus(1)

Casio(1)

dbest(1)

Plast'r Craft(1)

Wax Works(1)

Trait-tex(1)

Post-it®(1)

ECR4KIDS(1)

Early Childhood Resources(1)

Pentel(1)

Color

Assorted(198)

White(67)

Black(61)

Blue(39)

Yellow(34)

Red(33)

Green(31)

Multicolor(29)

Orange(23)

Natural(19)

Brown(18)

Multi(14)

Clear(14)

Purple(13)

Gray(12)

Pink(8)

Violet(7)

Silver(6)

Yellow Green(5)

Bright Assorted(5)

Off White(5)

Blue-violet(4)

Green Blue(4)

Red Orange(4)

Yellow-orange(4)

Gold(4)

Sky Blue(4)

Red-violet(4)

Neon(4)

Grass Green(3)

Dark Blue(3)

Terra Cotta(3)

Cranberry(3)

Dark Pink(3)

Carnation Pink(3)

Peach(2)

Tan(2)

Assorted Bright(2)

Turquoise(2)

Apricot(2)

Apple Green(2)

Dark Purple(2)

Cream(2)

Pale Blue(1)

Cobalt Blue(1)

Dark Green(1)

Pale Orange(1)

Lime Yellow(1)

Aluminum(1)

Swirl(1)

Transparent(1)

Black/White(1)

Deep Purple(1)

Neon Assorted(1)

Metallic Silver(1)

Brick Red(1)

Forest Green(1)

Beige(1)

Light Blue(1)

Burnt Sienna(1)

Sepia(1)

Primary(1)

Goldenrod(1)

Metallic Gold(1)

Mahogany(1)

Translucent(1)

Wood Grain(1)

Earth Tone(1)

Bisque(1)

Midnight Blue(1)

Sea Green(1)

Medium Blue(1)

Recycled

No(480)

Yes(18)

Price Range

$0-$499.99(811)

$500-$999.99(1)

$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