Cross-sell ideas from purchase history
Customer bought the panel. The driver is still waiting for its introduction.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get product purchase rows
Use customer code, product code, quantity and status. Confirm which complementary product is actually approved to offer.
Choose your pairing
Use your team's product knowledge, not an AI guess about compatibility.
Privacy Remove phone numbers, email IDs and payment details where not needed. Use only approved business names and facts.
I'm attaching purchase history for [History period]. Base product [Base product code], complementary product [Approved complementary product]. Rule: [Eligibility rule]. A. Group by customer; show completed positive quantities for both products, ignore cancelled rows; flag missing quantity for either product rather than treating as zero. B. List eligible customers, already bought both, no base purchase and history unclear. Count each customer once. C. Draft short (up to 6 lines) outreach template for eligible customers with [Customer name], asking whether complementary product is relevant. No compatibility, price, stock or delivery promise. Use only supplied facts. Never invent customer names, testimonials, urgency, prices, discounts, delivery dates or credit terms. A person reviews before sending or deciding. Line limits count body lines only, not subject, greeting or sign-off. Keep every required fact; if they do not fit, say so instead of dropping one.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep your actual records in your own workbook; ask AI for the local method using headings and rules only.
Excel A:D customer, product, qty, status. Base [Base product code], complementary [Approved complementary product], rule [Eligibility rule]. Give a unique customer summary with SUMIFS positive completed quantities and COUNTIFS missing qty, flag eligible/already both/no base/unknown. Ignore cancelled rows and do not assume compatibility. Tell me exactly where to paste formulas or set up the local steps. Use fictional examples only; do not ask for actual customer, employee or vendor records.
Run the method locally; verify every exception against source records and obtain approval before acting.
- C1Panel only. Eligible for a question, not a compatibility claim.
- C2Both bought. Not in this campaign.
- C4Driver qty missing. Review history; no message yet.
Then send this: Recount customers and product quantities using completed positive rows; check cancelled and missing rows and remove unsupported compatibility claim.
It treats cancelled as sale
Reply: "Completed positive rows only."
It assumes blank zero
Reply: "Flag unclear history."
It guarantees compatibility
Reply: "Ask whether relevant; confirm specs first."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.