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

Tootsie Roll(17)

Trident(12)

Reese's(11)

M & M's(8)

Spangler(8)

Ghirardelli(8)

Nestlé(8)

Colombina(8)

Werther's Original(7)

Jolly Rancher(5)

Kit Kat(5)

Mentos(5)

YumEarth(5)

Starburst(5)

LifeSavers(5)

National Brand(4)

MARS(4)

Dubble Bubble(4)

Jelly Belly(4)

York(4)

Lindt(4)

Altoids(4)

Charms(4)

Snickers(4)

Sour Patch Kids(4)

Hi-Chew(4)

Orbit(3)

Tic Tac(3)

UNREAL(3)

Red Vines(3)

Office Snax(3)

VerMints(3)

Dentyne Ice(3)

Twizzlers(2)

Barnana(2)

King Leo(2)

Sour Punch(2)

Andes(2)

Red Bird(2)

DeMet's(2)

Wrigley's(2)

Bazooka(2)

Swedish Fish(2)

Charleston Chews(2)

World Confections(2)

Skittles(2)

Haribo(2)

POP ROCKS(2)

Lik-m-aid Fun Dip(2)

Twix(2)

Ferrara(2)

Snack Box Pros(1)

Pearson's(1)

Albert's(1)

Junior Mints(1)

SKOR(1)

Nickelodeon(1)

PayDay(1)

Hospitality Mints(1)

Almond Joy(1)

Trolli(1)

Albanese World’s Best(1)

Riesen(1)

StarTech.com(1)

Big League Chew(1)

ROLO(1)

WHATCHAMACALLIT(1)

Sunkist(1)

JOJO's Chocolate(1)

LemonHead(1)

Black Forest(1)

Airheads(1)

BROOKSIDE(1)

Dove Chocolate(1)

Now and Later(1)

Bonomo(1)

Mounds(1)

Gilliam(1)

WARHEADS(1)

efrutti(1)

Lulú(1)

FERRERO ROCHER(1)

Good & Plenty(1)

100 GRAND(1)

Breitsamer Honig(1)

 
Packaged Quantity

1(1)

 
Weight (Approximate)

4.20 oz(1)

 
Flavor

Milk Chocolate(31)

Assorted(21)

Peppermint(18)

Original(9)

Chocolate(8)

Caramel(7)

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

Spearmint(5)

Wintergreen(5)

Strawberry(4)

Milk Chocolate with Almonds(4)

York(3)

Chocolate Mint(3)

Cherry; Lemon; Orange; Strawberry(3)

Snickers(3)

Black Licorice(2)

Wint-O-Green(2)

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

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

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

Blue Raspberry(2)

Milk Chocolate & Caramel(2)

Peanut(2)

Mint(2)

Cookies 'n' Creme(2)

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

Twix(2)

Milk Chocolate Sea Salt(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)

Special Dark Chocolate(2)

Fruity(2)

Milk Chocolate Caramel(2)

Watermelon(2)

Original Five Flavors(2)

Apple; Cherry; Pink Lemonade; Watermelon(2)

Milk Chocolate; Peanut(2)

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

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

Almond Joy(1)

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

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

Peppermint Cobalt(1)

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

Gingermint(1)

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

Intense Dark Midnight Reverie 86% Cacao(1)

Dark Chocolate & Sea Salt Caramel(1)

Pomegranate(1)

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

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

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

Blackberry; Cherry; Green Apple; Peach(1)

Dark Chocolate; Milk Chocolate; White Creme(1)

Outta' Here Original(1)

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

Peppermint/Chocolate(1)

Bubblemint(1)

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

Special Dark with Almonds(1)

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

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

18 Assorted Flavors(1)

Mint Bliss(1)

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

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

Freshmint(1)

Grape(1)

Chocolate and Caramel(1)

Milk Chocolate and Peanut Butter(1)

Randomly Assorted(1)

Assorted Flavors(1)

Mixed Fruit(1)

Arctic Chill(1)

Pep-O-Mint(1)

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

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

Hershey’s Special Dark Mildly Sweet Chocolate; Kit Kat Dark Wafer; Mounds; York Peppermint Patties(1)

Almond Joy; Mounds(1)

Spearmint Rush(1)

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

Peanut Caramel(1)

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

Blue Raspberry; Cherry; Green Apple; Strawberry; Watermelon(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)

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

Acapulco Lime; Himalayan Pink Salt(1)

Cherry; Fruit Punch; Strawberry; Watermelon(1)

Dark Chocolate Almond Butter(1)

Reese's(1)

Cherry Yum; Razz Apple(1)

Chocolate and Raisin(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)

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)

Honey and Oats(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)

Plantain Chips Salted(1)

Sweet & Sour(1)

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

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

WHATCHAMACALLIT(1)

STICKS(1)

Dark Chocolate & Coconut(1)

Milk Chocolate with Toffee and Almonds(1)

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

Licorice(1)

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

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

Caramel Peanut Nougat(1)

Dark Chocolate Coconut(1)

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

Dark Chocolate(1)

Original Pecan(1)

Peanut Butter(1)

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

Caramel Chocolate Nut(1)

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

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

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

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

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

Spearmint Rain(1)

 
Form Factor

Desktop(1)

Wall Mountable(1)

 
USB

Yes(1)

 
Ethernet Technology

Fast Ethernet(1)

 
Country of Origin

US(285)

CO(5)

CA(3)

ES(2)

NL(2)

BR(2)

SE(1)

MX(1)

CN(1)

DK(1)

DE(1)

 
Height

1.4"(1)

 
Width

2.2"(1)

 
Depth

1.9"(1)

 
Packing Type

Bag(2)

 
Capacity (Weight)

5 lb(16)

66.7 oz(13)

38.8 oz(8)

1.5 oz(7)

10.1 oz(4)

1 oz(4)

2 oz(4)

0.6 oz(4)

0.63 oz(4)

32 oz(3)

50 oz(3)

12.7 oz(3)

3 lb(3)

0.37 oz(3)

3.5 lb(3)

1.55 oz(3)

20.1 oz(3)

35.9 oz(3)

32.1 oz(3)

0.7 oz(3)

3.3 oz(3)

3.5 oz(3)

15.96 oz(2)

35 oz(2)

1.06 oz(2)

31.5 oz(2)

6.25 oz(2)

35.6 oz(2)

44.93 oz(2)

15.6 oz(2)

Assorted Full Size Bars(2)

56 oz(2)

26 oz(2)

3.53 oz(2)

0.53 oz(2)

13 oz(2)

30 oz(2)

2.75 oz(2)

0.35 oz(2)

19.5 oz(2)

38 oz(2)

3 oz(2)

1.4 oz(2)

1.85 lb(2)

0.33 oz(2)

48 oz(2)

0.04 oz(2)

60 oz(2)

34 oz(2)

0.85 oz(2)

1.32 oz(2)

0.4 oz(2)

14 oz(2)

1.2 oz(2)

46.5 oz(2)

12 oz(2)

0.43 oz(2)

5.1 oz(1)

3.02 oz(1)

33.9 oz(1)

71.96 oz(1)

14.86 oz(1)

15.77 oz(1)

5 lbs(1)

2 lb(1)

9.04 oz(1)

4.12 oz(1)

5.32 oz(1)

5 oz(1)

15 oz(1)

4.2 oz(1)

27 oz(1)

37.4 oz(1)

2.2 lb(1)

15.92 oz(1)

17 oz(1)

0.57 oz(1)

1.46 oz(1)

33.38 oz(1)

1.69 oz(1)

1.74 oz(1)

10.72 oz(1)

4.4 oz(1)

3.29 oz(1)

34.19 oz(1)

30 lb(1)

32.89 oz(1)

1.85 oz(1)

55.8 oz(1)

51 oz(1)

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

0.32 oz(1)

44.37 oz(1)

168.81 oz(1)

32.06 oz(1)

31 oz(1)

46 oz(1)

10.2 oz(1)

42 oz(1)

2.12 lb(1)

4.75 lb(1)

62.6 oz(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)

2.8 oz(1)

4.15 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.95 lb(1)

3.3 lb(1)

10.4 oz(1)

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

1.75 oz(1)

1.45 oz(1)

20 lb(1)

17.1 oz(1)

19.8 oz(1)

2.7 oz(1)

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

54 oz(1)

5 lb 3 oz(1)

6 lb, 8.4 oz(1)

0.55 oz(1)

2.24 lb(1)

84 oz(1)

 
Food Type

Candy Bars(99)

Candy(57)

Chewy Candy(38)

Gum(29)

Mints(18)

Lollipops(16)

Hard Candy(16)

Gummy Candy(11)

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