KIDS ICE SKATES

Find a fantastic collection of kids ice skates right here at SkateHut. If you’re little ones are keen to get out on the ice, you’ll find no better place for value quality and great prices. Need skate guards and a skate bag? Don’t hesitate to try a bundle! With kids ice skates from some of the best brands including SFR, Edea and Rio Roller, you’re bound to have your little one gliding in glee in no time! Use the size and colour filters at the side to help you shop.

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 = '1' 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')) 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 (82843, 82851, 82853, 82855, 82865, 82856, 82857, 82874, 207291, 82852, 82854, 82859, 82863, 82864, 153155, 158518, 158521, 167845, 158516, 158514, 167851, 167848, 158519, 154223))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,82843,82851,82853,82855,82865,82856,82857,82874,207291,82852,82854,82859,82863,82864,153155,158518,158521,167845,158516,158514,167851,167848,158519,154223)