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

Filter By

Current Filters

  1. Order In Product No Remove This Item
  2. Purchaser Tony Remove This Item
Clear All

Category

  1. Skateboards11item
  2. Skates2item
  3. Offers11item
  4. Black Friday11item
  5. Half Price10item
  6. Xmas Shop11item
  7. SkateHut Sale11item
  8. SkateHut Clearance4item
  9. End of Line10item

Order In Active

  1. Yes2item
  2. No11item

Order In Active Shipping Group

  1. Order in - 5 day leadtime2item

Export

  1. No13item

Has Identifier for GMC

  1. Yes13item

Export Common

  1. No13item

Supplier Name

  1. New English2item
  2. TKC11item

Skateboard Deck Randomiser

  1. No11item

Is for Gifting?

  1. No13item

Is Configurable Product

  1. Yes2item

Product Label Text

  1. 40% Off1 item
  2. End of Line10item

Stock At Supplier

  1. Yes2item
  2. No13item

Cross Sell Type

  1. Colour13item

Reporting Status

  1. Live13item

Sales Name

  1. Clearance6item

In Magento

  1. Yes13item

Season Name

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

Use In Google Feed

  1. Yes13item
  2. No2item

B-Stock

  1. No13item

Product Type Basic

  1. Ice Skates - Figure2item
  2. Skateboard Trucks11item

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

Channels Ready

  1. Yes13item

Variant Width

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

Channel Filters

  1. Allowed12item
  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. z312item

Department

  1. Ice Skates2item
  2. Skateboards11item

Is Simple Product

  1. Yes11item
  2. No2item

Price

  1. €0.00 - €24.9911item
  2. €250.00 and above2item

Brand Name

  1. Edea2item
  2. Fracture11item

Product Type

  1. Ice Skates > Figure Skates2item
  2. Skateboards > Trucks11item

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-56mm11item

Main Colour

  1. Black5item
  2. Blue2item
  3. Raw2item
  4. Red2item
  5. White2item

Skateboard Deck Width Suitability

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

Skateboard Truck Hanger Width

  1. 5.0"4item
  2. 5.25"4item
  3. 5.5"3item

Gender

  1. Female2item
  2. Male2item
  3. Unisex2item

Vegan

  1. No13item

Truck Width

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

Age Group

  1. Adult2item
  2. Kids2item

Builder Part

  1. Yes11item
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, 169244, 169245, 169246, 169247, 169248, 169249, 169251, 169254, 169258, 169259))) AND (e.created_in <= '1698796860') AND (e.updated_in > '1698796860') ORDER BY FIELD(e.entity_id,82854,82855,169242,169244,169245,169246,169247,169248,169249,169251,169254,169258,169259)

13 Items