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

Filter By

Current Filters

  1. Stock At Supplier No Remove This Item
  2. Builder Part Yes Remove This Item
Clear All

Category

  1. Offers22item
  2. Black Friday16item
  3. Half Price21item
  4. Xmas Shop16item
  5. SkateHut Sale22item
  6. Last One8item
  7. SkateHut Clearance6item
  8. End of Line15item

Order In Active

  1. No21item

Order In Product

  1. No21item

Export

  1. No28item

Has Identifier for GMC

  1. Yes34item

Export Common

  1. No28item

Supplier Name

  1. Shiner18item
  2. TKC16item

Skateboard Deck Randomiser

  1. No21item

Is for Gifting?

  1. No34item

Product Label Text

  1. 50% Off3item
  2. 40% Off1 item
  3. Last One7item
  4. 55% Off1 item
  5. 60% Off2item
  6. End of Line15item

Cross Sell Type

  1. Colour20item
  2. Width11item

Reporting Status

  1. Live34item

Sales Name

  1. Clearance9item
  2. Red Tier 15item
  3. Red Tier 21 item

In Magento

  1. Yes34item

Season Name

  1. Carryover Stock29item
  2. Holiday 204item
  3. Summer 201 item

Use In Google Feed

  1. Yes34item

B-Stock

  1. No34item

Product Type Basic

  1. Skateboard Trucks34item

Own Brand?

  1. No34item

Channels Ready

  1. Yes34item

Variant Width

  1. 129mm1 item
  2. 139mm3item
  3. 144mm1 item
  4. 148mm1 item
  5. 149mm2item
  6. 159mm2item
  7. 5"7item
  8. 5.25"6item
  9. 5.5"7item
  10. 6"1 item
  11. 7.13"1 item
  12. 7.63"1 item
  13. 9"1 item

Channel Filters

  1. Allowed34item

Purchaser

  1. Ricky18item
  2. Tony16item

Google Feed Margin Cat

  1. z11 item
  2. z21 item
  3. z332item

Department

  1. Skateboards34item

Is Simple Product

  1. Yes34item

Price

  1. €0.00 - €24.9918item
  2. €25.00 - €49.996item
  3. €50.00 - €74.996item
  4. €75.00 and above4item

Brand Name

  1. Fracture16item
  2. Grind King4item
  3. Independent9item
  4. Krux1 item
  5. Mini Logo2item
  6. Sushi1 item
  7. Thunder1 item

Product Type

  1. Skateboards > Trucks34item

Skateboard Truck Height

  1. Low - Wheels < 53mm4item
  2. Mid - Wheels 53-56mm30item

Main Colour

  1. Black8item
  2. Blue3item
  3. Raw10item
  4. Red2item
  5. Silver9item
  6. White2item

Skateboard Deck Width Suitability

  1. 7"1 item
  2. 7.12"1 item
  3. 7.15"1 item
  4. 7.25"1 item
  5. 7.3"1 item
  6. 7.35"1 item
  7. 7.4"2item
  8. 7.5"10item
  9. 7.6"9item
  10. 7.75"14item
  11. 7.8"18item
  12. 7.85"12item
  13. 7.88"12item
  14. 7.9"11item
  15. 8"18item
  16. 8.1"11item
  17. 8.12"12item
  18. 8.2"12item
  19. 8.25"10item
  20. 8.3"3item
  21. 8.38"4item
  22. 8.4"3item
  23. 8.5"4item
  24. 8.6"6item
  25. 8.62"4item
  26. 8.68"4item
  27. 8.7"4item
  28. 8.75"4item
  29. 8.82"3item
  30. 8.85"3item
  31. 8.9"3item
  32. 9"3item
  33. 9.12"1 item
  34. 9.5"1 item
  35. 9.62"1 item
  36. 10"1 item
  37. 10.5"1 item
  38. 7.875"9item
  39. 8.125"2item
  40. 8.375"4item
  41. 8.675"1 item

Skateboard Truck Hanger Width

  1. 129mm1 item
  2. 139mm3item
  3. 144mm1 item
  4. 148mm1 item
  5. 149mm2item
  6. 159mm2item
  7. 5.0"7item
  8. 5.25"6item
  9. 5.5"7item
  10. 6.0"1 item
  11. 7.13"1 item
  12. 7.63"1 item
  13. 9.0"1 item

Vegan

  1. No34item

Truck Width

  1. 129mm1 item
  2. 139mm3item
  3. 144mm1 item
  4. 148mm1 item
  5. 149mm2item
  6. 159mm2item
  7. 5"7item
  8. 5.25"6item
  9. 5.5"7item
  10. 6"1 item
  11. 9"1 item

Age Group

  1. Adult1 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 (111787, 111788, 111789, 111790, 111808, 111809, 112613, 111784, 111785, 163732, 111764, 111765, 111767, 111769, 111774, 111775, 112518, 169242, 169243, 169244, 169245, 169246, 169247, 169248))) AND (e.created_in <= '1698796860') AND (e.updated_in > '1698796860') ORDER BY FIELD(e.entity_id,111787,111788,111789,111790,111808,111809,112613,111784,111785,163732,111764,111765,111767,111769,111774,111775,112518,169242,169243,169244,169245,169246,169247,169248)

Showing 24 out of 34

Page