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

Office Snax(15)

Nabisco(13)

Emerald(13)

Kellogg's(7)

Keebler(6)

Planters(5)

Sunshine(5)

Chex Mix(4)

Paramount Farms(4)

Austin(3)

Sahale Snacks(3)

KIND(3)

Walkers(3)

Dolcetto(3)

Pop Secret(3)

Pop Weaver(3)

Pepperidge Farm(2)

Grandma's(2)

General Mills(2)

Sensible Portions(2)

Snyder's(1)

Stauffer's(1)

Utz(1)

Pirate's Booty(1)

De Beukelaer(1)

SkinnyPop Popcorn(1)

popchips(1)

Stacy's(1)

Fla-Vor-Ice(1)

Kettle Brand(1)

Knott's Berry Farm(1)

Kar's(1)

Rold Gold(1)

Frito-Lay(1)

Nutella(1)

Biscoff(1)

SunChips(1)

Sheila G’s Brownie Brittle(1)

Royal Dansk(1)

 
Packing Type

Bag(50)

Pack(26)

Box(15)

Packs(5)

Tub(5)

Tube Package(3)

Tin Container(2)

Canister(1)

Jar(1)

Container(1)

Single-Serve Bag(1)

Can(1)

Bar(1)

Packets(1)

Tube(1)

Carton(1)

Packet(1)

Single-Serve Tub(1)

 
Flavor

Original(11)

Chocolate(4)

Chocolate Chip(4)

Roasted & Salted(4)

Dry Roasted Almonds(3)

Peanut Butter(3)

Toast & Peanut Butter(2)

Sourdough(2)

Extra Butter(2)

Butter(2)

Natural Almonds(2)

Salted(2)

Cashews(2)

White Cheddar(2)

Sea Salt(2)

Cheddar Cheese(2)

Sesame Snax Mix(1)

Vanilla Cream(1)

Pineapple & Papaya(1)

Happy Heart Mix(1)

Berry Mix(1)

Wasabi Party Mix(1)

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

Hazelnut/Cocoa(1)

Cinnamon/Honey(1)

6 Packs Ritz Bits Peanut Butter; 6 Packs Ritz Bits Cheese; 7 Packs Nutter Butter Bites; 7 Packs Mini Nilla Wafers; 7 Packs Mini Oreo; 7 Packs Chips Ahoy(1)

Assorted(1)

Caramel(1)

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

Shortbread Fingers(1)

Mixed Nuts(1)

Nut & Chocolate(1)

Tropical Fruit & Nut(1)

Salted Peanuts; Honey Roasted Peanuts; Salted Cashews(1)

Cheese(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Barbeque; Sea Salt(1)

Hazelnut(1)

Danish Butter(1)

Light Butter(1)

Deluxe Nut Mix(1)

Vanilla(1)

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

Aged White Cheddar(1)

Dry Roasted & Salted(1)

Shortbread Highlanders(1)

Pistachios(1)

Frosted Strawberry(1)

Salt & Vinegar; Salt & Pepper; Backyard Barbeque; Jalapeno(1)

Apple Cinnamon(1)

Devil's Food(1)

Homestyle(1)

All Natural Almonds(1)

Salt & Pepper(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Original Fig(1)

Blueberry(1)

Corn(1)

Chocolate Turtle(1)

Sweet 'N Salty Mix(1)

Cheddar Mix(1)

Chocolate/Peanut Butter(1)

Vanilla Crème(1)

Raspberry(1)

Dark Chocolate Cocoa Roast Almonds(1)

Salty Sweet Mix(1)

Brown Sugar Cinnamon(1)

Frosted Blueberry(1)

Original Marshmallow(1)

Pepper Jack Cheese(1)

Cheddar(1)

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

Almond/Cranberry; Honey Roasted Nuts & Salt(1)

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

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

Traditional(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

Berry Punch; Grape; Lemon-Lime; Orange; Strawberry; Tropical Punch(1)

Original Salty Cracker(1)

Club & Cheddar Cheese(1)

Reduced Fat(1)

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

 
Manufacturer Part Number

00092(1)

00093(1)

00091(1)

00089(1)

00084(1)

00087(1)

00095(1)

00096(1)

105511(1)

105512(1)

105510(1)

00679(1)

00097(1)

00098(1)

00083(1)

00082(1)

52347(1)

52546(1)

45095(1)

32430(1)

25726(1)

13256(1)

67652(1)

456268(1)

00073(1)

00080(1)

80314(1)

827558(1)

04738(1)

375(1)

53005(1)

884624(1)

06833(1)

07708(1)

01670(1)

00026(1)

00027(1)

06834(1)

011037(1)

827582(1)

827612(1)

900330(1)

900328(1)

900327(1)

21812PK(1)

13539(1)

W-536(1)

042322F2OA(1)

W-176(1)

W-116(1)

655(1)

656(1)

042722C35S(1)

070146A25M(1)

05051(1)

1051900(1)

00408(1)

601049(1)

072142WTV(1)

25719(1)

25712(1)

16686(1)

27182(1)

12592(1)

30378(1)

05344(1)

30357(1)

28781(1)

33364(1)

53664(1)

54325(1)

34895(1)

34325(1)

33664(1)

05343(1)

04754(1)

SN37301(1)

SN43037(1)

SN35182(1)

SN28086(1)

SN08387(1)

SN16794(1)

59636(1)

00176(1)

02908BX(1)

03744(1)

02104(1)

00798(1)

00470(1)

80895(1)

84170(1)

31732(1)

51158(1)

31131(1)

31031(1)

21771(1)

26547(1)

58399(1)

58402(1)

827553(1)

827695(1)

827548(1)

827545(1)

827544(1)

21167(1)

21165(1)

94017(1)

827565(1)

93817(1)

93364(1)

84325(1)

93064(1)

92100(1)

01008(1)

12653(1)

21163(1)

122264(1)

10892(1)

10003(1)

01224(1)

 
Country of Origin

US(109)

ID(4)

GB(3)

IN(2)

DE(1)

TH(1)

 
Capacity (Volume)

1 oz(1)

1.5 oz(1)

1.75 oz(1)

 
Capacity (Weight)

1.5 oz(11)

5 oz(8)

2 oz(8)

1 oz(7)

1.8 oz(5)

1.75 oz(4)

0.7 oz(4)

2.5 oz(4)

32 oz(4)

40 oz(3)

0.63 oz(3)

1.4 oz(3)

1.38 oz(3)

1 1/2 oz(3)

38 oz(2)

24 oz(2)

3.67 oz(2)

48 oz(2)

1.25 oz(2)

1.06 oz(2)

1.2 oz(2)

6.3 oz(2)

5.5 oz(2)

4.5 oz(2)

44 oz(2)

0.9 oz(1)

22 oz(1)

1.75 oz; 1.5 oz(1)

26 oz(1)

0.8 oz(1)

34 oz(1)

12 oz(1)

14 oz(1)

2.17 oz(1)

15 oz(1)

3.52 oz(1)

1.76 oz(1)

6.75 oz(1)

4/5 oz(1)

2.4 oz(1)

1.7 oz(1)

3 oz(1)

3.75 oz(1)

0.81 oz(1)

3.2 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

3.71 oz(1)

1.3 oz(1)

0.56 oz(1)

0.2 oz(1)

0.22 oz(1)

 
Food Type

Nuts(30)

Cookies(23)

Crackers(19)

Snack(10)

Popcorn(7)

Pretzel(6)

Snack Bar(3)

Pastry(3)

Cookie(3)

Chips(3)

Dried Fruit(2)

Trail Mix(2)

Puffed Rice(1)

Snack Mix(1)

Potato Chip(1)

Freezer Bar(1)

Breakfast Biscuits(1)

Veggie Straw(1)

Apple Straw(1)

Snacks(1)

Nut Butter(1)

 
 
 

© 2018-2019 Gateway Business Products, All Rights Reserved