The Pickle Story · SmartCommerce
Order Desk
Live from the NPP Order Logger — orders, dispatch status, callbacks & abandoned carts.
✅ TO-DO
▶Loading live data…
🎁 Welcome Offer
▶Customers who open a partner's SmartLink or a shop QR see a popup after 10 seconds: "Enter your WhatsApp number to unlock ₹ off". First order only, one per phone number, ₹ INR only, on product value only. Pickle Story pays the discount — partner and outlet commission is worked out on the full price.
to
Every number that took the offer (full list: "Welcome Offers" tab in the sheet). Numbers with no order are added to 🛒 Abandoned carts automatically when the offer runs out.
📅 Follow-up Calendar
▶🗓️ Team Calendar
▶📱 Daily Digest
0
Total orders
0
Ready to dispatch
0
Awaiting payment
₹0
Collected revenue
0
Open callbacks
0
Carts to follow up
0
Needs attention
₹0
Average order value · Last 30 Days · by partner ↓
📈 Performance
▶🤝 Partner Performance
▶💰 Commission Calculator
| Order | Placed | Customer | Items | Partner | Value | Commission | Payment | Dispatch |
|---|
Commission is on Items Sub Total only (never shipping/COD), at the partner's slab for that whole month. Cancelled orders are left out.
📦 NPP Orders · 0 orders
▶| Order | Placed | Customer | Items | Partner | Value | Payment | Dispatch |
|---|
🏪 SmartComm Orders · 0 orders
▶| Order | Placed | Customer | Items | Outlet | Value | Payment | Dispatch |
|---|
📸 Influencer Orders · 0 orders
▶| Order | Placed | Customer | Items | Influencer | Value | Payment | Dispatch |
|---|
🛍️ Direct Orders
▶🌐 Website Orders
▶🚚 Pending Dispatch
▶| Order | Placed | Customer | Items | Partner | Value | Payment | Dispatch |
|---|
💰 Pending Payment
▶| Order | Placed | Customer | Items | Partner | Value | Payment | Dispatch |
|---|
🧮 Partner-wise AOV
▶📋 Partner Report
▶
Show:
👀 Partner SmartLink visits
▶One visit = one person opening a partner's SmartLink (counted once per visit, your own visits from SmartCommerce Home are not counted). Link = their normal SmartLink · Product link = a link to a product or page (e.g. #hampers) · Home-screen icon = opened from the saved Pickle Story icon · Came back = returned later without the SmartLink and the partner was remembered. Counting started on 20 Oct 2026.
✍️ Message sent with the green WhatsApp button (tap to edit)
Filled in for each partner: {name} {month} {tm_visits} {tm_orders} {lastmonth} {lm_visits} {lm_orders} {link}. Reset message
🩺 Partners Health, Coupons and Contact
▶M1 = orders in the last 30 days, M2 = 31–60 days ago, M3 = 61–90 days ago (blank = not joined yet), Total = M1 + M2 + M3. A partner's row updates straight after each of their orders, and everyone is rechecked every morning at 6 AM. Shop QR outlets are on the SmartCommerce page.
👋 Welcome message sent with the Welcome button (tap to edit)
Filled in for each partner: {name} {links} {codes}. Reset message
🎟 Partners Gift Coupons
▶Discount coupons partners give their own customers (created with 🎟 Coupon above). Total value = discounts given on orders using the code (cancelled orders left out); it is deducted from that partner's commission.
📸 NPP Insta Partners
▶
📦 Samples Sent
Insta Partner details
🎁 Pick products to send
Red ✓ = already sent to this partner (with the date). Green = sent more than 90 days ago, ready to send again. Tick the sizes you want to send (one or more per product).
Insta Partners are normal NPP partners: same SmartLink, same commission. Tap a partner's name (or 📦 Samples & posts) to see their scorecard, every product sent and every post, tick products (with size), 🖨️ print the Despatch Order, 💬 WhatsApp it and 🚀 send it to Shiprocket. Log each Reel / Story there too. Saved in the Insta Partners, Insta Despatches and Insta Posts tabs.
📨 Instagram Invites · invite food creators to NPP
▶Copy the message, send it on Instagram, then update the status. Pale yellow = already worked on. Saved in the "Insta Invites" tab, so every device shows the same list.
✍️ Add by hand
One person per line: Name | handle | followers | group | why | opening message (only Name and handle are needed).
⚙️ Edit common message · Download Excel
✉️ Common message (added after each person's opening line)
🏆 Partners Leader Board
▶
Rank:
📞 Callback requests
▶🛒 Abandoned carts to follow up
▶⚠️ Needs Attention
▶📅 Monthly Commission Statements
▶
Exports exactly the partners shown above — the payment list for the 7th. Commission is on product value only; cancelled orders are left out.
📊 Partner Monthly Report · Notify On partners
▶
Change any wording below. The words in {curly brackets} are filled in for each partner automatically, so keep them as they are (you can move or delete them).
A line holding only a {word} that has nothing to show for that partner is left out of their message.
{name} first name · {month} report month · {visits} SmartLink visits line · {orders} number of orders · {value} total order value · {commission} slab and commission lines · {tip} personal line (conversion, next slab, or encouragement) · {payment} payment date line · {link} their SmartLink · {thismonth} current month
{name} first name · {month} report month · {visits} SmartLink visits line · {orders} number of orders · {value} total order value · {commission} slab and commission lines · {tip} personal line (conversion, next slab, or encouragement) · {payment} payment date line · {link} their SmartLink · {thismonth} current month
🎁 Brand Ambassador Gift Coupon Statement · Notify Yes partners
▶✍️ Gift coupon message (tap to edit)
Filled in for each partner: {name} {code} {amount} {validtill} {month} {link}. Reset message
Downloads the coupon statement (one row per partner) and every order behind it. Change an amount in its box before sending. Sending again with a new amount updates the same coupon code.