For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "mgp mgx" has 30 results

Filter By

Current Filters

  1. Order In Active No Remove This Item
  2. Scooter Height 80cm - 90cm Remove This Item
Clear All

Category

  1. Bundles27item
  2. New Arrivals11item
  3. SkateHut Sale22item

Foldable?

  1. No5item

Height Adjustable?

  1. No5item

Scooter Compression Type

  1. IHC5item

Channel Filters

  1. Allowed17item
  2. Excluded13item

Stock At Supplier

  1. No30item

Cross Sell Type

  1. Colour25item

Reporting Status

  1. Live30item

In Magento

  1. Yes12item
  2. No18item

Use In Google Feed

  1. Yes30item

B-Stock

  1. No30item

Own Brand?

  1. No30item

Channels Ready

  1. Yes22item
  2. No8item

Country Of Origin

  1. China29item

Google Feed Margin Cat

  1. z22item
  2. z32item
  3. other8item

Order In Product

  1. No30item

Export

  1. No30item

Has Identifier for GMC

  1. No30item

Export Common

  1. No30item

Supplier Name

  1. J&R30item

Best Suited to

  1. Park6item
  2. Hybrid19item

Scooter Type

  1. Adult/Commuter Scooter3item
  2. Light Up Wheel2item
  3. Stunt Scooter25item

Is for Gifting?

  1. No30item

Scooter Bar Height

  1. Adjustable5item
  2. 584mm11item
  3. 609mm5item
  4. 635mm5item
  5. 660mm4item

Scooter Height

  1. 750mm1 item
  2. 800mm2item
  3. 805mm2item
  4. 810mm4item
  5. 815mm4item
  6. 830mm5item
  7. 855mm3item
  8. 880mm1 item
  9. 890mm5item
  10. 927mm3item

Skill Level

  1. Beginner9item
  2. Intermediate15item
  3. Pro1 item

Product Type Basic

  1. Scooters - Commuter3item
  2. Scooters - Folding2item
  3. Scooters - Stunt Scooters25item

Is Simple Product

  1. Yes30item

Department

  1. Scooters30item

Price

  1. £25.00 - £49.995item
  2. £75.00 - £99.999item
  3. £100.00 - £124.995item
  4. £125.00 - £149.993item
  5. £150.00 - £174.997item
  6. £175.00 and above1 item

Brand Name

  1. MGP (Madd Gear Pro)30item

Product Type

  1. Scooters > Commuter Completes3item
  2. Scooters > Folding Completes2item
  3. Scooters > Stunt Completes25item

Main Colour

  1. Black7item
  2. Blue4item
  3. Bronze1 item
  4. Gold1 item
  5. Green3item
  6. Neochrome1 item
  7. Pink2item
  8. Purple1 item
  9. Red3item
  10. Teal1 item
  11. White5item
  12. Yellow1 item

Scooter Fork Type

  1. Fork For 120mm Wheels IHC5item

Scooter Wheel Size

  1. 100mm2item
  2. 110mm5item
  3. 125mm3item

Vegan

  1. No30item

Age

  1. 6 to 826item
  2. 8 to 1227item
  3. 10 +7item
  4. 5 +3item

Deck Length

  1. 19.5"12item
  2. 20"1 item
  3. 17.5"2item
  4. 18"4item

Deck Width

  1. 4.5"12item
  2. 5.5"1 item

Scooter Bar Shape

  1. T - Shape12item
  2. Y - Shape5item

Scooter Rider Height Range

  1. 90cm - 125cm3item
  2. 125cm - 150cm26item
  3. 150cm - 170cm27item
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 (399913, 399916, 399922, 399925, 399919, 406036, 406039, 408265, 408268, 408271, 405105, 405108, 407848, 407851, 405093, 405111, 405090, 405096, 408907, 408913, 408919, 408922, 409118, 409119)) ORDER BY FIELD(e.entity_id,399913,399916,399922,399925,399919,406036,406039,408265,408268,408271,405105,405108,407848,407851,405093,405111,405090,405096,408907,408913,408919,408922,409118,409119)

Showing 24 out of 30

Page