For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "jd bug junior street scooter" has 37 results

Filter By

Current Filters

  1. Export No Remove This Item
  2. Shoe Size Size - UK 2 (EU 34) Remove This Item
Clear All

Category

  1. Skates27item
  2. Shoes9item
  3. Bundles22item
  4. New Arrivals1 item
  5. SkateHut Sale14item
  6. Footwear20item

Sales Name

  1. Price Match11item
  2. Red Tier 12item

Shoe Size Adjustable

  1. UK 2 - UK 51 item

Shoe Size Multi

  1. Size - UK 2 (EU 34)1 item
  2. Size - UK 2.5 (EU 34.5)1 item
  3. Size - UK 3 (EU 35)1 item
  4. Size - UK 3.5 (EU 36)1 item
  5. Size - UK 4 (EU 37)1 item
  6. Size - UK 4.5 (EU 37.5)1 item
  7. Size - UK 5 (EU 38)1 item

Variant Size

  1. Size - Junior UK 11 (EU 29)7item
  2. Size - Junior UK 12 (EU 30)8item
  3. Size - Junior UK 13 (EU 31.5)13item
  4. Size - UK 1 (EU 33)13item
  5. Size - UK 2 (EU 34)14item
  6. Size - UK 3 (EU 35)11item
  7. Size - UK 4 (EU 37)9item
  8. Size - UK 5 (EU 38)8item
  9. Size - UK 6 (EU 39)9item
  10. Size - UK 7 (EU 41)5item
  11. Size - UK 8 (EU 42)4item

Channel Filters

  1. Allowed36item
  2. Excluded1 item

Stock At Supplier

  1. Yes2item
  2. No35item

Cross Sell Type

  1. Colour27item

Reporting Status

  1. Live37item

In Magento

  1. Yes35item
  2. No33item

Use In Google Feed

  1. Yes37item
  2. No36item

B-Stock

  1. No37item

B-Stock Condition

  1. [Box Damage]1 item

Own Brand?

  1. No37item

Channels Ready

  1. Yes37item

Purchaser

  1. Billy10item
  2. Ricky5item
  3. Tony14item

Google Feed Margin Cat

  1. z114item
  2. z216item
  3. z39item
  4. other14item

Order In Active

  1. No37item

Order In Product

  1. No37item

Has Identifier for GMC

  1. Yes20item
  2. No17item

Export Common

  1. No37item

Supplier Name

  1. J&R4item
  2. Shiner9item
  3. Stateside23item
  4. Crocs Europe BV1 item

Is for Gifting?

  1. No37item

Is Configurable Product

  1. Yes19item

Product Label Text

  1. 30% Off1 item
  2. 15% Off4item
  3. 6% Off2item
  4. 8% Off1 item

Product Type Basic

  1. Heelys22item
  2. Ice Skates - Figure2item
  3. Inline Skates - Rollerblades1 item
  4. Roller Skates11item
  5. Crocs1 item

Heelys Collection

  1. Classic2item
  2. Rezerve2item
  3. Snazzy3item
  4. Veloz1 item

Is Simple Product

  1. Yes7item
  2. No36item

Department

  1. Footwear23item
  2. Ice Skates2item
  3. Inline Skates1 item
  4. Roller Skates11item

Price

  1. £25.00 - £49.9927item
  2. £50.00 - £74.999item
  3. £75.00 and above1 item

Brand Name

  1. Anarchy Skates1 item
  2. Crocs1 item
  3. Heelys9item
  4. Rio Roller3item
  5. Roller Derby4item
  6. SFR6item
  7. Breezy Rollers13item

Number Of Wheels

  1. 117item
  2. 25item

Product Type

  1. Footwear > Heelys22item
  2. Ice Skates > Figure Skates2item
  3. Inline Skates > Roller Blades1 item
  4. Roller Skates > Completes11item
  5. Footwear > Crocs1 item

Main Colour

  1. Black12item
  2. Blue2item
  3. Multi1 item
  4. Navy2item
  5. Pink6item
  6. Purple1 item
  7. Silver1 item
  8. Teal1 item
  9. White9item

Gender

  1. Female9item
  2. Male5item
  3. Unisex28item

Vegan

  1. Yes9item
  2. No28item

Skate Type Boot

  1. Soft Boot12item

Skate Suitability

  1. Indoor12item
  2. Outdoor12item

Age Group

  1. Adult7item
  2. Kids35item

Skate Plate Construction

  1. Plastic11item

Skate Closure System

  1. Lacing12item
  2. Velcro9item
  3. Buckle1 item

Abec Rating

  1. ABEC 74item
  2. Skate Rated6item
  3. Unrated2item

Size Adjustable?

  1. Yes1 item
  2. No11item

Durometer Rating

  1. 82a7item
  2. 83a4item
  3. 90a1 item

Adjustable Stopper?

  1. No11item

Light-up Wheels?

  1. No11item

Skate Wheel Size

  1. 52mm1 item
  2. 53mm4item
  3. 54mm4item
  4. 58mm3item
  5. 62mm3item

Material Primary

  1. Canvas5item
  2. Faux Suede3item
  3. Mesh4item
  4. Synthetic18item
  5. Vinyl3item

Skate Wheel Width

  1. 28mm4item
  2. 30mm4item
  3. 33mm3item
  4. 36mm3item
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 (199482, 119345, 119362, 119361, 119346, 82843, 82874, 396014, 119343, 119344, 154087, 154088, 150787, 408991, 405880, 406078, 406114, 406150, 406186, 406222, 406258, 406321, 406357, 406393)) ORDER BY FIELD(e.entity_id,199482,119345,119362,119361,119346,82843,82874,396014,119343,119344,154087,154088,150787,408991,405880,406078,406114,406150,406186,406222,406258,406321,406357,406393)

Showing 24 out of 37

Page