`DW-Agents/dw-agents/ENHANCED-QUERIES.md`

200 lines
# ✅ Enhanced Purchasing Agent - Now with Better Dates & Prices!

## 🎯 What's New

Your purchasing agent now shows **detailed dates, prices, and tracking info** for all queries!

**Access:** http://45.61.58.125:9880 (Login: admin / 2025)

---

## 📋 Try These Queries Now!

### 📦 Order History Queries

**"Show me last order"**
- Shows most recent order with full details
- Includes: Date ordered, Price, Status, Tracking number

**"Show all orders"**
- Lists all 12 orders with dates
- Shows which vendor (Amazon Personal vs Business)
- Displays status (Delivered ✅, In Transit 🚚, Pending ⏳)

**"When did we last order HP ink?"**
- Finds specific item in order history
- Shows exact date and price paid

**"What orders are in transit?"**
- Filters by status
- Shows delivery tracking numbers

**"Show orders from November"**
- Date-filtered results
- All recent orders with timestamps

---

### 📊 Inventory Queries

**"Show inventory with dates"**
- All 20 items with last ordered dates
- Current quantity vs reorder level
- Shows which items need attention

**"What was last ordered?"**
- Shows most recently purchased items
- Includes dates and quantities

**"When did we last order copy paper?"**
- Specific item lookup
- Shows last order date from inventory

**"What items are low in stock?"**
- Lists items below reorder level
- Shows when each was last ordered
- Helps you know what's urgent

**"Show items never ordered"**
- Items with no order history
- Need initial purchase

---

### 💰 Price Queries

**"What was the last price for black ink?"**
- Searches order history
- Shows most recent price paid
- Includes date and vendor

**"Compare prices from Personal vs Business account"**
- Shows price differences
- Recommends best account to use

**"Show me most expensive orders"**
- Sorts by price
- Useful for budget tracking

**"What did we spend in October?"**
- Monthly spending summary
- Breaks down by item category

---

### 📈 Smart Queries

**"What should I reorder this week?"**
- Items below reorder level
- Prioritized by how long since last order
- Shows last price for budgeting

**"Track order 113-9876543-2109876"**
- Full order details
- Tracking number
- Current status

**"Show all Post-it Notes purchases"**
- Complete history for one item
- Price trends over time

**"What's running low that we haven't ordered recently?"**
- Critical items needing attention
- Last ordered date helps prioritize

---

## 📋 Example Responses

### Query: "Show me last order"
```
Most Recent Order:

Order #117-8901234-5678901
• Item: Staples One-Touch Desktop Stapler, 25 Sheet Capacity
• Price: $16.49
• Vendor: Amazon.com
• Date: Nov 5, 2025
• Status: ⏳ Pending
```

### Query: "What items are low in stock?"
```
Items Below Reorder Level:

1. HP 63XL Tri-color Ink Cartridge
   • Current: 1 unit ⚠️ LOW STOCK
   • Reorder at: 2 units
   • Last ordered: Never
   • Action: ORDER NOW

This is the only item currently low. I recommend ordering soon!
```

### Query: "Show inventory with dates"
```
Current Inventory (20 items):

1. HP 63XL Black Ink Cartridge
   • Current: 3 units ✅ OK
   • Reorder at: 2 units
   • Last ordered: Oct 28, 2025

2. Copy Paper (8.5x11, 500 sheets/ream)
   • Current: 45 reams ✅ OK
   • Reorder at: 20 reams
   • Last ordered: Oct 12, 2025

[... continues for all 20 items ...]
```

---

## 🎯 Data Available

**Orders:** 12 total
- From Sep 28, 2025 to Nov 5, 2025
- Mix of Delivered, In Transit, and Pending
- Both Personal and Business accounts

**Inventory:** 20 items
- Office essentials tracked
- Reorder levels set
- Some items with order history, some without

---

## 💡 Pro Tips

1. **Be specific:** "When did we last order HP black ink?" works better than "ink"

2. **Ask for comparisons:** "Compare October vs September spending"

3. **Request summaries:** "Summarize what needs reordering"

4. **Track by vendor:** "Show all Amazon Business orders"

5. **Use date ranges:** "Orders from last week"

---

## 🚀 Coming Soon (When PA-API is enabled)

Once you get 3 affiliate sales and PA-API access:

- ✅ Real-time Amazon price lookups
- ✅ Automatic price tracking
- ✅ Price drop alerts
- ✅ Best deal recommendations
- ✅ Auto-populate from real Amazon data

---

**Try it now:** http://45.61.58.125:9880

Login: admin / 2025

**Test Query:** "Show me last order"

It now works perfectly with all dates, prices, and tracking info! 🎉