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_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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` 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 WHERE (`category_id` IN ('10053')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 `pinfo`.`sku` LIKE '%PensandPencils' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('PensandPencils' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+PensandPencils' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"PensandPencils"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"PensandPencils"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"PensandPencils"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"PensandPencils"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+PensandPencils' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='PensandPencils',`category_4` ='PensandPencils') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'PensandPencils,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('PensandPencils', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Pens And Pencils

Refine Search

  GO
 
Brand

Hershey's(49)

Tootsie Roll(17)

Trident(11)

M & M's(10)

Reese's(10)

Werther's Original(8)

Ghirardelli(8)

Spangler(8)

Colombina(8)

Nestlé(8)

Jolly Rancher(6)

Lindt(6)

MARS(6)

National Brand(6)

YumEarth(5)

Mentos(5)

Starburst(5)

LifeSavers(5)

Altoids(4)

UNREAL(4)

Hi-Chew(4)

Snickers(4)

Kit Kat(4)

Jelly Belly(4)

York(4)

Sour Patch Kids(4)

Dubble Bubble(4)

Orbit(4)

Charms(4)

Red Vines(3)

VerMints(3)

Dove Chocolate(3)

Wrigley's(3)

Tic Tac(3)

Dentyne Ice(3)

Office Snax(3)

King Leo(2)

DeMet's(2)

Andes(2)

Sour Punch(2)

Nickelodeon(2)

Twizzlers(2)

Red Bird(2)

Twix(2)

Ferrara(2)

Skittles(2)

Swedish Fish(2)

Charleston Chews(2)

World Confections(2)

Barnana(2)

efrutti(2)

Lik-m-aid Fun Dip(2)

Haribo(2)

POP ROCKS(2)

Bazooka(2)

Riesen(1)

Almond Joy(1)

WHATCHAMACALLIT(1)

Hospitality Mints(1)

Mounds(1)

StarTech.com(1)

Snack Box Pros(1)

Good & Plenty(1)

ROLO(1)

Lulú(1)

FERRERO ROCHER(1)

Pearson's(1)

Albanese World’s Best(1)

Trolli(1)

Junior Mints(1)

100 GRAND(1)

Bonomo(1)

Now and Later(1)

LemonHead(1)

Albert's(1)

WARHEADS(1)

SKOR(1)

Breitsamer Honig(1)

Gilliam(1)

Sunkist(1)

Black Forest(1)

Airheads(1)

BROOKSIDE(1)

JOJO's Chocolate(1)

Big League Chew(1)

 
Packaged Quantity

1(1)

 
Weight (Approximate)

4.20 oz(1)

 
Flavor

Milk Chocolate(31)

Assorted(21)

Peppermint(18)

Original(9)

Caramel(8)

Chocolate(8)

Krackle; Milk Chocolate; Mr. Goodbar; Special Dark(6)

Wintergreen(5)

Strawberry(4)

Spearmint(4)

Milk Chocolate with Almonds(4)

York(3)

Chocolate Mint(3)

Cherry; Lemon; Orange; Strawberry(3)

Snickers(3)

Black Licorice(2)

Mint(2)

Blue Raspberry; Cherry; Green Apple; Grape; Watermelon(2)

Dark Chocolate; Milk Chocolate; Milk Chocolate & Caramel(2)

Milk Chocolate Sea Salt(2)

Twix(2)

Cherry; Grape; Green Apple; Strawberry; Watermelon(2)

Cookies 'n' Creme(2)

Dark Chocolate(2)

Wint-O-Green(2)

Peanut(2)

Special Dark Chocolate(2)

Blue Raspberry(2)

Blue Raspberry; Cherry; Green Apple; Strawberry(2)

Mason Dots; Tootsie Roll Pops; Tootsie Roll(2)

Milk Chocolate & Caramel(2)

Special Dark; Special Dark Crisp Rice; Special Dark Peanut(2)

Milk Chocolate; Milk Chocolate with Almonds; Milk Chocolate with Toffee and Almonds; Special Dark with Almonds(2)

Bubble Gum; Grape; Sour Apple; Watermelon(2)

Watermelon(2)

Milk Chocolate Caramel(2)

Fruity(2)

Original Five Flavors(2)

Milk Chocolate; Peanut(2)

Apple; Cherry; Pink Lemonade; Watermelon(2)

M&M's; M&M's Peanut; Snickers; Twix(2)

Blood Orange Cocktail; Cheeky Lemon; Lucky Lime, Tickled Pink Grapefruit(1)

Mango Tango; Perfect Peach; Pomegranate Pucker; WetFace Watermelon(1)

Bubblemint(1)

Pomegranate(1)

Blackberry; Cherry; Green Apple; Peach(1)

Dark Chocolate & Sea Salt Caramel(1)

Intense Dark Midnight Reverie 86% Cacao(1)

Blue Raspberry; Cherry; Green Apple; Strawberry; Watermelon(1)

Peppermint Cobalt(1)

Perfectly Peach; Pomegranate Pucker; Strawberry Smash; Very Very Cherry(1)

Peppermint; Spearmint; Wintermint(1)

Almond Joy; Hershey's Milk Chocolate; Kit Kat Wafer; Reese's Peanut Butter Cups(1)

Peppermint/Chocolate(1)

Special Dark with Almonds(1)

Krackle; Milk Chocolate; Milk Chocolate KISSES; Mr. Goodbar; Reese's Mini Cups; Special Dark(1)

Almond Joy(1)

Hershey's Milk Chocolate; Kit Kat; Reese's Peanut Butter Cups(1)

Hershey's Cookies 'n' Creme; Kit Kat White Wafer; Reese's White Peanut Butter Cups(1)

Dark Chocolate; Milk Chocolate; White Creme(1)

60% Cacao; Dark & Mint; Dark & Raspberry; Milk & Caramel(1)

Hershey's Milk Chocolate; Hershey's Special Dark; Krackle; Mr. Goodbar(1)

Milk Chocolate KISSES; Milk Chocolate/White Creme HUGS(1)

Outta' Here Original(1)

Cherry; Fruit Punch; Strawberry; Watermelon(1)

Grape(1)

Dark Chocolate 60% Cacao; Dark Chocolate 72% Cacao; Dark Chocolate Sea Salt and Almonds; Dark Chocolate Sea Salt Caramel(1)

Hershey's Milk Chocolate; Kit Kat; Reese's Peanut Butter Cups; Reese's Pieces(1)

18 Assorted Flavors(1)

Cherry; Chocolate; Grape; Orange; Raspberry(1)

Milk Chocolate; Milk Chocolate with Almonds; Cookies 'n' Creme(1)

Freshmint(1)

Variety(1)

Chocolate and Caramel(1)

Randomly Assorted(1)

Assorted Flavors(1)

Milk Chocolate; Peanut; Peanut Butter(1)

Caramel; Milk Chocolate; Peanut; Peanut Butter(1)

Mixed Fruit(1)

Arctic Chill(1)

Pep-O-Mint(1)

Kit Kat; Reese's Peanut Butter Cups(1)

Café Express; Chai; Cinnamon; Gingermint; Peppermint; Wintergreen(1)

60% Extra Dark; Caramel; Dark; Milk; White(1)

Tropical(1)

Himalayan Pink Sea Salt(1)

Milk Chocolate; Milk Chocolate with Almonds; Special Dark(1)

Hershey's All-Time Greats Assortment; MARS Mini Favorites; Nestlé Assorted Mini Chocolates(1)

3 Musketeers; Kit Kat; MilkyWay; Reese's Peanut Butter Cups; Snickers; Twix(1)

Cherry; Razzapple(1)

Carmel Apple(1)

Chalky Sugar(1)

Peanut Butter/Chocolate(1)

Fresh Mint; Spearmint(1)

Acapulco Lime; Himalayan Pink Salt(1)

Spearmint Rush(1)

Mint Bliss(1)

Gingermint(1)

Reese's(1)

Caramel Peanut Nougat(1)

WHATCHAMACALLIT(1)

Cherry Yum; Razz Apple(1)

Perfect Peppermint(1)

White Peppermint(1)

Snickers Almond(1)

Milk Chocolate Peanut Butter Cups(1)

Blueberry; Cherry; Grape; Green Apple; Peach(1)

Wild Apple-Berry; Wild Blackberry; Wild Blueberry; Wild Cherry-Berry; Wild Mango-Berry(1)

Cinnamon(1)

3 Musketeers; MilkyWay; Snickers; Twix(1)

Bubble Gum(1)

Apple; Grape; Orange; Pineapple; Strawberry(1)

Sour Lemon(1)

Apple; Banana; Cherry; Grape; Strawberry(1)

Vanilla(1)

Lemon; Orange; Pineapple; Raspberry; Strawberry(1)

Milk Chocolate Crunch Bar(1)

Plantain Chips Salted(1)

Caramel Apple(1)

Fruit(1)

White Spearmint(1)

Tropical Twist(1)

Blue Raspberry; Cherry; Granny Smith Apple; Grape; Grapefruit; Lemon; Lime; Mango; Orange; Pineapple; Strawberry; Watermelon(1)

Cherry; Grape; Pineapple; Orange; Strawberry(1)

Cherry/Lemon; Orange/Lime; Strawberry/Grape(1)

Caramel/Chocolate(1)

Original Chunky Bar(1)

Green Apple(1)

Fruit Punch(1)

Dark Chocolate Mint(1)

Banana; Cherry; Sour Apple; Strawberry(1)

Blue Razz Berry 'N Sour Watermelon; Sweet Cherry N' Sour Green Apple; Sweet Mango "N Sour Tangerine; Sweet Pineapple 'N Sour Grapefruit; Sweet Strawberry 'N Sour Lemonade(1)

100 GRAND(1)

Chocolate and Raisin(1)

Honey and Oats(1)

STICKS(1)

Apple; Black Cherry; Blue Raspberry; Lemon; Watermelon(1)

Peanut Butter(1)

Original Pecan(1)

Jolly Rancher Chews Candy; Jolly Rancher Misfits Gummies; Twizzlers Rainbow Twists Chewy Candy; Twizzlers Twists Strawberry-Flavored Chewy Candy(1)

Dark Chocolate Coconut(1)

Dark Chocolate Almond Butter(1)

Chocolate Peanut(1)

Sour(1)

Evening Dream 60% Cacao; Sea Salt & Almonds; Twilight Delight 72% Cacao(1)

Life Savers; Skittles; Starburst Fave Reds; Starburst Original(1)

Juicy Passion Fruit; Sweet Cherry; Tangy Orange; Tart Apple(1)

Licorice(1)

Hershey's Milk Chocolate; Hershey's Milk Chocolate with Almonds; Kit Kat; Reese's Peanut Butter Cups(1)

Milk Chocolate with Toffee and Almonds(1)

Dark Chocolate & Coconut(1)

Cherry-Lemon; Cherry-Strawberry; Strawberry-Orange(1)

Acai Blueberry; Pomegranate(1)

Sweet & Sour(1)

3 Musketeers; MilkyWay; Snickers; Snickers Almond; Twix(1)

Caramel Chocolate Nut(1)

Berry Blast; Blue Raspberry; Blue Raspberry Watermelon; Cherry, Strawberry; Watermelon(1)

3 Musketeers; MilkyWay; MilkyWay Midnight,; Snickers; Twix(1)

Blueberry; Lemon; Orange; Pink Grapefruit; Raspberry(1)

Blue Raspberry; Blueberry; Bubble Gum; Butterscotch; Cherry; Cotton Candy; Cream Soda; Grape; Mango; Root Beer; Sour Apple; Strawberry; Tangerine; Watermelon(1)

3 Musketeers; M&M's; M&M's Peanut; Skittles; Snickers; Starburst(1)

Assorted Fruit Flavors(1)

Island Berry Lime; Tropical Twist; Watermelon Twist(1)

Apple; Cherry; Lemon; Orange; Pineapple(1)

Peppermint; Spearmint; Sweet Mint; Wintermint(1)

Baby Ruth; Butterfinger; Crunch Bar; Milk Chocolate Bars(1)

Blue Raspberry; Cherry; Grape; Orange; Watermelon; White Mystery(1)

Skittles Mixed Berry; Skittles Original; Starburst FAVE Reds; Starburst Original(1)

Blue Raspberry; Blueberry; Bubble Gum; Butterscotch; Cherry; Cotton Candy; Cream Soda; Grape; Mango; Mystery; Root Beer; Sour Apple; Strawberry; Tangerine; Watermelon(1)

Spearmint Rain(1)

 
Form Factor

Desktop(1)

Wall Mountable(1)

 
USB

Yes(1)

 
Ethernet Technology

Fast Ethernet(1)

 
Country of Origin

US(292)

CO(5)

CA(3)

ES(2)

CN(2)

NL(2)

BR(2)

DE(2)

SE(1)

MX(1)

DK(1)

 
Height

1.4"(1)

 
Width

2.2"(1)

 
Depth

1.9"(1)

 
Packing Type

Bag(3)

Tub(1)

 
Capacity (Weight)

5 lb(16)

66.7 oz(12)

38.8 oz(8)

1.5 oz(7)

0.63 oz(5)

10.1 oz(4)

0.6 oz(4)

2 oz(4)

1 oz(4)

1.55 oz(3)

3 lb(3)

60 oz(3)

12.7 oz(3)

32 oz(3)

3.3 oz(3)

3 oz(3)

0.37 oz(3)

3.5 lb(3)

35.9 oz(3)

3.5 oz(3)

30 oz(3)

0.7 oz(3)

50 oz(3)

19.5 oz(2)

2.7 oz(2)

38 oz(2)

0.53 oz(2)

3.53 oz(2)

5 oz(2)

1.06 oz(2)

25.4 oz(2)

44.93 oz(2)

6.25 oz(2)

33.9 oz(2)

35 oz(2)

15.96 oz(2)

56 oz(2)

Assorted Full Size Bars(2)

26 oz(2)

20.1 oz(2)

32.1 oz(2)

0.35 oz(2)

2.75 oz(2)

0.43 oz(2)

12 oz(2)

46.5 oz(2)

14 oz(2)

0.85 oz(2)

34 oz(2)

31.5 oz(2)

0.04 oz(2)

35.6 oz(2)

1.2 oz(2)

1.4 oz(2)

15.6 oz(2)

0.4 oz(2)

0.33 oz(2)

48 oz(2)

1.32 oz(2)

1.85 lb(2)

13 oz(2)

2.2 lb(1)

15 oz(1)

37.4 oz(1)

5.1 oz(1)

14.86 oz(1)

15.92 oz(1)

15.77 oz(1)

5.32 oz(1)

17.6 oz(1)

10.4 oz(1)

9.04 oz(1)

4.12 oz(1)

10.2 oz(1)

4.2 oz(1)

46 oz(1)

1.46 oz(1)

30.35 oz(1)

27 oz(1)

17 oz(1)

3.02 oz(1)

5 lbs(1)

71.96 oz(1)

20.4 oz(1)

51 oz(1)

30 lb(1)

3.29 oz(1)

4.4 oz(1)

10.72 oz(1)

2 lb(1)

32.9 oz(1)

1.69 oz(1)

0.57 oz(1)

1.74 oz(1)

33.38 oz(1)

25 Assorted Snacks(1)

38.9 oz Hershey All-Time Greats Assortment; 62.6 oz Mars Mini Favorites; 40 oz Nestle Assorted Mini Chocolates(1)

69.3 oz(1)

1.48 oz(1)

0.16 oz(1)

0.2 oz(1)

0.18 oz(1)

0.25 oz(1)

0.32 oz(1)

44.37 oz(1)

168.81 oz(1)

55.8 oz(1)

21.2 oz(1)

32.55 oz(1)

1.5 lb(1)

0.5 oz(1)

2.59 lb(1)

40 oz(1)

0.42 oz(1)

0.28 oz(1)

2.5 oz(1)

28 oz(1)

1.76 oz(1)

3.47 lb(1)

1.86 oz(1)

42 oz(1)

2.8 oz(1)

1.44 oz(1)

4.75 lb(1)

10.83 oz(1)

43.07 oz(1)

67.2 oz(1)

47.6 oz(1)

40.5 oz(1)

2.17 oz(1)

3.08 lb(1)

6.75 lb(1)

1.3 oz(1)

1.83 lb(1)

1.08 oz(1)

62 oz(1)

0.64 oz(1)

62.6 oz(1)

2.12 lb(1)

35.2 oz(1)

69.4 oz(1)

32.34 oz(1)

31.6 oz(1)

4.25 oz(1)

33 oz(1)

1.6 oz(1)

1.75 oz(1)

1.45 oz(1)

17.1 oz(1)

19.8 oz(1)

20 lb(1)

44.07 oz(1)

0.92 oz(1)

0.67 oz(1)

10 oz(1)

4.95 lb(1)

1 lb, 1.5 oz(1)

55 oz(1)

31 oz(1)

15.01 oz(1)

1 lb, 5 oz(1)

54 oz(1)

5 lb 3 oz(1)

6 lb, 8.4 oz(1)

0.55 oz(1)

2.24 lb(1)

0.8 oz(1)

3.3 lb(1)

4.15 lb(1)

84 oz(1)

 
Food Type

Candy Bars(101)

Candy(62)

Chewy Candy(39)

Gum(29)

Hard Candy(18)

Mints(18)

Lollipops(16)

Gummy Candy(11)

Jelly Beans(4)

Licorice(3)

Chips(3)

Sour Candy(2)

Honey(1)

Taffy(1)

Fruit Drops(1)

Chocolate; Candy(1)

Chocolate(1)

Snack Variety Packs(1)

Candy; Chocolate(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved