Total
0
Pending
0
Printing
0
Dispatched
0
Delivered
0
Due/Late
0
| Order ID | Customer | City | Platform | Type/Qty | Order Date | Delivery | Amount | Status ▾ | Actions |
|---|
0 records
➕ New Order
📍 Delivery Address
Import Orders
PDF packing slips లేదా Order IDs paste చేయండి
PDF Packing Slip Import
Amazon Seller Central → Orders → Select orders → Print packing slips → Save as PDF → Upload here
📄
Click or drag & drop PDF
Amazon packing slip PDF
Extracted — 0 orders
| # | Order ID | Name | City | Qty | Amount |
|---|
👥 Target Segment
Segment select చేయండి...
🎁 Loyalty Offer
🚀 New Launch
🎊 Festival Offer
💌 Re-engagement
✍️ Custom Message
Use {name} — auto replaced with first name.
Customers
0 unique customers
📊 Google Sheets Setup
4 steps · ~10 minutes · Use shithi.in Gmail
1
Create Google Sheet
In shithi.in Gmail account
- Open sheets.google.com with shithi.in account
- New sheet → Name:
Shithi Orders - Row 1 headers:
A:Timestamp B:Order ID C:Customer D:WhatsApp E:Alt Phone F:Platform
G:Magnet Type H:Qty I:Amount J:Order Date K:Delivery Date
L:Days Remaining M:Delivery Status N:Address O:City P:State Q:Pincode
R:Status S:Notes
G:Magnet Type H:Qty I:Amount J:Order Date K:Delivery Date
L:Days Remaining M:Delivery Status N:Address O:City P:State Q:Pincode
R:Status S:Notes
2
Paste Apps Script
Extensions → Apps Script
- Spreadsheet → Extensions → Apps Script
- Delete existing code, paste:
function doPost(e) {
var s = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var orders = JSON.parse(e.postData.contents).orders;
var last = s.getLastRow();
if (last > 1) s.deleteRows(2, last - 1);
var today = new Date(); today.setHours(0,0,0,0);
orders.forEach(function(o) {
var dr="", ds="";
if(o.deliveryDate){
var dd=new Date(o.deliveryDate); dd.setHours(0,0,0,0);
var diff=Math.round((dd-today)/86400000);
if(o.status==="Delivered"){dr="✅ Done";ds="Delivered";}
else if(o.status==="Cancelled"){dr="❌";ds="Cancelled";}
else if(diff<0){dr="⚠️ Overdue "+Math.abs(diff)+"d";ds="Overdue";}
else if(diff===0){dr="🔴 Due Today!";ds="Due Today";}
else{dr=diff+" days left";ds="Pending";}
}
s.appendRow([new Date(),o.orderId,o.name,o.wa,o.alt,
o.platform,o.magnetType,o.qty,o.amount,
o.orderDate,o.deliveryDate,dr,ds,
o.address,o.city,o.state,o.pincode,o.status,o.notes]);
});
return ContentService.createTextOutput(
JSON.stringify({status:"ok",count:orders.length}))
.setMimeType(ContentService.MimeType.JSON);
}
function doGet(){return ContentService.createTextOutput("Shithi OK");}
var s = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var orders = JSON.parse(e.postData.contents).orders;
var last = s.getLastRow();
if (last > 1) s.deleteRows(2, last - 1);
var today = new Date(); today.setHours(0,0,0,0);
orders.forEach(function(o) {
var dr="", ds="";
if(o.deliveryDate){
var dd=new Date(o.deliveryDate); dd.setHours(0,0,0,0);
var diff=Math.round((dd-today)/86400000);
if(o.status==="Delivered"){dr="✅ Done";ds="Delivered";}
else if(o.status==="Cancelled"){dr="❌";ds="Cancelled";}
else if(diff<0){dr="⚠️ Overdue "+Math.abs(diff)+"d";ds="Overdue";}
else if(diff===0){dr="🔴 Due Today!";ds="Due Today";}
else{dr=diff+" days left";ds="Pending";}
}
s.appendRow([new Date(),o.orderId,o.name,o.wa,o.alt,
o.platform,o.magnetType,o.qty,o.amount,
o.orderDate,o.deliveryDate,dr,ds,
o.address,o.city,o.state,o.pincode,o.status,o.notes]);
});
return ContentService.createTextOutput(
JSON.stringify({status:"ok",count:orders.length}))
.setMimeType(ContentService.MimeType.JSON);
}
function doGet(){return ContentService.createTextOutput("Shithi OK");}
3
Deploy as Web App
Deploy → New deployment
- Deploy → New deployment → Web App
- Execute as:
Me (shithi.in) - Who has access:
Anyone - Deploy → Allow → Copy URL 🔗
https://script.google.com/macros/s/AKfycby.../exec4
Paste URL & Test
Connect and verify
👑 Owner Account
👤 Employee Accounts
Staff: Orders + WhatsApp + Marketing ✅ | Revenue ❌ | Delete ❌ | Settings ❌
📊 Google Sheets URL
🗄 Data