row_id: 43871

Column Value
row_id 43871
time_created 2026-06-22 15:48:14.200999
endpoint https://usmall-catalog.shopfans.io/log/product_upload
params
body {"product": {"rating": 5.0, "rating_count": 4, "brand": "Reserveage Beauty", "name": "Na-PCA with Aloe", "description": "PureFormulas is an authorized retailer of Reserveage Beauty products. You can shop with confidence, knowing that all products purchased from PureFormulas are authentic, and sourced directly from the brand. Reserveage Beauty Na-PCA with Aloe Hydrating Mist is a pH-balanced\u201a moisture-boosting solution designed to replenish and refresh your skin. Infused with sodium PCA\u201a a natural moisturizing factor found in human skin\u201a and high-quality aloe vera gel\u201a this mist helps retain hydration\u201a soothe irritation\u201a and enhance skin\u2019s natural radiance. Key Benefits & Features: \u2022 Deeply hydrates and replenishes moisture for a fresh\u201a dewy glow \u2022 Enriched with aloe vera to help soothe and calm the skin \u2022 Non-comedogenic and will not clog pores \u2022 Ideal for use under makeup or skincare products \u2022 Provides a cooling and refreshing sensation\u2014perfect for warm days \u2022 Helps improve the appearance of dry or aging skin Lightweight and fast-absorbing\u201a Reserveage Beauty Na-PCA with Aloe Hydrating Mist is an effortless way to keep your skin feeling soft\u201a refreshed\u201a and naturally radiant throughout the day. These statements have not been evaluated by the Food and Drug Administration (FDA). These products are not meant to diagnose\u201a treat or cure any disease or medical condition. Please consult your doctor before starting any exercise or nutritional supplement program or before using these or any product during pregnancy or if you have a serious medical condition. Report incorrect product information", "data": {"dataFacets": [], "product_id": "1000056928", "repository_id": "1000056928", "route": "/product/na-pca-with-aloe-by-reserveage-nutrition/1000056928", "part_number": null, "parent_category_id_path": "rootCategory>beauty", "product_type": "Product", "tags": [], "highlights": [], "main_ingredient": null}, "categories": ["Beauty"], "gender": null, "product_images": ["https://www.pureformulas.com/file/v8044176885629346278/products/na-pca-with-aloe-8-fl-oz-237-ml-by-reserveage-nutrition.jpg", "https://www.pureformulas.com/file/v4432769625926477468/products/na-pca-with-aloe-8-fl-oz-237-ml-by-reserveage-nutrition-extra1.jpg", "https://www.pureformulas.com/file/v6676496397797098961/products/na-pca-with-aloe-8-fl-oz-237-ml-by-reserveage-nutrition-extra2.jpg", "https://www.pureformulas.com/file/v8807374673531994137/products/na-pca-with-aloe-8-fl-oz-237-ml-by-reserveage-nutrition-extra3.jpg"], "market_id": 144, "remote_code": "1000056928", "is_lost": 0, "variants": [{"remote_code": "RLN1092", "upc": "835552001843", "remote_url": "https://www.pureformulas.com/product/na-pca-with-aloe-by-reserveage-nutrition/1000056928?skuId=RLN1092", "size": "8 fl. oz (237 ml)", "origin_color": "Default", "price": 11.43, "email_meta": "RLN1092", "variant_images": ["https://www.pureformulas.com/file/v8044176885629346278/products/na-pca-with-aloe-8-fl-oz-237-ml-by-reserveage-nutrition.jpg", "https://www.pureformulas.com/file/v4432769625926477468/products/na-pca-with-aloe-8-fl-oz-237-ml-by-reserveage-nutrition-extra1.jpg", "https://www.pureformulas.com/file/v6676496397797098961/products/na-pca-with-aloe-8-fl-oz-237-ml-by-reserveage-nutrition-extra2.jpg", "https://www.pureformulas.com/file/v8807374673531994137/products/na-pca-with-aloe-8-fl-oz-237-ml-by-reserveage-nutrition-extra3.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.pureformulas.com/file/v8044176885629346278/products/na-pca-with-aloe-8-fl-oz-237-ml-by-reserveage-nutrition.jpg", "description": "Size: 8 fl. oz (237 ml)", "colors": ["Default"], "additional_upc": "1000056928", "weight": 277}]}, "remote_url": "https://www.pureformulas.com/product/na-pca-with-aloe-by-reserveage-nutrition/1000056928", "type_parsing": "full", "parsing_type": "full", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '1000056928' - parsed successfully. additional_error_text=''"}
status_code 500
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)