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

Planters(6)

Sunshine(6)

Kellogg's(6)

Sahale Snacks(5)

Keebler(5)

Office Snax(4)

Pepperidge Farm(3)

popchips(3)

Chex Mix(3)

Paramount Farms(3)

Pop Secret(3)

Shultz(2)

Walkers(2)

Food Should Taste Good(2)

Miss Vickie's(2)

Stauffer's(2)

Grandma's(2)

Austin(2)

Kar's(2)

Snyder's(2)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Pop Weaver(1)

Sqwincher(1)

Royal Dansk(1)

Annie's Homegrown(1)

Frito-Lay(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(34)

Box(7)

Canister(4)

Tub(4)

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

Peanut Butter(5)

Chocolate Chip(3)

Roasted & Salted(3)

Sea Salt(3)

Original Marshmallow(3)

Chocolate(3)

Dry Roasted Almonds(2)

All Natural Almonds(2)

Cheese(2)

Cheddar Cheese(2)

Cashews(2)

White Cheddar(2)

Blueberry(2)

Assorted(2)

Honey Wheat(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)

Hazelnut/Cocoa(1)

Caramel(1)

Cinnamon/Honey(1)

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

Salted(1)

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

Vanilla Cream(1)

Extra Butter(1)

Smokehouse BBQ(1)

Danish Butter(1)

Cheddar(1)

Shortbread Fingers(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)

Chocolate Chip Shortbread(1)

Tropical Fruit & Nut(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Baked Cheddar(1)

Aged White Cheddar(1)

Dry Roasted & Salted(1)

Nacho Cheese(1)

Club & Cheddar Cheese(1)

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

Salt & Pepper Cashews(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)

Golden Oat(1)

Fig Newton(1)

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

Butter(1)

Homestyle(1)

Natural Almonds(1)

Jalapeno Cashews(1)

Sriracha Cashews(1)

Frosted Strawberry(1)

Original Salty Cracker(1)

Mini Fudge Stripes(1)

Toast & Peanut Butter(1)

Cheese & Peanut Butter(1)

Multigrain with Sea Salt(1)

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

Reduced Fat(1)

Traditional(1)

Deluxe Mixed Nuts(1)

Sea Salt and Pepper Cashews(1)

Roasted & Salted Cashew Nuts(1)

Cocoa Roasted Almonds(1)

Cocoa Roast Almonds(1)

Movie Theater Butter(1)

Walnuts and Almonds(1)

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

00073(2)

80401(1)

04474(1)

W1537D(1)

W-116(1)

6270(1)

53005(1)

375(1)

3598(1)

105512(1)

00679(1)

00095(1)

00082(1)

1284253(1)

072142A25X(1)

04738(1)

456268(1)

67652(1)

52546(1)

52347(1)

45095(1)

44451(1)

44443(1)

44375(1)

44366(1)

32430(1)

20871(1)

070146A25M(1)

072142WTV(1)

98067(1)

06833(1)

159200201(1)

827582(1)

1011039(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

11017(1)

011037(1)

06834(1)

884624(1)

601049(1)

07708(1)

07210(1)

01670(1)

00027(1)

00026(1)

72200(1)

71100(1)

21812PK(1)

827562(1)

13539(1)

1051900(1)

00408(1)

14867(1)

827695(1)

81233(1)

02946(1)

33725(1)

33664(1)

33625(1)

33364(1)

28781(1)

27182(1)

12592(1)

30357(1)

52220(1)

04068(1)

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

827553(1)

122264(1)

827545(1)

40975(1)

31732(1)

26547(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

17120(1)

12653(1)

12233(1)

12061(1)

53664(1)

10892(1)

10003(1)

01008(1)

1160588(1)

94017(1)

93817(1)

93364(1)

86364(1)

84325(1)

84170(1)

57706(1)

54325(1)

827612(1)

 
Country of Origin

US(107)

IN(5)

ID(2)

GB(2)

CA(1)

 
Capacity (Volume)

1.38 oz(2)

3 oz(1)

 
Capacity (Weight)

1.5 oz(20)

2 oz(11)

1 oz(7)

5 oz(6)

1.75 oz(5)

2.5 oz(4)

1.76 oz(4)

0.8 oz(3)

0.63 oz(3)

0.62 oz(3)

1.8 oz(3)

1.4 oz(2)

1.25 oz(2)

24 oz(2)

44 oz(2)

3.75 oz(2)

32 oz(2)

1.2 oz(2)

15 oz(1)

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

16 oz(1)

58 oz(1)

2.32 oz(1)

2.2 oz(1)

1.44 oz(1)

1.75 oz; 1.5 oz(1)

12 oz(1)

50 oz(1)

0.7 oz(1)

40 oz(1)

1.02 oz(1)

1.5 oz; 2 oz(1)

0.22 oz(1)

0.39 oz(1)

2.4 oz(1)

1.7 oz(1)

5.5 oz(1)

0.56 oz(1)

3.2 oz(1)

0.2 oz(1)

.78 oz(1)

1.38 oz(1)

0.74 oz(1)

1.3 oz(1)

3.67 oz(1)

48 oz(1)

3 oz(1)

3.71 oz(1)

0.9 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(32)

Crackers(27)

Chips(18)

Cookies(17)

Nutrition & Snack Bars(7)

Pretzels(6)

Popcorn(5)

Danish/Pastries(1)

Snack Variety Packs(1)

Nut Butters(1)

Pretzel(1)

Frozen Treats(1)

 
 
 

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