| row_id |
44816 |
| time_created |
2026-06-22 20:30:38.494753 |
| endpoint |
https://usmall-catalog.shopfans.io/log/product_upload |
| params |
|
| body |
{"product": {"rating": null, "rating_count": null, "brand": "Tower 28 Beauty", "name": "SOS FaceGuard SPF 30 Mineral Sunscreen", "description": "<b>What it is: </b>A clinically-tested, non-greasy mineral SPF 30 made for sensitive and acne-prone skin that won\u2019t break you out or burn eyes.<br><br><b>Skin Type:</b> Normal, Dry, Combination, and Oily <br><br><b>Skincare Concerns:</b> Dryness<br><br><b>Formulation:</b> Cream<br><br><b>Highlighted Ingredients:<br></b>- Non-Nano Zinc Oxide: Provides broad-spectrum protection and is gentle on sensitive skin.<br>- Ceramide Blend: Supports skin barrier and helps skin retain moisture.<br>- Allantoin and Alpha Bisabolol: Calms and soothes skin.<br><br><b>Ingredient Callouts:</b> It is vegan and cruelty-free.<br><br><b>What Else You Need to Know:</b> With a whipped, creamy texture that feels more like a lightweight moisturizer, this non-acnegenic SPF hydrates, soothes, and leaves skin looking fresh. Designed to play nice with makeup, it doesn\u2019t pill when layered, and has a non-greasy, natural finish. SOS SPF is alcohol-free, oil-free, fragrance-free, ophthalmologist-tested, non-comedogenic and has been awarded the seal of acceptance from the National Eczema Association, National Rosacea Society, and National Psoriasis Foundation who clinically test for sensitivity, irritation, and toxicity.<br><br><b>Clinical Results:</b> Based on a third-party consumer test with 30 people, including those with sensitive skin:<br>100% agree this sunscreen did not burn their eyes<br>96% agree that this sunscreen did not break them out with regular use<br>96% agree that they did not experience pilling with this sunscreen", "data": {"dataFacets": []}, "categories": ["Skincare > Sunscreen > Face Sunscreen"], "gender": "Female", "product_images": [], "market_id": 51, "remote_code": "P515588", "is_lost": 0, "variants": [{"remote_code": "2892552", "upc": "", "remote_url": "https://www.sephora.com/product/P515588?skuId=2892552", "size": "Mini 0.68 fl oz / 20ml", "origin_color": "N/A", "price": 12.6, "price_full": 18.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2892552-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2892552-av-10202507151352482380700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2892552-av-1202507151352487670700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2892552-av-2202507151352488130700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2892552-av-3202507151352528080700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2892552-av-4202507151353019400700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2892552-av-5202507151352540260700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2892552-av-6202507151352531390700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2892552-av-7202507151352508570700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2892552-av-8202507151353017790700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2892552-av-9202507151352495600700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2892552-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: N/A; Size: Mini 0.68 fl oz / 20ml", "colors": ["N/A"]}, {"remote_code": "2871234", "upc": "", "remote_url": "https://www.sephora.com/product/P515588?skuId=2871234", "size": "Standard 1.7 oz / 50 ml", "origin_color": "N/A", "price": 22.4, "price_full": 32.0, "variant_images": ["https://www.sephora.com/productimages/sku/s2871234-main-zoom.jpg?pb=clean-at-sephora", "https://www.sephora.com/productimages/sku/s2871234-av-01-zoom.jpg", "https://www.sephora.com/productimages/sku/s2871234-av-02-zoom.jpg", "https://www.sephora.com/productimages/sku/s2871234-av-04-zoom.jpg", "https://www.sephora.com/productimages/sku/s2871234-av-06-zoom.jpg", "https://www.sephora.com/productimages/sku/s2871234-av-07-zoom.jpg", "https://www.sephora.com/productimages/sku/s2871234-av-09-zoom.jpg", "https://www.sephora.com/productimages/sku/s2871234-av-10-zoom.jpg", "https://www.sephora.com/productimages/sku/s2871234-av-3202505300242219480700-zoom.jpg", "https://www.sephora.com/productimages/sku/s2871234-av-8202505311016469350700-zoom.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://www.sephora.com/productimages/sku/s2871234-main-zoom.jpg?pb=clean-at-sephora", "description": "Color: N/A; Size: Standard 1.7 oz / 50 ml", "colors": ["N/A"]}]}, "remote_url": "https://www.sephora.com/product/P515588", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'P515588' - 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)
|