25% OFF $100+ WITH CODE SPRING24. MEMBERS, SIGN IN TO SAVE 30% ON $100+.
FREE STANDARD SHIPPING ON ORDERS OF $100 OR MORE. SHOP NOW. See details.
25% Off $100+
Members save 30% off $100+
Use code SPRING24 to save 25% on your purchase of $100+ excluding tax, shipping/handling, and gift wrap charges. Offer ends 11:59 pm ET on 4/29/24. 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 of $100+ excluding tax, shipping/handling, and gift wrap charges. No promotion code required. See savings at checkout. Offer ends 11:59 pm ET on 4/29/24. 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 of $100+ excluding tax, shipping/handling, and gift wrap charges. No promotion code required. See savings at checkout. Offer ends 11:59 pm ET on 4/29/24. 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.
Free Shipping on $100+
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 $100 or more, excluding tax and gift wrap. Offer ends 6/30/24 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.
Build-A-Bear Workshop
FILTERS Done
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 '1714136460')
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 '1714136460') WHERE (e.entity_id IN (197607)) ORDER BY FIELD(e.entity_id,197607)