For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "sfr plasma" has 35 results

Filter By

Current Filters

  1. Department Roller Skates Remove This Item
Clear All

Category

  1. Skates32item
  2. Clothes1 item
  3. Bags11item
  4. Brands32item
  5. Bundles23item
  6. Clearance3item
  7. SkateHut Sale16item

Foldable?

  1. No1 item

Height Adjustable?

  1. No1 item

Kick Stand?

  1. No1 item

Light Brake?

  1. No1 item

Light Front?

  1. No1 item

Light Rear?

  1. No1 item

Regenerative Breaking?

  1. No1 item

Sales Name

  1. Reduction1 item
  2. Price Match5item
  3. Red Tier 11 item
  4. B-Stock3item

Shoe Size Adjustable

  1. Junior UK 6 - Junior UK 91 item
  2. Junior UK 8 - Junior UK 114item
  3. Junior UK 10 - Junior UK 132item
  4. Junior UK 11 - UK 11 item
  5. Junior UK 12 - UK 23item
  6. UK 3 - UK 63item

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)5item
  6. Size - Toddler UK 8.5 (EU 26)5item
  7. Size - Toddler UK 9 (EU 26.5)5item
  8. Size - Toddler UK 9.5 (EU 27)4item
  9. Size - Junior UK 10 (EU 27.5)6item
  10. Size - Junior UK 10.5 (EU 28)6item
  11. Size - Junior UK 11 (EU 29)7item
  12. Size - Junior UK 11.5 (EU 29.5)3item
  13. Size - Junior UK 12 (EU 30)6item
  14. Size - Junior UK 12.5 (EU 31)6item
  15. Size - Junior UK 13 (EU 31.5)6item
  16. Size - Junior UK 13.5 (EU 32)4item
  17. Size - UK 1 (EU 33)4item
  18. Size - UK 1.5 (EU 33.5)3item
  19. Size - UK 2 (EU 34)3item
  20. Size - UK 3 (EU 35)3item
  21. Size - UK 3.5 (EU 36)3item
  22. Size - UK 4 (EU 37)3item
  23. Size - UK 4.5 (EU 37.5)3item
  24. Size - UK 5 (EU 38)3item
  25. Size - UK 5.5 (EU 38.5)3item
  26. Size - UK 6 (EU 39)3item

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)5item
  4. Size - Junior UK 12 (EU 30)4item
  5. Size - Junior UK 13 (EU 31.5)5item
  6. Size - UK 1 (EU 33)3item
  7. Size - UK 2 (EU 34)6item
  8. Size - UK 3 (EU 35)7item
  9. Size - UK 4 (EU 37)8item
  10. Size - UK 5 (EU 38)8item
  11. Size - UK 6 (EU 39)9item
  12. Size - UK 7 (EU 41)3item

Channel Filters

  1. Allowed32item
  2. Excluded3item

Stock At Supplier

  1. No35item

Cross Sell Type

  1. Colour32item

Reporting Status

  1. Live34item
  2. Preview1 item

In Magento

  1. Yes31item
  2. No14item

Use In Google Feed

  1. Yes32item
  2. No20item

B-Stock

  1. Yes3item
  2. No32item

B-Stock Condition

  1. [Box Damage]1 item
  2. [Cosmetic Damage]1 item
  3. [Pre-Owned]1 item

Own Brand?

  1. No34item

Channels Ready

  1. Yes32item
  2. No3item

Purchaser

  1. Billy29item

Google Feed Margin Cat

  1. z117item
  2. z27item
  3. z36item
  4. other2item

Order In Active

  1. No27item

Order In Product

  1. No35item

Export

  1. No28item

Has Identifier for GMC

  1. Yes29item
  2. No6item

Export Common

  1. No28item

Supplier Name

  1. Stateside35item

Is for Gifting?

  1. No34item

Is Configurable Product

  1. Yes12item

Product Label Text

  1. 10% Off1 item
  2. 20% Off1 item
  3. 30% Off1 item
  4. 9% Off2item
  5. 6% Off3item

Product Type Basic

  1. Roller Skates - Adjustable7item
  2. Roller Skates13item
  3. Skate Bags11item
  4. Skate Wheels4item

Is Simple Product

  1. Yes21item
  2. No17item

Price

  1. £0.00 - £24.9916item
  2. £25.00 - £49.9912item
  3. £50.00 and above7item

Brand Name

  1. Rio Roller3item
  2. SFR32item

Product Type

  1. Roller Skates > Adjustable Skates7item
  2. Roller Skates > Completes13item
  3. Roller Skates > Skate Bags11item
  4. Roller Skates > Wheels4item

Main Colour

  1. Black8item
  2. Blue5item
  3. Clear1 item
  4. Green1 item
  5. Multi1 item
  6. Pink9item
  7. Purple3item
  8. Red1 item
  9. Tie Dye1 item
  10. White5item

Skate Type

  1. Quad1 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)6item
  4. Size - Junior UK 12 (EU 30)4item
  5. Size - Junior UK 13 (EU 31.5)5item
  6. Size - UK 1 (EU 33)3item
  7. Size - UK 2 (EU 34)6item
  8. Size - UK 3 (EU 35)7item
  9. Size - UK 4 (EU 37)8item
  10. Size - UK 5 (EU 38)9item
  11. Size - UK 6 (EU 39)10item
  12. Size - UK 7 (EU 41)4item

Gender

  1. Female3item
  2. Male2item
  3. Unisex15item

Vegan

  1. Yes7item
  2. No26item

Skate Type Boot

  1. Hard Boot4item
  2. Soft Boot14item

Skate Suitability

  1. Indoor12item
  2. Outdoor12item
  3. Indoor/Outdoor6item

Age Group

  1. Adult5item
  2. Kids18item

Skate Plate Construction

  1. Plastic18item

Skate Closure System

  1. Lacing11item
  2. Velcro9item
  3. Buckle7item

Abec Rating

  1. ABEC 510item
  2. ABEC 72item
  3. Skate Rated6item

Size Adjustable?

  1. Yes7item
  2. No13item

Durometer Rating

  1. 82a18item

Adjustable Stopper?

  1. No20item

Light-up Wheels?

  1. No20item

Skate Wheel Size

  1. 53mm7item
  2. 54mm7item
  3. 58mm9item

Material Primary

  1. Canvas3item
  2. Faux Leather4item
  3. Plastic5item
  4. Polyester1 item
  5. PVC1 item
  6. Vinyl5item

Skate Wheel Width

  1. 30mm6item
  2. 32mm12item
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 (32059, 32061, 155154, 155156, 155157, 289610, 279615, 407953, 122470, 122469, 122471)) ORDER BY FIELD(e.entity_id,32059,32061,155154,155156,155157,289610,279615,407953,122470,122469,122471)

Showing 35 out of 35

Page