ValueQuarry Pricing, profit, and payout tools

Calculator template

TikTok Shop Profit Template

Build a TikTok Shop-style profit calculator with price, quantity, cost, referral fee, shipping, and ads.

Review the inputs and formulas below, then open this template in the calculator builder to customize the field names, values, result styles, and notes.

Open this template in the calculator builder Browse all calculator templates

Inputs

What people fill out

  • Sale price

    Uses sale_price in formulas, starts as a currency field, and begins at 32.

  • Quantity

    Uses quantity in formulas, starts as a number field, and begins at 2.

  • Product cost

    Uses product_cost in formulas, starts as a currency field, and begins at 9.

  • Referral fee

    Uses referral_fee in formulas, starts as a percent field, and begins at 8.

  • Shipping cost

    Uses shipping_cost in formulas, starts as a currency field, and begins at 5.

  • Ad spend

    Uses ad_spend in formulas, starts as a currency field, and begins at 4.

Outputs

What the template calculates

  • Estimated payout

    Format currency

    Result style metric

    Formula (sale_price * quantity) - ((sale_price * quantity) * referral_fee)

    Payout after the referral fee is removed.

  • Order profit

    Format currency

    Result style primary

    Formula (sale_price * quantity) - (product_cost * quantity) - ((sale_price * quantity) * referral_fee) - shipping_cost - ad_spend

    Profit after product cost, referral fee, shipping, and ads.

  • Profit margin

    Format percent

    Result style breakdown

    Formula ((sale_price * quantity) - (product_cost * quantity) - ((sale_price * quantity) * referral_fee) - shipping_cost - ad_spend) / (sale_price * quantity)

    Profit margin on the gross order total.

Use cases

When this template helps

  • Estimate profit on a social-commerce order.
  • Include referral fees, shipping, and paid promotion.
  • Use the builder to adjust assumptions quickly during a launch.

Related

More ways to work with this math

FAQ

Quick answers

Short answers for the questions that usually come up first.

Can I edit this tiktok shop profit template?

Yes. Open the template in the builder, then change the labels, values, formulas, notes, or output display styles to fit your workflow.

Can I save a version after I change it?

Yes. Save it on this device, export JSON, or copy a share link after you make changes.

Can I use this as a starting point for a different calculator?

Yes. Templates are meant to be edited. Remove fields, add new ones, or swap formulas if you want a different custom calculator.