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)

Craft Supplies(112)

Crayons(75)

Art Markers(63)

Craft Kits(51)

Paint Brushes(39)

Creative Learning(38)

Modeling Clays(30)

Printing Calculators(24)

Puzzles(24)

Glitters(12)

Art Paper Rolls and Sheets(12)

Magnetic Shapes(6)

Bags(5)

Desktop Organizers(4)

Portable Storage Files & Bins(4)

Shipping & Moving Boxes(3)

Bulletin Board Sets(3)

Tank-Style Highlighters(3)

Hand Soaps/Cleaners(2)

Desktop Staplers(2)

Non-Magnetic Letters & Numbers(2)

Cash Handling Bags(2)

Paint Dispensing Pumps(2)

Teaching Flash Cards(2)

Storage Boxes & Containers(2)

Hand Bags(1)

All-Purpose Glues(1)

Maps(1)

Paper Clips(1)

Construction Paper(1)

Stickers(1)

Liquid Soap / Sanitizer Dispensers(1)

Chalks(1)

Vinyl Numbers & Letters(1)

Canvas/Nylon Mail Bags(1)

Tool Storage & Organization(1)

Glue Sticks & Pens(1)

Office Paper(1)

Magnetic Push Pins(1)

Waste Containers & Accessories(1)

Public Address Systems(1)

Teaching Aids(1)

Brand

Crayola(196)

Creativity Street(161)

Handy Art(91)

Prang(40)

Roylco(29)

CLI(14)

Smart-Fab(13)

Hygloss(13)

Dixon(13)

Trend(12)

Learning Resources(12)

Pacon(11)

Victor(10)

Carson Dellosa Education(10)

Rust-Oleum(8)

Model Magic(7)

Sharp Calculators(7)

Pentel Arts(7)

Spectra(7)

A Broader View(6)

MOLOTOW(6)

Canon(6)

Mr. Sketch(6)

RoseArt(6)

ECR4KIDS(6)

OIC(6)

The Pencil Grip(5)

Children's Factory(5)

Sparco(4)

Blum(4)

Tombow(4)

Mega Bloks(4)

Armadillo Arts & Craft(4)

Berol(3)

Business Source(3)

Helix(2)

LYRA(2)

Playfoam(2)

Rainbow(2)

Swingline(2)

Prismacolor(2)

Teacher Created Resources(2)

Bankers Box(2)

Advantus(2)

Akro-Mils(2)

Zinsser(2)

dbest(1)

Sparmax(1)

Boise(1)

Casio(1)

Pentel(1)

Artistic(1)

Early Childhood Resources(1)

BIC(1)

Mind Sparks(1)

Wax Works(1)

Plast'r Craft(1)

Trait-tex(1)

ChenilleKraft(1)

Post-it®(1)

Rainbow Fraction(1)

IRIS(1)

AmpliVox(1)

Color

Assorted(193)

White(61)

Black(58)

Blue(39)

Yellow(34)

Red(32)

Green(30)

Multicolor(27)

Orange(21)

Natural(18)

Brown(17)

Clear(13)

Gray(12)

Purple(12)

Multi(11)

Silver(7)

Pink(7)

Violet(7)

Yellow Green(5)

Off White(5)

Bright Assorted(5)

Red-violet(4)

Green Blue(4)

Sky Blue(4)

Yellow-orange(4)

Red Orange(4)

Blue-violet(4)

Neon(4)

Dark Pink(3)

Cranberry(3)

Gold(3)

Terra Cotta(3)

Carnation Pink(3)

Dark Blue(2)

Turquoise(2)

Cream(2)

Apple Green(2)

Grass Green(2)

Dark Purple(2)

Kraft(2)

Peach(2)

Apricot(2)

Tan(2)

Deep Purple(1)

Lime Yellow(1)

Pale Orange(1)

Pale Blue(1)

Cobalt Blue(1)

Dark Green(1)

Black/White(1)

Medium Blue(1)

Beige(1)

Wood Grain(1)

Metallic Silver(1)

Light Blue(1)

Primary(1)

Sepia(1)

Mahogany(1)

Burnt Sienna(1)

Translucent(1)

Brick Red(1)

Aluminum(1)

Forest Green(1)

Goldenrod(1)

Metallic Gold(1)

Midnight Blue(1)

Bisque(1)

Earth Tone(1)

Neon Assorted(1)

Sea Green(1)

Recycled

No(455)

Yes(13)

Price Range

$0-$499.99(778)

$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