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') 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

Eco-Products(24)

Dart(22)

Dixie(19)

Hefty(8)

NatureHouse(2)

Office Settings(2)

WNA(1)

 
Warranty

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

Manufacturer's limited lifetime warranty.(1)

 
Special Features

Perfect Pak(4)

Squat(3)

50 Cups/50 White Lids(3)

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

WiseSize(2)

Squat Tumbler(1)

 
For Use With

Eco-Products EP-HL16-WR(12)

Eco-Products EP-HL8-WR(4)

Eco-Products EPCRFL(4)

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

Dixie 914LSRD(2)

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

Dixie 9542500DXCT, TB9542, TP9542(2)

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

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

SOLO OFTL36-0007(2)

NatureHouse FK08, FK09(2)

Dart 16FTLS, 16UL(2)

Dixie 9542500DXPK(1)

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

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

SOLO OFTL8-0007(1)

SOLO TL38R2-0004, TL38B2-0007(1)

SOLO OFTL31-0007(1)

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

Dixie 954200DX, TP9542(1)

Dart 8FTLS(1)

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

Dart 8JL, 8FTLS(1)

Dart 6JL(1)

Dart 12JL, 12SL(1)

Dart 32SL(1)

Dixie TB9538X(1)

Dixie 9538DX, D9538, DL9538B(1)

Dixie 9542500DXCT(1)

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

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

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

DXE9542500DX, DXEDL9540, DXEDL9540B, DXETB9540(1)

Dixie D9542, 9542500DX, D9542B(1)

 
Manufacturer Part Number

EPCC16GSPK(1)

EPCC12GSPK(1)

EPBRHC8EWPK(1)

EP-CC9S-GS(1)

EPCC9SGSPK(1)

EPCR9(1)

EPCR16PK(1)

EPCR12PK(1)

EP-BRHC8-EW(1)

EPBRHC16EWPK(1)

EPBHC8WAPK(1)

EP-BHC8-WA(1)

EPBHC16WAPK(1)

EPBRHC10EW(1)

EPBRHC10EWPK(1)

EP-BRHC16-EW(1)

EPBRHC12EWPK(1)

EP-BRHC12-EW(1)

EPCR9PK(1)

CPR16(1)

OF12BI-0041(1)

OF10BI-0041(1)

IC8-J7534CT(1)

OF16BI-0041(1)

OF8BI-0041(1)

RSMT91516(1)

RP19CT(1)

RP19(1)

FSIC12J753CT(1)

C21999CT(1)

C20315CT(1)

C20315(1)

CTM1(1)

C20950(1)

C20950CT(1)

C21999(1)

C21637CT(1)

C21637(1)

EP-BHC16-WA(1)

EPBHC12WAPK(1)

RTP16DBARECT(1)

8X8G(1)

8RP51(1)

TP16DCT(1)

TP9R(1)

2338PATH(1)

16PPATH(1)

12FPPATH(1)

8J8(1)

6J6(1)

12X16G(1)

12J16(1)

12J12(1)

14J16(1)

16J16(1)

32TJ32(1)

20J16(1)

16X16G(1)

2338WSPK(1)

2340PATHPK(1)

5342COMBO6CT(1)

5342COMBO600(1)

5342CDSBP(1)

5356CD(1)

5356CDCT(1)

EP-BHC12-WA(1)

EPBHC10WAPK(1)

EP-BHC10-WA(1)

5342CD-PK(1)

5338CD-PK(1)

2342WSPK(1)

2342PLA(1)

2342PATH(1)

2346PATH(1)

45PATH(1)

5310DX(1)

5310COMBO600(1)

10J12(1)

 
Country of Origin

US(52)

TW(23)

CN(1)

FR(1)

CA(1)

 
Color(s)

White(13)

Clear(11)

Multicolor(5)

Clear/Blue(4)

Red(4)

Maroon(4)

Multicolor Cup; White Lid(3)

Brown;Green;White(2)

Green; Purple; Orange; Teal(1)

Chocolate/Light Blue/Tan(1)

Chocolate/Blue/Beige(1)

Green; Purple;Orange; Teal(1)

Gray(1)

White/Green(1)

Brown;Red;White(1)

White/Green/Brown(1)

Multicolored(1)

Moss(1)

Plum(1)

 
Material(s)

Paper(13)

Foam(10)

Plastic(9)

Ingeo(4)

Poly-Coated Paper(4)

25% Recycled PET Bottles(4)

Paper Cup; Plastic Lid(3)

Polystyrene(3)

PET(2)

Ingeo PLA Corn Plastic(2)

RPET(1)

Glass(1)

Paper/PLA(1)

Wax-Coated Paper(1)

Porcelain(1)

 
Quantity

1,000 per carton(14)

50 per pack(10)

500 per carton(4)

1000 per carton(3)

300 per carton(3)

2400 per carton(2)

100 per pack(1)

240 per carton(1)

400 per carton(1)

312 per carton(1)

8 per box(1)

960 per carton(1)

1224 per carton(1)

1200 per carton(1)

100 per box(1)

1,000 per case(1)

6 per box(1)

 
Capacity (Volume)

12 oz(21)

16 oz(18)

8 oz(11)

10 oz(9)

9 oz(8)

3 oz(3)

18 oz(2)

16-18 oz(1)

6 oz(1)

14 oz(1)

20 oz(1)

32 oz(1)

8.5 oz(1)

 
Theme

Pathways(6)

Coffee Haze(6)

Party(5)

GreenStripe(4)

Bistro(4)

BlueStripe(4)

World Art(3)

Coffee(3)

live, love, green(2)

Ultra Clear(2)

Viridian(1)

Milan(1)

Bare(1)

Tuscan Café(1)

Cozumel(1)

Tuscan Cafe(1)

Chef's Table - Round Series(1)

 
Cup Type

Hot(41)

Cold(23)

Hot/Cold(10)

Bathroom(2)

Glass(1)

Mug(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved