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

Emerald(14)

Sunshine(6)

Planters(6)

Kellogg's(6)

Keebler(5)

Sahale Snacks(5)

Paramount Farms(4)

Office Snax(4)

Pop Secret(4)

Chex Mix(3)

popchips(3)

Pepperidge Farm(3)

Shultz(2)

Austin(2)

Grandma's(2)

Stauffer's(2)

Food Should Taste Good(2)

Frito-Lay(2)

Kar's(2)

Walkers(2)

Sqwincher(1)

Snyder's(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Royal Dansk(1)

Annie's Homegrown(1)

Miss Vickie's(1)

Pop Weaver(1)

Dolcetto(1)

Biscoff(1)

SunChips(1)

Stacy's(1)

Doritos(1)

Cheetos(1)

Rold Gold(1)

Tostitos(1)

Pringles(1)

Kettle Brand(1)

Sensible Portions(1)

Knott's Berry Farm(1)

General Mills(1)

Utz(1)

 
Packing Type

Bag(45)

Pack(34)

Box(7)

Tub(4)

Tube Package(3)

Canister(3)

Packs(3)

Packets(2)

Pouch(2)

Tube(1)

Carton(1)

Bar(1)

Packet(1)

Single-Serve Bag(1)

Tin Container(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

Container(1)

 
Flavor

Original(15)

Peanut Butter(5)

Chocolate(3)

Original Marshmallow(3)

Sea Salt(3)

Chocolate Chip(3)

Roasted & Salted(3)

Golden Oat(2)

Blueberry(2)

Sriracha Cashews(2)

Movie Theater Butter(2)

Dry Roasted Almonds(2)

All Natural Almonds(2)

Assorted(2)

Cheddar Cheese(2)

Cashews(2)

Cheese(2)

White Cheddar(2)

Shortbread Fingers(1)

Honey Wheat(1)

Extra Butter(1)

Danish Butter(1)

Salted(1)

Cinnamon/Honey(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)

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

Chocolate Chip Shortbread(1)

Cheddar(1)

Dry Roasted & Salted(1)

Mixed Nuts(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Tangerine Vanilla(1)

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

Salted Nuts(1)

Nut & Chocolate(1)

Salt & Pepper(1)

Tropical Fruit & Nut(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

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

Aged White Cheddar(1)

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

Cheese & Peanut Butter(1)

Vanilla Cream(1)

Walnuts and Almonds(1)

Sweet Potato with Sea Salt(1)

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

Sweet 'N Salty Mix(1)

Cheddar Mix(1)

Traditional Mix(1)

Raspberry(1)

Vanilla Creme(1)

Fig Newton(1)

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

Butter(1)

Homestyle(1)

Natural Almonds(1)

Deluxe Mixed Nuts(1)

Cocoa Roast Almonds(1)

Nacho Cheese(1)

Cocoa Roasted Almonds(1)

Roasted & Salted Cashew Nuts(1)

Sea Salt and Pepper Cashews(1)

Traditional(1)

Original Salty Cracker(1)

Reduced Fat(1)

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

Club & Cheddar Cheese(1)

Multigrain with Sea Salt(1)

Toast & Peanut Butter(1)

Mini Fudge Stripes(1)

Frosted Strawberry(1)

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

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

1284253(1)

04474(1)

W1537D(1)

W-116(1)

6270(1)

53005(1)

375(1)

3598(1)

105512(1)

00679(1)

00095(1)

00082(1)

04738(1)

072142A25X(1)

456268(1)

92268(1)

67652(1)

52546(1)

52347(1)

45095(1)

44443(1)

44375(1)

44366(1)

32430(1)

20871(1)

14867(1)

070146A25M(1)

072142WTV(1)

827695(1)

884624(1)

159200201(1)

827582(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

11017(1)

011037(1)

06834(1)

06833(1)

07708(1)

091842A25S(1)

07210(1)

01670(1)

00027(1)

00026(1)

72200(1)

71100(1)

21812PK(1)

827562(1)

13539(1)

1051900(1)

00408(1)

601049(1)

98067(1)

827553(1)

81233(1)

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

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

33825(1)

34325CT(1)

827545(1)

12061(1)

40975(1)

31732(1)

26547(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

17120(1)

12653(1)

12233(1)

122264(1)

10892(1)

53664(1)

10003(1)

01008(1)

1160588(1)

94017(1)

93917(1)

93817(1)

93364(1)

86364(1)

84325(1)

84170(1)

57706(1)

54325(1)

827612(1)

 
Country of Origin

US(109)

IN(4)

ID(2)

GB(2)

 
Capacity (Volume)

1.38 oz(1)

3 oz(1)

 
Capacity (Weight)

1.5 oz(20)

2 oz(11)

1 oz(7)

5 oz(6)

1.75 oz(6)

1.76 oz(5)

2.5 oz(4)

1.25 oz(4)

0.8 oz(3)

0.63 oz(3)

1.8 oz(3)

1.4 oz(2)

1.2 oz(2)

32 oz(2)

24 oz(2)

3.75 oz(2)

44 oz(2)

12 oz(1)

40 oz(1)

0.7 oz(1)

2.2 oz(1)

1.44 oz(1)

1.5 oz; 1.13 oz(1)

1.02 oz(1)

58 oz(1)

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

15 oz(1)

16 oz(1)

1.75 oz; 1.5 oz(1)

0.22 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

0.2 oz(1)

2.4 oz(1)

0.62 oz(1)

1.7 oz(1)

0.56 oz(1)

3.2 oz(1)

5.5 oz(1)

0.39 oz(1)

1.38 oz(1)

.78 oz(1)

0.74 oz(1)

1.3 oz(1)

3.67 oz(1)

48 oz(1)

3 oz(1)

0.9 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(32)

Crackers(27)

Chips(18)

Cookies(17)

Nutrition & Snack Bars(8)

Popcorn(6)

Pretzels(6)

Danish/Pastries(1)

Snack Variety Packs(1)

Frozen Treats(1)

 
 
 

© 2020-2021 Meadows Office Supply, All Rights Reserved