For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "feiyue x bruce lee" has 22 results

Filter By

Current Filters

  1. Department Roller Skates Remove This Item
  2. Shoe Size Size - UK 3 (EU 35) Remove This Item
Clear All

Category

  1. Bundles16item
  2. SkateHut Sale15item

Sales Name

  1. Price Match10item

Variant Size

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

Channel Filters

  1. Allowed22item

Stock At Supplier

  1. No22item

Cross Sell Type

  1. Colour22item

Reporting Status

  1. Live22item

In Magento

  1. Yes18item
  2. No16item

Use In Google Feed

  1. Yes22item
  2. No22item

B-Stock

  1. No22item

Own Brand?

  1. No22item

Channels Ready

  1. Yes22item

Purchaser

  1. Billy12item
  2. Tony4item

Google Feed Margin Cat

  1. z111item
  2. z29item
  3. z36item
  4. other2item

Order In Active

  1. No20item

Order In Product

  1. No20item

Export

  1. No20item

Has Identifier for GMC

  1. Yes16item
  2. No6item

Export Common

  1. No20item

Supplier Name

  1. Centrano4item
  2. J&R4item
  3. Shiner2item
  4. Stateside12item

Is for Gifting?

  1. No22item

Is Configurable Product

  1. Yes16item

Product Label Text

  1. 30% Off1 item
  2. 15% Off4item
  3. 6% Off2item
  4. 8% Off1 item
  5. 11% Off1 item

Product Type Basic

  1. Roller Skates22item

Is Simple Product

  1. Yes5item
  2. No22item

Price

  1. £25.00 - £49.998item
  2. £50.00 - £74.999item
  3. £75.00 - £99.993item
  4. £100.00 and above2item

Brand Name

  1. Rio Roller8item
  2. Roces4item
  3. Roller Derby4item
  4. Rookie2item
  5. SFR4item

Product Type

  1. Roller Skates > Completes22item

Main Colour

  1. Black8item
  2. Blue4item
  3. Green1 item
  4. Navy1 item
  5. Pink1 item
  6. Purple1 item
  7. Teal1 item
  8. White4item
  9. Yellow1 item

Gender

  1. Female6item
  2. Male6item
  3. Unisex16item

Vegan

  1. Yes9item
  2. No13item

Skate Type Boot

  1. Soft Boot22item

Skate Suitability

  1. Indoor16item
  2. Outdoor20item
  3. Indoor/Outdoor2item

Age Group

  1. Adult14item
  2. Kids17item

Skate Plate Construction

  1. Plastic20item
  2. Aluminium2item

Skate Closure System

  1. Lacing22item
  2. Velcro8item

Abec Rating

  1. ABEC 54item
  2. ABEC 710item
  3. Skate Rated6item
  4. Unrated2item

Size Adjustable?

  1. No22item

Durometer Rating

  1. 80a2item
  2. 82a12item
  3. 83a4item
  4. 85a4item

Adjustable Stopper?

  1. Yes5item
  2. No17item

Light-up Wheels?

  1. No22item

Skate Wheel Size

  1. 53mm4item
  2. 54mm12item
  3. 58mm10item
  4. 62mm3item

Material Primary

  1. Canvas1 item
  2. Faux Leather5item
  3. Faux Suede3item
  4. Mesh4item
  5. Vinyl3item
  6. PU4item
  7. Synthetic Leather2item

Skate Wheel Width

  1. 28mm4item
  2. 30mm8item
  3. 32mm6item
  4. 33mm8item
  5. 36mm3item
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 (119326, 119327, 119332, 119335, 119329, 119330, 119334, 119340, 119361, 119362, 119363, 153280, 410745, 410756, 409130, 409139, 409148, 409157, 119343, 119344, 119345, 119346)) ORDER BY FIELD(e.entity_id,119326,119327,119332,119335,119329,119330,119334,119340,119361,119362,119363,153280,410745,410756,409130,409139,409148,409157,119343,119344,119345,119346)

22 Items