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

SOLO Cup Company(39)

Dixie(39)

Boardwalk(22)

Dart(21)

Eco-Products(19)

WNA(6)

Konie(4)

Office Settings(2)

Contigo(1)

GEN(1)

 
Color(s)

White(26)

Clear(24)

Translucent(24)

Multicolor(9)

Maroon(7)

White/Yellow/Green/Purple(6)

Beige(5)

White/Green/Brown(5)

White/Green(4)

Clear/Blue(3)

Tan(2)

Multicolor Cup; White Lid(2)

Brown;Green;White(2)

Multicolored(1)

White/Green/Orange(1)

Brown;Red;White(1)

Monaco(1)

Beige/White/Red(1)

 
Quantity

1,000 per carton(34)

500 per carton(12)

1000 per carton(11)

5,000 per carton(7)

2,500 per carton(5)

300 per carton(5)

2500 per carton(4)

100 per pack(4)

2400 per carton(4)

1200 per carton(4)

240 per carton(3)

16 per pack(3)

1,000 per case(3)

50 per pack(2)

960 per carton(1)

6 per box(1)

8 per box(1)

1000 per case(1)

200 per pack(1)

3,000 per carton(1)

1 each(1)

100 per box(1)

 
Manufacturer Part Number

DEER10HCUP(1)

EP-BRHC8-EW(1)

EP-BNHC16-WD(1)

EP-BNHC8-WD(1)

EPBRHC10EW(1)

EP-BRHC12-EW(1)

EP-BRHC16-EW(1)

EPBRHC20EW(1)

EP-CC12GS(1)

EP-BHC8-WA(1)

EP-CC16GS(1)

EP-CC9S-GS(1)

EPCR12(1)

EPCR16(1)

EPCR9(1)

16HOTCUPWH(1)

40KBR(1)

EP-BNHC12-WD(1)

EP-BHC20-WA(1)

45KR(1)

58WS(1)

5342DX(1)

5356CD(1)

5356CDCT(1)

5356DX(1)

58PATH(1)

58PATHPK(1)

9PPATH(1)

EP-BHC16-WA(1)

9PPATHPK(1)

CP10DX(1)

CP12DX(1)

CP16DX(1)

CP9A(1)

EP-BHC10-WA(1)

EP-BHC12-WA(1)

40KR(1)

60KBR(1)

5342CDSBP(1)

OFX12NJ802CT(1)

4BRCT(1)

OF10BI-0041(1)

OF12BI-0041(1)

OF16BI-0041(1)

OF8BI-0041(1)

OFX10NJ802CT(1)

OFX8NJ8002CT(1)

44CT(1)

R53SYMCT(1)

R53SYMPK(1)

RSCC101516(1)

RSCC101516PK(1)

RSCC121516(1)

RSCC121516PK(1)

RSCCR91516(1)

4BR(1)

44(1)

CAR16(1)

378HSMSYM(1)

CTM1(1)

316PLABB(1)

316SMSYM(1)

316W(1)

370SI(1)

370SMSYM(1)

370W(1)

378SI(1)

412WN(1)

378SMJ8000(1)

378W2050(1)

404(1)

404CT(1)

412PLNJ7234(1)

412SIN(1)

412SMJ8000(1)

5342COMBO600(1)

5342CD-PK(1)

DEER12CCUP(1)

16J16(1)

70890(1)

10J10(1)

12J12(1)

12J16(1)

12X16G(1)

14J16(1)

16X16G(1)

TRANSCUP9CT(1)

20J16(1)

32TJ32(1)

4J4(1)

6J6(1)

8J8(1)

8X8G(1)

RTP12BARECT(1)

TRANSCUP9PK(1)

TRANSCUP7PK(1)

RTP16DBARECT(1)

TRANSCUP12PK(1)

DEER12HCUP(1)

DEER16CCUP(1)

DEER16HCUP(1)

DEER20CCUP(1)

TRANSCUP10CT(1)

TRANSCUP10PK(1)

TRANSCUP12CT(1)

TRANSCUP14CT(1)

TRANSCUP7CT(1)

TRANSCUP14PK(1)

TRANSCUP16CT(1)

TRANSCUP16PK(1)

TRANSCUP3CT(1)

TRANSCUP3PK(1)

TRANSCUP5CT(1)

TRANSCUP5PK(1)

RTP12BAREPK(1)

RTP16DBAREPK(1)

5342CD(1)

2346PATH(1)

2338WS(1)

2340PATH(1)

2340SPLA(1)

2342PATH(1)

2342PLA(1)

2342WS(1)

2346PLA(1)

2338PATH(1)

45PATH(1)

45PATHPK(1)

45WS(1)

5310COMBO600(1)

5310DX(1)

5338CD(1)

5338DX(1)

2338PLA(1)

16PPATHPK(1)

TP10DCT(1)

Y14(1)

TP10DPK(1)

TP12CT(1)

TP12PK(1)

TP16DCT(1)

TP16DPK(1)

Y10(1)

Y12S(1)

Y16T(1)

16PPATH(1)

Y35(1)

Y5CT(1)

Y7(1)

Y9CT(1)

12FPPATH(1)

12FPPATHPK(1)

12FPWS(1)

RSCCR91516PK(1)

 
Country of Origin

US(130)

TW(16)

CN(4)

CA(4)

 
Material(s)

Paper(48)

Plastic(35)

Foam(13)

Poly-Coated Paper(7)

PET(6)

Wax-Coated Paper(6)

RPET(4)

Paper/PLA(4)

Polystyrene(3)

Ingeo(3)

25% Recycled PET Bottles(3)

Paper Cup; Plastic Lid(2)

Glass(1)

Porcelain(1)

Double-Sided PLA-Lined Paper(1)

 
For Use With

Eco-Products EP-HL16-WR(8)

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

Dixie 914LSRD(4)

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

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

Boardwalk Deerfield Hot Cup Lids(3)

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

Eco-Products EPCRFL(3)

Dixie DS-115 Dispenser(3)

Boardwalk Deerfield Cold Cup Lids(3)

Dixie 9542500DXCT(3)

Dixie 9542500DXCT, TB9542, TP9542(3)

Dixie 9538DX(2)

SOLO LB3081, OFTL38-0007(2)

Dixie TB9538X(2)

Dixie D9542, TB9542, 914LSRD(2)

L7N25(2)

Dart 16FTLS, 16UL(2)

SOLO OFTL36-0007(2)

L14N(2)

Eco-Products EP-HL8-WR(2)

TL38B2, TL38R2, LB3081(1)

SOLO LB3161, OFTL36-0007(1)

SOLO DLX8R-00007, LGX8R1-0007(1)

SOLO DLX12R, LXS2BR(1)

SOLO LB3161, OFTL36-0007, TLP316(1)

GEN1020DLID(1)

SOLO TLB316(1)

SOLO DLX10R(1)

SOLO TLN316-00013, TPLUSB-00001, TPLUS-0001, TLB316-0004, TLP316-0007, AMP316-0007, LB3161-00007, LB316-00007(1)

TLB316, TLN316, TLP316, LB3161(1)

SOLO OFTL36-0007, LB3161(1)

SOLO OFTL8-0007(1)

LB3161-00007, TLB316-0004 TLN316-00013, TLP316-0007, LK316B-0004, LK316W-0007(1)

SOLO OFTL31-0007, LB3101(1)

SOLO LB3101-00007, TL31B2-0004, TL31R2-0007(1)

SOLO OFTL31-0007(1)

SOLO LB3081(1)

SOLO LB3101, OFTL31-0007(1)

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

Dixie CL1624, DL1624(1)

L9N25(1)

Dart 10JL(1)

Dart 12JL, 12SL(1)

Dart 32SL(1)

Dart 4JL(1)

Dart 6JL(1)

Dart 8JL, 8FTLS(1)

Dart 8FTLS(1)

L10N25(1)

L16TN(1)

Dixie D9538, DL9538B, TB9538X(1)

Dixie CL1420, DF1420, DL1420(1)

Dixie TB9540(1)

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

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

Dixie 9542500DX, D9542, TB9542, TP9542, TP9550, TP9550B(1)

Dixie D9542, 9542500DX, D9542B(1)

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

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

Dixie 9542500DXPK(1)

Dixie 9542500DX(1)

Dixie 985S(1)

L53(1)

 
Capacity (Volume)

12 oz(32)

16 oz(27)

10 oz(21)

8 oz(16)

9 oz(10)

5 oz(8)

3 oz(7)

4 oz(7)

14 oz(4)

20 oz(4)

12-14 oz(4)

16-18 oz(4)

7 oz(3)

32 oz(2)

6 oz(2)

3.5 oz(1)

4.5 oz(1)

 
Theme

Pathways(16)

Symphony(10)

Coffee Haze(9)

Bistro(7)

Deerfield(6)

Ultra Clear(6)

Bare(4)

Viridian(4)

BlueStripe(3)

GreenStripe(3)

Coffee(3)

Classicware(3)

Cortland(1)

Riviera(1)

Chef's Table - Round Series(1)

Bare Leaf Print(1)

Coffee Dreams(1)

White(1)

 
Cup Type

Cold(71)

Hot(58)

Hot/Cold(13)

Tumbler(3)

Tall Tumbler(2)

Glass(1)

Mug(1)

Rocks Glass(1)

 
 
 

© 2019-2020 gemlaser, Inc., All Rights Reserved