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

Nabisco(17)

Emerald(13)

Office Snax(10)

Kellogg's(8)

Pop Secret(7)

Keebler(6)

Paramount Farms(6)

Sunshine(6)

Planters(5)

Chex Mix(5)

Austin(4)

Pepperidge Farm(3)

Shultz(3)

Pop Weaver(3)

popchips(3)

Walkers(3)

Sahale Snacks(3)

Homefree(3)

Annie's Homegrown(2)

Sensible Portions(2)

Stacy's(2)

Snyder's(2)

Kar's(2)

KIND(2)

Grandma's(2)

General Mills(2)

Royal Dansk(1)

Stauffer's(1)

Utz(1)

De Beukelaer(1)

SkinnyPop Popcorn(1)

Pirate's Booty(1)

Doritos(1)

Tostitos(1)

Rold Gold(1)

Pringles(1)

Fla-Vor-Ice(1)

Knott's Berry Farm(1)

Kettle Brand(1)

Fritos(1)

Cheetos(1)

Biscoff(1)

Nutella(1)

Lay's(1)

SunChips(1)

Miss Vickie's(1)

Frito-Lay(1)

Dolcetto(1)

 
Packing Type

Bag(64)

Pack(33)

Box(13)

Tub(5)

Packs(5)

Tube Package(3)

Canister(3)

Yes(2)

Tin Container(2)

Packets(2)

Resealable Bag in Box(1)

Jar(1)

Container(1)

Single-Serve Bag(1)

Can(1)

Bar(1)

Tube(1)

Carton(1)

Packet(1)

Variety Pack(1)

Single-Serve Tub(1)

 
Flavor

Original(16)

Peanut Butter(6)

Chocolate Chip(6)

Roasted & Salted(5)

Chocolate(3)

Original Marshmallow(3)

Sea Salt(3)

Homestyle(3)

Extra Butter(2)

Butter(2)

Dry Roasted Almonds(2)

White Cheddar(2)

Cheddar Cheese(2)

Cashews(2)

Salt & Pepper(2)

Movie Theater Butter(2)

Natural Almonds(2)

Toast & Peanut Butter(2)

Blueberry(2)

Sesame Snax Mix(1)

Wasabi Party Mix(1)

Salted(1)

Berry Mix(1)

Pistachios(1)

Shortbread(1)

Deluxe Nut Mix(1)

Cinnamon/Honey(1)

Light Butter(1)

6 Packs Ritz Bits Peanut Butter; 6 Packs Ritz Bits Cheese; 7 Packs Nutter Butter Bites; 7 Packs Mini Nilla Wafers; 7 Packs Mini Oreo; 7 Packs Chips Ahoy(1)

Parmesan Garlic & Herb(1)

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

Vanilla Cream(1)

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

Jalapeno; Salt & Vinegar; Original; Applewood BBQ; Salt & Pepper(1)

Regular(1)

Assorted(1)

Caramel(1)

Hazelnut/Cocoa(1)

Honey Wheat(1)

Mixed Nuts(1)

Nut & Chocolate(1)

Tropical Fruit & Nut(1)

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

Cheese(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Barbeque(1)

Barbeque; Sea Salt(1)

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

Shortbread Fingers(1)

Nacho Cheese(1)

Dry Roasted & Salted(1)

Aged White Cheddar(1)

Baked Cheddar(1)

Cheddar(1)

Hazelnut(1)

Danish Butter(1)

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

Cocoa Roasted Almonds(1)

Cocoa Roast Almonds(1)

Traditional Mix(1)

Salty Sweet Mix(1)

Roasted & Salted Cashew Nuts(1)

Traditional(1)

Corn(1)

Sea Salt and Pepper Cashews(1)

Cheddar Mix(1)

Walnuts and Almonds(1)

Original Fig(1)

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

Apple Cinnamon(1)

Vanilla Crème(1)

Raspberry(1)

Deluxe Mixed Nuts(1)

All Natural Almonds(1)

Chocolate/Peanut Butter(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Double Chocolate Chip(1)

Frosted Strawberry(1)

Brown Sugar Cinnamon(1)

Frosted Blueberry(1)

Pepper Jack Cheese(1)

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

Oreo(1)

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

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

Mini Fudge Stripes(1)

Cocoa & Vanilla(1)

Chocolate Turtle(1)

Original Salty Cracker(1)

Berry Punch; Grape; Lemon-Lime; Orange; Strawberry; Tropical Punch(1)

Sweet 'N Salty Mix(1)

Reduced Fat(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

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

Crunchy(1)

 
Manufacturer Part Number

00073(2)

00087(1)

00089(1)

00092(1)

00082(1)

827558(1)

456268(1)

04738(1)

00095(1)

80314(1)

00096(1)

105510(1)

105511(1)

105512(1)

01570(1)

00679(1)

00097(1)

00098(1)

6775505(1)

67652(1)

25726(1)

14867(1)

20871(1)

25719(1)

98067(1)

827553(1)

827695(1)

32430(1)

44355(1)

52347(1)

52546(1)

52547(1)

45095(1)

44443(1)

44366(1)

44375(1)

310(1)

3598(1)

01670(1)

07708(1)

884624(1)

00027(1)

00026(1)

71100(1)

72200(1)

06833(1)

06834(1)

1011039(1)

827582(1)

827612(1)

900022(1)

900021(1)

011037(1)

900020(1)

21812PK(1)

827562(1)

W-536(1)

042322F2OA(1)

042722C35S(1)

W-116(1)

6270(1)

375(1)

53005(1)

070146A25M(1)

072142A25X(1)

05051(1)

1051900(1)

13539(1)

00408(1)

601049(1)

072142WTV(1)

091842A25S(1)

827548(1)

827545(1)

30357(1)

30378(1)

12592(1)

52220(1)

15923(1)

05344(1)

07737(1)

16686(1)

24680(1)

33664(1)

34325(1)

53664(1)

33364(1)

28781(1)

24696(1)

27182(1)

05343(1)

04068(1)

SN35181(1)

SN35182(1)

SN37301(1)

SN28086(1)

SN16794(1)

SN08361(1)

SN08387(1)

SN43037(1)

59636(1)

02908(1)

02908BX(1)

03744(1)

02104(1)

00798(1)

00176(1)

00470(1)

54325(1)

57690(1)

18251(1)

21163(1)

21165(1)

17120(1)

12653(1)

122264(1)

12233(1)

21167(1)

21771(1)

40975(1)

51158(1)

827544(1)

31732(1)

31131(1)

26547(1)

31031(1)

12061(1)

10892(1)

86364(1)

93064(1)

93364(1)

84325(1)

84170(1)

57706(1)

80895(1)

93817(1)

94017(1)

92100(1)

01008(1)

10003(1)

01948(1)

01873(1)

1160588(1)

01305(1)

00019(1)

 
Country of Origin

US(138)

GB(3)

ID(2)

IN(2)

DE(1)

 
Capacity (Volume)

1 oz(1)

1.375oz(1)

1.375 oz(1)

1.5 oz(1)

1.75 oz(1)

 
Capacity (Weight)

1.5 oz(13)

2 oz(12)

5 oz(8)

1 oz(7)

3.2 oz(5)

1.8 oz(5)

2.5 oz(5)

1 1/2 oz(4)

1.75 oz(4)

0.8 oz(3)

32 oz(3)

0.7 oz(3)

1.4 oz(3)

1.25 oz(3)

1.38 oz(3)

1.76 oz(3)

24 oz(2)

5.5 oz(2)

44 oz(2)

3.67 oz(2)

3.75 oz(2)

0.63 oz(2)

3 oz(2)

8 oz(2)

4.5 oz(2)

1.2 oz(2)

40 oz(1)

22 oz(1)

26 oz(1)

34 oz(1)

38 oz(1)

6.2 oz(1)

12 oz(1)

14 oz(1)

50 oz(1)

58 oz(1)

1.75 oz; 1.5 oz(1)

1.0 oz(1)

1.44 oz(1)

2 1/4 oz(1)

0.9 oz(1)

15 oz(1)

2.17 oz(1)

3.52 oz(1)

0.56 oz(1)

2 lb. Net Weight; 10/1.1 oz, 10/0.95 oz, 10/1.1 oz(1)

1.1 oz(1)

0.95 oz(1)

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

0.81 oz(1)

1.7 oz(1)

2.4 oz(1)

4/5 oz(1)

0.2 oz(1)

.39 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

1.5oz(1)

1.375 oz(1)

48 oz(1)

1.3 oz(1)

.78 oz(1)

0.74 oz(1)

6.75 oz(1)

0.22 oz(1)

 
Food Type

Nuts(31)

Cookies(28)

Crackers(20)

Snack(13)

Popcorn(11)

Chips(10)

Pretzel(4)

Pastry(3)

Pretzels(3)

Cookie(3)

Potato Chip(3)

Snack Bar(2)

Trail Mix(2)

Puffed Rice(1)

Nut Butter(1)

Snack Mix(1)

Dried Fruit(1)

Freezer Bar(1)

Breakfast Biscuit(1)

Breakfast Biscuits(1)

Cereal Bar(1)

Veggie Straw(1)

Apple Straw(1)

Potato Chips(1)

Rice Krispy Treat(1)

Snacks(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved