For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "Pro-Tec Classic Helmet" has 24 results

Filter By

Current Filters

  1. Supplier Name Stateside Remove This Item
  2. Builder Part Yes Remove This Item
Clear All

Category

  1. Skateboards21item
  2. Scooters3item
  3. SkateHut Sale11item

Sales Name

  1. Price Match14item
  2. Red Tier 12item
  3. Red Tier 21 item

Variant Width

  1. 129mm6item
  2. 139mm6item
  3. 149mm1 item

Channel Filters

  1. Allowed24item

Stock At Supplier

  1. No22item

Cross Sell Type

  1. Colour22item

Reporting Status

  1. Live24item

In Magento

  1. Yes22item
  2. No2item

Use In Google Feed

  1. Yes24item

B-Stock

  1. No24item

Own Brand?

  1. No24item

Channels Ready

  1. Yes23item
  2. No1 item

Purchaser

  1. Billy22item

Google Feed Margin Cat

  1. z322item

Order In Active

  1. No7item

Order In Product

  1. No24item

Export

  1. No13item

Has Identifier for GMC

  1. Yes22item
  2. No2item

Export Common

  1. No13item

Skateboard Deck Randomiser

  1. No4item

Is for Gifting?

  1. Yes3item
  2. No21item

Is Gift Tier

  1. High3item

Product Type Basic

  1. Scooter Grips3item
  2. Skateboard Trucks13item
  3. Skateboard Wheels8item

Is Simple Product

  1. Yes24item

Department

  1. Scooters3item
  2. Skateboards21item

Price

  1. £0.00 - £24.9913item
  2. £25.00 and above11item

Brand Name

  1. Enuff21item
  2. Slamm3item

Product Type

  1. Scooters > Grips3item
  2. Skateboards > Trucks13item
  3. Skateboards > Wheels8item

Grip Length

  1. 129mm3item

Main Colour

  1. Black5item
  2. Blue3item
  3. Natural3item
  4. Purple1 item
  5. Raw4item
  6. Red1 item
  7. Silver2item
  8. White3item

Truck Width

  1. 129mm6item
  2. 139mm6item
  3. 149mm1 item

Skateboard Truck Height

  1. Low - Wheels < 53mm10item
  2. Mid - Wheels 53-56mm3item

Skateboard Deck Width Suitability

  1. 7.5"6item
  2. 7.6"6item
  3. 7.75"11item
  4. 7.8"5item
  5. 7.85"5item
  6. 7.88"5item
  7. 7.9"5item
  8. 8"5item
  9. 8.1"5item
  10. 8.12"5item
  11. 8.2"6item
  12. 8.25"7item
  13. 8.3"2item
  14. 8.38"2item
  15. 8.4"2item
  16. 8.5"2item
  17. 8.6"2item
  18. 8.62"2item
  19. 8.68"2item
  20. 8.7"2item
  21. 8.75"2item
  22. 7.875"5item
  23. 8.125"1 item

Skateboard Truck Hanger Width

  1. 129mm6item
  2. 139mm5item
  3. 149mm1 item
  4. 5.5"1 item

Vegan

  1. No24item

Skateboard Wheel Size

  1. 53mm3item
  2. 55mm3item
  3. 58mm2item

Durometer Rating

  1. 85a8item
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 (101234, 406447, 406450, 163945, 163719, 111739, 163720, 163946, 163947, 164037, 164038, 163655, 111740, 111741, 111742, 111743, 164014, 164017, 111697, 111698, 111712, 111713, 111717, 111718)) ORDER BY FIELD(e.entity_id,101234,406447,406450,163945,163719,111739,163720,163946,163947,164037,164038,163655,111740,111741,111742,111743,164014,164017,111697,111698,111712,111713,111717,111718)

24 Items