| body |
{"product": {"rating": null, "rating_count": null, "brand": "California Gold Nutrition", "name": "California Gold Nutrition, Omega-3 Fish Oil, Vivomega Triglyceride, 1,000 mg, 90 Fish Gelatin Softgels", "description": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nFeaturing 1000 mg of Vivomega Triglyceride Fish Oil Concentrate400 mg EPA and 200 mg DHA per Fish SoftgelOmega-3 fatty acids are a type of good fat that are essential to the body, and they can often be found naturally in foods, especially fish. California Gold Nutrition\u00ae\u00a0Omega-3 Fish Oil\u00a0contains two types of omega-3s which can help support heart health.*Benefits of Omega-3 SupplementsA healthy, balanced diet should contain a daily dose of omega-3s, and if you can't get enough from food alone, a daily supplement could be the right solution. An omega-3 supplement can supply an adequate amount of these good fats, which may help provide a number of potentially heart-healthy benefits.* Omega-3s may help you maintain healthy levels of triglycerides and \u201cgood\u201d cholesterol, known as HDL.* In addition, it may support healthy blood pressure levels.*California Gold Nutrition\u00ae Omega-3 Fish Oil is formulated with premium fish oil concentrate and features both EPA and DHA in fish gelatin capsules. When taken as directed, this provides approximately a 3-month supply.iTested Verified\u00a0\n\n\n\n\nSpecifications\n\n\n First available: \n 11/2022 \n\n\n Shipping weight:\n \n 0.4 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: SPN-02140\nUPC: 898220021406\nPackage quantity:\n \n 90 count\n \n\n\n Dimensions:\n \n 4.3 x 2.35 x 2.35 in\n , \n 0.4 lb\n \n\n\n\nSame Formula, New Label. You may receive either package while we transition\n\n\n\n\n\n\n\n\nSuggested use\n\n\nTake 1 softgel daily, with food. Best when taken as directed by a qualified healthcare professional.\n\n\n\n\n\n\nOther ingredients\n\nMain IngredientsFish Oil Concentrate\u00a0Other IngredientsFish Gelatin Softgel (Gelatin, Vegetable Glycerin, Purified Water) and Mixed Tocopherols.\u00a0Contains: Fish (Anchovy & Tilapia), and Soy. Not manufactured with milk, eggs, crustacean shellfish, tree nuts, peanuts, wheat, sesame, or gluten. Produced in an FDA-registered, third-party audited, and cGMP-compliant facility that may process other products that contain these allergens or ingredients.\n\n\n\n\n\nWarnings\n\nKeep out of reach of children. Pregnant or lactating women, the chronically ill, elderly, individuals under the age of 18, those taking prescription medications (e.g ., blood thinners) as well as those with a physician-diagnosed medical condition should consult with a physician, pharmacist, naturopath or other qualified healthcare professional prior to taking dietary supplements.\u00a0Sealed for your protection. Do not use if seal is missing or broken. Store in a cool, dry place. Protect from heat, light, and moisture.\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\u00a0Servings Per Container:\u00a090\u00a0Amount Per Serving%Daily ValueCalories\u00a010\u00a0\u00a0Total Fat\u00a01 g\u00a01%*Fish Oil Concentrate\u00a01 g (1,000 mg)\u2020Total Omega-3 Fatty Acids as TG650 mg\u2020Eicosapentaenoic Acid (EPA as TG)400 mg\u2020Docosahexaenoic Acid (DHA as TG)200 mg\u2020*Percent Daily Values are based on a 2,000 calorie diet.\u2020Daily Value not established.\n\n\n\n\n\n\nVisit manufacturer's website", "data": {"dataFacets": []}, "categories": ["Brands A-Z > California Gold Nutrition", "Categories > Supplements > Omegas & Fish Oils (EPA DHA) > Omega-3 Fish Oil"], "gender": "Unisex", "product_images": [], "market_id": 89, "remote_code": "california-gold-nutrition-omega-3-fish-oil-vivomega-triglyceride", "is_lost": 0, "variants": [{"remote_code": "111468", "name": "California Gold Nutrition, Omega-3 Fish Oil, Vivomega Triglyceride, 1,000 mg, 240 Fish Softgels", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nFeaturing 1000 mg of Premium Fish Oil ConcentrateContains 650 mg Total Omega-3s with 400 mg EPA and 200 mg DHASupports Heart Health*California Gold Nutrition\u00ae Omega-3 Fish Oil is formulated with premium fish oil concentrate and features both EPA and DHA in fish gelatin capsules.iTested Verified\u00a0\n\n\n\n\nSpecifications\n\n\n First available: \n 10/2022 \n\n\n Shipping weight:\n \n 0.95 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: SPN-02141\nUPC: 898220021413\nPackage quantity:\n \n 240 count\n \n\n\n Dimensions:\n \n 6.2 x 3.15 x 3.15 in\n , \n 0.95 lb\n \n\n\n\nSame Formula, New Label. You may receive either package while we transition\n\n\n\n\n\n\n\n\nSuggested use\n\n\nTake 1 softgel daily, with food. Best when taken as directed by a qualified healthcare professional.\n\n\n\n\n\n\nOther ingredients\n\nMain IngredientsFish Oil Concentrate\u00a0Other IngredientsFish Gelatin Softgel (Gelatin, Vegetable Glycerin, Purified Water) and Mixed Tocopherols.\u00a0Contains: Fish (Anchovy & Tilapia), and Soy.\u00a0Not manufactured with milk, eggs, crustacean shellfish, tree nuts, peanuts, wheat, sesame, or gluten. Produced in an FDA-registered, third-party audited, and cGMP-compliant facility that may process other products that contain these allergens or ingredients.\n\n\n\n\n\nWarnings\n\nKeep out of reach of children. Pregnant or lactating women, the chronically ill, elderly, individuals under the age of 18, those taking prescription medications (e.g ., blood thinners) as well as those with a physician-diagnosed medical condition should consult with a physician, pharmacist, naturopath or other qualified healthcare professional prior to taking dietary supplements.\u00a0Sealed for your protection. Do not use if seal is missing or broken. Store in a cool, dry place. Protect from heat, light, and moisture.\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 SoftgelServings Per Container: 240\u00a0Amount Per Serving%Daily ValueCalories\u00a010\u00a0\u00a0Total Fat\u00a01 g\u00a01%*Fish Oil Concentrate\u00a01 g (1,000 mg)\u2020Total Omega-3 Fatty Acid as TG\u00a0650 mg\u00a0\u2020Eicosapentaenoic Acid (EPA as TG)400 mg\u00a0\u2020Docosahexaenoic Acid (DHA as TG)200 mg\u00a0\u2020*Percent Daily Values are based on a 2,000 calorie diet.\u2020Daily Value not established.\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "898220021413", "email_meta": "spn/spn02141", "remote_url": "https://www.iherb.com/pr/~/111468", "size": "NO_COLOR", "origin_color": "240 count", "price": 49.33, "variant_images": ["https://s3.images-iherb.com/spn/spn02141/l/47.jpg", "https://s3.images-iherb.com/spn/spn02141/l/52.jpg", "https://s3.images-iherb.com/spn/spn02141/l/55.jpg", "https://s3.images-iherb.com/spn/spn02141/l/9.jpg", "https://s3.images-iherb.com/spn/spn02141/l/93.jpg", "https://s3.images-iherb.com/spn/spn02141/l/57.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/spn/spn02141/l/47.jpg", "description": "Color: 240 count; Size: NO_COLOR", "colors": ["240 count"], "dosage": "", "combo_key": "NO_COLOR240 count"}, {"remote_code": "111467", "name": "California Gold Nutrition, Omega-3 Fish Oil, Vivomega Triglyceride, 1,000 mg, 90 Fish Gelatin Softgels", "description_front": "Product information\n\n\n\n\n\n\n\n\n\n\nOverview\n\nFeaturing 1000 mg of Vivomega Triglyceride Fish Oil Concentrate400 mg EPA and 200 mg DHA per Fish SoftgelOmega-3 fatty acids are a type of good fat that are essential to the body, and they can often be found naturally in foods, especially fish. California Gold Nutrition\u00ae\u00a0Omega-3 Fish Oil\u00a0contains two types of omega-3s which can help support heart health.*Benefits of Omega-3 SupplementsA healthy, balanced diet should contain a daily dose of omega-3s, and if you can't get enough from food alone, a daily supplement could be the right solution. An omega-3 supplement can supply an adequate amount of these good fats, which may help provide a number of potentially heart-healthy benefits.* Omega-3s may help you maintain healthy levels of triglycerides and \u201cgood\u201d cholesterol, known as HDL.* In addition, it may support healthy blood pressure levels.*California Gold Nutrition\u00ae Omega-3 Fish Oil is formulated with premium fish oil concentrate and features both EPA and DHA in fish gelatin capsules. When taken as directed, this provides approximately a 3-month supply.iTested Verified\u00a0\n\n\n\n\nSpecifications\n\n\n First available: \n 11/2022 \n\n\n Shipping weight:\n \n 0.4 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: SPN-02140\nUPC: 898220021406\nPackage quantity:\n \n 90 count\n \n\n\n Dimensions:\n \n 4.3 x 2.35 x 2.35 in\n , \n 0.4 lb\n \n\n\n\nSame Formula, New Label. You may receive either package while we transition\n\n\n\n\n\n\n\n\nSuggested use\n\n\nTake 1 softgel daily, with food. Best when taken as directed by a qualified healthcare professional.\n\n\n\n\n\n\nOther ingredients\n\nMain IngredientsFish Oil Concentrate\u00a0Other IngredientsFish Gelatin Softgel (Gelatin, Vegetable Glycerin, Purified Water) and Mixed Tocopherols.\u00a0Contains: Fish (Anchovy & Tilapia), and Soy. Not manufactured with milk, eggs, crustacean shellfish, tree nuts, peanuts, wheat, sesame, or gluten. Produced in an FDA-registered, third-party audited, and cGMP-compliant facility that may process other products that contain these allergens or ingredients.\n\n\n\n\n\nWarnings\n\nKeep out of reach of children. Pregnant or lactating women, the chronically ill, elderly, individuals under the age of 18, those taking prescription medications (e.g ., blood thinners) as well as those with a physician-diagnosed medical condition should consult with a physician, pharmacist, naturopath or other qualified healthcare professional prior to taking dietary supplements.\u00a0Sealed for your protection. Do not use if seal is missing or broken. Store in a cool, dry place. Protect from heat, light, and moisture.\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\u00a0Servings Per Container:\u00a090\u00a0Amount Per Serving%Daily ValueCalories\u00a010\u00a0\u00a0Total Fat\u00a01 g\u00a01%*Fish Oil Concentrate\u00a01 g (1,000 mg)\u2020Total Omega-3 Fatty Acids as TG650 mg\u2020Eicosapentaenoic Acid (EPA as TG)400 mg\u2020Docosahexaenoic Acid (DHA as TG)200 mg\u2020*Percent Daily Values are based on a 2,000 calorie diet.\u2020Daily Value not established.\n\n\n\n\n\n\nVisit manufacturer's website", "upc": "898220021406", "email_meta": "spn/spn02140", "remote_url": "https://www.iherb.com/pr/~/111467", "size": "NO_COLOR", "origin_color": "90 count", "price": 22.3, "variant_images": ["https://s3.images-iherb.com/spn/spn02140/l/58.jpg", "https://s3.images-iherb.com/spn/spn02140/l/63.jpg", "https://s3.images-iherb.com/spn/spn02140/l/66.jpg", "https://s3.images-iherb.com/spn/spn02140/l/18.jpg", "https://s3.images-iherb.com/spn/spn02140/l/104.jpg", "https://s3.images-iherb.com/spn/spn02140/l/68.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/spn/spn02140/l/58.jpg", "description": "Color: 90 count; Size: NO_COLOR", "colors": ["90 count"], "dosage": "", "combo_key": "NO_COLOR90 count"}]}, "remote_url": "https://api.scrape.do/?token=c38f147cd67c49d8a38cb4f2d704e6acf0663ff8c9d&super=true&geoCode=us&url=https://www.iherb.com/pr/~/111467", "parsing_type": "refresh", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'california-gold-nutrition-omega-3-fish-oil-vivomega-triglyceride' - parsed successfully. additional_error_text=''"} |
| 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)
|