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

Nabisco(17)

Office Snax(10)

Kellogg's(9)

Sunshine(7)

Pop Secret(7)

Planters(6)

Keebler(6)

Paramount Farms(5)

Sahale Snacks(5)

Austin(4)

popchips(4)

Chex Mix(4)

Walkers(3)

Pop Weaver(3)

Pepperidge Farm(3)

Nutella(2)

Snyder's(2)

Stacy's(2)

Shultz(2)

Miss Vickie's(2)

KIND(2)

Cheetos(2)

Sensible Portions(2)

Grandma's(2)

Kar's(2)

Food Should Taste Good(2)

Kettle Brand(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Knott's Berry Farm(1)

Sqwincher(1)

Utz(1)

Stauffer's(1)

General Mills(1)

Royal Dansk(1)

De Beukelaer(1)

Pringles(1)

Lay's(1)

Ruffles(1)

Annie's Homegrown(1)

Doritos(1)

Fritos(1)

Frito-Lay(1)

Tostitos(1)

Rold Gold(1)

Dolcetto(1)

Biscoff(1)

SunChips(1)

Homefree(1)

 
Packing Type

Bag(68)

Pack(39)

Box(11)

Packs(5)

Tub(4)

Canister(4)

Bar(3)

Tube Package(3)

Pouch(2)

Tin Container(2)

Single-Serve Tub(2)

Packets(2)

Jar(1)

Tube(1)

Container(1)

Can(1)

Resealable Bag in Box(1)

Single-Serve Bag(1)

Carton(1)

Packet(1)

 
Flavor

Original(16)

Peanut Butter(6)

Roasted & Salted(5)

Chocolate(4)

Chocolate Chip(3)

Sea Salt(3)

Original Marshmallow(3)

Homestyle(3)

Cheddar Cheese(2)

Dry Roasted Almonds(2)

Assorted(2)

Natural Almonds(2)

Butter(2)

Sriracha Cashews(2)

All Natural Almonds(2)

White Cheddar(2)

Hazelnut/Cocoa(2)

Cheese(2)

Cashews(2)

Toast & Peanut Butter(2)

Movie Theater Butter(2)

Blueberry(2)

Extra Butter(2)

Cinnamon/Honey(1)

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

Salted Nuts(1)

Salted(1)

Wasabi Party Mix(1)

Mixed Nuts(1)

Classic Fruit Nut(1)

Sesame Snax Mix(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)

Caramel(1)

Regular(1)

Honey Glazed Almond(1)

Barbecue(1)

Smokehouse BBQ(1)

Vanilla Cream(1)

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

Nut & Chocolate(1)

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

Parmesan Garlic & Herb(1)

Tangerine Vanilla(1)

Pistachios(1)

Aged White Cheddar(1)

Tropical Fruit & Nut(1)

Dry Roasted & Salted(1)

Sour Cream & Onion(1)

Hazelnut(1)

Baked Cheddar(1)

Barbeque; Sea Salt(1)

Barbeque(1)

Nacho Cheese(1)

Cashew Pom Vanilla(1)

Shortbread(1)

Raspberry Crumble Cashew Trail Mix(1)

Deluxe Nut Mix(1)

Light Butter(1)

Danish Butter(1)

Chocolate Chip Shortbread(1)

Shortbread Fingers(1)

Honey Wheat(1)

Berry Mix(1)

Brown Sugar Cinnamon(1)

Dill Pickle Cashews(1)

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

Apple Cinnamon(1)

Oreo(1)

Jalapeno Cashews(1)

Salt & Pepper Cashews(1)

Salt & Pepper(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Original Fig(1)

Golden Oat(1)

Sweet 'N Salty Mix(1)

Sweet 'N Spicy; Mango Pineapple; Yogurt Apple Nut(1)

Sweet Potato with Sea Salt(1)

Multigrain with Sea Salt(1)

Chocolate Turtle(1)

Chocolate/Peanut Butter(1)

Vanilla Crème(1)

Raspberry(1)

Traditional Mix(1)

Cocoa Roast Almonds(1)

Cocoa Roasted Almonds(1)

Pepper Jack Cheese(1)

Frosted Strawberry(1)

Cheddar(1)

Frosted Blueberry(1)

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

Zesty Ranch(1)

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

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

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

Mini Fudge Stripes(1)

Cheese & Peanut Butter(1)

Traditional(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

Salty Sweet Mix(1)

Vanilla(1)

Original Salty Cracker(1)

Club & Cheddar Cheese(1)

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

Reduced Fat(1)

Crunchy(1)

 
Manufacturer Part Number

00073(2)

00087(1)

00089(1)

00092(1)

00082(1)

80314(1)

04738(1)

1284253(1)

00095(1)

80401(1)

00097(1)

105511(1)

105512(1)

3598(1)

105510(1)

01570(1)

456268(1)

00098(1)

00679(1)

00096(1)

67652(1)

32430(1)

44355(1)

44366(1)

20871(1)

14867(1)

25719(1)

25726(1)

14672(1)

44375(1)

44443(1)

52347(1)

52546(1)

52547(1)

45095(1)

44463(1)

44451(1)

44458(1)

375(1)

53005(1)

884624(1)

06833(1)

06834(1)

07708(1)

07210(1)

00026(1)

00027(1)

01670(1)

011037(1)

900015(1)

827582(1)

159200201(1)

827612(1)

1011039(1)

900362(1)

900020(1)

900021(1)

900022(1)

77700(1)

72200(1)

042722C35S(1)

070146A25M(1)

072142A25X(1)

042322F2OA(1)

04474(1)

6270(1)

W-116(1)

W1537D(1)

072142WTV(1)

601049(1)

827562(1)

21812PK(1)

71100(1)

13539(1)

1051900(1)

00408(1)

05051(1)

98067CT(1)

93646(1)

16686(1)

24680(1)

24696(1)

12592(1)

30378(1)

07737(1)

15923(1)

30357(1)

27182(1)

28781(1)

33825(1)

34325(1)

34325CT(1)

33725(1)

33664(1)

33364(1)

33525(1)

33625(1)

05061(1)

04068(1)

SN14852(1)

SN14858(1)

SN14868(1)

SN14848(1)

SN08387(1)

81233(1)

81237(1)

SN08361(1)

59636(1)

00176(1)

02908BX(1)

02946(1)

03744(1)

02908(1)

02104(1)

00470(1)

00798(1)

53664(1)

54325(1)

21167(1)

21771(1)

26547(1)

21165(1)

21163(1)

12653(1)

17120(1)

18251(1)

31031(1)

31131(1)

827548(1)

827553(1)

827695(1)

827545(1)

827544(1)

31732(1)

40975(1)

51158(1)

12233(1)

122264(1)

86364(1)

93064(1)

93364(1)

84325(1)

84170(1)

57690(1)

57706(1)

80895(1)

93817(1)

93917(1)

10003(1)

10892(1)

12061(1)

01008(1)

01866(1)

94017(1)

1160588(1)

98067(1)

 
Country of Origin

US(143)

IN(7)

GB(3)

ID(2)

DE(1)

CA(1)

 
Capacity (Volume)

1.375 oz(2)

3 oz(1)

1 oz(1)

1.75 oz(1)

 
Capacity (Weight)

1.5 oz(20)

2 oz(13)

5 oz(8)

1 oz(7)

3.2 oz(5)

2.5 oz(5)

1.8 oz(5)

1 1/2 oz(4)

1.76 oz(4)

0.62 oz(4)

0.8 oz(4)

1.75 oz(4)

0.63 oz(3)

1.25 oz(3)

0.7 oz(3)

1.38 oz(3)

32 oz(3)

3.25 oz(2)

24 oz(2)

44 oz(2)

8 oz(2)

4.5 oz(2)

5.5 oz(2)

3.67 oz(2)

1.2 oz(2)

6.2 oz(1)

34 oz(1)

2.17 oz(1)

0.9 oz(1)

12 oz(1)

2.2 oz(1)

38 oz(1)

1.75 oz; 1.5 oz(1)

16 oz(1)

15 oz(1)

58 oz(1)

14 oz(1)

1.4 oz(1)

50 oz(1)

1.02 oz(1)

1.0 oz(1)

1.44 oz(1)

48 oz(1)

0.56 oz(1)

1.1 oz(1)

0.2 oz(1)

.39 oz(1)

3.9 oz(1)

2.4 oz(1)

8-1 3/4 oz; 16-1 1/2 oz(1)

3.75 oz(1)

1.7 oz(1)

.78 oz(1)

0.74 oz(1)

0.22 oz(1)

2.32 oz(1)

40 oz(1)

22 oz(1)

1.5 oz; 2 oz(1)

3.71 oz(1)

1.3 oz(1)

3.52 oz(1)

3 oz(1)

26 oz(1)

 
Food Type

Nuts(39)

Cookies(28)

Crackers(21)

Snack(14)

Chips(13)

Popcorn(11)

Pretzels(6)

Potato Chips(4)

Pastry(3)

Snack Bar(2)

Breakfast Biscuits(2)

Trail Mix(2)

Cereal Bar(2)

Nut Butter(2)

Puffed Rice(1)

Snack Mix(1)

Potato Chip(1)

Rice Krispy Treat(1)

Veggie Straw(1)

Apple Straw(1)

Snacks(1)

Dried Fruit(1)

 
 
 

© 2019-2020 Office Solutions & Innovations, Inc., All Rights Reserved