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

Emerald(13)

Nabisco(12)

Kellogg's(7)

Sunshine(6)

Sahale Snacks(5)

Planters(5)

Keebler(5)

Miss Vickie's(4)

Paramount Farms(4)

Pop Secret(4)

Office Snax(3)

Pepperidge Farm(3)

popchips(3)

Austin(3)

Pringles(2)

Grandma's(2)

Chex Mix(2)

Food Should Taste Good(2)

Kar's(2)

Frito-Lay(2)

Shultz(2)

Pop Weaver(1)

Stauffer's(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Walkers(1)

Royal Dansk(1)

Annie's Homegrown(1)

Doritos(1)

Dolcetto(1)

Nutella(1)

Biscoff(1)

Stacy's(1)

Cheetos(1)

Rold Gold(1)

SunChips(1)

Tostitos(1)

Cheez-It(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Sqwincher(1)

 
Packing Type

Bag(46)

Pack(29)

Box(6)

Tub(4)

Tube Package(3)

Canister(3)

Packs(3)

Packets(2)

Pouch(2)

Carton(1)

Bag; Canister; Bar(1)

Bar(1)

Packet(1)

Single-Serve Tub(1)

Single-Serve Bag(1)

Tin Container(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

 
Flavor

Original(12)

Peanut Butter(5)

Original Marshmallow(3)

Sea Salt(3)

Roasted & Salted(3)

Assorted(3)

Chocolate(3)

Chocolate Chip(2)

All Natural Almonds(2)

Cheddar Cheese(2)

Dry Roasted Almonds(2)

White Cheddar(2)

Extra Butter(2)

Cheese(2)

Blueberry(2)

Danish Butter(1)

Caramel(1)

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

Smokehouse BBQ(1)

Sea Salt & Vinegar(1)

Jalapeno(1)

Nacho Cheese(1)

Cinnamon/Honey(1)

Salted(1)

Cheddar(1)

Honey Wheat(1)

Nut & Chocolate(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Tangerine Vanilla(1)

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

Mixed Nuts(1)

Tropical Fruit & Nut(1)

Shortbread Fingers(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

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

Salt & Pepper(1)

Dry Roasted & Salted(1)

Aged White Cheddar(1)

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

Chocolate Chip; Peanut Butter; Vanilla Creme; Oatmeal Raisin;Chocolate Brownie(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 Creme(1)

Fig Newton(1)

Butter(1)

Homestyle(1)

Natural Almonds(1)

Salt & Pepper Cashews(1)

Deluxe Mixed Nuts(1)

Walnuts and Almonds(1)

Cocoa Roast Almonds(1)

Frosted Strawberry(1)

Cocoa Roasted Almonds(1)

Roasted & Salted Cashew Nuts(1)

Sea Salt and Pepper Cashews(1)

Cashews(1)

Original Salty Cracker(1)

Cheez-it Original; Cheez-it White Cheddar; Pringles Original; Rice Krispies Treats(1)

Cheddar Sour Cream & Onion; Double Cheese(1)

Reduced Fat(1)

Original; Cheese; Sour Cream & Onion(1)

Multigrain with Sea Salt(1)

Club & Cheddar Cheese(1)

Cheese & Peanut Butter(1)

Toast & Peanut Butter(1)

Mini Fudge Stripes(1)

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

52347(1)

53005(1)

375(1)

3598(1)

105512(1)

00679(1)

00082(1)

80314(1)

04738(1)

456268(1)

92268(1)

52546(1)

45095(1)

W-116(1)

44451(1)

44446(1)

44443(1)

44441(1)

44375(1)

44366(1)

32430(1)

30501(1)

20871(1)

14867(1)

98067(1)

6270(1)

04474(1)

827553(1)

00027(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

011037(1)

06834(1)

06833(1)

884624(1)

07708(1)

01670(1)

00026(1)

070146A25M(1)

72200(1)

71100(1)

21812PK(1)

827562(1)

13539(1)

1051900(1)

00408(1)

601049(1)

091842A25S(1)

072142WTV(1)

072142A25X(1)

827695(1)

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

40975(1)

122264(1)

31732(1)

26547(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

17120(1)

14991(1)

12653(1)

12233(1)

12061(1)

84170(1)

11500(1)

11461(1)

10892(1)

10104(1)

10003(1)

01008(1)

94017(1)

93817(1)

93364(1)

86364(1)

84325(1)

159200201(1)

 
Country of Origin

US(106)

IN(2)

ID(2)

DE(1)

GB(1)

 
Capacity (Volume)

1.38 oz(4)

No(1)

3 oz(1)

 
Capacity (Weight)

1.5 oz(18)

2 oz(11)

5 oz(6)

1 oz(6)

1.75 oz(4)

1.8 oz(4)

2.5 oz(4)

0.63 oz(3)

0.8 oz(3)

1.25 oz(3)

1.38 oz(2)

1.76 oz(2)

1.2 oz(2)

0.74 oz(2)

3.75 oz(2)

24 oz(2)

1.02 oz(1)

32 oz(1)

1.5 oz; 1.13 oz(1)

15 oz(1)

0.22 oz(1)

44 oz(1)

40 oz(1)

0.7 oz(1)

58 oz(1)

12 oz(1)

3.71 oz(1)

1.44 oz(1)

1.4 oz(1)

1.5 oz; 2 oz(1)

0.39 oz(1)

3 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)

48 oz(1)

3.2 oz(1)

0.2 oz(1)

1 oz; 1.02 oz; 1.3 oz, 0.78 oz(1)

0.75 oz(1)

.78 oz(1)

1.3 oz(1)

3.67 oz(1)

1.75 oz; 1.5 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(29)

Crackers(26)

Chips(20)

Cookies(16)

Popcorn(6)

Nutrition & Snack Bars(5)

Pretzels(5)

Cracker(1)

Snacks(1)

Danish/Pastries(1)

Nut Butters(1)

Frozen Treats(1)

 
 
 

© 2020-2021 Horizon Business Products, All Rights Reserved