Warren Buffett قال إن أهم حاجة في تقييم أي بيزنس هي قوة التسعير. وإنت مش هتعرف تسعّر صح قبل ما تعرف بتكسب كام فعلاً من كل صنف ومن كل عميل. اعمل Copy لكل prompt، وارفع معاه ملفات المبيعات والتكلفة من Excel أو Odoo.
أنهي صنف بيكسّبك وأنهي صنف بيأكل من ربحك. بيحسب الـ margin بالمبلغ وبالنسبة، ويرتّب الأصناف، ويطلّعلك أضعف 10 أصناف مع الأرقام اللي وراها.
<role>Act as a financial analyst for a trading and distribution company. Use simple formulas and show your work.</role>
<data>I will attach my sales lines (item, date, customer, quantity, selling price, discount) and my cost sheet (item, unit cost), from Excel or Odoo. If a column is missing or an item has no cost, ask me. Ask me if each discount is per unit, per line or a %, and if the price is before or after it. Never guess.</data>
<task>Calculate the margin of every item: profit after cost.</task>
<steps>
1. Match each sales line to its unit cost by item and list items with no match
2. Net revenue = quantity × price - discount, with the discount turned into an amount for the line
3. Cost per line = quantity × unit cost
4. Margin per item = net revenue - cost, in amount and in % of revenue
5. Rank the items by margin amount, and separately by margin %
</steps>
<rules>
- Use the same period for sales and costs and say which period it is
- If an item has several unit costs, use the latest and say so
- Show the numbers behind every item
</rules>
<output>A table: Item → Qty sold → Net revenue → Cost → Margin → Margin %. Then the 10 weakest items by margin %, and the total margin. Give the full table as a downloadable XLSX and show only the top 10 here.</output>بعد الخصومات والمرتجعات: العميل الكبير مش دايمًا الأربح. بيحسب ربح كل عميل الحقيقي، ويقارن ترتيبه في المبيعات بترتيبه في الربح.
<role>Act as a commercial analyst who finds out which customers really make money after discounts and returns.</role>
<data>I will attach my sales lines (customer, item, date, quantity, selling price, discount), my returns or credit notes (with quantities), and unit cost by item. If a column is missing, ask me. Ask me if each discount is per unit, per line or a %, and if the price is before or after it. Never guess.</data>
<task>Calculate the real margin of every customer so I can see who makes me money and who only looks big.</task>
<steps>
1. Net revenue per customer = sales - discounts - returns
2. Cost per customer = (quantity bought - quantity returned) × unit cost
3. Margin per customer = net revenue - cost, as an amount and as a %
4. Show the average discount % each customer got
5. Compare each customer's margin rank with their sales rank
</steps>
<rules>
- Under 3 orders (or the number I give): mark "not enough data"
- Merge duplicate customer names only after asking me
- Never subtract a discount twice: ask me if the prices already include it
- Show the numbers behind every customer
</rules>
<output>A table: Customer → Orders → Net revenue → Avg discount % → Margin → Margin %. Then the 10 customers with the biggest gap between sales rank and margin rank. Give the full table as a downloadable XLSX and show only the top 10 here.</output>صنف بيتباع بأقل من تكلفته بيخسّرك مع كل أوردر. بيلاقي السطور اللي سعرها بعد الخصم أقل من التكلفة، ويحسب خسارتك الكلية، ويقولك السبب: سعر واطي ولا خصم كبير.
<role>Act as a pricing analyst who finds products that lose money on every sale.</role>
<data>I will attach my sales lines (item, date, customer, quantity, selling price, discount) and unit cost by item from Excel or Odoo. If a column is missing or an item has no cost, ask me. Ask me if each discount is per unit, per line or a %, and if the price is before or after it. Never guess.</data>
<task>Find sales priced below cost and show my loss.</task>
<steps>
1. Net price per unit = selling price - discount, as a per-unit amount
2. A loss line is any line where the net price is below the unit cost
3. Per item: loss lines and total loss = (cost - net price) × quantity
4. Split always-losing items from items that lose only with some customers
5. Main reason per item: price too low or discount too high. If the data cannot tell, write "not in the data"
</steps>
<rules>
- Start with the biggest total loss
- Items with no cost are listed as "no cost", never assumed
- Say which cost you used if an item has more than one
- Show the numbers behind every item
</rules>
<output>A table: Item → Loss sales → Avg net price → Unit cost → Total loss → Main reason. Then the total loss for the period and 3 actions I can take this week. Give the full table as a downloadable XLSX and show only the top 10 here.</output>عملاء بياخدوا خصم أكبر من حجم شغلهم معاك. بيقسّم العملاء حسب مشترياتهم، ويعلّم اللي خصمهم أعلى بوضوح من شريحتهم، ويقولك مين تكلّمه الأول.
<role>Act as a sales controller who checks if discounts are earned.</role>
<data>I will attach my sales lines (customer, item, date, quantity, selling price, discount), unit cost by item, and my discount policy (if none, ask me what rules I use). Ask me if each discount is per unit, per line or a %, and if the price is before or after it. Never guess.</data>
<task>Find customers whose discount is bigger than they earn.</task>
<steps>
1. Average discount % per customer = total discount ÷ total value before discount
2. Total purchases and number of orders per customer
3. Group customers by total purchases into 3 size bands (tell me the bands) and flag those clearly above their band
4. If I gave a discount policy, also compare each customer with it
5. Check each flagged customer's margin % after the discount
6. Extra profit if the flagged discounts moved to the band average
</steps>
<rules>
- "Clearly above" = over 5 points above the band (or my number)
- Customers with little history are marked "not enough data"
- Facts only: do not blame anyone
</rules>
<output>A table: Customer → Purchases → Avg discount % → Band avg % → Margin % → Extra profit. Then the 5 customers I should talk to first.</output>أنهي أسعار تتزوّد، وبنسبة قد إيه، من أرقامك. بيسألك الأول عن الـ margin اللي مستهدفه، وبعدين يقترح أصغر زيادة توصّلك له، ويحسب الربح الزيادة لو الكمية ثابتة ولو قلّت.
<role>Act as a pricing strategist. Base every suggestion on my numbers.</role>
<data>I will attach 12 months of sales lines (item, customer, date, quantity, selling price, discount) and unit cost by item, with the date each cost last changed if you have it. Before you start, ask me for my target margin % (margin ÷ price) if I did not type it. If something is missing, ask me. Never guess.</data>
<task>Find the items I can raise the price on, and by how much.</task>
<steps>
1. Flag the items whose margin % is below my target
2. Lower risk to raise: items whose sales held or grew in the last 6 months (a hint, not a guarantee)
3. Raise first: items whose unit cost went up since my last price change (only if I gave cost dates, otherwise skip this step and say so)
4. Suggest the smallest raise that reaches my target margin, capped at 10% unless I allow more
5. Extra profit if volume stays the same and if it falls 10% (or the % I give)
</steps>
<rules>
- Show the numbers behind every suggestion
- Items with less than 8 weeks (or the number I give) of sales are marked "not enough data"
</rules>
<output>A table: Item → Price → Cost → Margin % → Raise % → New price → Extra profit. Then the 5 lowest-risk raises to start with.</output>بالمصري، وجاهزة تبعتها لعملائك. الصق الأسعار القديمة والجديدة وتاريخ البداية والسبب، وهيكتبلك 3 نسخ: للعملاء الكبار، والصغار، واللي بيشتكوا من الأسعار، مع ردود جاهزة على أسئلتهم.
<role>Act as a writer for a trading company in Egypt. Sound like a real owner talking to his customers on WhatsApp.</role>
<data>I will paste the items with old and new price, the start date of the new prices, and the reason in one sentence. If something is missing, ask me. Never guess.</data>
<task>Write the WhatsApp price-change message.</task>
<steps>
1. Write every message and reply in natural spoken Egyptian Arabic (colloquial, the way people text in Cairo), in Arabic script, never formal Modern Standard Arabic. Include the start date
2. Give the reason honestly in one sentence
3. List old and new prices of the main items, names as in my list
4. Write 3 versions: for big customers, for small customers, and for customers who complain about prices
5. End with one clear next step: reply here or call me
</steps>
<rules>
- No pressure words and no fake urgency
- Never promise an old price, a discount or a date I did not give you
- Maximum 8 lines per message
</rules>
<output>The 3 messages ready to copy, then short replies to: why, is it for everything, can I keep the old price. If I did not tell you my policy on old prices, ask me before you write the reply about keeping the old price.</output>الـ margin بيتحسب من التكلفة. صنف من غير تكلفة مش هيتحسب، والـ prompt هيقولك عليه ويسألك بدل ما يخمّن. ولو للصنف أكتر من تكلفة، هيستخدم آخر واحدة ويقولك، فقوله لو عايز غير كده.
الخصم ممكن يكون على الوحدة أو على السطر أو نسبة، والسعر ممكن يكون قبله أو بعده. لو جاوبت غلط، الربح هيطلع غلط. عشان كده الـ prompts بتسألك ومبتخمّنش.
الأرقام تحليل من الملفات اللي رفعتها، مش حكم نهائي. راجع كام صنف وكام عميل بنفسك على الملف الأصلي قبل ما تغيّر سعر أو تقلل خصم.
كل أسبوع ببعت prompts وأدوات AI بستخدمها فعلاً في شركاتي. ببلاش، ومن غير spam.
الفورم مش ظاهر؟ اشترك من هنا ↗