| body |
{"product": {"rating": null, "rating_count": null, "brand": "Palmer's", "name": "Palmer's, Shea Butter Formula\u00ae with Vitamin E, Body Balm, 7.25 oz (200 g)", "description": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nRaw Shea Nourish48 Hours MoistureDermatologist ApprovedVitamin Infused To Restore & Revitalize SkinSuitable For Sensitive Skin & Eczema-Prone Skin\u00a0Paraben, Phthalate & Dye FreeVegan FriendlyFamily Owned & OperatedEthically & Sustainably Sourced Ingredients\u00a0Soothe and Nourish head-to-toe with Palmer's\u00ae Shea Butter Formula\u24c7 Balm, crafted with raw African Shea Butter and concentrated to rehydrate the roughest, driest skin.Shea Butter (Butyrospermum Parkii)*:Sustainably produced, raw shea butter contains important vitamins and micro-nutrients, making it a superior skin-friendly moisturizer particularly for soothing sensitive skin.*Ethically traded and sustainably produced.\n\n\n\n\nSpecifications\n\n\n First available: \n 07/2013 \n\n\n Shipping weight:\n \n 0.6 lb\n \n\n\n\n\n\n\n\n\nShipping weight\nThe Shipping Weight includes the product, protective packaging material and the actual shipping box. In addition, the Shipping Weight may be adjusted for the Dimensional Weight (e.g. length, width & height) of a package. It is important to note that certain types of products (e.g. glass containers, liquids, fragile, refrigerated or ice packed) will often require protective packaging material. As such, these products will reflect a higher Shipping Weight compared to the unprotected product.\n\n\n\n\nProduct code: PAL-05008\nUPC: 010181050084\nPackage quantity:\n \n 7.25 oz\n \n\n\n Dimensions:\n \n 3.6 x 3.6 x 2.7 in\n , \n 0.6 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nApply to moisture-thirsty areas such as cuticles or cracked heels. Solid formula won't melt or get messy in the heat!\n\n\n\n\n\n\nOther ingredients\n\nButyrospermum parkii (shea) butter, glycine soja (soybean) oil, canola oil, helianthus annuus (sunflower seed oil, microcrystalline wax (cera microcristallina), cocos nucifera (coconut) oil, ozokerite, theobroma cacao (cocoa) seed butter, tocopheryl acetate, fragrance (parfum), benzyl benzoate, benzyl salicylate, hexyl cinnamal, benzyl alcohol.Made in USA with domestic and imported components.\u00a0\n\n\n\n\n\nWarnings\n\nDue to high concentration of natural ingredient, product color and consistency may vary.For external use only. Keep out of the reach of children. Avoid contact with eyes.\u00a0\n\n\n\n\n\nDisclaimer\n\n\nWhile iHerb strives to ensure the accuracy of its product images and information, some manufacturing changes to packaging and/or ingredients may be pending update on our site. Although items may occasionally ship with alternate packaging, freshness is always guaranteed. We recommend that you read labels, warnings and directions of all products before use and not rely solely on the information provided by iHerb.\n\n\n\n\n\n\nVisit manufacturer's website\n\n\n\n\n\n\n\n\n\n\n\nVisit manufacturer's website", "data": {"dataFacets": []}, "categories": ["Brands A-Z > Palmer's", "Categories > Bath & Personal Care > Body Care > Lotion > Shea Butter Lotion", "Categories > Beauty > Beauty by Ingredient > Vitamin E Skin Care"], "gender": "Unisex", "product_images": [], "market_id": 89, "remote_code": "palmer-s-shea-ya-forml-e-vitaminli-vcut-balsam", "is_lost": 0, "variants": [{"remote_code": "51542", "name": "Palmer's, Shea Butter Formula\u00ae with Vitamin E, Daily Body Lotion, Raw Shea, 8.5 fl oz (250 ml)", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nRaw Shea NourishRichly Replenishes Skin48 Hour MoistureVitamin InfusedTo Restore & Revitalize SkinDermatologist ApprovedSuitable for Sensitive & Eczema-Prone SkinVegan FriendlyFamily Owned & OperatedEthically & Sustainably Sourced IngredientsSoothe and Nourish skin with Palmer's\u00ae Shea Butter Formula\u00ae daily body lotion, crafted with vitamin-enriched Shea Butter to richly replenish dry, sensitive skin.Shea Butter (Butyrospermum Parkii)*: Sustainably produced, raw shea butter contains important vitamins and micro-nutrients, making it a superior skin-friendly moisturizer particularly for soothing sensitive skin.*Ethically traded and sustainably produced\n\n\n\n\nSpecifications\n\n\n First available: \n 07/2013 \n\n\n Shipping weight:\n \n 0.74 lb\n \n\n\n\n\n\n\n\n\nShipping weight\nThe Shipping Weight includes the product, protective packaging material and the actual shipping box. In addition, the Shipping Weight may be adjusted for the Dimensional Weight (e.g. length, width & height) of a package. It is important to note that certain types of products (e.g. glass containers, liquids, fragile, refrigerated or ice packed) will often require protective packaging material. As such, these products will reflect a higher Shipping Weight compared to the unprotected product.\n\n\n\n\nProduct code: PAL-05180\nUPC: 010181051807\nPackage quantity:\n \n 8.5 fl oz\n \n\n\n Dimensions:\n \n 7.5 x 3.2 x 1.6 in\n , \n 0.74 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nUse daily on clean, dry skin.\n\n\n\n\n\n\nOther ingredients\n\nWater (aqua), glycine soja (soybean) oil, butyrospermum parkii (shea) butter, isopropyl myristate, propylene glycol, cetyl alcohol, palmitic acid, stearic acid, tocopheryl acetate, aloe barbadensis leaf juice, vitis vinifera (grape) seed oil, sclerocarya birrea seed oil, helianthus annuus (sunflower) seed oil, avena sativa (oat) meal extract, stearyl alcohol, peg-40 stearate, carbomer, sodium hydroxide, ethylhexylglycerin, tetrasodium edta, sodium metabisulfite, sodium sulfite, phenoxyethanol, fragrance (parfum), benzyl benzoate, benzyl salicylate, hexyl cinnamal, benzyl alcohol, hexamethylindanopyran, vanillin.Made in USA with domestic and imported components.\n\n\n\n\n\nWarnings\n\nDue to high concentration of natural ingredients, product color and consistency may vary.For external use only. Avoid contact with eyes. Keep out of reach of children.\n\n\n\n\n\nDisclaimer\n\n\nWhile iHerb strives to ensure the accuracy of its product images and information, some manufacturing changes to packaging and/or ingredients may be pending update on our site. Although items may occasionally ship with alternate packaging, freshness is always guaranteed. We recommend that you read labels, warnings and directions of all products before use and not rely solely on the information provided by iHerb.\n\n\n\n\n\n\nVisit manufacturer's website\n\n\n\n\n\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "010181051807", "email_meta": "pal/pal05180", "remote_url": "https://www.iherb.com/pr/~/51542", "size": "8.5 fl oz", "origin_color": "Lotion", "price": 5.17, "variant_images": ["https://s3.images-iherb.com/pal/pal05180/l/35.jpg", "https://s3.images-iherb.com/pal/pal05180/l/39.jpg", "https://s3.images-iherb.com/cms/banners/dPDP-US-JP-Quality-Promise_007en-us.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://s3.images-iherb.com/pal/pal05180/l/35.jpg", "description": "Color: Lotion; Size: 8.5 fl oz", "colors": ["Lotion"], "combo_key": "8.5 fl ozLotion"}, {"remote_code": "26942", "name": "Palmer's, Shea Butter Formula\u00ae with Vitamin E, Daily Body Lotion, 13.5 fl oz (400 ml)", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nRaw Shea NourishRichly Replenishes Skin\u00a048 Hour MoistureDermatologist ApprovedVitamin InfusedTo Restore & Revitalize SkinSuitable for Sensitive & Eczema-Prone SkinParaben, Phthalate & Dye FreeNo Animal IngredientsFamily Owned & OperatedEthically & Sustainably Sourced IngredientsSoothe and Nourish skin with Palmer's\u00ae Shea Butter Formula\u00ae daily body lotion, crafted with vitamin-enriched Shea Butter to richly replenish dry, sensitive skin.\u00a0Shea Butter (Butyrospermum Parkii) *: Sustainably produced, raw shea butter contains important vitamins and micro-nutrients, making it a superior skin-friendly moisturizer particularly for soothing sensitive skin.*Ethically traded and sustainably produced\n\n\n\n\nSpecifications\n\n\n First available: \n 01/2011 \n\n\n Shipping weight:\n \n 0.95 lb\n \n\n\n\n\n\n\n\n\nShipping weight\nThe Shipping Weight includes the product, protective packaging material and the actual shipping box. In addition, the Shipping Weight may be adjusted for the Dimensional Weight (e.g. length, width & height) of a package. It is important to note that certain types of products (e.g. glass containers, liquids, fragile, refrigerated or ice packed) will often require protective packaging material. As such, these products will reflect a higher Shipping Weight compared to the unprotected product.\n\n\n\n\nProduct code: PAL-05165\nUPC: 010181051654\nPackage quantity:\n \n 13.5 fl oz\n \n\n\n Dimensions:\n \n 1.9 x 3 x 9 in\n , \n 0.95 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nUse daily on clean, dry skin.\n\n\n\n\n\n\nOther ingredients\n\nWater (aqua), glycine soja (soybean) oil, butyrospermum parkii (shea) butter, isopropyl myristate, propylene glycol, cetyl alcohol, palmitic acid, stearic acid, tocopheryl acetate, aloe barbadensis leaf juice, vitis vinifera (grape) seed oil, sclerocarya birrea seed oil, helianthus annuus (sunflower) seed oil, avena sativa (oat) meal extract, stearyl alcohol, peg-40 stearate, carbomer, sodium hydroxide, ethylhexylglycerin, fragrance (parfum), phenoxyethanol, tetrasodium edta, sodium metabisulfite, sodium sulfite, benzyl benzoate, benzyl salicylate, hexyl cinnamal, benzyl alcohol.\n\n\n\n\n\nWarnings\n\nFor external use only. Avoid contact with eyes. Keep out of reach of children.\u00a0Due to high concentration of natural ingredients, product color and consistency may vary.\n\n\n\n\n\nDisclaimer\n\n\nWhile iHerb strives to ensure the accuracy of its product images and information, some manufacturing changes to packaging and/or ingredients may be pending update on our site. Although items may occasionally ship with alternate packaging, freshness is always guaranteed. We recommend that you read labels, warnings and directions of all products before use and not rely solely on the information provided by iHerb.\n\n\n\n\n\n\nVisit manufacturer's website\n\n\n\n\n\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "010181051654", "email_meta": "pal/pal05165", "remote_url": "https://www.iherb.com/pr/~/26942", "size": "13.5 fl oz", "origin_color": "Lotion", "price": 6.7, "variant_images": ["https://s3.images-iherb.com/pal/pal05165/l/33.jpg", "https://s3.images-iherb.com/pal/pal05165/l/37.jpg", "https://s3.images-iherb.com/cms/banners/dPDP-US-JP-Quality-Promise_007en-us.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://s3.images-iherb.com/pal/pal05165/l/33.jpg", "description": "Color: Lotion; Size: 13.5 fl oz", "colors": ["Lotion"], "combo_key": "13.5 fl ozLotion"}, {"remote_code": "51541", "name": "Palmer's, Shea Butter Formula\u00ae with Vitamin E, Body Balm, 7.25 oz (200 g)", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nRaw Shea Nourish48 Hours MoistureDermatologist ApprovedVitamin Infused To Restore & Revitalize SkinSuitable For Sensitive Skin & Eczema-Prone Skin\u00a0Paraben, Phthalate & Dye FreeVegan FriendlyFamily Owned & OperatedEthically & Sustainably Sourced Ingredients\u00a0Soothe and Nourish head-to-toe with Palmer's\u00ae Shea Butter Formula\u24c7 Balm, crafted with raw African Shea Butter and concentrated to rehydrate the roughest, driest skin.Shea Butter (Butyrospermum Parkii)*:Sustainably produced, raw shea butter contains important vitamins and micro-nutrients, making it a superior skin-friendly moisturizer particularly for soothing sensitive skin.*Ethically traded and sustainably produced.\n\n\n\n\nSpecifications\n\n\n First available: \n 07/2013 \n\n\n Shipping weight:\n \n 0.6 lb\n \n\n\n\n\n\n\n\n\nShipping weight\nThe Shipping Weight includes the product, protective packaging material and the actual shipping box. In addition, the Shipping Weight may be adjusted for the Dimensional Weight (e.g. length, width & height) of a package. It is important to note that certain types of products (e.g. glass containers, liquids, fragile, refrigerated or ice packed) will often require protective packaging material. As such, these products will reflect a higher Shipping Weight compared to the unprotected product.\n\n\n\n\nProduct code: PAL-05008\nUPC: 010181050084\nPackage quantity:\n \n 7.25 oz\n \n\n\n Dimensions:\n \n 3.6 x 3.6 x 2.7 in\n , \n 0.6 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nApply to moisture-thirsty areas such as cuticles or cracked heels. Solid formula won't melt or get messy in the heat!\n\n\n\n\n\n\nOther ingredients\n\nButyrospermum parkii (shea) butter, glycine soja (soybean) oil, canola oil, helianthus annuus (sunflower seed oil, microcrystalline wax (cera microcristallina), cocos nucifera (coconut) oil, ozokerite, theobroma cacao (cocoa) seed butter, tocopheryl acetate, fragrance (parfum), benzyl benzoate, benzyl salicylate, hexyl cinnamal, benzyl alcohol.Made in USA with domestic and imported components.\u00a0\n\n\n\n\n\nWarnings\n\nDue to high concentration of natural ingredient, product color and consistency may vary.For external use only. Keep out of the reach of children. Avoid contact with eyes.\u00a0\n\n\n\n\n\nDisclaimer\n\n\nWhile iHerb strives to ensure the accuracy of its product images and information, some manufacturing changes to packaging and/or ingredients may be pending update on our site. Although items may occasionally ship with alternate packaging, freshness is always guaranteed. We recommend that you read labels, warnings and directions of all products before use and not rely solely on the information provided by iHerb.\n\n\n\n\n\n\nVisit manufacturer's website\n\n\n\n\n\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "010181050084", "email_meta": "pal/pal05008", "remote_url": "https://www.iherb.com/pr/~/51541", "size": "7.25 oz", "origin_color": "Balm", "price": 8.39, "variant_images": ["https://s3.images-iherb.com/pal/pal05008/l/37.jpg", "https://s3.images-iherb.com/pal/pal05008/l/42.jpg", "https://s3.images-iherb.com/pal/pal05008/l/46.jpg", "https://s3.images-iherb.com/cms/banners/dPDP-US-JP-Quality-Promise_007en-us.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://s3.images-iherb.com/pal/pal05008/l/37.jpg", "description": "Color: Balm; Size: 7.25 oz", "colors": ["Balm"], "combo_key": "7.25 ozBalm"}]}, "remote_url": "https://api.scrape.do/?token=c38f147cd67c49d8a38cb4f2d704e6acf0663ff8c9d&super=true&geoCode=us&url=https://www.iherb.com/pr/~/51541", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'palmer-s-shea-ya-forml-e-vitaminli-vcut-balsam' - parsed successfully. additional_error_text=''"} |
| error_text |
File "/opt/working_folder/middlewares/catch_errors_middleware/catch_500_errors.py", line 15, in dispatch
response = await call_next(request)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 84, in call_next
raise app_exc
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 70, in coro
await self.app(scope, receive_or_disconnect, send_no_error)
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/cors.py", line 83, in __call__
await self.app(scope, receive, send)
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 79, in __call__
raise exc
File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 68, in __call__
await self.app(scope, receive, sender)
File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 20, in __call__
raise e
File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 17, in __call__
await self.app(scope, receive, send)
File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 718, in __call__
await route.handle(scope, receive, send)
File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 276, in handle
await self.app(scope, receive, send)
File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 66, in app
response = await func(request)
^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 274, in app
raw_response = await run_endpoint_function(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 193, in run_endpoint_function
return await run_in_threadpool(dependant.call, **values)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/starlette/concurrency.py", line 41, in run_in_threadpool
return await anyio.to_thread.run_sync(func, *args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/anyio/to_thread.py", line 33, in run_sync
return await get_asynclib().run_sync_in_worker_thread(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 877, in run_sync_in_worker_thread
return await future
^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 807, in run
result = context.run(func, *args)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/working_folder/api/logging_router/api/product_logging.py", line 495, in log_product_upload
add_product_history(db, market_id, remote_code, json_data)
File "/opt/working_folder/api/logging_router/api/product_logging.py", line 319, in add_product_history
.first()
^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2728, in first
return self.limit(1)._iter().first() # type: ignore
^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2827, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2362, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2247, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 305, in orm_execute_statement
result = conn.execute(
^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1418, in execute
return meth(
^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute
cursor.execute(statement, parameters)
|