Here at SkateHut, we have one of the biggest collections of JD Bug scooters and accessories online. Find stunt scooters, pro scooters, folding scooters, commuting scooters, kids scooters, adult scooters – we have them all! The JD Bug brand is a specialist scooter brand designed especially for young children who are active, stunt scooter pros and adult commuters. For the best kids scooters, make sure you check out our age filters. Check our JD Bug electric scooters too! Use them along-side public transport as they’re super easy to fold down for storage. The JD Bug scooters and JD Bug Pro Extreme scooters are in our price match promise so you won’t find better prices anywhere else. Shop now for a full range of JD Bug scooters, wheels, balance boards and more. Need help choosing? Contact our friendly Support Team for advice.
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 (235029, 235032, 98838, 98839, 98840, 98841, 98842, 98843, 98844, 98845, 98846, 98847, 98848, 98849, 98850, 98851, 98852, 98853, 98854, 99164, 99165, 99166, 99167, 99168))) AND (e.created_in <= '1641570900') AND (e.updated_in > '1641570900') ORDER BY FIELD(e.entity_id,235029,235032,98838,98839,98840,98841,98842,98843,98844,98845,98846,98847,98848,98849,98850,98851,98852,98853,98854,99164,99165,99166,99167,99168)
We use cookies and other similar technologies to improve your browsing experience and the functionality of our site. By clicking "Accept All Cookies", you consent to the storing on your device of all the technologies described in our Privacy Policy.
More Colours Available
