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

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)

barkTHINS(3)

ROLO(3)

Werther's Original(3)

Lindt(2)

Red Bird(2)

Snack Jar(2)

Dove Chocolate(2)

Twix(2)

Jolly Rancher(2)

Skittles(2)

Swedish Fish(2)

Hi-Chew(2)

National Brand(2)

Snack Box Pros(2)

Charms(2)

Andes(2)

HEATH(2)

Twizzlers(2)

Ghirardelli(2)

Walker’s Nonsuch(1)

Dubble Bubble(1)

Tic Tac(1)

Sour Patch Kids(1)

Junior Mints(1)

Big League Chew(1)

Dentyne Pure(1)

Orbit(1)

Starburst(1)

Riesen(1)

FERRERO ROCHER(1)

F.B. Washburn Candy(1)

Goetze’s(1)

Nestlé(1)

100 GRAND(1)

Good & Plenty(1)

Hot Tamales(1)

Mike and Ike(1)

PayDay(1)

Hospitality Mints(1)

Almond Joy(1)

5th AVENUE(1)

WHATCHAMACALLIT(1)

MR. GOODBAR(1)

ZERO(1)

Black Forest(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)

Milk Chocolate with Toffee and Almonds(3)

Milk Chocolate Caramel(3)

White Creme(3)

Cookies n Creme(3)

Variety(2)

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)

Apple; Cherry; Grape; Orange(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)

Blue Raspberry; Cherry; Green Apple; Grape; Watermelon(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; Hershey's Milk Chocolate with Almonds; Kit Kat Bars; Reese's Peanut Butter Cups(1)

Amond Joy; Mounds(1)

Special Dark(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)

Dark Chocolate Coconut with Almonds(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)

Milk Chocolate Peanut Butter(1)

Almond Joy(1)

Peanut Caramel(1)

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

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

Hershey's Milk Chocolate Bars; Kit Kat Bars; Reese's Peanut Butter Cups; Whoppers Malted Milk Balls(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)

Milk Chocolate with Reese's Pieces(1)

Special Dark with Almonds(1)

Hershey's Milk Chocolate Bars; Kit Kat Bars; Reese's Peanut Butter Cups(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)

Semi-Sweet Chocolate(1)

Spearmint Rain(1)

 
Country of Origin

US(251)

CA(5)

AR(4)

CO(4)

BR(2)

MX(2)

SE(1)

NL(1)

GB(1)

CN(1)

DE(1)

 
Packing Type

Bag(137)

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

10.2 oz(5)

7.6 oz(5)

2 oz(4)

48 oz(4)

50 oz(4)

38 oz(3)

60 oz(3)

33 oz(3)

20.1 oz(3)

35.6 oz(3)

4.25 oz(3)

56 oz(3)

35.9 oz(3)

6.25 oz(3)

0.8 oz(3)

40 oz(3)

4.5 lbs(3)

25.4 oz(2)

3 lb(2)

1.45 oz(2)

38.8 oz(2)

0.85 oz(2)

1.85 oz(2)

35.2 oz(2)

14 oz(2)

1.6 oz(2)

46.5 oz(2)

12 oz(2)

15.6 oz(2)

10.5 oz(2)

5 lb(2)

0.35 oz(2)

33.9 oz(2)

1.06 oz(2)

16.1 oz(2)

54 oz(2)

35.8 oz(2)

Assorted Full Size Bars(2)

35 oz(2)

30 oz(2)

5 lbs(2)

26 oz(2)

9.6 oz(1)

32.89 oz(1)

1.69 oz(1)

55.8 oz(1)

1.74 oz(1)

37 oz(1)

45 oz(1)

38.9 oz(1)

1.32 oz(1)

40.5 oz(1)

30.35 oz(1)

25 lbs(1)

2.75 oz(1)

17 oz(1)

57.5 oz(1)

3.02 oz(1)

36 oz(1)

71.96 oz(1)

0.6 oz(1)

1 oz(1)

45.6 oz(1)

172 oz(1)

20.4 oz(1)

51 oz(1)

30 lbs(1)

32.9 oz(1)

3.29 oz(1)

4.4 oz(1)

10.72 oz(1)

2.7 lb(1)

0.2 oz(1)

2.75 lbs(1)

44 oz(1)

24 oz(1)

28 oz(1)

3.5 lbs(1)

23 oz(1)

30 lb(1)

4 lb(1)

1.75 lbs(1)

32 oz(1)

12.7 oz(1)

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

42 oz(1)

1.44 oz(1)

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

19.5 oz(1)

2.8 oz(1)

3.53 oz(1)

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

16 oz(1)

17.3 oz(1)

10.6 oz(1)

10.8 oz(1)

10.4 oz(1)

46 oz(1)

1 lb(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)

1.8 oz(1)

84 oz(1)

 
Food Type

Candy Bars(168)

Chewy Candy(27)

Hard Candy(20)

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