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','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

Nabisco(15)

Emerald(14)

Kellogg's(8)

THIS BAR SAVES LIVES™(6)

Sunshine(6)

Sahale Snacks(5)

Planters(5)

Keebler(5)

Paramount Farms(4)

Pop Secret(4)

Austin(3)

popchips(3)

Office Snax(3)

Kar's(2)

Chex Mix(2)

Grandma's(2)

Pepperidge Farm(2)

Food Should Taste Good(2)

Stauffer's(2)

Walkers(2)

Frito-Lay(2)

Shultz(2)

Pringles(2)

Pop Weaver(1)

Sqwincher(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Royal Dansk(1)

Annie's Homegrown(1)

Dolcetto(1)

Biscoff(1)

Stacy's(1)

Miss Vickie's(1)

Doritos(1)

Rold Gold(1)

SunChips(1)

Tostitos(1)

Cheez-It(1)

Kettle Brand(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Cheetos(1)

 
Packing Type

Bag(41)

Pack(33)

Box(8)

Individually Wrapped Bar(6)

Canister(4)

Tub(4)

Packs(3)

Pouch(3)

Tube Package(3)

Packets(2)

Tube(1)

Carton(1)

Bag; Canister; Bar(1)

Packet(1)

Single-Serve Bag(1)

Tin Container(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

Bar(1)

 
Flavor

Original(13)

Peanut Butter(5)

Sea Salt(3)

Assorted(3)

Chocolate Chip(3)

Roasted & Salted(3)

Original Marshmallow(3)

Chocolate(3)

Movie Theater Butter(2)

Golden Oat(2)

Blueberry(2)

All Natural Almonds(2)

Cheese(2)

Sriracha Cashews(2)

White Cheddar(2)

Dry Roasted Almonds(2)

Dry Roasted & Salted(1)

Honey Wheat(1)

Chocolate Chip Shortbread(1)

Shortbread Fingers(1)

Aged White Cheddar(1)

Danish Butter(1)

Extra Butter(1)

Salted(1)

Cinnamon/Honey(1)

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

Salt & Pepper(1)

Cheddar(1)

Cheddar Cheese(1)

Cashew Pom Vanilla(1)

Dark Chocolate & Coconut(1)

Dark Chocolate & Peanut Butter(1)

Wild Blueberry & Pistachio(1)

Madagascar Vanilla & Almond & Honey(1)

Dark Chocolate & Cherry(1)

Raspberry Crumble Cashew Trail Mix(1)

Classic Fruit Nut(1)

Honey Glazed Almond(1)

Baked Cheddar(1)

Tangerine Vanilla(1)

Salted Nuts(1)

Mixed Nuts(1)

Nut & Chocolate(1)

Tropical Fruit & Nut(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Vanilla Cream(1)

Cheese & Peanut Butter(1)

Nacho Cheese(1)

Fig Newton(1)

Walnuts and Almonds(1)

Deluxe Mixed Nuts(1)

Natural Almonds(1)

Homestyle(1)

Butter(1)

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

Vanilla Creme(1)

Cocoa Roasted Almonds(1)

Raspberry(1)

Traditional Mix(1)

Cheddar Mix(1)

Sweet 'N Salty Mix(1)

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

Sweet Potato with Sea Salt(1)

Cocoa Roast Almonds(1)

Roasted & Salted Cashew Nuts(1)

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

Club & Cheddar Cheese(1)

Chocolate Chip; Peanut Butter; Vanilla Creme; Oatmeal Raisin;Chocolate Brownie(1)

Frosted Strawberry(1)

Chocolatey Fudge; Strawberry(1)

Mini Fudge Stripes(1)

Toast & Peanut Butter(1)

Multigrain with Sea Salt(1)

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

Sea Salt and Pepper Cashews(1)

Original; Cheese; Sour Cream & Onion(1)

Reduced Fat(1)

Cheddar Sour Cream & Onion; Double Cheese(1)

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

Original Salty Cracker(1)

Cashews(1)

PB&J(1)

 
Manufacturer Part Number

00073(2)

456268(1)

070146A25M(1)

04474(1)

W1537D(1)

W-116(1)

6270(1)

53005(1)

375(1)

3598(1)

105512(1)

00679(1)

00082(1)

04738(1)

92268(1)

072142WTV(1)

52546(1)

52347(1)

45095(1)

44443(1)

44375(1)

44366(1)

32430(1)

30501(1)

20871(1)

14867(1)

98067(1)

827695(1)

072142A25X(1)

091842A25S(1)

827545(1)

011037(1)

00457BX(1)

00447BX(1)

00445BX(1)

00444BX(1)

00443BX(1)

159200201(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

10173(1)

06834(1)

601049(1)

06833(1)

07708(1)

07210(1)

01670(1)

00027(1)

00026(1)

72200(1)

71100(1)

21812PK(1)

827562(1)

13539(1)

00408(1)

827553(1)

40975(1)

81233(1)

02946(1)

33825(1)

33664(1)

33364(1)

28783(1)

28781(1)

27182(1)

12592(1)

30357(1)

52220(1)

04068(1)

03744(1)

02946BX(1)

02908BX(1)

34325CT(1)

02908(1)

02104(1)

00798(1)

00470(1)

00176(1)

59636(1)

SN14868(1)

SN14858(1)

SN14839(1)

SN08387(1)

SN08361(1)

81237(1)

34325(1)

53664(1)

31732(1)

12061(1)

26547(1)

24913(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

17120(1)

14991(1)

12653(1)

12233(1)

122264(1)

11500(1)

54325(1)

11461(1)

10892(1)

10104(1)

10003(1)

01008(1)

94017(1)

93917(1)

93817(1)

93364(1)

86364(1)

84325(1)

84170(1)

57706(1)

00473BX(1)

 
Country of Origin

US(114)

IN(3)

ID(2)

GB(2)

 
Capacity (Volume)

No(1)

1.38 oz(1)

3 oz(1)

 
Capacity (Weight)

1.5 oz(20)

2 oz(11)

1.4 oz(9)

5 oz(6)

1.75 oz(5)

1.76 oz(5)

1 oz(5)

2.5 oz(4)

1.25 oz(4)

0.8 oz(3)

1.8 oz(3)

0.63 oz(3)

24 oz(2)

0.74 oz(2)

1.2 oz(2)

1.38 oz(2)

3.75 oz(2)

44 oz(1)

0.22 oz(1)

32 oz(1)

40 oz(1)

0.7 oz(1)

1.44 oz(1)

12 oz(1)

1.5 oz; 2 oz(1)

2.2 oz(1)

1.02 oz(1)

58 oz(1)

8-1.75 oz; 16-1.5 oz(1)

15 oz(1)

1.5 oz; 1.13 oz(1)

3.71 oz(1)

0.62 oz(1)

3 oz(1)

48 oz(1)

3.67 oz(1)

1.3 oz(1)

5.5 oz(1)

.78 oz(1)

1.7 oz(1)

0.39 oz(1)

0.75 oz(1)

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

0.2 oz(1)

2.4 oz(1)

3.2 oz(1)

0.56 oz(1)

16 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(30)

Crackers(26)

Chips(18)

Cookies(17)

Nutrition & Snack Bars(14)

Popcorn(6)

Pretzels(5)

Danish/Pastries(2)

Cracker(1)

Snacks(1)

Frozen Treats(1)

 
 
 

© 2020-2021 Meadows Office Supply, All Rights Reserved