Har warehouse ki sabse nayi inventory file apne aap uthayi jaati hai.
Apne SKU yahan paste karo — ek line me ek, ya comma se. Excel se seedha copy-paste bhi chalega. Phir alert sirf inhi SKU ka aayega.
Sabse behtar tareeka: EasyEcom khud stock updates yahan bhejta hai. Koi request nahi jaati, isliye ban ka risk zero — aur data seconds me current rehta hai.
1. Seedha EasyEcom se (fully independent — aapka laptop off ho to bhi chalega).
EasyEcom har company ke webhooks sirf EK url par bhejta hai. Is PC ka public URL banao
(Tailscale Funnel free hai, KottyOps me already use ho raha hai), aur EasyEcom dashboard me us company ka
webhook URL badal kar ye laga do. Tab ye PC seedha live data payega — kisi doosre PC ki zaroorat nahi.
2. KottyOps se copy (same office network, turant chalu).
KottyOps ke .env me: WEBHOOK_RELAY_URL=<upar wala URL> —
wo har update ki ek copy yahan bhej dega. Isme koi registration nahi karna, par KottyOps wala PC on hona chahiye.
Is PC par inventory files na hon to app khud EasyEcom se aapke SKU ka live stock le lega. Har warehouse ka apna login chahiye (wahi jo KottyOps ke .env me hai).
Jitne chaaho email add karo — har alert sabko jaayega, CSV attach hokar.
Gmail: normal password kaam nahi karega. Google Account → Security → 2-Step Verification → App passwords se 16 character ka password banao aur yahan paste karo (spaces hata do).
Bot phone par alert + CSV file bhejta hai. @BotFather se token lo, bot ko START dabao, fir niche "Find chat id".
Group me /stock SKU, /find, /oos, /report, /watch, /status — bot jawab deta hai (files se, EasyEcom call nahi).
Sirf EK PC par ON rakho — ek bot do jagah chale to Telegram commands baant deta hai.
Kaunse SKU alert me aayenge aur kitni der me alert jaayega.
Baseline export har kuch din me banta hai. Live file me EasyEcom ke webhooks se aaya abhi ka stock hota hai — dono milakar numbers current rehte hain. Ye band kar doge to report purane export par bani hogi.
Har warehouse me ~99,000 SKU hamesha zero par bethe rehte hain (purana dead catalogue). Isliye zero tabhi report hota hai jab wo SKU upar chuni gayi window me update hua ho — warna file me 3 lakh bekaar rows aa jaati hain.
| When | Trigger | Zero | Low | Telegram | File |
|---|