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_2` 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','out_of_stock') 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(18)

Nabisco(17)

Sunshine(7)

Kellogg's(6)

Keebler(5)

Sahale Snacks(5)

Office Snax(5)

Planters(5)

Paramount Farms(4)

Miss Vickie's(4)

Pop Secret(4)

popchips(3)

Pepperidge Farm(3)

Austin(3)

Homefree(2)

Frito-Lay(2)

Stauffer's(2)

Chex Mix(2)

Grandma's(2)

Shultz(2)

Kar's(2)

Food Should Taste Good(2)

Walkers(2)

Royal Dansk(1)

Annie's Homegrown(1)

Pirate's Booty(1)

SkinnyPop Popcorn(1)

Pop Weaver(1)

Cheetos(1)

Dolcetto(1)

Nutella(1)

Biscoff(1)

Stacy's(1)

Doritos(1)

Rold Gold(1)

SunChips(1)

Tostitos(1)

Pringles(1)

Kettle Brand(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Sqwincher(1)

 
Packing Type

Bag(49)

Pack(37)

Box(7)

Tube Package(4)

Tub(4)

Canister(3)

Packs(3)

Packets(2)

Tube(2)

Pouch(2)

Bar(1)

Carton(1)

Single-Serve Tub(1)

Yes(1)

Single-Serve Bag(1)

Tin Container(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

Packet(1)

 
Flavor

Original(13)

Peanut Butter(6)

Chocolate Chip(4)

Sea Salt(3)

Roasted & Salted(3)

Assorted(3)

Original Marshmallow(3)

Chocolate(3)

Cocoa Roast Almonds(2)

All Natural Almonds(2)

White Cheddar(2)

Dry Roasted Almonds(2)

Jalapeno Cashews(2)

Cheddar Cheese(2)

Movie Theater Butter(2)

Sriracha Cashews(2)

Cashews(2)

Golden Oat(2)

Blueberry(2)

Cheese(2)

Salted(1)

Berry Mix(1)

Extra Butter(1)

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

Caramel(1)

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

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

Vanilla Cream(1)

Danish Butter(1)

Honey Wheat(1)

Cheddar(1)

Shortbread Fingers(1)

Nut & Chocolate(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Tangerine Vanilla(1)

Salted Nuts(1)

Mixed Nuts(1)

Tropical Fruit & Nut(1)

Chocolate Chip Shortbread(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Aged White Cheddar(1)

Sea Salt & Vinegar(1)

Salt & Pepper(1)

Dry Roasted & Salted(1)

Smokehouse BBQ(1)

Cheese & Peanut Butter(1)

Jalapeno(1)

Walnuts and Almonds(1)

Sweet Potato with Sea Salt(1)

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

Sweet 'N Salty Mix(1)

Cheddar Mix(1)

Traditional Mix(1)

Raspberry(1)

Vanilla Creme(1)

Fig Newton(1)

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

Butter(1)

Homestyle(1)

Natural Almonds(1)

Salt & Pepper Cashews(1)

Deluxe Mixed Nuts(1)

Cocoa Roasted Almonds(1)

Nacho Cheese(1)

Roasted & Salted Cashew Nuts(1)

Sea Salt and Pepper Cashews(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Original Salty Cracker(1)

Reduced Fat(1)

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

Club & Cheddar Cheese(1)

Multigrain with Sea Salt(1)

Toast & Peanut Butter(1)

Mini Fudge Stripes(1)

Frosted Strawberry(1)

Zesty Ranch(1)

Chocolate Chip; Peanut Butter; Vanilla Creme; Oatmeal Raisin;Chocolate Brownie(1)

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

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

52347(1)

3598(1)

105512(1)

00679(1)

00095(1)

00092(1)

00082(1)

80401(1)

1284253(1)

04738(1)

456268(1)

92268(1)

52546(1)

45095(1)

53005(1)

44451(1)

44446(1)

44443(1)

44441(1)

44375(1)

44366(1)

32430(1)

30501(1)

20871(1)

14867(1)

98067(1)

93646(1)

827695(1)

375(1)

6270(1)

827545(1)

00026(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

11017(1)

011037(1)

06834(1)

06833(1)

07708(1)

07210(1)

01670(1)

00027(1)

72200(1)

W-116(1)

71100(1)

21812PK(1)

827562(1)

13539(1)

1051900(1)

00408(1)

601049(1)

091842A25S(1)

072142WTV(1)

072142A25X(1)

070146A25M(1)

04474(1)

W1537D(1)

827553(1)

40975(1)

81233(1)

02946BX(1)

33725(1)

33664(1)

33625(1)

33364(1)

28783(1)

28781(1)

27182(1)

12592(1)

30357(1)

52220(1)

04068(1)

03745(1)

03744(1)

02946(1)

34325(1)

02908BX(1)

02908(1)

02104(1)

00798(1)

00470(1)

00176(1)

59636(1)

SN14868(1)

SN14858(1)

SN14839(1)

SN08387(1)

SN08361(1)

81237(1)

33825(1)

34325CT(1)

31732(1)

10003(1)

26547(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

17120(1)

12653(1)

12233(1)

122264(1)

12061(1)

10892(1)

10104(1)

01008(1)

53664(1)

01873(1)

01305(1)

94217(1)

94017(1)

93917(1)

93817(1)

93364(1)

89426(1)

86364(1)

84325(1)

84170(1)

57706(1)

54325(1)

159200201(1)

 
Country of Origin

US(115)

IN(7)

ID(2)

GB(2)

CA(1)

 
Capacity (Volume)

1.38 oz(4)

3 oz(1)

 
Capacity (Weight)

1.5 oz(21)

2 oz(11)

1 oz(7)

5 oz(6)

1.76 oz(5)

1.25 oz(5)

1.75 oz(5)

2.5 oz(4)

1.8 oz(3)

0.63 oz(3)

0.62 oz(3)

0.8 oz(3)

3 oz(2)

24 oz(2)

1.38 oz(2)

1.2 oz(2)

32 oz(2)

1.4 oz(2)

3.75 oz(2)

2.32 oz(1)

40 oz(1)

15 oz(1)

38 oz(1)

12 oz(1)

0.7 oz(1)

44 oz(1)

1.44 oz(1)

2.2 oz(1)

58 oz(1)

1.5 oz; 1.13 oz(1)

1.02 oz(1)

0.22 oz(1)

.78 oz(1)

1.5 oz; 2 oz(1)

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

8-1.75 oz; 16-1.5 oz(1)

5.5 oz(1)

1.7 oz(1)

2.4 oz(1)

0.56 oz(1)

3.2 oz(1)

1.1 oz(1)

3.71 oz(1)

0.2 oz(1)

0.39 oz(1)

0.74 oz(1)

1.3 oz(1)

3.67 oz(1)

48 oz(1)

3.25 oz(1)

16 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(35)

Crackers(27)

Chips(20)

Cookies(20)

Nutrition & Snack Bars(8)

Popcorn(6)

Pretzels(5)

Cracker(1)

Danish/Pastries(1)

Snack Variety Packs(1)

Nut Butters(1)

Fruit Snacks(1)

Frozen Treats(1)

 
 
 

© 2020-2021 ISEOP, All Rights Reserved