Memorial Day Sale: 25% off (30% off for Members) $125+ through 5/29 with code MEM23. Shop now.
Free standard shipping on orders of $125 or more. Shop now. See details.
Free Shipping on $125+
Offer applies automatically at checkout. Valid online only for standard shipping to addresses within the contiguous 48 states, on merchandise orders of $125 or more, excluding tax and gift wrap. Offer ends 12/31/23 at 11:59 PM ET and does not apply to prior purchases or select items with surcharges. Offer not available in our retail stores and subject to change or cancellation without notice. Void where prohibited.
25% off $125+
Members get 30% off $125+
Use code MEM23 to save 25% on your online order of $125 or more at store.metmuseum.org. Offer valid through 11:59pm ET on 5/29/23. Onetime use only. Discount does not apply to the purchase of The Met Custom Prints (customprints.metmuseum.org), Membership, Museum admission, donations, Gift Cards, eGift Certificates, prior purchases, or select items, and cannot be applied toward gift wrap, tax, or shipping/handling charges. One promotion code per order; cannot be combined with other offers or discounts, except Member discount. Void where prohibited.
Members save 30% off the original price on your purchase of $125 or more, excluding tax, shipping/handling, and gift wrap charges. No promotion code required. See savings at checkout. Offer ends 11:59 pm ET on 5/29/23. Available at The Met Store online only. Offer does not apply to prior purchases, clearance products, purchases on The Met Custom Prints (customprints.metmuseum.org), or select items including designer collaborations, Museum Admission, Museum Memberships, donations and eGift Certificates. Cannot be combined with other offers or discounts. Offer subject to change or cancellation without notice. Void where prohibited.
Members save 30% off the original price on your purchase of $125 or more, excluding tax, shipping/handling, and gift wrap charges. No promotion code required. See savings at checkout. Offer ends 11:59 pm ET on 5/29/23. Available at The Met Store online only. Offer does not apply to prior purchases, clearance products, purchases on The Met Custom Prints (customprints.metmuseum.org), or select items including designer collaborations, Museum Admission, Museum Memberships, donations and eGift Certificates. Cannot be combined with other offers or discounts. Offer subject to change or cancellation without notice. Void where prohibited.
Harlem Candle Co.
Showing 1 -
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`, `e`.`sku`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`url_key`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`giftcard_amounts`, `e`.`allow_open_amount`, `e`.`open_amount_min`, `e`.`open_amount_max`, `e`.`tax_class_id`, `e`.`swatch_image`, `e`.`was_price`, `e`.`member_price`, `e`.`member_was_price`, `e`.`launch_date`, `e`.`book_language`, `e`.`book_language_value`, `e`.`giftcard_amt`, `e`.`giftcard_amt_value`, `e`.`more_ways_to_shop`, `e`.`size_2`, `e`.`size_2_value`, `e`.`hover_image`, `e`.`bv_feed_exclude`, `e`.`sale_badge`, `e`.`am_shipping_type`, `e`.`am_shipping_type_value`, `e`.`price_range`, `e`.`bv_category_id`, `e`.`bv_category_id_value`, `e`.`custom_product_badge_block`, `e`.`pricing_details`, `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`, `product_entity`.`row_id`, `stock_status_index`.`stock_status` AS `is_salable`, `e_entity`.`row_id` FROM `catalog_product_flat_1` 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 `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = e.entity_id AND (product_entity.created_in '1685019601')
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
INNER JOIN `catalog_product_entity` AS `e_entity` ON e_entity.entity_id = e.entity_id AND (e_entity.created_in '1685019601') WHERE (e.entity_id IN (183718, 183721, 163366, 163372, 164305, 183791, 163375, 183794, 183788)) ORDER BY FIELD(e.entity_id,183718,183721,163366,163372,164305,183791,163375,183794,183788)
Showing - of 9
Showing - of 9