25% off sitewide with code SNOW23 through 12/4. Members, sign in to save 30%. Shop now.
Save 25% on your Met Custom Prints order with code SNOW23 through 12/4. Shop now
Free standard shipping on orders of $125 or more. Shop now. See details.
25% off Sitewide
Members Save 30% Sitewide
Use code SNOW23 to save 25% on your purchase excluding tax, shipping/handling, and gift wrap charges. Offer ends 11:59 pm ET on 12/4/23. Available at The Met Store online only. Offer does not apply to prior purchases, clearance products, or select items including select 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 excluding tax, shipping/handling, and gift wrap charges. No promotion code required. See savings at checkout. Offer ends 11:59 pm ET on 12/4/23. Available at The Met Store online only. Offer does not apply to prior purchases, clearance products, or select items including select 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 excluding tax, shipping/handling, and gift wrap charges. No promotion code required. See savings at checkout. Offer ends 11:59 pm ET on 12/4/23. Available at The Met Store online only. Offer does not apply to prior purchases, clearance products, or select items including select 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.
25% Off at Met Custom Prints
Use code SNOW23 to save 25% on your Met Custom Prints purchase at customprints.metmuseum.org, excluding tax, shipping/handling, and gift wrap charges. Offer ends 11:59 pm ET on 12/4/23. Available at The Met Custom Prints online only. Offer does not apply to prior purchases, clearance products, purchases on The Met Store (store.metmuseum.org), or select items including Museum Admission, Museum Memberships, donations and eGift Certificates. Cannot be combined with other offers or discounts. Offer subject to change or cancellation without notice.
Free Shipping on $125+
Offer applies automatically at checkout. Valid online (store.metmuseum.org) 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, membership purchases, or select items with surcharges. Offer not available in our retail stores or Met Custom Prints (customprints.metmuseum.org) and 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 '1701406741')
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 '1701406741') WHERE (e.entity_id IN (183718, 163366, 164305, 183794, 183788)) ORDER BY FIELD(e.entity_id,183718,163366,164305,183794,183788)
Showing - of 5
Showing - of 5