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

Currently Filtered by

Category

Snacks

Refine Search

  GO
 
Brand

Emerald(22)

Nabisco(19)

Office Snax(14)

Kellogg's(9)

Pop Secret(8)

Keebler(6)

Sunshine(6)

Paramount Farms(6)

Chex Mix(6)

Planters(6)

Miss Vickie's(4)

Walkers(4)

Austin(4)

Annie's Homegrown(3)

KIND(3)

popchips(3)

Shultz(3)

Homefree(3)

Pop Weaver(3)

Justin's(3)

Pepperidge Farm(3)

Sahale Snacks(3)

Dolcetto(3)

Fritos(2)

Stacy's(2)

Nutella(2)

Stauffer's(2)

Rold Gold(2)

Sensible Portions(2)

Combos(2)

General Mills(2)

Kar's(2)

Snyder's(2)

Grandma's(2)

Wyler's Italian Ices(2)

Jack Link's(2)

Utz(1)

Sqwincher(1)

Pirate's Booty(1)

De Beukelaer(1)

SkinnyPop Popcorn(1)

Royal Dansk(1)

Cheetos(1)

Fla-Vor-Ice(1)

Pringles(1)

Kettle Brand(1)

Knott's Berry Farm(1)

Sheila G’s Brownie Brittle(1)

Tostitos(1)

Doritos(1)

Lay's(1)

Biscoff(1)

SunChips(1)

Frito-Lay(1)

Ruffles(1)

Ocean Spray(1)

 
Recycled

No(2)

 
Packing Type

Bag(77)

Pack(45)

Box(17)

Tub(8)

Packs(5)

Canister(4)

Tube(4)

Bar(3)

Tube Package(3)

Packet(3)

Packets(2)

Tin Container(2)

Single-Serve Tub(2)

Squeeze Pack(2)

Jar(1)

Container(1)

Can(1)

Resealable Bag in Box(1)

Single-Serve Bag(1)

Variety Pack(1)

Carton(1)

 
Flavor

Original(20)

Chocolate Chip(7)

Peanut Butter(6)

Roasted & Salted(5)

Chocolate(5)

Homestyle(3)

Movie Theater Butter(3)

Original Marshmallow(3)

Sea Salt(3)

Dry Roasted Almonds(3)

Natural Almonds(2)

Butter(2)

Sriracha Cashews(2)

Dill Pickle Cashews(2)

Jalapeno Cashews(2)

Traditional(2)

Hazelnut/Cocoa(2)

Assorted(2)

Toast & Peanut Butter(2)

Regular(2)

White Cheddar(2)

Sourdough(2)

Cashews(2)

Kiwi Watermelon; Lemon; Orange Crème; Raspberry(2)

Salted(2)

Salt & Pepper(2)

All Natural Almonds(2)

Extra Butter(2)

Cheddar Cheese(2)

Blueberry(2)

Cheese(1)

Honey Glazed Almond(1)

Caramel(1)

Salted Peanuts; Honey Roasted Peanuts; Salted Cashews(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 Nuts(1)

Mixed Nuts(1)

Cinnamon/Honey(1)

Cranberry(1)

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

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

Smokehouse BBQ(1)

Sea Salt & Vinegar(1)

Jalapeno(1)

Nacho Cheese(1)

Classic Fruit Nut(1)

Vanilla Cream(1)

Nut & Chocolate(1)

Parmesan Garlic & Herb(1)

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

Cashew Pom Vanilla(1)

Wasabi Party Mix(1)

Crunchy(1)

Vanilla(1)

Honey Wheat(1)

Baked Cheddar(1)

Tiramisu(1)

Hazelnut(1)

Shortbread Fingers(1)

Dry Roasted & Salted(1)

Aged White Cheddar(1)

Danish Butter(1)

Light Butter(1)

Berry Mix(1)

Pineapple & Papaya(1)

Sesame Snax Mix(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Shortbread(1)

Deluxe Nut Mix(1)

Pistachios(1)

Tropical Fruit & Nut(1)

Club & Cheddar Cheese(1)

Oreo(1)

Apple Cinnamon(1)

Original Fig(1)

Golden Oat(1)

Vanilla Crème(1)

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

Salt & Pepper Cashews(1)

Cocoa Roasted Almonds(1)

Dark Chocolate Cocoa Roast Almonds(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Pepperoni Pizza Cracker(1)

Cheddar Cheese Cracker(1)

Sweet 'N Salty Mix(1)

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

Snickerdoodle(1)

Cheddar(1)

Chocolate Turtle(1)

Corn(1)

Raspberry(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

Traditional Mix(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(1)

Frosted Blueberry(1)

Brown Sugar Cinnamon(1)

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

Cocoa & Vanilla(1)

Frosted Strawberry(1)

Pepper Jack Cheese(1)

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

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

Dark Chocolate Cinnamon Pecan(1)

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

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

Original with M&Ms(1)

Teriyaki(1)

Double Chocolate Chip(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Sea Salt and Pepper Cashews(1)

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

Chocolate Almond/Hazelnut Butter(1)

Reduced Fat(1)

Original Salty Cracker(1)

Classic Almond Butter w/Pretzels(1)

Honey Peanut Butter(1)

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

 
Manufacturer Part Number

00073(2)

80314(1)

80401(1)

00080(1)

827558(1)

29516(1)

456268(1)

56628(1)

67652(1)

6775505(1)

00082(1)

04738(1)

00084(1)

00096(1)

00097(1)

00098(1)

00679(1)

00095(1)

00092(1)

56627(1)

00087(1)

00089(1)

00091(1)

00083(1)

52546(1)

25719(1)

25726(1)

13256(1)

20871(1)

17852(1)

98067(1)

827545(1)

827548(1)

827553(1)

827695(1)

32430(1)

44355(1)

44463(1)

45095(1)

52347(1)

01021(1)

44451(1)

44446(1)

44366(1)

44375(1)

44441(1)

44443(1)

52547(1)

01570(1)

00027(1)

01670(1)

07210(1)

07708(1)

00026(1)

72200(1)

13539(1)

827562(1)

21812PK(1)

71100(1)

884624(1)

06833(1)

1011039(1)

827582(1)

159200201(1)

827612(1)

900330(1)

900328(1)

06834(1)

011037(1)

11017(1)

900327(1)

1051900(1)

05051(1)

53005(1)

6270(1)

656(1)

657(1)

375(1)

3598(1)

105510(1)

105511(1)

105512(1)

310(1)

W-116(1)

W-536(1)

072142WTV(1)

091842A25S(1)

601049(1)

00408(1)

072142A25X(1)

070146A25M(1)

04474(1)

042322F2OA(1)

042722C35S(1)

827544(1)

51158(1)

12592(1)

16686(1)

24680(1)

24696(1)

30378(1)

30357(1)

05343(1)

05344(1)

07737(1)

15923(1)

27182(1)

28781(1)

33825(1)

34325(1)

34325CT(1)

34895(1)

33725(1)

33664(1)

28783(1)

33364(1)

33525(1)

33625(1)

05061(1)

04068(1)

SN35181(1)

SN35182(1)

SN37301(1)

SN43037(1)

SN28086(1)

SN16794(1)

32021(1)

01224(1)

SN08361(1)

SN08387(1)

59636(1)

42007(1)

02908(1)

02908BX(1)

02946(1)

03744(1)

02104(1)

00798(1)

42008(1)

00176(1)

00470(1)

53664(1)

54325(1)

12061(1)

122264(1)

12233(1)

12653(1)

10892(1)

10003(1)

00058(1)

00309(1)

10050(1)

01008(1)

13189(1)

17120(1)

31031(1)

31131(1)

31732(1)

40975(1)

26547(1)

21771(1)

18251(1)

21163(1)

21165(1)

21167(1)

94816BX(1)

94816(1)

93064(1)

93364(1)

93817(1)

93917(1)

86364(1)

84325(1)

57690(1)

57706(1)

80895(1)

84170(1)

94017(1)

94117(1)

01948(1)

87631(1)

87635(1)

92100(1)

01873(1)

01305(1)

94217(1)

1160588(1)

827565(1)

00019(1)

 
Country of Origin

US(168)

IN(9)

GB(4)

ID(4)

United States(2)

DE(1)

CA(1)

TH(1)

 
Weight (Approximate)

2.85 oz(2)

 
Capacity (Volume)

1.375 oz(4)

2 oz(2)

1.75 oz(2)

3 oz(1)

1 oz(1)

1.375oz(1)

1.5 oz(1)

 
Capacity (Weight)

1.5 oz(15)

2 oz(12)

5 oz(9)

1 oz(8)

1.25 oz(6)

1.75 oz(6)

3.2 oz(5)

1.8 oz(5)

2.5 oz(5)

1.76 oz(4)

0.62 oz(4)

1 1/2 oz(4)

6.3 oz(4)

0.63 oz(4)

0.7 oz(3)

40 oz(3)

0.8 oz(3)

32 oz(3)

1.4 oz(3)

1.38 oz(3)

5.5 oz(2)

48 oz(2)

3.67 oz(2)

6.75 oz(2)

3 oz(2)

1.3 oz(2)

24 oz(2)

38 oz(2)

3.75 oz(2)

44 oz(2)

4 oz(2)

4.5 oz(2)

1.15 oz(2)

8 oz(2)

1.2 oz(2)

2 1/4 oz(1)

2.4 oz(1)

2.17 oz(1)

4.9 oz(1)

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

34 oz(1)

12 oz(1)

6.2 oz(1)

1.44 oz(1)

16 oz(1)

1.75 oz; 1.5 oz(1)

50 oz(1)

0.9 oz(1)

15 oz(1)

1.7 oz(1)

1.0 oz(1)

14 oz(1)

58 oz(1)

1.02 oz(1)

22 oz(1)

0.95 oz(1)

1.1 oz(1)

3.52 oz(1)

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

0.74 oz(1)

.78 oz(1)

0.2 oz(1)

.39 oz(1)

2.1 oz(1)

4/5 oz(1)

3.9 oz(1)

0.22 oz(1)

2.32 oz(1)

0.81 oz(1)

1.375 oz(1)

0.56 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

26 oz(1)

 
Serving

Bag(1)

 
Product Type

Beef Snack(2)

 
Packaged Quantity

8 / Bag(1)

1 Bag(1)

 
Assembly Required

No(2)

 
Food Type

Nuts(41)

Cookies(32)

Snack(21)

Crackers(20)

Chips(14)

Popcorn(12)

Pretzel(7)

Cookie(6)

Nut Butter(4)

Potato Chip(3)

Pretzels(3)

Snack Bar(3)

Pastry(3)

Dried Fruit(3)

Freezer Bar(3)

Cereal Bar(2)

Trail Mix(2)

Puffed Rice(1)

Snack Mix(1)

Breakfast Biscuits(1)

Breakfast Biscuit(1)

Rice Krispy Treat(1)

Apple Straw(1)

Snacks(1)

Veggie Straw(1)

Potato Chips(1)

 
Container Type

Carton(1)

 
 
 

© 2018-2019 Office Solutions & Innovations, Inc., All Rights Reserved