KIDS ROLLER SKATES

Roller skating is a fun activity for kids and a great way to help your children exercise effortlessly. Find a huge collection of roller skates for toddlers and kids all the way up to age 13 and size junior 11 up to adult 7. Shop the best brands including Rio Roller, SFR and Rookie. These great brands make skates for children who are beginners, and those who are little professionals too. Use the pricing, colour and size filters to find the right skates for your child. To add safety features to your purchase, check out our bundle deals that include helmets, pads and bags. Need help choosing? Contact our friendly support team for advice on sizes, safety, styles, colour and brands.

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 = '5' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 5 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 (153248, 155138, 155154, 119350, 119368, 243637, 155134, 155135, 155139, 155140, 155151, 155153, 155155, 119349, 119352, 119367, 155150, 155152, 119310, 119340, 119353, 243638, 119313, 119314))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,153248,155138,155154,119350,119368,243637,155134,155135,155139,155140,155151,155153,155155,119349,119352,119367,155150,155152,119310,119340,119353,243638,119313,119314)
Page