Banner1 Banner1
 
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_36` 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

Nabisco(13)

Emerald(13)

Kellogg's(6)

Sunshine(6)

Planters(5)

Sahale Snacks(5)

Keebler(5)

Paramount Farms(4)

Miss Vickie's(4)

Pop Secret(4)

Office Snax(3)

Chex Mix(3)

Pepperidge Farm(3)

Austin(3)

popchips(3)

Food Should Taste Good(2)

Frito-Lay(2)

Grandma's(2)

Shultz(2)

Snyder's(2)

Kar's(2)

SkinnyPop Popcorn(1)

Sqwincher(1)

Pirate's Booty(1)

Walkers(1)

Royal Dansk(1)

Stauffer's(1)

Annie's Homegrown(1)

Pop Weaver(1)

Dolcetto(1)

Nutella(1)

Biscoff(1)

SunChips(1)

Stacy's(1)

Doritos(1)

Cheetos(1)

Rold Gold(1)

Tostitos(1)

Pringles(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Utz(1)

 
Packing Type

Bag(45)

Pack(30)

Box(7)

Packs(4)

Tub(4)

Tube Package(3)

Canister(3)

Packets(2)

Pouch(2)

Resealable Bag in Box(1)

Jar(1)

Can(1)

Packet(1)

Tin Container(1)

Single-Serve Bag(1)

Single-Serve Tub(1)

Bar(1)

Carton(1)

Container(1)

 
Flavor

Original(15)

Peanut Butter(5)

Sea Salt(3)

Original Marshmallow(3)

Roasted & Salted(3)

Chocolate(3)

Toast & Peanut Butter(2)

Assorted(2)

White Cheddar(2)

Chocolate Chip(2)

All Natural Almonds(2)

Cheddar Cheese(2)

Dry Roasted Almonds(2)

Extra Butter(2)

Cheese(2)

Blueberry(2)

Tropical Fruit & Nut(1)

Hazelnut/Cocoa(1)

Smokehouse BBQ(1)

Vanilla Cream(1)

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

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

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

Caramel(1)

Classic Fruit Nut(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)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Tangerine Vanilla(1)

Salted(1)

Cinnamon/Honey(1)

Barbeque(1)

Danish Butter(1)

Honey Wheat(1)

Shortbread Fingers(1)

Dry Roasted & Salted(1)

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

Salt & Pepper(1)

Sea Salt & Vinegar(1)

Mixed Nuts(1)

Nut & Chocolate(1)

Baked Cheddar(1)

Barbeque; Sea Salt(1)

Aged White Cheddar(1)

Cheddar(1)

Jalapeno(1)

Movie Theater Butter(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 Crème(1)

Original Fig(1)

Butter(1)

Homestyle(1)

Natural Almonds(1)

Salt & Pepper Cashews(1)

Deluxe Mixed Nuts(1)

Walnuts and Almonds(1)

Cocoa Roast Almonds(1)

Nacho Cheese(1)

Cocoa Roasted Almonds(1)

Roasted & Salted Cashew Nuts(1)

Sea Salt and Pepper Cashews(1)

Cashews(1)

Traditional(1)

Original Salty Cracker(1)

Reduced Fat(1)

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

Club & Cheddar Cheese(1)

Cheese & Peanut Butter(1)

Multigrain with Sea Salt(1)

Mini Fudge Stripes(1)

Frosted Strawberry(1)

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

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

456268(1)

W-116(1)

6270(1)

53005(1)

375(1)

3598(1)

105512(1)

00679(1)

00082(1)

80314(1)

1284253(1)

04738(1)

92268(1)

070146A25M(1)

67652(1)

52546(1)

52347(1)

45095(1)

44451(1)

44446(1)

44443(1)

44441(1)

44375(1)

44366(1)

32430(1)

04474(1)

072142A25X(1)

14867(1)

884624(1)

159200201(1)

827582(1)

1011039(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

011037(1)

06834(1)

06833(1)

07708(1)

072142WTV(1)

01670(1)

00027(1)

00026(1)

72200(1)

71100(1)

21812PK(1)

827562(1)

13539(1)

1051900(1)

00408(1)

601049(1)

091842A25S(1)

20871(1)

98067(1)

81233(1)

02908BX(1)

34325CT(1)

34325(1)

33725(1)

33664(1)

33364(1)

28781(1)

27182(1)

16686(1)

30357(1)

07737(1)

03744(1)

02908(1)

54325(1)

02104(1)

00798(1)

00470(1)

00176(1)

59636(1)

SN14868(1)

SN14858(1)

SN14839(1)

SN08387(1)

SN08361(1)

81237(1)

53664(1)

57706(1)

827695(1)

17120(1)

827553(1)

827548(1)

827545(1)

40975(1)

31732(1)

26547(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

12653(1)

84170(1)

12233(1)

122264(1)

12061(1)

10892(1)

10003(1)

01008(1)

1160588(1)

94017(1)

93817(1)

93364(1)

86364(1)

84325(1)

827612(1)

 
Country of Origin

US(108)

IN(2)

ID(2)

DE(1)

GB(1)

 
Capacity (Volume)

1.375 oz(4)

1 oz(1)

3 oz(1)

 
Capacity (Weight)

1.5 oz(18)

2 oz(11)

1 oz(7)

5 oz(6)

1.75 oz(5)

1.8 oz(4)

2.5 oz(4)

0.63 oz(3)

0.8 oz(3)

1.25 oz(3)

44 oz(2)

1.38 oz(2)

1.76 oz(2)

1.2 oz(2)

3.75 oz(2)

24 oz(2)

0.22 oz(1)

32 oz(1)

40 oz(1)

50 oz(1)

0.7 oz(1)

1.44 oz(1)

12 oz(1)

15 oz(1)

1.4 oz(1)

1.5 oz; 2 oz(1)

1.02 oz(1)

1.75 oz; 1.5 oz(1)

58 oz(1)

1.5 oz; 1.13 oz(1)

0.74 oz(1)

3.71 oz(1)

0.62 oz(1)

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

5.5 oz(1)

1.7 oz(1)

2.4 oz(1)

8 oz(1)

3.5 oz(1)

0.56 oz(1)

3 oz(1)

3.2 oz(1)

0.2 oz(1)

.39 oz(1)

.78 oz(1)

1.3 oz(1)

3.67 oz(1)

48 oz(1)

0.9 oz(1)

 
Food Type

Nuts(25)

Cookies(20)

Crackers(19)

Snack(12)

Chips(12)

Popcorn(6)

Pretzels(6)

Potato Chips(4)

Trail Mix(2)

Cereal Bar(1)

Breakfast Biscuits(1)

Veggie Straw(1)

Rice Krispy Treat(1)

Pastry(1)

Nut Butter(1)

Puffed Rice(1)

Snack Mix(1)

 
 
 

© 2020-2021 Horizon Business Products, All Rights Reserved