DUFFEL BAGS

Duffel bags are undoubtedly nice and spacious, yet portable enough to carry with ease. Look out for our duffel bags from Eastpak, Douchebags and Mi-Pac. Here are SkateHut we're commited to providing you with excellent value for money, whether you are looking for cheaper or pricier duffel bags. Shop our large range of duffel bags and use our price, colour and brand filters to help you pick one to match your own style. Click the bags to reveal more images of a specific bag, and further details on size and capacity.

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 (e.entity_id IN (206644, 206659))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,206644,206659)