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

Currently Filtered by

Manufacturer

ALERA

Refine Search

  GO
 
Category Filter

Chairs/Stools(150)

Shelving Units/Bookcases(89)

File Cabinets(83)

Desks(42)

Storage Cabinets(37)

Hutches(36)

Tables(30)

Credenzas(26)

Reception Seating & Sofas(25)

Table Tops(21)

Returns(20)

Shelving Parts(15)

Table Bases/Legs(15)

Replacement Shelves(14)

Furniture Doors(8)

Clothes Racks(8)

Utility Drawers(8)

Table Accessories(7)

Keyboard Drawers/Platforms(7)

Storage Cabinet Accessories(6)

Carts(5)

File Cabinet Accessories(4)

Refrigerators(4)

Fans(4)

File Shelves/Components(3)

Hutch Accessories(3)

Partition & Panel Systems(2)

Casters & Glides(2)

Chair Arms(2)

Partition & Panel Accessories(2)

Furniture Hardware(2)

Label Holders(1)

Chair Accessories(1)

Locks(1)

 
Brand

Alera(650)

Alera Plus(33)

 
Color

Mahogany(66)

Black(57)

Espresso(56)

Medium Cherry(55)

Silver(27)

Putty(24)

Light Gray(20)

Cherry(19)

Walnut(16)

Maple(15)

Medium Oak(12)

Charcoal(11)

Black Anthracite(8)

Walnut/Black(4)

Black Anthracite Plus(4)

Green(4)

Cherry/Putty(4)

Cherry/Granite Nebula(4)

Espresso/White(4)

Clear(4)

Gray(4)

Gray/Granite Nebula(4)

Almond(3)

Beige(3)

Chestnut(2)

Black/Silver(2)

Slate(2)

Black/Mahogany(2)

Clear/Satin(1)

Mahogany/Black(1)

Caribbean(1)

Cardinal(1)

Mandarin(1)

Saffron(1)

Chrome(1)

 
Height

7 1/2"(4)

4 3/4"(2)

81 3/4"(2)

75"(2)

33 9/10"(2)

17 7/10"(2)

5 3/4"(1)

19"(1)

19 1/4"(1)

36"(1)

 
Color(s)

Black(8)

Silver(7)

White(3)

Black/Silver(1)

Gray(1)

 
Depth

18"(8)

17 7/10"(2)

18 3/5"(2)

3 1/8"(1)

3 3/8"(1)

3 3/8""(1)

10 3/8"(1)

6 1/2"(1)

11 7/8"(1)

 
Quantity

1 each(144)

4 per carton(13)

2 per carton(10)

4 per pack(9)

2 per pack(5)

1 kit(3)

2 each(2)

4 each(1)

10 per pack(1)

2 per set(1)

 
Size

3"(1)

 
Overall Width

36"(70)

35 5/8"(34)

48"(24)

72"(20)

47 1/4"(19)

14 7/8"(16)

16"(16)

31 3/4"(15)

18"(13)

42"(12)

60"(12)

15 5/8"(9)

15 3/8"(9)

35 1/2"(9)

23 5/8"(9)

70 5/8"(8)

71"(8)

65"(7)

30"(7)

34"(7)

66"(6)

24"(6)

47"(6)

26 3/8"(6)

24 1/2"(5)

58 7/8"(5)

64 3/4"(5)

34 1/4"(3)

70 7/8"(3)

14 3/4"(3)

29 1/2"(3)

26"(3)

31"(3)

59 1/8"(3)

44"(3)

35"(3)

15 7/8"(3)

31 1/4"(3)

59"(3)

15 3/4"(3)

17"(2)

14"(2)

12"(2)

58"(2)

25 3/4"(2)

38 3/8"(2)

46 5/8" to 75 1/4"(2)

15 1/4"(2)

47 1/2"(2)

38"(2)

50"(2)

31 1/2"(1)

25 5/8"(1)

96"(1)

62"(1)

59" to 72"(1)

34 7/8"(1)

6 1/2"(1)

62 3/8"(1)

20 3/4"(1)

22 1/2"(1)

77"(1)

55"(1)

43 1/8"(1)

44 7/8"(1)

55 1/2"(1)

65 3/4"(1)

15 1/2"(1)

94 1/2"(1)

28"(1)

 
Overall Depth

18"(61)

15"(43)

11 3/4"(39)

24"(31)

23 5/8"(23)

14"(23)

19 1/4"(18)

30"(14)

20"(14)

20 1/2"(12)

24 3/4"(9)

22"(8)

19 1/8"(8)

23 1/4"(8)

19 1/2"(8)

23 1/8"(8)

22 3/4"(6)

3/4"(5)

26 3/8"(4)

1/4"(4)

19 3/4"(4)

2"(3)

5/8"(3)

14 3/16"(3)

10"(3)

1/2"(3)

19 5/8"(3)

21 1/2"(3)

31 1/2"(3)

21"(2)

14 5/8"(2)

24" to 36"(2)

3/8"(2)

26"(1)

50 5/8" to 75 3/8"(1)

2 5/8"(1)

31 1/8"(1)

22 5/8"(1)

48"(1)

36"(1)

16"(1)

22 1/2"(1)

47 1/4"(1)

24" to 30"(1)

22 1/4"(1)

 
Diameter

42"(3)

21 1/4"(1)

29 3/4"(1)

2 5/8"(1)

18"(1)

 
Base Color

Black(106)

Mahogany(16)

Chrome(15)

Silver(11)

Graphite(11)

Medium Cherry(5)

Aluminum(4)

Bronze(3)

Charcoal(3)

Light Gray(3)

Tan(3)

Black Anthracite(2)

Espresso(2)

Gray(2)

Gunmetal Gray(1)

Walnut(1)

Cherry(1)

Slate(1)

 
Folded Height

2 1/2"(5)

2"(3)

2 3/4"(3)

3 9/10"(2)

3 1/2"(1)

 
 
 

© 2020-2021 Onestop, Inc., All Rights Reserved