Skip to main content

MCP Servers
woocommerce
google_sheet
Local Tools
history
claim_done
python_execute
manage_context
handle_overlong_tool_outputs

​
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

​
Google Sheet and WooCommerce

You can review the data construction process during testing here.

​
Model Trajectory