Is hafte 11.11 discount calculator kyun zaroori hai
11.11 Budh ko hai, aur har COD seller ka ek hi sawal hai: 11.11 sale mein kitna discount dein ke nuqsaan na ho? Ye discount calculator isi sawal ka jawab hai. Zyada tar seller koi bhi acha lagne wala number chun lete hain, jaise 20 ya 30 percent, kyunke bare marketplaces sale ka shor macha rahe hain. Daraz ne October mein apne 11.11 festival se pehle Karachi mein 1,000 se zyada sellers ke saath Seller Summit aur Lahore mein 200 brands ke numaindon ke saath apna pehla Brands Summit kiya. Pichle saal Daraz ke mutabiq 48,000 se zyada sellers ne apni pichli 11.11 sale se zyada becha. Aap ke customers ye offers dekhenge aur compare karenge.
Masla ye hai ke COD par discount ka kharcha sirf woh rupay nahi jo aap qeemat se kaatte hain. Har wapas aane wala parcel dono taraf ki shipping khata hai, aur har order par ad ka paisa lag chuka hota hai. Is liye safe discount aap ke return rate aur ad kharche par depend karta hai, is par nahi ke baqi sab kitna de rahe hain. Neeche ek sheet hai jo aap paanch minute mein Google Sheets mein bana sakte hain, Rs mein ek misaal, aur agle teen din ka chhota plan.
Sheet mein kya daalna hai?
Har product ki ek line banayein. Ye inputs hain, sab per shipped order, Rs mein, siwaye jahan percent likha ho:
| Column | Kya likhna hai | Kahan se milega |
|---|---|---|
| A. Product | Product ka naam ya SKU | Aap ki Shopify product list |
| B. Normal price | Sale se pehle aaj customer jo qeemat deta hai | Shopify product page |
| C. Product cost | Ek piece aap ko store tak kitne ka parta hai | Supplier ke bill |
| D. Forward shipping | Is weight ka ek parcel pohanchane ka courier charge | Courier invoice |
| E. Return charge | Parcel wapas aane par courier ka extra charge | Courier invoice ya rate sheet |
| F. Packing | Flyer, dabba, tape, slip, ek parcel ke liye | Packing ke bill divide parcels |
| G. Delivery rate | Ship hone wale parcels mein se kitne deliver hote hain, decimal mein (80% = 0.8) | Is product ka pichle 30 se 60 din ka courier data |
| H. Ad cost per shipped order | Ad kharcha divide shipped orders, sale wale hafte ka andaza | Meta ya TikTok Ads Manager aur orders ki ginti |
| I. Minimum profit | Sale mein per shipped order kam az kam kitna profit chahiye | Aap ka apna faisla |
Apna delivery rate lagayein, andaza nahi. Sirf andaze ke liye: OrderNation ki 2026 ki study mein ek bare Pakistani online retailer ke taqreeban 127,000 parcels mein se 19.4% shipped parcels wapas aaye, aur nakaam COD delivery ko hisaab mein nazar aane mein median 21.7 din lage. Ye ek retailer hai, poori market nahi. Agar har product ka data nahi hai to store ka average lagayein aur us line par nishaan laga dein taake baad mein theek kar sakein.
Paste karne wale formulas
Inputs column A se I mein doosri line se likhein, phir ye formulas doosri line mein paste kar ke neeche drag kar dein:
| Column | Matlab | Doosri line ka formula |
|---|---|---|
| J. Break even price | Woh kam se kam qeemat jis par returns aur ads ke baad profit zero ho | =(((1-G2)*(D2+E2+F2))+H2)/G2+C2+D2+F2 |
| K. Floor price | Woh kam se kam qeemat jis par aap ka minimum profit bache | =J2+I2/G2 |
| L. Max discount (Rs) | Rs mein sab se bara discount jo de sakte hain | =B2-K2 |
| M. Max discount (%) | Yahi discount normal price ke percent mein | =L2/B2 |
| N. Chuni hui sale price par per shipped order profit | Sale price column O mein likhein | =G2*(O2-C2-D2-F2)-(1-G2)*(D2+E2+F2)-H2 |
Break even formula aasaan alfaaz mein: har wapas aane wala parcel forward shipping, return charge aur packing ka nuqsaan karta hai. Is mein ad ka kharcha jorein. Ye sara kharcha un parcels ne poora karna hai jo deliver hote hain, is liye ise delivery rate se divide karein. Phir deliver hone wale parcel ka apna kharcha jorein: product, shipping aur packing. Jawab woh qeemat hai jis par aap kuch nahi kamate. Agar column L minus mein aaye to aap ki normal price pehle hi floor ke qareeb hai aur us product par discount bilkul nahi dena chahiye.
Agar aap ka courier parcel ki qeemat ke percent mein COD collection fee leta hai, ya aap ki COD payment se tax katta hai, to is qeemat ke hisaab se woh raqam column D mein jor dein. Asal rate apne courier aur apne accountant se confirm karein.
Misaal: Rs 3,000 ke product par kitna discount?
Misaal (farzi numbers, kisi store ya courier ka asal data nahi). Ek seller product Rs 3,000 mein bechta hai. Product cost Rs 1,100, forward shipping Rs 250, return charge Rs 200, packing Rs 50. Ship hone wale 80% parcel deliver hote hain. Normal din mein ad kharcha Rs 400 per shipped order hai; sale wale hafte ke liye seller Rs 500 maanta hai, kyunke bohat se brands unhi customers ke liye boli laga rahe hote hain.
- Normal profit per shipped order: 0.8 x (3,000 - 1,100 - 250 - 50) - 0.2 x (250 + 200 + 50) - 400 = 1,280 - 100 - 400 = Rs 780.
- Sale wale hafte mein break even price: (0.2 x 500 + 500) / 0.8 + 1,400 = 750 + 1,400 = Rs 2,150. Yani Rs 850 (28%) se zyada discount par har shipped order par nuqsaan hai.
- Agar seller per shipped order kam az kam Rs 400 chahta hai to floor price: 2,150 + 400 / 0.8 = Rs 2,650. Max discount Rs 350, taqreeban 12%.
Doosra number woh hai jo zyada tar seller miss kar dete hain. Marketplace ke banners ke saath 30% sale normal lagti hai, lekin is product par iska matlab hai customer ko paise de kar parcel lene ko kehna. Ab bara sawal: discount faida mand hone ke liye kitne zyada orders chahiye? Normal din mein 100 shipped orders Rs 78,000 kamate hain. Ye table batati hai ke sale mein utna hi kamane ke liye kya chahiye, 80% delivery par aur agar sale ke returns barh kar 25% ho jayein, jo jaldi mein kiye gaye orders mein aam hai.
| Discount | Sale price | Profit per shipped order (80% delivery) | Rs 78,000 barabar karne ke liye orders | Profit per shipped order agar 75% delivery |
|---|---|---|---|---|
| 0% | Rs 3,000 | Rs 680 | 115 | Rs 575 |
| 5% | Rs 2,850 | Rs 560 | 140 | Rs 463 |
| 10% | Rs 2,700 | Rs 440 | 178 | Rs 350 |
| 15% | Rs 2,550 | Rs 320 | 244 | Rs 238 |
| 20% | Rs 2,400 | Rs 200 | 390 | Rs 125 |
| 25% | Rs 2,250 | Rs 80 | 975 | Rs 13 |
Aaram se parhein. 10% discount par seller ko utna hi kamane ke liye normal din se 78% zyada shipped orders chahiye. 20% par taqreeban chaar guna. 25% par taqreeban das guna, aur agar returns thore bhi barhein to profit khatam. Discount ek shart hai ke sale bohat barh jayegi. Sheet batati hai ke ye shart lagane se pehle sale kitni barhni chahiye.
Kaun se offers seedhe discount se saste parte hain?
Kyunke COD ke zyada tar kharche per parcel hote hain, is liye parcel mein kuch jorne wale offers aam taur par ek piece ki qeemat kaatne se saste parte hain:
| Offer | Asal mein aap ka kya kharcha hota hai | Kab use karein |
|---|---|---|
| Seedha percent discount | Har order par poora discount, un par bhi jo waise bhi khareed lete | Purana stock nikalna ho |
| Doosra piece sasta (2 piece Rs 5,400) | Discount sirf tab jab customer zyada le, aur shipping aur ad ka kharcha do pieces mein bat jata hai | Jore mein ya gift ke taur par bikne wali cheezein |
| Ek had se upar free delivery | Woh delivery charge jo aap lete, sirf bare orders par | Kayi sasti cheezon wale store |
| Parcel mein free gift | Gift ki cost, uski bechne wali qeemat nahi | Jab aap ke paas sasti, halki cheez ho |
| Form par chhota order bump | Kuch nahi; ye profit barhata hai | Har product par, basharte pehle se tick na ho |
Har offer ko isi sheet se guzarein: 2 piece wale offer ke liye column O mein bundle ki qeemat likhein, product cost double karein, aur bhaari parcel ki asal shipping lagayein. Agar aap ek page wale COD order form se bechte hain to offer naam aur address wali jagah ke saath, Rs mein likha hona chahiye. RabbitROI ki Shopify app ek page wale COD order form par bundles aur quantity offers, 1-tick order bumps aur upsells ke saath yahi karti hai.
Sale imaandaar rakhein: CCP ne kis cheez se khabardar kiya hai
Competition Commission of Pakistan (CCP) ne Competition Act ki Section 10 ke tehat, jo gumraah kun marketing se mutaliq hai, discount ke ishtiharaat par ek se zyada baar action liya hai. December 2023 mein usne brands ko khabardar kiya jab pata chala ke "flat" discount har cheez par nahi tha aur bahar ke banners andar ki qeematon se bara discount dikha rahe the. September 2024 mein usne 20 brands ko "up to" discount par notice diye jahan sab se bara discount chand ghair maqbool cheezon par tha. Online store par bhi yahi usool lagu hota hai:
- Kati hui "compare at" qeemat woh honi chahiye jo aap ne waqai li ho, sale se pehle barhai hui nahi.
- Agar aap "40% tak discount" likhte hain to asal, maqbool products par woh discount ho, sirf ek bache hue size par nahi.
- Sharaait (minimum order, kaun se products, khatam hone ka waqt) offer ke paas parhne ke qabil likhein.
- WhatsApp ya phone confirmation mein sale price dobara batayein taake darwaze par rider se behas na ho.
Ye aam maloomat hai, qanooni mashwara nahi. Imaandaar qeemat darwaze par inkaar bhi kam karti hai: jo customer khud ko dhoka khaya hua mehsoos kare, woh rider ko paise nahi deta.
Budh se pehle kya karein: 3 din ka plan
- Itwar ya Peer: sheet banayein, sale ke hisaab se apne top 10 products ki ek ek line bharein, aur har ek ka delivery rate courier data se nikalein.
- Peer: per shipped order minimum profit tay karein. Discount sirf un products par dein jin ka column L saaf taur par plus mein ho.
- Peer: jin products ka column L kam ya minus mein ho, wahan discount ki jagah 2 piece offer, free gift ya had se upar free delivery rakhein, aur har ek ko column N mein check karein.
- Mangal: compare-at qeematein sirf asal pichli qeematon par rakhein, sale khatam hone ka saaf waqt likhein, aur order confirm karne wale ko sale ki sahi qeematein bata dein.
- Budh: poora din per shipped order ad kharcha dekhte rahein. Agar ye column H wale number se kaafi upar chala jaye to sheet dobara chalayein aur floor se neeche jaane wale products rok dein.
- Teen chaar hafte baad: jab returns aa jayein to per shipped order ka asal profit sheet se milayein. Black Friday aur agli sale ke liye asal numbers use karein.
Aakhri qadam par zyada tar seller sabaq kho dete hain, kyunke sale ke returns hafton baad aate hain. RabbitROI courier, shehar aur product ke hisaab se return (RTO) rate, aur returns, ad kharche, product cost aur shipping ke baad har ad campaign ka asal profit dikhati hai, jo is baat ka asal saboot hai ke sale ne paisa kamaya ya nahi.
Aam sawalat
Pakistan mein 11.11 par kitna discount dena chahiye?
Sab ke liye ek sahi percent nahi hai. Product cost, shipping, return rate aur ad kharche se apni floor price nikalein, phir sale price us se upar rakhein. Is post ki misaal mein Rs 3,000 ke product par taqreeban 12% discount de kar per shipped order Rs 400 profit bachta tha, aur taqreeban 28% par profit zero ho jata tha.
COD product ki break even price kaise nikalein?
Returns ka nuqsaan (forward shipping, return charge aur packing zarb return ka hissa) aur per shipped order ad kharcha jorein, delivery rate se divide karein, phir deliver hone wale parcel ki product, shipping aur packing ki cost jorein. Is post ki sheet ye ek formula mein karti hai.
COD ke liye 2 piece offer discount se behtar hai?
Aksar haan, kyunke discount sirf tab milta hai jab customer zyada le, aur shipping, ad aur return ka kharcha do pieces mein bat jata hai. Bundle ko sheet mein double product cost aur bhaari parcel ki asal shipping ke saath check karein.
Kya sale mein returns barh jate hain?
Barh sakte hain, kyunke sale ke orders jaldi mein kiye jate hain. Pakistan ka koi qabil-e-aitmaad public number nahi hai, is liye sale wale orders ka apna return rate teen chaar hafte dekhein aur normal hafton se compare karein.
Kya discount bara dikhane ke liye compare-at price zyada likh sakte hain?
Nahi. Competition Commission of Pakistan ne Competition Act ki Section 10 ke tehat gumraah kun discount daawon par brands ko khabardar kiya hai. Sirf woh qeematein dikhayein jo aap ne sale se pehle waqai li thin.
Hawalay
- ProPakistani: Daraz Pakistan Deepens Industry Partnerships Through Seller and Brand Summits Ahead of 11.11 (Oct 2026)
- ProPakistani: DarazMall Brands Lead Daraz Pakistan's 11.11 Sale with Record Growth (Dec 2025)
- OrderNation: State of Online Shopping in Pakistan 2026
- Dawn: 20 brands issued notices for deceptive discount ads
- Profit: Fake discounts and sales no more; CCP takes notice
Comments
Abhi koi comment nahi. Pehla comment aap karein.