id: 848164

Column Value
id 848164
source usmall
endpoint http://app-usmall.prod.vpc/api/product-external
market_id 37
remote_code B0D2P8VY14
parsing_type refresh
status_code 422
request_json {'json_data': '{"market_id":37,"remote_code":"B0D2P8VY14","is_lost":0,"partial_update":0,"brand":"Boiron","seller_name":"Boiron","name":"Boiron SleepCalm Kids Sleep Aid for Deep, Relaxing, Restful Nighttime Sleep - Melatonin-Free and Non Habit-Forming - 2 Count (160 Pellets) | 2 PK with Liquid Doses Sleep Drops (15drops) and Sleep Calm Meltaway Tablets (160count) Natural Sleep Aid for Kids, by Ilios","description":"Twist your way to relief with SleepCalm Kids Meltaway Pellets. Melatonin-free and non-habit forming, this over-the-counter sleep aid provides a gentle way to relieve occasional sleeplessness, so your child can fall asleep and stay asleep.* Simply twist the tube until 5 pellets are dispensed and let them melt in your child’s mouth before bed or anytime during the night for calming relief. Unlike melatonin and herbal supplements, SleepCalm Kids contains a blend of plant-based and other pure active ingredients that help restore a healthy sleep pattern disturbed by upsets, excitement, and schedule changes. The meltaway pellets are easy for kids to take (no chewing or swallowing pills!) and offer parents convenience and portability. And they don’t contain any artificial sweeteners, flavors, colors, or preservatives. Recommended for children 3 years of age and older, SleepCalm Kids Pellets are available over the counter in a box of two easy dispensing tubes of medicine. Boiron’s sleep relief line includes SleepCalm Meltaway Tablets and Pellets, as well as SleepCalm Kids Pre-Measured Liquid Doses. *Claims based on traditional homeopathic practice, not accepted medical evidence. Not FDA evaluated.","rating":5.0,"rating_count":1,"data":{"dataFacets":[]},"categories":["Health & Household > Vitamins, Minerals & Supplements > Sleep Supplements"],"gender":"Kid","product_images":[],"variants":[{"remote_code":"B0BL1W7WG9","upc":"306969308424","additional_upc":"B0BL1W7WG9","delivery_days":5,"remote_url":"https://www.amazon.com/dp/B0BL1W7WG9?th=1&psc=1","size":"160","origin_color":"Medication","price":10.99,"variant_images":["https://m.media-amazon.com/images/I/81W9AdSD9VL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/81-MpilYdtL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/619H1nrlTpL._AC_SL1200_.jpg","https://m.media-amazon.com/images/I/81yUiHqpPZL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/819bStPwPJL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/71r3aLHPCgL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/81tWl6znF3L._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/71J-Dpe0pNL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/81ZmrzjWZWL._AC_SL1500_.jpg","https://m.media-amazon.com/images/I/81KLngCr0nL._AC_SL1500_.jpg"],"stock_count":1,"data":["transfer"],"image_url":"https://m.media-amazon.com/images/I/81W9AdSD9VL._AC_SL1500_._AC_SY300.jpg","description":"Color: Medication; Size: 160","colors":["Medication"]}]}', 'market_id': '37', 'remote_code': 'B0D2P8VY14', '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-08-07 12:59:47.873368