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

Trident(13)

Reese's(10)

YumEarth(10)

M & M's(10)

Kit Kat(10)

Spangler(9)

Ghirardelli(8)

Nestlé(8)

Colombina(6)

Charms(5)

LifeSavers(5)

Lindt(5)

Dubble Bubble(4)

MARS(4)

Jelly Belly(4)

Altoids(4)

VerMints(4)

Snickers(4)

Jolly Rancher(4)

Starburst(4)

Sour Patch Kids(4)

Dove Chocolate(3)

Red Vines(3)

York(3)

Mentos(3)

Werther's Original(3)

Orbit(3)

Hi-Chew(3)

Office Snax(3)

Tic Tac(2)

Wrigley's(2)

Barnana(2)

National Brand(2)

DeMet's(2)

ROLO(2)

Godiva(2)

Twizzlers(2)

Dentyne Ice(2)

Twix(2)

Swedish Fish(2)

Bazooka(2)

POP ROCKS(2)

Albanese World’s Best(2)

Skittles(2)

Albert's(1)

Nickelodeon(1)

Milk Duds(1)

World Confections(1)

Mounds(1)

MR. GOODBAR(1)

WHATCHAMACALLIT(1)

HEATH(1)

Almond Joy(1)

Junior Mints(1)

Trolli(1)

Charleston Chews(1)

Storck(1)

Gerrit's(1)

Sugar Daddy(1)

Snack Box Pros(1)

Hospitality Mints(1)

Sweet's(1)

Walker’s Nonsuch(1)

Riesen(1)

StarTech.com(1)

Good & Plenty(1)

LILY’S(1)

FERRERO ROCHER(1)

Kervan(1)

SKOR(1)

Ferrara(1)

LemonHead(1)

Breitsamer Honig(1)

Now and Later(1)

Andes(1)

Sour Punch(1)

King Leo(1)

Gilliam(1)

Bonomo(1)

Haribo(1)

Pearson's(1)

Sunkist(1)

Goetze’s(1)

Black Forest(1)

Airheads(1)

BROOKSIDE(1)

Lik-m-aid Fun Dip(1)

100 GRAND(1)

KINDER JOY(1)

Anastasia Confections(1)

JOJO's Chocolate(1)

Lulú(1)

 
Packaged Quantity

1(1)

 
Weight (Approximate)

4.20 oz(1)

 
Flavor

Milk Chocolate(29)

Assorted(21)

Peppermint(14)

Original(9)

Chocolate(7)

Strawberry(6)

Wintergreen(6)

Caramel(5)

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

Milk Chocolate with Almonds(5)

Special Dark Chocolate(5)

Spearmint(4)

Cherry; Lemon; Orange; Strawberry(3)

Dark Chocolate; Milk Chocolate; White Creme(3)

Milk Chocolate with Toffee and Almonds(2)

Twix(2)

Milk Chocolate Sea Salt(2)

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

Cookies 'n' Creme(2)

Cherry(2)

Milk Chocolate & Caramel(2)

Milk Chocolate Peanut Butter Cups(2)

Snickers(2)

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

Black Licorice(2)

Bubble Gum(2)

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

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

York(2)

Milk Chocolate Caramel(2)

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

Chocolate Mint(2)

Watermelon(2)

Chocolate and Caramel(2)

Wint-O-Green(2)

Milk Chocolate; Peanut(2)

Variety(2)

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

Original Five Flavors(2)

Blue Raspberry(2)

Semi-Sweet Chocolate(1)

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

Milk Chocolate with White Creme(1)

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

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

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

Chocolate & Peanut M&M's(1)

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

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

Himalayan Pink Sea Salt(1)

Almond Joy(1)

Special Dark with Almonds(1)

Cherry; Fruit Punch; Strawberry; Watermelon(1)

Grape(1)

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

Reese's(1)

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

Milk Chocolate English Toffee(1)

WHATCHAMACALLIT(1)

Milk Chocolate with Peanuts(1)

STICKS(1)

White Creme(1)

Dark Chocolate & Coconut(1)

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

Gingermint(1)

Soft & Chewy Mix(1)

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

Peppermint/Chocolate(1)

Pep-O-Mint(1)

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

Acapulco Lime; Himalayan Pink Salt(1)

Spearmint Rush(1)

Mint Bliss(1)

Chocolate/Caramel/Hazelnut(1)

Mint(1)

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

Extra Dark Chocolate(1)

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

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

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

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

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

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

Mixed Fruit(1)

Intense Dark Midnight Reverie 86% Cacao(1)

Intense Dark Sea Salt Soiree(1)

Dark Chocolate & Sea Salt Caramel(1)

Pomegranate(1)

Mango Tango; Playful Pineapple, Razzmatazz Berry(1)

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

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

Googly Grape; Mango Tango; Perfectly Peach; Pomegranate Pucker; Razzmatazz Berry; Strawberry Smash; Very Very Cherry; WetFace Watermelon(1)

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

Blackberry; Cherry; Green Apple; Peach(1)

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

Arctic Chill(1)

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

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

Original Chunky Bar(1)

Milk Chocolate Pretzel(1)

Peanut(1)

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

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

Cinnamon(1)

Milk Chocolate; Peanut; Peanut Butter(1)

3 Musketeers; MilkyWay; Snickers; Twix(1)

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

Sour Lemon(1)

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

Vanilla(1)

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

Cherry Yum; Razz Apple(1)

Milk Chocolate Crunch Bar(1)

100 GRAND(1)

White Peppermint(1)

Banana(1)

Fruit(1)

White Spearmint(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)

Apple; Cherry; Pink Lemonade; Watermelon(1)

Caramel Apple(1)

Blue Razz Berry; Cherry; Grape; Orange; Strawberry; Watermelon(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)

Snickers Almond(1)

Perfect Peppermint(1)

Licorice(1)

Peppermint; Spearmint; Sweet Mint; Wintermint(1)

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

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

Chocolate, Peanut Butter(1)

Dark Chocolate(1)

Original Pecan(1)

Peanut Butter(1)

Chocolate/Coconut(1)

Dark Chocolate Ganache Heart(1)

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

Acai Blueberry; Pomegranate(1)

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

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

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

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

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

Watermelon Twist(1)

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

White Wintergreen(1)

Chocolate and Raisin(1)

Plantain Chips Salted(1)

Honey and Oats(1)

Sweet & Sour(1)

Caramel Chocolate Nut(1)

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

Assorted Fruit Flavors(1)

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

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

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

Bubblemint(1)

 
Form Factor

Desktop(1)

Wall Mountable(1)

 
USB

Yes(1)

 
Ethernet Technology

Fast Ethernet(1)

 
Country of Origin

US(289)

CO(3)

CA(2)

ES(2)

SE(1)

NL(1)

AR(1)

GB(1)

DE(1)

 
Height

1.4"(1)

 
Width

2.2"(1)

 
Depth

1.9"(1)

 
Packing Type

Bag(153)

Box(32)

Bar(25)

Pack(22)

Individually Wrapped(18)

Tub(18)

Pouch(12)

Jar(5)

Tin(4)

Roll(2)

Bottle(2)

Packet(1)

Tube(1)

Standup Pouch(1)

Egg(1)

Flip-Top Dispenser(1)

Cup(1)

Resealable Bag(1)

Carton(1)

 
Capacity (Weight)

5 lb(14)

66.7 oz(12)

1.5 oz(9)

38.8 oz(8)

0.7 oz(6)

10.1 oz(6)

5 oz(5)

2 oz(4)

3 oz(4)

3.5 oz(4)

12.7 oz(3)

1.55 oz(3)

1.4 oz(3)

3.3 oz(3)

1 oz(3)

50 oz(3)

20.1 oz(3)

32.1 oz(3)

3 lb(3)

0.6 oz(3)

16.1 oz(2)

1.2 oz(2)

32 oz(2)

1.6 oz(2)

5.1 oz(2)

28 oz(2)

13 oz(2)

3.5 lb(2)

4.12 oz(2)

33.9 oz(2)

35 oz(2)

9.6 oz(2)

35.9 oz(2)

15.6 oz(2)

2 lb(2)

Assorted Full Size Bars(2)

10.2 oz(2)

1.32 oz(2)

35.6 oz(2)

0.37 oz(2)

1.75 oz(2)

38.1 oz(2)

0.63 oz(2)

38 oz(2)

1.95 lb(2)

60 oz(2)

0.33 oz(2)

48 oz(2)

6.25 oz(2)

26 oz(2)

44.93 oz(2)

14 oz(2)

0.35 oz(2)

46.5 oz(2)

30 lb(1)

10.72 oz(1)

31.5 oz(1)

32.55 oz(1)

30 oz(1)

35.2 oz(1)

3.29 oz(1)

25 Assorted Snacks(1)

51 oz(1)

32.34 oz(1)

6.8 oz(1)

17.6 oz(1)

20.4 oz(1)

31.6 oz(1)

8 oz(1)

5 lbs(1)

3.02 oz(1)

4.25 oz(1)

33 oz(1)

2.75 lbs(1)

1.75 lb(1)

7.6 oz(1)

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

56 oz(1)

32.89 oz(1)

2.75 oz(1)

1.46 oz(1)

1.06 oz(1)

14.86 oz(1)

15.77 oz(1)

15.96 oz(1)

30.35 oz(1)

10.4 oz(1)

5.32 oz(1)

4 lb(1)

4.2 oz(1)

2 lbs(1)

4.5 lb(1)

37.4 oz(1)

2.2 lb(1)

15.92 oz(1)

16 oz(1)

10.8 oz(1)

15 oz(1)

0.19 oz(1)

1.45 oz(1)

40.5 oz(1)

1.86 oz(1)

1.14 oz(1)

42 oz(1)

2.8 oz(1)

1.5 lb(1)

1.44 oz(1)

10.83 oz(1)

1.85 lb(1)

85.23 oz(1)

43.07 oz(1)

67.2 oz(1)

47.6 oz(1)

1.7 oz(1)

0.4 oz(1)

1.76 oz(1)

0.43 oz(1)

2.17 oz(1)

3.08 lb(1)

6.75 lb(1)

29.76 oz(1)

1.3 oz(1)

1.83 lb(1)

0.81 oz(1)

1.08 oz(1)

62 oz(1)

10.5 oz(1)

0.47 oz(1)

4 lb 1 oz(1)

34 oz(1)

3.47 lb(1)

2.5 oz(1)

17.1 oz(1)

54 oz(1)

19.5 oz(1)

19.8 oz(1)

21.2 oz(1)

10 oz(1)

1 lb, 1.5 oz(1)

55 oz(1)

31 oz(1)

21.25 oz(1)

12 oz(1)

13.4 oz(1)

13.25 oz(1)

15.01 oz(1)

1 lb, 5 oz(1)

5 lb 3 oz(1)

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

4.75 lb(1)

0.5 oz(1)

6 oz(1)

2.59 lb(1)

40 oz(1)

0.42 oz(1)

27 oz(1)

 
Food Type

Candy Bars(108)

Candy(49)

Chewy Candy(41)

Gum(24)

Lollipops(18)

Mints(16)

Hard Candy(13)

Gummy Candy(11)

Licorice(5)

Jelly Beans(4)

Chips(3)

Chocolate(2)

Taffy(1)

Honey(1)

Sour Candy(1)

Baking Supplies(1)

Fruit Drops(1)

Fruit Snacks(1)

Snack Variety Packs(1)

 
 
 
 

© 2023-2024 Regal Office Supplies, All Rights Reserved