For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "Roller derby" has 47 results

Filter By

Current Filters

  1. Has Identifier for GMC Yes Remove This Item
  2. Shoe Size Size - UK 5 (EU 38) Remove This Item
Clear All

Category

  1. Bundles44item
  2. SkateHut Sale24item

Material Secondary

  1. Suede2item

Sales Name

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

Variant Size

  1. Size - Junior UK 11 (EU 29)3item
  2. Size - Junior UK 12 (EU 30)3item
  3. Size - Junior UK 13 (EU 31.5)6item
  4. Size - UK 1 (EU 33)5item
  5. Size - UK 2 (EU 34)9item
  6. Size - UK 3 (EU 35)24item
  7. Size - UK 4 (EU 37)29item
  8. Size - UK 5 (EU 38)35item
  9. Size - UK 6 (EU 39)32item
  10. Size - UK 7 (EU 41)31item
  11. Size - UK 8 (EU 42)24item
  12. Size - UK 9 (EU 43)10item
  13. Size - UK 10 (EU 44)3item
  14. Size - UK 11 (EU 46)4item
  15. Size - UK 12 (EU 47)3item
  16. Size - UK 13 (EU 48)1 item

Channel Filters

  1. Allowed33item
  2. Excluded15item
  3. Ebay Only2item

Stock At Supplier

  1. Yes17item
  2. No47item

Cross Sell Type

  1. Colour43item
  2. Size1 item

Reporting Status

  1. Live47item
  2. Discontinued1 item

In Magento

  1. Yes46item
  2. No34item

Use In Google Feed

  1. Yes47item
  2. No47item

B-Stock

  1. No47item

Own Brand?

  1. Yes2item
  2. No45item

Channels Ready

  1. Yes33item
  2. No15item

Purchaser

  1. Billy24item
  2. Ricky2item
  3. Tony10item
  4. Own Brand2item

Google Feed Margin Cat

  1. z123item
  2. z223item
  3. z329item
  4. other3item

Order In Active

  1. Yes16item
  2. No32item

Order In Active Shipping Group

  1. Order in - 5 day leadtime17item
  2. Order in - 2-4 day leadtime2item

Order In Product

  1. Yes17item
  2. No46item

Export

  1. No46item

Export Common

  1. No46item

Supplier Name

  1. J&R19item
  2. Shiner2item
  3. Skatehut2item
  4. Stateside22item
  5. Flaneurz Ltd2item

Is for Gifting?

  1. No47item

Is Configurable Product

  1. Yes47item

Product Label Text

  1. 30% Off7item
  2. 60% Off1 item
  3. 6% Off1 item
  4. 8% Off1 item
  5. 54% Off1 item
  6. 11% Off1 item

Product Type Basic

  1. Roller Skates45item
  2. Roller Skates - Detachable2item

Is Simple Product

  1. Yes5item
  2. No47item

Department

  1. Roller Derby1 item
  2. Roller Skates46item

Price

  1. £25.00 - £49.997item
  2. £50.00 - £74.9920item
  3. £75.00 - £99.993item
  4. £125.00 - £149.991 item
  5. £175.00 - £199.995item
  6. £200.00 - £224.991 item
  7. £225.00 - £249.992item
  8. £425.00 and above8item

Brand Name

  1. Candi Girl1 item
  2. LMNADE2item
  3. Moxi16item
  4. Riedell2item
  5. Rio Roller15item
  6. Rookie2item
  7. SFR7item
  8. Slades2item

Product Type

  1. Roller Derby > Roller Derby Skates1 item
  2. Roller Skates > Completes45item
  3. Roller Skates > Detachable Skates > Completes2item

Main Colour

  1. Black11item
  2. Blue4item
  3. Cream1 item
  4. Green6item
  5. Navy1 item
  6. Orange1 item
  7. Pink6item
  8. Purple5item
  9. Red2item
  10. Teal1 item
  11. White6item
  12. Yellow4item

Gender

  1. Female26item
  2. Male16item
  3. Unisex17item

Vegan

  1. Yes12item
  2. No35item

Skate Type Boot

  1. Soft Boot47item

Skate Suitability

  1. Indoor30item
  2. Outdoor35item
  3. Indoor/Outdoor11item

Age Group

  1. Adult43item
  2. Kids45item

Skate Plate Construction

  1. Plastic38item
  2. Aluminium10item

Skate Closure System

  1. Lacing47item
  2. Velcro9item

Abec Rating

  1. ABEC 525item
  2. ABEC 718item
  3. Skate Rated4item

Size Adjustable?

  1. No47item

Durometer Rating

  1. 78a13item
  2. 80a2item
  3. 82a30item
  4. 95a1 item
  5. 96a1 item

Adjustable Stopper?

  1. Yes23item
  2. No24item

Light-up Wheels?

  1. No47item

Skate Wheel Size

  1. 53mm3item
  2. 54mm6item
  3. 57mm1 item
  4. 58mm30item
  5. 62mm11item
  6. 65mm8item
  7. 66mm1 item

Material Primary

  1. Canvas2item
  2. Faux Leather16item
  3. Faux Suede13item
  4. Suede1 item
  5. Synthetic1 item
  6. Vinyl14item

Skate Wheel Width

  1. 30mm8item
  2. 32mm19item
  3. 33mm15item
  4. 35mm8item
  5. 36mm8item
  6. 38mm1 item
  7. 43mm1 item
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 (134407, 153278, 153277, 119329, 119330, 119334, 119342, 119332, 119333, 119335, 119326, 119327, 119331, 119340, 380372, 119338, 119360, 119363, 153275, 296041, 119317, 296036, 296038, 296039)) ORDER BY FIELD(e.entity_id,134407,153278,153277,119329,119330,119334,119342,119332,119333,119335,119326,119327,119331,119340,380372,119338,119360,119363,153275,296041,119317,296036,296038,296039)

Showing 24 out of 47

Page