If you are looking for stylish kid’s skate shoes that children will love, we’ve got it covered, At SkateHut it is our mission to provide you with endless choices when shopping for comfortable, durable skate shoes for little feet. We understand that our customers are looking for kid’s skate shoes that are both fashionable and functional. That’s why we stock only the brands that get our seal of approval. You can take your pick from some of the hottest brands including Nike SB, Vans, Etnies, Lakai and many more. Shop online with us for kid’s skate shoes and get the latest designs delivered to your door.

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 (76814, 76843, 76844, 76873, 76890, 129779, 150785, 150786, 150788))) AND (e.created_in <= '1653674400') AND (e.updated_in > '1653674400') ORDER BY FIELD(e.entity_id,76814,76843,76844,76873,76890,129779,150785,150786,150788)

9 Items

You Have Selected

  • Size - UK 2 (EU 34)
  • Clear All