Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/graniteo/public_html/modules/search_new/SearchBase.php on line 105
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 (`category_name` LIKE "") 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 ('09' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+09' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"09"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"09"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"09"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"09"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+09' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='09',`category_4` ='09') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE '09,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('09', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

09

Refine Search

  GO
Brand

Blue Sky(79)

At-A-Glance(79)

Xerox(32)

Kyocera(23)

HP(20)

Oki(20)

Business Source(11)

3M(10)

Febreze(8)

Pledge(7)

Ziploc(7)

Protected Chef(7)

Softsoap(5)

Windex(5)

Sharp(4)

Airwick(4)

Fantastik(3)

Canon(3)

First Aid Only(3)

Scrubbing Bubbles(2)

Milan(2)

Glade(2)

Drano(2)

Office Snax(2)

Curad(2)

Eveready(2)

HON(2)

Coffee-mate(2)

Fellowes(1)

Shout(1)

Coffee Pro(1)

Palmolive(1)

Comet(1)

Tylenol(1)

Special K(1)

Post-it(1)

Airborne(1)

Pyramid(1)

Rubbermaid Commercial(1)

Ricoh(1)

Raid(1)

Konica Minolta(1)

Motrin(1)

Color

Multi(45)

Assorted(43)

Multicolor(27)

Black(21)

Clear(18)

Blue(9)

White(8)

Gold(5)

Matte(4)

Gray(4)

Orange(3)

Navy(3)

Navy Blue(3)

Teal(3)

Brown(3)

Red(3)

Pink(3)

Yellow(2)

Blue/White(2)

Heather(2)

Purple(2)

Floral(2)

Green(2)

Olive Green(2)

Blue/Green(1)

Lacquer(1)

Natural(1)

Stainless Steel(1)

Silver(1)

Light Blue(1)

Brightness

92(4)

Size

Letter(4)

Recycled

Yes(135)

No(65)

Manufacturer Part Number

PF101W9B(1)

GF170C4B(1)

GF156W9B(1)

GF141W1B(1)

PF201W1B(1)

PF260W1B(1)

83475(1)

79976(1)

SD60B(1)

PF270W1B(1)

GF140W9B(1)

GF133W9B(1)

TK-897K(1)

TK-897C(1)

TK-8507Y(1)

TK-8507M(1)

TK-897M(1)

TK-897Y(1)

DEF50X4(1)

CUR26600D(1)

CUR0055RB(1)

3598(1)

6270(1)

46507603(1)

46507602(1)

46507601(1)

46507504(1)

46507604(1)

46508701(1)

8961MCT(1)

46508704(1)

46508703(1)

46508702(1)

46507503(1)

46507502(1)

46507304(1)

46507303(1)

46507302(1)

44968308(1)

46507401(1)

46507402(1)

46507501(1)

46507404(1)

46507403(1)

TK-8507K(1)

TK-8507C(1)

CF460X(1)

CF453A(1)

CF452A(1)

CF451A(1)

CF461X(1)

CF462X(1)

CF472X(1)

CF471X(1)

CF470X(1)

CF463X(1)

CF450A(1)

CF400XD(1)

CF237A(1)

CF226XD(1)

8042901(1)

90111(1)

CF237X(1)

CF237Y(1)

CF287XD(1)

CF253XM(1)

CF251AM(1)

CF473X(1)

SN3054ENDK(1)

TK7107(1)

TK582Y(1)

TK582M(1)

TK582K(1)

TK7207(1)

TK8317C(1)

TK8317Y(1)

TK8317M(1)

TK8317K(1)

TK582C(1)

TK572Y(1)

12519(1)

48152(1)

44910(1)

SW3054ENDK(1)

A32W011(1)

TK-3132(1)

TK572M(1)

TK572K(1)

TK572C(1)

8961SCT(1)

8961XLCT(1)

106R03502(1)

106R03501(1)

106R03500(1)

RSMT91516CT(1)

106R03503(1)

106R03512(1)

106R03524(1)

106R03515(1)

106R03514(1)

106R03513(1)

RSMT12151(1)

RSCC10151(1)

682264(1)

682263(1)

682262(1)

682258(1)

682265(1)

682274(1)

687374EA(1)

686661(1)

682275(1)

106R03525(1)

106R03526(1)

106R03762(1)

106R03761(1)

106R03760(1)

106R03759(1)

106R03763(1)

106R03764(1)

3R05134(1)

3R04901(1)

3R04299(1)

3R02047PL(1)

106R03758(1)

106R03757(1)

106R03584(1)

106R03582(1)

106R03580(1)

106R03527(1)

106R03737(1)

106R03738(1)

106R03744(1)

106R03742(1)

106R03739(1)

682257(1)

682256(1)

96717(1)

30004(1)

35100-10(1)

97810(1)

96718(1)

96719(1)

MX62NTBA(1)

407656(1)

636100LAC(1)

96720(1)

97596(1)

96260(1)

8981XLCT(1)

8981SCT(1)

8981MCT(1)

8981LCT(1)

96254(1)

96255(1)

96259(1)

96257(1)

96256(1)

MX62NTCA(1)

MX62NTMA(1)

668012(1)

665016(1)

665015(1)

652995(1)

671301(1)

682251(1)

682255(1)

682253(1)

682252EA(1)

652989(1)

652514(1)

624489PK(1)

617717(1)

000116(1)

MX62NTYA(1)

642513(1)

644080(1)

652468(1)

649876(1)

644973(1)

90095(1)

90001(1)

TP905A27(1)

TP905A20(1)

TP200A38(1)

TP200A27(1)

TP905A38(1)

W1012707A(1)

YP20009(1)

W6099707(1)

W1041707(1)

W1018707A(1)

TP200A20(1)

SK24E00(1)

PM22818(1)

G70159(1)

G70030(1)

E7175018(1)

PM8BP28(1)

PM93707(1)

SK240018(1)

SK14E00(1)

SD38178(1)

YP20010(1)

YP20012(1)

100006(1)

100005(1)

100004(1)

100002(1)

100014(1)

100015(1)

100032(1)

100028(1)

100026(1)

100018(1)

100000(1)

YP90545(1)

YP90014(1)

YP80014(1)

YP60009(1)

YP20045(1)

YP90045(1)

YP90508(1)

YP90512(1)

YP90510(1)

YP90509(1)

E7125018(1)

D6099705(1)

1050905(1)

1050200(1)

1042905(1)

1042200(1)

1051200(1)

1053200(1)

1064200(1)

105490520(1)

105420020(1)

1053905(1)

1041905(1)

1041200(1)

1018905A(1)

1018201A(1)

1012905A(1)

1012900A(1)

1021905A(1)

1022200A42(1)

1026905A(1)

1026200A(1)

1022905A42(1)

1064905(1)

551200(1)

793201(1)

709500518(1)

708000518(1)

702600518(1)

D1012705A(1)

D1041704(1)

D6099704(1)

D1090704(1)

D1041706(1)

70250X42(1)

701200518(1)

609980520(1)

604690542(1)

604620042(1)

551905(1)

609980527(1)

609980627(1)

6099905S(1)

609990527(1)

609990520(1)

100079(1)

100082(1)

103626(1)

103625(1)

103624(1)

103623(1)

103627(1)

103628(1)

103632(1)

103631(1)

103630(1)

103629(1)

103622(1)

103621(1)

101655(1)

101630(1)

101618(1)

101617(1)

101708(1)

101715(1)

103619(1)

103618(1)

103617(1)

20068BX(1)

20069BX(1)

03563CT(1)

03562CT(1)

GPR54(1)

GPR43(1)

03565CT(1)

03573CT(1)

L15HS(1)

EVFL45S(1)

04229CT(1)

04206CT(1)

GPR42(1)

CPCM4276(1)

99943(1)

99942(1)

36693BX(1)

36692BX(1)

99944(1)

99945(1)

99948(1)

99947(1)

99946(1)

101613(1)

101606(1)

100260(1)

100173(1)

100165(1)

100161(1)

100275(1)

100287(1)

100330(1)

100329(1)

100325(1)

100315(1)

100157(1)

100151(1)

100107(1)

100089(1)

100087(1)

100085(1)

100116(1)

100119(1)

100149(1)

100131(1)

100121(1)

100337(1)

100339(1)

101563(1)

101553(1)

101552(1)

100657(1)

101570(1)

101574(1)

101602(1)

101591(1)

101582(1)

100656(1)

100655(1)

100346(1)

100345(1)

100344(1)

100343(1)

100347(1)

100351(1)

100654(1)

100353(1)

100352(1)

1012200A(1)

Binding Type

Wire Bound(45)

Twin Wire(26)

2-ring(2)

Headband(2)

Book Bound(1)

Closure

Zipper Lock(6)

Zipper Seal(1)

Material

Vinyl(8)

Metal(4)

Nitrile(4)

Plastic(2)

Polystyrene(2)

Simulated Leather(2)

Leather(2)

Medium Density Fiberboard (MDF)(1)

Steel(1)

Wood(1)

Fabric(1)

Polyethylene(1)

Paper(1)

Poly(1)

Cardboard(1)

Faux Leather(1)

Polypropylene Casing(1)

Material(s)

Plastic(7)

Cloth(3)

Paper(1)

Lamp Life

60 Hour(1)

400 Hour(1)

Width

7"(4)

10 9/16"(3)

4"(1)

22.91"(1)

21.69"(1)

23.2"(1)

9 3/5"(1)

4.7"(1)

6 1/2"(1)

15"(1)

17.09"(1)

8.78"(1)

28.5"(1)

12.5"(1)

9.4"(1)

12"(1)

14.3"(1)

11.57"(1)

13.31"(1)

13.58"(1)

11.97"(1)

12.20"(1)

7.4"(1)

Height

10 3/4"(3)

14.33"(1)

13.54"(1)

10.71"(1)

35.4"(1)

8 1/2"(1)

6"(1)

13"(1)

4.96"(1)

7 3/4"(1)

10.67"(1)

16.5"(1)

17.5"(1)

12.5"(1)

17.1"(1)

4.8"(1)

6.54"(1)

7.64"(1)

7.48"(1)

6.89"(1)

9.1"(1)

Depth

6.2"(1)

12"(1)

5.5"(1)

0.3"(1)

0.5"(1)

Color(s)

Clear(7)

White(4)

Sheet Size

Letter - 8.50" x 11"(7)

8.50" Width x 11" Length(3)

Shape

Square(1)

Square-to-Round(1)

Rectangle(1)

Length

10"(3)

5.9"(1)

Handle Type

Threaded(1)

Capacity (Volume)

32 oz(6)

9.7 oz(3)

13.8 oz(3)

1 gal(2)

5 gal(1)

25 oz(1)

2.5 qt(1)

0.375 oz(1)

15 oz(1)

16 oz(1)

1.5 Liter(1)

Packing Type

Aerosol(7)

Spray Bottle(4)

Bottle(4)

Trigger Spray Bottle(1)

Aerosol Can(1)

Dispenser(1)

Trigger Bottle(1)

Mini Cups(1)

Pump Dispenser(1)

Number of Pieces

419(1)

63(1)

Case Material

Metal(1)

Thickness

1.75 mil(5)

2.7 mil(1)

1.2 mil(1)

Time Period

1 Year(127)

1.1 Year(23)

Grade

Super Extra-Heavy(1)

Top Material

Thermofused Laminate (TFL)(2)

Particleboard(2)

Dispenser Type

Pump Bottle(3)

Yield Type

High(31)

Standard(13)

Extra High(6)

Scent

Unscented(8)

Lemon(3)

Pleasant(2)

Citrus(2)

Fresh Citrus(1)

Clean Citrus Scent(1)

Fresh Clean(1)

Rainshower(1)

Clean Fresh(1)

Hawaiian Breeze(1)

Super Fresh(1)

Ocean Breeze(1)

Clean Splash(1)

Crisp Clean(1)

Linen & Sky(1)

Meadows & Rain(1)

Hawaiian Aloha(1)

Gain Original(1)

Tropical Flowers(1)

Sunset Cotton(1)

Lavender(1)

Spring & Renewal(1)

Widescreen

Yes(8)

Battery Size

D(2)

Power Source

Battery(2)

Towel/Wipe Type

Wet Wipes(2)

Laundry Wipes(1)

Furniture Wipes(1)

Packaging

Carton(2)

Flat Pack(1)

Pack(1)

Number of Towels/Wipes Per Container

80(1)

25(1)

28(1)

24(1)

Orientation

Horizontal/Vertical(1)

Tab Style

Blank(4)

Sheet Width

8.50"(20)

8"(17)

5"(16)

9"(16)

11"(13)

12"(9)

8.75"(8)

17"(6)

22"(5)

7"(5)

5.75"(4)

15"(4)

10.88"(3)

4.88"(2)

24"(2)

10"(1)

5.88"(1)

7.25"(1)

5.50"(1)

4.75"(1)

5.25"(1)

6.88"(1)

8.25"(1)

22.20"(1)

7.38"(1)

17.88"(1)

3.50"(1)

Number of Holes Punched

3(4)

Placement

Wall Mountable(34)

Desk Pad(22)

Desk(20)

Surface(1)

Tabletop(1)

Desktop(1)

Capacity Range (Volume) [Max]

1 gal(3)

1 qt(2)

2 gal(1)

Maximum Load Capacity

35 lb(1)

26 lb(1)

Premeasured

No(1)

Country of Origin

China(139)

United States(81)

US(28)

CA(3)

Japan(3)

Taiwan(3)

TH(1)

Vietnam(1)

Brazil(1)

Price Range

$0-$499.99(455)

$500-$999.99(3)

$7000-$7499.99(1)

To  GO

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

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