Partner files (All Partners, Notify On, Notify Off, Notify Yes, Notify No, NPP Insta Partners): Name, Full Phone Number, Phone Number, Country Code, Email, WhatsApp Opted, Partner Link. The NPP Insta Partners file also has an Insta Handle column, and only lists partners marked Active in the Insta Partners tab.
SmartCommerce Outlets file: same columns as the partner files; Name is the owner's name and the SmartLink is the shop's own SmartLink (e.g. https://picklestory.netlify.app/?p=sctg0001). Only Live outlets are included.
Customers file: Name, Full Phone Number, Phone Number, Country Code, Email, WhatsApp Opted.
Numbers without a country code are treated as Indian (91). Email is filled only where the sheet has one. WhatsApp Opted is always TRUE. Partner Link is the partner's full SmartLink, built from their Alt. Partner Code in column I (e.g. https://picklestory.netlify.app/?p=in0008), or from their Partner Code (e.g. ?p=rama) if column I is empty — left blank if the Partners tab has no code for them. Rows with no phone number are left out.

WhatsApp button list: a single .html file. Open it from your Downloads on your phone or computer; each name has a WhatsApp button that opens a chat with that number. Each message carries the text you type once at the top (with emojis, an optional video link and an optional image). The message, video link and image stay until you press Clear. WhatsApp links can only carry text, so on a computer the image is copied for you and you press Ctrl+V in the chat to attach it. Tapped buttons turn green so you can see who you have already messaged. On a computer, chats open in the WhatsApp Desktop app: the message is copied for you, so press Ctrl+V and then Enter in the chat (WhatsApp Desktop would otherwise turn emojis into "?"). You can switch to WhatsApp Web at the top of the file instead. On a phone they open in the WhatsApp app with the message already typed.

Start and end of each message (14 Oct 2026): a tick box turns Dear (name), at the start on or off (on by default). In partner lists you also choose how each message ends: Share your SmartLink (their SmartLink) + Share more Earn more (default), only their SmartLink, or nothing. You can also type {name} or {link} anywhere in your message to put the name or that partner's SmartLink there. These choices are remembered on that phone or computer.

🎯 Link opens a particular page (partner lists): type a page, e.g. hampers or a product name like rava-laddu, and every partner SmartLink becomes …/?p=rama#hampers, so it opens straight on that page while still crediting the partner. Leave it empty for the normal home page. It is kept until you press Clear.

Save our numbers (12 Oct 2026): with the tick box on (it is on by default), every message also carries a link to picklestory.vcf. Tapping it lets the person save all three Pickle Story numbers (NPP, LPP, API) to their contacts in one go. WhatsApp links can't attach a contact card, so this link does the same job.