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 20 results

Filter By

Current Filters

  1. Stock At Supplier No Remove This Item
  2. Purchaser Tony Remove This Item
Clear All

Category

  1. Skateboards18item
  2. Skates2item
  3. Offers18item
  4. Black Friday17item
  5. Half Price15item
  6. Xmas Shop17item
  7. SkateHut Sale18item
  8. SkateHut Clearance6item
  9. End of Line17item

Order In Active

  1. Yes2item
  2. No11item

Order In Active Shipping Group

  1. Order in - 5 day leadtime2item

Order In Product

  1. Yes2item
  2. No13item

Export

  1. No20item

Has Identifier for GMC

  1. Yes20item

Export Common

  1. No20item

Supplier Name

  1. New English2item
  2. TKC18item

Skateboard Deck Randomiser

  1. No11item

Is for Gifting?

  1. No20item

Is Configurable Product

  1. Yes2item

Product Label Text

  1. 40% Off1 item
  2. End of Line17item

Cross Sell Type

  1. Colour18item
  2. Width2item

Reporting Status

  1. Live20item

Sales Name

  1. Clearance8item
  2. Red Tier 12item

In Magento

  1. Yes20item

Season Name

  1. Carryover Stock18item
  2. Order In Product2item
  3. Order In Warehouse Stock2item

Use In Google Feed

  1. Yes20item
  2. No2item

B-Stock

  1. No20item

Product Type Basic

  1. Ice Skates - Figure2item
  2. Skateboard Trucks16item
  3. Undercarriage Kits2item

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. No20item

Channels Ready

  1. Yes20item

Variant Width

  1. 5"5item
  2. 5.25"7item
  3. 5.5"6item

Channel Filters

  1. Allowed19item
  2. Excluded1 item

ShipperHQ Shipping Group

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

Google Feed Margin Cat

  1. z11 item
  2. z23item
  3. z319item

Department

  1. Ice Skates2item
  2. Skateboards18item

Is Simple Product

  1. Yes18item
  2. No2item

Price

  1. €0.00 - €24.9916item
  2. €25.00 - €49.992item
  3. €250.00 and above2item

Brand Name

  1. Edea2item
  2. Fracture18item

Product Type

  1. Ice Skates > Figure Skates2item
  2. Skateboards > Trucks16item
  3. Skateboards > Undercarriage Kits2item

Shoe 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

Skateboard Truck Height

  1. Mid - Wheels 53-56mm18item

Main Colour

  1. Black9item
  2. Blue3item
  3. Raw3item
  4. Red2item
  5. White3item

Skateboard Deck Width Suitability

  1. 7.5"5item
  2. 7.6"5item
  3. 7.75"11item
  4. 7.8"11item
  5. 7.85"6item
  6. 7.88"6item
  7. 7.9"6item
  8. 8"13item
  9. 8.1"7item
  10. 8.12"7item
  11. 8.2"7item
  12. 8.25"7item
  13. 7.875"6item

Skateboard Truck Hanger Width

  1. 5.0"5item
  2. 5.25"6item
  3. 5.5"7item

Gender

  1. Female2item
  2. Male2item
  3. Unisex2item

Vegan

  1. No20item

Truck Width

  1. 5"5item
  2. 5.25"5item
  3. 5.5"6item

Age Group

  1. Adult2item
  2. Kids2item

Builder Part

  1. Yes16item
  2. No2item
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 (82854, 82855, 169242, 169243, 169244, 169245, 169246, 169247, 169248, 169249, 169251, 169252, 169254, 169255, 169256, 169257, 169258, 169259, 176485, 176486))) AND (e.created_in <= '1698796860') AND (e.updated_in > '1698796860') ORDER BY FIELD(e.entity_id,82854,82855,169242,169243,169244,169245,169246,169247,169248,169249,169251,169252,169254,169255,169256,169257,169258,169259,176485,176486)

20 Items