// Check low stock products
const lowStock = await db.find('Product', {
  filters: [
    ['StockStatus', 'in', ['Low Stock', 'Out of Stock']],
    ['IsActive', '=', true]
  ],
  orderBy: { field: 'QuantityInStock', direction: 'asc' }
});

// Auto-update stock status (via trigger)
if (product.QuantityInStock === 0) {
  stockStatus = 'Out of Stock';
} else if (product.QuantityInStock < product.ReorderLevel) {
  stockStatus = 'Low Stock';
} else {
  stockStatus = 'In Stock';
}

"Key Selling Points for 'Enterprise CRM Platform':

✨ Unique Value Propositions:
- 40% lower TCO compared to Salesforce
- Native China deployment (no VPN required)
- Advanced AI capabilities built-in
- Industry-leading customization

🎯 Target Audience:
- Enterprise companies with 500+ users
- Organizations expanding in Asia-Pacific
- Companies requiring extensive customization

💼 Use Cases:
- Global sales team coordination
- Multi-currency deal management
- Complex approval workflows
- Customer 360-degree view"

"Recommended Bundle for 'CRM Enterprise License':
1. Training Package (Professional Services) - 80% attach rate
2. Premium Support (12 months) - 95% attach rate
3. API Integration Service - 60% attach rate
4. Mobile App Add-on - 50% attach rate

Total bundle value: $45,000 (vs. $52,000 individual)
Average discount: 13%
Win rate when bundled: 78% (vs. 52% standalone)"

"Pricing Strategy Analysis:

Current Price: $299/user/month
Market Position: Premium (85th percentile)

Recommendations:
1. Consider volume discounts:
   - 100-500 users: 15% discount
   - 500-1000 users: 25% discount
   - 1000+ users: 35% discount

2. Competitive positioning:
   - 40% lower than Salesforce
   - 20% higher than HubSpot
   - Differentiate on China deployment

3. Upsell opportunities:
   - API access: +$50/user/month
   - Advanced analytics: +$30/user/month
   - Premium support: +$25/user/month"

// System enforces only one standard pricebook
{
  Name: 'Standard Pricebook',
  IsStandard: true,
  Currency: 'CNY', // Must be CNY
  IsActive: true
}

// Create US pricebook
const usPricebook = await db.doc.create('Pricebook', {
  Name: 'US Direct Sales - 2026',
  Currency: 'USD',
  Region: 'North America',
  SalesChannel: 'Direct',
  PricingStrategy: 'Standard',
  StartDate: '2026-01-01',
  EndDate: '2026-12-31',
  IsActive: true
});

// Create China channel pricebook with 20% discount
const chinaPricebook = await db.doc.create('Pricebook', {
  Name: 'China Channel Partner - 2026',
  Currency: 'CNY',
  Region: 'China Mainland',
  SalesChannel: 'Channel',
  PricingStrategy: 'Discount',
  StartDate: '2026-01-01',
  EndDate: '2026-12-31',
  IsActive: true
});

// Add product to US pricebook
await db.doc.create('PricebookEntry', {
  PricebookId: usPricebook.Id,
  ProductId: crmProductId,
  UnitPrice: 299.00, // $299 USD
  IsActive: true
});

// Add same product to China pricebook
await db.doc.create('PricebookEntry', {
  PricebookId: chinaPricebook.Id,
  ProductId: crmProductId,
  UnitPrice: 1999.00, // ¥1999 CNY
  IsActive: true
});

// Automatic calculation formula
Subtotal = Sum of all QuoteLineItems (Quantity × UnitPrice)
DiscountAmount = Subtotal × DiscountPercent
TaxAmount = (Subtotal - DiscountAmount) × TaxPercent
TotalPrice = Subtotal - DiscountAmount + TaxAmount + ShippingHandling

Subtotal:          $100,000.00
Discount (15%):    -$15,000.00
Subtotal after:     $85,000.00
Tax (13%):         +$11,050.00
Shipping:           +$1,000.00
----------------------------
Total Price:        $97,050.00

// Trigger approval workflow
if (quote.DiscountPercent > 0.20) {
  await db.doc.update('Quote', quote.Id, {
    Status: 'In Review',
    ApprovalStatus: 'Pending',
    ApprovalLevel: 2 // Director approval needed
  });
  
  // Route to director
  await createApprovalRequest({
    objectType: 'Quote',
    objectId: quote.Id,
    approverId: directorOfSalesId,
    reason: `Discount of ${quote.DiscountPercent * 100}% requires director approval`
  });
}

// Generate quote PDF
await generateQuotePDF(quote.Id);

// Updates quote record
{
  PDFGeneratedDate: new Date(),
  PDFUrl: 'https://storage.hotcrm.com/quotes/Q-2026-01-0042.pdf'
}

"Recommended Bundle based on $150K budget:

Option 1: Balanced Solution ($148K)
- CRM Enterprise (500 users): $120K
- Professional Services (80 hrs): $16K
- Premium Support (12 months): $12K
Win Probability: 72%

Option 2: Premium Solution ($195K - suggest upsell)
- CRM Enterprise (500 users): $120K
- Advanced Analytics Add-on: $30K
- Professional Services (120 hrs): $24K
- Premium Support (12 months): $12K
- Mobile App Licenses: $9K
Win Probability: 65%

Recommendation: Start with Option 1, upsell Analytics in 6 months."

"Optimal Discount Analysis:

Current Discount: 15%
AI Recommended: 12%

Reasoning:
- Historical win rate at 12%: 68%
- Historical win rate at 15%: 70% (marginal gain)
- Revenue impact: +$4,500 with 12% discount
- Customer's budget confirmed, price not main concern
- Competitor pricing allows lower discount

Recommendation: Start at 10%, max 12%"

{
  winProbability: 67,
  confidence: 'High',
  factors: {
    positive: [
      'Strong relationship with decision maker',
      'Budget confirmed and allocated',
      'Timeline matches their needs',
      'No active competitors identified'
    ],
    negative: [
      'Price 20% above initial budget',
      'Long approval process (45 days)',
      'Economic buyer not fully engaged'
    ],
    recommendations: [
      'Reduce discount to 10% (still competitive)',
      'Schedule call with economic buyer',
      'Add value-adds instead of deeper discount'
    ]
  }
}

"Pricing Competitiveness Analysis:

Your Quote: $97,050
Market Range: $85,000 - $125,000
Position: Mid-range (competitive)

vs. Salesforce: 35% lower ✅
vs. HubSpot: 15% higher ⚠️
vs. Microsoft Dynamics: 20% lower ✅

Value Proposition:
- Better price than enterprise competitors
- Justify premium over HubSpot with:
  * Enterprise-grade security
  * Advanced customization
  * China deployment
  * Dedicated support

Competitive Response:
If customer mentions HubSpot pricing:
1. Highlight enterprise features
2. Offer premium support bundle
3. Show TCO over 3 years (we win)"

// 1. Create quote
const quote = await db.doc.create('Quote', {
  Name: 'Acme Corp - CRM Enterprise Solution',
  OpportunityId: opportunityId,
  AccountId: accountId,
  ContactId: contactId,
  PricebookId: usPricebookId,
  QuoteDate: new Date(),
  ExpirationDate: '2026-03-15', // 30 days validity
  PaymentTerms: '50/50 Split',
  DeliveryTerms: 'Cloud Deployment',
  Status: 'Draft'
});

// 2. Add line items
await db.doc.create('QuoteLineItem', {
  QuoteId: quote.Id,
  ProductId: crmEnterpriseId,
  Quantity: 500,
  UnitPrice: 299.00,
  Description: 'CRM Enterprise - 500 users, annual subscription'
});

await db.doc.create('QuoteLineItem', {
  QuoteId: quote.Id,
  ProductId: trainingId,
  Quantity: 40,
  UnitPrice: 200.00,
  Description: 'On-site training - 40 hours'
});

// 3. Apply discount
await db.doc.update('Quote', quote.Id, {
  DiscountPercent: 0.15, // 15% discount
  TaxPercent: 0.13, // 13% tax
  ShippingHandling: 1000.00
});
// Subtotal, DiscountAmount, TaxAmount, TotalPrice calculated automatically

// 4. Submit for approval (if discount > 10%)
await db.doc.update('Quote', quote.Id, {
  Status: 'In Review'
});

// 5. After approval, send to customer
await db.doc.update('Quote', quote.Id, {
  Status: 'Sent'
});
await sendQuoteEmail(quote.Id);

// 6. Customer accepts
await db.doc.update('Quote', quote.Id, {
  Status: 'Customer Accepted'
});

// 1. Customer requests quote for 500 users
const opportunity = await db.findOne('Opportunity', oppId);

// 2. AI recommends product bundle
const bundle = await aiRecommendProductBundle({
  accountId: opportunity.AccountId,
  budget: 150000,
  userCount: 500
});

// 3. Create quote with recommended products
const quote = await db.doc.create('Quote', {
  Name: `${opportunity.Name} - Quote`,
  OpportunityId: opportunity.Id,
  AccountId: opportunity.AccountId,
  ContactId: opportunity.ContactId,
  PricebookId: await getDefaultPricebook(opportunity.AccountId),
  QuoteDate: new Date(),
  ExpirationDate: addDays(new Date(), 30)
});

// 4. Add AI-recommended line items
for (const item of bundle.items) {
  await db.doc.create('QuoteLineItem', {
    QuoteId: quote.Id,
    ProductId: item.productId,
    Quantity: item.quantity,
    UnitPrice: item.unitPrice
  });
}

// 5. Apply AI-suggested discount
await db.doc.update('Quote', quote.Id, {
  DiscountPercent: bundle.suggestedDiscount / 100
});

// 6. Review and adjust
const pricing = await aiAnalyzePricing(quote.Id);
console.log(`Win probability: ${pricing.winProbability}%`);
console.log(`Competitive position: ${pricing.competitivePosition}`);

// 7. Submit for approval if needed
if (quote.DiscountPercent > 0.10) {
  await submitForApproval(quote.Id);
}

// 8. After approval, generate PDF and send
await generateQuotePDF(quote.Id);
await sendQuoteToCustomer(quote.Id);

// 9. Track customer response
// (Customer accepts via portal or email)

// 10. Convert to contract
if (quote.Status === 'Customer Accepted') {
  await convertQuoteToContract(quote.Id);
}