For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

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

Filter By

Current Filters

  1. Number Of Wheels 1 Remove This Item
Clear All

Category

  1. Skates14item
  2. Shoes4item
  3. Bundles3item
  4. New Arrivals1 item
  5. Footwear15item

Channel Filters

  1. Allowed18item

Stock At Supplier

  1. Yes3item
  2. No15item

Cross Sell Type

  1. Colour9item

Reporting Status

  1. Live18item

In Magento

  1. Yes16item
  2. No17item

Use In Google Feed

  1. Yes18item
  2. No18item

B-Stock

  1. No18item

Own Brand?

  1. No18item

Channels Ready

  1. Yes18item

Purchaser

  1. Tony10item

Google Feed Margin Cat

  1. z15item
  2. z24item
  3. z31 item
  4. other14item

Order In Active

  1. No18item

Order In Product

  1. No18item

Export

  1. No18item

Has Identifier for GMC

  1. Yes1 item
  2. No17item

Export Common

  1. No18item

Supplier Name

  1. Shiner4item
  2. Stateside14item

Is for Gifting?

  1. No18item

Is Configurable Product

  1. Yes1 item

Product Type Basic

  1. Heelys18item

Heelys Collection

  1. Rezerve2item
  2. Veloz1 item

Is Simple Product

  1. No18item

Department

  1. Footwear18item

Price

  1. £25.00 - £49.9912item
  2. £50.00 and above6item

Brand Name

  1. Heelys4item
  2. Breezy Rollers14item

Product Type

  1. Footwear > Heelys18item

Main Colour

  1. Black3item
  2. Navy1 item
  3. Pink6item
  4. Silver1 item
  5. White7item

Shoe Size

  1. Size - Junior UK 11 (EU 29)11item
  2. Size - Junior UK 11.5 (EU 29.5)13item
  3. Size - Junior UK 12 (EU 30)4item
  4. Size - Junior UK 12.5 (EU 31)13item
  5. Size - Junior UK 13 (EU 31.5)4item
  6. Size - Junior UK 13.5 (EU 32)14item
  7. Size - UK 1 (EU 33)17item
  8. Size - UK 2 (EU 34)17item
  9. Size - UK 2.5 (EU 34.5)13item
  10. Size - UK 3 (EU 35)4item
  11. Size - UK 3.5 (EU 36)13item
  12. Size - UK 4 (EU 37)16item
  13. Size - UK 5 (EU 38)16item
  14. Size - UK 6 (EU 39)13item

Gender

  1. Female4item
  2. Unisex14item

Vegan

  1. No18item

Age Group

  1. Adult2item
  2. Kids16item

Material Primary

  1. Canvas2item
  2. Synthetic14item
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 (409185, 408991, 405880, 406078, 406114, 406150, 406186, 406222, 406258, 406321, 406357, 406393, 409197, 344297, 403581, 386738, 386828, 406294)) ORDER BY FIELD(e.entity_id,409185,408991,405880,406078,406114,406150,406186,406222,406258,406321,406357,406393,409197,344297,403581,386738,386828,406294)

18 Items