id: 1827788

Column Value
id 1827788
source usmall
endpoint http://app-usmall.prod.vpc/api/product-external
market_id 2
remote_code 9812947
parsing_type full
status_code 422
request_json {'json_data': '{"market_id":2,"remote_code":"9812947","is_lost":0,"partial_update":0,"brand":"Cole Haan","name":"Zerogrand City Wedge Boot Waterproof","description":"Get ready for your cold-weather adventures by wearing the Cole Haan® Zerogrand City Wedge Boot Waterproof. Crafted with a fully padded leather midsole that offers superior comfort, these boots are the perfect footwear for your everyday wear. The seam-sealed construction of these leather boots keeps the elements out. With the stretchy side panels, these winter boots are easy to slip on and remove.\\nWaterproof leather upper.\\nCushioned GRANDFØAM footbed with textile lining.\\nSlip-on style.\\n65mm wedge heel.\\nRound toe.\\nLugged outsole with rubber pods offers traction and durability.\\nImported.\\nProduct measurements were taken using size 7, width B - Medium. Please note that measurements may vary by size.\\nMeasurements:\\n<ul>\\n <li> Heel Height: 2 in</li>\\n <li> Weight: 8 oz</li>\\n <li> Circumference: 10 <sup>1</sup>⁄<sub>2</sub> in</li>\\n </ul>","data":{"dataFacets":[]},"categories":["Shoes > Boots > Chelsea Boots"],"gender":"Women","product_images":[],"variants":[{"remote_code":"55955056","upc":"194736634124","email_meta":"B0BQ1W5DS7","remote_url":"https://www.6pm.com/p/~/product/9812947/color/1023241","size":"5.5/B - Medium","origin_color":"Waterproof British Tan","price":219.95,"price_full":260.0,"variant_images":["https://m.media-amazon.com/images/I/61gprmTg5WL.jpg","https://m.media-amazon.com/images/I/51KpjS8mMCL.jpg","https://m.media-amazon.com/images/I/71jMrSFUJnL.jpg","https://m.media-amazon.com/images/I/71evLceE7AL.jpg","https://m.media-amazon.com/images/I/61HbxB+2b9L.jpg"],"stock_count":1,"data":["transfer"],"image_url":"https://m.media-amazon.com/images/I/61gprmTg5WL._AC_SR400,400_.jpg","description":"Color: Waterproof British Tan; Size: 5.5/B - Medium","colors":["Waterproof British Tan"]},{"remote_code":"55955064","upc":"194736634209","email_meta":"B0BQ1TL7RL","remote_url":"https://www.6pm.com/p/~/product/9812947/color/1023241","size":"9.5/B - Medium","origin_color":"Waterproof British Tan","price":219.95,"price_full":260.0,"variant_images":["https://m.media-amazon.com/images/I/61gprmTg5WL.jpg","https://m.media-amazon.com/images/I/51KpjS8mMCL.jpg","https://m.media-amazon.com/images/I/71jMrSFUJnL.jpg","https://m.media-amazon.com/images/I/71evLceE7AL.jpg","https://m.media-amazon.com/images/I/61HbxB+2b9L.jpg"],"stock_count":1,"data":["transfer"],"image_url":"https://m.media-amazon.com/images/I/61gprmTg5WL._AC_SR400,400_.jpg","description":"Color: Waterproof British Tan; Size: 9.5/B - Medium","colors":["Waterproof British Tan"]},{"remote_code":"55955053","upc":"194736634094","email_meta":"B0BQ24CNBQ","remote_url":"https://www.6pm.com/p/~/product/9812947/color/1023241","size":"10.5/B - Medium","origin_color":"Waterproof British Tan","price":219.95,"price_full":260.0,"variant_images":["https://m.media-amazon.com/images/I/61gprmTg5WL.jpg","https://m.media-amazon.com/images/I/51KpjS8mMCL.jpg","https://m.media-amazon.com/images/I/71jMrSFUJnL.jpg","https://m.media-amazon.com/images/I/71evLceE7AL.jpg","https://m.media-amazon.com/images/I/61HbxB+2b9L.jpg"],"stock_count":1,"data":["transfer"],"image_url":"https://m.media-amazon.com/images/I/61gprmTg5WL._AC_SR400,400_.jpg","description":"Color: Waterproof British Tan; Size: 10.5/B - Medium","colors":["Waterproof British Tan"]},{"remote_code":"55955054","upc":"194736634100","email_meta":"B0BQ22568Z","remote_url":"https://www.6pm.com/p/~/product/9812947/color/1023241","size":"11/B - Medium","origin_color":"Waterproof British Tan","price":219.95,"price_full":260.0,"variant_images":["https://m.media-amazon.com/images/I/61gprmTg5WL.jpg","https://m.media-amazon.com/images/I/51KpjS8mMCL.jpg","https://m.media-amazon.com/images/I/71jMrSFUJnL.jpg","https://m.media-amazon.com/images/I/71evLceE7AL.jpg","https://m.media-amazon.com/images/I/61HbxB+2b9L.jpg"],"stock_count":1,"data":["transfer"],"image_url":"https://m.media-amazon.com/images/I/61gprmTg5WL._AC_SR400,400_.jpg","description":"Color: Waterproof British Tan; Size: 11/B - Medium","colors":["Waterproof British Tan"]}]}', 'market_id': '2', 'remote_code': '9812947', 'type_parsing': 'full', 'refresh_v2': 1}
response_text {"status":"fail","message":"SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for rds.prod-ecommerce.prod.vpc failed: Temporary failure in name resolution"}
error_text USMall response status is not 200/202
date_created 2026-09-05 10:17:02.671062