For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "Roller derby" has 56 results

Filter By

Current Filters

  1. Channels Ready Yes Remove This Item
  2. Skate Suitability Indoor Remove This Item
Clear All

Category

  1. Bundles46item
  2. New Arrivals3item
  3. SkateHut Sale37item
  4. Black Friday Deals1 item

Sales Name

  1. Reduction2item
  2. Clearance1 item
  3. Price Match17item
  4. Red Tier 21 item

Shoe Size Adjustable

  1. Junior UK 6 - Junior UK 91 item
  2. Junior UK 10 - Junior UK 132item
  3. Junior UK 11 - UK 12item
  4. UK 1 - UK 41 item

Shoe Size Multi

  1. Size - Toddler UK 6 (EU 23)1 item
  2. Size - Toddler UK 6.5 (EU 23.5)1 item
  3. Size - Toddler UK 7 (EU 24)1 item
  4. Size - Toddler UK 7.5 (EU 25)1 item
  5. Size - Toddler UK 8 (EU 25.5)1 item
  6. Size - Toddler UK 8.5 (EU 26)1 item
  7. Size - Toddler UK 9 (EU 26.5)1 item
  8. Size - Junior UK 10 (EU 27.5)2item
  9. Size - Junior UK 10.5 (EU 28)2item
  10. Size - Junior UK 11 (EU 29)4item
  11. Size - Junior UK 11.5 (EU 29.5)4item
  12. Size - Junior UK 12 (EU 30)4item
  13. Size - Junior UK 12.5 (EU 31)4item
  14. Size - Junior UK 13 (EU 31.5)4item
  15. Size - Junior UK 13.5 (EU 32)2item
  16. Size - UK 1 (EU 33)3item
  17. Size - UK 1.5 (EU 33.5)1 item
  18. Size - UK 2 (EU 34)1 item
  19. Size - UK 2.5 (EU 34.5)1 item
  20. Size - UK 3 (EU 35)1 item
  21. Size - UK 3.5 (EU 36)1 item
  22. Size - UK 4 (EU 37)1 item

Variant Size

  1. Size - Toddler UK 6 (EU 23)1 item
  2. Size - Junior UK 10 (EU 27.5)2item
  3. Size - Junior UK 11 (EU 29)9item
  4. Size - Junior UK 12 (EU 30)8item
  5. Size - Junior UK 13 (EU 31.5)12item
  6. Size - UK 1 (EU 33)11item
  7. Size - UK 2 (EU 34)15item
  8. Size - UK 3 (EU 35)22item
  9. Size - UK 4 (EU 37)25item
  10. Size - UK 5 (EU 38)28item
  11. Size - UK 6 (EU 39)33item
  12. Size - UK 7 (EU 41)29item
  13. Size - UK 8 (EU 42)21item
  14. Size - UK 9 (EU 43)5item
  15. Size - UK 10 (EU 44)3item
  16. Size - UK 11 (EU 46)4item
  17. Size - UK 12 (EU 47)3item
  18. Size - UK 13 (EU 48)1 item
  19. Size 101 item
  20. Size 81 item
  21. Size 71 item
  22. Size 41 item
  23. Size 51 item

Channel Filters

  1. Allowed48item
  2. Excluded8item
  3. Ebay Only4item

Stock At Supplier

  1. Yes7item
  2. No54item

Cross Sell Type

  1. Colour45item
  2. Size6item

Reporting Status

  1. Live55item
  2. Preview1 item
  3. Discontinued1 item

In Magento

  1. Yes48item
  2. No44item

Use In Google Feed

  1. Yes56item
  2. No50item

B-Stock

  1. No56item

Own Brand?

  1. Yes4item
  2. No52item

Purchaser

  1. Billy32item
  2. Ricky2item
  3. Tony9item
  4. Own Brand4item

Google Feed Margin Cat

  1. z131item
  2. z224item
  3. z317item
  4. other1 item

Order In Active

  1. Yes4item
  2. No45item

Order In Active Shipping Group

  1. Order in - 5 day leadtime4item
  2. Order in - 2-4 day leadtime1 item

Order In Product

  1. Yes6item
  2. No54item

Export

  1. No49item

Has Identifier for GMC

  1. Yes54item
  2. No3item

Export Common

  1. No49item

Supplier Name

  1. Centrano1 item
  2. J&R16item
  3. Shiner2item
  4. Skatehut4item
  5. Stateside32item
  6. Yvolve1 item

Is for Gifting?

  1. No56item

Is Configurable Product

  1. Yes49item

Product Label Text

  1. 30% Off5item
  2. 50% Off1 item
  3. 60% Off2item
  4. 15% Off4item
  5. 6% Off3item
  6. 8% Off1 item
  7. 11% Off1 item

Product Type Basic

  1. Inline Skates - Adjustable3item
  2. Roller Skates - Adjustable3item
  3. Roller Skates45item
  4. Skate Plates5item

Is Simple Product

  1. Yes13item
  2. No50item

Department

  1. Inline Skates2item
  2. Roller Derby6item
  3. Roller Skates48item

Price

  1. £25.00 - £49.9919item
  2. £50.00 - £74.9925item
  3. £75.00 - £99.994item
  4. £125.00 - £149.992item
  5. £375.00 - £399.995item
  6. £450.00 and above1 item

Brand Name

  1. Candi Girl3item
  2. Chaya1 item
  3. LMNADE4item
  4. Moxi1 item
  5. Powerdyne5item
  6. Riedell3item
  7. Rio Roller18item
  8. Roller Derby4item
  9. Rookie2item
  10. SFR14item
  11. Y-Volution1 item

Product Type

  1. Inline Skates > Adjustable Roller Blades3item
  2. Roller Derby > Roller Derby Skates1 item
  3. Roller Skates > Adjustable Skates3item
  4. Roller Skates > Completes45item
  5. Roller Skates > Plates5item

Main Colour

  1. Black14item
  2. Blue8item
  3. Cream1 item
  4. Gold1 item
  5. Green5item
  6. Grey1 item
  7. Navy1 item
  8. Pink6item
  9. Purple3item
  10. Red2item
  11. Silver5item
  12. Teal4item
  13. White5item
  14. Yellow1 item

Shoe Size

  1. Size - Toddler UK 6 (EU 23)1 item
  2. Size - Junior UK 10 (EU 27.5)2item
  3. Size - Junior UK 11 (EU 29)10item
  4. Size - Junior UK 12 (EU 30)8item
  5. Size - Junior UK 13 (EU 31.5)13item
  6. Size - UK 1 (EU 33)13item
  7. Size - UK 2 (EU 34)15item
  8. Size - UK 3 (EU 35)22item
  9. Size - UK 4 (EU 37)26item
  10. Size - UK 5 (EU 38)29item
  11. Size - UK 6 (EU 39)34item
  12. Size - UK 6.5 (EU 39.5)1 item
  13. Size - UK 7 (EU 41)32item
  14. Size - UK 8 (EU 42)23item
  15. Size - UK 9 (EU 43)5item
  16. Size - UK 10 (EU 44)3item
  17. Size - UK 11 (EU 46)4item
  18. Size - UK 12 (EU 47)4item
  19. Size - UK 13 (EU 48)2item

Gender

  1. Female19item
  2. Male18item
  3. Unisex32item

Vegan

  1. Yes15item
  2. No41item

Skate Type Boot

  1. Soft Boot56item

Age Group

  1. Adult40item
  2. Kids42item

Skate Plate Construction

  1. Plastic44item
  2. Aluminium11item

Skate Closure System

  1. Lacing51item
  2. Velcro22item
  3. Buckle5item

Abec Rating

  1. ABEC 516item
  2. ABEC 722item
  3. Skate Rated10item
  4. Unrated8item

Size Adjustable?

  1. Yes6item
  2. No50item

Durometer Rating

  1. 100a5item
  2. 101a1 item
  3. 82a42item
  4. 83a4item
  5. 93a1 item
  6. 95a1 item
  7. 98a1 item
  8. N/A1 item

Adjustable Stopper?

  1. Yes13item
  2. No41item

Light-up Wheels?

  1. No54item

Skate Wheel Size

  1. N/A5item
  2. 52mm1 item
  3. 53mm5item
  4. 54mm15item
  5. 56mm2item
  6. 58mm24item
  7. 62mm13item
  8. 64mm1 item
  9. 66mm2item
  10. 70mm1 item

Material Primary

  1. Aluminium5item
  2. Canvas3item
  3. Faux Leather20item
  4. Faux Suede6item
  5. Leather2item
  6. Mesh4item
  7. Plastic3item
  8. Suede2item
  9. Synthetic1 item
  10. Vinyl10item

Skate Wheel Width

  1. 28mm4item
  2. N/A5item
  3. 30mm10item
  4. 31mm1 item
  5. 32mm16item
  6. 33mm17item
  7. 36mm10item
  8. 38mm2item
  9. 43mm2item
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' INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.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 (119343, 119344, 119345, 119346, 134407, 153278, 153277, 119329, 119330, 119334, 119342, 119332, 119333, 119335, 119326, 119327, 153276, 119331, 119340, 119339, 380372, 119338, 119337, 119360)) ORDER BY FIELD(e.entity_id,119343,119344,119345,119346,134407,153278,153277,119329,119330,119334,119342,119332,119333,119335,119326,119327,153276,119331,119340,119339,380372,119338,119337,119360)

Showing 24 out of 56

Page