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_27` 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(18)

Nabisco(16)

Kellogg's(9)

Sunshine(7)

Sahale Snacks(5)

Planters(5)

Office Snax(5)

Keebler(5)

Paramount Farms(4)

popchips(4)

Pop Secret(4)

Miss Vickie's(4)

Austin(3)

Homefree(3)

Stauffer's(3)

Stacy's(2)

Nutella(2)

THIS BAR SAVES LIVES™(2)

Shultz(2)

Walkers(2)

Pepperidge Farm(2)

Frito-Lay(2)

Doritos(2)

Food Should Taste Good(2)

Kar's(2)

Chex Mix(2)

Grandma's(2)

Cheetos(2)

Pirate's Booty(1)

Sqwincher(1)

General Mills(1)

Knott's Berry Farm(1)

Sensible Portions(1)

SkinnyPop Popcorn(1)

Pringles(1)

Kettle Brand(1)

Lay's(1)

Royal Dansk(1)

Pop Weaver(1)

Dolcetto(1)

Tostitos(1)

Biscoff(1)

SunChips(1)

Rold Gold(1)

Annie's Homegrown(1)

 
Packing Type

Bag(54)

Pack(37)

Box(9)

Tub(4)

Tube Package(4)

Pouch(3)

Canister(3)

Packs(3)

Single-Serve Tub(2)

Individually Wrapped Bar(2)

Tube(2)

Packets(2)

Carton(1)

Yes(1)

Packet(1)

Single-Serve Bag(1)

Tin Container(1)

Resealable Bag in Box(1)

Can(1)

Jar(1)

Bar(1)

 
Flavor

Original(14)

Peanut Butter(6)

Chocolate Chip(5)

Roasted & Salted(3)

Assorted(3)

Cheese(3)

Original Marshmallow(3)

Chocolate(3)

Sea Salt(3)

Hazelnut/Cocoa(2)

Movie Theater Butter(2)

Sriracha Cashews(2)

All Natural Almonds(2)

Cashews(2)

Golden Oat(2)

Blueberry(2)

Dry Roasted Almonds(2)

Cocoa Roast Almonds(2)

White Cheddar(2)

Nacho Cheese(2)

Jalapeno Cashews(2)

Honey Wheat(1)

Danish Butter(1)

Cheddar(1)

Extra Butter(1)

Berry Mix(1)

Salted(1)

Shortbread Fingers(1)

Caramel(1)

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

Parmesan Garlic & Herb(1)

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

Vanilla Cream(1)

Cinnamon/Honey(1)

Baked Cheddar(1)

Chocolate Chip Shortbread(1)

Mixed Nuts(1)

Dark Chocolate & Cherry(1)

Raspberry Crumble Cashew Trail Mix(1)

Classic Fruit Nut(1)

Cashew Pom Vanilla(1)

Honey Glazed Almond(1)

Tangerine Vanilla(1)

Salted Nuts(1)

Nut & Chocolate(1)

Dry Roasted & Salted(1)

Tropical Fruit & Nut(1)

Sour Cream & Onion(1)

Barbeque(1)

Barbeque; Sea Salt(1)

Smokehouse BBQ(1)

Cheddar Cheese(1)

Aged White Cheddar(1)

Salt & Pepper(1)

Barbecue(1)

Chocolatey Fudge; Strawberry(1)

Sea Salt & Vinegar(1)

Fig Newton(1)

Deluxe Mixed Nuts(1)

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

Walnuts and Almonds(1)

Roasted & Salted Cashew Nuts(1)

Jalapeno(1)

Mini Fudge Stripes(1)

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

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

Zesty Ranch(1)

Frosted Strawberry(1)

Frosted Blueberry(1)

Multigrain with Sea Salt(1)

Toast & Peanut Butter(1)

Sea Salt and Pepper Cashews(1)

Cheese & Peanut Butter(1)

Club & Cheddar Cheese(1)

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

Reduced Fat(1)

Original Salty Cracker(1)

Vanilla(1)

Chocolate Chip; Double Chocolate Chip; Vanilla(1)

Madagascar Vanilla & Almond & Honey(1)

 
Manufacturer Part Number

00073(2)

52347(1)

3598(1)

105512(1)

00679(1)

00095(1)

00092(1)

00082(1)

80401(1)

80314(1)

04738(1)

456268(1)

92268(1)

62737(1)

52547(1)

52546(1)

45095(1)

53005(1)

44458(1)

44451(1)

44446(1)

44443(1)

44441(1)

44375(1)

44366(1)

32430(1)

30501(1)

20871(1)

14867(1)

14672(1)

98067CT(1)

98067(1)

375(1)

6270(1)

827695(1)

01670(1)

00443BX(1)

159200201(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

11017(1)

10173(1)

011037(1)

06834(1)

06833(1)

07708(1)

07210(1)

00027(1)

W-116(1)

601049(1)

W1537D(1)

04474(1)

070146A25M(1)

072142A25X(1)

072142WTV(1)

091842A25S(1)

00408(1)

00026(1)

13539(1)

827562(1)

21812PK(1)

71100(1)

72200(1)

77700(1)

93646(1)

827553(1)

81233(1)

03744(1)

34325(1)

33825(1)

33725(1)

33664(1)

33625(1)

33364(1)

28783(1)

28781(1)

27182(1)

12592(1)

30357(1)

52220(1)

04068(1)

03745(1)

02946BX(1)

53664(1)

02946(1)

02908BX(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)

34325CT(1)

54325(1)

827545(1)

12061(1)

40975(1)

31732(1)

31031(1)

26547(1)

24913(1)

21771(1)

21167(1)

21165(1)

21163(1)

18251(1)

17120(1)

12653(1)

12233(1)

122264(1)

10892(1)

57706(1)

93917(1)

84170(1)

84325(1)

86364(1)

89426(1)

93364(1)

93817(1)

94017(1)

10104(1)

94217(1)

01305(1)

01866(1)

01873(1)

01008(1)

10003(1)

00444BX(1)

 
Country of Origin

US(125)

IN(7)

ID(2)

GB(2)

DE(1)

CA(1)

 
Capacity (Volume)

1.38 oz(4)

3 oz(1)

 
Capacity (Weight)

1.5 oz(24)

2 oz(12)

5 oz(6)

1.4 oz(5)

1.25 oz(5)

1.75 oz(5)

1.76 oz(5)

1 oz(5)

2.5 oz(4)

1.8 oz(4)

0.8 oz(4)

0.62 oz(3)

0.63 oz(3)

3 oz(2)

3.75 oz(2)

1.38 oz(2)

32 oz(2)

3.25 oz(2)

3.67 oz(2)

1.1 oz(2)

1.2 oz(2)

24 oz(2)

40 oz(1)

38 oz(1)

15 oz(1)

44 oz(1)

0.7 oz(1)

12 oz(1)

58 oz(1)

1.44 oz(1)

2.2 oz(1)

0.22 oz(1)

1.02 oz(1)

2.32 oz(1)

0.74 oz(1)

1.5 oz; 1.13 oz(1)

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

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

5.5 oz(1)

1.7 oz(1)

2.4 oz(1)

0.56 oz(1)

3.2 oz(1)

0.2 oz(1)

2.875 oz(1)

0.39 oz(1)

.78 oz(1)

1.3 oz(1)

48 oz(1)

3.71 oz(1)

1.5 oz; 2 oz(1)

16 oz(1)

 
Food Type

Trail Mix, Nuts & Seeds(35)

Crackers(27)

Chips(23)

Cookies(22)

Nutrition & Snack Bars(10)

Popcorn(6)

Pretzels(5)

Danish/Pastries(2)

Nut Butters(2)

Cracker(1)

Pastry(1)

Snack(1)

Fruit Snacks(1)

Potato Chip(1)

Frozen Treats(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved