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

Currently Filtered by

Category

Beverage Straws And Stir Sticks

Refine Search
  GO
 
Brand

Universal(8)

Oxford(7)

deflecto(5)

Samsill(5)

Advantus(3)

Durable(3)

Vaultz(3)

Rolodex(3)

Artistic(2)

C-Line(2)

Kantek(1)

 
For Use With

Index Cards(9)

TELINDEX 241902 Cards(2)

Universal Index Cards(2)

TELINDEX 241902 Address Cards(1)

Rolodex 67691 Business Card Sleeve Refill(1)

5 3/4" x 7 3/4" Refill Pages(1)

 
Country of Origin

CN(31)

PL(3)

VN(3)

MX(3)

IN(2)

 
Height

1.75"(2)

3.38"(2)

3.63"(2)

5.75"(2)

5"(2)

3.75"(2)

6"(2)

3.56"(2)

3.5"(2)

9.75"(1)

5.08"(1)

10.13"(1)

2.13"(1)

2.5"(1)

1.38"(1)

7.75"(1)

10"(1)

3"(1)

11.13"(1)

10.25"(1)

4.38"(1)

5.38"(1)

1.81"(1)

5.33"(1)

6.75"(1)

4.75"(1)

5.25"(1)

2"(1)

4.63"(1)

4.25"(1)

8.06"(1)

4.5"(1)

 
Width

4"(4)

8.75"(2)

4.75"(2)

5.5"(2)

6.5"(2)

7"(2)

5.63"(2)

5.13"(2)

5"(1)

6.38"(1)

6.78"(1)

3.78"(1)

4.25"(1)

3.75"(1)

5.75"(1)

4 3/4"(1)

4 1/4"(1)

10.25"(1)

6.25"(1)

9"(1)

3.88"(1)

8.13"(1)

8.63"(1)

5.38"(1)

7.25"(1)

6"(1)

7.88"(1)

3.94"(1)

7.78"(1)

8.5"(1)

3"(1)

 
Depth

3.5"(4)

11"(3)

9.31"(2)

5"(2)

4.78"(2)

1.33"(2)

1.88"(2)

3.88"(2)

1.63"(1)

4"(1)

5.5"(1)

3.63"(1)

1.38"(1)

6.38"(1)

7.13"(1)

3.75"(1)

6.75"(1)

5.61"(1)

1.81"(1)

8.25"(1)

3.38"(1)

3.25"(1)

4.25"(1)

1.25"(1)

 
Color(s)

Black(20)

Clear(7)

Black/White Agate(3)

Assorted(2)

Translucent Black(2)

Black/Blue(2)

White(1)

Gray/White(1)

Graphite/Black(1)

Black/Graphite(1)

Black/Silver(1)

Ebony(1)

 
Material(s)

Plastic(18)

Metal(4)

Polypropylene(3)

Aluminum/Chrome/Laminate/Plywood(3)

Reinforced Board(3)

Leather(3)

Perforated Steel(2)

Vinyl(2)

Acrylic(1)

Poly(1)

Vinyl/Brass(1)

Metal/Plastic(1)

 
Card Capacity

400(7)

50(5)

200(4)

500(4)

100(3)

1,200(3)

25(2)

160(2)

300(2)

120(1)

96(1)

250(1)

80(1)

550(1)

450(1)

350(1)

480(1)

600(1)

 
For Card Size

3 x 5(8)

2 x 3.5(7)

4 x 6(6)

Business Card(6)

2.25 x 4(3)

2.88 x 4.13(3)

5 x 8(3)

2" x 3 1/2"(2)

6 x 9(1)

1.75 x 3.25(1)

2.63 x 4(1)

3.5 x 2(1)

 
Card Holder Type

Business Card Holder(11)

Card File Box With Hinged Lid(6)

Card File Box With Lift-Off Lid(5)

Index Card(4)

Open Rotary Business Card File(3)

Business Card Binder(3)

Business Card Book(2)

Index Card Box(2)

Open Tray Address Card File(1)

Open Tray Business Card File(1)

Note Card Case(1)

Open Rotary Card File(1)

Business Card Wallet(1)

Covered Tray Business Card File(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander