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

Reese's(23)

Office Snax(21)

M & M's(13)

Kit Kat(12)

Snickers(8)

LifeSavers(6)

Spangler(6)

York(6)

Trident(6)

Tootsie Roll(5)

MARS(5)

Dentyne Ice(5)

Wrigley's(4)

Mentos(4)

Jelly Belly(3)

Saf-T-Pops(3)

Jolly Rancher(3)

barkTHINS(3)

ROLO(3)

Werther's Original(3)

Dove Chocolate(2)

National Brand(2)

Snack Jar(2)

Lindt(2)

Twix(2)

Andes(2)

Skittles(2)

Swedish Fish(2)

Hi-Chew(2)

Snack Box Pros(2)

Red Bird(2)

Charms(2)

HEATH(2)

Twizzlers(2)

Ghirardelli(2)

Walker’s Nonsuch(1)

Dubble Bubble(1)

Junior Mints(1)

Tic Tac(1)

Sour Patch Kids(1)

Big League Chew(1)

Orbit(1)

Dentyne Pure(1)

Starburst(1)

Riesen(1)

Good & Plenty(1)

F.B. Washburn Candy(1)

Goetze’s(1)

Nestlé(1)

100 GRAND(1)

FERRERO ROCHER(1)

Hot Tamales(1)

Mike and Ike(1)

PayDay(1)

Hospitality Mints(1)

Almond Joy(1)

Black Forest(1)

5th AVENUE(1)

WHATCHAMACALLIT(1)

MR. GOODBAR(1)

ZERO(1)

Atomic FireBall(1)

 
Flavor

Milk Chocolate(45)

Assorted(21)

Milk Chocolate with Almonds(8)

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

Snickers(6)

York(6)

Original(6)

Dark Chocolate; Milk Chocolate; White Creme(5)

Caramel(4)

Chocolate(4)

Peppermint(4)

Special Dark Chocolate(4)

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

Milk Chocolate with Toffee and Almonds(3)

Milk Chocolate Caramel(3)

White Creme(3)

Cookies n Creme(3)

Strawberry(2)

Reese's(2)

Milk Chocolate English Toffee(2)

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

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

Variety(2)

Fancy Mix(2)

Dark Chocolate(2)

Mint(2)

Wint-O-Green(2)

Pep-O-Mint(2)

Original Five Flavors(2)

All Tyme Favorites(2)

Soft & Chewy Mix(2)

Peppermint Puffs(2)

Apple; Cherry; Grape; Orange(2)

Cinnamon(2)

Arctic Chill(2)

Chocolate Mint(2)

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

Pieces(2)

Peanut(2)

Twix(2)

Milk Chocolate; Peanut; Peanut Butter(2)

Spearmint(2)

White Spearmint(1)

Banana; Orange; Strawberry; Grape; Green Apple(1)

Assorted Flavors(1)

3 Musketeers; Milky Ways; Snickers Minis, Twix(1)

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

Milk Chocolate; Peanut(1)

Licorice(1)

Peanut Butter(1)

Tropical Twist(1)

Original Peppermint(1)

Wintergreen(1)

Mixed Fruit(1)

Caramel Cream(1)

100 GRAND(1)

Crisp Wafers in Milk Chocolate(1)

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

Original Fruits(1)

Wrapped Asst. Fruit Slices(1)

Mint with Herbal Accents(1)

Butterscotch Creamy & Smooth Delights(1)

Freshmint(1)

Peppermint Cobalt(1)

Bubblemint(1)

Outta' Here Original(1)

Iceberg Mint(1)

Grape(1)

Junior Mints(1)

18 Assorted Flavors(1)

Mason Dots; Tootsie Roll Pops; Tootsie Rolls(1)

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

Blueberry/Vanilla; Cherry/Vanilla; Orange/Vanilla; Strawberry/Vanilla(1)

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

Fruit(1)

Cherry; Lemon; Orange; Strawberry(1)

Chocolate and Caramel(1)

Starlight Mints, Peppermint(1)

Gummy Bears(1)

Starlight Mints, Spearmint(1)

Skittles; Starburst(1)

Fresh Mint(1)

Starlight Peppermints(1)

Chocolate & Peanut M&Ms(1)

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

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

Amond Joy; Mounds(1)

Special Dark(1)

Milk Chocolate Peanut Butter(1)

Milk Chocolate with Dark Chocolate Drizzle(1)

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

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

Snickers Almond(1)

Dark Chocolate Pretzel with Sea Salt(1)

Dark Chocolate Almond with Sea Salt(1)

5th AVENUE(1)

WHATCHAMACALLIT(1)

Milk Chocolate with Peanuts(1)

Almond Joy(1)

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

STICKS(1)

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

ZERO(1)

TAKE5(1)

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

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

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

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

Dark Chocolate Coconut with Almonds(1)

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

Peanut Caramel(1)

Milk Chocolate with Reese's Pieces(1)

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

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

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

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

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

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

Milk Chocolate; Milk Chocolate with Almonds; Milk Chocolate/White Creme(1)

Semi-Sweet Chocolate(1)

Special Dark with Almonds(1)

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

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

Milk Chocolate Pretzel(1)

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

Milk Chocolate with White Creme(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)

Spearmint Rain(1)

 
Country of Origin

US(252)

CA(6)

AR(4)

CO(4)

BR(2)

MX(2)

SE(1)

NL(1)

GB(1)

CN(1)

DE(1)

 
Packing Type

Bag(139)

Individually Wrapped(33)

Box(32)

Bar(21)

Tub(20)

Pack(15)

Tubes(3)

Bottle(2)

Resealable Bag(2)

Carton(2)

Bowl(2)

Pouch(1)

Roll(1)

Bulk(1)

Bucket(1)

 
Capacity (Weight)

66.7 oz(18)

2 lbs(11)

1.5 oz(8)

10.1 oz(6)

32.1 oz(6)

10 oz(6)

10.2 oz(5)

10 lbs(5)

7.6 oz(5)

50 oz(4)

2 oz(4)

48 oz(4)

20.1 oz(3)

60 oz(3)

4.25 oz(3)

33 oz(3)

35.9 oz(3)

35.6 oz(3)

38 oz(3)

6.25 oz(3)

4.5 lbs(3)

5 lbs(3)

56 oz(3)

40 oz(3)

0.8 oz(3)

38.8 oz(2)

15.6 oz(2)

1.06 oz(2)

26 oz(2)

1.85 oz(2)

12 oz(2)

1.6 oz(2)

16.1 oz(2)

35 oz(2)

3 lb(2)

46.5 oz(2)

35.2 oz(2)

14 oz(2)

35.8 oz(2)

1.45 oz(2)

0.85 oz(2)

5 lb(2)

Assorted Full Size Bars(2)

25.4 oz(2)

10.5 oz(2)

30 oz(2)

54 oz(2)

33.9 oz(2)

0.35 oz(2)

38.9 oz(1)

3.02 oz(1)

45 oz(1)

55.8 oz(1)

57.5 oz(1)

1.69 oz(1)

9.6 oz(1)

32.89 oz(1)

2.75 oz(1)

1.74 oz(1)

17 oz(1)

37 oz(1)

1.32 oz(1)

51 oz(1)

30.35 oz(1)

1 oz(1)

30 lbs(1)

3.29 oz(1)

4.4 oz(1)

10.72 oz(1)

20.4 oz(1)

2.7 lb(1)

0.2 oz(1)

172 oz(1)

2.75 lbs(1)

45.6 oz(1)

0.6 oz(1)

32.9 oz(1)

44 oz(1)

24 oz(1)

28 oz(1)

3.5 lbs(1)

71.96 oz(1)

36 oz(1)

23 oz(1)

25 lbs(1)

30 lb(1)

4 lb(1)

1.75 lbs(1)

40.5 oz(1)

12.7 oz(1)

42 oz(1)

19.5 oz(1)

19.8 oz(1)

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

2.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.21 oz(1)

0.63 oz(1)

12.8 oz(1)

0.19 oz(1)

20 lb(1)

17.1 oz(1)

1 lb(1)

3.53 oz(1)

10.4 oz(1)

6 lbs(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)

69.3 oz Total(1)

15.77 oz(1)

15.92 oz(1)

16 oz(1)

17.3 oz(1)

10.6 oz(1)

10.8 oz(1)

17.6 oz(1)

1.8 oz(1)

46 oz(1)

32 oz(1)

31.5 oz(1)

32.55 oz(1)

32.34 oz(1)

32.6 oz(1)

1.48 oz(1)

8 oz(1)

44.65 oz(1)

1.4 oz(1)

1.75 oz(1)

84 oz(1)

 
Food Type

Candy Bars(169)

Chewy Candy(27)

Hard Candy(21)

Gum(19)

Lollipops(15)

Mints(8)

Snack Variety Packs(5)

Candy(4)

Gummy Candy(3)

Jelly Beans(3)

Baking Supplies(1)

 
 
 
 

© 2021-2022 Regal Office Supplies, All Rights Reserved