Telegram Auto-Shop Bot Fixes

My Telegram auto-shop bot is 90 % there: written in Python, it talks to PostgreSQL, lets users browse stock, pay by crypto through NowPayments or by manual bank transfer, and even handles automatic refunds. Where I’m stuck is reliability—especially around the two external APIs that keep the shop flowing: the product-request/verification endpoint and NowPayments.

Right now the bot occasionally stalls or throws exceptions when it should be confirming inventory or posting the payment callback. I need a fresh set of eyes to trace those API communication errors, harden the error-handling logic and make sure every purchase path completes cleanly.

What you’ll actually do
• Audit the current codebase (roughly 1 500 LOC, aiogram + asyncpg).
• Pinpoint and repair any broken request/response cycles with both the product verification API and NowPayments.
• Confirm database writes/rollbacks work as intended after each API call, including the auto-refund routine.
• Run end-to-end tests for: checking stock, paying with crypto, paying by manual transfer, receiving order confirmation, and refund scenarios.
• Deliver concise deployment instructions so I can spin the bot up on my own VPS.

Acceptance is simple: no unhandled exceptions during those five flows, correct balances in PostgreSQL after every transaction, and a readable log of all external API interactions for future debugging.

If you live and breathe Python async and have beaten unruly APIs before, you’ll fly through this. Let’s get the shop fully open.