id: 683839

Column Value
id 683839
source usmall
endpoint http://app-usmall.prod.vpc/api/product-external
market_id 37
remote_code B0GHHKXKS1
parsing_type refresh
status_code 422
request_json {'json_data': '{"market_id":37,"remote_code":"B0GHHKXKS1","is_lost":0,"partial_update":0,"brand":"Boiron","seller_name":"Boiron","name":"Boiron ColdCalm Kids Pellets for Relief of Common Cold Symptoms Such as Sneezing, Runny Nose, Sore Throat, and Nasal Congestion - 2 Count (160 Pellets) | For Common Cold Symptoms Such as Sneezing, Runny Nose, Sore Throat, and Nasal Congestion. Size: 2 Count (160 Pellets).","description":"Non-drowsy ColdCalm Kids Pellets by Boiron target specific cold symptoms at every stage of the cold. * Made for children 4 years of age and older, the meltaway pellets are easy to take. Simply twist the tube to dispense and let them dissolve in the mouth. No water, chewing, or swallowing is needed. *Claims based on traditional homeopathic practice, not accepted medical evidence. Not FDA evaluated.","rating":5.0,"rating_count":1,"data":{"dataFacets":[]},"categories":["Health & Household > Health Care > Over-the-Counter Medication > Cough & Cold > Cold & Flu Relief"],"gender":"Kid","product_images":[],"variants":[{"remote_code":"B0GHDGBHC3","upc":"","additional_upc":"B0GHDGBHC3","name":"Boiron ColdCalm Kids Pellets for Relief of Common Cold Symptoms Such as Sneezing, Runny Nose, Sore Throat, and Nasal Congestion - 80 Count (Pack of 4)","delivery_days":5,"weight":1,"remote_url":"https://www.amazon.com/dp/B0GHDGBHC3?th=1&psc=1","size":"80 Count (Pack of 4)","origin_color":"NO_COLOR","price":20.97,"variant_images":["https://m.media-amazon.com/images/I/714+jkLSayL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/81Y-uNqTrXL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/71Q5gwIctKL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/71Y6fdLcgGL._AC_SL1000_.jpg","https://m.media-amazon.com/images/I/81D1w5VpAvL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/71KFTDIJQpL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/81yd+0lKrXL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/81dwq7htReL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/91BBXKPlcOL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/513tQ+BNARL._AC_SL1000_.jpg","https://m.media-amazon.com/images/I/81NYmLonY5L._AC_SL1500_.jpg"],"stock_count":1,"data":["transfer"],"image_url":"https://m.media-amazon.com/images/I/714+jkLSayL._AC_SL1500_._AC_SY300.jpg","description":"Color: NO_COLOR; Size: 80 Count (Pack of 4)","colors":["NO_COLOR"]}]}', 'market_id': '37', 'remote_code': 'B0GHHKXKS1', 'type_parsing': 'refresh', 'refresh_v2': 1}
response_text {"status":"fail","message":"Field 'name' must be 255 characters or less"}
error_text USMall response status is not 200/202
date_created 2026-07-30 13:31:56.642611