EUR €

  • Choose a currency

  • British Pound Sterling Website:
  • Danish Krone Website:
  • Swedish Krona Website:
  • MOTO Website:

For Sales & Advice Call Us on 071928374650192837565

Search

Menu

Loading...

Your search for "feiyue mid" has 23 results

Filter By

Current Filters

  1. Stock At Supplier No Remove This Item
  2. Gender Unisex Remove This Item
Clear All

Category

  1. Skates4item
  2. Shoes8item
  3. Clothes10item
  4. Brands22item
  5. Bundles3item
  6. Clearance1 item
  7. Offers8item
  8. Black Friday2item
  9. Half Price3item
  10. New Arrivals3item
  11. Xmas Shop2item
  12. SkateHut Sale8item
  13. Last One1 item
  14. SkateHut Clearance5item
  15. End of Line3item

Order In Active

  1. Yes2item
  2. No4item

Order In Active Shipping Group

  1. Order in - 5 day leadtime4item

Order In Product

  1. Yes4item
  2. No16item

Export

  1. No6item

Has Identifier for GMC

  1. Yes7item
  2. No16item

Export Common

  1. No6item

Supplier Name

  1. Barts3item
  2. J&R3item
  3. New English2item
  4. Nineteen761 item
  5. Rock Solid5item
  6. Shiner8item
  7. Stance1 item

Is for Gifting?

  1. Yes1 item
  2. No22item

Is Gift Tier

  1. High1 item

Is Configurable Product

  1. Yes4item

Product Label Text

  1. 20% Off1 item
  2. 30% Off4item
  3. 45% Off1 item
  4. End of Line3item

Cross Sell Type

  1. Colour8item

Reporting Status

  1. Live23item

Sales Name

  1. B-Stock1 item

In Magento

  1. Yes12item
  2. No12item

Season Name

  1. B-Stock1 item
  2. Carryover Stock6item
  3. Order In Product4item
  4. Order In Warehouse Stock4item
  5. Spring 234item
  6. Fall 231 item
  7. Holiday 235item
  8. Fall 242item

Use In Google Feed

  1. Yes22item
  2. No14item

B-Stock

  1. Yes1 item
  2. No22item

B-Stock Condition

  1. [Box Damage]1 item

Product Type Basic

  1. Caps4item
  2. Hats5item
  3. Socks1 item
  4. Heelys2item
  5. Skate Shoes & Trainers6item
  6. Ice Skates - Figure2item
  7. Inline Skates - Rollerblades3item

Variant Size

  1. Size - UK 2 (EU 34)2item
  2. Size - UK 3 (EU 35)2item
  3. Size - UK 4 (EU 37)2item
  4. Size - UK 5 (EU 38)1 item
  5. Size - UK 6 (EU 39)2item
  6. Size - UK 7 (EU 41)2item
  7. Size - UK 8 (EU 42)2item
  8. Size - UK 9 (EU 43)2item
  9. Size - UK 10 (EU 44)1 item
  10. Size - UK 11 (EU 46)1 item
  11. Size - UK 12 (EU 47)1 item

Own Brand?

  1. No23item

Channels Ready

  1. Yes22item
  2. No1 item

Channel Filters

  1. Allowed20item
  2. Excluded3item

Purchaser

  1. Tony2item

ShipperHQ Shipping Group

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

Google Feed Margin Cat

  1. z11 item
  2. z22item
  3. z310item
  4. other2item

Department

  1. Clothes/Accessories10item
  2. Footwear8item
  3. Ice Skates2item
  4. Inline Skates3item

Is Simple Product

  1. Yes10item
  2. No13item

Price

  1. €0.00 - €24.995item
  2. €25.00 - €49.998item
  3. €50.00 - €74.994item
  4. €75.00 - €99.991 item
  5. €125.00 - €149.993item
  6. €250.00 and above2item

Brand Name

  1. Barts3item
  2. Edea2item
  3. Feiyue6item
  4. Grizzly5item
  5. Heelys2item
  6. Primitive1 item
  7. SEBA2item
  8. Stance1 item
  9. Luminous Skates1 item

Product Type

  1. Clothes/Accessories > Caps4item
  2. Clothes/Accessories > Hats5item
  3. Clothes/Accessories > Socks1 item
  4. Footwear > Heelys2item
  5. Footwear > Skate Shoes and Trainers6item
  6. Ice Skates > Figure Skates2item
  7. Inline Skates > Roller Blades3item

Number Of Wheels

  1. 12item

Shoe Size

  1. Size - Junior UK 13 (EU 31.5)1 item
  2. Size - UK 2 (EU 34)3item
  3. Size - UK 3 (EU 35)3item
  4. Size - UK 4 (EU 37)4item
  5. Size - UK 5 (EU 38)3item
  6. Size - UK 6 (EU 39)6item
  7. Size - UK 6.5 (EU 39.5)2item
  8. Size - UK 7 (EU 41)11item
  9. Size - UK 8 (EU 42)7item
  10. Size - UK 9 (EU 43)10item
  11. Size - UK 9.5 (EU 43.5)2item
  12. Size - UK 10 (EU 44)8item
  13. Size - UK 11 (EU 46)7item
  14. Size - UK 12 (EU 47)2item

Size

  1. Large1 item
  2. One Size Fits Most1 item

Closure Type

  1. Strapback8item
  2. Snapback1 item

Clothing Style Cap

  1. 5-Panel2item
  2. Dad Hat3item
  3. 6-Panel1 item

Main Colour

  1. Black12item
  2. Blue1 item
  3. Khaki1 item
  4. Natural1 item
  5. Navy2item
  6. Tan1 item
  7. White5item

Vegan

  1. No23item

Skate Type Boot

  1. Hard Boot3item

Skate Suitability

  1. Outdoor3item

Age Group

  1. Adult21item
  2. Kids4item

Skate Closure System

  1. Lacing3item
  2. Velcro2item
  3. Buckle3item

Abec Rating

  1. ABEC 72item
  2. Unrated1 item

Size Adjustable?

  1. No3item

Durometer Rating

  1. 82a2item
  2. 85a1 item

Adjustable Stopper?

  1. No1 item

Light-up Wheels?

  1. No1 item

Skate Wheel Size

  1. 80mm3item
  2. 84mm1 item

Material Primary

  1. Canvas7item
  2. Cotton6item
  3. Denim1 item
  4. Linen3item
  5. Plastic3item
  6. Polyester Blend1 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 = '5' INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 5 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 5 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 (382697, 389929, 389911, 382484, 382445, 382466, 389440, 389443, 389434, 389437, 389431, 383600, 352022, 352023, 352024, 379175, 344297, 369903, 389104, 374971, 379418, 82854, 82855))) AND (e.created_in <= '1698796860') AND (e.updated_in > '1698796860') ORDER BY FIELD(e.entity_id,382697,389929,389911,382484,382445,382466,389440,389443,389434,389437,389431,383600,352022,352023,352024,379175,344297,369903,389104,374971,379418,82854,82855)

23 Items