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 "Ballpoint Stick Pens") 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 ('BallpointStickPen' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+BallpointStickPen' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"BallpointStickPen"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"BallpointStickPen"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"BallpointStickPen"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"BallpointStickPen"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+BallpointStickPen' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='BallpointStickPen',`category_4` ='BallpointStickPen') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'BallpointStickPen,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('BallpointStickPen', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Ballpoint Stick Pens

Refine Search

  GO
Brand

Paper Mate(30)

BIC(28)

Pentel(13)

Business Source(7)

Uni-Ball(6)

Zebra Pen(4)

EasyTouch(4)

ecolutions(3)

Cross(2)

Better(2)

Sharpie(1)

Pentel Arts(1)

Recycled

No(93)

Yes(7)

Manufacturer Part Number

9660131(1)

9680131(1)

9630131(1)

9610131(1)

88080-87(1)

BK90-A(1)

BK90ASW2(1)

BK90USAA(1)

BK90LBP2A(1)

BK90-C(1)

BK90-B(1)

88079-87(1)

85586(1)

3930158(1)

4621401(1)

3920158(1)

3910158(1)

3381131(1)

4621501(1)

6110187(1)

85585(1)

70602(1)

70601(1)

6130187(1)

BK90USABP5A(1)

BK91-A(1)

33923(1)

40173(1)

33922(1)

33921(1)

1758054(1)

40174(1)

73840(1)

25520(1)

23620(1)

21820(1)

21810(1)

36011(1)

35011(1)

BK91CRBP8M(1)

BK91-C(1)

BK91-B(1)

BK91ASW-US(1)

BK91-D(1)

BK91MNBP8M(1)

32011(1)

32010(1)

32002(1)

32001(1)

3361131(1)

3331131(1)

GSMG11-RD(1)

GSMG361AST(1)

GSMG11-PE(1)

GSMG11-GN(1)

GSMG11-BK(1)

GSMG361BE(1)

GSMG361BK(1)

MSSP21BK(1)

MS11-RD(1)

MS11-BK(1)

MS11-BE(1)

GSMG11-BE(1)

GSME509BK(1)

GSFG11-BE(1)

GSFG11-BK(1)

GSF11-BK(1)

GSF11-BE(1)

CPGE11BK(1)

GSFG11-RD(1)

GSM11-BE(1)

GSM609BK(1)

GSM609BE(1)

GSM11-RD(1)

GSM11-BK(1)

SGSM11-BE(1)

SGSM11-BK(1)

1951257(1)

1951341(1)

1951256(1)

1951255(1)

AT0652S2(1)

1951342(1)

1951372(1)

3321131(1)

3311131(1)

1951374(1)

1951373(1)

AT0652S1(1)

37532(1)

VSG11-BK(1)

VSG11-BE(1)

VCGC11BK(1)

VCGC11BE(1)

37500(1)

37501(1)

37531(1)

37504(1)

37503(1)

37502(1)

CPGE11BE(1)

Refillable

No(40)

Yes(28)

Material

Tungsten Carbide(11)

Rubber(3)

Brass(2)

Stainless Steel - Tip(1)

Rubberized - Grip(1)

Plastic(1)

Nickel(1)

Barrel Material

Rubber(10)

Stainless Steel(6)

Plastic(5)

Polypropylene(1)

Nickel Silver(1)

Grip Type

Comfort(1)

Latex-free(1)

Soft(1)

Retractable

No(35)

Yes(10)

Point Size

1 mm(23)

0.7 mm(13)

1.2 mm(7)

1.4 mm(2)

0.8 mm(1)

Point Type

Medium(62)

Fine(24)

Bold(5)

Regular(2)

Tip Material

Stainless Steel(9)

Brass(4)

Metal(3)

Tungsten Carbide(2)

Nickel(2)

Country of Origin

Mexico(58)

China(17)

India(9)

Japan(8)

United States(6)

Korea(2)

Tunisia(1)

Price Range

$0-$9.99(70)

$10-$19.99(24)

$20-$29.99(5)

$30-$39.99(2)

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