id: 679142

Column Value
id 679142
source usmall
endpoint http://app-usmall.prod.vpc/api/product-external
market_id 37
remote_code B09PQR7S76
parsing_type refresh
status_code 422
request_json {'json_data': '{"market_id":37,"remote_code":"B09PQR7S76","is_lost":0,"partial_update":0,"brand":"Amazing Chiles & Spices","seller_name":"AmazingChilesSpices","name":"Achiote Powder – Ground Annatto Seeds 16oz (1LB) Great for Adding Color and Mild Flavor in Soup, Stews, Meats and Mexican Recipes | Mild flavor with earthy warmth. Rich golden color for rice, soups, meats & sauces. All natural annatto. Resealable bulk bag.","description":"About this item \\n \\n \\n ACHIOTE POWDER – Authentic made from ground Annatto seeds \\n \\n DEEP RICH COLOR and Flavor – Add a golden yellow, orange reddish hue to your recipes. \\n \\n PREMIUM 100% NATURAL – Has a mild nutty, sweet and peppery flavor \\n \\n RESEALABLE BAG FOR FRESHNESS - Our Achiote powder comes in a resealable bag to lock in freshness. \\n \\n SATISFACTION PROMISE - If you don’t love your chile powders as much as we do, simply let us know what the issue is and we’ll do whatever we can to make things right \\n \\n \\nShow more","rating":5.0,"rating_count":1,"data":{"dataFacets":[]},"categories":["Grocery & Gourmet Food > Pantry Staples > Herbs, Spices & Seasonings > Mixed Spices & Seasonings > Mexican Seasoning"],"gender":"NO GENDER","product_images":[],"variants":[{"remote_code":"B09PQKZVSZ","upc":"860008086112","additional_upc":"B09PQKZVSZ","name":"","delivery_days":5,"weight":454,"remote_url":"https://www.amazon.com/dp/B09PQKZVSZ?th=1&psc=1","size":"1 Pound (Pack of 1)","origin_color":"NO_COLOR","price":13.99,"variant_images":["https://m.media-amazon.com/images/I/81KESQDKQAL._SL1500_.jpg","https://m.media-amazon.com/images/I/51o3bfRyT6L.jpg","https://m.media-amazon.com/images/I/91E9TWlrzNL._SL1500_.jpg","https://m.media-amazon.com/images/I/915jGlOTMpL._SL1500_.jpg","https://m.media-amazon.com/images/I/91Lb5-hWziL._SL1500_.jpg","https://m.media-amazon.com/images/I/81gj+QT8uNL._SL1500_.jpg","https://m.media-amazon.com/images/I/81AJEMof82L._SL1500_.jpg","https://m.media-amazon.com/images/I/61Z7ab6I9DL.jpg","https://m.media-amazon.com/images/I/91baqtJo2dL._SL1500_.jpg"],"stock_count":1,"data":["transfer"],"image_url":"https://m.media-amazon.com/images/I/81KESQDKQAL._SL1500_._AC_SY300.jpg","description":"Color: NO_COLOR; Size: 1 Pound (Pack of 1)","colors":["NO_COLOR"]},{"remote_code":"B08WWM9YM4","upc":"","additional_upc":"B08WWM9YM4","name":"Achiote Powder – Ground Annatto Seeds 4oz Great for Adding Color and Mild Flavor in Soup, Stews, Meats and Mexican Recipes | Earthy mild flavor, rich golden red hue for rice, al pastor marinade, soups & stews. All natural. Resealable bag.","delivery_days":5,"weight":113,"remote_url":"https://www.amazon.com/dp/B08WWM9YM4?th=1&psc=1","size":"4 Ounce (Pack of 1)","origin_color":"NO_COLOR","price":6.49,"variant_images":["https://m.media-amazon.com/images/I/91TBqNcybtL._SL1500_.jpg","https://m.media-amazon.com/images/I/51o3bfRyT6L.jpg","https://m.media-amazon.com/images/I/91E9TWlrzNL._SL1500_.jpg","https://m.media-amazon.com/images/I/915jGlOTMpL._SL1500_.jpg","https://m.media-amazon.com/images/I/91Lb5-hWziL._SL1500_.jpg","https://m.media-amazon.com/images/I/91baqtJo2dL._SL1500_.jpg","https://m.media-amazon.com/images/I/81gj+QT8uNL._SL1500_.jpg","https://m.media-amazon.com/images/I/81AJEMof82L._SL1500_.jpg","https://m.media-amazon.com/images/I/61Hto83OhsL._SL1000_.jpg"],"stock_count":1,"data":["transfer"],"image_url":"https://m.media-amazon.com/images/I/91TBqNcybtL._SL1500_._AC_SY300.jpg","description":"Color: NO_COLOR; Size: 4 Ounce (Pack of 1)","colors":["NO_COLOR"]}]}', 'market_id': '37', 'remote_code': 'B09PQR7S76', '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-29 12:56:33.487968