| body |
{"product": {"rating": null, "rating_count": null, "brand": "ALO Yoga", "name": "Alosoft High-Waist 7/8 Highlight Legging - Black", "description": "<p>This staple does double duty. The Alosoft High-Waist 7/8 Highlight Legging is teched out for yoga and velvet-soft for whatever\u2019s next. With a clean finish and contouring back seam, it goes great with all your favorite Alo.</p> True to size\u2014designed with light compression for a comfortable fit Inseam lengths by measurement: XXS, XS & S - 24\"; M & L - 24.5\" Ultra-light, breathable signature Alosoft fabric 87% Polyester, 13% Elastane", "data": {"dataFacets": []}, "categories": ["Legging"], "gender": "women", "product_images": [], "market_id": 95, "remote_code": "w51104r", "is_lost": 0, "variants": [{"remote_code": "40028489056436", "upc": "W51104R010", "additional_upc": "v=1736468996", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-black?variant=40028489056436", "size": "XXS", "origin_color": "Black", "price": 108.0, "price_full": null, "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a2_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a3_1_m91.jpg?v=1736468996"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "description": "Color: Black; Size: XXS", "colors": ["Black"]}, {"remote_code": "40028489089204", "upc": "W51104R011", "additional_upc": "v=1736468996", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-black?variant=40028489089204", "size": "XS", "origin_color": "Black", "price": 108.0, "price_full": null, "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a2_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a3_1_m91.jpg?v=1736468996"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "description": "Color: Black; Size: XS", "colors": ["Black"]}, {"remote_code": "40028489121972", "upc": "W51104R012", "additional_upc": "v=1736468996", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-black?variant=40028489121972", "size": "S", "origin_color": "Black", "price": 108.0, "price_full": null, "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a2_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a3_1_m91.jpg?v=1736468996"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "description": "Color: Black; Size: S", "colors": ["Black"]}, {"remote_code": "40028489154740", "upc": "W51104R013", "additional_upc": "v=1736468996", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-black?variant=40028489154740", "size": "M", "origin_color": "Black", "price": 108.0, "price_full": null, "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a2_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a3_1_m91.jpg?v=1736468996"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "description": "Color: Black; Size: M", "colors": ["Black"]}, {"remote_code": "40028489187508", "upc": "W51104R014", "additional_upc": "v=1736468996", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-black?variant=40028489187508", "size": "L", "origin_color": "Black", "price": 108.0, "price_full": null, "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a2_1_m91.jpg?v=1736468997", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a3_1_m91.jpg?v=1736468996"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_01_b1_s1_a1_1_m91.jpg?v=1736468997", "description": "Color: Black; Size: L", "colors": ["Black"]}, {"remote_code": "43298993078452", "upc": "W51104R043570", "additional_upc": "v=1772526442", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-oatmeal-heather?variant=43298993078452", "size": "XXS", "origin_color": "Oatmeal Heather", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a6_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a5_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a4_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a3_dSP26_m191.jpg?v=1772526404", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a2_dSP26_m191.jpg?v=1772526404"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "description": "Color: Oatmeal Heather; Size: XXS", "colors": ["Oatmeal Heather"], "combo_key": "XXSOatmeal Heather"}, {"remote_code": "43298993111220", "upc": "W51104R043571", "additional_upc": "v=1772526442", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-oatmeal-heather?variant=43298993111220", "size": "XS", "origin_color": "Oatmeal Heather", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a6_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a5_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a4_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a3_dSP26_m191.jpg?v=1772526404", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a2_dSP26_m191.jpg?v=1772526404"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "description": "Color: Oatmeal Heather; Size: XS", "colors": ["Oatmeal Heather"], "combo_key": "XSOatmeal Heather"}, {"remote_code": "43298993143988", "upc": "W51104R043572", "additional_upc": "v=1772526442", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-oatmeal-heather?variant=43298993143988", "size": "S", "origin_color": "Oatmeal Heather", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a6_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a5_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a4_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a3_dSP26_m191.jpg?v=1772526404", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a2_dSP26_m191.jpg?v=1772526404"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "description": "Color: Oatmeal Heather; Size: S", "colors": ["Oatmeal Heather"], "combo_key": "SOatmeal Heather"}, {"remote_code": "43298993176756", "upc": "W51104R043573", "additional_upc": "v=1772526442", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-oatmeal-heather?variant=43298993176756", "size": "M", "origin_color": "Oatmeal Heather", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a6_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a5_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a4_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a3_dSP26_m191.jpg?v=1772526404", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a2_dSP26_m191.jpg?v=1772526404"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "description": "Color: Oatmeal Heather; Size: M", "colors": ["Oatmeal Heather"], "combo_key": "MOatmeal Heather"}, {"remote_code": "43298993209524", "upc": "W51104R043574", "additional_upc": "v=1772526442", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-oatmeal-heather?variant=43298993209524", "size": "L", "origin_color": "Oatmeal Heather", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a6_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a5_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a4_dSP26_m191.jpg?v=1772736200", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a3_dSP26_m191.jpg?v=1772526404", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b1_s1_a2_dSP26_m191.jpg?v=1772526404"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_04357_b2_s1_a1_dSP26_m134.jpg?v=1772526442", "description": "Color: Oatmeal Heather; Size: L", "colors": ["Oatmeal Heather"], "combo_key": "LOatmeal Heather"}, {"remote_code": "40028489515188", "upc": "W51104R065010", "additional_upc": "v=1762820626", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-athletic-heather-grey?variant=40028489515188", "size": "XXS", "origin_color": "Athletic Heather Grey", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a1_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a2_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a3_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a4_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a5_1_m224.jpg?v=1762820626"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "description": "Color: Athletic Heather Grey; Size: XXS", "colors": ["Athletic Heather Grey"], "combo_key": "XXSAthletic Heather Grey"}, {"remote_code": "40028489547956", "upc": "W51104R065011", "additional_upc": "v=1762820626", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-athletic-heather-grey?variant=40028489547956", "size": "XS", "origin_color": "Athletic Heather Grey", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a1_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a2_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a3_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a4_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a5_1_m224.jpg?v=1762820626"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "description": "Color: Athletic Heather Grey; Size: XS", "colors": ["Athletic Heather Grey"], "combo_key": "XSAthletic Heather Grey"}, {"remote_code": "40028489580724", "upc": "W51104R065012", "additional_upc": "v=1762820626", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-athletic-heather-grey?variant=40028489580724", "size": "S", "origin_color": "Athletic Heather Grey", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a1_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a2_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a3_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a4_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a5_1_m224.jpg?v=1762820626"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "description": "Color: Athletic Heather Grey; Size: S", "colors": ["Athletic Heather Grey"], "combo_key": "SAthletic Heather Grey"}, {"remote_code": "40028489613492", "upc": "W51104R065013", "additional_upc": "v=1762820626", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-athletic-heather-grey?variant=40028489613492", "size": "M", "origin_color": "Athletic Heather Grey", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a1_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a2_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a3_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a4_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a5_1_m224.jpg?v=1762820626"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "description": "Color: Athletic Heather Grey; Size: M", "colors": ["Athletic Heather Grey"], "combo_key": "MAthletic Heather Grey"}, {"remote_code": "40028489646260", "upc": "W51104R065014", "additional_upc": "v=1762820626", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-athletic-heather-grey?variant=40028489646260", "size": "L", "origin_color": "Athletic Heather Grey", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a1_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a2_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a3_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a4_1_m224.jpg?v=1762820626", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b1_s1_a5_1_m224.jpg?v=1762820626"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_02910_b2_s1_a1_1_m18.jpg?v=1762820626", "description": "Color: Athletic Heather Grey; Size: L", "colors": ["Athletic Heather Grey"], "combo_key": "LAthletic Heather Grey"}, {"remote_code": "50661502845287", "upc": "W51104R030403", "additional_upc": "v=1758538961", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-bone?variant=50661502845287", "size": "M", "origin_color": "Bone", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b2_s1_a1_m54.jpg?v=1758538961", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a3_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a5_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a4_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a2_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a1_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a6_m241.jpg?v=1758538961"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b2_s1_a1_m54.jpg?v=1758538961", "description": "Color: Bone; Size: M", "colors": ["Bone"], "combo_key": "MBone"}, {"remote_code": "50661502878055", "upc": "W51104R030404", "additional_upc": "v=1758538961", "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-bone?variant=50661502878055", "size": "L", "origin_color": "Bone", "price": 108.0, "price_full": "", "variant_images": ["https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b2_s1_a1_m54.jpg?v=1758538961", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a3_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a5_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a4_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a2_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a1_m241.jpg?v=1758657352", "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b1_s1_a6_m241.jpg?v=1758538961"], "stock_count": 1, "data": ["transfer"], "image_url": "https://cdn.shopify.com/s/files/1/2185/2813/files/W51104R_03040_b2_s1_a1_m54.jpg?v=1758538961", "description": "Color: Bone; Size: L", "colors": ["Bone"], "combo_key": "LBone"}]}, "remote_url": "https://www.aloyoga.com/products/w51104r-alosoft-high-waist-7-8-highlight-legging-black.js", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'w51104r' - parsed successfully. additional_error_text=''"} |
| error_text |
Traceback (most recent call last):
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)
psycopg2.errors.SqlclientUnableToEstablishSqlconnection: could not establish connection for write forwarding
DETAIL: fe_sendauth: no password supplied
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/working_folder/middlewares/catch_errors_middleware/catch_500_errors.py", line 35, 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 535, 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)
sqlalchemy.exc.OperationalError: (psycopg2.errors.SqlclientUnableToEstablishSqlconnection) could not establish connection for write forwarding
DETAIL: fe_sendauth: no password supplied
[SQL: SELECT product_history.id AS product_history_id, product_history.remote_code AS product_history_remote_code, product_history.market_id AS product_history_market_id, product_history.history AS product_history_history, product_history.date_created AS product_history_date_created, product_history.date_modified AS product_history_date_modified
FROM product_history
WHERE product_history.market_id = %(market_id_1)s AND product_history.remote_code = %(remote_code_1)s
LIMIT %(param_1)s FOR UPDATE]
[parameters: {'market_id_1': 95, 'remote_code_1': 'w51104r', 'param_1': 1}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|