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_19` 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

Emerald(13)

Nabisco(12)

Sunshine(6)

Kellogg's(6)

Planters(5)

Keebler(5)

Sahale Snacks(5)

Paramount Farms(4)

Miss Vickie's(4)

Pepperidge Farm(3)

popchips(3)

Office Snax(3)

Pop Secret(3)

Chex Mix(3)

Austin(2)

Grandma's(2)

Snyder's(2)

Food Should Taste Good(2)

Kar's(2)

Shultz(2)

Frito-Lay(2)

Stauffer's(1)

Pop Weaver(1)

Sqwincher(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Walkers(1)

Royal Dansk(1)

Annie's Homegrown(1)

Dolcetto(1)

Nutella(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(44)

Pack(30)

Box(7)

Tub(4)

Tube Package(3)

Canister(3)

Packs(3)

Packets(2)

Pouch(2)

Resealable Bag in Box(1)

Jar(1)

Can(1)

Packet(1)

Tin Container(1)

Single-Serve Bag(1)

Single-Serve Tub(1)

Bar(1)

Carton(1)

Container(1)

 
Flavor

Original(15)

Peanut Butter(4)

Chocolate(3)

Original Marshmallow(3)

Roasted & Salted(3)

Sea Salt(3)

Cheese(2)

Cheddar Cheese(2)

Blueberry(2)

Dry Roasted Almonds(2)

Assorted(2)

Chocolate Chip(2)

All Natural Almonds(2)

White Cheddar(2)

Hazelnut/Cocoa(1)

Cinnamon/Honey(1)

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

Danish Butter(1)

Caramel(1)

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

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

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

Vanilla Cream(1)

Smokehouse BBQ(1)

Extra Butter(1)

Cheddar(1)

Honey Wheat(1)

Nut & Chocolate(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Tangerine Vanilla(1)

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

Mixed Nuts(1)

Tropical Fruit & Nut(1)

Shortbread Fingers(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Aged White Cheddar(1)

Sea Salt & Vinegar(1)

Dry Roasted & Salted(1)

Salt & Pepper(1)

Toast & Peanut Butter(1)

Jalapeno(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 Crème(1)

Original Fig(1)

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

Butter(1)

Homestyle(1)

Natural Almonds(1)

Salt & Pepper Cashews(1)

Deluxe Mixed Nuts(1)

Movie Theater Butter(1)

Nacho Cheese(1)

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

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

Frosted Strawberry(1)

Mini Fudge Stripes(1)

Multigrain with Sea Salt(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

Reduced Fat(1)

Cocoa Roast Almonds(1)

Original Salty Cracker(1)

Traditional(1)

Cashews(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

Cocoa Roasted Almonds(1)

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

04738(1)

04474(1)

W-116(1)

6270(1)

53005(1)

375(1)

3598(1)

105512(1)

00679(1)

00082(1)

80314(1)

1284253(1)

456268(1)

072142A25X(1)

92268(1)

67652(1)

52546(1)

52347(1)

45095(1)

44451(1)

44446(1)

44443(1)

44441(1)

44375(1)

44366(1)

070146A25M(1)

072142WTV(1)

20871(1)

884624(1)

159200201(1)

827582(1)

1011039(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

011037(1)

06834(1)

06833(1)

07708(1)

091842A25S(1)

01670(1)

00027(1)

00026(1)

72200(1)

71100(1)

21812PK(1)

827562(1)

13539(1)

1051900(1)

00408(1)

601049(1)

32430(1)

14867(1)

81233(1)

02908BX(1)

53664(1)

34325CT(1)

34325(1)

33725(1)

33664(1)

33364(1)

28781(1)

27182(1)

12592(1)

30357(1)

03744(1)

02908(1)

57706(1)

02104(1)

00798(1)

00470(1)

00176(1)

59636(1)

SN14868(1)

SN14858(1)

SN14839(1)

SN08387(1)

SN08361(1)

81237(1)

54325(1)

84170(1)

98067(1)

17120(1)

827695(1)

827553(1)

827545(1)

40975(1)

31732(1)

26547(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

12653(1)

84325(1)

12233(1)

122264(1)

12061(1)

10892(1)

10003(1)

01008(1)

1160588(1)

94017(1)

93817(1)

93364(1)

86364(1)

827612(1)

 
Country of Origin

US(106)

IN(2)

ID(2)

DE(1)

GB(1)

 
Capacity (Volume)

1.375 oz(4)

1.75 oz(1)

1 oz(1)

3 oz(1)

 
Capacity (Weight)

1.5 oz(19)

2 oz(11)

1 oz(7)

5 oz(6)

2.5 oz(4)

1.75 oz(4)

1.8 oz(4)

0.63 oz(3)

1.25 oz(3)

0.8 oz(3)

1.76 oz(2)

1.2 oz(2)

3.75 oz(2)

24 oz(2)

44 oz(2)

1.44 oz(1)

32 oz(1)

40 oz(1)

0.7 oz(1)

12 oz(1)

2.4 oz(1)

1.4 oz(1)

1.02 oz(1)

1.5 oz; 1.13 oz(1)

58 oz(1)

15 oz(1)

1.75 oz; 1.5 oz(1)

50 oz(1)

0.22 oz(1)

3 oz(1)

1.5 oz; 2 oz(1)

.39 oz(1)

1.38 oz(1)

5.5 oz(1)

0.62 oz(1)

0.56 oz(1)

3.2 oz(1)

0.2 oz(1)

.78 oz(1)

3.71 oz(1)

0.74 oz(1)

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

1.3 oz(1)

3.67 oz(1)

48 oz(1)

1.7 oz(1)

0.9 oz(1)

 
Food Type

Nuts(25)

Cookies(19)

Crackers(18)

Chips(13)

Snack(12)

Pretzels(6)

Popcorn(5)

Potato Chips(4)

Trail Mix(2)

Cereal Bar(1)

Breakfast Biscuits(1)

Veggie Straw(1)

Rice Krispy Treat(1)

Pastry(1)

Nut Butter(1)

Puffed Rice(1)

Snack Mix(1)

 
 
 

© 2020-2021 Office Industries Corporation, All Rights Reserved