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

Emerald(15)

Office Snax(15)

Nabisco(15)

Kellogg's(9)

Sunshine(7)

Paramount Farms(6)

Chex Mix(6)

Keebler(6)

Pop Secret(6)

Planters(5)

Austin(4)

Walkers(4)

Annie's Homegrown(3)

Shultz(3)

Dolcetto(3)

Combos(3)

popchips(3)

Pop Weaver(3)

Sahale Snacks(3)

Pepperidge Farm(2)

Grandma's(2)

Sensible Portions(2)

General Mills(2)

Snyder's(2)

Kar's(2)

KIND(2)

De Beukelaer(1)

Stauffer's(1)

Utz(1)

SkinnyPop Popcorn(1)

Royal Dansk(1)

Pirate's Booty(1)

Frito-Lay(1)

Fla-Vor-Ice(1)

Rold Gold(1)

Kettle Brand(1)

Knott's Berry Farm(1)

Sheila G’s Brownie Brittle(1)

Cheetos(1)

Miss Vickie's(1)

Biscoff(1)

Lay's(1)

SunChips(1)

Stacy's(1)

Nutella(1)

 
Packing Type

Bag(66)

Pack(35)

Box(16)

Tub(8)

Packs(5)

Tube Package(3)

Tin Container(2)

Packets(2)

Canister(2)

Jar(1)

Container(1)

Single-Serve Bag(1)

Can(1)

Packet(1)

Tube(1)

Carton(1)

Bar(1)

Variety Pack(1)

Single-Serve Tub(1)

 
Flavor

Original(14)

Roasted & Salted(5)

Peanut Butter(5)

Chocolate Chip(5)

Chocolate(4)

Original Marshmallow(3)

Homestyle(3)

Sea Salt(3)

Dry Roasted Almonds(3)

Cashews(2)

All Natural Almonds(2)

Natural Almonds(2)

Butter(2)

Traditional(2)

White Cheddar(2)

Sourdough(2)

Salted(2)

Toast & Peanut Butter(2)

Cheddar(2)

Extra Butter(2)

Salt & Pepper(2)

Cheddar Cheese(2)

Blueberry(2)

Sesame Snax Mix(1)

Wasabi Party Mix(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Fruit & Nut Mix(1)

Berry Mix(1)

Mixed Nuts(1)

Pineapple & Papaya(1)

Cinnamon/Honey(1)

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

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

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

Caramel(1)

Assorted(1)

Hazelnut(1)

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

Tropical Fruit & Nut(1)

Aged White Cheddar(1)

Cheese(1)

Vanilla Cream(1)

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

Classic Fruit Nut(1)

Dry Roasted & Salted(1)

Cashew Pom Vanilla(1)

Shortbread Highlanders(1)

Shortbread Fingers(1)

Vanilla(1)

Honey Wheat(1)

Shortbread(1)

Deluxe Nut Mix(1)

Pistachios(1)

Light Butter(1)

Regular(1)

Danish Butter(1)

Nut & Chocolate(1)

Honey Glazed Almond(1)

Mini Fudge Stripes(1)

Original Fig(1)

Vanilla Crème(1)

Pepperoni Pizza Cracker(1)

Cheddar Cheese Cracker(1)

Oreo(1)

Apple Cinnamon(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

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

Cheddar Cheese Pretzel(1)

Raspberry(1)

Sweet 'N Salty Mix(1)

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

Snickerdoodle(1)

Chocolate Turtle(1)

Corn(1)

Chocolate/Peanut Butter(1)

Cheddar Mix(1)

Traditional Mix(1)

Movie Theater Butter(1)

Dark Chocolate Cocoa Roast Almonds(1)

Pepper Jack Cheese(1)

Frosted Strawberry(1)

Brown Sugar Cinnamon(1)

Frosted Blueberry(1)

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

Zesty Ranch(1)

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

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

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

Cocoa & Vanilla(1)

Cheese & Peanut Butter(1)

Roasted & Salted Cashew Nuts(1)

Salty Sweet Mix(1)

Cocoa Roasted Almonds(1)

Sea Salt and Pepper Cashews(1)

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

Club & Cheddar Cheese(1)

Reduced Fat(1)

Original Salty Cracker(1)

Crunchy(1)

 
Manufacturer Part Number

00073(2)

00091(1)

00092(1)

00093(1)

00089(1)

00084(1)

00082(1)

00083(1)

00095(1)

00087(1)

00096(1)

105510(1)

105511(1)

105512(1)

01570(1)

00679(1)

00097(1)

00098(1)

00080(1)

827558(1)

13256(1)

32430(1)

44366(1)

25726(1)

25719(1)

827695(1)

93646(1)

98067(1)

44443(1)

45095(1)

456268(1)

04738(1)

310(1)

6775505(1)

67652(1)

52347(1)

52546(1)

80314(1)

375(1)

01670(1)

07708(1)

884624(1)

00027(1)

00026(1)

21812PK(1)

71100(1)

72200(1)

06833(1)

06834(1)

1011039(1)

827582(1)

827612(1)

900330(1)

900328(1)

011037(1)

900327(1)

13539(1)

1051900(1)

W-116(1)

W1177D(1)

W-536(1)

656(1)

655(1)

827553(1)

53005(1)

6270(1)

042322F2OA(1)

042722C35S(1)

601049(1)

00408(1)

05051(1)

091842A25S(1)

072142WTV(1)

070146A25M(1)

072142A25X(1)

3598(1)

827548(1)

15923(1)

30357(1)

30378(1)

05344(1)

05343(1)

02908BX(1)

03744(1)

04068(1)

12592(1)

16686(1)

33364(1)

33664(1)

34325(1)

28781(1)

27182(1)

24680(1)

24696(1)

02908(1)

02104(1)

SN28086(1)

SN35181(1)

SN35182(1)

SN16794(1)

SN08387(1)

32021(1)

01224(1)

SN08361(1)

SN37301(1)

SN43037(1)

00176(1)

00470(1)

00798(1)

42008(1)

42007(1)

59636(1)

42005(1)

34325CT(1)

34895(1)

21165(1)

21167(1)

21771(1)

21163(1)

17120(1)

122264(1)

12233(1)

12653(1)

26547(1)

31031(1)

58399(1)

827544(1)

827545(1)

51158(1)

40975(1)

31131(1)

31732(1)

12061(1)

10892(1)

84170(1)

84325(1)

86364(1)

80895(1)

57706(1)

53664(1)

54325(1)

93064(1)

93364(1)

92100(1)

01008(1)

10003(1)

827565(1)

1160588(1)

93817(1)

94017(1)

00019(1)

 
Country of Origin

US(140)

ID(4)

GB(4)

IN(2)

DE(1)

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

2 oz(11)

5 oz(9)

1 oz(7)

6.3 oz(5)

2.5 oz(5)

1.8 oz(5)

0.63 oz(4)

1 1/2 oz(4)

3.2 oz(4)

1.75 oz(4)

32 oz(4)

40 oz(3)

0.7 oz(3)

1.4 oz(3)

0.8 oz(3)

1.25 oz(3)

1.38 oz(3)

1.76 oz(3)

38 oz(2)

48 oz(2)

44 oz(2)

3.67 oz(2)

6.75 oz(2)

24 oz(2)

1.2 oz(2)

5.5 oz(2)

3.75 oz(2)

4.5 oz(2)

34 oz(1)

6.2 oz(1)

26 oz(1)

0.9 oz(1)

50 oz(1)

2.17 oz(1)

1.0 oz(1)

22 oz(1)

1.44 oz(1)

14 oz(1)

15 oz(1)

1.75 oz; 1.5 oz(1)

2 1/4 oz(1)

12 oz(1)

3.52 oz(1)

0.81 oz(1)

8 oz(1)

0.56 oz(1)

4/5 oz(1)

2.4 oz(1)

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

3 oz(1)

1.7 oz(1)

0.2 oz(1)

.39 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

1.375 oz(1)

3.71 oz(1)

3.25 oz(1)

.78 oz(1)

1.3 oz(1)

1.06 oz(1)

0.22 oz(1)

 
Food Type

Nuts(34)

Cookies(27)

Crackers(21)

Snack(17)

Popcorn(10)

Pretzel(7)

Chips(6)

Cookie(4)

Pastry(3)

Pretzels(3)

Potato Chip(3)

Snack Bar(2)

Trail Mix(2)

Dried Fruit(2)

Snack Mix(1)

Puffed Rice(1)

Nut Butter(1)

Freezer Bar(1)

Breakfast Biscuits(1)

Cereal Bar(1)

Breakfast Biscuit(1)

Veggie Straw(1)

Rice Krispy Treat(1)

Apple Straw(1)

Snacks(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved