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

Currently Filtered by

Category

Rigid Liners

Refine Search

  GO
 
Brand

Rubbermaid Commercial(5)

Safco(1)

 
Height

27 1/2"(1)

21.5"(1)

28"(1)

28.5"(1)

27.63"(1)

27.25"(1)

 
Color(s)

Black(2)

Beige(2)

Black/Blue(1)

Gray(1)

 
Depth

16 3/4"(1)

15.5"(1)

14.25"(1)

16.25"(1)

19.5"(1)

17"(1)

 
Manufacturer Part Number

1900896(1)

1902007(1)

356300BGCT(1)

3566 GRA(1)

395800BG(1)

9669(1)

 
Country of Origin

US(5)

CN(1)

 
Width

10"(1)

9.38"(1)

14.25"(1)

16.25"(1)

19.5"(1)

17"(1)

 
Material(s)

Plastic(5)

Rigid Plastic(1)

 
Shape

Rectangular Prism(5)

Rectangular(1)

 
For Use With

Rubbermaid Commercial Slim Jim Stainless Steel Step-On Containers(2)

RCP9P9000BG(1)

Rubbermaid Commercial 8430-88 35 Gallon Ranger Container(1)

RCP396400BG(1)

Safco 36-Gallon Wood Waste Receptacles(1)

 
Capacity (Volume)

13 gal(1)

8 gal(1)

19 gal(1)

24.67 gal(1)

35 gal(1)

36 gal(1)

 
Opening Type

Open Top(6)

 
Waste Receptacle Type

Rigid Waste Bin Liner(5)

Rigid Liner(1)

 
Liner Material

Rigid Plastic(2)

Plastic(2)

LLDPE Plastic(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved