SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `perm`.`grant_catalog_category_view`, `perm`.`grant_catalog_product_price`, `perm`.`grant_checkout_items`, `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`, IFNULL(warehouse_index.stock_status, stock_status_index.stock_status) AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=43 LEFT JOIN `magento_catalogpermissions_index` AS `perm` ON perm.customer_group_id = 0 AND perm.category_id = cat_index.category_id AND perm.website_id = '1' 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 LEFT JOIN `amasty_multiinventory_warehouse_item` AS `warehouse_index` ON e.entity_id = warehouse_index.product_id AND warehouse_index.warehouse_id = '2' INNER JOIN `search_tmp_614b9cefd55478_07813054` AS `search_result` ON e.entity_id = search_result.entity_id WHERE ((perm.grant_catalog_category_view != -2 OR perm.grant_catalog_category_view IS NULL)) AND (e.created_in <= '1575176340') AND (e.updated_in > '1575176340') ORDER BY `cat_index`.`position` asc, `e`.`entity_id` DESC LIMIT 15 Removal - Store
Removal

Removal

Solutions for quick and easy hair system removal

Shop All Removal

Hair system removal products come in spray, pour, and dab-on varieties to help make
removal quick, easy, and gentle on both your scalp and your hair system.

Removal

Make the removal of your hair replacement system easier while protecting your scalp and hair system. HairDirect offers spray, dab-on, and pour-on hair system removers by trusted brands such as Walker, ProTouch, PPI and TDi, in bottle sizes ranging from under 5 ounces to over 30 ounces. With worldwide shipping and a 30-day money-back guarantee on all purchases, we make it easy for you to find and order the removal products you need to simplify your hair system routine.

Newsletter Fashion Box
WANT A DISCOUNT?