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

Office Snax(15)

Nabisco(13)

Emerald(13)

Kellogg's(7)

Keebler(6)

Planters(5)

Sunshine(5)

Paramount Farms(4)

Chex Mix(4)

KIND(3)

Austin(3)

Dolcetto(3)

Pop Secret(3)

Walkers(3)

Pop Weaver(3)

Sahale Snacks(3)

Pepperidge Farm(2)

Grandma's(2)

General Mills(2)

Sensible Portions(2)

Utz(1)

Stauffer's(1)

Snyder's(1)

Pirate's Booty(1)

Royal Dansk(1)

De Beukelaer(1)

SkinnyPop Popcorn(1)

popchips(1)

Stacy's(1)

Fla-Vor-Ice(1)

Kellogg's®(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)

Shultz(1)

 
Packing Type

Bag(50)

Pack(27)

Box(15)

Tub(6)

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

Roasted & Salted(4)

Chocolate Chip(4)

Peanut Butter(3)

Dry Roasted Almonds(3)

Salted(2)

Toast & Peanut Butter(2)

Extra Butter(2)

Butter(2)

Original Marshmallow(2)

Natural Almonds(2)

Cashews(2)

White Cheddar(2)

Sea Salt(2)

Cheddar Cheese(2)

Sourdough(2)

Pineapple & Papaya(1)

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

Happy Heart Mix(1)

Pistachios(1)

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

Berry Mix(1)

Caramel(1)

Hazelnut/Cocoa(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)

Assorted(1)

Sesame Snax Mix(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)

Regular(1)

Light Butter(1)

Vanilla(1)

Vanilla Cream(1)

Aged White Cheddar(1)

Dry Roasted & Salted(1)

Shortbread Highlanders(1)

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

Pepper Jack Cheese(1)

Brown Sugar Cinnamon(1)

Frosted Blueberry(1)

Cheddar(1)

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

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

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

Almond/Cranberry; Honey Roasted Nuts & Salt(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)

Chocolate Chip; Peanut Butter; Vanilla Crème; Oatmeal Raisin;Chocolate Brownie(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)

310(1)

375(1)

07708(1)

884624(1)

01670(1)

00027(1)

21812PK(1)

00026(1)

06833(1)

06834(1)

827582(1)

827612(1)

900330(1)

900328(1)

011037(1)

900327(1)

13539(1)

1051900(1)

W-176(1)

W-536(1)

W-116(1)

656(1)

53005(1)

655(1)

042322F2OA(1)

042722C35S(1)

00408(1)

05051(1)

601049(1)

072142WTV(1)

070146A25M(1)

25719(1)

25712(1)

16686(1)

27182(1)

12592(1)

30378(1)

05344(1)

30357(1)

28781(1)

33364(1)

54325(1)

80895(1)

53664(1)

34895(1)

33664(1)

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

84170(1)

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

827565(1)

92100(1)

94017(1)

93817(1)

93064(1)

93364(1)

01008(1)

10003(1)

17120(1)

21163(1)

12653(1)

122264(1)

10892(1)

01224(1)

 
Country of Origin

US(111)

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)

5.5 oz(2)

6.3 oz(2)

44 oz(2)

4.5 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)

2.17 oz(1)

12 oz(1)

14 oz(1)

2 1/4 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)

3.71 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

1.3 oz(1)

.78 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)

Potato Chip(1)

Pretzels(1)

Snack Mix(1)

Puffed Rice(1)

Rice Krispy Treat(1)

Veggie Straw(1)

Breakfast Biscuits(1)

Apple Straw(1)

Freezer Bar(1)

Snacks(1)

Nut Butter(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved