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

Tootsie Roll(16)

Trident(12)

Reese's(11)

M & M's(9)

Nestlé(8)

Colombina(8)

Ghirardelli(8)

Spangler(8)

Werther's Original(7)

Lindt(6)

Jolly Rancher(6)

LifeSavers(5)

MARS(5)

Mentos(5)

Kit Kat(5)

Starburst(5)

Snickers(5)

YumEarth(5)

Charms(4)

Jelly Belly(4)

Hi-Chew(4)

Sour Patch Kids(4)

Altoids(4)

National Brand(4)

Dubble Bubble(4)

Orbit(3)

Red Vines(3)

York(3)

UNREAL(3)

Tic Tac(3)

Skittles(3)

Ferrara(3)

Office Snax(3)

VerMints(3)

Dentyne Ice(3)

Twizzlers(2)

Nickelodeon(2)

Barnana(2)

King Leo(2)

Sour Punch(2)

Andes(2)

DeMet's(2)

Red Bird(2)

Wrigley's(2)

POP ROCKS(2)

Haribo(2)

World Confections(2)

Twix(2)

Bazooka(2)

Charleston Chews(2)

Lik-m-aid Fun Dip(2)

Almond Joy(1)

ROLO(1)

100 GRAND(1)

Junior Mints(1)

Hospitality Mints(1)

Trolli(1)

Snack Box Pros(1)

PayDay(1)

Albanese World’s Best(1)

Dentyne Pure(1)

Riesen(1)

StarTech.com(1)

Swedish Fish(1)

Big League Chew(1)

WHATCHAMACALLIT(1)

Breitsamer Honig(1)

Mounds(1)

Airheads(1)

SKOR(1)

Albert's(1)

Gilliam(1)

Pearson's(1)

Dove Chocolate(1)

Sunkist(1)

Black Forest(1)

BROOKSIDE(1)

Good & Plenty(1)

LemonHead(1)

JOJO's Chocolate(1)

Now and Later(1)

Bonomo(1)

WARHEADS(1)

efrutti(1)

Lulú(1)

FERRERO ROCHER(1)

 
Packaged Quantity

1(1)

 
Weight (Approximate)

4.20 oz(1)

 
Flavor

Milk Chocolate(32)

Assorted(21)

Peppermint(18)

Chocolate(8)

Original(8)

Caramel(7)

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

Wintergreen(5)

Spearmint(5)

Snickers(4)

Strawberry(4)

Cherry; Lemon; Orange; Strawberry(3)

Chocolate Mint(3)

Milk Chocolate with Almonds(2)

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

Milk Chocolate Sea Salt(2)

Twix(2)

Cookies 'n' Creme(2)

Mint(2)

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

Black Licorice(2)

Wint-O-Green(2)

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

Milk Chocolate & Caramel(2)

Special Dark Chocolate(2)

Dark Chocolate(2)

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

Fruity(2)

York(2)

Milk Chocolate Caramel(2)

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

Peanut(2)

Original Five Flavors(2)

Watermelon(2)

Apple; Cherry; Pink Lemonade; Watermelon(2)

Blue Raspberry(2)

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

Milk Chocolate; Peanut(2)

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

Peppermint/Chocolate(1)

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

Almond Joy(1)

Intense Dark Midnight Reverie 86% Cacao(1)

Dark Chocolate & Sea Salt Caramel(1)

Pomegranate(1)

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

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

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

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

Blackberry; Cherry; Green Apple; Peach(1)

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

Special Dark with Almonds(1)

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

18 Assorted Flavors(1)

Peppermint Cobalt(1)

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

Dark Chocolate; Milk Chocolate; White Creme(1)

Grape(1)

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

Bubblemint(1)

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

Gingermint(1)

Outta' Here Original(1)

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

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

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

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

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

Arctic Chill(1)

Dark Chocolate; Milk Chocolate; White Crème(1)

Mixed Fruit(1)

M&M'S Milk Chocolate; Peanut; Peanut Butter(1)

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

Assorted Flavors(1)

Almond Joy; Mounds(1)

Randomly Assorted(1)

Milk Chocolate and Peanut Butter(1)

Chocolate and Caramel(1)

Peanut Caramel(1)

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

Original Assortment(1)

Lifesaver's Hard Candy; Skittles Original; Skittles Wild Berry(1)

Pep-O-Mint(1)

Tropical(1)

Himalayan Pink Sea Salt(1)

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

Cherry; Razzapple(1)

Carmel Apple(1)

Chalky Sugar(1)

Peanut Butter/Chocolate(1)

Fresh Mint; Spearmint(1)

Freshmint(1)

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

Acapulco Lime; Himalayan Pink Salt(1)

Spearmint Rush(1)

Mint Bliss(1)

Cherry; Fruit Punch; Strawberry; Watermelon(1)

Dark Chocolate Almond Butter(1)

Reese's(1)

Bubble Gum(1)

Cherry Yum; Razz Apple(1)

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

Vanilla(1)

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

Sour Lemon(1)

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

Cinnamon(1)

Original Chunky Bar(1)

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

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

Milk Chocolate Peanut Butter Cups(1)

Snickers Almond(1)

White Peppermint(1)

Perfect Peppermint(1)

Milk Chocolate Crunch Bar(1)

100 GRAND(1)

Plantain Chips Salted(1)

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

Fruit(1)

Mint with Herbal Accents(1)

White Spearmint(1)

Tropical Twist(1)

Mixed Berry(1)

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

Cherry/Lemon; Orange/Lime; Strawberry/Grape(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)

Caramel Apple(1)

Caramel/Chocolate(1)

Green Apple(1)

Fruit Punch(1)

Dark Chocolate Mint(1)

Banana; Cherry; Sour Apple; Strawberry(1)

Chocolate and Raisin(1)

Honey and Oats(1)

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

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

Cherry-Lemon; Cherry-Strawberry; Strawberry-Orange(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)

Caramel Peanut Nougat(1)

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

Acai Blueberry; Pomegranate(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)

STICKS(1)

WHATCHAMACALLIT(1)

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

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

Sweet & Sour(1)

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

Caramel Chocolate Nut(1)

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

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

Mason Dots; Tootsie Roll Pops; Tootsie Roll(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; MilkyWay; Snickers; Snickers Almond; Twix(1)

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

Assorted Fruit Flavors(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)

Spearmint Rain(1)

 
Form Factor

Desktop(1)

Wall Mountable(1)

 
USB

Yes(1)

 
Ethernet Technology

Fast Ethernet(1)

 
Country of Origin

US(290)

CO(5)

CA(3)

ES(2)

NL(2)

BR(2)

MX(1)

CN(1)

DK(1)

DE(1)

 
Height

1.4"(1)

 
Width

2.2"(1)

 
Depth

1.9"(1)

 
Packing Type

Bag(3)

Individually Wrapped(1)

 
Capacity (Weight)

5 lb(17)

66.7 oz(13)

38.8 oz(8)

1.5 oz(7)

0.63 oz(6)

1 oz(4)

2 oz(4)

0.6 oz(4)

3.5 lb(3)

3 lb(3)

0.37 oz(3)

20.1 oz(3)

1.55 oz(3)

50 oz(3)

3.5 oz(3)

3.3 oz(3)

35.9 oz(3)

32.1 oz(3)

10.1 oz(3)

12.7 oz(3)

0.7 oz(3)

30 oz(2)

Assorted Full Size Bars(2)

3 oz(2)

40 oz(2)

1.06 oz(2)

35 oz(2)

2.75 oz(2)

6.25 oz(2)

44.93 oz(2)

56 oz(2)

38 oz(2)

54 oz(2)

13 oz(2)

3.53 oz(2)

31.5 oz(2)

19.5 oz(2)

15.96 oz(2)

35.6 oz(2)

32 oz(2)

15.6 oz(2)

0.53 oz(2)

25.4 oz(2)

0.35 oz(2)

34 oz(2)

60 oz(2)

0.4 oz(2)

0.43 oz(2)

1.4 oz(2)

48 oz(2)

0.33 oz(2)

1.85 lb(2)

1.32 oz(2)

0.04 oz(2)

2.5 oz(2)

0.85 oz(2)

12 oz(2)

1.2 oz(2)

46.5 oz(2)

5 oz(1)

5.32 oz(1)

20.4 oz(1)

33.9 oz(1)

71.96 oz(1)

1.46 oz(1)

15 oz(1)

4.12 oz(1)

5 lbs(1)

5.1 oz(1)

14.86 oz(1)

3.02 oz(1)

17 oz(1)

9.04 oz(1)

15.77 oz(1)

27 oz(1)

0.57 oz(1)

0.32 oz(1)

168.81 oz(1)

1.85 oz(1)

2 lb(1)

32.06 oz(1)

1.69 oz(1)

10.72 oz(1)

1.74 oz(1)

45.85 oz(1)

4.4 oz(1)

4.2 oz(1)

3.29 oz(1)

31 oz(1)

14 oz(1)

34.19 oz(1)

55.8 oz(1)

44.37 oz(1)

33.38 oz(1)

30 lb(1)

26 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)

1.48 oz(1)

0.16 oz(1)

0.2 oz(1)

0.18 oz(1)

0.25 oz(1)

51 oz(1)

19.41 oz(1)

46 oz(1)

1.75 oz(1)

37.4 oz(1)

42 oz(1)

4.95 lb(1)

2.12 lb(1)

4.75 lb(1)

62.6 oz(1)

0.5 oz(1)

2.59 lb(1)

0.42 oz(1)

0.28 oz(1)

28 oz(1)

1.76 oz(1)

3.47 lb(1)

1.86 oz(1)

2.8 oz(1)

3.3 lb(1)

1.5 lb(1)

1.44 oz(1)

10.83 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)

4.15 lb(1)

0.8 oz(1)

2.2 lb(1)

17.1 oz(1)

15.92 oz(1)

10.2 oz(1)

10.4 oz(1)

17.6 oz(1)

32.55 oz(1)

35.2 oz(1)

32.34 oz(1)

31.6 oz(1)

4.25 oz(1)

33 oz(1)

1.6 oz(1)

20 lb(1)

19.8 oz(1)

2.24 lb(1)

21.2 oz(1)

2.7 oz(1)

0.92 oz(1)

0.67 oz(1)

69.4 oz(1)

10 oz(1)

1 lb, 1.5 oz(1)

55 oz(1)

15.01 oz(1)

1 lb, 5 oz(1)

5 lb 3 oz(1)

6 lb, 8.4 oz(1)

0.55 oz(1)

84 oz(1)

 
Food Type

Candy Bars(98)

Candy(61)

Chewy Candy(36)

Gum(30)

Mints(18)

Hard Candy(17)

Lollipops(16)

Gummy Candy(12)

Jelly Beans(4)

Licorice(3)

Chips(3)

Sour Candy(2)

Candy; Chocolate(2)

Honey(1)

Taffy(1)

Fruit Drops(1)

Chocolate; Candy(1)

Chocolate(1)

Snack Variety Packs(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved