Case 7: Purchase Order Batch Extraction

Pain Point

Eight PDF purchase orders in mixed languages (English and Chinese). Manually extracting fields and consolidating into Excel takes at least half a day.

After QoderWork

QoderWork reads all PDFs, handles complex layouts, extracts 280 line items, and finishes in about 28 minutes. The user then packaged the flow as a reusable Skill.

Prompt Example

Read all PDF purchase orders in this folder:
1. Extract key fields: PO number, supplier, SKU, product name, quantity, unit price, total, delivery date
2. Create summary views: all orders merged, by supplier, by product category
3. Flag rows with unusual amounts (e.g., unit price >20% off category average)
4. Output as Excel

Ongoing Use: After creating the Skill, new POs go into the folder and the Skill is run. No redoing the flow from scratch.

Key Metrics

Metric	Result
Efficiency	From half a day to ~28 minutes
Reusability	User packaged as Skill
Mindset	User wanted to turn the flow into a repeatable template

User quote: “I want to turn this into a Skill so I can reuse it.”