Cart

Skills

Each skill is one specific job to teach an AI staff member you already have in Solo Agent. A connection lets your staff work in an app you already use. Download Solo Agent

7 results in Sales & Revenue

Clear filters
  • Free trial

    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

    Skill

    99.000 ₫

  • Free trial

    OPCSales & Revenue

    Reconcile marketplace payouts

    Match the order file with the marketplace payout file to identify delivered orders with no payment yet, orders charged unusually high fees, and returned orders that do not reconcile. It is normal for marketplace payouts to be lower than revenue: marketplace fees, payment fees, shop-funded vouchers, and return shipping. The hard part is knowing, among hundreds of orders, which ones have not been paid, which ones were charged much higher fees than usual, and which returned orders were charged shipping in both directions. The Reconcile marketplace payouts skill handles exactly this: upload the order file and the reconciliation file from the same marketplace into the chat, and each order ID is matched. The result highlights only the orders that need review, with the amounts involved. What this skill does for you Matches each order between the order file and the reconciliation/income file from Shopee, TikTok Shop, or Lazada. Finds delivered orders with no payment yet, separating orders that are not yet due from overdue orders and showing how many days overdue they are. Flags orders charged unusually high fees compared with the shop's usual fees, identifies which fee increased the total, and gives possible reasons. Groups returned or canceled orders with unmatched payments: returned orders that were fully paid (and may be charged in a later period), and returned orders where the shop was still charged fees or shipping. Compares each marketplace transfer with the money received in the bank statement, if you provide one. Assign the task with one message "Please reconcile my September Shopee orders and check which delivered orders have no payment yet and which orders have unusually high fees." (attach the September order file, the Revenue file from 01/09 to 15/10, and the bank statement) This skill checks first: which marketplace each file belongs to, the date range, and whether every row has been read. If the reconciliation file is missing, it tells you how to download it from the seller center. If you do not know how many days payments usually take or what the usual fee level is, these figures are inferred from the shop's own data and clearly labeled "inferred from data." What you get back A chat summary: orders paid, unpaid, overdue, with unusual fees, returns needing review, and differences from the bank; with recommended next steps. An Excel file in the doi-soat folder containing Overview, Unpaid (oldest overdue first), Unusual Fees, Returns, Order Details, and Bank tabs if a bank statement is provided. The app asks before saving. Example: "Cutoff date: 15/10. 7 orders unpaid = 2,340,000đ, including 3 orders more than 5 days overdue. 4 orders have unusual fees, mainly due to affiliate marketing fees. Recommended action: open the marketplace's Finance page and check the 3 overdue orders." How this skill differs from a regular AI question "Unpaid" does not mean "money lost." The result says only "not found in the reconciliation file through the cutoff date." The cutoff date is the latest date in the marketplace file, not today, so it avoids false alarms. It does not apply an invented "standard" fee. The comparison level is either a figure you provide or one calculated from the shop's own matched orders. Small orders that differ by only a few thousand đồng because of a fixed per-order fee are not flagged. Totals are calculated by the app and checked again. The order groups must add up to the total number of orders, and the order amounts must add up to the reconciliation file total. If they do not, the result explains the difference and looks for the cause. Four types of money are kept separate: merchandise money, money recorded by the marketplace for the shop, money transferred out by the marketplace, and money received in the account. This is a good fit if You sell on Shopee, TikTok Shop, or Lazada and feel that payouts are "a bit short" but cannot identify which orders are involved. At the end of the month, you want to know how much money is still held by the marketplace. You have many returns and suspect you were charged shipping twice. You handle accounting for an online shop and need to reconcile marketplace payouts every month. You need a specific list of order IDs before opening a support request with the marketplace. What to prepare Required: the order file and the reconciliation/income file from the same marketplace (Shopee: Finance → Revenue; TikTok Shop: Finance → Settlements/Income; Lazada: Finance → Account Statement). The reconciliation file should cover a few weeks beyond the order period so payments have time to arrive. Helpful if available: a bank statement or withdrawal history; the shop's usual payment time and fee level. Outside this skill's scope It does not contact the marketplace or open support requests; it provides the order list, and you take action yourself. It does not edit the original files. It does not include customer names, phone numbers, addresses, or bank account numbers in the result. The result is for reference when checking payments, not an accounting ledger or tax/accounting advice → if you need a revenue ledger for reporting, use Household Business Revenue Ledger. It does not calculate profit or loss by product → use Shop Business Analysis. 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 routes each request to the right person with the relevant skill. Often used with: Shop Business Analysis · Household Business Revenue Ledger · Sales Performance Report

    New

    Skill

    99.000 ₫

  • Free trial

    OPCSales & Revenue

    Translate & summarize supplier pages (1688, Taobao, Alibaba)

    Paste 1688, Taobao, or Alibaba links to get a Vietnamese version covering tiered prices, minimum order quantities, designs, and questions to ask the supplier. Finding Chinese suppliers often starts with a dozen 1688 tabs open at once, translating each section with a translation tool, then copying prices into Zalo and sending them to yourself. Tiered price tables make it easy to mistake "from 2 pieces" for "from 200 pieces", while every page seems to say "sold directly from the factory". The Translate & summarize supplier pages skill reads Chinese and handles exactly this task: paste links to the suppliers you are considering and say what and how many units you plan to import. Each page is opened and translated, suppliers are compared side by side, with ready-made questions for you to ask before importing. What this skill does for you Translates the information you need to decide into Vietnamese: specifications, materials, colors and sizes, packaging, shipping location, shipping time, and returns. Reads the MOQ (minimum order quantity) and tiered quantity price table, even when the price table is in an image. Compares 2–3 suppliers at the exact quantity you plan to import: who is cheaper at that level, who lets you mix colors to reach the quantity, which page says it is a factory, and which is a reseller. Converts prices into Vietnamese đồng using the exchange rate you provide, clearly stating the rate used. Prepares 6–10 questions for the supplier, each in Vietnamese and Chinese. If you agree, the Chinese version is copied out ready for you to paste into the chat with the supplier. Marks information the page does not state so you can ask instead of guessing. Assign the task with just one message "Please compare these 3 canvas tote bag suppliers for me. I plan to import 300 pieces, with a logo printed, in beige and black. Exchange rate: 1 yuan = 3.650đ." (with 3 1688 links) The page is read in a browser within the app. If a page requires login or a drag-to-verify challenge, this skill does not try to bypass it. Instead, it asks you to log in yourself in the browser window and request the page to be read again, or send screenshots of the prices, designs, and specifications, or paste the text from the page into the chat. What you get A summary table right in the chat: one row per supplier with the minimum quantity, price at your planned quantity, shipping location, and notes, plus 3 points to ask about before importing. An Excel comparison file in the nguon-hang folder. The app asks before saving it. A bilingual list of questions, with the Chinese version copied out when you want it. Example: "Supplier B is cheapest at 300 pieces: ¥8,5 (≈ 31.025đ) per bag, but the page does not state the logo printing fee. Supplier A allows mixed colors to reach the minimum quantity. Ask both: how much extra does logo printing cost, and how many days does making a sample take?" How this skill differs from a regular AI question Separates what the page states from what has been verified. Phrases such as "工厂直销" (sold directly from the factory) or "品质保证" (quality guaranteed) are recorded as "the page says..." and are not treated as facts. Does not guess the exchange rate or estimate shipping costs to Vietnam. Results always remind you that the page price excludes shipping to Vietnam, taxes, and import fees. Compares at your exact quantity, rather than using the lowest price for a 5,000-piece tier that you will never reach. Warns about products printed with famous brands: risks of counterfeit goods, imitation goods, and intellectual property violations. This skill does not help find "1:1 replica goods". This is right for you if You are new to importing from 1688 and cannot read Chinese yet. You are choosing between several suppliers for the same product and want a fair comparison. You need to send questions to a supplier in Chinese but do not want to translate each sentence yourself. You import through a purchasing agent and want to understand the page yourself before confirming with them. What to prepare Required: a product page link (1688, Taobao, Tmall, Alibaba), or screenshots, or text pasted from the page. Helpful: what you plan to import, how many pieces, special requirements (logo printing, packaging), and the exchange rate you are using. Without an exchange rate, prices remain in yuan (or dollars for Alibaba). Outside this skill's scope It does not click buy, add to cart, message, or send a quote request to a supplier; it does not click any button on the page. It does not enter accounts, passwords, or verification codes for you. It does not confirm whether goods can be imported into Vietnam or what documents are needed; ask your import service provider or check current regulations. It does not calculate resale prices and profit or loss → use Calculate selling prices & promotions. It does not write product descriptions for listing → use Write multichannel content. 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 routes each request to the right person with the appropriate skill. Often used with: Calculate selling prices & promotions · Shop business analysis · Product launch plan

    New

    Skill

    99.000 ₫

  • Free trial

    OPCSales & Revenue

    Calculate Affiliate / KOC Commissions

    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

    New

    Skill

    99.000 ₫

  • Free trial

    OPCSales & Revenue

    Prepare quotations / wholesale quotations

    Send the customer's price list and requirements, and receive an accurate Word or PDF quotation, with discounts, VAT and the total written in words. Wholesale price lists come in all kinds of formats: retail, wholesale, agent and tiered-quantity columns. You need to match the right column in the quotation, multiply the right figures, subtract discounts, add VAT if applicable, then write the total in words. Being off by one zero is enough to lose a company customer’s trust. The Prepare quotations skill handles exactly this: drag your price list into the chat and note what the customer needs. It takes the correct prices from the table, calculates each line and prepares a quotation as polished as one from a company sales department. What this skill does for you Matches each item the customer asks about to exactly one line in the price list. If several lines have similar names, it asks you; if an item is not in the list, it enters [price: you fill in]. Selects the correct price column: by quantity tier when the table has one; if it is unclear whether the customer is retail, wholesale or an agent, it asks once. Calculates each line total, discount, delivery fee (only when you provide it), VAT (only when you issue a VAT invoice, using the tax rate you specify), and then the grand total. Checks the total: quotations with 6 or more product lines are also saved with a detailed Excel table so the app can add up the line-total column again. If there is a discrepancy, it recalculates instead of rounding to make it match. Writes the total in words and checks each group of three digits. Reads the customer's quotation request in Word or PDF format. Fills in delivery, payment and quotation-validity terms exactly as you state them. Assign the task with just one message "Quote for Hoa Sen Company Limited: 120 boxes of ginger tea, 20 sachets each; 60 boxes of lemongrass and lemon tea; deliver to Hanoi. Give 5% off orders over 10 million, prices exclude 8% VAT. 30% deposit, valid for 15 days." (attach the wholesale price list) If you have not attached a price list, this skill searches the working folder for files with names like "bang-gia" or "gia-si" and asks which file to use. If there is no file, it uses the prices you type in the message. What you receive A Word quotation (by default), PDF or both, in the bao-gia/ folder: quotation number by date, recipient, product table (quantity, unit price, discount, line total), grand total in figures and words, terms and preparer. Seller information (address, tax code and bank account number) comes from memory; if unavailable, it is left blank for you to fill in. The app asks before saving. In the chat: each line's calculations and a list of points you need to check before sending. Example of the final line: "Total: 12.312.000đ. In words: Twelve million three hundred twelve thousand dong." How this skill differs from a regular AI question It never makes up a number. Prices, discounts, delivery fees, delivery times, gifts and warranties are taken only from the price list or from you; if missing, it enters [...] and lists it in the review section. It never adds tax on its own. If VAT is not selected, the quotation has no tax line. The tax rate is never chosen automatically; if products have different tax rates, it asks you. It hides internal figures. Cost, purchase price, profit and private notes in the price list never appear in the quotation. It removes unused lines. If there is no discount or delivery fee, it removes that line entirely instead of showing "0đ", which looks unprofessional. This is a good fit if Company customers ask for prices on Tet or event gifts in large quantities. Agents or new shops ask for wholesale prices to stock products. You work in sales and need to quickly send company customers accurate quotations. Your price list has many columns and you often confuse wholesale and agent prices. You issue VAT invoices and need quotations to clearly state whether prices include tax. What to prepare Required: what items the customer needs and how many. Recommended: an Excel/CSV price list (if you do not have one, type the prices in the message), customer name, permitted discount, whether to issue a VAT invoice and the tax rate applied by your accountant, delivery terms, payment terms and validity period. Outside this skill's scope It does not send the quotation to the customer; you review and send it yourself. It does not edit the original price list or overwrite old quotations. It does not advise on tax rates; you or your accountant must confirm this figure. To offer a service with an introduction and scope of work, use Proposal chào dịch vụ. Use in Solo Agent After purchase, assign this skill to an existing AI staff member on your team, or create a new one to handle it. One AI staff member can have multiple skills; the assistant routes each request to the right person with the right skill. Often used with: Calculate selling prices & promotions · Proposal chào dịch vụ · Package & price services

    New

    Skill

    99.000 ₫

  • Free trial

    OPCSales & Revenue

    Sales performance report

    Combine ad, Fanpage and order files into a weekly/monthly report: how much you spent, how much you earned, and what to do next. At the end of the month, if you want to know how much of your revenue is going to ads, you have to open three or four places, filter dates, remove cancelled orders and add everything up by hand. It takes half a day, and you have to start over every month. If you do not, all you have is the feeling that "this month seems worse". The Sales performance report skill solves exactly this: drag your files into the chat and enter the reporting period. The data is filtered for the right dates, each part is added up, and you get one overall picture with a few recommended actions. What this skill does for you Automatically identifies each file as an ad, Fanpage or order file from a marketplace. If a type is missing, the report leaves out that section and says so clearly. Filters the right period and tells you directly when the data does not cover the full period, such as when the order file only goes up to the 20th. Counts valid orders and revenue for each channel, excluding cancelled orders, returned orders and duplicate rows; one order with multiple items still counts as one order. Calculates the two numbers worth checking every period: ad spend per order and what percentage of revenue goes to ads. Ranks the 3 best and 3 worst Fanpage posts by engagement rate based on the number of people who saw the post. Compares with the previous period: how many orders, how much money and what percentage increased or decreased. Suggests 3–5 actions, each based on a specific number in the report. Assign the task with one message "Make the October report, compared with September: 210 orders, 64 million VND in revenue, 9 million VND in ads." (attach the ad file, Fanpage post file and Shopee order file) If a file cannot be identified, or your handwritten order log does not clearly show which column contains the amount, you will be asked one question. If you previously asked it to remember the previous period's figures, you do not need to type them again. What you get back An Excel file in bao-cao/: Overview (this period, previous period, changes), Ads, Fanpage, Orders by channel, and Recommended actions. A one-page Word document (included by default): 5–7 key metrics, 3 positives, 3 things to fix, and 3 actions for the next period. Concise enough to print or send to your business partner. A summary in the chat. Excel, Word and chat use the same figures. The app asks before saving each file. Example: "October: 248 orders, 77.5 million VND (up 21% from September). Ad spend per order is 41,000đ, or 13% of revenue. The cancellation and return rate is 12%, above the 10% threshold: review the order confirmation process." What makes this skill different from a typical AI question Revenue is not profit. The report always states that revenue is the amount paid for goods after discounts, before marketplace fees, and is not profit. It does not claim credit for ad conversions. Cost per order is calculated across all orders, including orders not from ads. The report does not say "ads brought in X orders" when there is no way to verify that. It does not add up reach incorrectly. The total reach of the posts is not the number of unique people, because one person may see multiple posts; the report makes this clear. It remembers figures for the next comparison. After the report is complete, you are asked whether you want to save this period's total figures (without customer information) for automatic comparison next time. This is a good fit if You run ads, post on Fanpage and sell on marketplaces but do not yet have one shared report. You have a business partner who needs a one-page summary every month. You handle marketing for a store or brand and need a monthly report to send to your manager. You want to know whether ad spend has exceeded a safe level compared with revenue. You want last week's report on Monday morning: copy the new file into the work folder and schedule it with "Work schedule" in the app. What to prepare Required: the reporting period and at least one file: a Facebook ad report, post data exported from Meta Business Suite (Insights → Export), an order file from Shopee, TikTok Shop or Lazada, or a self-recorded order log. Better if available: the previous period's figures for comparison. Outside this skill's scope Customer names, phone numbers and addresses are not included in the report or chat. It does not send the report to anyone or edit the original files. It does not state profit or loss when you have not provided your profit margin → for actual profit, use Shop business analysis. For a detailed review of each ad creative, use Facebook ad report. Use in Solo Agent After purchase, assign this skill to a staff member already 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 relevant skill. Often used with: Facebook ad report · Shop business analysis · Monthly content plan

    New

    Skill

    99.000 ₫

  • Free trial

    OPCSales & Revenue

    Shop business analysis

    Send your order files and get a direct answer: how much you really made, which products are losing money, and what you should restock next week. At the end of the month, many shop owners still open three Excel files from Shopee, TikTok Shop, and their handwritten order log, then filter, add up, and compare everything by hand. They spend the whole evening and still cannot answer the most important question: which products are truly profitable, and which are losing money? The Business Analysis skill solves exactly this problem: drag your files into the chat and ask as if you were asking your own accountant. This skill reads the numbers and answers in plain language, with actions you can take right away. What this skill does for you Calculates real profit after marketplace fees, cost of goods, shipping paid by the shop, and advertising—not just total revenue. Shows which products are driving profit and which sell well but still lose money. Explains why sales went up or down: fewer orders, smaller orders, stockouts, or a specific product. Groups customers into new customers, returning customers, and customers who have not come back for a long time so you know whom to focus on. Checks whether your latest promotion was worthwhile: how many extra sales it brought and how much profit it cost. Detects unusual figures, such as a sudden spike in the cancellation rate on one day or an unexpected fee deduction. Suggests how much to restock for each product based on sales speed and delivery time; when needed, it can check competitor prices on public pages for comparison. Assign work with just one message "How much real profit did the shop make in August after marketplace fees and cost of goods? Which products are losing money?" (attach Shopee and TikTok Shop order files and the cost-of-goods table) Each file is reviewed carefully, including the date range it covers and what information is missing. If one missing detail would completely change the conclusion (for example, the cost of goods is not included), this skill asks just one short question and continues. What you get back A short answer right in the chat: conclusion first, figures second, and up to 3 recommended actions, with each action stating which number to check afterward to measure its effect. An Excel file when the result is long (by product, by customer, or restocking suggestions), saved to your work folder. The app asks for your permission before saving. Example: "In August, profit after selling expenses was about 18.4 million VND. Plain T-shirts sold the most but lost about 6,000đ per order because marketplace fees and vouchers overlapped. Recommended action: remove the 20k voucher for this product and track profit per order for 2 weeks." What makes this skill different from a regular AI question No mental math. The app calculates every sum in the file accurately, so subtotals always match the grand total. No confusion between types of money. Revenue, marketplace settlement, money received in the account, and profit are kept separate because sellers often misunderstand their own figures at this point. No making things up. If the cost of goods or marketplace fees are missing, it says so clearly, only calculates a trial figure based on numbers you approve, and labels it "trial calculation". Remembers things for you. For cost of goods, delivery time, and alert thresholds you provide once, this skill asks whether you want to save them so you do not have to enter them again next time. It's a good fit if You sell on multiple marketplaces and have never known exactly how much you make. You keep your own order records (Excel) and want to know which products are truly profitable. Sales are falling and you do not know why. You are about to restock and worry about overstocking slow products or running out of popular ones. You want a summary of the previous day every morning: schedule this task in the app's "Work Schedule". What to prepare Required: order files downloaded from the marketplace (Excel/CSV) or your own order log. For more reliable results: cost-of-goods table, marketplace settlement/earnings file, advertising spend, and inventory table. Outside this skill's scope It does not change prices, promotions, orders, or inventory on the marketplace; message customers; or place orders with suppliers. This skill only reads, calculates, explains, and recommends. It does not include customer names, phone numbers, or addresses in reports. Profit figures are estimates for operations, not accounting or tax figures → if you need a revenue ledger for tax reporting, use Sổ doanh thu hộ kinh doanh. For advertising-only analysis → use Báo cáo quảng cáo Facebook. Use in Solo Agent After purchasing, assign this skill to an existing AI staff member on your team, or create a new one to handle it. One AI staff member can have multiple skills; the assistant routes each request to the right person with the appropriate skill. Often used with: Đối soát tiền sàn trả về · Tính giá bán & khuyến mãi · Báo cáo hiệu quả bán hàng

    New

    Skill

    99.000 ₫