Catalog Admin

row_id: 3461

Column	Value
row_id	3461
time_created	2026-06-12 20:18:30.163698
endpoint	https://usmall-catalog.shopfans.io/log/product_upload
params
body	{"product": {"rating": null, "rating_count": null, "brand": "Bobbi Brown", "name": "Intensive Serum Foundation SPF 40/30", "description": "<b>WHAT IT IS</b><br><br>Powered by serum, our newly transformed skin-energizing foundation delivers 10x the Cordyceps and stronger skincare benefits to leave skin looking smoother, plumper, and more radiant instantly and over time.<br>Free of: Parabens, Phthalate, Sulfates, Sulfite, Mineral Oil, Alcohol, Formaldehyde, Petrolatum, Triclosan. 30 ml. Imported.<br><br><b>WHAT IT DOES</b><br><br>Powerful skincare meets skin-perfecting makeup with fuller coverage, and 12-hour non-caking, non-creasing, color-true wear.<br><br><b>HOW TO USE IT</b><br><br>Buff foundation onto face with Full Coverage Face Brush for a second-skin finish.<br><br><b>ACTIVE INGREDIENTS</b><br><br>Octinoxate, Titanium Dioxide, Zinc Oxide.<br><br><b>INGREDIENTS</b><br><br>Water, Dimethicone, Octyldodecyl Neopentanoate. Butlyoctyl Salicylate, Methyl Trimethicone, Isononyl Isononanoate, Butylene Gycol, Diethylhexyll Succinate, Lauryl PEG-9 Polydimethylsiloxyethyl Dimethicone, Cetyl PEG/PPG-10/1 Dimethicone, Laureth-4, Tocopheryl Acetate, Sodium Hyaluronate. Citrullus Lanatus Fruit Extract, Litchi Chinensis Seed Extract, Sapindus Mukorossi Fruit Extract, Laminaria Saccharina Extract, Lens Esculenta (Lentil) Fruit Extract, Poluhonum Cuspidatum Root Extract, Hippophae Rhamnoides Extract, Ganoderma Lucidum (Mushroom) Extract, Pyrus Malus (Apple) Fruit Extract, Lavandula Angustifolia (Ginseng) Root Extract,Cordyceps Sinensis Extract, Lavandula Angustifolia (Lavender) Oil, Sasa Kurilensis Water, Glycerin, Methicone, Sodim PCA, Sodium Lactate, Hydrolyzed Wheat Protein/PVP Crosspolymer, Dimethicone Crosspolymer -3, Dimethicone/Vinyl Dimethicone Crosspolymer, Thermus Thermophillus Ferment, Caesalpinia Spinosa Gum, Magnesium Sulfate, Aluminum Hydroxide, Dextrin, Dimethicone/PEG-10/15 Crosspolymer, Caprylyl Glycol, Dipropylene Glycol, Dipentaerthrityl Tri-Polyhydroxystearate, Stearic Acid, Linalool, BHT, Disodium Edta, Sodium Citrat, Phenoxyethonal, Potassium Sorbate, Sodium Benzoate, +/1 Mica, Titanium Dixode (CI 177891), Iron Oxides (CI 77491), Iron Oxides (CI 77492), Iron Oxides (CI 77499).<iln48151><UL></UL></iln48151>", "data": {"dataFacets": []}, "categories": ["Beauty > Face Serums > Sun Protection"], "gender": "Women's", "product_images": [], "market_id": 16, "remote_code": "bobbi-brown-intensive-serum-foundation-spf-40%2F30-0400015824560", "is_lost": 0, "variants": [{"remote_code": "15824472", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824472.html", "size": "N/A", "origin_color": "WARM NATURAL", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMNATURAL?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMNATURAL_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMNATURAL_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMNATURAL_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMNATURAL_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMNATURAL_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMNATURAL_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/0400015824560_WARMNATURAL?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: WARM NATURAL; Size: N/A", "colors": ["WARM NATURAL"], "combo_key": "N/AWARM NATURAL"}, {"remote_code": "19442168", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/19442168.html", "size": "N/A", "origin_color": "NEUTRAL WARM WALNUT", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALWARMWALNUT?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALWARMWALNUT_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALWARMWALNUT_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALWARMWALNUT_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALWARMWALNUT_A4?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/0400015824560_NEUTRALWARMWALNUT?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: NEUTRAL WARM WALNUT; Size: N/A", "colors": ["NEUTRAL WARM WALNUT"], "combo_key": "N/ANEUTRAL WARM WALNUT"}, {"remote_code": "19442171", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/19442171.html", "size": "N/A", "origin_color": "WARM ESPRESSO", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMESPRESSO?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMESPRESSO_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMESPRESSO_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMESPRESSO_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMESPRESSO_A4?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/0400015824560_WARMESPRESSO?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: WARM ESPRESSO; Size: N/A", "colors": ["WARM ESPRESSO"], "combo_key": "N/AWARM ESPRESSO"}, {"remote_code": "15824487", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824487.html", "size": "N/A", "origin_color": "ESPRESSO", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ESPRESSO?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ESPRESSO_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ESPRESSO_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ESPRESSO_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ESPRESSO_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ESPRESSO_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ESPRESSO_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/0400015824560_ESPRESSO?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: ESPRESSO; Size: N/A", "colors": ["ESPRESSO"], "combo_key": "N/AESPRESSO"}, {"remote_code": "15824509", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824509.html", "size": "N/A", "origin_color": "HONEY", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_HONEY?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_HONEY_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_HONEY_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_HONEY_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_HONEY_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_HONEY_A5?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/0400015824560_HONEY?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: HONEY; Size: N/A", "colors": ["HONEY"], "combo_key": "N/AHONEY"}, {"remote_code": "15824556", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824556.html", "size": "N/A", "origin_color": "ALMOND", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALMOND?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALMOND_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALMOND_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALMOND_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALMOND_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALMOND_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALMOND_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/0400015824560_ALMOND?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: ALMOND; Size: N/A", "colors": ["ALMOND"], "combo_key": "N/AALMOND"}, {"remote_code": "15824532", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824532.html", "size": "N/A", "origin_color": "CHESTNUT", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_CHESTNUT?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_CHESTNUT_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_CHESTNUT_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_CHESTNUT_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_CHESTNUT_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_CHESTNUT_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_CHESTNUT_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/0400015824560_CHESTNUT?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: CHESTNUT; Size: N/A", "colors": ["CHESTNUT"], "combo_key": "N/ACHESTNUT"}, {"remote_code": "15824548", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824548.html", "size": "N/A", "origin_color": "WARM IVORY", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMIVORY?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMIVORY_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMIVORY_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMIVORY_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMIVORY_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMIVORY_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMIVORY_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/0400015824560_WARMIVORY?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: WARM IVORY; Size: N/A", "colors": ["WARM IVORY"], "combo_key": "N/AWARM IVORY"}, {"remote_code": "15824516", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824516.html", "size": "N/A", "origin_color": "WALNUT", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WALNUT?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WALNUT_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WALNUT_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WALNUT_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WALNUT_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WALNUT_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WALNUT_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/0400015824560_WALNUT?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: WALNUT; Size: N/A", "colors": ["WALNUT"], "combo_key": "N/AWALNUT"}, {"remote_code": "19442165", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/19442165.html", "size": "N/A", "origin_color": "NEUTRAL COOL HONEY", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALCOOLHONEY?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALCOOLHONEY_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALCOOLHONEY_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALCOOLHONEY_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_NEUTRALCOOLHONEY_A4?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/0400015824560_NEUTRALCOOLHONEY?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: NEUTRAL COOL HONEY; Size: N/A", "colors": ["NEUTRAL COOL HONEY"], "combo_key": "N/ANEUTRAL COOL HONEY"}, {"remote_code": "15824484", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824484.html", "size": "N/A", "origin_color": "WARM HONEY", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMHONEY?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMHONEY_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMHONEY_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMHONEY_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMHONEY_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMHONEY_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMHONEY_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/0400015824560_WARMHONEY?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: WARM HONEY; Size: N/A", "colors": ["WARM HONEY"], "combo_key": "N/AWARM HONEY"}, {"remote_code": "15824563", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824563.html", "size": "N/A", "origin_color": "ALABASTER", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALABASTER?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALABASTER_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALABASTER_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALABASTER_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALABASTER_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALABASTER_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_ALABASTER_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/0400015824560_ALABASTER?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: ALABASTER; Size: N/A", "colors": ["ALABASTER"], "combo_key": "N/AALABASTER"}, {"remote_code": "15824527", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824527.html", "size": "N/A", "origin_color": "WARM ALMOND", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMALMOND?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMALMOND_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMALMOND_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMALMOND_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMALMOND_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMALMOND_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMALMOND_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/0400015824560_WARMALMOND?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: WARM ALMOND; Size: N/A", "colors": ["WARM ALMOND"], "combo_key": "N/AWARM ALMOND"}, {"remote_code": "15824569", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824569.html", "size": "N/A", "origin_color": "WARM WALNUT", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMWALNUT?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMWALNUT_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMWALNUT_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMWALNUT_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMWALNUT_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMWALNUT_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_WARMWALNUT_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/0400015824560_WARMWALNUT?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: WARM WALNUT; Size: N/A", "colors": ["WARM WALNUT"], "combo_key": "N/AWARM WALNUT"}, {"remote_code": "15824513", "upc": "", "remote_url": "https://www.saksfifthavenue.com/product/15824513.html", "size": "N/A", "origin_color": "GOLDEN", "price": 57.4, "price_full": 82.0, "variant_images": ["https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_GOLDEN?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_GOLDEN_A1?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_GOLDEN_A2?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_GOLDEN_A3?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_GOLDEN_A4?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_GOLDEN_A5?wid=830&hei=1106&qlt=90&resMode=sharp2&op_usm=0.9,1.0,8,0", "https://cdn.saksfifthavenue.com/is/image/saks/0400015824560_GOLDEN_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/0400015824560_GOLDEN?wid=380&hei=506&qlt=70&resMode=sharp2&op_usm=1.2,1,6,0", "description": "Color: GOLDEN; Size: N/A", "colors": ["GOLDEN"], "combo_key": "N/AGOLDEN"}]}, "remote_url": "https://www.saksfifthavenue.com/on/demandware.store/Sites-SaksFifthAvenue-Site/en_US/Product-Variation?pid=0400015824560&quantity=1#bobbi-brown-intensive-serum-foundation-spf-40%2F30-0400015824560", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'bobbi-brown-intensive-serum-foundation-spf-40%2F30-0400015824560' - 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 463, 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)