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

Tootsie Roll(16)

Reese's(12)

Trident(12)

M & M's(10)

YumEarth(10)

MARS(9)

Ghirardelli(8)

Spangler(8)

Colombina(8)

Werther's Original(7)

Nestlé(7)

Starburst(6)

LifeSavers(5)

Jolly Rancher(5)

Lindt(5)

Mentos(5)

Snickers(5)

Altoids(4)

Dubble Bubble(4)

Jelly Belly(4)

Kit Kat(4)

York(4)

Orbit(4)

Hi-Chew(4)

Sour Patch Kids(4)

VerMints(4)

Tic Tac(3)

NERDS(3)

Sanders(3)

UNREAL(3)

Charms(3)

Office Snax(3)

National Brand(3)

Ferrara(3)

Snack Jar(3)

Dentyne Ice(3)

Skittles(3)

King Leo(2)

Red Bird(2)

Nickelodeon(2)

Barnana(2)

Snack Box Pros(2)

Sour Punch(2)

Andes(2)

Red Vines(2)

Twix(2)

Charleston Chews(2)

World Confections(2)

Lik-m-aid Fun Dip(2)

Haribo(2)

DeMet's(2)

POP ROCKS(2)

Bazooka(2)

Wrigley's(2)

Airheads(1)

PayDay(1)

Lulú(1)

100 GRAND(1)

Gilliam(1)

Junior Mints(1)

Breitsamer Honig(1)

Hospitality Mints(1)

Trolli(1)

Almond Joy(1)

Albanese World’s Best(1)

Riesen(1)

Dentyne Pure(1)

StarTech.com(1)

Swedish Fish(1)

Big League Chew(1)

ROLO(1)

WHATCHAMACALLIT(1)

BROOKSIDE(1)

Sunkist(1)

Dove Chocolate(1)

JOJO's Chocolate(1)

Black Forest(1)

Pearson's(1)

WARHEADS(1)

LemonHead(1)

Butterfinger(1)

Mounds(1)

Goetze’s(1)

Now and Later(1)

Bonomo(1)

Albert's(1)

Good & Plenty(1)

SKOR(1)

Twizzlers(1)

FERRERO ROCHER(1)

 
Packaged Quantity

1(1)

 
Weight (Approximate)

4.20 oz(1)

 
Flavor

Milk Chocolate(34)

Assorted(20)

Peppermint(19)

Original(9)

Caramel(8)

Chocolate(8)

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

Wintergreen(6)

Spearmint(5)

Cherry; Lemon; Orange; Strawberry(5)

Snickers(4)

York(3)

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

Chocolate Mint(3)

Strawberry(3)

Milk Chocolate with Almonds(3)

Milk Chocolate; Peanut(2)

Peanut Butter(2)

Mint(2)

Fruity(2)

Special Dark Chocolate(2)

Cookies 'n' Creme(2)

Grape; Green Apple; Lemon; Orange; Strawberry(2)

Twix(2)

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

Milk Chocolate Sea Salt(2)

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

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

Pep-O-Mint(2)

Original Five Flavors(2)

Peanut(2)

Milk Chocolate Caramel(2)

Watermelon(2)

Blue Raspberry(2)

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

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

Apple; Cherry; Pink Lemonade; Watermelon(2)

Milk Chocolate & Caramel(2)

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)

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

Intense Dark Midnight Reverie 86% Cacao(1)

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

Blackberry; Cherry; Green Apple; Peach(1)

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

Dark Chocolate & Sea Salt Caramel(1)

Pomegranate(1)

Peppermint/Chocolate(1)

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

Dark Chocolate; Milk Chocolate; White Creme(1)

Special Dark with Almonds(1)

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

Gingermint(1)

Outta' Here Original(1)

Peppermint; Spearmint; Wintermint(1)

Bubblemint(1)

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

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

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

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

Almond Joy(1)

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

Reese's(1)

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

Peppermint Cobalt(1)

Mint Bliss(1)

Cherry; Razzapple(1)

Spearmint Rush(1)

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

Peanut Caramel(1)

Almond Joy; Mounds(1)

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

Wint-O-Green(1)

Arctic Chill(1)

Mixed Fruit(1)

Milk Chocolate Sea Salt Caramels(1)

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

Dark Chocolate Sea Salt Caramel(1)

Randomly Assorted(1)

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

Milk Chocolate and Peanut Butter(1)

Chocolate and Caramel(1)

Cherry; Lemon; Lime; Orange(1)

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

Grape(1)

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

Acapulco Lime; Himalayan Pink Salt(1)

Black Licorice(1)

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

Fresh Mint; Spearmint(1)

Peanut Butter/Chocolate(1)

Chalky Sugar(1)

Carmel Apple(1)

Freshmint(1)

Ghoulish Green Twix; Ghoulish Green Snickers; 3 Musketeers; MilkyWay; Skittles; Starburst; Twix(1)

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

Ghoulish Green Twix; Ghoulish Green Snickers; Lifesavers Gummies; Milky Way; Skittles Gummies; Snickers; Twix(1)

Ghoulish Green Twix; Ghoulish Green Snickers; M&M's; M&M's Peanut; MilkyWay; Snickers; Twix(1)

3 Musketeers; Almond Joy; Baby Ruth; Butterfinger; Hershey's Milk Chocolate; Milky Way; Kit Kat; Nestle Crunch; Reese's Peanut Butter Cups; Snickers; TWIX; York Peppermint Patties(1)

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

WHATCHAMACALLIT(1)

Tropical(1)

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

Himalayan Pink Sea Salt(1)

Baby Ruth; Butterfinger; Crunch Bar(1)

STICKS(1)

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

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

Milk Chocolate Crunch Bar(1)

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

Milk Chocolate Peanut Butter Cups(1)

Snickers Almond(1)

White Peppermint(1)

Perfect Peppermint(1)

Chocolate and Raisin(1)

Plantain Chips Salted(1)

Cherry Yum; Razz Apple(1)

Original Chunky Bar(1)

Sweet & Sour(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)

Assorted Sour(1)

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

100 GRAND(1)

Caramel Apple(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)

Honey and Oats(1)

Caramel Chocolate Nut(1)

Dark Chocolate & Coconut(1)

Assorted Fruity(1)

Dark Chocolate Almond Butter(1)

Caramel Peanut Nougat(1)

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

Cherry; Mango; Peach; Strawberry(1)

Cherry; Grape; Mango; Peach; Pomegranate; Razzamatazz Berry; Strawberry; Watermelon(1)

Berry; Cherry; Grape; Mango; Peach; Pomegranate; Strawberry; Watermelon(1)

Dark Chocolate Caramel(1)

Grape; Lemonade; Orange; Strawberry(1)

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

Berry(1)

Cadbury Caramello Milk Chocolate Caramel; Hershey's Milk Chocolate; Hershey's Milk Chocolate KISSES; Kit Kat; Reese's Peanut Butter Cups(1)

3 Musketeers; MilkyWay; Snickers; Twix(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)

Dark Chocolate(1)

Cherry(1)

Assorted Fruit Flavors(1)

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

3 Musketeers; MilkyWay; Snickers; Twix; M&Ms; Peanut M&Ms(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; 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)

Original Pecan(1)

Peppermint; Spearmint; Sweet Mint; Wintermint(1)

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

Skittles Wild 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)

Acai Blueberry; Pomegranate(1)

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

Spearmint Rain(1)

 
Form Factor

Desktop(1)

Wall Mountable(1)

 
USB

Yes(1)

 
Ethernet Technology

Fast Ethernet(1)

 
Country of Origin

US(307)

CO(8)

MX(6)

CA(2)

ES(2)

NL(2)

BR(2)

DK(1)

DE(1)

 
Height

1.4"(1)

 
Width

2.2"(1)

 
Depth

1.9"(1)

 
Packing Type

Bag(3)

Individually Wrapped(2)

 
Capacity (Weight)

5 lb(17)

66.7 oz(14)

38.8 oz(8)

1.5 oz(7)

0.63 oz(6)

2 oz(6)

0.7 oz(5)

0.6 oz(5)

1 oz(4)

3 oz(4)

3.3 oz(3)

48 oz(3)

12.7 oz(3)

38 oz(3)

20.1 oz(3)

32 oz(3)

35.9 oz(3)

35.6 oz(3)

31.5 oz(3)

32.1 oz(3)

10.1 oz(3)

1.55 oz(3)

6.25 oz(3)

50 oz(3)

3.5 oz(3)

30 oz(2)

40 oz(2)

1.06 oz(2)

Assorted Full Size Bars(2)

56 oz(2)

1.4 oz(2)

0.53 oz(2)

3.5 lbs(2)

3.53 oz(2)

0.04 oz(2)

19.5 oz(2)

3.5 lb(2)

2.75 oz(2)

15.96 oz(2)

5 lbs(2)

15.6 oz(2)

2.5 oz(2)

35.2 oz(2)

0.85 oz(2)

46.5 oz(2)

35 oz(2)

12 oz(2)

34 oz(2)

54 oz(2)

60 oz(2)

28 oz(2)

1.32 oz(2)

3 lb(2)

18 oz(2)

1.2 oz(2)

0.37 oz(2)

0.43 oz(2)

0.4 oz(2)

1.85 lb(2)

0.35 oz(2)

0.33 oz(2)

27 oz(1)

10.72 oz(1)

1.69 oz(1)

3.4 lb(1)

0.57 oz(1)

15 oz(1)

44.37 oz(1)

1.46 oz(1)

45.85 oz(1)

5.1 oz(1)

14.86 oz(1)

15.77 oz(1)

0.25 oz(1)

51 oz(1)

4.4 oz(1)

9.04 oz(1)

4.12 oz(1)

5.32 oz(1)

30 lb(1)

5 oz(1)

0.32 oz(1)

0.2 oz(1)

17 oz(1)

26 oz(1)

1.74 oz(1)

19.41 oz(1)

25.4 oz(1)

4.2 oz(1)

44.93 oz(1)

14 oz(1)

34.19 oz(1)

1.85 oz(1)

55.8 oz(1)

45 oz(1)

33.38 oz(1)

2 lb(1)

32.06 oz(1)

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

33.43 oz; 35.7 oz; 49.44 oz(1)

20.13 oz; 46.19 oz(1)

20.13 oz; 49.9 oz(1)

20.13 oz; 58.63 oz(1)

2.07 oz(1)

1.48 oz(1)

0.16 oz(1)

33.9 oz(1)

3.02 oz(1)

20.4 oz(1)

3.29 oz(1)

46 oz(1)

37.4 oz(1)

42 oz(1)

4.15 lb(1)

4.95 lb(1)

2.12 lb(1)

4.75 lb(1)

62.6 oz(1)

0.5 oz(1)

6 oz(1)

2.59 lb(1)

0.42 oz(1)

0.28 oz(1)

1.76 oz(1)

3.47 lb(1)

1.86 oz(1)

2.8 oz(1)

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

3.3 lb(1)

0.55 oz(1)

2.2 lb(1)

20 lb(1)

15.92 oz(1)

10.2 oz(1)

10.4 oz(1)

17.6 oz(1)

32.55 oz(1)

32.34 oz(1)

31.6 oz(1)

13 oz(1)

4.25 oz(1)

33 oz(1)

1.6 oz(1)

1.75 oz(1)

17.1 oz(1)

19.8 oz(1)

6 lb, 8.4 oz(1)

21.2 oz(1)

49.44 oz(1)

63.4 oz(1)

40.98 oz(1)

35.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)

84 oz(1)

 
Food Type

Candy Bars(107)

Candy(67)

Chewy Candy(41)

Gum(31)

Mints(19)

Lollipops(18)

Hard Candy(18)

Gummy Candy(13)

Jelly Beans(4)

Chips(3)

Sour Candy(2)

Licorice(2)

Honey(1)

Taffy(1)

Fruit Drops(1)

Chocolate(1)

Snack Variety Packs(1)

Candy; Chocolate(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved