Catalog Admin

row_id: 36331

Column	Value
row_id	36331
time_created	2026-06-21 06:20:23.523056
endpoint	https://usmall-catalog.shopfans.io/log/product_upload
params
body	{"product": {"rating": null, "rating_count": null, "brand": "Represent", "name": "Guns N' Roses Tour Crewneck T-Shirt", "description": "Crafted of a cotton and hemp blend, this crewneck T-shirt from Represent features Guns N' Roses tour graphics on the chest and reverse.<ul><li>Crewneck</li><li>Short sleeves</li><li>Pulls over</li><li>85% cotton/15% hemp</li><li>Machine wash</li><li>Made in Portugal</li></ul><br><b>SIZE & FIT</b><ul><li>Model measurements: 6'2\" tall, 40\" chest, 31\" waist</li><li>Model is wearing a US size Medium</li></ul>", "data": {"dataFacets": []}, "categories": ["Men's Apparel > T-Shirts > Graphic & Logo"], "gender": "Men's", "product_images": [], "market_id": 16, "remote_code": "0400026519586", "is_lost": 0, "variants": [{"remote_code": "26519606", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/26519606.html", "size": "X-Large", "origin_color": "STAINED BLACK", "price": 155.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_ASTL?wid=984&hei=1312&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A6?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: STAINED BLACK; Size: X-Large", "colors": ["STAINED BLACK"], "combo_key": "X-LargeSTAINED BLACK"}, {"remote_code": "26519604", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/26519604.html", "size": "Large", "origin_color": "STAINED BLACK", "price": 155.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_ASTL?wid=984&hei=1312&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A6?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: STAINED BLACK; Size: Large", "colors": ["STAINED BLACK"], "combo_key": "LargeSTAINED BLACK"}, {"remote_code": "26519602", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/26519602.html", "size": "Medium", "origin_color": "STAINED BLACK", "price": 155.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_ASTL?wid=984&hei=1312&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A6?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: STAINED BLACK; Size: Medium", "colors": ["STAINED BLACK"], "combo_key": "MediumSTAINED BLACK"}, {"remote_code": "26519600", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/26519600.html", "size": "Small", "origin_color": "STAINED BLACK", "price": 155.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_ASTL?wid=984&hei=1312&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK_A6?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_STAINEDBLACK?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: STAINED BLACK; Size: Small", "colors": ["STAINED BLACK"], "combo_key": "SmallSTAINED BLACK"}, {"remote_code": "26519593", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/26519593.html", "size": "Large", "origin_color": "FLAT WHITE", "price": 155.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_ASTL?wid=984&hei=1312&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A6?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: FLAT WHITE; Size: Large", "colors": ["FLAT WHITE"], "combo_key": "LargeFLAT WHITE"}, {"remote_code": "26519595", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/26519595.html", "size": "X-Large", "origin_color": "FLAT WHITE", "price": 155.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_ASTL?wid=984&hei=1312&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A6?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: FLAT WHITE; Size: X-Large", "colors": ["FLAT WHITE"], "combo_key": "X-LargeFLAT WHITE"}, {"remote_code": "26519591", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/26519591.html", "size": "Medium", "origin_color": "FLAT WHITE", "price": 155.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_ASTL?wid=984&hei=1312&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A6?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: FLAT WHITE; Size: Medium", "colors": ["FLAT WHITE"], "combo_key": "MediumFLAT WHITE"}, {"remote_code": "26519588", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/26519588.html", "size": "Small", "origin_color": "FLAT WHITE", "price": 155.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_ASTL?wid=984&hei=1312&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE_A6?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.saksfifthavenue.com/is/image/saks/0400026519586_FLATWHITE?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: FLAT WHITE; Size: Small", "colors": ["FLAT WHITE"], "combo_key": "SmallFLAT WHITE"}]}, "remote_url": "https://www.saksfifthavenue.com/on/demandware.store/Sites-SaksFifthAvenue-Site/en_US/Product-Variation?pid=0400026519586&quantity=1#0400026519586", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '0400026519586' - 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 705, in log_product_upload upsert_product_hash( File "/opt/working_folder/api/logging_router/api/product_logging.py", line 368, in upsert_product_hash db.execute(stmt) 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 2256, in _execute_internal 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)