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

Nabisco(10)

Office Snax(9)

Sunshine(6)

Keebler(6)

Kellogg's(6)

Sahale Snacks(5)

Planters(5)

Austin(4)

Paramount Farms(3)

Pop Weaver(3)

Pop Secret(3)

Shultz(2)

KIND(2)

Grandma's(2)

Pepperidge Farm(2)

Frito-Lay(2)

Walkers(2)

Food Should Taste Good(2)

popchips(1)

De Beukelaer(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Stauffer's(1)

Snyder's(1)

SunChips(1)

Royal Dansk(1)

Dolcetto(1)

Nutella(1)

Biscoff(1)

Kar's(1)

Stacy's(1)

Rold Gold(1)

Chex Mix(1)

Kettle Brand(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Utz(1)

 
Packing Type

Bag(39)

Pack(25)

Box(10)

Packs(5)

Tub(4)

Tube Package(3)

Bar(3)

Tin Container(2)

Pouch(2)

Jar(1)

Can(1)

Single-Serve Tub(1)

Canister(1)

Single-Serve Bag(1)

Packets(1)

Packet(1)

Carton(1)

Container(1)

 
Flavor

Original(13)

Peanut Butter(4)

Roasted & Salted(3)

Chocolate(3)

Toast & Peanut Butter(2)

Cashews(2)

Original Marshmallow(2)

Cheddar Cheese(2)

Extra Butter(2)

Butter(2)

White Cheddar(2)

Natural Almonds(2)

Dry Roasted Almonds(2)

Multigrain with Sea Salt(1)

Danish Butter(1)

Light Butter(1)

Sesame Snax Mix(1)

Deluxe Nut Mix(1)

Pistachios(1)

Wasabi Party Mix(1)

Salted(1)

Cinnamon/Honey(1)

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

Assorted(1)

Honey Wheat(1)

Aged White Cheddar(1)

Shortbread Fingers(1)

Chocolate Chip Shortbread(1)

Dry Roasted & Salted(1)

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

Hazelnut(1)

Barbeque; Sea Salt(1)

Tropical Fruit & Nut(1)

Nut & Chocolate(1)

Mixed Nuts(1)

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

Cheese(1)

Tangerine Vanilla(1)

Honey Glazed Almond(1)

Cashew Pom Vanilla(1)

Classic Fruit Nut(1)

Caramel(1)

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

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

Traditional(1)

Sweet 'N Salty Mix(1)

Raspberry(1)

Vanilla Crème(1)

Original Fig(1)

Sea Salt(1)

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

Homestyle(1)

All Natural Almonds(1)

Deluxe Mixed Nuts(1)

Walnuts and Almonds(1)

Cocoa Roast Almonds(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(1)

Sea Salt and Pepper Cashews(1)

Original Salty Cracker(1)

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

Chocolate Chip(1)

Reduced Fat(1)

Club & Cheddar Cheese(1)

Cheese & Peanut Butter(1)

Mini Fudge Stripes(1)

Frosted Blueberry(1)

Brown Sugar Cinnamon(1)

Frosted Strawberry(1)

Pepper Jack Cheese(1)

Sweet Potato with Sea Salt(1)

Cherry Cashew/Dark Chocolate; Dark Chocolate/Peanut Butter(1)

Almond & Sea Salt; Dark Chocolate Nuts; Sea Salt Caramel(1)

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

Vanilla Cream(1)

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

81233(1)

00095(1)

53005(1)

375(1)

3598(1)

105512(1)

105511(1)

105510(1)

00679(1)

00098(1)

00097(1)

00096(1)

00089(1)

W-116(1)

00087(1)

00082(1)

00073(1)

80314(1)

1284253(1)

04738(1)

456268(1)

92268(1)

67652(1)

52546(1)

6270(1)

W1537D(1)

45095(1)

07708(1)

827582(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

011037(1)

06834(1)

06833(1)

884624(1)

01670(1)

04474(1)

00027(1)

00026(1)

21812PK(1)

13539(1)

1051900(1)

05051(1)

00408(1)

601049(1)

072142WTV(1)

070146A25M(1)

042722C35S(1)

52347(1)

32430(1)

81237(1)

27182(1)

93364(1)

93064(1)

84325(1)

84170(1)

54325(1)

53664(1)

34325(1)

33664(1)

33364(1)

28781(1)

16686(1)

94017(1)

12592(1)

30357(1)

03744(1)

02104(1)

00798(1)

00470(1)

00176(1)

59636(1)

SN14868(1)

SN08387(1)

93817(1)

1160588(1)

14867(1)

31131(1)

25726(1)

25719(1)

827695(1)

827553(1)

827548(1)

827545(1)

827544(1)

51158(1)

40975(1)

31732(1)

31031(1)

01008(1)

26547(1)

21771(1)

21167(1)

21165(1)

21163(1)

17120(1)

12653(1)

12233(1)

122264(1)

10892(1)

10003(1)

827612(1)

 
Country of Origin

US(98)

IN(2)

ID(2)

GB(2)

DE(1)

 
Capacity (Volume)

1.75 oz(1)

1 oz(1)

 
Capacity (Weight)

1.5 oz(17)

2 oz(9)

1 oz(6)

1.8 oz(5)

5 oz(5)

2.5 oz(4)

1 1/2 oz(4)

32 oz(3)

1.75 oz(3)

1.38 oz(3)

0.7 oz(3)

24 oz(2)

1.2 oz(2)

1.25 oz(2)

44 oz(2)

0.63 oz(2)

5.5 oz(2)

3.67 oz(2)

2.17 oz(1)

1.02 oz(1)

12 oz(1)

1.44 oz(1)

1.4 oz(1)

2.2 oz(1)

14 oz(1)

0.8 oz(1)

15 oz(1)

1.75 oz; 1.5 oz(1)

34 oz(1)

3.71 oz(1)

26 oz(1)

22 oz(1)

40 oz(1)

0.22 oz(1)

3 oz(1)

1.5 oz; 2 oz(1)

48 oz(1)

3.52 oz(1)

1.3 oz(1)

.78 oz(1)

0.2 oz(1)

0.56 oz(1)

3.2 oz(1)

2.4 oz(1)

1.7 oz(1)

0.9 oz(1)

 
Food Type

Nuts(28)

Cookies(21)

Crackers(18)

Popcorn(7)

Chips(6)

Snack(6)

Pretzels(5)

Pastry(3)

Snack Bar(2)

Trail Mix(2)

Rice Krispy Treat(1)

Snacks(1)

Nut Butter(1)

Veggie Straw(1)

Puffed Rice(1)

Potato Chips(1)

Snack Mix(1)

 
 
 

© 2020-2021 Legal Name, All Rights Reserved