id: 27280

Column Value
id 27280
brand ZARA
name STAIN QUEEN LIP STAIN & BALM
description Two-in-one lip tint and balm for natural color and irresistible lips.   Its fine tip allows for precise and defined application, while the creamy balm provides a juicy finish, enhancing your smile.   Available in two perfect shades for any occasion.
data {'dataFacets': []}
categories ['LIP MAKE UP - WOMAN']
gender WOMAN
market_id 65
remote_code stain-queen-lip-stain---balm-p24880325.html
is_lost 0
variants [{'upc': 'zaraQR:2488032567499', 'data': ['transfer'], 'isbn': None, 'name': None, 'size': 'ONE SIZE ONLY', 'price': 25.9, 'author': None, 'colors': ['RED THRONE'], 'dosage': None, 'flavor': None, 'weight': None, 'image_url': 'https://static.zara.net/assets/public/b8b6/e6f2/e50041cb8324/f639af70cc9a/24880325674-e1/24880325674-e1.jpg?ts=1764334840484&w=300', 'email_meta': '2488032567499', 'price_full': None, 'remote_url': 'https://www.zara.com/us/en/stain-queen-lip-stain---balm-p24880325.html?v1=554897625', 'sgr_number': None, 'description': 'Color: RED THRONE; Size: ONE SIZE ONLY', 'remote_code': '2488032567499-I2026', 'stock_count': 1, 'origin_color': 'RED THRONE', 'delivery_days': None, 'additional_upc': '554897625', 'expiration_str': None, 'variant_images': ['https://static.zara.net/assets/public/b8b6/e6f2/e50041cb8324/f639af70cc9a/24880325674-e1/24880325674-e1.jpg?ts=1764334840484&w={width}', 'https://static.zara.net/assets/public/143b/79c4/7b1d43c3b3a3/cd65cfcbad31/24880325674-ult12/24880325674-ult12.jpg?ts=1764332197434&w={width}', 'https://static.zara.net/assets/public/7a2b/d629/25eb44f5bf90/6c5256ada8d8/24820207626-1-p/24820207626-1-p.jpg?ts=1769875967259&w={width}', 'https://static.zara.net/assets/public/93a4/4973/c54940b6941e/5e3522292013/24880325674-e1/24880325674-e1.jpg?ts=1764334840210&w={width}'], 'expiration_date': None, 'description_front': None}, {'upc': 'zaraQR:2488032467399', 'data': ['transfer'], 'isbn': None, 'name': None, 'size': 'ONE SIZE ONLY', 'price': 25.9, 'author': None, 'colors': ['CROWNED PINK'], 'dosage': None, 'flavor': None, 'weight': None, 'image_url': 'https://static.zara.net/assets/public/2f56/ea7a/205e4f22958f/2bbd940a438e/24880324673-e1/24880324673-e1.jpg?ts=1764334840075&w=300', 'email_meta': '2488032467399', 'price_full': None, 'remote_url': 'https://www.zara.com/us/en/stain-queen-lip-stain---balm-p24880325.html?v1=554897686', 'sgr_number': None, 'description': 'Color: CROWNED PINK; Size: ONE SIZE ONLY', 'remote_code': '2488032467399-I2026', 'stock_count': 1, 'origin_color': 'CROWNED PINK', 'delivery_days': None, 'additional_upc': '554897686', 'expiration_str': None, 'variant_images': ['https://static.zara.net/assets/public/2f56/ea7a/205e4f22958f/2bbd940a438e/24880324673-e1/24880324673-e1.jpg?ts=1764334840075&w={width}', 'https://static.zara.net/assets/public/890e/612c/375b4fcc9e86/aece71937cc6/24880324673-p/24880324673-p.jpg?ts=1764238184153&w={width}', 'https://static.zara.net/assets/public/8e21/86ae/c89c445d8726/c019e6932535/24880324673-a1/24880324673-a1.jpg?ts=1764238183941&w={width}', 'https://static.zara.net/assets/public/9382/77c9/80724ff9903a/4b90f3f373b2/24880324673-e1/24880324673-e1.jpg?ts=1764334839922&w={width}'], 'expiration_date': None, 'description_front': None}]
date_created 2026-06-11 14:50:55.224334
date_modified 2026-07-16 14:16:23.087873