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','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(7)

Planters(6)

Office Snax(5)

Sahale Snacks(5)

Keebler(5)

Miss Vickie's(4)

Paramount Farms(4)

popchips(4)

Pop Secret(4)

Walkers(3)

Pepperidge Farm(3)

Pop Weaver(3)

Homefree(3)

Shultz(2)

Kar's(2)

Chex Mix(2)

Nutella(2)

Frito-Lay(2)

Austin(2)

Food Should Taste Good(2)

Doritos(2)

Stauffer's(2)

Grandma's(2)

Cheetos(2)

Snyder's(1)

Pirate's Booty(1)

Sqwincher(1)

Royal Dansk(1)

SkinnyPop Popcorn(1)

Annie's Homegrown(1)

Dolcetto(1)

Biscoff(1)

Stacy's(1)

Lay's(1)

Rold Gold(1)

Tostitos(1)

Pringles(1)

Kettle Brand(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Utz(1)

 
Packing Type

Bag(56)

Pack(38)

Box(8)

Tube Package(4)

Tub(4)

Canister(3)

Packs(3)

Tube(2)

Pouch(2)

Single-Serve Tub(2)

Packets(2)

Packet(1)

Bar(1)

Carton(1)

Single-Serve Bag(1)

Tin Container(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

Yes(1)

Container(1)

 
Flavor

Original(15)

Peanut Butter(6)

Chocolate Chip(5)

Cheese(3)

Roasted & Salted(3)

Sea Salt(3)

Original Marshmallow(3)

Chocolate(3)

Dry Roasted Almonds(2)

Sriracha Cashews(2)

White Cheddar(2)

All Natural Almonds(2)

Movie Theater Butter(2)

Cocoa Roast Almonds(2)

Cheddar Cheese(2)

Cashews(2)

Jalapeno Cashews(2)

Butter(2)

Hazelnut/Cocoa(2)

Assorted(2)

Golden Oat(2)

Blueberry(2)

Nacho Cheese(2)

Berry Mix(1)

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

Honey Wheat(1)

Extra Butter(1)

Danish Butter(1)

Shortbread Fingers(1)

Light Butter(1)

Cinnamon/Honey(1)

Salted(1)

Shortbread(1)

Cheddar(1)

Baked Cheddar(1)

Chocolate Chip Shortbread(1)

Mixed Nuts(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Tangerine Vanilla(1)

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

Salted Nuts(1)

Nut & Chocolate(1)

Dry Roasted & Salted(1)

Tropical Fruit & Nut(1)

Sour Cream & Onion(1)

Barbeque(1)

Barbeque; Sea Salt(1)

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

Aged White Cheddar(1)

Salt & Pepper(1)

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

Frosted Strawberry(1)

Vanilla Cream(1)

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

Cocoa Roasted Almonds(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Salt & Pepper Cashews(1)

Natural Almonds(1)

Homestyle(1)

Fig Newton(1)

Sea Salt and Pepper Cashews(1)

Vanilla Creme(1)

Raspberry(1)

Traditional Mix(1)

Sweet 'N Salty Mix(1)

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

Sweet Potato with Sea Salt(1)

Roasted & Salted Cashew Nuts(1)

Traditional(1)

Barbecue(1)

Mini Fudge Stripes(1)

Smokehouse BBQ(1)

Sea Salt & Vinegar(1)

Jalapeno(1)

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

Zesty Ranch(1)

Multigrain with Sea Salt(1)

Toast & Peanut Butter(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

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

Reduced Fat(1)

Original Salty Cracker(1)

Vanilla(1)

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

456268(1)

375(1)

3598(1)

105512(1)

105511(1)

105510(1)

01570(1)

00679(1)

00095(1)

00092(1)

00082(1)

80401(1)

80314(1)

1284253(1)

04738(1)

92268(1)

6270(1)

62737(1)

52546(1)

52347(1)

45095(1)

44458(1)

44451(1)

44446(1)

44443(1)

44441(1)

44375(1)

44366(1)

32430(1)

20871(1)

14867(1)

53005(1)

W-116(1)

98067CT(1)

01670(1)

159200201(1)

827582(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

11017(1)

011037(1)

06834(1)

06833(1)

884624(1)

07708(1)

07210(1)

00027(1)

W1537D(1)

00408(1)

04474(1)

070146A25M(1)

072142A25X(1)

072142WTV(1)

091842A25S(1)

601049(1)

1051900(1)

00026(1)

13539(1)

827562(1)

21812PK(1)

71100(1)

72200(1)

77700(1)

14672(1)

98067(1)

81233(1)

03745(1)

34325CT(1)

34325(1)

33825(1)

33725(1)

33664(1)

33625(1)

33364(1)

28783(1)

28781(1)

27182(1)

12592(1)

30357(1)

52220(1)

04068(1)

03744(1)

54325(1)

02946BX(1)

02946(1)

02908BX(1)

02908(1)

02104(1)

00798(1)

00470(1)

00176(1)

59636(1)

SN14868(1)

SN14858(1)

SN08387(1)

SN08361(1)

81237(1)

53664(1)

57706(1)

93646(1)

122264(1)

827695(1)

827553(1)

827545(1)

40975(1)

31732(1)

26547(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

17120(1)

12653(1)

12233(1)

12061(1)

84170(1)

94017(1)

84325(1)

86364(1)

89426(1)

93364(1)

93817(1)

93917(1)

94217(1)

10892(1)

1160588(1)

01305(1)

01866(1)

01873(1)

01008(1)

10003(1)

827612(1)

 
Country of Origin

US(124)

IN(7)

GB(3)

ID(2)

DE(1)

CA(1)

 
Capacity (Volume)

1.38 oz(4)

3 oz(1)

 
Capacity (Weight)

1.5 oz(21)

2 oz(12)

1 oz(7)

1.75 oz(6)

5 oz(6)

2.5 oz(5)

1.25 oz(5)

1.76 oz(5)

1.8 oz(4)

0.8 oz(4)

0.62 oz(3)

0.63 oz(3)

1.4 oz(2)

1.1 oz(2)

32 oz(2)

3.25 oz(2)

24 oz(2)

3 oz(2)

44 oz(2)

1.2 oz(2)

1.44 oz(1)

15 oz(1)

12 oz(1)

2.2 oz(1)

0.22 oz(1)

58 oz(1)

2.17 oz(1)

6.2 oz(1)

16 oz(1)

1.75 oz; 1.5 oz(1)

0.7 oz(1)

38 oz(1)

1.02 oz(1)

40 oz(1)

2.32 oz(1)

1.3 oz(1)

1.5 oz; 1.13 oz(1)

3.2 oz(1)

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

3.75 oz(1)

5.5 oz(1)

1.7 oz(1)

2.4 oz(1)

1.38 oz(1)

0.56 oz(1)

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

2.875 oz(1)

0.2 oz(1)

0.39 oz(1)

.78 oz(1)

0.74 oz(1)

3.67 oz(1)

48 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

0.9 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(36)

Crackers(27)

Cookies(23)

Chips(22)

Nutrition & Snack Bars(8)

Popcorn(8)

Pretzels(6)

Nut Butters(2)

Danish/Pastries(1)

Snack(1)

Snack Variety Packs(1)

Fruit Snacks(1)

Potato Chip(1)

Frozen Treats(1)

 
 
 

© 2020-2021 BonTay, Inc., All Rights Reserved