row_id: 35732

Column Value
row_id 35732
time_created 2026-06-20 23:24:40.279908
endpoint https://usmall-catalog.shopfans.io/log/product_upload
params
body {"product": {"category_meta_splitter": null, "meta_category": ["Target > Personal Care > Men\u2019s Grooming > Grooming Gifts for Men"], "origin_url": "https://www.target.com/c/grooming-gifts-for-men/-/N-ck9cw", "rating": 4.12, "rating_count": 17, "brand": "TONE", "name": "TONE On-The-Go Cologne and Body Mist - Vanilla - 100ml: Sulfate-Free, Spray, 1-Pack", "description": "TONE Vanilla On-The-Go Cologne & Body Mist for Men is designed for wherever the day takes you. This durable, portable spray delivers a premium fragrance experience with smooth, warm vanilla and a modern finish. Crafted to last throughout the day, the scent evolves as you wear it without feeling overpowering. Designed to layer seamlessly with other TONE Vanilla products, this cologne fits effortlessly into a simple daily grooming routine.<br /><br />What it is: A portable cologne and body mist for men that delivers long-lasting fragrance in an easy, on-the-go format.<br /><br />Who it\u2019s for: Men who want a premium scent they can reapply anytime throughout the day.<br /><br />Product Form: Spray<br /><br />Packaging: Durable pump bottle, no glass<br /><br />Fragrance Information:<br />- Fragrance Family: Warm<br />- Scent: Vanilla<br /><br />Scent Notes:<br />- Top \u2013 Lemon Zest, Wild Sage, Bergamot Peel<br />- Mid \u2013 Jasmine, Ocean Air<br />- Base \u2013 Vanilla Bean, Amberwood, Sandalwood<br /><br />How to Use:<br />- Spray generously onto body or clothing<br />- Reapply throughout the day as needed<br />- Avoid spraying directly into eyes<br />\n &bull;TONE \u2013 Fragrance-led personal care for men by AMP<br>&bull;ON-THE-GO FORMAT \u2013 Premium fragrance in a durable, portable spray<br>&bull;VANILLA SCENT \u2013 Smooth, warm vanilla with a modern edge<br>&bull;LONG-LASTING FRAGRANCE \u2013 Nuanced scent that evolves throughout the day<br>&bull;DURABLE PACKAGING \u2013 Built for gym bags, backpacks, and travel<br>&bull;LAYERABLE \u2013 Designed to pair with TONE Vanilla deodorant and body wash<br>&bull;EASY TO USE \u2013 Spray on anytime, anywhere<br>&bull;MADE IN USA \u2013 Made in the USA from globally sourced ingredients", "data": {"dataFacets": []}, "categories": ["Beauty > Fragrances > Men\u2019s Cologne"], "gender": "Men", "location": "OxfordValley;Neshaminy;PhiladelphiaRooseveltBlvd;AbingtonTownship;PhiladelphiaCottman", "product_images": [], "market_id": 84, "remote_code": "94877832", "is_lost": 0, "variants": [{"remote_code": "94877832", "upc": "860014324758", "remote_url": "https://www.target.com/p/~/-/A-94877832", "size": "N/A", "origin_color": "N/A", "price": 20.0, "price_full": null, "variant_images": ["https://target.scene7.com/is/image/Target/GUEST_5f9e1af8-e149-45d2-908b-cac771d8046a?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_19108be5-c094-47e9-bfa1-fee45bb68419?wid=1200&hei=1200", "https://target.scene7.com/is/image/Target/GUEST_f8dbbc8e-a96b-43c4-b86e-c345584ab619?wid=1200&hei=1200"], "stock_count": 1, "data": ["transfer"], "image_url": "https://target.scene7.com/is/image/Target/GUEST_f8dbbc8e-a96b-43c4-b86e-c345584ab619", "description": "Color: N/A; Size: N/A", "colors": ["N/A"]}]}, "remote_url": "https://www.target.com/p/~/-/A-94877832", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '94877832' - 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 496, in log_product_upload db.commit() File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2028, in commit trans.commit(_to_root=True) File "<string>", line 2, in commit File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go ret_value = fn(self, *arg, **kw) ^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1313, in commit self._prepare_impl() File "<string>", line 2, in _prepare_impl File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go ret_value = fn(self, *arg, **kw) ^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1288, in _prepare_impl self.session.flush() File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 4352, in flush self._flush(objects) File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 4487, in _flush with util.safe_reraise(): File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__ raise exc_value.with_traceback(exc_tb) File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 4448, in _flush flush_context.execute() File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute rec.execute(self) File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1233, in _emit_insert_statements result = connection.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)