GRIT SCOOTERS

If you need scooters and accessories of the highest quality, look no further than our sought after Grit product range. As a leading supplier of skate related products, it is our mission to bring you an endless selection of industry leading brands. We update our product range regularly to bring you the latest products from the Grit brand. You can shop with us for everything from the popular Invader scooter to compression kits, scooter bars and more. Browse our Grit scooters and accessories and get next day delivery at SkateHut.

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 (99004, 99005, 99006, 99122, 99123, 101460, 127026, 127027, 127055, 127056, 127057, 136684, 136685, 136686, 136687))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,99004,99005,99006,99122,99123,101460,127026,127027,127055,127056,127057,136684,136685,136686,136687)