BARTS

Bart was a man who made his own shorts to sell on the sandy shores of Saint Tropez, but when he switched to making beanies the brand really took off (and with good reason). If you’re looking for something to keep your head warm, or even just to be the coolest cat in town, Barts beanies could well be the answer. Having made a name for themselves by making the woolliest, comfiest headgear around, Barts hats are now taking the world by storm. We offer a number of different designs and types of hat, so take a look through our selection to find the right one for your taste. With our beanies sale on you can be sure that you're getting the best value in ur skate shop!

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 (206526, 206527, 235673, 235674, 235675, 235680, 235681, 235685, 235690, 235691, 235694, 235698, 235701, 235704, 235706, 235707, 235710, 235711, 235563, 235573, 235574, 235577, 235579, 235581))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,206526,206527,235673,235674,235675,235680,235681,235685,235690,235691,235694,235698,235701,235704,235706,235707,235710,235711,235563,235573,235574,235577,235579,235581)
Page