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

Craft Supplies(103)

Crayons(64)

Art Markers(62)

Craft Kits(47)

Paint Brushes(35)

Modeling Clays(30)

Creative Learning(26)

Printing Calculators(24)

Puzzles(16)

Art Paper Rolls and Sheets(12)

Glitters(11)

Bags(4)

Magnetic Shapes(4)

Portable Storage Files & Bins(4)

Shipping & Moving Boxes(3)

Bulletin Board Sets(3)

Desktop Organizers(3)

Tank-Style Highlighters(3)

Desktop Staplers(2)

Paint Dispensing Pumps(2)

Hand Soaps/Cleaners(2)

Teaching Flash Cards(2)

Non-Magnetic Letters & Numbers(2)

Cash Handling Bags(2)

Storage Boxes & Containers(2)

All-Purpose Glues(1)

Waste Containers & Accessories(1)

Maps(1)

Hand Bags(1)

Teaching Aids(1)

Public Address Systems(1)

Paper Clips(1)

Magnetic Push Pins(1)

Tool Storage & Organization(1)

Canvas/Nylon Mail Bags(1)

Chalks(1)

Stickers(1)

Liquid Soap / Sanitizer Dispensers(1)

Copy & Multi-use White Paper(1)

Glue Sticks & Pens(1)

Vinyl Numbers & Letters(1)

Brand

Crayola(175)

Creativity Street(150)

Handy Art(91)

Prang(39)

Roylco(21)

CLI(14)

Smart-Fab(13)

Dixon(13)

Trend(12)

Pacon(11)

Learning Resources(11)

Hygloss(10)

Victor(10)

Carson-Dellosa(8)

Rust-Oleum(8)

Sharp Calculators(7)

Spectra(7)

Model Magic(7)

Canon(6)

Mr. Sketch(6)

OIC(6)

MOLOTOW(6)

Pentel Arts(6)

The Pencil Grip(5)

Children's Factory(5)

Sparco(4)

Tombow(4)

RoseArt(4)

Berol(3)

Blum(3)

Business Source(3)

Prismacolor(2)

Zinsser(2)

Rainbow(2)

Swingline(2)

Teacher Created Resources(2)

LYRA(2)

Bankers Box(2)

Playfoam(2)

Akro-Mils(2)

Helix(2)

Advantus(1)

Artistic(1)

AmpliVox(1)

BIC(1)

Early Childhood Resources(1)

IRIS(1)

ECR4KIDS(1)

Boise(1)

Casio(1)

dbest(1)

Rainbow Fraction(1)

Mega Bloks(1)

Wax Works(1)

Mind Sparks(1)

Plast'r Craft(1)

Trait-tex(1)

Post-it®(1)

ChenilleKraft(1)

Pentel(1)

Color

Assorted(160)

White(60)

Black(57)

Blue(37)

Yellow(33)

Red(31)

Green(28)

Multicolor(25)

Orange(20)

Brown(17)

Natural(15)

Gray(12)

Clear(12)

Purple(12)

Multi(9)

Violet(7)

Pink(6)

Off White(5)

Silver(5)

Yellow Green(5)

Green Blue(4)

Blue-violet(4)

Sky Blue(4)

Yellow-orange(4)

Red-violet(4)

Red Orange(4)

Neon(4)

Bright Assorted(4)

Cranberry(3)

Gold(3)

Carnation Pink(3)

Terra Cotta(3)

Dark Pink(3)

Peach(2)

Tan(2)

Dark Purple(2)

Apricot(2)

Apple Green(2)

Kraft(2)

Cream(2)

Grass Green(2)

Turquoise(2)

Dark Blue(2)

Black/White(1)

Aluminum(1)

Pale Orange(1)

Deep Purple(1)

Wood Grain(1)

Lime Yellow(1)

Pale Blue(1)

Cobalt Blue(1)

Dark Green(1)

Bisque(1)

Light Blue(1)

Beige(1)

Translucent(1)

Primary(1)

Sepia(1)

Mahogany(1)

Burnt Sienna(1)

Metallic Silver(1)

Brick Red(1)

Sea Green(1)

Earth Tone(1)

Midnight Blue(1)

Metallic Gold(1)

Forest Green(1)

Goldenrod(1)

Neon Assorted(1)

Brightness

92(1)

Size

Letter(1)

Recycled

No(412)

Yes(7)

Price Range

$0-$499.99(707)

$500-$999.99(2)

$1000-$1499.99(1)

To  GO

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

© 2020-2021 Granite Office, LLC, All Rights Reserved