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

Currently Filtered by

Category

Snacks

Refine Search

  GO
 
Brand

Emerald(15)

Nabisco(13)

Office Snax(10)

Kellogg's(8)

Sunshine(7)

Pop Secret(6)

Keebler(6)

Paramount Farms(6)

Sahale Snacks(5)

Austin(4)

Planters(4)

popchips(4)

Miss Vickie's(4)

Chex Mix(3)

Pop Weaver(3)

Pepperidge Farm(3)

Shultz(2)

Frito-Lay(2)

Stacy's(2)

Food Should Taste Good(2)

Kar's(2)

Cheetos(2)

Snyder's(2)

Sensible Portions(2)

Grandma's(2)

KIND(2)

General Mills(1)

Stauffer's(1)

Utz(1)

Pirate's Booty(1)

SkinnyPop Popcorn(1)

Walkers(1)

De Beukelaer(1)

Sqwincher(1)

Knott's Berry Farm(1)

Fritos(1)

Doritos(1)

Rold Gold(1)

Tostitos(1)

Pringles(1)

Annie's Homegrown(1)

Lay's(1)

Homefree(1)

Dolcetto(1)

Nutella(1)

Biscoff(1)

SunChips(1)

Royal Dansk(1)

 
Packing Type

Bag(64)

Pack(35)

Box(9)

Packs(5)

Tub(4)

Tube Package(3)

Canister(3)

Tin Container(2)

Pouch(2)

Bar(2)

Packets(2)

Jar(1)

Container(1)

Can(1)

Resealable Bag in Box(1)

Packet(1)

Single-Serve Bag(1)

Carton(1)

Single-Serve Tub(1)

 
Flavor

Original(16)

Roasted & Salted(5)

Peanut Butter(4)

Chocolate(3)

Chocolate Chip(3)

Sea Salt(3)

Homestyle(3)

All Natural Almonds(2)

Movie Theater Butter(2)

Cheddar Cheese(2)

Butter(2)

Dry Roasted Almonds(2)

Natural Almonds(2)

Cashews(2)

Assorted(2)

Original Marshmallow(2)

White Cheddar(2)

Cheese(2)

Toast & Peanut Butter(2)

Blueberry(2)

Sesame Snax Mix(1)

Pistachios(1)

Deluxe Nut Mix(1)

Berry Mix(1)

Barbecue(1)

Cinnamon/Honey(1)

6 Packs Ritz Bits Peanut Butter; 8 Packs Ritz Bits Cheese; 8 Packs Nutter Butter Bites; 9 Packs Mini Oreo; 9 Packs Chips Ahoy(1)

Parmesan Garlic & Herb(1)

Caramel(1)

BBQ; Cheddar & Sour Cream; Classic; Crunchy; Sour Cream & Onion(1)

Lays Classic;Doritos Nacho Cheese;Cheetos Original;Fritos Original; Lays BBQ;Doritos Cool Ranch(1)

Hazelnut/Cocoa(1)

Salted(1)

Harvest Cheddar; Original; French Onion; Garden Salsa(1)

Vanilla Cream(1)

Wasabi Party Mix(1)

Dry Roasted & Salted(1)

Mixed Nuts(1)

Nut & Chocolate(1)

Tropical Fruit & Nut(1)

Sour Cream & Onion(1)

Tangerine Vanilla(1)

Honey Glazed Almond(1)

Raspberry Crumble Cashew Trail Mix(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Shortbread Fingers(1)

Honey Wheat(1)

Danish Butter(1)

Extra Butter(1)

Smokehouse BBQ(1)

Salt & Pepper(1)

Baked Cheddar(1)

Hazelnut(1)

Aged White Cheddar(1)

Light Butter(1)

Choco Cremes, Vanilla Cremes, Lemon Ohs!, Cheese Crackers w/Cheese, Cheese Crackers w/Peanut Butter, Toasty Crackers w/Peanut Butter(1)

Deluxe Mixed Nuts(1)

Sriracha Cashews(1)

Salt & Pepper Cashews(1)

Apple Cinnamon(1)

Walnuts and Almonds(1)

Cocoa Roast Almonds(1)

Roasted & Salted Cashew Nuts(1)

Salty Sweet Mix(1)

Cocoa Roasted Almonds(1)

Oreo(1)

Original Fig(1)

Sweet 'N Spicy; Mango Pineapple; Yogurt Apple Nut(1)

Sweet Potato with Sea Salt(1)

Multigrain with Sea Salt(1)

Sweet 'N Salty Mix(1)

Chocolate Turtle(1)

Vanilla Crème(1)

Raspberry(1)

Traditional Mix(1)

Sea Salt and Pepper Cashews(1)

Traditional(1)

Cherry Cashew/Dark Chocolate; Dark Chocolate/Peanut Butter(1)

Zesty Ranch(1)

Cheddar(1)

Pepper Jack Cheese(1)

Almond & Sea Salt; Dark Chocolate Nuts; Sea Salt Caramel(1)

Chocolate Chip; Peanut Butter; Vanilla Crème; Oatmeal Raisin;Chocolate Brownie(1)

Jalapeno(1)

Nacho Cheese(1)

Crunchy(1)

Frosted Strawberry(1)

Brown Sugar Cinnamon(1)

Reduced Fat(1)

Original Salty Cracker(1)

Vanilla(1)

Original; Sour Cream & Onion; Cheddar Cheese(1)

Club & Cheddar Cheese(1)

Frosted Blueberry(1)

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

Sea Salt & Vinegar(1)

 
Manufacturer Part Number

00073(2)

00089(1)

00092(1)

00095(1)

00087(1)

00082(1)

1284253(1)

80314(1)

00096(1)

00098(1)

105512(1)

3598(1)

375(1)

105511(1)

105510(1)

04738(1)

00679(1)

00097(1)

456268(1)

44441(1)

44443(1)

44446(1)

44375(1)

44366(1)

32430(1)

44355(1)

44451(1)

44458(1)

67652(1)

92268(1)

52547(1)

52546(1)

45095(1)

52347(1)

53005(1)

6270(1)

06833(1)

06834(1)

011037(1)

07708(1)

01670(1)

00026(1)

00027(1)

900015(1)

900020(1)

827582(1)

159200201(1)

827612(1)

1011039(1)

900362(1)

900021(1)

900022(1)

77700(1)

72200(1)

070146A25M(1)

072142A25X(1)

072142WTV(1)

042722C35S(1)

042322F2OA(1)

W-116(1)

04474(1)

091842A25S(1)

601049(1)

827562(1)

21812PK(1)

71100(1)

13539(1)

1051900(1)

00408(1)

05051(1)

20871(1)

14672(1)

33364(1)

33664(1)

33725(1)

28781(1)

27182(1)

24680(1)

24696(1)

33825(1)

34325(1)

57706(1)

84170(1)

84325(1)

57690(1)

54325(1)

34325CT(1)

53664(1)

30378(1)

30357(1)

SN14848(1)

SN14858(1)

SN14868(1)

SN08387(1)

SN08361(1)

81233(1)

81237(1)

59636(1)

00176(1)

02908BX(1)

03744(1)

15923(1)

02908(1)

02104(1)

00470(1)

00798(1)

86364(1)

93064(1)

40975(1)

51158(1)

827544(1)

31732(1)

31131(1)

21771(1)

31031(1)

827545(1)

827548(1)

98067CT(1)

25719(1)

25726(1)

98067(1)

93646(1)

827553(1)

827695(1)

21167(1)

21165(1)

01866(1)

01008(1)

10003(1)

1160588(1)

94017(1)

93364(1)

93817(1)

10892(1)

12061(1)

18251(1)

21163(1)

17120(1)

12653(1)

122264(1)

12233(1)

14867(1)

 
Country of Origin

US(135)

IN(4)

ID(2)

GB(1)

DE(1)

 
Capacity (Volume)

1.375 oz(4)

3 oz(1)

1 oz(1)

1.75 oz(1)

 
Capacity (Weight)

1.5 oz(18)

2 oz(13)

5 oz(7)

1 oz(7)

1.8 oz(5)

2.5 oz(5)

3.2 oz(4)

1 1/2 oz(4)

1.75 oz(4)

0.8 oz(4)

32 oz(3)

1.25 oz(3)

0.7 oz(3)

0.63 oz(3)

1.38 oz(3)

3.67 oz(2)

5.5 oz(2)

3 oz(2)

24 oz(2)

3.25 oz(2)

44 oz(2)

1.76 oz(2)

0.62 oz(2)

1.2 oz(2)

50 oz(1)

38 oz(1)

2.17 oz(1)

34 oz(1)

0.9 oz(1)

15 oz(1)

12 oz(1)

1.44 oz(1)

1.4 oz(1)

14 oz(1)

58 oz(1)

26 oz(1)

1.0 oz(1)

1.02 oz(1)

3.52 oz(1)

8 oz(1)

0.56 oz(1)

1.1 oz(1)

2.4 oz(1)

1.7 oz(1)

8-1 3/4 oz; 16-1 1/2 oz(1)

4.5 oz(1)

3.75 oz(1)

0.2 oz(1)

.39 oz(1)

1.5 oz; 2 oz(1)

0.22 oz(1)

40 oz(1)

3.71 oz(1)

48 oz(1)

.78 oz(1)

0.74 oz(1)

22 oz(1)

 
Food Type

Nuts(34)

Cookies(24)

Crackers(21)

Chips(15)

Snack(11)

Popcorn(10)

Pretzels(6)

Potato Chips(4)

Pastry(3)

Trail Mix(2)

Snack Bar(2)

Dried Fruit(1)

Puffed Rice(1)

Snack Mix(1)

Potato Chip(1)

Rice Krispy Treat(1)

Breakfast Biscuits(1)

Cereal Bar(1)

Veggie Straw(1)

Apple Straw(1)

Snacks(1)

Nut Butter(1)

 
 
 

© 2019-2020 Horizon Business Products, All Rights Reserved