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

Nabisco(15)

Office Snax(10)

Kellogg's(8)

Pop Secret(8)

Keebler(6)

Sunshine(6)

Paramount Farms(6)

Sahale Snacks(5)

Planters(5)

Austin(4)

Chex Mix(4)

popchips(3)

Walkers(3)

Pop Weaver(3)

Pepperidge Farm(3)

Kar's(2)

Stacy's(2)

Food Should Taste Good(2)

Shultz(2)

Snyder's(2)

KIND(2)

Frito-Lay(2)

Grandma's(2)

Sensible Portions(2)

Stauffer's(1)

De Beukelaer(1)

Utz(1)

Royal Dansk(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Doritos(1)

Pringles(1)

Tostitos(1)

Kettle Brand(1)

Knott's Berry Farm(1)

General Mills(1)

Rold Gold(1)

Fritos(1)

Biscoff(1)

Nutella(1)

SunChips(1)

Annie's Homegrown(1)

Cheetos(1)

Dolcetto(1)

 
Packing Type

Bag(60)

Pack(36)

Box(11)

Packs(5)

Tub(4)

Tube Package(3)

Bar(3)

Canister(3)

Pouch(2)

Packets(2)

Tin Container(2)

Can(1)

Jar(1)

Resealable Bag in Box(1)

Container(1)

Single-Serve Tub(1)

Tube(1)

Carton(1)

Packet(1)

Single-Serve Bag(1)

 
Flavor

Original(16)

Peanut Butter(5)

Roasted & Salted(5)

Movie Theater Butter(3)

Chocolate Chip(3)

Chocolate(3)

Homestyle(3)

Original Marshmallow(3)

Butter(2)

Natural Almonds(2)

Extra Butter(2)

Cashews(2)

White Cheddar(2)

Sriracha Cashews(2)

Dry Roasted Almonds(2)

Toast & Peanut Butter(2)

Cheddar Cheese(2)

All Natural Almonds(2)

Sea Salt(2)

Blueberry(2)

Raspberry Crumble Cashew Trail Mix(1)

Berry Mix(1)

Sesame Snax Mix(1)

Pistachios(1)

Deluxe Nut Mix(1)

Light Butter(1)

Shortbread(1)

Wasabi Party Mix(1)

Classic Fruit Nut(1)

Cinnamon/Honey(1)

BBQ; Cheddar & Sour Cream; Classic; Crunchy; Sour Cream & Onion(1)

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

Parmesan Garlic & Herb(1)

Caramel(1)

Assorted(1)

Cashew Pom Vanilla(1)

Hazelnut/Cocoa(1)

6 Packs Ritz Bits Peanut Butter; 8 Packs Ritz Bits Cheese; 8 Packs Nutter Butter Bites; 9 Packs Mini Oreo; 9 Packs Chips Ahoy(1)

Salted(1)

Honey Wheat(1)

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

Cheese(1)

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

Mixed Nuts(1)

Nut & Chocolate(1)

Baked Cheddar(1)

Barbeque(1)

Tropical Fruit & Nut(1)

Hazelnut(1)

Aged White Cheddar(1)

Shortbread Fingers(1)

Honey Glazed Almond(1)

Barbeque; Sea Salt(1)

Chocolate Chip Shortbread(1)

Tangerine Vanilla(1)

Salt & Pepper(1)

Dry Roasted & Salted(1)

Danish Butter(1)

Brown Sugar Cinnamon(1)

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

Apple Cinnamon(1)

Oreo(1)

Dill Pickle Cashews(1)

Deluxe Mixed Nuts(1)

Cocoa Roasted Almonds(1)

Cocoa Roast Almonds(1)

Walnuts and Almonds(1)

Original Fig(1)

Vanilla Crème(1)

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

Sweet Potato with Sea Salt(1)

Multigrain with Sea Salt(1)

Sweet 'N Salty Mix(1)

Chocolate Turtle(1)

Raspberry(1)

Traditional Mix(1)

Chocolate/Peanut Butter(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(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)

Frosted Strawberry(1)

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

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

Nacho Cheese(1)

Crunchy(1)

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

Cheddar(1)

Frosted Blueberry(1)

Original Salty Cracker(1)

Traditional(1)

Sea Salt and Pepper Cashews(1)

Reduced Fat(1)

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

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

Vanilla Cream(1)

 
Manufacturer Part Number

00073(2)

00092(1)

00095(1)

00096(1)

00089(1)

00087(1)

80314(1)

00082(1)

00097(1)

00679(1)

105512(1)

3598(1)

375(1)

105511(1)

105510(1)

1284253(1)

01570(1)

00098(1)

04738(1)

32430(1)

44355(1)

44366(1)

20871(1)

14867(1)

25719(1)

25726(1)

44375(1)

45095(1)

92268(1)

456268(1)

67652(1)

52547(1)

52347(1)

52546(1)

53005(1)

6270(1)

884624(1)

06833(1)

06834(1)

07708(1)

01670(1)

00026(1)

00027(1)

011037(1)

900015(1)

1011039(1)

827582(1)

827612(1)

900362(1)

900022(1)

900020(1)

900021(1)

72200(1)

71100(1)

042722C35S(1)

070146A25M(1)

072142A25X(1)

042322F2OA(1)

04474(1)

W-116(1)

W1537D(1)

072142WTV(1)

091842A25S(1)

13539(1)

827562(1)

21812PK(1)

1051900(1)

05051(1)

601049(1)

00408(1)

98067(1)

827553(1)

16686(1)

24680(1)

24696(1)

12592(1)

30378(1)

52220(1)

30357(1)

27182(1)

28781(1)

33825(1)

34325(1)

34325CT(1)

33664(1)

33525(1)

28783(1)

33364(1)

15923(1)

04068(1)

SN14848(1)

SN14852(1)

SN14858(1)

SN08387(1)

SN08361(1)

81233(1)

81237(1)

SN14868(1)

59636(1)

02908(1)

02908BX(1)

03744(1)

02104(1)

00798(1)

00176(1)

00470(1)

53664(1)

54325(1)

21165(1)

21167(1)

21771(1)

21163(1)

18251(1)

12653(1)

17120(1)

26547(1)

31031(1)

827544(1)

827545(1)

827548(1)

51158(1)

40975(1)

31131(1)

31732(1)

12233(1)

122264(1)

86364(1)

93064(1)

93364(1)

84325(1)

84170(1)

57690(1)

57706(1)

93817(1)

93917(1)

10892(1)

12061(1)

10003(1)

01008(1)

94017(1)

1160588(1)

827695(1)

 
Country of Origin

US(132)

IN(5)

GB(3)

ID(2)

DE(1)

 
Capacity (Volume)

1 oz(1)

1.75 oz(1)

 
Capacity (Weight)

1.5 oz(18)

2 oz(12)

1 oz(7)

5 oz(7)

1.8 oz(5)

2.5 oz(5)

1.75 oz(5)

3.2 oz(5)

1 1/2 oz(4)

1.25 oz(4)

0.7 oz(3)

32 oz(3)

0.63 oz(3)

1.38 oz(3)

1.76 oz(3)

0.8 oz(3)

3 oz(2)

1.4 oz(2)

4.5 oz(2)

3.67 oz(2)

0.62 oz(2)

1.2 oz(2)

44 oz(2)

24 oz(2)

5.5 oz(2)

6.2 oz(1)

34 oz(1)

50 oz(1)

0.9 oz(1)

2.17 oz(1)

1.75 oz; 1.5 oz(1)

15 oz(1)

58 oz(1)

38 oz(1)

14 oz(1)

1.0 oz(1)

1.44 oz(1)

2.2 oz(1)

1.02 oz(1)

12 oz(1)

3.52 oz(1)

0.56 oz(1)

0.2 oz(1)

.39 oz(1)

8 oz(1)

2.4 oz(1)

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

3.75 oz(1)

1.7 oz(1)

.78 oz(1)

0.74 oz(1)

0.22 oz(1)

40 oz(1)

22 oz(1)

1.5 oz; 2 oz(1)

3.71 oz(1)

1.3 oz(1)

48 oz(1)

26 oz(1)

 
Food Type

Nuts(36)

Cookies(25)

Crackers(20)

Popcorn(12)

Chips(11)

Snack(11)

Pretzels(6)

Potato Chips(4)

Pastry(3)

Trail Mix(2)

Snack Bar(2)

Breakfast Biscuits(2)

Dried Fruit(1)

Puffed Rice(1)

Snack Mix(1)

Rice Krispy Treat(1)

Cereal Bar(1)

Veggie Straw(1)

Apple Straw(1)

Snacks(1)

Nut Butter(1)

 
 
 
 
 

© 2019-2020 Office 8, All Rights Reserved