Banner1 Banner1
 
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_36` 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(10)

Nabisco(9)

Sunshine(6)

Planters(5)

Sahale Snacks(5)

Keebler(4)

Kellogg's(4)

Office Snax(3)

Pepperidge Farm(2)

Frito-Lay(2)

Chex Mix(2)

Grandma's(2)

Austin(2)

Walkers(2)

Pop Secret(2)

Paramount Farms(2)

popchips(1)

SkinnyPop Popcorn(1)

Stauffer's(1)

Stacy's(1)

Royal Dansk(1)

Biscoff(1)

SunChips(1)

Knott's Berry Farm(1)

Rold Gold(1)

Kettle Brand(1)

Sensible Portions(1)

Utz(1)

 
Packing Type

Bag(26)

Pack(20)

Box(8)

Tube Package(3)

Packs(3)

Tub(2)

Pouch(2)

Bar(1)

Packet(1)

Canister(1)

Tin Container(1)

Can(1)

Jar(1)

Container(1)

 
Flavor

Original(11)

Peanut Butter(3)

Cheddar Cheese(2)

Dry Roasted Almonds(2)

Chocolate(2)

White Cheddar(2)

Roasted & Salted(2)

Original Marshmallow(2)

Chocolate Chip Shortbread(1)

Shortbread Fingers(1)

Danish Butter(1)

Cheddar Mix(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)

Assorted(1)

Caramel(1)

Cinnamon/Honey(1)

Barbeque; Sea Salt(1)

Dry Roasted & Salted(1)

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

Tropical Fruit & Nut(1)

Nut & Chocolate(1)

Mixed Nuts(1)

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

Cheese(1)

Tangerine Vanilla(1)

Honey Glazed Almond(1)

Cashew Pom Vanilla(1)

Classic Fruit Nut(1)

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

Frosted Strawberry(1)

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

Roasted & Salted Cashew Nuts(1)

Original Fig(1)

Sea Salt(1)

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

Butter(1)

Homestyle(1)

Natural Almonds(1)

All Natural Almonds(1)

Deluxe Mixed Nuts(1)

Walnuts and Almonds(1)

Cocoa Roast Almonds(1)

Sea Salt and Pepper Cashews(1)

Vanilla Cream(1)

Cashews(1)

Traditional(1)

Chocolate Chip(1)

Reduced Fat(1)

Club & Cheddar Cheese(1)

Cheese & Peanut Butter(1)

Toast & Peanut Butter(1)

Mini Fudge Stripes(1)

Raspberry(1)

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

Raspberry Crumble Cashew Trail Mix(1)

 
Manufacturer Part Number

SN14839(1)

00073(1)

04474(1)

W1537D(1)

W-116(1)

53005(1)

375(1)

00082(1)

1284253(1)

072142WTV(1)

04738(1)

456268(1)

92268(1)

67652(1)

52546(1)

52347(1)

070146A25M(1)

00408(1)

32430(1)

06834(1)

900362(1)

900022(1)

900021(1)

900020(1)

900015(1)

011037(1)

06833(1)

1051900(1)

884624(1)

07708(1)

01670(1)

00027(1)

00026(1)

21812PK(1)

13539(1)

45095(1)

14867(1)

59636(1)

33364(1)

84325(1)

84170(1)

54325(1)

53664(1)

34325(1)

33664(1)

28781(1)

93817(1)

27182(1)

12592(1)

30357(1)

03744(1)

02104(1)

00798(1)

00470(1)

93364(1)

94017(1)

827695(1)

21167(1)

827553(1)

827545(1)

40975(1)

31732(1)

26547(1)

21771(1)

21165(1)

1160588(1)

21163(1)

17120(1)

12653(1)

12233(1)

122264(1)

10892(1)

10003(1)

827612(1)

 
Country of Origin

US(70)

GB(2)

IN(1)

ID(1)

 
Capacity (Volume)

1 oz(1)

 
Capacity (Weight)

1.5 oz(17)

2 oz(8)

1 oz(5)

5 oz(5)

1.75 oz(4)

1.8 oz(3)

44 oz(2)

1.2 oz(2)

0.63 oz(2)

2.5 oz(2)

1.25 oz(2)

3.75 oz(1)

1.4 oz(1)

12 oz(1)

0.8 oz(1)

2.2 oz(1)

1.02 oz(1)

32 oz(1)

15 oz(1)

1.75 oz; 1.5 oz(1)

40 oz(1)

48 oz(1)

0.22 oz(1)

1.5 oz; 1.13 oz(1)

1.5 oz; 2 oz(1)

3.71 oz(1)

3.67 oz(1)

1.3 oz(1)

.78 oz(1)

0.56 oz(1)

1.38 oz(1)

2.4 oz(1)

24 oz(1)

 
Food Type

Nuts(20)

Cookies(17)

Crackers(15)

Snack(6)

Chips(4)

Popcorn(3)

Pretzels(2)

Trail Mix(2)

Veggie Straw(1)

Rice Krispy Treat(1)

Pastry(1)

Potato Chips(1)

Snack Mix(1)

 
 
 

© 2020-2021 Legal Name, All Rights Reserved