Product details
- Type:
- Skill
- Category:
- Sales & Revenue
- Seller:
- OPC
- Listed on:
Product description
Send your order file, affiliate code list and commission rules, and receive a payout table for each person, orders on hold and orders that need your decision.
Commission sounds simple: 10% of sales. But there are cancelled orders, customers who return items after you have paid, and people who reach 30 million and move up to 12%... Every mistake means upsetting an affiliate or losing money for no reason. The Calculate Affiliate / KOC Commissions skill handles exactly this: upload your order file and affiliate list in the chat, then write your commission rules in your own words. The rules are applied to each order, while any uncertain orders are set aside for your decision.
What this skill does for you
- Assigns each order to the right affiliate using a referral code, unique discount code or unique link, without distinguishing uppercase and lowercase; multiple codes belonging to one person are grouped together.
- Puts each order into one group: eligible, on hold (the customer’s return period has not ended), excluded (cancelled, returned or not yet fully delivered), or needs review.
- Applies your exact rule type: fixed %, product-specific %, fixed amount per order, sales-based tiers or extra bonuses.
- Calculates the amount to pay = this period’s commission + previous balance − deductions for returned orders after payment. Amounts below the minimum are carried forward to the next period.
- Separates questionable orders: unknown codes, one order matching two people, orders before the affiliate’s start date or signs of fake orders. The result only lists the numbers; you decide.
- Excludes orders for which the platform has already paid commission through Shopee or TikTok Shop’s affiliate programs, so you do not pay twice.
Assign the task with one message
"Calculate affiliate commissions for September. 10% of item value excluding shipping; from 30 million/month, use 12% for the whole month; exclude cancelled and returned orders; hold orders for 7 days after delivery; amounts under 200,000đ carry forward to the next month." (attach Shopee orders, Facebook orders and the affiliate list)
If a rule is unclear in a way that changes the result—for example, whether the 12% tier applies to all sales or only the amount above the threshold—you receive one combined question with a default interpretation, so you only need to reply "correct".
What you get back
- An Excel file in
hoa-hong/, with 5 sheets: Overview, Payout table (one row per affiliate, from order count to this period’s payout and carried-forward amount), Order details, Needs review (with a column for your decision), and Applied rules. The app asks before saving.
- A chat summary by affiliate code: total commission, amount to pay now, amount carried forward and orders waiting for your review. The payout table is clear enough to send to each affiliate for checking.
Example: "Affiliate 02 – 38 eligible orders, 31,400,000đ in item value, reached the 12% tier → 3,768,000đ. 4 orders delivered from 24/9 have not completed the 7-day hold period and will move to October."
What makes this skill different from a typical AI question
- Uses only your rules. Rates, tiers, hold periods and minimum amounts are never made up; any default interpretation is marked "please confirm".
- Never assigns an order to someone based on guesswork. Orders without a matching code, even if a note mentions a similar name, go into "Needs review".
- Calculates every line correctly. Each row in a Shopee file is one product; item value is taken from the row, without repeatedly adding the order total, and order count is based on order codes.
- Checks twice. The total value of all order groups must equal the total value of orders with codes; total commission by person must equal the total by order.
Good for you if
- You have from a few to a few dozen affiliates selling with unique discount codes.
- You pay KOCs a different percentage for each product, such as 15% for lipstick and 8% for moisturizer.
- You sell courses or services through referrers and have an order file containing each person’s referral code.
- Affiliates often question their payout and you need order-level details to check.
- You sell both on platforms and through Facebook or your website, and worry about paying twice for platform commissions already deducted.
What to prepare
- Required: an order file with a discount code, referral code or source column; an affiliate list with each person’s code (file or quick text entry); and your commission rules.
- Helpful: the calculation period, previous balance or adjustments, and a reconciliation file or platform affiliate report.
Outside this skill’s scope
- No money transfers and no messages to affiliates; you handle those yourself.
- Customer names, phone numbers and addresses are not put in the file or chat; affiliate account numbers stay only in the file.
- It does not determine income tax matters when paying commissions; you are reminded to ask a tax agent, and a withholding column is added only if you provide the withholding rate.
- Finding, selecting, messaging KOCs and tracking collaborations → use Work with KOC/KOL; checking money paid back by platforms → use Reconcile Platform Payouts.
Use in Solo Agent
After purchase, assign this skill to an existing staff member on your team, or create a new staff member to handle it. One staff member can have multiple skills; the assistant sends each request to the right person with the right skill.
Often used with: Work with KOC/KOL · Reconcile Platform Payouts
Reviews
New product
No one has reviewed this product yet. Buy it and be the first to share your experience.
No reviews yet.
Related products
More in Sales & Revenue
OPCSales & Revenue
Pancake POS shop operations AI staff
Grace has 7 skills on your Pancake POS: sales reports, reviewing orders needing action, creating orders from customer messages, checking inventory and suggesting restocking, customer care, creating promotions and discount codes, updating products and prices. Every data creation or edit asks you first. Pancake POS keeps all orders, inventory, and customers of your shop. The numbers are there, but each day you still have to filter orders yourself, count inventory yourself, and type each order from customer messages yourself. This staff member is Grace, shop operations AI staff, with 7 skills. Grace works directly on your Pancake POS, through official Pancake connection. You give tasks in plain language, Grace answers with your shop's real data. Grace's 7 skills SkillWhat Grace does Sales reportsRevenue, number of orders, average order value, returned orders, best-selling products, order sources, sales staff; compare to previous period. Set goals so Grace reports automatically every morning Review pending ordersOrders waiting long for confirmation, orders awaiting stock, confirmed but not shipped, failed or late deliveries, returns in progress; sorted by urgency with suggested actions Create orders from customer messagesPaste messages or screenshots of chats: Grace extracts name, phone, address, finds correct size and color in stock, calculates shipping and COD fee, reads back, then creates order when you approve Inventory and restockingItems running low based on 14-day sales speed, slow-moving stock, lots near expiry; suggests restock quantities by supplier and creates purchase orders when you approve Customer careCheck a customer's purchase history, points, membership tier, balance; make lists of customers who haven't returned, big spenders, those about to level up; draft messages Promotions and discount codesCreate discount codes, product-based discount programs, toggle running promotions; alert when discounts may cause loss Products and pricesChange price of a product or batch, add new variants with sizes and colors, hide discontinued items; always show you old and new prices before changing Assign tasks with just one message "Grace, please give me yesterday's sales report." "Are there any orders not yet processed or delivery failed?" "Create an order for this customer: Lily, 0912 345 678, 45 Trần Duy Hưng, Cầu Giấy, Hà Nội, white linen dress size M." "What do we need to restock this week?" "Create 100 codes for 50,000 đ off orders from 400,000 đ, valid until Sunday." "Which customers haven't come back for a while? Help me draft a message." Grace does, you approve Grace reads data and reports on her own. Every time she creates an order, updates prices, creates purchase orders, or discount codes, the app shows clearly what will change for your approval. Auto calls to customers are off by default. What makes Grace different Real data. Every number comes from your shop's Pancake POS, no estimates. If a number isn't available, Grace says so. Orders without variant mistakes. Grace finds the right size, color in stock, and returning customers before creating an order; if info is missing, she asks, never guesses. No order missed. Stuck orders and late deliveries are collected every morning with suggested actions. Evidence-based restocking. Restock suggestions based on actual sales speed, not gut feeling. Right for you if Your shop manages orders and inventory on Pancake POS. You sell via Facebook, TikTok Shop, Shopee, or in-store and finalize orders through messages daily. You want revenue, pending orders list, and restock needs ready each morning. Preparation needed Solo Agent app on your computer. Pancake POS account (pos.pancake.vn). API key created in Pancake POS: Account → API Key → Create. It's best to create the key from an account with appropriate permissions: Grace can only do what the key allows. After receiving Grace, paste the key into the "Enter key" field in the setup box. You can also do it later: Settings → "Connected apps" → Pancake POS. What Grace does not do Does not create or edit orders, prices, inventory, or promotions without your approval. Does not send messages to customers: care messages are sent by you. Does not hand over orders to shipping carriers unless you request. Does not include customer phone numbers or addresses in reports unless you ask. Use in Solo Agent After purchase, Grace joins your team with all 7 skills above, along with a greeting and daily morning report goal you can enable with one button. You can teach Grace additional skills or create new staff; the assistant routes each request to the right person. Goes well with: Fanpage care AI staff · Done.vn ad reporting AI staff · Customer care message sequence
New
Staff member · 7 skills399.000 ₫
OPCSales & Revenue
B2B Sales Agent
Jack has 6 skills: target customer persona and list of potential companies, first call and message scripts, needs discovery, objection handling with roleplay, post-quote follow-up sequence, and weekly sales funnel review. All outreach is through legal channels, clearly stating how the contact was obtained and recording the customer's consent. Selling to businesses is very different from retail: one contract goes through multiple approvers, takes weeks to months, and often fails at the follow-up stage. The common way to find customers is buying phone number lists and cold-calling—ineffective and often illegal. This staff member is Jack, B2B salesperson, with 6 skills that follow each stage of the funnel, tailored for selling in Vietnam (calls, Zalo, email, in-person meetings, invoices and receivables). Jack only contacts through six legal channels, logs where the customer came from and which channels they agreed to receive messages. Jack drafts, you call and send yourself. Jack's 6 skills SkillWhat Jack does Target customer personaPersona with exclusion criteria, companies with public buying signals (hiring, opening branches, winning bids), source and date for each piece of information, tiered A/B/C, legal contact channels; saves to Excel First call and message scriptsSix-part call script including how to get past the receptionist, Zalo messages under 80 words, email under 150 words, referral requests; first line clearly states who is calling and where the contact info came from Needs discoveryQuestion set and decision-maker map before the meeting; after the meeting: minutes, quantify the value gap in the customer's numbers, score opportunity on 8 criteria, send summary message to customer Objection handlingFour-step replies for "too expensive", "let me think about it", "I already have a supplier", "boss hasn't approved"; custom replies for your product; roleplay a difficult customer and score each answer Follow-up sequence5–7 contacts in 14–21 days after meeting or quote, each with new information and a pre-drafted message, avoid holidays, include a closing message; re-engage cold opportunities; saves to Excel Sales funnel reviewReads Excel or exports from Getfly, Base, MISA AMIS CRM, Bitrix24, HubSpot; stalled opportunities, no next step, overdue; forecast three levels against target; each opportunity gets one task with a deadline Assign tasks with just one message "My company sells kitchen and cleaning supplies to restaurants and hotels in Đà Nẵng. Help me create a list of 30 companies to contact this month." "Draft a Zalo message for Mr. Sam, the hotel manager I met at the trade fair on Oct 22. He gave me his business card and agreed to receive messages." "Tomorrow afternoon I'm meeting the director of a spa chain to pitch a booking software. Help me prepare a set of questions." "The school's accountant said the quote is too expensive. How should I reply? Then roleplay as the customer so I can practice." "Here's the export from Getfly this month. Review my funnel and tell me if I can hit the target of 800 million." What makes Jack different Legal outreach from the first message. Six legal channels: customer reaches out themselves, existing or past customer, referred person who consented, person met at a trade fair who gave their business card, public business channels, customer who received a quote. Call times, message times, daily call volume, and stopping when a customer refuses comply with Decree 91/2020/NĐ-CP; no buying or collecting personal data under the Personal Data Protection Law, effective from Jan 1, 2026. Records consent. The funnel file has a Source column and a Consent column (channel and date, or "Refused" with date). Once a customer refuses, Jack no longer drafts sales messages for them. Sell with value, not pressure. No fake scarcity, no fake deadlines, no badmouthing competitors. Discounts come with conditions (volume, early payment). Reads the funnel you already have. No CRM switch needed; Jack flags missing data before calculating and forecasts at three levels with assumptions. Monday target. Every Monday at 08:00, a maximum of 15 opportunities to contact, each with a pre-drafted message on the channel the customer agreed to. On first use, Jack creates a sample file kinh-doanh/pheu-ban-hang.xlsx. Works with other office staff. Jack shares file names and column names with Helen (internal accountant), Kirk (procurement and warehouse), Hannah (admin – HR) and Ann (executive assistant); even without them, Jack still gets the job done. Good for you if You're an owner or salesperson of a small company, distributor, or dealer selling to restaurants, hotels, schools, offices. You provide business services (software, marketing, accounting, maintenance, training) and each contract requires several meetings to close. You're a consultant or broker and need to track many opportunities at once without missing any. You manage a small sales team, need data for meetings, and want the team to practice handling objections. Setup required The latest version of the Solo Agent app on your computer. Information about your work: what you sell, contract value, best current customers; include customer list, price list, CRM export if available. To receive weekly tasks: enable Jack's suggested targets after setup and leave the app running at 08:00 on Monday, either window open or minimized to system tray. Each task Jack performs uses AI credits from your account, or your own AI key entered in Settings; when using credits, each web search costs an additional credit. Jack does not Does not make calls or send Zalo, email, or messages; Jack drafts, you send. Does not find or guess personal phone numbers, emails, or Zalo IDs; does not collect numbers from groups or comments; does not buy "customer data" or send bulk messages. Does not suggest money, gifts, or "commission" to the buyer's staff; instead offers a discount to the buying business, recorded in the contract and invoice. Does not draft detailed quotes or service proposals; those are the tasks of Quote creator and Service proposal. Does not evaluate salaries, bonuses, or discipline sales staff. Rules reviewed through Oct 30, 2026; regulations on calls and messages are under revision, so Jack checks official sources when needed and notes when verification is pending. Knowledge sources Methodology adapted from agency-agents (github.com/msitarzewski/agency-agents, MIT license), rewritten for B2B sales in Vietnam: Zalo, phone calls, in-person meetings, and customer contact regulations. Using in Solo Agent After purchase, Jack joins your team with all 6 skills, plus a welcome message and a Monday funnel review target that you can enable with one click. You can teach Jack additional skills, or create new staff; the assistant routes each request to the right person. Goes well with: Quote creator · Service proposal · Executive assistant
New
Staff member · 6 skills399.000 ₫
OPCSales & Revenue
Tự Động Sale Automatic Lead-Finding Staff
Khôi has 5 skills in your Tự Động Sale: reporting new leads from Facebook groups, updating the CRM, creating lead-finding topics, adjusting filter criteria, and preparing draft campaigns. Khôi asks before making any changes. Tự Động Sale reads posts in the Facebook groups and pages you follow, then filters out people who are looking for something: a service provider, a rental home, a quote, or advice. There may be many leads, but opening the app to review them, deciding whom to prioritize, recording each call, and adjusting criteria when the filter is wrong still takes time. This AI staff member is Khôi, your lead-finding staff member, with 5 skills. Khôi works directly in your Tự Động Sale account through Tự Động Sale's official connection gateway. Ask in everyday language, and Khôi replies with real data from your account. Khôi's 5 skills SkillWhat Khôi does Report new leadsNew leads within the date range you ask for, tasks waiting for you, leads overdue for follow-up, and which topics bring in the most leads; sorts who you should contact first; exports to Excel when needed. Schedule it so Khôi reports automatically each morning Update leadsTell Khôi about a call, and Khôi changes the status, adds labels and notes, and records the call under the right lead in the CRM Create lead-finding topicsAsk who and where you are looking for; write group-selection and post-filtering criteria; add the Facebook groups you provide; turn on a collection schedule or run one round immediately; monitor post comments Adjust filtering criteriaReview filtered and skipped posts, point out why they were filtered incorrectly, mark what is right or wrong so Tự Động Sale can learn again, and adjust the criteria to find better-matching leads Prepare draft campaignsDraft replies to posts from people who need something, messages for the leads you choose, and posts for groups; everything stays as a draft for your approval Assign tasks with just one message "Khôi, check whether there have been any new leads since yesterday and who I should call first." "I called Thu Hà. The customer needs 2 machines repaired and scheduled a site survey for 9 a.m. Friday." "Please create a topic to find people looking to rent an apartment in Cầu Giấy. Here are 10 groups I often read." "Lately it's all sellers joining in. Please review the filtering criteria for me." "Draft a message to check in with the 10 newest leads from the air-conditioner repair topic." Khôi drafts, you approve Tự Động Sale does not let the AI assistant automatically publish posts, comment, or send messages. Khôi only creates drafts; you open the Tự Động Sale app, review them, and click to run them yourself. Before each CRM update, topic creation, or collection activation, Solo Agent shows a permission box clearly stating what will be done. What makes Khôi different Real data. Leads, match scores, and plan limits all come from your Tự Động Sale account, not estimates. Knows who to call first. Khôi ranks leads by urgency and match score instead of giving you one long list. Your CRM stays complete. Just tell Khôi what happened in your own words, and Khôi records it under the right lead with the right status. More accurate filtering over time. Khôi reviews incorrectly filtered posts and adjusts the criteria to find the right people more often. Sign in once, no key needed. Click "Sign in to Tự Động Sale" and grant permission—that's all. It's right for you if You find leads in Facebook groups for home services, brokerage, repairs, courses, recruitment, or online sales. You already use Tự Động Sale and want to spend less time reviewing, rating, and taking notes every day. You want a ready-made list of leads to call each morning. What to prepare The Solo Agent app on your computer. A Tự Động Sale account (tudongsale.com), and the Tự Động Sale app running on your computer with your Facebook account to collect posts. Limits depend on your Tự Động Sale plan. After receiving Khôi, click "Sign in to Tự Động Sale" in the setup box, sign in, check both "Edit data" and "Control computer", then click "Allow". You can also do this later: Settings → "Connected apps" → Tự Động Sale. What Khôi does not do Does not automatically publish posts, comment, send messages, or run campaigns. You do these things in Tự Động Sale. Does not turn on automatic commenting or automatic messaging for topics. Does not read conversations between you and leads. Does not show a lead's phone number or email when you have not asked about that lead. Use in Solo Agent After purchase, Khôi joins your team with all 5 skills above and works on the Tự Động Sale account you connected. You can teach Khôi other skills or create more AI staff; the assistant routes each request to the right person. Often used with: Customer care message sequences (Zalo, email, SMS) · Prepare quotes / wholesale quotes · Fanpage customer care staff
New
Staff member · 5 skills399.000 ₫
OPCSales & Revenue
Sổ doanh thu hộ kinh doanh
Combine year-round orders from marketplaces and handwritten sales records into a revenue ledger for reference, so you know whether you are nearing the VND 1 billion threshold. Online business households need to know their revenue for the whole year, by month and by channel. But the figures are scattered across Shopee, TikTok Shop and Lazada files, as well as handwritten Facebook and Zalo order records, with different columns and date formats in each file. Adding them manually can easily miss a month or include cancelled orders. The Sổ doanh thu hộ kinh doanh skill handles exactly this: drag your channel files into the chat, tell it the period for the ledger, and receive a revenue ledger showing the source of every figure, so you or your tax agent can review it before use. From the start, the result clearly states that this ledger is for reference only and is not tax advice. What this skill does for you Combines exported files from Shopee, TikTok Shop and Lazada with your handwritten sales records into a revenue ledger using the S1a-HKD template, with the household name, address and tax code you provide at the top. Adds totals by month, quarter and channel; monthly totals match channel totals and the total for the whole period. Calculates the cumulative amount against the VND 1 billion annual threshold: how much remains, or the month in which you exceeded it. Records marketplace tax withheld separately by month and channel when the marketplace reconciliation file includes this column. Lists months with missing files for each channel and points to check before reporting revenue to the tax authority. Assign the task with one message "Prepare a revenue ledger for the first 9 months of 2026 and check whether I’m nearing VND 1 billion." (Attach the monthly Shopee order files, the Q1 TikTok Shop file and the Facebook sales record.) Each file is checked first: which channel it belongs to and the dates it covers. If a month is missing, the available data is still processed, the missing month is clearly marked "missing", and you are reminded to upload it. If one file combines multiple months and cannot be accurately separated, you are asked to export it again by month instead of using estimates. What you receive A chat summary: recorded revenue, order count, the date type used, breakdown by channel, cumulative amount against the threshold, marketplace tax withheld, missing months and up to 3 points for you to check. An Excel file in the so-sach folder: a ledger page using the template, summary tables by month, quarter and channel, and a "Needs checking" page. The application asks for your confirmation before saving. Example: "Recorded revenue from 01/01 to 30/09: VND 742,600,000, based on successful delivery dates. Amount remaining before the VND 1 billion threshold: VND 257,400,000. Missing: TikTok Shop for June." What makes this skill different from a regular AI question Recorded revenue does not deduct costs. Marketplace fees, shipping paid by you and advertising are costs; cancelled orders are excluded and returned goods are deducted; delivered orders are still counted even if the marketplace has not paid you yet. One date type for the entire ledger. Successful delivery date is preferred; if unavailable, the order date is used and clearly noted in the ledger. If you agree, this choice is remembered so next year's ledger follows the same approach. Only cites rules that have been checked. This skill is based on notes from documents read directly, such as Decree 68/2026/NĐ-CP, amended by Decree 141/2026/NĐ-CP, with the date checked. Questions outside that scope are answered directly: "ask the tax authority or a tax agent". Does not fill missing months with averages. Marketplace-funded subsidies whose calculation method is unclear are kept in a separate column, not added to revenue, and listed under "Needs checking". This is a good fit if You are a business household or individual selling online, on multiple marketplaces and outside marketplaces. You have a physical store as well as online sales and want to combine the revenue into one ledger. You want the ledger ready before meeting your tax agent at year-end. During the year, you want to know whether you are nearing the VND 1 billion threshold. You want to know how much tax the marketplaces have withheld from you. What to prepare Required: the ledger period and order files from each channel; ideally, export each marketplace by month. Helpful if available: handwritten sales records, marketplace reconciliation/income files (to get the tax withheld), household details for the ledger header, and monthly revenue from sales not included in the files (in-store and wholesale sales). Outside this skill's scope For reference only, not tax or accounting advice. You or your tax agent must check the figures and ledger template before use; regulations may have changed. It does not calculate the tax payable or confirm that you are "entitled to a tax refund" or "not required to file". If revenue exceeds VND 1 billion, you are reminded to switch to the appropriate ledger template and meet a tax agent promptly. It does not submit filings or log in to the tax website for you; it does not include customers' names, phone numbers or addresses in the ledger. It does not calculate profit and loss → use Phân tích kinh doanh shop; to check whether a marketplace has underpaid you → use Đối soát tiền sàn trả về. Use in Solo Agent After purchasing, assign this skill to an existing staff member on your team, or create a new staff member to handle it. One staff member can have multiple skills; the assistant sends each request to the right person with the right skill. Often used with: Đối soát tiền sàn trả về · Phân tích kinh doanh shop · Báo cáo hiệu quả bán hàng
New
Skill99.000 ₫