id: 594292

Column Value
id 594292
source usmall
endpoint http://app-usmall.prod.vpc/api/product-external
market_id 4
remote_code 18890157
parsing_type refresh
status_code 502
request_json {'json_data': '{"market_id":4,"remote_code":"18890157","is_lost":0,"partial_update":0,"sales_tag":"Today Only Sale ends 7/20/26","brand":"philosophy","name":"Hula Girl Hydrating Shower Gel","description":"Transport yourself to a moment of self-care with the ultra-creamy, iconic philosophy shower gel, upgraded with a skin-hugging moisture complex for intense hydration that won\'t be rinsed off yet doesn\'t leave the feel of a film or residue. The formula, which respects the moisture barrier, efficiently cleanses, soothes and comforts dry skin, while a breezy orange, sandalwood and vanilla musk scent evokes the relaxing feel of island life.\\nWHAT IT IS:\\nA dermatologist-tested pH-balanced formula that\'s made in the USA and doesn\'t strip skin\\nWHAT IT DOES:\\nHydration lasts after showering with no film or residue; clinically demonstrated to respect skin\'s moisture barrier\\nINGREDIENT HIGHLIGHTS:\\nFormulated with 5x more hydrating ingredients than before\\nHOW TO USE:\\nApply the scented shower gel all over body, then rinse\\nFor bath, drizzle under water\\nRESULTS:\\n94% agree dry skin feels soothed, nourished and hydrated all day*\\n94% agree dry skin is calm and comforted*\\n95% agree skin feels revitalized and silky soft*\\n98% agree skin does not feel stripped after use*\\n9 out of 10 agree this shower gel is better than their current and would switch to this one immediately*\\n*Based on a 2-week consumer study with 143 women\\nPACKAGED WITH CARE: Both the primary and secondary packaging of this product meets at least one of the Packaged with Care requirements\\nCRUELTY FREE: This product has not been tested on animals in any form or at any stage of development, production, or supply chain\\nVEGAN: Formulated and produced without the use of any animal-derived ingredients or by-products\\nCONSCIOUS BEAUTY: This product meets one or more Pillars of the Macy\'s Conscious Beauty Program: Conscious Ingredients, Cruelty Free, Vegan and/or Packaged with Care","data":{"dataFacets":[]},"categories":["Beauty > Skin Care > Girl"],"gender":"Beauty - Girl","product_images":[],"variants":[{"remote_code":"9356289_noneSize","upc":"3616303423025","additional_upc":"53412733","remote_url":"https://www.macys.com/shop/product/~?ID=18890157&swatchColor=No Color&swatchSize=noneSize","size":"noneSize","origin_color":"No Color","price":14.0,"price_full":28.0,"variant_images":["https://slimages.macysassets.com/is/image/MCY/products/8/optimized/30897788_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp","https://slimages.macysassets.com/is/image/MCY/products/1/optimized/37264511_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp","https://slimages.macysassets.com/is/image/MCY/products/2/optimized/37264512_fpx.tif?op_sharpen=1&wid=700&fit=fit,1&fmt=webp"],"stock_count":1,"data":["transfer"],"image_url":"https://slimages.macysassets.com/is/image/MCY/products/8/optimized/30897788_fpx.tif","description":"Color: No Color; Size: noneSize","colors":["No Color"]}]}', 'market_id': '4', 'remote_code': '18890157', 'type_parsing': 'refresh', 'refresh_v2': 1}
response_text <html> <head><title>502 Bad Gateway</title></head> <body> <center><h1>502 Bad Gateway</h1></center> <hr><center>nginx</center> </body> </html>
error_text USMall response status is not 200/202
date_created 2026-07-20 14:52:46.657643