Update purchase order statuses and quantities in MySQL based on new item data

Update purchase order item statuses and quantities in MySQL based on new item data. Ensure accurate tracking of inventory and order fulfillment for improved operational efficiency.