id: 31701

Column Value
id 31701
remote_code P522447
market_id 51
history [{'data': {'data': {'dataFacets': []}, 'name': 'Guava Hair Oil for Split End Repair and Shine', 'brand': 'Ceremonia', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 1 oz / 30 ml', 'price': 34.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2982528-main-zoom.jpg?pb=clean-planet-aware', 'remote_url': 'https://www.sephora.com/product/P522447?skuId=2982528', 'description': 'Color: N/A; Size: Standard 1 oz / 30 ml', 'remote_code': '2982528', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2982528-main-zoom.jpg?pb=clean-planet-aware', 'https://www.sephora.com/productimages/sku/s2982528-av-10202603190659461190700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-11202603190659468370700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-1202603190659472950700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-13202603190659471600700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-14202603190659460570700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-2202603191027291570700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-3202603190659464800700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-4202603190659467320700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-5202603190659463280700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-6202603190659468960700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-7202603190659463780700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-8202603190659462890700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-9202603190659469480700-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Hair Styling & Treatments > Hair Oil'], 'description': '<b>What it is: </b>A daily, silicone-free gloss therapy oil powered by guava that’s clinically shown to boost shine and repair split ends while taming frizz.<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Concerns:<br></b>- Damage, Split Ends, and Breakage<br>- Frizz<br>- Shine<br><br><b>Key Benefits: <br></b>- Instant glass-like shine<br>- Reduce frizz and split ends<br>- Protects from heat-styling tools up to 445°F<br><br><b>Highlighted Ingredients:<br></b>- Guava Oil: Infuses hair with moisture and antioxidants, protecting hair against damage.<br>- Cacay Oil: Delivers frizz reduction, strand repair, silky shine, and heat protection.<br>- Aloe Vera Extract: Intensely hydrates and absorbs into strands to strengthen damaged ends.<br><br><b>Ingredient Callouts:</b> This product is vegan and cruelty-free.<br><br><b>What Else You Need to Know: </b>This lightweight leave-in oil spreads easily for instant glass-like shine and long-term softness. It’s clinically shown to deliver 2.8X more shine, 2.5X less frizz, and 2.2X fewer split ends after just one week and formulated with Ceremonia’s delicious signature guava scent.<br><br><b>Clinical Results:</b> After 1 week of daily use:<br>- 2.8X more shine<br>- 2.5X less frizz<br>- 2.2X split end repair<br><br><b>Clean + Planet Aware at Sephora<br></b>Products formulated without certain ingredients, including parabens, sulfates, phthalates, and mineral oils, from brands that have met our specific criteria for ingredient sourcing and formulation, packaging, environmental commitments, and consumer transparency. Learn more <a title="https://www.sephora.com/beauty/clean-planet-aware" href="https://www.sephora.com/beauty/clean-planet-aware">here</a>.', 'remote_code': 'P522447', 'partial_update': 0, 'product_images': []}, 'date': '2026-08-13 15:10:48'}, {'data': {'data': {'dataFacets': []}, 'name': 'Guava Hair Oil for Split End Repair and Shine', 'brand': 'Ceremonia', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 1 oz / 30 ml', 'price': 34.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2982528-main-zoom.jpg?pb=clean-planet-aware', 'remote_url': 'https://www.sephora.com/product/P522447?skuId=2982528', 'description': 'Color: N/A; Size: Standard 1 oz / 30 ml', 'remote_code': '2982528', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2982528-main-zoom.jpg?pb=clean-planet-aware', 'https://www.sephora.com/productimages/sku/s2982528-av-10202603190659461190700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-11202603190659468370700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-1202603190659472950700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-13202603190659471600700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-14202603190659460570700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-2202603191027291570700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-3202603190659464800700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-4202603190659467320700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-5202603190659463280700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-6202603190659468960700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-7202603190659463780700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-8202603190659462890700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-9202603190659469480700-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Hair Styling & Treatments > Hair Oil'], 'description': '<b>What it is: </b>A daily, silicone-free gloss therapy oil powered by guava that’s clinically shown to boost shine and repair split ends while taming frizz.<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Concerns:<br></b>- Damage, Split Ends, and Breakage<br>- Frizz<br>- Shine<br><br><b>Key Benefits: <br></b>- Instant glass-like shine<br>- Reduce frizz and split ends<br>- Protects from heat-styling tools up to 445°F<br><br><b>Highlighted Ingredients:<br></b>- Guava Oil: Infuses hair with moisture and antioxidants, protecting hair against damage.<br>- Cacay Oil: Delivers frizz reduction, strand repair, silky shine, and heat protection.<br>- Aloe Vera Extract: Intensely hydrates and absorbs into strands to strengthen damaged ends.<br><br><b>Ingredient Callouts:</b> This product is vegan and cruelty-free.<br><br><b>What Else You Need to Know: </b>This lightweight leave-in oil spreads easily for instant glass-like shine and long-term softness. It’s clinically shown to deliver 2.8X more shine, 2.5X less frizz, and 2.2X fewer split ends after just one week and formulated with Ceremonia’s delicious signature guava scent.<br><br><b>Clinical Results:</b> After 1 week of daily use:<br>- 2.8X more shine<br>- 2.5X less frizz<br>- 2.2X split end repair<br><br><b>Clean + Planet Aware at Sephora<br></b>Products formulated without certain ingredients, including parabens, sulfates, phthalates, and mineral oils, from brands that have met our specific criteria for ingredient sourcing and formulation, packaging, environmental commitments, and consumer transparency. Learn more <a title="https://www.sephora.com/beauty/clean-planet-aware" href="https://www.sephora.com/beauty/clean-planet-aware">here</a>.', 'remote_code': 'P522447', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-12 13:40:09'}, {'data': {'data': {'dataFacets': []}, 'name': 'Guava Hair Oil for Split End Repair and Shine', 'brand': 'Ceremonia', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 1 oz / 30 ml', 'price': 34.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2982528-main-zoom.jpg?pb=clean-planet-aware', 'remote_url': 'https://www.sephora.com/product/P522447?skuId=2982528', 'description': 'Color: N/A; Size: Standard 1 oz / 30 ml', 'remote_code': '2982528', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2982528-main-zoom.jpg?pb=clean-planet-aware', 'https://www.sephora.com/productimages/sku/s2982528-av-10202603190659461190700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-11202603190659468370700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-1202603190659472950700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-13202603190659471600700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-14202603190659460570700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-2202603191027291570700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-3202603190659464800700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-4202603190659467320700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-5202603190659463280700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-6202603190659468960700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-7202603190659463780700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-8202603190659462890700-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2982528-av-9202603190659469480700-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Hair Styling & Treatments > Hair Oil'], 'description': '<b>What it is: </b>A daily, silicone-free gloss therapy oil powered by guava that’s clinically shown to boost shine and repair split ends while taming frizz.<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Concerns:<br></b>- Damage, Split Ends, and Breakage<br>- Frizz<br>- Shine<br><br><b>Key Benefits: <br></b>- Instant glass-like shine<br>- Reduce frizz and split ends<br>- Protects from heat-styling tools up to 445°F<br><br><b>Highlighted Ingredients:<br></b>- Guava Oil: Infuses hair with moisture and antioxidants, protecting hair against damage.<br>- Cacay Oil: Delivers frizz reduction, strand repair, silky shine, and heat protection.<br>- Aloe Vera Extract: Intensely hydrates and absorbs into strands to strengthen damaged ends.<br><br><b>Ingredient Callouts:</b> This product is vegan and cruelty-free.<br><br><b>What Else You Need to Know: </b>This lightweight leave-in oil spreads easily for instant glass-like shine and long-term softness. It’s clinically shown to deliver 2.8X more shine, 2.5X less frizz, and 2.2X fewer split ends after just one week and formulated with Ceremonia’s delicious signature guava scent.<br><br><b>Clinical Results:</b> After 1 week of daily use:<br>- 2.8X more shine<br>- 2.5X less frizz<br>- 2.2X split end repair<br><br><b>Clean + Planet Aware at Sephora<br></b>Products formulated without certain ingredients, including parabens, sulfates, phthalates, and mineral oils, from brands that have met our specific criteria for ingredient sourcing and formulation, packaging, environmental commitments, and consumer transparency. Learn more <a title="https://www.sephora.com/beauty/clean-planet-aware" href="https://www.sephora.com/beauty/clean-planet-aware">here</a>.', 'remote_code': 'P522447', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-11 14:55:43'}]
date_created 2026-06-11 14:55:45.813620
date_modified 2026-08-13 15:10:48.782610