GBP £

For Sales & Advice Call Us on 0121 501 1111

Search

Menu
Settings
  • AUD A$
  • CAD CA$
  • USD $

    • HOODIES

    You’re spoilt for choice when it comes to skate hoodies with us. Here at SkateHut, we’re proud to be able to offer you a variety of clothing in our collection, and our selection of hoodies is no different. With skate hoodies for all occasions in a range of colours, from all your favourite brands including Nike Skateboarding, Thrasher, Huf, Dickies, Santa Cruz, Brixton and loads more. Whether you’re looking for men’s or women’s hoodies, you’re sure to find exactly what you’re after with us. Browse the wide range today!

    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 (67827, 243776, 67817, 67830, 67809, 67798, 67828, 67823, 67822, 67739, 67837, 152014, 152020, 172920, 172925, 172933, 172936, 67632, 172907, 172914, 172949, 172951, 67765, 128882))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,67827,243776,67817,67830,67809,67798,67828,67823,67822,67739,67837,152014,152020,172920,172925,172933,172936,67632,172907,172914,172949,172951,67765,128882)
    Page