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_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(10)

Office Snax(7)

Kellogg's(6)

General Mills(5)

Nabisco(5)

Planters(5)

Keebler(4)

Paramount Farms(4)

Sunshine(4)

Austin(3)

Pop Secret(3)

Pop Weaver(3)

Walkers(2)

Sensible Portions(2)

Stauffer's(1)

popchips(1)

Pepperidge Farm(1)

De Beukelaer(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Snyder's(1)

Annie's Homegrown(1)

Stacy's(1)

Royal Dansk(1)

Dolcetto(1)

Nutella(1)

Biscoff(1)

Kar's(1)

Frito-Lay(1)

Grandma's(1)

Rold Gold(1)

Fla-Vor-Ice(1)

Kettle Brand(1)

Knott's Berry Farm(1)

Utz(1)

 
Packing Type

Bag(36)

Pack(19)

Box(8)

Packs(4)

Tub(2)

Tube Package(2)

Tin Container(2)

Cup(1)

Jar(1)

Can(1)

Canister(1)

Packet(1)

Single-Serve Bag(1)

Single-Serve Tub(1)

Packets(1)

Bar(1)

Tube(1)

Container(1)

 
Flavor

Original(10)

Roasted & Salted(4)

Peanut Butter(3)

Cashews(2)

Toast & Peanut Butter(2)

Butter(2)

Extra Butter(2)

Real Aged Cheddar(1)

Wasabi Party Mix(1)

Salted(1)

6 Packs Ritz Bits Peanut Butter; 6 Packs Ritz Bits Cheese; 7 Packs Nutter Butter Bites; 7 Packs Mini Nilla Wafers; 7 Packs Mini Oreo; 7 Packs Chips Ahoy(1)

Cinnamon/Honey(1)

Hazelnut/Cocoa(1)

Deluxe Nut Mix(1)

Caramel(1)

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

Vanilla Cream(1)

Choco Cremes, Vanilla Cremes, Lemon Ohs!, Cheese Crackers w/Cheese, Cheese Crackers w/Peanut Butter, Toasty Crackers w/Peanut Butter(1)

Pistachios(1)

Shortbread Fingers(1)

Chocolate(1)

Light Butter(1)

Danish Butter(1)

Strawberry(1)

Chocolate Chip(1)

Dry Roasted & Salted(1)

Aged White Cheddar(1)

Hazelnut(1)

Cheddar Cheese(1)

Barbeque; Sea Salt(1)

Fruit & Nut(1)

Nut & Chocolate(1)

Mixed Nuts(1)

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

Blueberry(1)

Original Marshmallow(1)

Frosted Strawberry(1)

All Natural Almonds(1)

Chocolate Turtle(1)

Corn(1)

Cheddar Mix(1)

Chocolate/Peanut Butter(1)

Raspberry(1)

Original Fig(1)

Sea Salt(1)

Apple Cinnamon(1)

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

Homestyle(1)

Natural Almonds(1)

Dry Roasted Almonds(1)

Deluxe Mixed Nuts(1)

Brown Sugar Cinnamon(1)

Walnuts and Almonds(1)

Dark Chocolate Cocoa Roast Almonds(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(1)

Sea Salt and Pepper Cashews(1)

Berry Punch; Grape; Lemon-Lime; Orange; Strawberry; Tropical Punch(1)

Reduced Fat(1)

White Cheddar(1)

Club & Cheddar Cheese(1)

Cheese & Peanut Butter(1)

Mini Fudge Stripes(1)

Sweet 'N Salty Mix(1)

Frosted Blueberry(1)

Cheese(1)

 
Manufacturer Part Number

00058(1)

00095(1)

375(1)

105512(1)

105511(1)

105510(1)

00679(1)

00098(1)

00097(1)

00087(1)

W-116(1)

00082(1)

00073(1)

80314(1)

827558(1)

456268(1)

52546(1)

52347(1)

45095(1)

53005(1)

W-536(1)

827695(1)

00027(1)

827582(1)

011037(1)

06834(1)

06833(1)

884624(1)

07708(1)

01670(1)

00026(1)

042322F2OA(1)

21812PK(1)

13539(1)

05051(1)

00408(1)

601049(1)

072142WTV(1)

070146A25M(1)

042722C35S(1)

32430(1)

827553(1)

SN08387(1)

30378(1)

34325(1)

33664(1)

33364(1)

28781(1)

27182(1)

16686(1)

12592(1)

30357(1)

54325(1)

03744(1)

02104(1)

59636(1)

SN43037(1)

SN37301(1)

SN35182(1)

SN28086(1)

SN16794(1)

53664(1)

84325(1)

827548(1)

21771(1)

827545(1)

827544(1)

56926(1)

56924(1)

31732(1)

31131(1)

31031(1)

26547(1)

21167(1)

93064(1)

21165(1)

21163(1)

12653(1)

122264(1)

92100(1)

94017(1)

93817(1)

93364(1)

827612(1)

 
Country of Origin

US(77)

IN(2)

ID(2)

GB(2)

DE(1)

 
Capacity (Volume)

1.5 oz(1)

1 oz(1)

 
Capacity (Weight)

1.5 oz(8)

2 oz(7)

1 oz(6)

5 oz(6)

1.8 oz(4)

2.5 oz(3)

1.38 oz(3)

1.25 oz(2)

1.4 oz(2)

3.52 oz(2)

44 oz(2)

24 oz(2)

1.2 oz(2)

0.63 oz(2)

5.5 oz(2)

32 oz(2)

4.5 oz(2)

0.88 oz(2)

2.17 oz(1)

0.7 oz(1)

2.01 oz(1)

12 oz(1)

14 oz(1)

0.8 oz(1)

15 oz(1)

1.75 oz(1)

1.75 oz; 1.5 oz(1)

34 oz(1)

3.71 oz(1)

22 oz(1)

40 oz(1)

0.22 oz(1)

1.5oz(1)

1.5 oz; 2 oz(1)

48 oz(1)

3.67 oz(1)

1.3 oz(1)

0.56 oz(1)

3.5 oz(1)

3.75 oz(1)

3 oz(1)

0.9 oz(1)

 
Food Type

Nuts(21)

Cookies(14)

Crackers(12)

Snack(9)

Popcorn(7)

Pretzel(3)

Pastry(3)

Trail Mix(2)

Chips(2)

Cereal Bar(2)

Macaroni and Cheese(1)

Potato Chip(1)

Puffed Rice(1)

Freezer Bar(1)

Nut Butter(1)

Snacks(1)

Apple Straw(1)

Veggie Straw(1)

Snack Mix(1)

 
 
 

© 2019-2020 gemlaser, Inc., All Rights Reserved