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

Nabisco(12)

Office Snax(10)

Kellogg's(6)

Keebler(6)

Sunshine(5)

Planters(5)

Paramount Farms(4)

Shultz(3)

Pop Weaver(3)

Austin(3)

Sahale Snacks®(3)

Chex Mix(3)

Pop Secret(3)

Pepperidge Farm(2)

Walkers(2)

General Mills(2)

Sensible Portions(2)

KIND(2)

Grandma's(2)

Pirate's Booty(1)

Utz(1)

popchips(1)

Stauffer's(1)

Snyder's(1)

De Beukelaer(1)

SkinnyPop Popcorn(1)

SunChips(1)

Rold Gold(1)

Fla-Vor-Ice(1)

Kettle Brand(1)

Knott's Berry Farm(1)

Frito-Lay(1)

Stacy's(1)

Dolcetto(1)

Nutella(1)

Biscoff(1)

Kar's(1)

Royal Dansk(1)

 
Packing Type

Bag(45)

Pack(24)

Box(11)

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)

Peanut Butter(4)

Roasted & Salted(4)

Chocolate(3)

Chocolate Chip(3)

Natural Almonds(2)

Extra Butter(2)

Butter(2)

Dry Roasted Almonds(2)

Cashews(2)

White Cheddar(2)

Original Marshmallow(2)

Cheddar Cheese(2)

Toast & Peanut Butter(2)

Sesame Snax Mix(1)

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

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

Berry Mix(1)

Vanilla Cream(1)

Pistachios(1)

Wasabi Party Mix(1)

Caramel(1)

Hazelnut/Cocoa(1)

Deluxe Nut 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)

Salted(1)

Assorted(1)

Cinnamon/Honey(1)

Honey Wheat(1)

Classic Fruit Nut(1)

Nut & Chocolate(1)

Tropical Fruit & Nut(1)

Mixed Nuts(1)

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

Cheese(1)

Cashew Pom Vanilla(1)

Barbeque; Sea Salt(1)

Hazelnut(1)

Honey Glazed Almond(1)

Danish Butter(1)

Regular(1)

Shortbread Fingers(1)

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

Aged White Cheddar(1)

Dry Roasted & Salted(1)

Light Butter(1)

Frosted Blueberry(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)

Brown Sugar Cinnamon(1)

Sweet 'N Salty Mix(1)

Mini Fudge Stripes(1)

Frosted Strawberry(1)

Pepper Jack Cheese(1)

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

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

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

Roasted & Salted Cashew Nuts(1)

Salty Sweet Mix(1)

Sea Salt and Pepper Cashews(1)

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

Reduced Fat(1)

Original Salty Cracker(1)

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

 
Manufacturer Part Number

00097(1)

00098(1)

00096(1)

00095(1)

00092(1)

00679(1)

105510(1)

3598(1)

375(1)

310(1)

105512(1)

105511(1)

00089(1)

00087(1)

52347(1)

52546(1)

45095(1)

32430(1)

14867(1)

67652(1)

456268(1)

00073(1)

00082(1)

80314(1)

827558(1)

04738(1)

53005(1)

6270(1)

884624(1)

06833(1)

07708(1)

01670(1)

00027(1)

06834(1)

011037(1)

827582(1)

827612(1)

900022(1)

900021(1)

900020(1)

00026(1)

21812PK(1)

042722C35S(1)

070146A25M(1)

042322F2OA(1)

W-536(1)

W-116(1)

072142WTV(1)

601049(1)

13539(1)

1051900(1)

05051(1)

00408(1)

25726(1)

25719(1)

16686(1)

27182(1)

12592(1)

30378(1)

30357(1)

28781(1)

33364(1)

54325(1)

80895(1)

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

84170(1)

84325(1)

31031(1)

31131(1)

26547(1)

21771(1)

21167(1)

31732(1)

51158(1)

827553(1)

827695(1)

827548(1)

827545(1)

827544(1)

21165(1)

21163(1)

94017(1)

92100(1)

93817(1)

93364(1)

93064(1)

01008(1)

10003(1)

17120(1)

12653(1)

122264(1)

10892(1)

SN08387(1)

 
Country of Origin

US(102)

ID(2)

IN(2)

GB(2)

DE(1)

 
Capacity (Volume)

1 oz(1)

1.5 oz(1)

 
Capacity (Weight)

1.5 oz(11)

2 oz(8)

1 oz(7)

5 oz(7)

1.8 oz(5)

2.5 oz(4)

1 1/2 oz(4)

1.38 oz(3)

0.7 oz(3)

32 oz(3)

1.75 oz(3)

5.5 oz(2)

1.25 oz(2)

3.67 oz(2)

0.63 oz(2)

4.5 oz(2)

24 oz(2)

44 oz(2)

1.4 oz(2)

1.2 oz(2)

0.8 oz(1)

14 oz(1)

38 oz(1)

22 oz(1)

15 oz(1)

26 oz(1)

1.44 oz(1)

2 1/4 oz(1)

12 oz(1)

0.9 oz(1)

2.17 oz(1)

40 oz(1)

1.75 oz; 1.5 oz(1)

34 oz(1)

3.52 oz(1)

1.76 oz(1)

4/5 oz(1)

0.81 oz(1)

2.4 oz(1)

1.7 oz(1)

3 oz(1)

3.75 oz(1)

3.2 oz(1)

0.56 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

48 oz(1)

1.3 oz(1)

0.2 oz(1)

.78 oz(1)

0.22 oz(1)

 
Food Type

Nuts(28)

Cookies(19)

Crackers(17)

Snack(9)

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 Legal Name, All Rights Reserved