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

Currently Filtered by

Category

Beverage Straws Stir Sticks

Refine Search

  GO
 
Brand

Eco-Products(7)

Dixie(5)

Genuine Joe(5)

Royal(3)

D&W(2)

Starbucks(2)

Office Snax(1)

 
Color

White(12)

Translucent(4)

Red(3)

Clear(3)

Natural(3)

Blue(2)

Tan(1)

Green(1)

Woodgrain(1)

 
Size

5.50" Length(5)

7.75" Length(5)

7.50" Length(2)

7.75" Length x 0.25" Diameter(2)

7" Length(2)

7.75" Length x 0.24" Diameter(2)

10.25" Length(1)

5" Length(1)

7.75" Length x 0.22" Diameter(1)

 
Recycled

No(25)

 
Packaged Quantity

10000 / Carton(4)

1000 / Box(4)

500 / Box(3)

2000 / Carton(2)

40000 / Carton(1)

1000 / Pack(1)

5000 / Carton(1)

3200 / Carton(1)

12000 / Carton(1)

6000 / Carton(1)

600 / Pack(1)

1200 / Carton(1)

1600 / Carton(1)

1000 / Carton(1)

500 / Pack(1)

50 / Pack(1)

 
Assembly Required

No(25)

 
Weight (Approximate)

4 oz(1)

 
Compatibility

Eco-Products GreenStripe 9 oz. Through 24 oz. Cold Cups(1)

 
Recycled Content

0%(1)

No(1)

 
Diameter

0.2"(1)

 
Quantity Per Container

10(1)

 
Manufacturer Part Number

58944(1)

58944CT(1)

58925CT(1)

58925(1)

20050CT(1)

STR5(1)

R810BX(1)

11064122(1)

11007879(1)

R825(1)

R810CT(1)

NTSTC10CCT(1)

NTSTC10C(1)

JW74CT(1)

DSTGW4300T(1)

15000444(1)

HS5CC(1)

HS551CT(1)

GDSFW4400(1)

EPFLCC(1)

EPSTP7BLURCT(1)

EPSTP7BLUR(1)

EPSTP76WHT(1)

EPSTP76UWH(1)

HS551(1)

 
Country of Origin

China(13)

United States(11)

Taiwan(1)

 
Material

Plastic(9)

Paper(4)

Birch Wood(3)

Wood(3)

Polypropylene(3)

 
Height

7"(1)

 
Container Type

Pack(1)

 
 
 

© 2019-2020 Panola Paper Co, All Rights Reserved