row_id: 42624

Column Value
row_id 42624
time_created 2026-06-22 10:35:23.540405
endpoint https://usmall-catalog.shopfans.io/log/product_upload
params
body {"product": {"rating": null, "rating_count": null, "brand": "Swanson Vitamins", "name": "Swanson Vitamins, Lyc-O-Mato\u00ae Lycopene, 20 mg, 60 Softgels", "description": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nProstate HealthDouble StrengthDietary SupplementIncreases Antioxidant Protection Against Free RadicalsSupports Prostate HealthMaintains Cardiovascular WellnessScience-Backed Quality Since 1969Lyc-O-Mato - Natural Tomato Lycopene\n\n\n\n\nSpecifications\n\n\n First available: \n 03/2023 \n\n\n Shipping weight:\n \n 0.18 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: SWV-21031\nUPC: 087614210315\nPackage quantity:\n \n 60 count\n \n\n\n Dimensions:\n \n 4.15 x 1.95 x 1.95 in\n , \n 0.19 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nAs a dietary supplement, take one softgel per day with food and water.\n\n\n\n\n\n\nOther ingredients\n\nSoybean oil, gelatin, glycerin, purified water, beeswax, carob.Contains a bioengineered food Ingredient.\n\n\n\n\n\nWarnings\n\nFor adults only. Consult your healthcare provider before using this or any product if you are pregnant or nursing, taking medication or have a medical condition.Keep out of reach of children. Do not use if seal is broken. Store in a cool, dry place. Do not refrigerate.\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\nSupplement factsServing Size:\u00a01 Softgel\u00a0Amount Per Serving%Daily ValueLyc-O-Mato\u00ae Tomato ExtractProviding:133 mg*\u00a0Lycopene20 mg\u00a0*\u00a0Natural Tocopherols2 mg\u00a0*\u00a0Phytoene and Phytofluene1.4 mg\u00a0*\u00a0*Daily Value not established.\n\n\n\n\n\n\nVisit manufacturer's website", "data": {"dataFacets": []}, "categories": ["Brands A-Z > Swanson Vitamins", "Categories > Supplements > Antioxidants > Lycopene"], "gender": "Unisex", "product_images": [], "market_id": 89, "remote_code": "swanson-lyc-o-mato-lycopene", "is_lost": 0, "variants": [{"remote_code": "119508", "name": "Swanson Vitamins, Lyc-O-Mato\u00ae Lycopene, 10 mg, 60 Softgels", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nProstate HealthDietary SupplementTotal Wellness\u00a0Unsurpassed Purity & PotencyScience-Backed Quality Since 1969As men get older, it becomes increasingly important to find ways to support prostate health. Swanson Lyc-O-Mato Lycopene is a full spectrum tomato concentrate extracted from a high-lycopene variety of tomato. This tomato extract is a member of the carotenoid family and provides a full compliment of antioxidants besides lycopene, which includes phytoene, phytofluene, beta-carotene, phytosterols, and vitamin E. Lycopene supports the fight against free radicals within the body and promotes a healthy defense against damage to cells and the immune system. The result is enhanced biological activity, which means greater health benefits for you!\n\n\n\n\nSpecifications\n\n\n First available: \n 04/2023 \n\n\n Shipping weight:\n \n 0.18 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: SWV-21022\nUPC: 087614210223\nPackage quantity:\n \n 60 count\n \n\n\n Dimensions:\n \n 4.15 x 1.95 x 1.95 in\n , \n 0.19 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nAs a dietary supplement, take one softgel per day with food and water.\n\n\n\n\n\n\nOther ingredients\n\nRice bran oil,\ngelatin, glycerin, yellow beeswax,\npurified water, silica.\n\n\n\n\n\nWarnings\n\nFor adults only. Consult your healthcare provider before using this or any product if you are pregnant or nursing, taking medication or have a medical condition.Keep out of reach of children. Do not use if seal is broken. Store in a cool, dry place. Do not refrigerate.\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\nSupplement factsServing Size: 1 Softgel\u00a0Amount Per Serving%Daily ValueLyc-O-Mato\u00ae Tomato ExtractProviding:Lycopene66.67 mg10 mg***Daily Value not established.\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "087614210223", "email_meta": "swv/swv21022", "remote_url": "https://www.iherb.com/pr/~/119508", "size": "10 mg", "origin_color": "NO_COLOR", "price": 12.54, "variant_images": ["https://s3.images-iherb.com/swv/swv21022/l/24.jpg", "https://s3.images-iherb.com/swv/swv21022/l/30.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/swv/swv21022/l/24.jpg", "description": "Color: NO_COLOR; Size: 10 mg", "colors": ["NO_COLOR"], "dosage": "", "combo_key": "10 mgNO_COLOR"}, {"remote_code": "116317", "name": "Swanson Vitamins, Lyc-O-Mato\u00ae Lycopene, 20 mg, 60 Softgels", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nProstate HealthDouble StrengthDietary SupplementIncreases Antioxidant Protection Against Free RadicalsSupports Prostate HealthMaintains Cardiovascular WellnessScience-Backed Quality Since 1969Lyc-O-Mato - Natural Tomato Lycopene\n\n\n\n\nSpecifications\n\n\n First available: \n 03/2023 \n\n\n Shipping weight:\n \n 0.18 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: SWV-21031\nUPC: 087614210315\nPackage quantity:\n \n 60 count\n \n\n\n Dimensions:\n \n 4.15 x 1.95 x 1.95 in\n , \n 0.19 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nAs a dietary supplement, take one softgel per day with food and water.\n\n\n\n\n\n\nOther ingredients\n\nSoybean oil, gelatin, glycerin, purified water, beeswax, carob.Contains a bioengineered food Ingredient.\n\n\n\n\n\nWarnings\n\nFor adults only. Consult your healthcare provider before using this or any product if you are pregnant or nursing, taking medication or have a medical condition.Keep out of reach of children. Do not use if seal is broken. Store in a cool, dry place. Do not refrigerate.\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\nSupplement factsServing Size:\u00a01 Softgel\u00a0Amount Per Serving%Daily ValueLyc-O-Mato\u00ae Tomato ExtractProviding:133 mg*\u00a0Lycopene20 mg\u00a0*\u00a0Natural Tocopherols2 mg\u00a0*\u00a0Phytoene and Phytofluene1.4 mg\u00a0*\u00a0*Daily Value not established.\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "087614210315", "email_meta": "swv/swv21031", "remote_url": "https://www.iherb.com/pr/~/116317", "size": "20 mg", "origin_color": "NO_COLOR", "price": 20.79, "variant_images": ["https://s3.images-iherb.com/swv/swv21031/l/24.jpg", "https://s3.images-iherb.com/swv/swv21031/l/30.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/swv/swv21031/l/24.jpg", "description": "Color: NO_COLOR; Size: 20 mg", "colors": ["NO_COLOR"], "dosage": "", "combo_key": "20 mgNO_COLOR"}, {"remote_code": "118536", "name": "Swanson Vitamins, Lyc-O-Mato\u00ae Lycopene, 60 Softgels", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nProstate HealthDietary SupplementPromotes a Healthy ProstatePowerful AntioxidantLycopene-Rich Complex of Plant NutrientsScience-Backed Quality Since 1969Get super-potent prostate and antioxidant support with Super-Strength Lyc-O-Mato Lycopene. It provides 40 mg of lycopene protection\u2014more than ever before! Lyc-O- Mato, a tomato extract, contains a full complement of antioxidants, including phytoene, phytofluene, beta-carotene, phytosterols with vitamin E and, of course, lycopene. One softgel per day helps you achieve superb antioxidant nourishment for the prostate, liver and heart!\n\n\n\n\nSpecifications\n\n\n First available: \n 06/2023 \n\n\n Shipping weight:\n \n 0.18 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: SWV-21023\nUPC: 087614210230\nPackage quantity:\n \n 60 count\n \n\n\n Dimensions:\n \n 4.15 x 1.95 x 1.95 in\n , \n 0.19 lb\n \n\n\n\n\n\n\n\n\n\nSuggested use\n\n\nAs a dietary supplement, take one softgel per day with food and water.\n\n\n\n\n\n\nOther ingredients\n\nSoftgel (gelatin, glycerin, purified water, caramel color), soybean oil, beeswax.Contains a bioengineered food\ningredient.\n\n\n\n\n\nWarnings\n\nFor adults only. Consult your healthcare provider before using this or any product if you are pregnant or nursing, taking medication or have a medical condition.\u00a0Keep out of reach of children. Do not use if seal is broken. Store in a cool, dry place. Do not refrigerate.\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\nSupplement factsServing Size: 1 Softgel\u00a0Amount Per Serving%Daily ValueLyc-O-Mato\u00ae Tomato Extractproviding:267 mg* Lycopene40 mg* Natural Tocopherols4 mg* Phytoene and Phytofluene 2.67 mg**Daily Value not established.\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "087614210230", "email_meta": "swv/swv21023", "remote_url": "https://www.iherb.com/pr/~/118536", "size": "40 mg", "origin_color": "NO_COLOR", "price": 43.09, "variant_images": ["https://s3.images-iherb.com/swv/swv21023/l/24.jpg", "https://s3.images-iherb.com/swv/swv21023/l/30.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/swv/swv21023/l/24.jpg", "description": "Color: NO_COLOR; Size: 40 mg", "colors": ["NO_COLOR"], "dosage": "", "combo_key": "40 mgNO_COLOR"}]}, "remote_url": "https://api.scrape.do/?token=c38f147cd67c49d8a38cb4f2d704e6acf0663ff8c9d&super=true&geoCode=us&url=https://www.iherb.com/pr/~/116317", "parsing_type": "refresh", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'swanson-lyc-o-mato-lycopene' - 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)