The store will not work correctly when cookies are disabled.
We use cookies and personal data for two reasons - to deliver the best website experience and serve personalised ads. Click Accept to continue or find out more in our Cookie and Privacy Policy
Discover the enduring elegance of Bronnley, one of Britain's most cherished heritage bath and body brands. Established in 1884, Bronnley is renowned in fine soap-making inspired by British nature, with a reputation built on exceptional quality, craftsmanship and beautifully refined fragrance.
As suppliers of soap to the Royal Household, Bronnley proudly holds Royal Warrants from three generations of British monarchs - a testament to over 140 years of exceptional quality, craftsmanship and heritage. The brand is also known as a personal favourite of King Charles III. Proudly made in the UK, the entire collection is cruelty-free and vegan-friendly. Perfect for thoughtful gifting or elevating daily rituals, Bronnley remains a celebrated name in British fragrance and luxury toiletries.
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`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents` 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 = '5'
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (96385, 96386, 96387, 96390, 96392, 96388, 96389, 96391)) ORDER BY FIELD(e.entity_id,96385,96386,96387,96390,96392,96388,96389,96391)