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

Tootsie Roll(16)

M & M's(12)

Reese's(11)

Trident(11)

Nestlé(10)

UNREAL(8)

Spangler(8)

Ghirardelli(7)

Werther's Original(6)

Colombina(6)

Starburst(5)

YumEarth(5)

Kit Kat(5)

LifeSavers(5)

Lindt(5)

Mentos(5)

Jolly Rancher(5)

National Brand(5)

Jelly Belly(4)

Hi-Chew(4)

Snickers(4)

Charms(4)

Sour Patch Kids(4)

York(4)

MARS(4)

Altoids(4)

efrutti(3)

Orbit(3)

Dubble Bubble(3)

Tic Tac(3)

Dove Chocolate(3)

Skittles(3)

Dentyne Ice(3)

VerMints(3)

Wrigley's(3)

Office Snax(3)

Twix(2)

Swedish Fish(2)

Twizzlers(2)

Red Vines(2)

DeMet's(2)

Barnana(2)

POP ROCKS(2)

Bazooka(2)

Red Bird(2)

Hospitality Mints(1)

WHATCHAMACALLIT(1)

Snack Box Pros(1)

Almond Joy(1)

Mounds(1)

Good & Plenty(1)

FERRERO ROCHER(1)

ROLO(1)

Riesen(1)

StarTech.com(1)

WARHEADS(1)

Nickelodeon(1)

Lulú(1)

JOJO's Chocolate(1)

LemonHead(1)

Albanese World’s Best(1)

Trolli(1)

Charleston Chews(1)

Junior Mints(1)

World Confections(1)

100 GRAND(1)

Lik-m-aid Fun Dip(1)

Haribo(1)

Bonomo(1)

Now and Later(1)

Pearson's(1)

BROOKSIDE(1)

Albert's(1)

SKOR(1)

Ferrara(1)

Breitsamer Honig(1)

Andes(1)

Sour Punch(1)

King Leo(1)

Gilliam(1)

Sunkist(1)

Black Forest(1)

Airheads(1)

Big League Chew(1)

 
Packaged Quantity

1(1)

 
Weight (Approximate)

4.20 oz(1)

 
Flavor

Milk Chocolate(30)

Assorted(21)

Peppermint(14)

Original(10)

Chocolate(8)

Caramel(6)

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

Wintergreen(5)

Spearmint(4)

Milk Chocolate with Almonds(4)

Strawberry(4)

Cherry; Lemon; Orange; Strawberry(3)

Peanut Butter(3)

York(3)

Snickers(3)

Tropical(2)

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

Milk Chocolate; Peanut; Peanut Butter(2)

Milk Chocolate Sea Salt(2)

Mint(2)

Twix(2)

Milk Chocolate Peanut Butter Cups(2)

Chocolate Mint(2)

Cookies 'n' Creme(2)

Dark Chocolate(2)

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

Milk Chocolate & Caramel(2)

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

Special Dark Chocolate(2)

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

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

Peanut(2)

Wint-O-Green(2)

Blue Raspberry(2)

Watermelon(2)

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

Milk Chocolate; Peanut(2)

Original Five Flavors(2)

Grape(1)

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

Dark Chocolate; Milk Chocolate; White Creme(1)

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

Milk Chocolate Caramel(1)

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

Milk Chocolate with White Creme(1)

Special Dark with Almonds(1)

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

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

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

Gingermint(1)

Semi-Sweet Chocolate(1)

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

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

Outta' Here Original(1)

Almond Joy(1)

Cherry; Fruit Punch; Strawberry; Watermelon(1)

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

Reese's(1)

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

Bubblemint(1)

WHATCHAMACALLIT(1)

STICKS(1)

White Creme(1)

Dark Chocolate & Coconut(1)

Peppermint Cobalt(1)

Peppermint/Chocolate(1)

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

Blackberry; Cherry; Green Apple; Peach(1)

Freshmint(1)

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

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

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

Arctic Chill(1)

Mixed Fruit(1)

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

Assorted Flavors(1)

Randomly Assorted(1)

Milk Chocolate and Peanut Butter(1)

Chocolate and Caramel(1)

Himalayan Pink Sea Salt(1)

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

Variety(1)

Fresh Mint; Spearmint(1)

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

Acapulco Lime; Himalayan Pink Salt(1)

Spearmint Rush(1)

Mint Bliss(1)

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

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

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

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

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

Pep-O-Mint(1)

Milk Chocolate with Toffee and Almonds(1)

Dark Chocolate Peanut Butter(1)

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

3 Musketeers; MilkyWay; Snickers; Twix(1)

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

Vanilla(1)

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

Sour Lemon(1)

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

Bubble Gum(1)

Cinnamon(1)

Milk Chocolate Crunch Bar(1)

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

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

Snickers Almond(1)

White Peppermint(1)

Perfect Peppermint(1)

Chocolate and Raisin(1)

Cherry Yum; Razz Apple(1)

Original Chunky Bar(1)

Honey and Oats(1)

Apple; Cherry; Pink Lemonade; Watermelon(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 Apple(1)

100 GRAND(1)

Caramel/Chocolate(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)

Plantain Chips Salted(1)

Sweet & Sour(1)

Licorice(1)

Caramel Peanut Nougat(1)

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

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

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

Fruity(1)

Berry(1)

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

Sour(1)

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

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

Acai Blueberry; Pomegranate(1)

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

Black Licorice(1)

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

Caramel Chocolate Nut(1)

Blue Raspberry; Cherry; Green Apple; Strawberry(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; MilkyWay; Snickers; Snickers Almond; Twix(1)

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

Bubble Gum; Grape; Sour Apple; 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)

Spearmint Rain(1)

 
Form Factor

Desktop(1)

Wall Mountable(1)

 
USB

Yes(1)

 
Ethernet Technology

Fast Ethernet(1)

 
Country of Origin

US(286)

CA(3)

CO(3)

CN(3)

ES(2)

NL(2)

BR(2)

DE(2)

SE(1)

MX(1)

 
Height

1.4"(1)

 
Width

2.2"(1)

 
Depth

1.9"(1)

 
Packing Type

Bag(3)

Tub(1)

 
Capacity (Weight)

5 lb(14)

66.7 oz(12)

1.5 oz(9)

38.8 oz(8)

10.1 oz(4)

1 oz(4)

2 oz(4)

35.9 oz(3)

12.7 oz(3)

2.7 oz(3)

60 oz(3)

0.53 oz(3)

1.55 oz(3)

3.3 oz(3)

0.37 oz(3)

3 lb(3)

38 oz(3)

0.92 oz(3)

4.2 oz(3)

50 oz(3)

0.7 oz(3)

0.6 oz(3)

3 oz(3)

0.63 oz(3)

3.5 oz(3)

32.1 oz(2)

35.6 oz(2)

1.06 oz(2)

13 oz(2)

31.5 oz(2)

1.6 oz(2)

44.93 oz(2)

3.5 lb(2)

56 oz(2)

20.1 oz(2)

26 oz(2)

5 oz(2)

3.53 oz(2)

35 oz(2)

2.75 oz(2)

54 oz(2)

32 oz(2)

Assorted Full Size Bars(2)

6.25 oz(2)

15.6 oz(2)

1.85 lb(2)

0.33 oz(2)

30 oz(2)

0.04 oz(2)

34 oz(2)

0.85 oz(2)

48 oz(2)

14 oz(2)

1.32 oz(2)

0.35 oz(2)

46.5 oz(2)

1.2 oz(2)

1.4 oz(2)

12 oz(2)

20.4 oz(1)

33.9 oz(1)

37.4 oz(1)

2.2 lb(1)

71.96 oz(1)

15.92 oz(1)

17 oz(1)

10.2 oz(1)

5 lbs(1)

3.02 oz(1)

10.4 oz(1)

17.6 oz(1)

5.32 oz(1)

27 oz(1)

32.55 oz(1)

35.2 oz(1)

51 oz(1)

30.35 oz(1)

4.12 oz(1)

25 Assorted Snacks(1)

1.69 oz(1)

1.74 oz(1)

25.4 oz(1)

2 lb(1)

34.19 oz(1)

32.89 oz(1)

55.8 oz(1)

32.06 oz(1)

33.38 oz(1)

10.72 oz(1)

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

9.04 oz(1)

4.4 oz(1)

44.37 oz(1)

168.81 oz(1)

3.29 oz(1)

1.46 oz(1)

15 oz(1)

30 lb(1)

5.1 oz(1)

32.9 oz(1)

15.77 oz(1)

15.96 oz(1)

14.86 oz(1)

46 oz(1)

32.34 oz(1)

85.23 oz(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.5 lb(1)

1.44 oz(1)

10.83 oz(1)

43.07 oz(1)

0.5 oz(1)

67.2 oz(1)

47.6 oz(1)

40.5 oz(1)

0.4 oz(1)

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

2.59 lb(1)

62.6 oz(1)

31.6 oz(1)

69.4 oz(1)

8 oz(1)

4.25 oz(1)

33 oz(1)

1.75 oz(1)

1.45 oz(1)

17.1 oz(1)

19.5 oz(1)

19.8 oz(1)

21.2 oz(1)

44.07 oz(1)

20 lb(1)

3.2 oz(1)

0.67 oz(1)

10 oz(1)

4.75 lb(1)

1 lb, 1.5 oz(1)

55 oz(1)

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

2.24 lb(1)

0.8 oz(1)

3.3 lb(1)

4.15 lb(1)

4.95 lb(1)

2.12 lb(1)

84 oz(1)

 
Food Type

Candy Bars(101)

Candy(62)

Chewy Candy(39)

Gum(27)

Hard Candy(16)

Mints(16)

Lollipops(15)

Gummy Candy(10)

Jelly Beans(4)

Chips(3)

Candy; Chocolate(2)

Licorice(2)

Sour Candy(1)

Taffy(1)

Baking Supplies(1)

Fruit Drops(1)

Chocolate; Candy(1)

Chocolate(1)

Snack Variety Packs(1)

Honey(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved