Is mahine stock reorder sheet kyun zaroori hai
Stock reorder sheet har product ke liye do baatein batati hai: supplier ko agla order kab dena hai, aur kitne piece mangwane hain. Zyada tar Pakistani online sellers yeh faisla shelf dekh kar andaze se karte hain. Aam mahine mein yeh chal jata hai, lekin November mein nahi chalta. 11.11 Budh 11 November ko hai aur Black Friday Jumma 27 November ko, ads mehngi ho jati hain, aur jo product sab se zyada bik raha hota hai wohi sab se pehle khatam hota hai.
COD seller ke liye maal khatam hona doosron se zyada mehnga parta hai. Aap aisi ads ke paise dete rehte hain jo logon ko khaali product page par bhejti hain, ya is se bhi bura, order lete rehte hain aur phir customer ko call kar ke cancel karte hain, jis se trust aur page ke reviews dono kharab hote hain. Zyada maal mangwana bhi utna hi nuqsaan deh hai: aap ka cash cartons mein band para rehta hai jabke courier ke paas pichle hafte ke COD paise abhi tak ruke hote hain.
Neeche ek sheet hai jo aap Google Sheets mein 15 minute mein bana sakte hain, us ke peeche chaar formulas, teen products ki Rs mein misaal, aur hafta war routine. Shopify ke apne inventory numbers is mein jate hain, is liye shuru karne ke liye kisi alag app ki zaroorat nahi.
Har product ke liye kaun se numbers chahiye?
Har product ke liye chhe numbers chahiye (agar size ya rang alag alag bikte hain to har variant ke liye). Paanch aap ke store aur supplier se aate hain, ek aap khud tay karte hain.
- Haath mein stock: aaj aap ke store room mein mojood piece. Shopify mein yeh us location ki available quantity hai jo online orders bhejti hai. Shopify help center ke mutabiq agar aap ki ek se zyada locations hain to jo location online orders poore nahi karti wahan para stock online sale ke liye nahi gina jata.
- Wapas aa raha maal: woh parcel jinhein courier ne return mark kar diya hai aur jinhein aap dobara shelf par rakhne ki tawaqqo rakhte hain. Sirf woh ginein jo dobara bech sakein; kharab return stock nahi hai.
- Order par: woh piece jin ke paise de diye ya supplier se confirm ho gaye lekin abhi pohanche nahi.
- Rozana sale: is product ke pichle 28 din ke confirmed orders, 28 se taqseem. Confirmed ya dispatch hone wale orders lein, har lagne wala order nahi. Fake aur cancel orders aap ki sale ki raftar zyada dikhate hain aur aap zaroorat se zyada maal mangwa lete hain.
- Lead time (din): supplier ko order dene ke din se le kar us din tak jab maal shelf par ho aur bheja ja sake. Shah Alam ya Jodia Bazaar ke supplier se yeh chand din ho sakta hai; import mein hafte lag sakte hain. Apne pichle orders ka hisaab lein, supplier ka waada nahi.
- Safety din: izafi dinon ka stock jo aap is liye rakhte hain ke supplier late ho jaye ya sale achanak barh jaye. Yeh aap ka faisla hai. Ek aam tareeqa yeh hai ke mustaqil bikne wale products ke liye lead time ka aadha rakhein, aur jin products ko sale mein zor se chalana hai un ke liye zyada.
Sheet ke peeche chaar formulas
Stock position woh hai jis par aap bharosa kar sakte hain: Haath mein stock + Wapas aa raha maal + Order par.
Baqi din batate hain ke aaj ki raftar se aap ka stock kitne din chalega: Stock position taqseem Rozana sale. Shopify isi tarah ke number ko days of inventory remaining kehta hai: muddat ke aakhir mein mojood stock, us muddat ki average rozana sale se taqseem. Yeh Shopify admin mein Products page par ek tile ki shakal mein nazar aata hai.
Reorder point woh stock level hai jis par agla order dena laazmi hai: Rozana sale x (Lead time + Safety din). Jab stock position is number ke barabar ya kam ho jaye to aaj hi order dein.
Order ki miqdaar yeh batati hai ke kitne piece mangwayein taake agla order aane tak kaam chale: Rozana sale x (Lead time + Cover din + Safety din) minus Stock position. Cover din yeh hain ke aap yeh order kitne din chalana chahte hain; zyada tar chhote stores ke liye 30 din acha aaghaz hai kyunke yeh mahine mein ek baar supplier ke paas jane se mail khata hai.
Order ki miqdaar ko fi piece laagat se zarb dein to Chahiye cash nikal aata hai. Yeh aakhri column zyada tar sellers bhool jate hain, aur yehi woh jagah hai jahan COD business phans jate hain.
Copy karne wali sheet ka dhancha
Har product ya variant ki ek row banayein aur yeh columns rakhein. Agar aap column A se shuru karein to letters batate hain ke kaun sa formula kahan jayega.
| Column | Naam | Is mein kya daalein |
|---|---|---|
| A | Product / SKU | Shopify mein jo naam hai |
| B | Haath mein stock | Shopify se available quantity |
| C | Wapas aa raha maal | Raaste mein bikne ke qabil returns |
| D | Order par | Paise diye ya confirm, abhi pohancha nahi |
| E | Pichle 28 din ke orders | Sirf confirmed ya dispatch orders |
| F | Rozana sale | =E2/28 |
| G | Lead time (din) | Apne pichle supplier orders se |
| H | Safety din | Aap ka faisla |
| I | Stock position | =B2+C2+D2 |
| J | Baqi din | =IF(F2=0,"no sales",I2/F2) |
| K | Reorder point | =ROUNDUP(F2*(G2+H2),0) |
| L | Abhi order karein? | =IF(I2<=K2,"YES","no") |
| M | Cover din | Shuru mein 30 |
| N | Order ki miqdaar | =IF(L2="YES",MAX(0,ROUNDUP(F2*(G2+M2+H2),0)-I2),0) |
| O | Fi piece laagat (Rs) | Godaam tak pohanchne ki poori laagat |
| P | Chahiye cash (Rs) | =N2*O2 |
Column L par conditional formatting lagayein taake YES laal ho jaye. Column J (Baqi din) ko chhote se bare tarteeb dein, to jin products par tawajjo chahiye woh har baar sheet kholne par sab se upar hon gi.
Misaal: sardiyon ki teen products, Rs mein hisaab
Misaal (tareeqa samjhane ke liye farzi numbers). Lahore ka ek store hoodie, shawl aur bachon ki jacket bechta hai. Woh har order par 30 cover din chahta hai.
| Item | Hoodie | Shawl | Bachon ki jacket |
|---|---|---|---|
| Haath mein stock | 25 | 60 | 6 |
| Wapas aa raha maal | 4 | 0 | 2 |
| Order par | 0 | 0 | 0 |
| Pichle 28 din ke confirmed orders | 84 | 42 | 14 |
| Rozana sale | 3 | 1.5 | 0.5 |
| Lead time (din) | 7 | 10 | 14 |
| Safety din | 4 | 5 | 5 |
| Stock position | 29 | 60 | 8 |
| Baqi din | 9.7 | 40 | 16 |
| Reorder point | 33 | 23 | 10 |
| Abhi order karein? | YES | no | YES |
| Order ki miqdaar | 94 | 0 | 17 |
| Fi piece laagat | Rs 1,800 | Rs 1,200 | Rs 2,200 |
| Chahiye cash | Rs 169,200 | Rs 0 | Rs 37,400 |
Hoodie ki row kaise bani: reorder point = 3 x (7 + 4) = 33. Stock position 29 hai jo 33 se kam hai, is liye sheet kehti hai aaj order dein. Order ki miqdaar = 3 x (7 + 30 + 4) = 123, is mein se 29 jo haath mein ya raaste mein hain nikaal dein = 94 piece. Rs 1,800 fi piece ke hisaab se yeh Rs 169,200 bante hain.
Bachon ki jacket shelf par theek lagti hai, 16 din baqi hain, lekin us ka lead time 14 din aur safety 5 din hai, is liye yeh pehle hi apne reorder point 10 se neeche hai. Yehi aam jaal hai: aahista bikne wali aur lambe lead time wali products khatam ho jati hain halanke kabhi fori masla nahi lagtin.
Shawl ke 40 din baqi hain aur reorder point 23 hai. Is hafte order ki zaroorat nahi. Rozana 1.5 ki raftar se yeh taqreeban 25 din mein 23 tak pohanchegi ((60 - 23) / 1.5), is liye woh cash shelf par para rehne ke bajaye hoodie ke order ke liye farigh rehta hai.
11.11 aur Black Friday ke liye hisaab kaise badlein
Sheet pichle 28 din ka data leti hai, is liye usay nahi pata ke sale aane wali hai. Sale ko alag line ke taur par sambhalein, poore mahine ki rozana sale ko andaze se bara kar ke nahi.
- Woh products chunein jinhein aap waqai sale mein chalayenge. Sirf unhein izafi stock milega.
- Apni purani sale ka hisaab lein. Agar pichle saal ki 11.11 ya aap ki pichli bari sale mein is product ki sale aam din se dugni hui thi to sirf sale ke dinon ke liye dugna lein. Agar purana record nahi hai to bara zarb farz na karein; thora izafi rakhein aur rozana dekhein.
- Sale ke dinon ke izafi piece aam order ki miqdaar ke upar daalein, aur itna pehle order dein ke lead time aur safety din sale shuru hone se pehle poore ho jayein.
- Chahiye cash wale column ko agle do hafton mein waqai aane wale COD paison se milayein, apni kul sale se nahi. Agar cash nahi hai to sab se pehle C grade products kam karein.
Shopify ki product analytics products ko aamdani ke hisaab se A, B aur C grade mein baant'ti hai: A products taqreeban 80% aamdani lati hain, B taqreeban 15% aur C taqreeban 5%. Cash ki tangi wale mahine ke liye aasaan usool: A product kabhi khatam na hone dein, B products maamool ke mutabiq mangwayein, aur C products sirf tab jab woh zero par pohanch jayein.
Kya stock khatam hone par bhi bechte rahein?
Shopify mein har product ke Inventory hisse mein Continue selling when out of stock ki setting hai. Yeh sirf tab kaam karti hai jab inventory tracking on ho. Shopify is ke istemal mein pre-order aur jaldi pohanchne wala stock jaisi soorten batata hai.
Pakistan mein COD ke liye isay sirf tab on karein jab agla maal pehle se order ho chuka ho aur chand din mein pohanch jaye. Jo customer aaj order kare aur das din baad parcel paye, us ke darwaze par parcel wapas karne ka imkaan zyada hota hai, aur har wapas hone wala parcel aap ko delivery aur return charges mein parta hai. Agar on karein to product page aur confirmation message mein dispatch ki mutawaqqa tareekh saaf likhein.
Har hafte 20 minute ki routine
- Peer ki subah: Shopify se available quantity column B mein copy karein.
- Courier portal ki return list se Wapas aa raha maal update karein, sirf bikne ke qabil items ginein.
- Column E mein pichle 28 din ke confirmed orders update karein.
- Baqi din ke hisaab se tarteeb dein. Har YES wali row ka aaj hi supplier ko order jaye, column N ki miqdaar ke mutabiq.
- Column P ka total nikalein aur is hafte aane wali COD payments se milayein.
- Mahine mein ek baar lead time ko asal mein jo hua us se milayein aur column G update karein.
Returns ki wajah se Wapas aa raha maal wala column zyada tar sellers ki tawaqqo se zyada badalta hai. Agar aap RabbitROI istemal karte hain to is mein product aur courier ke hisaab se return rates nazar aate hain, jis se pata chalta hai ke kaun si products sab se zyada wapas aati hain, kin ke liye Wapas aa raha maal ka andaza bara rakhna hai aur kin ke liye safety buffer bara.
Aam sawalat
Online store ka reorder point kaise nikalein?
Rozana sale ko lead time aur safety dinon ke majmooe se zarb dein. Agar aap rozana 3 bechte hain, supplier 7 din leta hai aur aap 4 safety din rakhte hain to reorder point 3 x 11 = 33 piece hai. Jab haath mein, wapas aa raha aur order par stock 33 ya is se kam ho jaye to order dein.
Rozana sale ke liye saare orders ginein ya sirf confirmed?
Sirf confirmed ya dispatch hone wale orders. Fake, duplicate aur cancel COD orders product ko asal se tez bikta dikhate hain aur aap zyada maal mangwa lete hain.
Chhota Shopify store kitne din ka stock rakhe?
Koi ek sahi number nahi. 30 cover din aur lead time ke taqreeban aadhe safety din se shuru karein, phir do teen baar ke baad asal sale aur supplier ki takheer dekh kar badlein.
Kya Shopify batata hai ke stock kam ho raha hai?
Shopify admin mein Products page par days of inventory remaining aur sell-through rate ki tiles dikhata hai aur wahin se inventory reports khulti hain. Alert ke liye Shopify Flow mein workflow bana sakte hain ya app istemal kar sakte hain; upar wali sheet dono ke baghair bhi kaam karti hai.
Comments
Abhi koi comment nahi. Pehla comment aap karein.