ICE SKATES

Here at SkateHut, we are proud to stock state of the art ice skates and ice hockey boots for men, women and children, all at great prices. You can find a wide range of skate equipment for the whole family right here. We have skates for all abilities too! Whether you are just starting to learn the ropes on your skating shoes, or if you have been ice skating for years, we have you covered. You can browse a fantastic selection on our site. Ranging from heavy duty adjustable ice skates, to professional standard ice hockey skates, use our store filters to help you find your perfect skates. Want a specific colour? Have a specific budget? Use our colour and price filters to help narrow down your search. If you need help or advice in choosing your ice skates, contact our friendly Support Team who are always happy to help!

Loading...
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.customer_group_id = 0 AND price_index.website_id = '8' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 8 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (82864, 82865, 82876, 82863, 82843, 82877, 207291, 82875, 82844, 82874, 153155, 82859, 82845, 82857, 82860, 153152, 158514, 82856, 153154, 158518, 82853, 82855, 82867, 158521))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,82864,82865,82876,82863,82843,82877,207291,82875,82844,82874,153155,82859,82845,82857,82860,153152,158514,82856,153154,158518,82853,82855,82867,158521)
Page