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') 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(56)

Office Snax(21)

Reese's(20)

M & M's(11)

Kit Kat(9)

Snickers(6)

LifeSavers(6)

Spangler(5)

MARS(5)

Trident(4)

Tootsie Roll(4)

Wrigley's(4)

Dentyne Ice(4)

York(4)

barkTHINS(3)

ROLO(3)

Jelly Belly(3)

National Brand(2)

Snack Box Pros(2)

HEATH(2)

Saf-T-Pops(2)

Red Bird(2)

Werther's Original(2)

Ghirardelli(2)

Dove Chocolate(2)

Andes(2)

MR. GOODBAR(1)

Twizzlers(1)

Dubble Bubble(1)

Swedish Fish(1)

Sour Patch Kids(1)

Skittles(1)

Dentyne Pure(1)

Starburst(1)

Riesen(1)

Walker’s Nonsuch(1)

100 GRAND(1)

Mentos(1)

ZERO(1)

Twix(1)

Hot Tamales(1)

Mike and Ike(1)

Hospitality Mints(1)

Black Forest(1)

Almond Joy(1)

FERRERO ROCHER(1)

5th AVENUE(1)

Good & Plenty(1)

WHATCHAMACALLIT(1)

 
Flavor

Milk Chocolate(33)

Assorted(16)

Milk Chocolate with Almonds(7)

Peppermint(5)

Snickers(5)

Special Dark Chocolate(4)

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

Chocolate(4)

York(4)

Caramel(3)

Dark Chocolate; Milk Chocolate; White Creme(3)

White Creme(3)

Cookies n Creme(3)

Milk Chocolate Caramel(3)

Original(3)

All Tyme Favorites(2)

Milk Chocolate English Toffee(2)

Pep-O-Mint(2)

Reese's(2)

Wint-O-Green(2)

Milk Chocolate with Toffee and Almonds(2)

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

Soft & Chewy Mix(2)

Peppermint Puffs(2)

Original Five Flavors(2)

Fancy Mix(2)

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

Chocolate Mint(2)

Variety(2)

Arctic Chill(2)

Pieces(2)

Original Fruits(1)

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

Hershey's KISSES; Reese's Peanut Butter Cups; Rolo(1)

Cinnamon(1)

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

Dark Chocolate(1)

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

Mint(1)

Milk Chocolate with Reese's Pieces(1)

Assorted Snacks(1)

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

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

Special Dark with Almonds(1)

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

Mixed Fruit(1)

Skittles; Starburst(1)

Cherry; Lemon; Orange; Strawberry(1)

Chocolate and Caramel(1)

Grape(1)

Starlight Mints, Peppermint(1)

Gummy Bears(1)

Starlight Mints, Spearmint(1)

Starlight Peppermints(1)

Peanut Butter(1)

Chocolate & Peanut M&Ms(1)

Butterscotch Creamy & Smooth Delights(1)

Strawberry(1)

Wrapped Asst. Fruit Slices(1)

Peppermint Cobalt(1)

Apple; Cherry; Grape; Orange(1)

Milk Chocolate; Peanut(1)

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

Almond Joy(1)

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

Peanut(1)

3 Musketeers; Milky Way; M&Ms; Snickers; Twix(1)

M&Ms; M&M Peanut; Snickers; Twix(1)

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

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

(10) Snickers; (8) Twix; (6) Milky Way; (3) 3 Musketeers; (3) Snickers Almond(1)

(8) Snickers; (6) M&M; (6) M&M Peanut; (4) Skittles; (3) 3 Musketeers; (3) Starburst(1)

Snickers Almond(1)

Milk Chocolate Pretzel(1)

Twix(1)

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

Milk Chocolate; Peanut; Peanut Butter(1)

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

3 Musketeers; Milky Way; Snickers; Twix(1)

100 GRAND(1)

Tropical Twist(1)

White Spearmint(1)

Mint with Herbal Accents(1)

Fruit(1)

Licorice(1)

TAKE5(1)

Milk Chocolate with White Creme(1)

Milk Chocolate with Dark Chocolate Drizzle(1)

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

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

OUTRAGEOUS!(1)

Semi-Sweet Chocolate(1)

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

Iceberg Mint(1)

Dark Chocolate Coconut with Almonds(1)

Milk Chocolate Peanut Butter(1)

STICKS Bars; Pieces Candies; Big Cup Peanut Butter Cups; White Creme Peanut Butter Cups; Peanut Butter Cups; PIECES Peanut Butter Cups(1)

ZERO(1)

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

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

Dark Chocolate Pretzel with Sea Salt(1)

Dark Chocolate Almond with Sea Salt(1)

5th AVENUE(1)

WHATCHAMACALLIT(1)

Special Dark(1)

Milk Chocolate with Peanuts(1)

STICKS(1)

Spearmint Rain(1)

 
Country of Origin

US(192)

AR(4)

CO(4)

CA(3)

MX(2)

NL(1)

BR(1)

GB(1)

DE(1)

 
Packing Type

Bag(114)

Box(26)

Bar(21)

Tub(17)

Pack(12)

Individually Wrapped(8)

Tubes(3)

Resealable Bag(2)

Carton(2)

Bowl(2)

Bottle(1)

Roll(1)

 
Capacity (Weight)

66.7 oz(12)

2 lbs(11)

1.5 oz(8)

10.1 oz(6)

10 oz(5)

10.2 oz(5)

7.6 oz(5)

10 lbs(5)

2 oz(4)

50 oz(4)

5 lb(3)

6.25 oz(3)

4.5 lbs(3)

38 oz(3)

40 oz(3)

4.25 oz(3)

48 oz(3)

32.1 oz(3)

5 lbs(2)

1.6 oz(2)

33 oz(2)

35.9 oz(2)

15.6 oz(2)

35.6 oz(2)

1.45 oz(2)

10.5 oz(2)

20.1 oz(2)

38.8 oz(2)

16.1 oz(2)

0.35 oz(2)

0.8 oz(2)

33.9 oz(2)

Assorted Full Size Bars(2)

30 oz(2)

12 oz(2)

46.5 oz(2)

30.35 oz(1)

15.92 oz(1)

16 oz(1)

25 lbs(1)

51 oz(1)

17.3 oz(1)

20.4 oz(1)

69.3 oz Total(1)

10.6 oz(1)

0.6 oz(1)

10.8 oz(1)

10.4 oz(1)

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

44 oz(1)

3.5 lbs(1)

28 oz(1)

1.69 oz(1)

1.32 oz(1)

24 oz(1)

0.85 oz(1)

1.75 lbs(1)

30 lbs(1)

26 oz(1)

2.75 lbs(1)

6 lbs(1)

10.72 oz(1)

3.29 oz(1)

23 oz(1)

9.6 oz(1)

46 oz(1)

17.6 oz(1)

42 oz(1)

81.7 oz(1)

20.77 oz(1)

15.01 oz(1)

1.76 oz(1)

1.86 oz(1)

1.53 oz(1)

1.14 oz(1)

1.55 oz(1)

19.8 oz(1)

1.44 oz(1)

10.83 oz(1)

85.23 oz(1)

43.07 oz(1)

67.2 oz(1)

1.08 oz(1)

0.63 oz(1)

0.19 oz(1)

21.2 oz(1)

19.5 oz(1)

32 oz(1)

1.48 oz(1)

35 oz(1)

31.5 oz(1)

32.55 oz(1)

35.2 oz(1)

20 lb(1)

32.34 oz(1)

31.6 oz(1)

8 oz(1)

17.1 oz(1)

44.65 oz(1)

1.4 oz(1)

1.75 oz(1)

1.8 oz(1)

1.85 oz(1)

1 lb(1)

2.8 oz(1)

60 oz(1)

35.8 oz(1)

 
Food Type

Candy Bars(132)

Chewy Candy(19)

Hard Candy(14)

Gum(12)

Lollipops(8)

Candy(6)

Mints(6)

Snack Variety Packs(5)

Gummy Candy(3)

Jelly Beans(3)

Baking Supplies(1)

 
 
 
 

© 2022-2023 Regal Office Supplies, All Rights Reserved