Kuponaut

Codes Comparisons Guides Calculator About Contact Submit a coupon TR

Kuponaut › Blog

How to find your most profitable product with Julius AI (profit after fees and shipping, not just sales)

Most small sellers know their bestseller. Far fewer know which product actually leaves the most money after marketplace fees, payment fees, shipping and materials, because that number lives across several columns and nobody adds it up. Julius AI can do that addition in one question if the spreadsheet is prepared for it. This guide shows the columns to include, the exact wording that gets a usable answer, how to read the code Julius ran before you trust the chart, and what the answer does and does not tell you. It is the question behind our Kupo episode below: the mug Maya was about to discontinue was the one making the money.

By Fırat Papatya · Published October 21, 2026 · 6 min read

Affiliate disclosure: links to Julius AI in this article are partner links and KUPONAUT is a partner code; if you buy through them, Kuponaut may earn a commission at no extra cost to you. Prices were read on julius.ai/pricing on 21 October 2026 and can change.

Step 1: put the costs in the sheet, one row per order

Julius can only compare what is in the file. A sales export usually has the product name, quantity and selling price; the money that disappears afterwards is often missing. Before you upload, add a column for each cost that varies by product or order: the marketplace or platform fee, the payment processing fee, the shipping you paid (not what the buyer paid, unless you want that counted too), packaging, and the unit cost of materials or stock. If a cost is the same for every item, a single column with the same value in every row is fine; Julius will still subtract it.

Keep one row per order line, with one header row and short unique column names such as order_date, product, units, price, platform_fee, payment_fee, shipping_cost and unit_cost. Amounts should be plain numbers in one currency, without symbols typed into some cells and not others. Refunds and cancelled orders deserve their own column or a status flag, because leaving them in as normal sales inflates everything.

Julius accepts CSV and Excel files, along with JSON, Parquet and several other data formats, and its FAQ says you can refer to individual tabs of a workbook by name. Remove customer names, emails and addresses first; they are not needed for a profit question.

Step 2: ask one precise question, and ask for both numbers

Vague questions get vague charts. "Which product is most profitable?" leaves Julius to guess whether you mean profit per unit, total profit, or margin as a percentage, and whether shipping counts. Name the columns and the formula in plain English, for example: "For each product, calculate profit per unit as price minus platform_fee minus payment_fee minus shipping_cost minus unit_cost, then total profit as profit per unit times units. Show a table sorted by total profit, with units, revenue, profit per unit and margin percent, and a bar chart of total profit."

Asking for both profit per unit and total profit matters because they disagree more often than you would expect. A high-margin item that sells ten a month can lose to a thin-margin item that sells three hundred, or the other way round, and the decision you take (raise a price, drop a product, reorder stock) depends on which one you are looking at. Add a time window if the file spans a long period: "use orders from the last 90 days".

If the first answer is close but not right, reply in the same chat rather than starting again. Julius keeps the file and the previous steps, so "exclude refunded orders" or "treat shipping_charged as income" is enough to get a corrected table.

Step 3: open the code before you trust the chart

Julius answers by writing and running Python or R, then shows the result as text, a table or a chart. The code is the part worth reading even if you do not program. Check three things: that every cost column you listed appears in the subtraction, that units multiplies the per-unit profit (and that units is not being summed twice), and that the number of rows it reports matches your sheet after any filter you asked for. A summary sentence that says "the flamingo mug is your most profitable product" is only as good as the arithmetic underneath it, and the written summary can disagree with the numbers in the table.

A quick sanity check costs nothing: pick one product you know well and recompute its profit per unit by hand from one row. If Julius matches it, the formula is right for every row. If it does not, the usual culprits are a fee column stored as a percentage rather than an amount, or shipping that was already deducted from the price in your export.

The traps that make a bestseller look profitable

Shipping is the biggest one. If your export shows the buyer's shipping payment as revenue but your own carrier cost is not in the file, every product looks better than it is, and heavy items look best of all. Put both in, and tell Julius which is income and which is cost.

The second trap is percentage fees. Marketplaces usually take a percentage of the sale plus a fixed amount per order; if your sheet only has the percentage, ask Julius to compute the fee from the price rather than typing an average in. The third is small numbers: a product with four sales cannot be called your most profitable line, so ask for the units column to stay visible and ignore anything below a sensible count. And the fourth is time: a product that was profitable in a sale month can be a loss at full price, so compare like-for-like periods.

What to do with the answer

The useful outcomes are usually small. A bestseller with a thin margin is a candidate for a modest price rise or a cheaper shipping option rather than discontinuation. A quiet product with a high margin is a candidate for a better photo and a better listing before you make more of it. A product with negative profit per unit after shipping should either change its shipping rule or go. Save the table Julius produced, and run the same question again next month with the new export; the chat history keeps the wording, so the second run takes a minute.

What Julius AI costs, and the code

Julius has a free tier with a limited daily allowance. On the pricing page read on 21 October 2026, Plus is $20 per month with 2,000 credits a month, Pro is $45 per month with 5,000 credits, and Business is $450 per month; annual billing is shown as 20% cheaper, which puts Plus at $16 a month. Every plan listed includes 100 daily refresh credits and access to the frontier models named on the page. A single profit question on a small file uses a handful of credits, so the free tier is enough to test the workflow above before paying.

The partner code KUPONAUT takes 10% off every Julius plan; the code page explains where to enter it and what the discount applies to. The code is the one Kupo mentions in the episode.

The Kupo episode this guide comes from

Kupo at Midnight is Kuponaut's short series: one problem, one tool, one "aha" per episode. In episode 1, Maya runs a small ceramic mug brand at night, drops 400 rows of sales data into Julius and asks the question in step 2. The answer is the flamingo mug she had boxed up to discontinue. The video is an AI-generated story made with Google Veo 3.1, not a screen recording of Julius; the prices and the code in the end card are the ones above.

Kupo episode: Kupo in trouble

Kupo is Kuponaut’s AI-animated robot; this is a story, not a screen recording of the product. Code and prices as above. Shorts version

Related code pages

Links