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

Nabisco(12)

Office Snax(10)

Kellogg's(6)

Keebler(6)

Planters(5)

Sunshine(5)

Chex Mix(4)

Paramount Farms(4)

Pop Weaver(3)

Shultz(3)

Austin(3)

Pop Secret(3)

Pepperidge Farm(2)

Sensible Portions(2)

Dolcetto(2)

Walkers(2)

General Mills(2)

KIND(2)

Grandma's(2)

Utz(1)

Snyder's(1)

De Beukelaer(1)

popchips(1)

Stauffer's(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Stacy's(1)

Rold Gold(1)

Fla-Vor-Ice(1)

Kettle Brand(1)

Knott's Berry Farm(1)

Frito-Lay(1)

Kar's(1)

Nutella(1)

Biscoff(1)

SunChips(1)

Royal Dansk(1)

 
Packing Type

Bag(45)

Pack(26)

Box(12)

Tub(5)

Packs(5)

Tube Package(3)

Tin Container(2)

Canister(1)

Can(1)

Container(1)

Jar(1)

Single-Serve Bag(1)

Single-Serve Tub(1)

Tube(1)

Carton(1)

Bar(1)

Packets(1)

Packet(1)

 
Flavor

Original(11)

Roasted & Salted(4)

Peanut Butter(4)

Dry Roasted Almonds(3)

Chocolate Chip(3)

Chocolate(3)

Natural Almonds(2)

Cashews(2)

Extra Butter(2)

Butter(2)

White Cheddar(2)

Toast & Peanut Butter(2)

Original Marshmallow(2)

Cheddar Cheese(2)

Cinnamon/Honey(1)

Sesame Snax Mix(1)

Salted(1)

Wasabi Party Mix(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)

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

Vanilla Cream(1)

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

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

Caramel(1)

Berry Mix(1)

Assorted(1)

Hazelnut/Cocoa(1)

Honey Wheat(1)

Tropical Fruit & Nut(1)

Barbeque; Sea Salt(1)

Hazelnut(1)

Nut & Chocolate(1)

Mixed Nuts(1)

Cheese(1)

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

Aged White Cheddar(1)

Dry Roasted & Salted(1)

Regular(1)

Light Butter(1)

Deluxe Nut Mix(1)

Danish Butter(1)

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

Shortbread Fingers(1)

Vanilla(1)

Pistachios(1)

Mini Fudge Stripes(1)

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

Apple Cinnamon(1)

Sea Salt(1)

Homestyle(1)

All Natural Almonds(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Original Fig(1)

Blueberry(1)

Corn(1)

Chocolate Turtle(1)

Cheddar Mix(1)

Chocolate/Peanut Butter(1)

Vanilla Crème(1)

Raspberry(1)

Salt & Pepper(1)

Cocoa Roast Almonds(1)

Frosted Blueberry(1)

Sweet 'N Salty Mix(1)

Cheese & Peanut Butter(1)

Brown Sugar Cinnamon(1)

Frosted Strawberry(1)

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

Pepper Jack Cheese(1)

Club & Cheddar Cheese(1)

Reduced Fat(1)

Roasted & Salted Cashew Nuts(1)

Salty Sweet Mix(1)

Sea Salt and Pepper Cashews(1)

Traditional(1)

Original Salty Cracker(1)

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

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

 
Manufacturer Part Number

00095(1)

00096(1)

00092(1)

00089(1)

00087(1)

00097(1)

00098(1)

105512(1)

310(1)

105511(1)

105510(1)

00679(1)

00082(1)

00073(1)

32430(1)

45095(1)

14867(1)

25726(1)

25719(1)

52347(1)

52546(1)

827558(1)

80314(1)

04738(1)

456268(1)

67652(1)

3598(1)

375(1)

00027(1)

01670(1)

00026(1)

21812PK(1)

13539(1)

07708(1)

884624(1)

827582(1)

827612(1)

011037(1)

06834(1)

06833(1)

1051900(1)

05051(1)

W-116(1)

W-536(1)

656(1)

6270(1)

53005(1)

042322F2OA(1)

042722C35S(1)

00408(1)

601049(1)

072142WTV(1)

070146A25M(1)

827695(1)

827553(1)

16686(1)

27182(1)

12592(1)

30378(1)

30357(1)

28781(1)

33364(1)

53664(1)

54325(1)

34895(1)

34325(1)

33664(1)

05344(1)

05343(1)

SN37301(1)

SN43037(1)

SN35182(1)

SN28086(1)

SN16794(1)

59636(1)

00176(1)

02908BX(1)

03744(1)

02104(1)

00798(1)

00470(1)

80895(1)

84170(1)

21771(1)

26547(1)

21167(1)

21165(1)

21163(1)

31031(1)

31131(1)

827545(1)

827548(1)

827544(1)

51158(1)

31732(1)

17120(1)

12653(1)

93817(1)

94017(1)

93364(1)

93064(1)

84325(1)

827565(1)

92100(1)

122264(1)

10892(1)

10003(1)

01008(1)

SN08387(1)

 
Country of Origin

US(101)

ID(3)

IN(2)

GB(2)

DE(1)

 
Capacity (Volume)

1 oz(1)

1.5 oz(1)

1.75 oz(1)

 
Capacity (Weight)

1.5 oz(11)

2 oz(8)

1 oz(7)

5 oz(7)

1.8 oz(5)

1.75 oz(4)

2.5 oz(4)

32 oz(3)

0.63 oz(3)

0.7 oz(3)

1.38 oz(3)

5.5 oz(2)

1.25 oz(2)

44 oz(2)

1.4 oz(2)

4.5 oz(2)

24 oz(2)

1.2 oz(2)

3.67 oz(2)

38 oz(1)

2.17 oz(1)

34 oz(1)

26 oz(1)

12 oz(1)

6.3 oz(1)

14 oz(1)

0.8 oz(1)

15 oz(1)

1.75 oz; 1.5 oz(1)

0.9 oz(1)

1 1/2 oz(1)

22 oz(1)

1.44 oz(1)

2 1/4 oz(1)

48 oz(1)

4/5 oz(1)

0.81 oz(1)

3.2 oz(1)

1.76 oz(1)

2.4 oz(1)

3 oz(1)

3.75 oz(1)

1.7 oz(1)

0.56 oz(1)

0.2 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

0.22 oz(1)

3.71 oz(1)

3.52 oz(1)

.78 oz(1)

1.3 oz(1)

40 oz(1)

 
Food Type

Nuts(26)

Cookies(20)

Crackers(17)

Snack(10)

Popcorn(7)

Pretzels(3)

Pastry(3)

Chips(3)

Pretzel(3)

Snack Bar(2)

Cookie(2)

Trail Mix(2)

Dried Fruit(1)

Potato Chip(1)

Puffed Rice(1)

Snack Mix(1)

Rice Krispy Treat(1)

Veggie Straw(1)

Breakfast Biscuits(1)

Apple Straw(1)

Freezer Bar(1)

Snacks(1)

Nut Butter(1)

 
 
 

© 2018-2019 Gateway Business Products, All Rights Reserved