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_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 ('1019')) 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 '%CandyGumandMints' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('CandyGumandMints' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+CandyGumandMints' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"CandyGumandMints"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"CandyGumandMints"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"CandyGumandMints"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"CandyGumandMints"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+CandyGumandMints' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='CandyGumandMints',`category_4` ='CandyGumandMints') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'CandyGumandMints,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('CandyGumandMints', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Candy Gum And Mints

Refine Search

  GO
 
Brand

Office Snax(21)

Nabisco(9)

LifeSavers(8)

M & M's(7)

Tootsie Roll(4)

Nestl(3)

CLIF Bar(3)

Dentyne Ice(3)

Spangler(3)

Jelly Belly(3)

Twizzlers(2)

Tic Tac(2)

Saf-T-Pops(2)

Skittles(2)

Starburst(2)

Riesen(2)

Mentos(2)

Kellogg's(2)

Swedish Fish(2)

Trident(2)

Black Forest(2)

Werther's Original(2)

Hot Tamales(1)

Mike and Ike(1)

Walkers Nonsuch(1)

Red Vines(1)

Haribo(1)

Hospitality Mints(1)

Brach's(1)

Certs(1)

Sour Patch(1)

Jolly Rancher(1)

Mayfair(1)

Dubble Bubble(1)

Chiclets(1)

Welch's(1)

Wrigley's(1)

 
Packing Type

Bag(43)

Tub(19)

Box(12)

Pack(11)

Bar(3)

Bottle(3)

Roll(3)

Carton(2)

Bowl(2)

Individually Wrapped(1)

Canister(1)

Pouch(1)

 
Flavor

Assorted(21)

Original(6)

Original Assortment(3)

Milk Chocolate(3)

Original Five Flavors(3)

Peppermint(3)

Strawberry(3)

Caramel(2)

Chocolate and Caramel(2)

Soft & Chewy Mix(2)

All Tyme Favorites(2)

Peanut(2)

Mixed Fruit(2)

Pep-O-Mint(2)

Mint(2)

Wint-O-Green(2)

Arctic Chill(2)

Blueberry(2)

Golden Oat(2)

Peanut Butter(2)

Fresh Mint(1)

Peppermint Puffs(1)

Spearmint(1)

Starlight Mints, Spearmint(1)

Fancy Mix(1)

Jelly Beans(1)

Crunchy Peanut Butter(1)

Gummy Bears(1)

Starlight Mints, Peppermint(1)

White Chocolate Macadamia Nut(1)

Chocolate Chip(1)

Freshmint(1)

Orange(1)

Chocolate(1)

Starburst Original; Starburst Very Berry; Starburst FaveReds; Skittles Original; Skittles Wildberry; Skittles Sour; Skittles Darkside(1)

Butterscotch Creamy & Smooth Delights(1)

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

Wrapped Asst. Fruit Slices(1)

Vanilla Crme(1)

Wintergreen(1)

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

Milk Chocolate with Peanuts(1)

Devil's Food(1)

Peppermint/Spearmint(1)

Soft Baked Oats & Chocolate(1)

Mixed Berry(1)

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

Cinnamon(1)

Original Fruits(1)

Gummi Bears - Original Assortment(1)

Fruit(1)

Strawberry Creme(1)

Milk Chocolate Pretzel(1)

 
Manufacturer Part Number

SN38096(1)

00086(1)

72692(1)

72512(1)

70019(1)

70015(1)

70013(1)

70009(1)

70005(1)

22935(1)

21264(1)

21262(1)

00085(1)

98475(1)

00068(1)

00042(1)

00029(1)

00028(1)

00017(1)

00015(1)

00013(1)

00007(1)

00005(1)

00004(1)

94054(1)

827495(1)

00002(1)

00633(1)

039856(1)

884614(1)

884640(1)

884064(1)

51902(1)

884580(1)

7806(1)

7801(1)

16403(1)

0508(1)

00631(1)

035926(1)

66(1)

60(1)

545(1)

534(1)

182(1)

24552(1)

22701(1)

24947(1)

22649(1)

398052(1)

00003(1)

85741CT(1)

827132(1)

10512(1)

7155000(1)

6763800(1)

4331800(1)

43147(1)

43146(1)

34068(1)

3125400(1)

3105000(1)

12296(1)

10849(1)

07737(1)

75400(1)

04754(1)

03745(1)

02946BX(1)

02946(1)

02908BX(1)

02908(1)

00176(1)

50120(1)

161009(1)

160004(1)

08393(1)

75402(1)

85741(1)

88504(1)

48749(1)

827470(1)

827450(1)

32438(1)

32437(1)

24929(1)

24908(1)

430220(1)

4181(1)

4180(1)

88503(1)

000501(1)

88501(1)

22733(1)

22732(1)

21524(1)

29668(1)

29665(1)

884243(1)

460989(1)

46097(1)

30220(1)

39870(1)

 
Country of Origin

US(77)

CA(9)

AR(5)

MX(3)

DE(3)

NL(2)

TR(1)

BR(1)

CO(1)

GB(1)

 
Capacity (Volume)

300 ct(1)

 
Capacity (Weight)

2 lbs(11)

1.76 oz(5)

41 oz(4)

4.5 lbs(3)

6.25 oz(3)

32 oz(3)

30 oz(3)

2.4 oz(3)

5 lbs(3)

10 lbs(2)

0.35 oz(2)

9 oz(2)

56 oz(2)

19.2 oz(2)

1.32 oz(2)

3.4 oz(2)

2.5 oz(2)

42 oz(2)

46.5 oz(2)

14 oz(2)

5 oz(1)

2.75 lbs(1)

5.5 lbs(1)

3 oz(1)

54 oz(1)

30 lbs(1)

25 lbs(1)

51 oz(1)

0.9 oz(1)

20.4 oz(1)

1.7 oz(1)

0.6 oz(1)

57.5 oz(1)

.9 oz(1)

6.75 oz(1)

44 oz(1)

8.0 oz(1)

26 oz(1)

24 oz(1)

28 oz(1)

3.5 lbs(1)

23 oz(1)

0.186 oz(1)

12 oz(1)

3.08 lbs(1)

58 oz(1)

12.8 oz(1)

6 oz(1)

5.4 oz(1)

50 oz(1)

5.4oz(1)

70 oz(1)

 
Food Type

Candy(74)

Gum(9)

Cookies(4)

Nutrition Bar(3)

Cereal Bar(2)

Breakfast Biscuits(2)

Gummy Candy(2)

Breath Mint(2)

Breakfast Biscuit(1)

Licorice(1)

Fruit Snacks(1)

 
 
 

© 2020-2021 Onestop, Inc., All Rights Reserved