For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

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

Category

  1. Skates28item
  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)14item
  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. Excluded2item

Stock At Supplier

  1. Yes2item
  2. No36item

Cross Sell Type

  1. Colour27item

Reporting Status

  1. Live38item

In Magento

  1. Yes36item
  2. No33item

Use In Google Feed

  1. Yes38item
  2. No37item

B-Stock

  1. No38item

B-Stock Condition

  1. [Box Damage]1 item

Own Brand?

  1. No38item

Channels Ready

  1. Yes37item
  2. No1 item

Purchaser

  1. Billy10item
  2. Ricky5item
  3. Tony14item

Google Feed Margin Cat

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

Order In Active

  1. Yes1 item
  2. No37item

Order In Active Shipping Group

  1. Order in - 2-4 day leadtime1 item

Order In Product

  1. No38item

Export

  1. No37item

Has Identifier for GMC

  1. Yes21item
  2. No17item

Export Common

  1. No37item

Supplier Name

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

Is for Gifting?

  1. No38item

Is Configurable Product

  1. Yes20item

Product Label Text

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

Product Type Basic

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

Heelys Collection

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

Is Simple Product

  1. Yes8item
  2. No37item

Department

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

Price

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

Brand Name

  1. Anarchy Skates1 item
  2. Crocs1 item
  3. Heelys9item
  4. Riedell1 item
  5. Rio Roller3item
  6. Roller Derby4item
  7. SFR6item
  8. 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 > Completes12item
  5. Footwear > Crocs1 item

Main Colour

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

Gender

  1. Female9item
  2. Male5item
  3. Unisex29item

Vegan

  1. Yes9item
  2. No29item

Skate Type Boot

  1. Soft Boot13item

Skate Suitability

  1. Indoor13item
  2. Outdoor12item

Age Group

  1. Adult8item
  2. Kids35item

Skate Plate Construction

  1. Plastic11item
  2. Aluminium1 item

Skate Closure System

  1. Lacing13item
  2. Velcro10item
  3. Buckle1 item

Abec Rating

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

Size Adjustable?

  1. Yes1 item
  2. No12item

Durometer Rating

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

Adjustable Stopper?

  1. Yes1 item
  2. No11item

Light-up Wheels?

  1. No12item

Skate Wheel Size

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

Material Primary

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

Skate Wheel Width

  1. 28mm4item
  2. 30mm4item
  3. 33mm3item
  4. 36mm3item
  5. 43mm1 item
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 (76890, 76891, 119363, 409197, 344297, 386738, 386828, 406294, 403581, 381470, 153280, 119335, 119326, 119327)) ORDER BY FIELD(e.entity_id,76890,76891,119363,409197,344297,386738,386828,406294,403581,381470,153280,119335,119326,119327)

Showing 38 out of 38

Page