MICROSHIFT

MicroSHIFT is committed to making your riding experience immensely fun and unforgettable. It consists of a team of experts with decades of experience who have designed a range of high-performance bike parts, using state-of-the-art engineering processes and patented technology. Heaps of engineering expertise and high-quality materials go into every one of MicroSHIFT’s products so that you can rest assured that you’ll ride smoothly and safely wherever, whenever. MicroSHIFT has something for everyone, regardless of what you are after or your budget. Its budget-friendly products are also jam-packed with innovative features, so you won't need to worry about sacrificing your riding experience for price! 

Loading...
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' 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 (NULL)) AND (e.created_in <= '1653037202') AND (e.updated_in > '1653037202')
We can't find products matching the selection.