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

Currently Filtered by

Category

Dinnerware

Refine Search

  GO
 
Brand

Dart(54)

WNA(26)

Chinet(22)

Eco-Products(18)

Hefty(17)

Pactiv(16)

Genpak(16)

Dixie Ultra(15)

Dixie(14)

Boardwalk(12)

NatureHouse(10)

SOLO Cup Company(10)

AJM Packaging Corporation(9)

Office Settings(8)

Dixie Basic(6)

Tablemate(6)

Hoffmaster(5)

Libbey(2)

AbilityOne(1)

Stalk Market(1)

 
Color

White(2)

 
Height

0.8"(1)

4"(1)

 
Color(s)

White(155)

Green/Burgundy(22)

Black(20)

Natural White(15)

Clear(12)

Tan(9)

Ivory(8)

White/Silver(6)

White/Yellow/Green/Purple(3)

Wheat Straw(3)

Green/Tan(3)

Natural(2)

Red(2)

Burgundy(1)

White/Brown/Gold(1)

White/Green/Burgundy(1)

Assorted(1)

White/Beige/Red(1)

Beige(1)

Hunter Green(1)

 
Depth

1"(10)

0.8"(3)

0.7"(3)

0.4"(3)

1.5"(3)

0.6"(3)

.7"(2)

1.4"(2)

.8"(1)

1.5''(1)

3"(1)

1 1/8"(1)

0.88"(1)

1.88"(1)

1.75"(1)

0.44"(1)

5"(1)

 
Quantity

500 per carton(7)

8 per box(5)

50 per pack(5)

1,000 per carton(4)

125 per pack(4)

12 count(3)

25 per pack(2)

12/plates(1)

180 per carton(1)

12/pack(1)

12 per bag(1)

1 each(1)

1,000 per case(1)

36 per carton(1)

500 per case(1)

1 kit(1)

10 count(1)

 
Diameter

6"(48)

9"(45)

10 1/4"(20)

10"(16)

8.5"(11)

10.25"(9)

7"(7)

8 1/2"(7)

8 7/8"(5)

8 3/4"(4)

5.78"(3)

6 3/4"(3)

6.78"(3)

5.8"(3)

10 1/4 in(2)

10.13"(2)

8.25"(2)

10 1/8"(2)

8 9/10"(2)

8.88"(2)

10 1/2"(2)

6 in(2)

6 1/2"(1)

4.5"(1)

8"(1)

2 3/8"(1)

9 1/4"(1)

9 3/4"(1)

7.38"(1)

6.8"(1)

6.25''(1)

9''(1)

7.69"(1)

4 3/4"(1)

4.2"(1)

5 1/2"(1)

7 1/2 in(1)

 
Manufacturer Part Number

CP6GOAWH(1)

D25045CT(1)

YTH100040000(1)

YTH100060000(1)

YTH100070000(1)

YTH100120000(1)

YTK100090000(1)

YTKB00090000(1)

YTKB00120000(1)

D20769(1)

D20826(1)

D21029(1)

D21029CT(1)

D22155(1)

D22155CT(1)

D28100(1)

PI10E(1)

D28100CT(1)

D71016(1)

D71016PK(1)

D71625(1)

D71625PK(1)

D77300(1)

D77300PK(1)

D79001(1)

D79001PK(1)

10PSC2050CT(1)

10PSC-2050PK(1)

12BSC(1)

12BSC-2050PK(1)

6PSC2050CT(1)

YPI9E(1)

MC500440002(1)

8PSC2050CT(1)

15445(1)

21230(1)

21230PK(1)

21232(1)

21237PK(1)

21257CT(1)

22524(1)

81409(1)

81410(1)

81430(1)

82210(1)

82211(1)

82212(1)

82218(1)

82239(1)

15446(1)

0TKB0044000Y(1)

3322111(1)

ALDP06(1)

ALDPDB(1)

CTB1(1)

CTR1(1)

CTR2(1)

CTS1(1)

CTS2(1)

RLRSP(1)

0TH10009(1)

0TH10010000Y(1)

0TH10011(1)

0TH10044000Y(1)

0TK10044000Y(1)

6PSC-2050PK(1)

8PSC-2050PK(1)

21227(1)

RSC101212W(1)

19644WH(1)

5244WH(1)

6644WH(1)

9644WH(1)

TM10644WH(1)

CW10144(1)

CW10144BK(1)

CW6180(1)

CW6180BK(1)

DWP6180(1)

DWP75180(1)

MS10WPK(1)

MS6WPK(1)

MS9WPK(1)

RSC101212WPK(1)

P009CT(1)

RSCW101212(1)

RSCW101212PK(1)

RSCW61512(1)

RSCW61512PK(1)

RSCW61512WPK(1)

RSCW91512(1)

RSCW91512PK(1)

RSCW91512W(1)

RSCW91512WPK(1)

RSM101210WS(1)

RSM101210WSP(1)

RSM61210WS(1)

RSM61210WSPK(1)

RSM91210WS(1)

12244WH(1)

P007CT(1)

FSF6(1)

OFHW12-J7234(1)

FSF9-0007(1)

FSFB12(1)

HB12-J8001CT(1)

HB12-J8001PK(1)

HP9S(1)

HP9S-J8001CT(1)

HP9S-J8001PK(1)

MP6-J8001CT(1)

MP6-J8001PK(1)

MP9B(1)

MP9-J8001CT(1)

MP9-J8001PK(1)

MP9RJ8001CT(1)

MPR9J8001PK(1)

OFMP6-J7234(1)

P007(1)

OFMP9RJ7234(1)

PS95R-0099CT(1)

PS95R-0099PK(1)

RSF6CT(1)

RSF90007(1)

RSFB12-0007(1)

L001(1)

L010N(1)

L010NPK(1)

P001(1)

P001CT(1)

P002(1)

P002CT(1)

P005CT(1)

21228(1)

21226CT(1)

CP9AJCWWH14(1)

9PWCR(1)

5BWWQ(1)

6B20(1)

6PWCR(1)

6PWF(1)

6PWFPK(1)

6PWQR(1)

6PWQRPK(1)

7PWCR(1)

8B20(1)

9CPWCR(1)

9CPWF(1)

9CPWQR(1)

9CPWQRPK(1)

9PWCRPK(1)

5BWWF(1)

9PWF(1)

9PWFPK(1)

9PWQR(1)

9PWQRPK(1)

702622WNP6(1)

DBB12W(1)

DBB12WPK(1)

DBP06W(1)

DBP06WCT(1)

DBP09W(1)

DBP09WCT(1)

DXCOMBO50CT(1)

ES10PCOMP(1)

ES9PCOMP(1)

5BWWFPK(1)

5BWWC(1)

SX11PLPATHPK(1)

PLATEWF9(1)

CP9GOEWH(1)

PP6AJKWH(1)

PP6GREWH(1)

PP9GRAWH(1)

PP9GRAWHPK(1)

PP9GREWH(1)

PP9GREWHPK(1)

12UNLAMBWL(1)

6IMPACT(1)

BOWLHIPS12BL(1)

BOWLWF12(1)

DEER12BOWL(1)

DEER6PLT(1)

DEER9PLT(1)

PLHIPS10BL(1)

5B20(1)

PLTHIPS10BL3(1)

PLTHIPS6BL(1)

PLTHIPS9BL(1)

10B20(1)

10CPWCR(1)

10CPWF(1)

10PWCR(1)

10PWF(1)

10PWQR(1)

12B32(1)

12BWWCR(1)

12BWWF(1)

12BWWQR(1)

12BWWQRPK(1)

SX11PLPATH(1)

SX12PATH(1)

21225PK(1)

BLK09(1)

EPP016PK(1)

EPP016PKCT(1)

EP-P023(1)

EPPW10(1)

EPPW103(1)

72100(1)

80500(1)

80600(1)

80700(1)

80900(1)

81000(1)

81300(1)

82100(1)

83900(1)

BLK10(1)

EPP013PK(1)

LAM09(1)

LAM09-3L(1)

LAM13(1)

LAM13-3L(1)

LAM21-3L(1)

310524(1)

310528(1)

601SE1014(1)

PM32052(1)

TC8704472(1)

21060(1)

21204CT(1)

21217(1)

21225(1)

EPP013PKCT(1)

EP-P013(1)

SX20PATH(1)

UX9PATH(1)

SX20PATHPK(1)

SXB12WS(1)

SXB12WSPK(1)

SXP10PATH(1)

SXP10PATHPK(1)

SXP6PATHCT(1)

SXP6WS(1)

SXP6WSPK(1)

SXP9PATH(1)

SXP9PATHDX(1)

SXP9PATHPK(1)

UX7PATH(1)

UX7WS(1)

UX7WSPK(1)

UX9PATHPB(1)

EP-P009(1)

UX9PATHPBBX(1)

UX9PATHPK(1)

UX9WS(1)

UX9WSPK(1)

WNP9OD(1)

EP-BL12(1)

EPBL12PK(1)

EPBL12PKCT(1)

EPBL24(1)

EPBW12(1)

EP-P005(1)

EPP005PK(1)

EPP005PKCT(1)

EP-P007(1)

RSM91210WSPK(1)

 
Country of Origin

US(207)

CN(46)

CA(7)

TW(6)

China(2)

VN(1)

 
Width

6"(11)

10"(8)

8 1/2"(5)

9"(3)

7"(3)

9.5"(3)

8.5"(3)

6.7"(2)

10.25"(2)

5 3/8"(1)

9 1/4"(1)

6 1/2"(1)

8.3"(1)

10 1/2"(1)

8.88"(1)

16"(1)

6.8"(1)

9 3/4"(1)

14"(1)

8 1/4"(1)

 
Material

Porcelain(2)

 
Material(s)

Paper(74)

Plastic(61)

Foam(48)

Polystyrene(13)

Bagasse;Sugarcane(10)

Sugarcane(10)

Sugarcane Bagasse(10)

Bagasse(10)

Porcelain(6)

Laminated Foam(5)

Wheat Straw(3)

Clay-Coated Paper(3)

Molded Cellulose Fiber(2)

Sugarcane;Bagasse(2)

Glass(2)

HIPS(2)

Paper; Plastic(1)

Molded Fiber(1)

Molded fiber(1)

Fiber-Blend Bagasse(1)

Sugar-Cane-Fiber Paper(1)

Sugarcane; Bagasse(1)

 
Shape

Round(246)

Square(6)

Rectangular(6)

Oval(5)

Variety(1)

 
Length

6"(10)

10"(8)

9"(4)

13.5"(3)

8.5"(3)

8 1/2"(2)

11"(2)

10.25"(2)

7"(2)

9 1/4"(2)

6.7"(2)

6.8"(1)

5 3/8"(1)

12 1/2"(1)

8.3"(1)

8.88"(1)

19"(1)

14"(1)

8 1/4"(1)

 
Capacity (Volume)

12 oz(33)

16 oz(5)

20 oz(4)

5 oz(3)

6 oz(3)

10 oz(2)

6.000 oz(1)

5-6 oz(1)

8.000 oz(1)

10-12 oz(1)

24 oz(1)

45 oz(1)

12.000 oz(1)

1 1/2 oz(1)

3 oz(1)

7 oz(1)

4-5 oz(1)

 
Style

Scalloped Edges(2)

Embossed Scalloped Edges(2)

Embossed Straight Edges(1)

 
Backing Material

Paper(5)

 
Theme

Pathways(24)

Classicware(12)

Bare(11)

Symphony(10)

Masterpiece(6)

Deerfield(3)

Chef's Table - Round Series(3)

Milan(3)

Winchester(2)

Chef's Table - Soft-Square Series(2)

plain(1)

Pathways Vine & Leaves(1)

Vines(1)

 
Mat Type

Placemat(4)

Tray Mat(1)

 
Kitchenware Details

1 x Appetizer Plate - 6" Length x 6" Width - 6" Diameter(1)

1 x Dessert Bowl - 4" Length x 4" Width - 4" Diameter(1)

 
Kitchenware Type

Appetizer Plate(1)

Dessert Bowl(1)

 
Microwave Safe

Yes(2)

 
Dishwasher Safe

Yes(2)

 
Product Type

Table Ware(2)

 
Packaged Quantity

8 / Box(2)

 
Dinnerware Type

Plate(171)

Bowl(59)

Compartment Plate(16)

3-Compartment Plate(4)

Platter(3)

Ramekin(2)

Dinner Plate(2)

Salad Plate(2)

Variety(1)

Oval Platter(1)

Serving Tray(1)

 
 
 

© 2020-2021 NBJ Form & Function Inc. , All Rights Reserved