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=46 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_614b8946c5b850_41244303` 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 Other Maintenance - Store
Other Maintenance

Other Maintenance

Styling tools and maintenance solutions to keep your hair system looking great

Shop All Other Maintenance

From knot-bleaching kits to styling heads and supplies, we carry the
supplies you need to maintain your hair system like a professional.

Other Maintenance

To help you maintain a natural-looking hair replacement system, we carry knot-bleaching kits and knot-sealing sprays you can use in the comfort of your own home. To apply tape, air dry, and style your hair system, a styling head is a must-have tool. Browse our selection of styrofoam and canvas styling heads, as well as related tools like base clamps, hardware, pins, and fasteners. Need your hair system maintenance supplies now? HairDirect offers same-day shipping. To ensure your satisfaction, we honor a 30-day money-back guarantee on all purchases.

Newsletter Fashion Box
WANT A DISCOUNT?