write the cost.
Users:
• Administrators
• Barbers
(identification by Telegram ID)
⸻
Bot functions:
1. Main menu (buttons):
• Add sale
• My statistics
• Bonus rules
• Product list
⸻
2. Add sale:
• User clicks “Add sale”
• Bot suggests selecting a product from the list (buttons or dropdown list)
• Bot records:
• Date and time
• Username (automatically by Telegram ID)
• Product name
• Quantity (default 1, can choose more)
• Record goes to the database (for example, Google Sheets or SQLite)
⸻
3. Bonus calculation:
Bonus is calculated based on the number of cosmetic sales per day:
• 1 sale — 20% of the margin
• 2 — 25%
• 3 — 30%
• 4 or more — 35%
• Minimum bonus: 30 UAH
• Maximum bonus: 125 UAH
Bonus formula:
(retail price - wholesale price) × %
Percentages are determined automatically based on the number of sales by this user for the current day.
⸻
4. Statistics:
• “My statistics” shows:
• How many products sold today
• How much bonus accrued
• How many sales for the month and total bonus
• Administrator (bot owner) can call full statistics for all users
⸻
5. Product list (can be embedded in the bot or pulled from Google Sheets):
Example:
• Morgans shampoo 250ml — retail: 500 UAH, wholesale: 255 UAH
• Luxina powder — retail: 950 UAH, wholesale: 577 UAH
(And so on — the list can be updated)
⸻
Additionally (if possible):
• Ability to export statistics (CSV or Google Sheets)
• Notification to the bot owner about new sales (optional)