Toolathlon-Verified · Website task ID285· Canonical taskupdate-material-inventoryView the task source atd57361c0
Required Tools
MCP Servers
Local Tools
handle_overlong_tool_outputs
manage_context
Instruction
Please help me monitor new paid orders in WooCommerce, retrieve the SKU and quantity of each finished product in the order, then, based on the Bill of Materials (BOM) recorded in Google Sheets, calculate the amount of raw materials that need to be consumed. Deduct the corresponding quantities from the raw material inventory table in Google Sheets, write the updated raw material inventory back to Google Sheets, and then, based on the updated raw material balances, recalculate the maximum producible quantities for all finished products. Finally, sync these maximum producible quantities to WooCommerce as the available stock for the products.Initial State
Local Workspace
workspace/
└── config.json




