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

Currently Filtered by

Category

Utensils

Refine Search

  GO
 
Brand

Dart(34)

WNA(15)

Rubbermaid Commercial(13)

Office Settings(9)

SOLO Cup Company(3)

Royal Paper(3)

NatureHouse(3)

Royal(2)

Miller's Creek(1)

Tablemate(1)

 
Height

2"(2)

3 3/4"(1)

4"(1)

 
Color(s)

White(37)

Silver(12)

Black(8)

Clear(8)

Stainless Steel(7)

Champagne(4)

Red/White(3)

Natural(2)

Gray(1)

Transparent Blue(1)

Wood(1)

 
Depth

21 1/4"(1)

15"(1)

13 1/2"(1)

12"(1)

 
Quantity

1 each(4)

 
Manufacturer Part Number

HSWS-0007(1)

HSWK-0007(1)

HSWF-0007(1)

GDR8SS(1)

HSWT-0007(1)

K6SW(1)

RSWFX(1)

RSW1(1)

RSAT(1)

MUWS-0007(1)

GDR7TS(1)

GDR6KN(1)

GD7TW(1)

GD7TS(1)

GD6KW(1)

GD5FW(1)

GDC5FK-0090(1)

GDC6KN-0090(1)

GDR5FK(1)

GDC8SS(1)

GDC7TS-0090(1)

RSWKX(1)

RSWT(1)

A7TSBL(1)

A7SPBL(1)

A7FKBL(1)

640155(1)

REF320FK(1)

REF320FKPK(1)

REF320SPPK(1)

REF320SP(1)

REF320KNPK(1)

REF320KN(1)

630155(1)

620155(1)

RP06CT(1)

RP05CT(1)

RP04CT(1)

S6SW(1)

W95PK4(1)

WCA4265(1)

612375PK(1)

61080(1)

610155(1)

GD5FK(1)

GBX8SW(1)

CTTS(1)

CTSS(1)

CTSF(1)

CTLF(1)

1901 WHI(1)

1905 WHI(1)

1964 RED(1)

1963 RED(1)

1962 RED(1)

1906 WHI(1)

CTDS(1)

CTDK(1)

CTU7547(1)

CTU25807(1)

CTU25806(1)

CTU25516(1)

CTU7548(1)

682331(1)

CTDF(1)

8CCTWH(1)

5CCTWH(1)

2882 CLE(1)

2884 CLE(1)

GBX5FK(1)

F6SW(1)

827272(1)

827271(1)

GBX5FW(1)

GBX5FW0007BX(1)

GBX7TW0007BX(1)

GBX7TW(1)

GBX6KW0007BX(1)

GBX6KW(1)

827263(1)

RTS3000(1)

9F50(1)

3362 GRA(1)

2886 CLE(1)

2885 WHI(1)

9F75 CLE(1)

R806(1)

R832W(1)

R813(1)

R809(1)

CRU014(1)

 
Country of Origin

US(50)

CN(31)

CA(3)

 
Width

11 1/2"(1)

12 1/2" to 21"(1)

11"(1)

22"(1)

 
Material(s)

Polystyrene(37)

Plastic(20)

Stainless Steel(7)

Polycarbonate(5)

Polystyrene Plastic(3)

Crystalized Ingeo PLA Corn Plastic(3)

Bamboo(3)

Polyethylene(1)

Polypropylene(1)

Birch Wood(1)

 
Length

7"(17)

6"(4)

7 in(3)

7 3/5"(3)

9 in(3)

9 1/2"(3)

5 3/5"(2)

7 1/2"(2)

6 1/10"(2)

16 1/2"(2)

6 1/4 in(2)

7 1/2 in(2)

13 1/2"(2)

6 in(1)

5 3/4 in(1)

5 3/10"(1)

6 1/4"(1)

10 in(1)

9 3/4"(1)

9 1/4"(1)

8 1/2"(1)

7 1/4"(1)

8"(1)

9 1/2 in(1)

10 4/5"(1)

3"(1)

3 3/4"(1)

9"(1)

10.80 in(1)

6.41"(1)

 
Grade

Heavyweight(28)

Extra-Heavyweight(7)

18/0(7)

Medium Heavy Weight(5)

Mediumweight(4)

Extra-Heavy Weight(1)

 
Utensils Type

Fork(19)

Knife(14)

Teaspoon(11)

Spoon(8)

Soup Spoon(6)

Scraper/Spatula(6)

Scoop(6)

Serving Utensil(4)

Salad Fork(1)

Cutlery Kit(1)

Serving Spoon(1)

Dinner Spoon(1)

Skewer(1)

Serving Fork(1)

 
Dispenser Type

Utensils/Cutlery(2)

Utensils/Condiments(1)

Utensil Organizer(1)

 
Holds

Cutlery(2)

Forks;Knives;Spoons(1)

 
 
 

© 2018-2019 Office Solutions & Innovations, Inc., All Rights Reserved