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

Currently Filtered by

Category

Storage Boxes And Containers

Refine Search

  GO
 
Brand

Bankers Box(52)

Business Source(16)

Snap-N-Store(2)

Vaultz(2)

Classroom Keepers(2)

Akro-Mils(1)

Safco(1)

Trend(1)

 
Color

White(58)

Blue(44)

Kraft(7)

Black(5)

Green(4)

Wood Grain(1)

Gray(1)

Red(1)

Chrome(1)

Purple(1)

 
Recycled

Yes(70)

No(7)

 
Packaged Quantity

12 / Carton(40)

1 Each(8)

6 / Carton(5)

4 / Carton(5)

10 / Carton(1)

8 / Carton(1)

20 / Pack(1)

1 / Each(1)

 
Limited Warranty

1 Year(1)

Lifetime(1)

 
Weight (Approximate)

1.67 lb(7)

2.11 lb(3)

1.10 lb(3)

2 lb(3)

1.25 lb(2)

2.45 lb(2)

1.75 lb(1)

1.84 lb(1)

1.24 lb(1)

2.50 lb(1)

2.40 lb(1)

2.41 lb(1)

1.74 lb(1)

12.96 oz(1)

2.21 lb(1)

1.78 lb(1)

2.23 lb(1)

2.91 lb(1)

2.25 lb(1)

1.40 lb(1)

13.50 lb(1)

3 lb(1)

8 oz(1)

32.40 lb(1)

10.40 oz(1)

9.44 oz(1)

13.60 oz(1)

13.12 oz(1)

11.52 oz(1)

15.04 oz(1)

20 lb(1)

1.20 lb(1)

2.03 lb(1)

1.56 lb(1)

15.20 oz(1)

1.50 lb(1)

1.36 lb(1)

2.20 lb(1)

 
Media Size Supported

Letter(45)

Legal(34)

 
Exterior Material

Fiberboard(17)

Cardboard(6)

Plastic(5)

Corrugated Paper(4)

Steel(3)

Kraft(2)

Polymer(1)

Board(1)

Aluminum(1)

 
Case Style

Box(73)

Drawer(4)

 
Stackable

Yes(65)

 
Number of Storable Items

1100 Card(1)

16 Tube(1)

 
Manufacturer Part Number

09185BLUE(1)

00724(1)

00789(1)

00785(1)

00784(1)

0077101(1)

73301(1)

00725(1)

00709(1)

83201(1)

00706(1)

00705(1)

00704(1)

00703(1)

00702(1)

0070104(1)

00701(1)

83101(1)

83601(1)

0063601(1)

1277601(1)

3098(1)

001304(1)

001302(1)

VZ01189(1)

VZ01187(1)

SNS01647(1)

SNS01536(1)

12775(1)

07241(1)

12772(1)

12770(1)

1270101(1)

12112(1)

11111(1)

07243(1)

07242(1)

00648(1)

0063201(1)

26744(1)

26755(1)

42051(1)

42050(1)

32450(1)

26758(1)

26757(1)

26756(1)

26754(1)

00003(1)

26753(1)

26752(1)

26751(1)

26750(1)

26747(1)

26746(1)

26745(1)

00002(1)

00005(1)

0063101(1)

00025(1)

0062901(1)

0062801(1)

0062701(1)

0007101(1)

0006301(1)

00052(1)

00051(1)

00022(1)

00006(1)

00018(1)

0001203(1)

00012(1)

0001103(1)

00011(1)

00009(1)

00007(1)

T7001(1)

 
Country of Origin

United States(73)

China(3)

Vietnam(1)

 
Height

10.3"(13)

10.8"(11)

10"(10)

10.4"(9)

10.5"(8)

4.3"(2)

4.5"(2)

5"(2)

12.3"(2)

11.5"(2)

13"(1)

23"(1)

5.3"(1)

13.3"(1)

12.4"(1)

4.1"(1)

9"(1)

19"(1)

16.6"(1)

12.6"(1)

11"(1)

6.3"(1)

7.5"(1)

6.4"(1)

15"(1)

12.5"(1)

 
Width

12.8"(10)

12.3"(7)

12.9"(6)

12"(6)

15.3"(5)

12.5"(5)

13"(4)

15"(4)

9.3"(3)

9"(2)

15.9"(2)

14"(2)

13.8"(2)

11"(1)

17.3"(1)

30.8"(1)

16.8"(1)

8.3"(1)

16.5"(1)

12.6"(1)

13.1"(1)

13.3"(1)

16"(1)

9.5"(1)

18.3"(1)

18.1"(1)

12.4"(1)

10"(1)

15.5"(1)

6.3"(1)

9.8"(1)

39.5"(1)

 
Depth

24.1"(10)

24"(10)

16.5"(8)

25.4"(7)

15"(5)

16"(4)

16.3"(3)

23.8"(3)

7.3"(2)

25.3"(2)

25"(2)

23.3"(2)

20.1"(1)

9"(1)

1.8"(1)

15.6"(1)

5"(1)

37"(1)

16.6"(1)

6.5"(1)

18.4"(1)

16.9"(1)

17.8"(1)

18.8"(1)

17.3"(1)

12.4"(1)

13.3"(1)

25.5"(1)

24.3"(1)

12"(1)

8"(1)

 
Compartment Depth

24"(20)

15"(17)

23.25"(5)

23.50"(2)

15.50"(2)

16"(2)

23"(1)

14.25"(1)

23.75"(1)

12"(1)

18"(1)

18.50"(1)

15.19"(1)

12.38"(1)

8.75"(1)

6"(1)

 
Compartment Width

12"(28)

15"(8)

9"(4)

12.25"(3)

9.50"(2)

12.13"(2)

18"(2)

12.75"(2)

15.50"(1)

6"(1)

10.75"(1)

8.75"(1)

12.38"(1)

8"(1)

13"(1)

 
Closure Type

Lift-off(32)

String/Button Tie(20)

Flip Top(5)

Lid Lock(3)

Locking Tab(1)

Zipper(1)

Key Lock(1)

 
Weight Capacity

350 lb(2)

800 lb(2)

650 lb(2)

400 lb(1)

750 lb(1)

850 lb(1)

450 lb(1)

 
Number of Dividers

5(1)

 
Strength

Medium Duty(23)

Heavy Duty(18)

Light Duty(17)

Basic Duty(2)

 
Compartment Height

10"(37)

10.25"(3)

4"(3)

4.25"(2)

12"(2)

9.75"(2)

4.63"(1)

5.75"(1)

7"(1)

6"(1)

16"(1)

18"(1)

12.50"(1)

5"(1)

10.75"(1)

 
 
 

© 2019-2020 Edwards Office System, All Rights Reserved