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

Currently Filtered by

Category

Boxes And Bins

Refine Search

  GO
Brand

Rubbermaid(11)

Rubbermaid Commercial(9)

deflecto(4)

Storex(3)

Advantus(2)

Safco(1)

Height

7"(4)

8 3/4"(3)

6 1/2"(3)

5"(2)

16 1/2"(2)

10"(2)

5 3/8"(1)

20 3/5"(1)

4 3/4"(1)

7 3/4"(1)

12 1/4"(1)

19"(1)

8"(1)

10 1/2"(1)

4 1/2"(1)

8 1/8"(1)

16 3/4"(1)

9 1/2"(1)

12 3/8"(1)

14"(1)

Color(s)

Steel Gray(5)

Gray(4)

Black/Clear(4)

Clear(3)

Dark Indigo Metallic(3)

Brown(2)

Clear/Blue(2)

Random Assorted Color(2)

Medium Oak/Clear(1)

Red; Green; Blue; Purple; Yellow(1)

Black(1)

Yellow(1)

White(1)

Depth

16"(6)

17 1/8"(3)

12 5/8"(2)

15"(2)

16 7/8"(1)

21 3/10"(1)

11"(1)

13 3/8"(1)

13"(1)

15 5/8"(1)

10 1/8"(1)

23 3/4"(1)

12 1/8"(1)

19 1/2"(1)

15 1/2"(1)

3 5/8"(1)

6 5/8"(1)

20 1/2"(1)

7 3/4"(1)

14 1/4"(1)

5 1/4"(1)

Manufacturer Part Number

2212CP STE(1)

2214TP STE(1)

FG334900WHT(1)

9T84YELCT(1)

3354-88 BLA(1)

3Q34 CLE(1)

2215CP STE(1)

2463 DIM(1)

61515U06C(1)

70105U06C(1)

61514U06C(1)

9452MO(1)

3Q24 CLE(1)

3Q31 CLE(1)

3351 GRA(1)

3351 BRO(1)

20604OP(1)

1721 GRACT(1)

20504OP(1)

20404OP(1)

37375(1)

20304OP(1)

1731 GRA(1)

2214 STE(1)

3349 GRA(1)

3350 BRO(1)

2244 STECT(1)

2215CP DIMCT(1)

2214TP DIMCT(1)

37371(1)

Country of Origin

US(27)

CA(3)

Width

24"(6)

23 5/8"(4)

21 1/2"(3)

20"(2)

13 3/8"(1)

8 1/2"(1)

42 3/10"(1)

10 5/8"(1)

10"(1)

4 3/4"(1)

34"(1)

17"(1)

19 1/2"(1)

7 1/2"(1)

23 1/2"(1)

32 3/8"(1)

18 3/4"(1)

10 3/8"(1)

17 1/2"(1)

Material(s)

Plastic(11)

Low-Density Polyethylene(8)

High-Density Polyethylene(6)

HIPS/Crystal Styrene(4)

Wood(1)

Mounting

Wall;Countertop(2)

Countertop;Wall(2)

Free Standing(1)

Number of Compartments

1(22)

5(2)

6(2)

12(1)

2(1)

4(1)

3(1)

Boxes & Bins Type

Covered(11)

Bus/Utility Pan(7)

Open(5)

Covered Modular(5)

Storage Box(2)

Price Range

$0-$499.99(29)

$500-$999.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
 

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