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(26)

Eco-Products(24)

Dixie(21)

Hefty(8)

Office Settings(2)

Rubbermaid Commercial(2)

NatureHouse(2)

Solo(1)

WNA(1)

 
Color

Multi(1)

 
Recycled

No(1)

 
Packaged Quantity

50 / Pack(1)

 
Assembly Required

No(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)

 
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)

NatureHouse FK08, FK09(2)

Dixie 9542500DXCT, TB9542, TP9542(2)

Dixie 914LSRD(2)

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

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

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

SOLO OFTL36-0007(2)

Dart 16FTLS, 16UL(2)

TLB316, TLN316, TLP316, LB3161(1)

Dixie D9538, TB9538X, 9538DX, DL9538B(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)

Dixie D9542, 9542500DX, D9542B(1)

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

DXED9542, DXED9542PK, DXED9542B(1)

Dart 8FTLS(1)

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

Dart 32SL(1)

Dart 32JL; 32SL; 8CLR; 32PL; 32RL; 32HDLC(1)

Dart 4JL(1)

Dart 6JL(1)

Dart 8JL, 8FTLS(1)

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

Dixie 9542500DX, TP9542B, TP9542, D9542, D9542B, TB9542(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)

Dart 12JL, 12SL(1)

Dixie 9542500DXCT(1)

 
Volume Capacity

18 fl oz(1)

 
Manufacturer Part Number

10J12(1)

EPBRHC8EWPK(1)

EPCR9PK(1)

EPCR9(1)

EPCR16PK(1)

EPCR12PK(1)

EPCC9SGSPK(1)

EP-CC9S-GS(1)

EPCC16GSPK(1)

EPCC12GSPK(1)

EP-BRHC8-EW(1)

CTM1(1)

EPBRHC16EWPK(1)

EP-BRHC16-EW(1)

EPBRHC12EWPK(1)

EP-BRHC12-EW(1)

EPBRHC10EWPK(1)

EPBRHC10EW(1)

EPBHC8WAPK(1)

EP-BHC8-WA(1)

CPR16(1)

3216 CLE(1)

EP-BHC16-WA(1)

FSIC12J753CT(1)

RP19CT(1)

RP19(1)

SQ185020001(1)

OF8BI-0041(1)

OF16BI-0041(1)

OF12BI-0041(1)

OF10BI-0041(1)

IC8-J7534CT(1)

412JZJ(1)

3218 CLE(1)

C21999CT(1)

C21999(1)

C21637CT(1)

C21637(1)

C20950CT(1)

C20950(1)

C20315CT(1)

C20315(1)

EPBHC16WAPK(1)

EPBHC12WAPK(1)

12J12(1)

4J4(1)

12FPPATH(1)

TP9R(1)

TP16DCT(1)

RTP16DBARECT(1)

8X8G(1)

8RP51(1)

8J8(1)

6J6(1)

44TJ32(1)

2338PATH(1)

32TJ32(1)

24J16(1)

20J16(1)

16X16G(1)

16J16(1)

14J16(1)

12X16G(1)

12J16(1)

16PPATH(1)

2338WSPK(1)

EP-BHC12-WA(1)

5338CD-PK(1)

EPBHC10WAPK(1)

EP-BHC10-WA(1)

5356CDCT(1)

5356CD(1)

5342COMBO6CT(1)

5342COMBO600(1)

5342CDSBP(1)

5342CD-PK(1)

5320CD(1)

2340PATHPK(1)

5310DXPK(1)

5310DX(1)

5310COMBO600(1)

45PATH(1)

2346PATH(1)

2342WSPK(1)

2342PLA(1)

2342PATH(1)

T9S(1)

 
Country of Origin

US(60)

TW(23)

CA(1)

FR(1)

CN(1)

United States(1)

 
Material

Plastic(1)

 
Color(s)

White(16)

Clear(13)

Multicolor(7)

Red(4)

Clear/Blue(4)

Maroon(4)

Multicolor Cup; White Lid(3)

Brown;Green;White(2)

White/Green/Brown(1)

Multicolored(1)

Gray(1)

Brown;Red;White(1)

Plum(1)

White/Green(1)

Green; Purple; Orange; Teal(1)

Green; Purple;Orange; Teal(1)

Green; Purple; White(1)

Chocolate/Light Blue/Tan(1)

Chocolate/Blue/Beige(1)

Moss(1)

 
Material(s)

Paper(16)

Foam(13)

Plastic(9)

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

51/Bag, 24 Bags/Carton(1)

2400 per carton(1)

6 per box(1)

8 per box(1)

50 per pack(1)

 
Capacity (Volume)

12 oz(22)

16 oz(18)

8 oz(11)

10 oz(10)

9 oz(8)

3 oz(3)

18 oz(2)

20 oz(2)

32 oz(2)

44 oz(1)

6 oz(1)

24 oz(1)

8.5 oz(1)

16-18 oz(1)

14 oz(1)

4 qt(1)

4 oz(1)

 
Theme

Pathways(6)

Coffee Haze(6)

Party(5)

BlueStripe(4)

GreenStripe(4)

Bistro(4)

Coffee(3)

World Art(3)

Ultra Clear(2)

live, love, green(2)

Coffee Dreams(1)

Bare(1)

Cozumel(1)

Chef's Table - Round Series(1)

Viridian(1)

Jazz(1)

Tuscan Cafe(1)

Tuscan Café(1)

 
Cup Type

Hot(44)

Cold(22)

Hot/Cold(14)

Measuring(2)

Bathroom(2)

Glass(1)

Mug(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved