Webhook Monitor
Har incoming webhook ka raw log β source, date/time aur poora payload SQLite me. Blank ya galat-format payload bhi save hota hai. Niche filter karo; row pe "Payload" dabao to raw body khulega. Failed ko retry kar sakte ho.
Settlement Auto-Poller
Learnyst (Razorpay) settlement ~T+2 me aata hai. Poller fixed times pe chalta hai, Razorpay settlement recon report se settle hui payments ko pending invoices se match karke payment β journal β apply credit auto karta hai. Niche har run ka log + atki hui rows ka step-wise error.
Jis row ka settle adhura raha β kahan atka (step) aur kya error. Theek karke "Settle" se resume kar sakte ho (jo step ho chuka skip hoga).
Sheet upload
Review β
Process karne se pehle dekh lo: Matched = system me already hai (webhook se aaya). New = sirf sheet me hai, iska invoice+payment+journal naya banega.
Result
Failed / Attention transactions
Zoho Mapping β per platform
Bank = settled paisa yahan deposit (Record Payment). Vendor = gateway (journal ke Accounts Payable line pe). AR (customer) / AP system accounts auto-detect β koi ledger mapping nahi.
π Graphy
π Learnyst
π¦ Zoho Items (Product gate)
Invoice tabhi banega jab uska product Zoho Books ke Items me ho. Ye store roz 24h me auto refresh hota hai; naye item add karne ke baad yahan se turant sync + held (product-missing) rows retry kar sakte ho. Product Zoho me na ho to invoice HOLD hota hai (Transactions me "Product missing").
Webhook URLs
Ye URLs Graphy/Learnyst ke webhook settings me daalo (purchase event):
Flow
- Purchase β platform webhook β Zoho me invoice (tax-inclusive, sent, due today).
- Graphy ke 2 webhook (enrolled + transaction) Order Id se merge.
- Duplicate sirf Order Id (Graphy) / Payment Ref (Learnyst) se β same key dobara aaye to skip.
- Settlement ke baad sheet upload β payment + journal (fee).