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

Currently Filtered by

Category

Cups

Refine Search

  GO
 
Brand

Dart(28)

Eco-Products(24)

Dixie(19)

Hefty(8)

Office Settings(2)

Rubbermaid Commercial(2)

NatureHouse(2)

SOLO Cup Company(1)

WNA(1)

 
Warranty

Manufacturer's limited one-year warranty.(2)

Manufacturer's limited lifetime warranty.(1)

Manufacturer's limited three-year no-chip warranty.(1)

 
Special Features

Perfect Pak(4)

Squat(3)

50 Cups/50 White Lids(3)

WiseSize(2)

Bright Assorted Colors-Orange, purple, green and teal.(2)

25 Cups per Bag, 40 Bags per Carton(1)

Individually Wrapped(1)

 
For Use With

Eco-Products EP-HL16-WR(12)

Eco-Products EPCRFL(4)

Dart 16JL, 16SL, 16UL, 16FTLS(4)

Eco-Products EP-HL8-WR(4)

SOLO PET Plastic Dome Lids; SOLO PET Plastic Flat Cold Lids(2)

Dixie 9542500DXCT, TB9542, TP9542(2)

Eco-Products EP-FLCC, EP-DLCC, EP-DLCC-NH(2)

Eco-Products EP-FLCC (Flat Lid), or EP-DLCC (Dome Lid)(2)

NatureHouse FK08, FK09(2)

Dart 16FTLS, 16UL(2)

SOLO OFTL36-0007(2)

TL38B2, TL38R2, LB3081(1)

Dixie D9542, 9542500DX, D9542B(1)

TLB316, TLN316, TLP316, LB3161(1)

SOLO TL38R2-0004, TL38B2-0007(1)

SOLO OFTL31-0007(1)

SOLO OFTL8-0007(1)

Dixie 9542500DXPK(1)

Dixie D9542, TB9542, TP9542B, TP9542, 9542500DX, D9542B(1)

DXED9542, DXETB9542, DXETP9542B, DXETP9542, DXE9542500DX, DXED9542B(1)

Dixie 9542500DX, D9542, D9542B, TB9542, TP9542, TP9542B(1)

DCCPL1N(1)

Dixie D9538, TB9538X, 9538DX, DL9538B(1)

SOLO RPET Plastic Dome Lids; SOLO RPET Plastic Flat Cold Lids(1)

Dart 12JL, 12SL(1)

Dart 16SL, 16FTLS, 16UL, 16EL, 16ELBLK, 16FTL, 16JL, 16LCD, 16LCDH, 16LCDHX, 16RCL(1)

Dart 32SL(1)

Dart 6JL(1)

Dart 8JL, 8FTLS(1)

Dart 8FTLS(1)

Dixie 914LSRD(1)

DXED9542, DXED9542PK, DXED9542B(1)

Dixie TB9538X(1)

Dixie 9538DX, D9538, DL9538B(1)

DXE9542500DX, DXEDL9540, DXEDL9540B, DXETB9540(1)

Dixie 954200DX, 9542500DX, D9542, D9542B, D9542G, TB9542, TP9542(1)

Dixie 954200DX, TP9542(1)

12JL, 12SL, 12UL, 12CLR, 12EL, 12FTL, 12FTLS, 12HDLC(1)

Dixie 9542500DXCT(1)

 
Manufacturer Part Number

100PC(1)

EP-CC9S-GS(1)

3216 CLE(1)

CTM1(1)

CPR16(1)

EPCR9PK(1)

EPCR9(1)

EPCR16PK(1)

EPCR12PK(1)

EPCC9SGSPK(1)

EPCC16GSPK(1)

C20315(1)

EPCC12GSPK(1)

EPBRHC8EWPK(1)

EP-BRHC8-EW(1)

EPBRHC16EWPK(1)

EP-BRHC16-EW(1)

EPBRHC12EWPK(1)

EP-BRHC12-EW(1)

EPBRHC10EWPK(1)

3218 CLE(1)

C20315CT(1)

EPBHC8WAPK(1)

FSIC12J753CT(1)

RP19CT(1)

RP19(1)

TP10DW(1)

OF8BI-0041(1)

OF16BI-0041(1)

OF12BI-0041(1)

OF10BI-0041(1)

IC8-J7534CT(1)

412JZJ(1)

C20950(1)

378JZJ(1)

100(1)

050(1)

C21999CT(1)

C21999(1)

C21637CT(1)

C21637(1)

C20950CT(1)

EPBRHC10EW(1)

EP-BHC8-WA(1)

10J12(1)

6J6(1)

2338PATH(1)

16PPATH(1)

TP9R(1)

TP16DCT(1)

RTP16DBARECT(1)

8X8G(1)

8RP51(1)

8J8(1)

32TJ32(1)

2340PATHPK(1)

24J16(1)

20J16(1)

16X16G(1)

16J16(1)

14J16(1)

12X16G(1)

12J16(1)

12J12(1)

2338WSPK(1)

2342PATH(1)

EPBHC16WAPK(1)

5342COMBO600(1)

EP-BHC16-WA(1)

EPBHC12WAPK(1)

EP-BHC12-WA(1)

EPBHC10WAPK(1)

EP-BHC10-WA(1)

5356CDCT(1)

5356CD(1)

5342COMBO6CT(1)

5342CDSBP(1)

2342PLA(1)

5342CD-PK(1)

5338CD-PK(1)

5320CD(1)

5310DX(1)

5310COMBO600(1)

45PATH(1)

2346PATH(1)

2342WSPK(1)

T9S(1)

 
Country of Origin

US(61)

TW(23)

CA(1)

FR(1)

CN(1)

 
Color(s)

White(16)

Clear(15)

Multicolor(6)

Red(4)

Clear/Blue(4)

Maroon(4)

Multicolor Cup; White Lid(3)

Brown;Green;White(2)

Green; Purple; White(2)

White/Green/Brown(1)

Multicolored(1)

Gray(1)

White/Green(1)

Plum(1)

Brown;Red;White(1)

Green; Purple; Orange; Teal(1)

Green; Purple;Orange; Teal(1)

Chocolate/Light Blue/Tan(1)

Chocolate/Blue/Beige(1)

Moss(1)

 
Material(s)

Paper(17)

Plastic(11)

Foam(11)

Ingeo(4)

25% Recycled PET Bottles(4)

Poly-Coated Paper(4)

Polystyrene(3)

Paper Cup; Plastic Lid(3)

PET(2)

Polycarbonate(2)

Ingeo PLA Corn Plastic(2)

RPET(1)

Paper/PLA(1)

Wax-Coated Paper(1)

Glass(1)

Porcelain(1)

 
Quantity

50 per pack(10)

1,000 per carton(8)

25/Bag, 40 Bags/Carton(4)

1,000 per case(3)

300 per carton(3)

1000 per carton(3)

500 per case(2)

5,000 per case(2)

6 per case(2)

500 per carton(2)

25/Bag, 20 Bags/Carton(2)

1000/Carton(2)

2400 per carton(1)

100 per box(1)

1200 per carton(1)

960 per carton(1)

51/Bag, 24 Bags/Carton(1)

50/Pack, 20 Packs/Carton(1)

6 per box(1)

8 per box(1)

100 per pack(1)

400 per carton(1)

500/Carton(1)

312 per carton(1)

2,500 per case(1)

 
Capacity (Volume)

12 oz(21)

16 oz(18)

8 oz(12)

10 oz(10)

9 oz(8)

3 oz(3)

1 oz(2)

18 oz(2)

20 oz(2)

32 oz(2)

4 qt(1)

6 oz(1)

16-18 oz(1)

8.5 oz(1)

24 oz(1)

14 oz(1)

0.5 oz(1)

 
Theme

Coffee Haze(6)

Pathways(5)

Party(5)

BlueStripe(4)

GreenStripe(4)

Bistro(4)

Coffee(3)

World Art(3)

Jazz(2)

Ultra Clear(2)

live, love, green(2)

Coffee Dreams(1)

Bare(1)

Cozumel(1)

Chef's Table - Round Series(1)

Viridian(1)

Tuscan Cafe(1)

Tuscan Café(1)

 
Cup Type

Hot(44)

Cold(22)

Hot/Cold(12)

Portion(3)

Measuring(2)

Bathroom(2)

Glass(1)

Mug(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved