Banner1 Banner1
 
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_19` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`category_name` LIKE "Candy, Gum & Mints") AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=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 MATCH(`desc_short`) AGAINST ('CandyGumandMint' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+CandyGumandMint' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"CandyGumandMint"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"CandyGumandMint"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"CandyGumandMint"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"CandyGumandMint"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+CandyGumandMint' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='CandyGumandMint',`category_4` ='CandyGumandMint') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'CandyGumandMint,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('CandyGumandMint', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

CANDY, GUM & MINTS


Search Again >>


Refine Search

  GO
Brand

Office Snax(24)

LifeSavers(6)

Dentyne Ice(5)

M & M's(4)

Nabisco(4)

Nestlé(3)

Trident(3)

Jelly Belly(3)

Spangler(3)

Kellogg's(3)

CLIF Bar(3)

Tootsie Roll(2)

Werther's Original(2)

Saf-T-Pops(2)

Riesen(2)

Mentos(2)

Charms(1)

Mike and Ike(1)

Swedish Fish(1)

Dubble Bubble(1)

Twizzlers(1)

Hot Tamales(1)

Wrigley's(1)

Welch's(1)

Skittles(1)

Hospitality Mints(1)

Haribo(1)

Brach's(1)

Sour Patch(1)

Walker’s Nonsuch(1)

Starburst(1)

Jolly Rancher(1)

Red Vines(1)

Mayfair(1)

Packing Type

Bag(35)

Tub(20)

Box(12)

Pack(6)

Bar(3)

Carton(2)

Tin(2)

Roll(2)

Bowl(2)

Bottle(2)

Pouch(1)

Individually Wrapped(1)

Canister(1)

Flavor

Assorted(21)

Original(3)

Pep-O-Mint(2)

Mixed Fruit(2)

Original Five Flavors(2)

Strawberry(2)

Milk Chocolate(2)

Mixed Berry(2)

Milk Chocolate with Peanuts(2)

Chocolate and Caramel(2)

Original Assortment(2)

Caramel(2)

Fancy Mix(2)

Peppermint Puffs(2)

All Tyme Favorites(2)

Soft & Chewy Mix(2)

Mint(2)

Wint-O-Green(2)

Starlight Peppermints(1)

Vanilla Crème(1)

Starlight Mints, Spearmint(1)

Generations Mix(1)

Chocolate & Peanut M&Ms(1)

Butterscotch Creamy & Smooth Delights(1)

Bubblegum(1)

Jelly Beans(1)

Gummy Bears(1)

Starburst Original; Starburst Tropical;Starburst FaveREDS; Skittles Original; Skittles Wild Berry; Skittles Tropical;Skittles Sour(1)

Chocolate Chip(1)

Chocolate(1)

White Chocolate Macadamia Nut(1)

Starlight Mints, Peppermint(1)

Crunchy Peanut Butter(1)

Glacier Mint(1)

Wrapped Asst. Fruit Slices(1)

Fruit(1)

Arctic Chill(1)

Peppermint(1)

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

Cinnamon(1)

Gummi Bears - Original Assortment(1)

Original Fruits(1)

Peanut Butter(1)

Devil's Food(1)

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

Iceberg Mint(1)

SweeTarts;Bottle Caps;Nerds;Laffy Taffy(1)

Avalanche(1)

Blueberry(1)

Glacier(1)

Fresh Mint(1)

Manufacturer Part Number

00603(1)

00602(1)

00601(1)

00086(1)

70005(1)

70009(1)

72512(1)

70019(1)

70015(1)

70013(1)

00085(1)

00068(1)

00017(1)

00015(1)

00013(1)

00007(1)

00028(1)

00029(1)

00067(1)

00066(1)

00042(1)

72692(1)

94054(1)

884580(1)

16403(1)

1034885(1)

1014965(1)

884064(1)

884640(1)

39870(1)

039856(1)

884614(1)

66(1)

60(1)

398052(1)

035926(1)

827495(1)

98475(1)

22649(1)

24552(1)

545(1)

534(1)

182(1)

00005(1)

00004(1)

43146(1)

12296(1)

10512(1)

07737(1)

43147(1)

6763800(1)

460989(1)

46097(1)

30220(1)

000501(1)

04754(1)

02908BX(1)

00176(1)

50120(1)

161009(1)

160004(1)

00735(1)

00866(1)

00926(1)

00924(1)

00868(1)

884243(1)

11050(1)

24929(1)

24908(1)

1137771(1)

1137762(1)

48749(1)

85741(1)

00003(1)

00002(1)

86774(1)

430220(1)

4181(1)

22732(1)

21524(1)

29668(1)

29665(1)

22733(1)

88501(1)

4180(1)

88504(1)

88503(1)

827132(1)

Country of Origin

US(64)

CA(6)

AR(5)

CO(4)

DE(3)

MX(2)

NL(2)

BR(1)

GB(1)

TR(1)

Capacity (Volume)

300 ct(1)

Capacity (Weight)

2 lbs(10)

0.8 oz(5)

10 lbs(5)

41 oz(3)

6.25 oz(3)

4.5 lbs(3)

5 lbs(3)

2.4 oz(3)

9 oz(2)

32 oz(2)

2.5 oz(2)

62 oz(2)

19.2 oz(2)

0.35 oz(2)

30 oz(2)

1.32 oz(2)

46.5 oz(2)

1.75 lbs(1)

16 oz(1)

2.75 lbs(1)

70 oz(1)

5.5 lbs(1)

30 lbs(1)

25 lbs(1)

51 oz(1)

54 oz(1)

0.76 oz(1)

57.5 oz(1)

20.4 oz(1)

44 oz(1)

.9 oz(1)

3.08 lbs(1)

0.186 oz(1)

12 oz(1)

12.8 oz(1)

8 oz(1)

6.75 oz(1)

1.7 oz(1)

7.352 oz(1)

1.76 oz(1)

26 oz(1)

5 oz(1)

23 oz(1)

3.5 lbs(1)

28 oz(1)

2.5 lb(1)

58 oz(1)

0.7 oz(1)

50 oz(1)

24 oz(1)

Food Type

Candy(71)

Gum(7)

Nutrition Bar(3)

Cookies(3)

Mint(2)

Fruit Snacks(1)

Licorice(1)

Breakfast Biscuits(1)

Price Range

$0-$99.99(86)

$100-$199.99(3)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Carriage Paper Products, All Rights Reserved