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 ('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

Nabisco(17)

Emerald(14)

Office Snax(10)

Kellogg's(8)

Pop Secret(7)

Paramount Farms(6)

Keebler(6)

Sunshine(6)

Chex Mix(6)

Planters(5)

Austin(4)

popchips(3)

Shultz(3)

Pop Weaver(3)

Pepperidge Farm(3)

Walkers(3)

Homefree(3)

Annie's Homegrown(2)

Dolcetto(2)

Stacy's(2)

Grandma's(2)

Kar's(2)

General Mills(2)

Snyder's(2)

Sensible Portions(2)

KIND(2)

Royal Dansk(1)

SkinnyPop Popcorn(1)

Stauffer's(1)

Pirate's Booty(1)

Utz(1)

De Beukelaer(1)

Cheetos(1)

Pringles(1)

Tostitos(1)

Fla-Vor-Ice(1)

Kettle Brand(1)

Sheila G’s Brownie Brittle(1)

Knott's Berry Farm(1)

Rold Gold(1)

Fritos(1)

Lay's(1)

Biscoff(1)

SunChips(1)

Frito-Lay(1)

Doritos(1)

Miss Vickie's(1)

Nutella(1)

 
Packing Type

Bag(65)

Pack(37)

Box(14)

Tub(5)

Packs(5)

Canister(3)

Tube Package(3)

Tin Container(2)

Packets(2)

Resealable Bag in Box(1)

Jar(1)

Container(1)

Single-Serve Bag(1)

Can(1)

Bar(1)

Tube(1)

Carton(1)

Packet(1)

Variety Pack(1)

Single-Serve Tub(1)

 
Flavor

Original(16)

Chocolate Chip(7)

Peanut Butter(6)

Roasted & Salted(5)

Homestyle(3)

Original Marshmallow(3)

Sea Salt(3)

Dry Roasted Almonds(3)

Chocolate(3)

Blueberry(2)

Cashews(2)

Extra Butter(2)

Butter(2)

Natural Almonds(2)

Toast & Peanut Butter(2)

Traditional(2)

Cheddar Cheese(2)

Salt & Pepper(2)

White Cheddar(2)

Movie Theater Butter(2)

Berry Mix(1)

Sesame Snax Mix(1)

Salted(1)

Cinnamon/Honey(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)

Nacho Cheese(1)

Crunchy(1)

Parmesan Garlic & Herb(1)

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

Assorted(1)

Caramel(1)

Jalapeno; Salt & Vinegar; Original; Applewood BBQ; Salt & Pepper(1)

Hazelnut/Cocoa(1)

Danish Butter(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Hazelnut(1)

Tropical Fruit & Nut(1)

Nut & Chocolate(1)

Cheese(1)

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

Mixed Nuts(1)

Aged White Cheddar(1)

Dry Roasted & Salted(1)

Light Butter(1)

Shortbread(1)

Deluxe Nut Mix(1)

Regular(1)

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

Shortbread Fingers(1)

Vanilla(1)

Honey Wheat(1)

Pistachios(1)

Cheese & Peanut Butter(1)

Apple Cinnamon(1)

Oreo(1)

Original Fig(1)

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

All Natural Almonds(1)

Cocoa Roast Almonds(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Vanilla Crème(1)

Raspberry(1)

Sweet 'N Salty Mix(1)

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

Cheddar(1)

Chocolate Turtle(1)

Corn(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

Traditional Mix(1)

Cocoa Roasted Almonds(1)

Salty Sweet Mix(1)

Frosted Blueberry(1)

Mini Fudge Stripes(1)

Cocoa & Vanilla(1)

Brown Sugar Cinnamon(1)

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

Pepper Jack Cheese(1)

Club & Cheddar Cheese(1)

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

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

Double Chocolate Chip(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

00073(2)

80314(1)

00082(1)

00087(1)

827558(1)

456268(1)

67652(1)

6775505(1)

00089(1)

04738(1)

00092(1)

00679(1)

01570(1)

105510(1)

00098(1)

00097(1)

00095(1)

00096(1)

52547(1)

52546(1)

98067(1)

25719(1)

25726(1)

827695(1)

827553(1)

827545(1)

827548(1)

14867(1)

20871(1)

44443(1)

45095(1)

52347(1)

44375(1)

44366(1)

32430(1)

44355(1)

105511(1)

105512(1)

72200(1)

00026(1)

00027(1)

71100(1)

21812PK(1)

13539(1)

827562(1)

01670(1)

07708(1)

1011039(1)

827582(1)

827612(1)

011037(1)

06834(1)

884624(1)

06833(1)

1051900(1)

05051(1)

6270(1)

656(1)

W-116(1)

53005(1)

375(1)

310(1)

3598(1)

W-536(1)

042322F2OA(1)

091842A25S(1)

601049(1)

00408(1)

072142WTV(1)

072142A25X(1)

042722C35S(1)

070146A25M(1)

827544(1)

40975(1)

30357(1)

30378(1)

12592(1)

52220(1)

15923(1)

05343(1)

05344(1)

07737(1)

16686(1)

24680(1)

33664(1)

34325(1)

34895(1)

33364(1)

28781(1)

24696(1)

27182(1)

04068(1)

03744(1)

SN28086(1)

SN35181(1)

SN35182(1)

SN16794(1)

SN08387(1)

01224(1)

SN08361(1)

SN37301(1)

SN43037(1)

02104(1)

02908(1)

02908BX(1)

00798(1)

00470(1)

59636(1)

00176(1)

53664(1)

54325(1)

12653(1)

17120(1)

18251(1)

12233(1)

122264(1)

10892(1)

12061(1)

21163(1)

21165(1)

31131(1)

31732(1)

00019(1)

31031(1)

26547(1)

21167(1)

21771(1)

10003(1)

01008(1)

84325(1)

86364(1)

93064(1)

84170(1)

80895(1)

57690(1)

57706(1)

93364(1)

93817(1)

01873(1)

01948(1)

92100(1)

01305(1)

827565(1)

94017(1)

1160588(1)

51158(1)

 
Country of Origin

US(138)

GB(3)

ID(3)

IN(2)

DE(1)

 
Capacity (Volume)

1.75 oz(2)

1 oz(1)

1.375oz(1)

1.375 oz(1)

1.5 oz(1)

 
Capacity (Weight)

1.5 oz(13)

2 oz(12)

5 oz(9)

1 oz(7)

3.2 oz(5)

1.75 oz(5)

1.8 oz(5)

2.5 oz(5)

1.4 oz(3)

0.63 oz(3)

1.25 oz(3)

0.7 oz(3)

1.76 oz(3)

0.8 oz(3)

1.38 oz(3)

32 oz(3)

3.67 oz(2)

24 oz(2)

5.5 oz(2)

1.2 oz(2)

3 oz(2)

8 oz(2)

3.75 oz(2)

4.5 oz(2)

44 oz(2)

2.17 oz(1)

6.2 oz(1)

22 oz(1)

38 oz(1)

2 1/4 oz(1)

26 oz(1)

34 oz(1)

14 oz(1)

15 oz(1)

1.75 oz; 1.5 oz(1)

50 oz(1)

0.9 oz(1)

58 oz(1)

40 oz(1)

12 oz(1)

1.44 oz(1)

6.3 oz(1)

1.0 oz(1)

1 1/2 oz(1)

48 oz(1)

0.56 oz(1)

2 lb. Net Weight; 10/1.1 oz, 10/0.95 oz, 10/1.1 oz(1)

1.1 oz(1)

0.95 oz(1)

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

0.81 oz(1)

1.7 oz(1)

2.4 oz(1)

4/5 oz(1)

0.2 oz(1)

.39 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

1.375 oz(1)

3.52 oz(1)

1.3 oz(1)

.78 oz(1)

0.74 oz(1)

6.75 oz(1)

0.22 oz(1)

 
Food Type

Cookies(29)

Nuts(29)

Crackers(20)

Snack(14)

Popcorn(11)

Chips(10)

Cookie(4)

Pretzel(4)

Pastry(3)

Pretzels(3)

Potato Chip(3)

Snack Bar(2)

Trail Mix(2)

Snack Mix(1)

Dried Fruit(1)

Puffed Rice(1)

Nut Butter(1)

Freezer Bar(1)

Breakfast Biscuit(1)

Breakfast Biscuits(1)

Cereal Bar(1)

Veggie Straw(1)

Apple Straw(1)

Potato Chips(1)

Rice Krispy Treat(1)

Snacks(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved