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_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 (`manufacturer_id` = "790") 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 '%OFFICESNAXINC' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('OFFICESNAXINC' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+OFFICESNAXINC' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"OFFICESNAXINC"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"OFFICESNAXINC"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"OFFICESNAXINC"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"OFFICESNAXINC"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+OFFICESNAXINC' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='OFFICESNAXINC',`category_4` ='OFFICESNAXINC') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'OFFICESNAXINC,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('OFFICESNAXINC', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Manufacturer

OFFICE SNAX INC

Refine Search

  GO
 
Category Filter

Candy, Gum & Mints(17)

Coffee Condiments(17)

Snacks(16)

Water(6)

Meals & Snack Bars(3)

Coffee(2)

Straws/Stems/Sticks(1)

Pet Foods(1)

 
Brand

Office Snax(57)

Sugar in the Raw(3)

Pop Weaver(3)

 
Color(s)

White(1)

 
Quantity

24 per carton(3)

1 each(2)

63 per carton(1)

3 per carton(1)

12 per carton(1)

 
Size

5"(1)

 
Packing Type

Tub(25)

Packet(11)

Canister(8)

Bottle(6)

Bag(4)

Bowl(3)

Box(3)

Packets(1)

Carton(1)

 
Flavor

Regular(10)

Assorted(6)

Natural Spring Water(6)

Soft & Chewy Mix(2)

All Tyme Favorites(2)

Sourdough(2)

Original Blend(2)

Salted(2)

Extra Butter(1)

Light Butter(1)

Peanut Butter(1)

Butter(1)

Jelly Beans(1)

Starlight Mints, Peppermint(1)

Original(1)

Gummy Bears(1)

Maple(1)

Fancy Mix(1)

Starlight Mints, Spearmint(1)

Happy Heart Mix(1)

Peppermint Puffs(1)

Cashews(1)

Plain(1)

Butterscotch Creamy & Smooth Delights(1)

Wrapped Asst. Fruit Slices(1)

Pistachios(1)

Sesame Snax Mix(1)

Brown Sugar(1)

Cinnamon/Honey(1)

Deluxe Nut Mix(1)

Wasabi Party Mix(1)

Pure Honey(1)

 
Beverage Type

Water(6)

Coffee(2)

 
 
 

© 2019-2020 Onestop, Inc., All Rights Reserved