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)

Keebler(6)

Kellogg's(6)

Sunshine(6)

Planters(5)

Sahale Snacks(5)

Austin(4)

Pop Weaver(3)

Pop Secret(3)

Paramount Farms(3)

Pepperidge Farm(2)

Shultz(2)

Food Should Taste Good(2)

Frito-Lay(2)

General Mills(2)

KIND(2)

Walkers(2)

Grandma's(2)

Snyder's(1)

Stauffer's(1)

Pirate's Booty(1)

SkinnyPop Popcorn(1)

De Beukelaer(1)

popchips(1)

Utz(1)

SunChips(1)

Kettle Brand(1)

Sensible Portions(1)

Knott's Berry Farm(1)

Kar's(1)

Chex Mix(1)

Rold Gold(1)

Dolcetto(1)

Nutella(1)

Biscoff(1)

Stacy's(1)

Royal Dansk(1)

 
Packing Type

Bag(40)

Pack(25)

Box(10)

Packs(5)

Tub(4)

Bar(3)

Tube Package(3)

Tin Container(2)

Pouch(2)

Can(1)

Jar(1)

Container(1)

Packet(1)

Packets(1)

Carton(1)

Single-Serve Tub(1)

Single-Serve Bag(1)

Canister(1)

 
Flavor

Original(13)

Peanut Butter(4)

Chocolate(3)

Roasted & Salted(3)

Natural Almonds(2)

Toast & Peanut Butter(2)

Dry Roasted Almonds(2)

Original Marshmallow(2)

White Cheddar(2)

Cashews(2)

Extra Butter(2)

Cheddar Cheese(2)

Butter(2)

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)

Light Butter(1)

Assorted(1)

Caramel(1)

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

Danish Butter(1)

Deluxe Nut Mix(1)

Hazelnut/Cocoa(1)

Wasabi Party Mix(1)

Sesame Snax Mix(1)

Salted(1)

Pistachios(1)

Cinnamon/Honey(1)

Honey Wheat(1)

Aged White Cheddar(1)

Tangerine Vanilla(1)

Cheese(1)

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

Honey Glazed Almond(1)

Cashew Pom Vanilla(1)

Raspberry Crumble Cashew Trail Mix(1)

Classic Fruit Nut(1)

Mixed Nuts(1)

Nut & Chocolate(1)

Dry Roasted & Salted(1)

Chocolate Chip Shortbread(1)

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

Hazelnut(1)

Tropical Fruit & Nut(1)

Barbeque; Sea Salt(1)

Shortbread Fingers(1)

Pepper Jack Cheese(1)

Deluxe Mixed Nuts(1)

All Natural Almonds(1)

Homestyle(1)

Walnuts and Almonds(1)

Cocoa Roast Almonds(1)

Roasted & Salted Cashew Nuts(1)

Salty Sweet Mix(1)

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

Sea Salt(1)

Sweet 'N Salty Mix(1)

Sweet Potato with Sea Salt(1)

Corn(1)

Raspberry(1)

Original Fig(1)

Vanilla Crème(1)

Sea Salt and Pepper Cashews(1)

Traditional(1)

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

Multigrain with Sea Salt(1)

Frosted Strawberry(1)

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

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

Vanilla Cream(1)

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

Brown Sugar Cinnamon(1)

Frosted Blueberry(1)

Chocolate Chip(1)

Original Salty Cracker(1)

Reduced Fat(1)

Club & Cheddar Cheese(1)

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

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

 
Manufacturer Part Number

00098(1)

00679(1)

00097(1)

00096(1)

00095(1)

105510(1)

105511(1)

53005(1)

6270(1)

375(1)

3598(1)

105512(1)

00089(1)

00087(1)

67652(1)

92268(1)

52546(1)

52347(1)

45095(1)

456268(1)

04738(1)

00082(1)

00073(1)

80314(1)

1284253(1)

W-116(1)

W1537D(1)

06834(1)

011037(1)

06833(1)

884624(1)

07708(1)

900015(1)

900020(1)

827582(1)

827612(1)

900362(1)

900022(1)

900021(1)

01670(1)

00027(1)

072142WTV(1)

601049(1)

070146A25M(1)

042722C35S(1)

04474(1)

00408(1)

05051(1)

00026(1)

21812PK(1)

13539(1)

1051900(1)

32430(1)

14867(1)

33664(1)

34325(1)

33364(1)

28781(1)

27182(1)

53664(1)

54325(1)

93364(1)

93817(1)

93064(1)

84325(1)

84170(1)

16686(1)

12592(1)

SN14868(1)

59636(1)

SN14834(1)

SN08387(1)

81237(1)

00176(1)

00470(1)

30357(1)

03744(1)

02104(1)

00798(1)

94017(1)

1160588(1)

51158(1)

827544(1)

40975(1)

31732(1)

31131(1)

827545(1)

827548(1)

25726(1)

25719(1)

827695(1)

827553(1)

31031(1)

26547(1)

122264(1)

12233(1)

10892(1)

10003(1)

01008(1)

12653(1)

17120(1)

21771(1)

21167(1)

21165(1)

21163(1)

81233(1)

 
Country of Origin

US(99)

ID(2)

IN(2)

GB(2)

DE(1)

 
Capacity (Volume)

1 oz(1)

1.75 oz(1)

 
Capacity (Weight)

1.5 oz(17)

2 oz(9)

1 oz(6)

5 oz(5)

1.8 oz(5)

2.5 oz(4)

1 1/2 oz(4)

32 oz(3)

0.7 oz(3)

1.75 oz(3)

1.38 oz(3)

3.67 oz(2)

24 oz(2)

3 oz(2)

44 oz(2)

5.5 oz(2)

1.2 oz(2)

0.63 oz(2)

1.25 oz(2)

1.4 oz(1)

1.44 oz(1)

12 oz(1)

2.17 oz(1)

2.2 oz(1)

1.02 oz(1)

1.75 oz; 1.5 oz(1)

0.9 oz(1)

15 oz(1)

0.8 oz(1)

14 oz(1)

34 oz(1)

26 oz(1)

2.4 oz(1)

1.7 oz(1)

48 oz(1)

3.52 oz(1)

0.2 oz(1)

1.3 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

22 oz(1)

.78 oz(1)

40 oz(1)

3.2 oz(1)

0.22 oz(1)

0.56 oz(1)

 
Food Type

Nuts(28)

Cookies(21)

Crackers(18)

Snack(7)

Popcorn(7)

Chips(6)

Pretzels(5)

Pastry(3)

Trail Mix(2)

Snack Bar(2)

Potato Chips(1)

Snack Mix(1)

Puffed Rice(1)

Veggie Straw(1)

Snacks(1)

Nut Butter(1)

Rice Krispy Treat(1)

 
 
 

© 2019-2020 Gateway Business Products, All Rights Reserved