Replacement Lid, Barrel, Lever-Lock Band, and Screw-on Lids

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (e.entity_id IN (9128, 9135, 9141, 9156, 9123, 9129, 9133, 9134, 9122, 9126, 9127, 9132, 9139, 9140, 9147, 9158, 9124, 9130, 9138, 9157, 9142, 9146, 9730)) ORDER BY FIELD(e.entity_id,9128,9135,9141,9156,9123,9129,9133,9134,9122,9126,9127,9132,9139,9140,9147,9158,9124,9130,9138,9157,9142,9146,9730)

23 Items

Set Descending Direction
View as Grid List

23 Items

Set Descending Direction
View as Grid List

Replacement Lid, Barrel, Lever-Lock Band, and Screw-on Lids

For lab pack drums parts that have been lost or damaged, Eagle offers a wide range of replacement lab pack drum accessories. Lids and screw-on only lids can be used to replace lids that have been cracked or chipped. For drums or barrels that have been lost or damaged replacement drums are also available. Combining replacement parts with other parts that have not been damaged is a cost-effective alternative to ordering an entire lab pack drum kit.

Terms and Conditions Privacy Policy Terms of Use © 2021 Eagle Manufacturing All Rights Reserved