id: 28177

Column Value
id 28177
remote_code P477384
market_id 51
history [{'data': {'data': {'dataFacets': []}, 'name': 'African Black Soap Reviving Shampoo', 'brand': 'Melanin Haircare', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 16.5 oz / 490 ml', 'price': 32.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'remote_url': 'https://www.sephora.com/product/P477384?skuId=2538403', 'description': 'Color: N/A; Size: Standard 16.5 oz / 490 ml', 'remote_code': '2538403', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'https://www.sephora.com/productimages/sku/s2538403-av-02-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-08-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-10-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-11-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-12-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Shampoo & Conditioner > Shampoo'], 'description': '<b>What it is: </b>A mineral-rich clarifying black-soap shampoo enhanced with beneficial pro-vitamin B5, butters, and oils for soothing the scalp while hydrating and adding shine to hair.<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Concerns:<br></b>- Dryness<br>- Scalp Buildup<br>- Shine<br><br><b>Key Benefits: <br></b>- Visibly clarifies scalp product buildup<br>- Soothes and calms the appearance of scalp issues<br>- Hydrates and increases shine<br><br><b>Highlighted Ingredients:<br></b>- Tea Tree: Antiseptic, anti-inflammatory, and anti-fungal; helps to visibly remove buildup.<br>- Peppermint: Anti-inflammatory, anti-bacterial, anti-fungal; soothes and stimulates scalp.<br>- Black Cumin Seed: Anti-inflammatory, anti-bacterial, anti-fungal; conditions and soothes scalp.<br><br><b>Ingredient Callouts:</b> Free of parabens, formaldehydes, formaldehyde-releasing agents, phthalates, mineral oil, retinyl palmitate, oxybenzone, coal tar, hydroquinone, sulfates SLS & SLES, triclocarban, triclosan, and contains less than one percent synthetic fragrance. It is also vegan, gluten-free, cruelty-free, and comes in recyclable packaging.<br><br><b>What Else You Need to Know:</b> This effective clarifying shampoo leaves the hair and scalp visibly refreshed and hydrated while assisting in clumping curls. The charcoal powder helps to detoxify and gently exfoliate, while rosemary, turmeric root, argan, lavender, and cocoa butters help to moisturize and encourage healthy hair growth.<br><br><b>Fragrance Description:</b> Earthy with notes of peppermint and rosemary.', 'remote_code': 'P477384', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-16 18:56:14'}, {'data': {'data': {'dataFacets': []}, 'name': 'African Black Soap Reviving Shampoo', 'brand': 'Melanin Haircare', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 16.5 oz / 490 ml', 'price': 32.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'remote_url': 'https://www.sephora.com/product/P477384?skuId=2538403', 'description': 'Color: N/A; Size: Standard 16.5 oz / 490 ml', 'remote_code': '2538403', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'https://www.sephora.com/productimages/sku/s2538403-av-02-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-08-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-10-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-11-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-12-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Shampoo & Conditioner > Shampoo'], 'description': '<b>What it is: </b>A mineral-rich clarifying black-soap shampoo enhanced with beneficial pro-vitamin B5, butters, and oils for soothing the scalp while hydrating and adding shine to hair.<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Concerns:<br></b>- Dryness<br>- Scalp Buildup<br>- Shine<br><br><b>Key Benefits: <br></b>- Visibly clarifies scalp product buildup<br>- Soothes and calms the appearance of scalp issues<br>- Hydrates and increases shine<br><br><b>Highlighted Ingredients:<br></b>- Tea Tree: Antiseptic, anti-inflammatory, and anti-fungal; helps to visibly remove buildup.<br>- Peppermint: Anti-inflammatory, anti-bacterial, anti-fungal; soothes and stimulates scalp.<br>- Black Cumin Seed: Anti-inflammatory, anti-bacterial, anti-fungal; conditions and soothes scalp.<br><br><b>Ingredient Callouts:</b> Free of parabens, formaldehydes, formaldehyde-releasing agents, phthalates, mineral oil, retinyl palmitate, oxybenzone, coal tar, hydroquinone, sulfates SLS & SLES, triclocarban, triclosan, and contains less than one percent synthetic fragrance. It is also vegan, gluten-free, cruelty-free, and comes in recyclable packaging.<br><br><b>What Else You Need to Know:</b> This effective clarifying shampoo leaves the hair and scalp visibly refreshed and hydrated while assisting in clumping curls. The charcoal powder helps to detoxify and gently exfoliate, while rosemary, turmeric root, argan, lavender, and cocoa butters help to moisturize and encourage healthy hair growth.<br><br><b>Fragrance Description:</b> Earthy with notes of peppermint and rosemary.', 'remote_code': 'P477384', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-15 17:45:52'}, {'data': {'data': {'dataFacets': []}, 'name': 'African Black Soap Reviving Shampoo', 'brand': 'Melanin Haircare', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 16.5 oz / 490 ml', 'price': 32.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'remote_url': 'https://www.sephora.com/product/P477384?skuId=2538403', 'description': 'Color: N/A; Size: Standard 16.5 oz / 490 ml', 'remote_code': '2538403', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'https://www.sephora.com/productimages/sku/s2538403-av-02-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-08-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-10-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-11-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-12-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Shampoo & Conditioner > Shampoo'], 'description': '<b>What it is: </b>A mineral-rich clarifying black-soap shampoo enhanced with beneficial pro-vitamin B5, butters, and oils for soothing the scalp while hydrating and adding shine to hair.<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Concerns:<br></b>- Dryness<br>- Scalp Buildup<br>- Shine<br><br><b>Key Benefits: <br></b>- Visibly clarifies scalp product buildup<br>- Soothes and calms the appearance of scalp issues<br>- Hydrates and increases shine<br><br><b>Highlighted Ingredients:<br></b>- Tea Tree: Antiseptic, anti-inflammatory, and anti-fungal; helps to visibly remove buildup.<br>- Peppermint: Anti-inflammatory, anti-bacterial, anti-fungal; soothes and stimulates scalp.<br>- Black Cumin Seed: Anti-inflammatory, anti-bacterial, anti-fungal; conditions and soothes scalp.<br><br><b>Ingredient Callouts:</b> Free of parabens, formaldehydes, formaldehyde-releasing agents, phthalates, mineral oil, retinyl palmitate, oxybenzone, coal tar, hydroquinone, sulfates SLS & SLES, triclocarban, triclosan, and contains less than one percent synthetic fragrance. It is also vegan, gluten-free, cruelty-free, and comes in recyclable packaging.<br><br><b>What Else You Need to Know:</b> This effective clarifying shampoo leaves the hair and scalp visibly refreshed and hydrated while assisting in clumping curls. The charcoal powder helps to detoxify and gently exfoliate, while rosemary, turmeric root, argan, lavender, and cocoa butters help to moisturize and encourage healthy hair growth.<br><br><b>Fragrance Description:</b> Earthy with notes of peppermint and rosemary.', 'remote_code': 'P477384', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-14 13:05:48'}, {'data': {'data': {'dataFacets': []}, 'name': 'African Black Soap Reviving Shampoo', 'brand': 'Melanin Haircare', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 16.5 oz / 490 ml', 'price': 32.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'remote_url': 'https://www.sephora.com/product/P477384?skuId=2538403', 'description': 'Color: N/A; Size: Standard 16.5 oz / 490 ml', 'remote_code': '2538403', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'https://www.sephora.com/productimages/sku/s2538403-av-02-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-08-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-10-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-11-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-12-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Shampoo & Conditioner > Shampoo'], 'description': '<b>What it is: </b>A mineral-rich clarifying black-soap shampoo enhanced with beneficial pro-vitamin B5, butters, and oils for soothing the scalp while hydrating and adding shine to hair.<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Concerns:<br></b>- Dryness<br>- Scalp Buildup<br>- Shine<br><br><b>Key Benefits: <br></b>- Visibly clarifies scalp product buildup<br>- Soothes and calms the appearance of scalp issues<br>- Hydrates and increases shine<br><br><b>Highlighted Ingredients:<br></b>- Tea Tree: Antiseptic, anti-inflammatory, and anti-fungal; helps to visibly remove buildup.<br>- Peppermint: Anti-inflammatory, anti-bacterial, anti-fungal; soothes and stimulates scalp.<br>- Black Cumin Seed: Anti-inflammatory, anti-bacterial, anti-fungal; conditions and soothes scalp.<br><br><b>Ingredient Callouts:</b> Free of parabens, formaldehydes, formaldehyde-releasing agents, phthalates, mineral oil, retinyl palmitate, oxybenzone, coal tar, hydroquinone, sulfates SLS & SLES, triclocarban, triclosan, and contains less than one percent synthetic fragrance. It is also vegan, gluten-free, cruelty-free, and comes in recyclable packaging.<br><br><b>What Else You Need to Know:</b> This effective clarifying shampoo leaves the hair and scalp visibly refreshed and hydrated while assisting in clumping curls. The charcoal powder helps to detoxify and gently exfoliate, while rosemary, turmeric root, argan, lavender, and cocoa butters help to moisturize and encourage healthy hair growth.<br><br><b>Fragrance Description:</b> Earthy with notes of peppermint and rosemary.', 'remote_code': 'P477384', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-13 12:35:06'}, {'data': {'data': {'dataFacets': []}, 'name': 'African Black Soap Reviving Shampoo', 'brand': 'Melanin Haircare', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 16.5 oz / 490 ml', 'price': 32.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'remote_url': 'https://www.sephora.com/product/P477384?skuId=2538403', 'description': 'Color: N/A; Size: Standard 16.5 oz / 490 ml', 'remote_code': '2538403', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'https://www.sephora.com/productimages/sku/s2538403-av-02-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-08-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-10-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-11-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-12-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Shampoo & Conditioner > Shampoo'], 'description': '<b>What it is: </b>A mineral-rich clarifying black-soap shampoo enhanced with beneficial pro-vitamin B5, butters, and oils for soothing the scalp while hydrating and adding shine to hair.<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Concerns:<br></b>- Dryness<br>- Scalp Buildup<br>- Shine<br><br><b>Key Benefits: <br></b>- Visibly clarifies scalp product buildup<br>- Soothes and calms the appearance of scalp issues<br>- Hydrates and increases shine<br><br><b>Highlighted Ingredients:<br></b>- Tea Tree: Antiseptic, anti-inflammatory, and anti-fungal; helps to visibly remove buildup.<br>- Peppermint: Anti-inflammatory, anti-bacterial, anti-fungal; soothes and stimulates scalp.<br>- Black Cumin Seed: Anti-inflammatory, anti-bacterial, anti-fungal; conditions and soothes scalp.<br><br><b>Ingredient Callouts:</b> Free of parabens, formaldehydes, formaldehyde-releasing agents, phthalates, mineral oil, retinyl palmitate, oxybenzone, coal tar, hydroquinone, sulfates SLS & SLES, triclocarban, triclosan, and contains less than one percent synthetic fragrance. It is also vegan, gluten-free, cruelty-free, and comes in recyclable packaging.<br><br><b>What Else You Need to Know:</b> This effective clarifying shampoo leaves the hair and scalp visibly refreshed and hydrated while assisting in clumping curls. The charcoal powder helps to detoxify and gently exfoliate, while rosemary, turmeric root, argan, lavender, and cocoa butters help to moisturize and encourage healthy hair growth.<br><br><b>Fragrance Description:</b> Earthy with notes of peppermint and rosemary.', 'remote_code': 'P477384', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-12 17:41:05'}, {'data': {'data': {'dataFacets': []}, 'name': 'African Black Soap Reviving Shampoo', 'brand': 'Melanin Haircare', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 16.5 oz / 490 ml', 'price': 32.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'remote_url': 'https://www.sephora.com/product/P477384?skuId=2538403', 'description': 'Color: N/A; Size: Standard 16.5 oz / 490 ml', 'remote_code': '2538403', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'https://www.sephora.com/productimages/sku/s2538403-av-02-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-08-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-10-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-11-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-12-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Shampoo & Conditioner > Shampoo'], 'description': '<b>What it is: </b>A mineral-rich clarifying black-soap shampoo enhanced with beneficial pro-vitamin B5, butters, and oils for soothing the scalp while hydrating and adding shine to hair.<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Concerns:<br></b>- Dryness<br>- Scalp Buildup<br>- Shine<br><br><b>Key Benefits: <br></b>- Visibly clarifies scalp product buildup<br>- Soothes and calms the appearance of scalp issues<br>- Hydrates and increases shine<br><br><b>Highlighted Ingredients:<br></b>- Tea Tree: Antiseptic, anti-inflammatory, and anti-fungal; helps to visibly remove buildup.<br>- Peppermint: Anti-inflammatory, anti-bacterial, anti-fungal; soothes and stimulates scalp.<br>- Black Cumin Seed: Anti-inflammatory, anti-bacterial, anti-fungal; conditions and soothes scalp.<br><br><b>Ingredient Callouts:</b> Free of parabens, formaldehydes, formaldehyde-releasing agents, phthalates, mineral oil, retinyl palmitate, oxybenzone, coal tar, hydroquinone, sulfates SLS & SLES, triclocarban, triclosan, and contains less than one percent synthetic fragrance. It is also vegan, gluten-free, cruelty-free, and comes in recyclable packaging.<br><br><b>What Else You Need to Know:</b> This effective clarifying shampoo leaves the hair and scalp visibly refreshed and hydrated while assisting in clumping curls. The charcoal powder helps to detoxify and gently exfoliate, while rosemary, turmeric root, argan, lavender, and cocoa butters help to moisturize and encourage healthy hair growth.<br><br><b>Fragrance Description:</b> Earthy with notes of peppermint and rosemary.', 'remote_code': 'P477384', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-12 13:41:47'}, {'data': {'data': {'dataFacets': []}, 'name': 'African Black Soap Reviving Shampoo', 'brand': 'Melanin Haircare', 'gender': 'Female', 'is_lost': 0, 'variants': [{'upc': '', 'data': ['transfer'], 'size': 'Standard 16.5 oz / 490 ml', 'price': 32.0, 'colors': ['N/A'], 'image_url': 'https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'remote_url': 'https://www.sephora.com/product/P477384?skuId=2538403', 'description': 'Color: N/A; Size: Standard 16.5 oz / 490 ml', 'remote_code': '2538403', 'stock_count': 1, 'origin_color': 'N/A', 'variant_images': ['https://www.sephora.com/productimages/sku/s2538403-main-zoom.jpg?pb=clean-at-sephora', 'https://www.sephora.com/productimages/sku/s2538403-av-02-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-08-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-10-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-11-zoom.jpg', 'https://www.sephora.com/productimages/sku/s2538403-av-12-zoom.jpg']}], 'market_id': 51, 'categories': ['Hair > Shampoo & Conditioner > Shampoo'], 'description': '<b>What it is: </b>A mineral-rich clarifying black-soap shampoo enhanced with beneficial pro-vitamin B5, butters, and oils for soothing the scalp while hydrating and adding shine to hair.<br><br><b>Hair Type:</b> Fine, Medium, and Thick<br><br><b>Hair Texture:</b> Straight, Wavy, Curly, and Coily<br><br><b>Hair Concerns:<br></b>- Dryness<br>- Scalp Buildup<br>- Shine<br><br><b>Key Benefits: <br></b>- Visibly clarifies scalp product buildup<br>- Soothes and calms the appearance of scalp issues<br>- Hydrates and increases shine<br><br><b>Highlighted Ingredients:<br></b>- Tea Tree: Antiseptic, anti-inflammatory, and anti-fungal; helps to visibly remove buildup.<br>- Peppermint: Anti-inflammatory, anti-bacterial, anti-fungal; soothes and stimulates scalp.<br>- Black Cumin Seed: Anti-inflammatory, anti-bacterial, anti-fungal; conditions and soothes scalp.<br><br><b>Ingredient Callouts:</b> Free of parabens, formaldehydes, formaldehyde-releasing agents, phthalates, mineral oil, retinyl palmitate, oxybenzone, coal tar, hydroquinone, sulfates SLS & SLES, triclocarban, triclosan, and contains less than one percent synthetic fragrance. It is also vegan, gluten-free, cruelty-free, and comes in recyclable packaging.<br><br><b>What Else You Need to Know:</b> This effective clarifying shampoo leaves the hair and scalp visibly refreshed and hydrated while assisting in clumping curls. The charcoal powder helps to detoxify and gently exfoliate, while rosemary, turmeric root, argan, lavender, and cocoa butters help to moisturize and encourage healthy hair growth.<br><br><b>Fragrance Description:</b> Earthy with notes of peppermint and rosemary.', 'remote_code': 'P477384', 'partial_update': 0, 'product_images': []}, 'date': '2026-06-11 14:51:43'}]
date_created 2026-06-11 14:51:46.276070
date_modified 2026-06-16 18:56:17.607503