facebook
 
 
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_name` IN ('Roll Files','Flat/Plan Files','Wall Racks','Mobile Racks')) 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 '%ArtandDraftingFiles' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('ArtandDraftingFiles' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ArtandDraftingFiles' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ArtandDraftingFiles"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ArtandDraftingFiles"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ArtandDraftingFiles"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ArtandDraftingFiles"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ArtandDraftingFiles' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ArtandDraftingFiles',`category_4` ='ArtandDraftingFiles') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ArtandDraftingFiles,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ArtandDraftingFiles', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Art And Drafting Files

Refine Search

  GO
 
Brand

Safco(10)

Jonti-Craft(6)

Rainbow Accents(4)

Lorell(4)

Children's Factory(1)

Genuine Joe(1)

 
Color

Satin(4)

Gray(3)

Blue(2)

Tropic Sand(2)

White(2)

Wood Grain(2)

Putty(1)

Black(1)

Green(1)

Orange(1)

Navy Blue(1)

Navy(1)

Red(1)

Yellow(1)

Teal(1)

Purple(1)

Baltic(1)

Sand(1)

 
Recycled

No(23)

Yes(3)

 
Height

35.5"(9)

24.5"(3)

22"(2)

7.5"(1)

3.8"(1)

29.3"(1)

30.5"(1)

31.8"(1)

9.8"(1)

61.6"(1)

51"(1)

 
Depth

15"(10)

12"(2)

12.8"(2)

21.5"(1)

2.8"(1)

15.8"(1)

16.5"(1)

14"(1)

14.8"(1)

37.5"(1)

20.5"(1)

 
Manufacturer Part Number

005003(1)

69503(1)

5026(1)

5016(1)

3091(1)

3090(1)

3088(1)

3084(1)

3083(1)

3081(1)

3079(1)

69504(1)

69502(1)

12504CT(1)

69501(1)

2691JCWW180(1)

2691JCWW119(1)

2691JCWW114(1)

2691JCWW112(1)

2691JCWW008(1)

2691JCWW007(1)

2691JCWW005(1)

2691JCWW004(1)

2691JCWW003(1)

0324JC(1)

5060(1)

 
Country of Origin

United States(13)

China(11)

Taiwan(2)

 
Width

48"(10)

15"(2)

18"(2)

16.5"(1)

30.1"(1)

16.3"(1)

21"(1)

24"(1)

27"(1)

43.8"(1)

 
Material

Hard Rubber(9)

Steel(8)

Aluminum(4)

Plastic(4)

Fiberboard(2)

ABS Plastic(1)

Acrylic(1)

Rubber(1)

Wood(1)

 
Limited Warranty

Lifetime(13)

 
Weight (Approximate)

107 lb(9)

68 lb(1)

47 lb(1)

 
Number of Casters

4(2)

 
Length

52.5"(1)

18"(1)

24"(1)

30"(1)

36"(1)

 
Maximum Load Capacity

240 lb(1)

 
Sheet Capacity

100(4)

 
Placement

Wall Mountable(2)

Floor(2)

 
Total Number of Compartments

5(1)

 
Size Capacity

1"(4)

 
Number of Devices Supported

20(1)

 
Product Type

Storage Rack(10)

Vertical Paper Rack(7)

Hanging Clamp(4)

Mobile Cart(2)

Tool Organizer(1)

Wall Rack(1)

Mobile File Cart(1)

 
Packaged Quantity

1 Each(12)

1 / Each(9)

6 / Box(4)

24 / Carton(1)

 
Assembly Required

No(15)

Yes(11)

 
Finishing

Powder Coated(1)

 
Caster Size

2"(1)

 
Item Capacity

5 x Broom(1)