ODI

ODI

ODI Is the world leader in grip technology. That's not an exaggeration, ODI pioneered lock on grips and over the past 25 years have been dedicated to providing the best products there is to offer.

54 items found

per page
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.website_id = '1' AND price_index.customer_group_id = 0 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')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE ((e.entity_id IN (504691, 472739, 472742, 473252, 473306, 473255, 473258, 473303, 472529, 472799, 472898, 473291, 473300, 473309, 494142, 472670, 473285, 505174, 472523, 472796, 473261, 473294, 473288, 473264, 473267, 473141, 473138, 473129, 474141, 474144))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,504691,472739,472742,473252,473306,473255,473258,473303,472529,472799,472898,473291,473300,473309,494142,472670,473285,505174,472523,472796,473261,473294,473288,473264,473267,473141,473138,473129,474141,474144)
  1. New
    Heater Windbreaker Jacket

    ODI Heater Windbreaker Jacket

  2. AG1 MTB Lock On Grips

    ODI AG1 MTB Lock On Grips

  3. Vans MTB Lock On Grips

    ODI Vans MTB Lock On Grips

    From £31.99
     
  4. AG2 v2.1 MTB Lock On Grips

    ODI AG2 v2.1 MTB Lock On Grips

    From £31.99
     
  5. Dread Lock MTB Grips

    ODI Dread Lock MTB Grips

  6. Troy Lee Designs MTB Lock On Grips

    ODI Troy Lee Designs MTB Lock On Grips

  7. Rogue MTB Lock On Grips

    ODI Rogue MTB Lock On Grips

  8. Stay Strong BMX Lock On Grips

    ODI Stay Strong BMX Lock On Grips

  9. X-Treme MTB Lock On Grips

    ODI X-Treme MTB Lock On Grips

  10. Ruffian BMX Lock On Grips

    ODI Ruffian BMX Lock On Grips

  11. SDG MTB Lock On Grips

    ODI SDG MTB Lock On Grips

  12. Best Seller
    Elite Flow MTB Lock On Grips

    ODI Elite Flow MTB Lock On Grips

    From £27.99
     
  13. Ruffian MTB Lock On Grips

    ODI Ruffian MTB Lock On Grips

  14. Rogue BMX Lock On Grips

    ODI Rogue BMX Lock On Grips

  15. Elite Motion MTB Lock On Grips

    ODI Elite Motion MTB Lock On Grips

    From £27.99
    Out of stock
  16. New
    Elite Pro MTB Lock On Grips

    ODI Elite Pro MTB Lock On Grips

    From £27.99
    Out of stock
  17. Performance Bar Tape 3.5mm

    ODI Performance Bar Tape 3.5mm

  18. Best Seller
    Performance Bar Tape 2.5mm

    ODI Performance Bar Tape 2.5mm

  19. DH Number Plate

    ODI DH Number Plate

Page