Return to Previous Page
x

Marmalade of London

Marmalade of London

Immerse yourself in the world of Marmalade of London, a luxurious British brand that takes pride in creating exquisite candles in their eco-friendly factory nestled in the scenic Cotswolds region. The candles are crafted from natural ingredients, including essential oils and 100% soy wax, known to burn up to 50% longer than paraffin candles. To preserve the top notes of the fragrance, each candle is carefully crafted in small batches, with a wick size specifically selected to perfectly complement each fragrance. Marmalade of London remains steadfast in its commitment to never test any of its products on animals.

10% OFF Everything in our Winter Sale!

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`, `at_bestsellers`.`qty_ordered` AS `bestsellers`, `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 `amasty_sorting_bestsellers` AS `at_bestsellers` ON (at_bestsellers.`product_id`=e.entity_id) AND (at_bestsellers.store_id = '5') LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (73168, 73191, 73143, 73144, 73151, 73152, 73159, 73160, 73167, 73175, 73176, 73180, 73181, 73185, 73186, 73190, 73200, 73201, 73205, 73208, 76585, 76588, 76589, 76591, 76594, 76595, 79982, 79983, 76592, 76586)) ORDER BY FIELD(e.entity_id,73168,73191,73143,73144,73151,73152,73159,73160,73167,73175,73176,73180,73181,73185,73186,73190,73200,73201,73205,73208,76585,76588,76589,76591,76594,76595,79982,79983,76592,76586)

30 Items

Set Ascending Direction
per page

30 Items

Set Ascending Direction
per page
Fast and secure payment with:
Secure Payment Options
© 2023 - 2024