Shop / Business / Finance / The Product Pricing Handbook

Finance · Nº 29

The Product Pricing Handbook

Cost, Markup, and Pricing for Every Sales Channel

You know every price on your shelf by heart. Do you know what each sale leaves you?

24 tools, a spreadsheet that does the math, and one coffee roaster followed from the cost of a single bag to a price for every channel, so you see which products and channels actually pay.

You get 24 tools to find the real cost of every product, turn cost into price without mixing up markup and margin, and set a price for each sales channel. Plus 13 templates and an 8-tab spreadsheet, filled in with the example.

1ready-made spreadsheet
13templates to adapt
24tools

A book explains the method. This handbook puts it to work: the tool, a worked example, and a spreadsheet with your numbers.

Secure checkout by Digistore24Money-back guaranteeLifetime access

One-time payment of $29.00. The order form shows the final amount, with any taxes for your country, before you pay.

Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.

14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.

Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.

Your prices came from the supplier invoice times two, a few years ago. The same price now goes out at the counter, on your website, on a marketplace, and to wholesale customers. Each channel takes its own cut: a commission here, free shipping there, a volume discount for the reseller. None of it shows up on the price tag. Sales look good. And when a supplier raises prices, you find out months later, when the margin is already gone.

THE SPREADSHEET

Product pricing spreadsheet

Use the completed example as a reference and enter your business data in the marked fields. Check the instructions and the calculations before you make a decision.

The Product Pricing Handbook · The spreadsheet on screen
The spreadsheet on screen
The Product Pricing Handbook · Simulation with the example data
Simulation with the example data

SOUND FAMILIAR?

Three situations this handbook solves

A new supplier invoice lands on your desk

The cost went up again. You enter the price of the next batch in the cost sheet as the replacement cost and recalculate the floor and target price. The price changes before the old stock runs out, not months later.

You're about to list on a marketplace

Before you copy your counter price, you add the commission, the per-sale fee, and shipping into the channel cost. You see what the listing price has to be to leave a margin, and whether the channel is worth it at all.

Someone suggests a big holiday promotion

Before you announce anything, you run the discount through the promotion tool. It tells you how many more units you'd have to sell just to break even. Then you decide whether the promotion pays or just keeps you busy.

INSIDE

What you'll find in each tool

Five parts, from the invoice to the dashboard. Find what each product really costs, down to the packaging. Turn that cost into a price with a markup that covers fees and profit. Set a different price for each channel you sell in. Check what the customer sees on the shelf. Then protect your margin with promotions that pay for themselves and a monthly dashboard. Every tool has a step by step, a worked example, and a short exercise.

The Product Pricing Handbook · The tool: the idea, where it comes from, and the diagram
The tool: the idea, where it comes from, and the diagram
The Product Pricing Handbook · The step-by-step and the hands-on exercise
The step-by-step and the hands-on exercise
The Product Pricing Handbook · Illustrative example with numbers
Illustrative example with numbers: Torrefação Paraibuna, a fictional specialty coffee roaster. Helena, the owner and head roaster, sets the prices. Diego runs the website, the marketplace, and wholesale. They find out the coffee pays the bills, the grinder loses money, and the marketplace sells a lot while leaving little behind.
The Product Pricing Handbook · The diagram in detail
The diagram in detail

WHAT YOU GET

Everything included in your purchase

  • The Product Pricing Handbook in PDF: 24 tools, each with a step by step, a worked example, and an exercise
  • The Product pricing spreadsheet in Excel and Google Sheets, with 8 tabs, from the cost sheet to the product mix, filled in with the example company
  • The Template kit: 13 ready-made templates, including a channel pricing policy, a wholesale price list, a promotion rule, and a price increase notice
  • 2 worksheets to fill in (product cost and channel pricing) and a 30-day plan, one week per stage
  • Access to your handbook on the Consylion platform
The Product Pricing Handbook · What lands in your library
What lands in your library
The Product Pricing Handbook · The final checklist
The final checklist

Full table of contents

The 24 tools, in the order you'll use them

Part 1 · Part 1 · What your product really costs

  1. 01
    Product cost worksheetRaw materials, loss, and packaging for each unit, gram by gram
  2. 02
    Landed cost of resale goodsWhat a product really costs once freight and damage are added to the invoice
  3. 03
    Fixed expenses as a percentage of salesHow much of every sale goes to rent and salaries before anything is left
  4. 04
    Replacement costPrice on what the next batch will cost, not the one already in stock

Part 2 · Part 2 · From cost to price

  1. 05
    Markup multiplierThe math that turns cost into a price that covers fees, expenses, and profit
  2. 06
    Markup is not marginWhy doubling the cost gives you a margin of half the price, not double
  3. 07
    Floor price and target priceThe cash floor, the break-even price, and the price that actually leaves a profit
  4. 08
    Pricing kits and bundlesDiscount the bundle without selling any piece of it below cost

Part 3 · Part 3 · A price for each channel

  1. 09
    Channel costEach channel's fees, commissions, shipping, and payment terms, rolled into one number
  2. 10
    Marketplace pricingBuild the commission and per-sale fee into every listing
  3. 11
    Free shippingWho really pays for shipping, and the minimum order that makes the math work
  4. 12
    Wholesale and reseller pricingA volume price list with a margin floor you don't go below
  5. 13
    Monthly subscriptionA subscriber discount paid for by more frequent purchases

Part 4 · Part 4 · The price the customer sees

  1. 14
    Market reference priceCompare competitors per unit of weight, with shipping included
  2. 15
    Acceptable price rangeFour questions to ask customers to find the price they'll accept
  3. 16
    Price endingsWhen the last digits on the tag matter, and when they don't
  4. 17
    Tiered product lineThree prices on the shelf, so the one in the middle sells
  5. 18
    Launch pricingStart high and come down, or start low and go up

Part 5 · Part 5 · Protecting your margin

  1. 19
    Promotions that pay for themselvesHow much more you need to sell so a discount doesn't turn into a loss
  2. 20
    Inventory turnover and marginThe product that sells through and the one that sits on the shelf
  3. 21
    ABC analysis of the product mixThe few products that bring in most of your margin
  4. 22
    Product price increasesPass it on, absorb it, or change the package, with clear notice to customers
  5. 23
    Marketplace price warsWhen to match, when to hold, and when to walk away
  6. 24
    Price and margin dashboard by channelOne page a month showing what each channel really leaves you

Who it's for

It's for you if

  • You make or resell products and set your own prices
  • You sell through more than one channel (counter, website, marketplace, wholesale, subscription) and charge the same price everywhere
  • You don't know how much each product leaves you after fees, shipping, and commissions
  • You've heard "markup" and "margin" used as if they were the same thing and want the math straight
  • You'd rather have a ready-made spreadsheet and a worked example than sit through a class

It's not for you if

  • You mainly sell services or hours of work. For that, see The Service Pricing Handbook
  • You want to build your company's cash flow and income statement. That's The Cash Flow and Profit Handbook
  • You need to know exactly what's charged on each sale and purchase in your country. That's your accountant's job
  • You want one magic multiplier for every product. This handbook makes you look at each product's real numbers

Frequently asked questions

I sell hundreds of products. Do I need a cost sheet for every one?

No. Start with the products that bring in most of your margin, which the ABC analysis points out for you. For the rest, you use the landed cost and a markup for each group of similar products.

Is it fair to charge a different price in each channel?

Yes, and in most cases you should, because each channel costs you something different. The handbook shows how to explain the difference to customers who compare, and why counter customers shouldn't pay for your marketplace fees.

A competitor sells for less than my cost. How is that possible?

They may buy better, waste less, sell below cost for a while, or just have the math wrong. The handbook has you check your own cost sheet and landed cost first, then decide whether to match, hold, or walk away.

Do I need to be good with numbers?

No. It's written for beginners, and every tool has a worked example with numbers. The spreadsheet does the markup, channel, and promotion math. You type into the input cells and the prices update on their own.

Does this work if I don't roast coffee?

Yes. The example is a coffee roaster, but every tool shows how it applies to services, retail, manufacturing and distribution, and independent professionals. You swap in your own invoices and channels.

How much time does this take?

About 2 hours and 24 minutes of reading, or 6 minutes per tool, plus the exercises. The 30-day plan goes one week per stage: real cost, markup and floors, price by channel, then shelf and dashboard.

What do I get, and in what formats?

Each handbook is a PDF of about 100 pages with 24 to 27 tools. Every tool has step-by-step instructions and a worked example. You also get the handbook's spreadsheet in Excel (.xlsx), which opens in Google Sheets too, with the example already filled in. The message, policy, and clause templates are in the Template Kit inside the PDF, ready to copy and adapt. Read it in the member area or download the files.

How do I know if it fits my business?

Each handbook's page shows the problem it solves, who it is for and who it is not for, the full table of contents, sample pages, and the company used in the examples. The examples come from small businesses in several industries, with illustrative numbers. If it is not a fit, you can ask for a full refund within 14 days of your purchase, as described in the Refund Policy.

What is the difference between a handbook, an area set, and the Series?

A handbook solves one problem. An area set brings together every handbook and spreadsheet in one of the 6 areas, for less than the price of 5 single handbooks. The Consylion Handbook Series brings together all 100 handbooks and 100 spreadsheets, for less than the price of 8 single handbooks, and includes the next handbooks in the Series. Products outside the Series, from Consylion Life or Consylion Business, have their own price. They are sold separately and are not part of an area set or the Series.

Do I need to read everything before I start?

No. Each tool works on its own. Open the table of contents, pick the tool for today's problem, and start there. You can also read it cover to cover.

Do I need to know Excel?

The basics are enough: open the file and fill in the marked fields. The formulas are already built, and the handbook's example is filled in for reference.

How do I pay, and when do I get access?

By card or bank transfer, as a one-time payment with no subscription. Once your payment is confirmed, you get access to the member area by email. Approved card payments are confirmed right away. Bank transfers are confirmed when the funds clear. If access does not arrive within 24 hours of confirmation, check your spam folder and write to team@consylion.org.

How long do I have access, and how can I use the files?

Access does not expire, and you can download the files for offline use. The license is individual. You may read the handbooks, print them for your own use, and fill in and adapt the spreadsheet and templates with your company's data. If you are a consultant, accountant, or manager, you may apply the tools with your clients and deliver the result of your work, not the files. You may not share, resell, or distribute the files or the access.

How do support and refunds work?

Support is by email at team@consylion.org, on business days, with a reply within 5 business days. It covers questions about access, files, and payment. It does not include consulting or advice on applying the material to your case. You can cancel within 14 days of your purchase, without giving a reason, and get the full amount back through the payment method you used. Send the request to the same email. The details are in the Refund Policy.

All 100 handbooks

CONSYLION HANDBOOK SERIES

The 6 departments of your business, for less than the price of 8 single handbooks.

This handbook solves today's problem. The Series solves the next one, and the one after that, with nothing more to pay.

  • 100 handbooks with 2,403 ready-made tools, to read on screen and download as PDFs
  • 100 spreadsheets for Excel and Google Sheets
  • 6 business areas
  • Lifetime access, unlocked once payment is confirmed
$2,900.00 if bought separately
$197.00
One-time payment · for less than the price of 8 single handbooks
See details

One-time payment of $197.00. The order form shows the final amount, with any taxes for your country, before you pay.

Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.

14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.

Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.

Finance · Nº 29

Find out which products are really paying the bills

Pick your five best sellers and the latest invoice for each. By the end of the book, each one has a real cost, a floor, and a price for every channel you sell in. What you do with the products that turn out to be losing money is up to you.

See all 100 handbooks · $197.00

Single handbook
$29.00
One-time payment
Secure checkout by Digistore24Money-back guaranteeLifetime access

One-time payment of $29.00. The order form shows the final amount, with any taxes for your country, before you pay.

Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.

14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.

Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.

All 100 handbooks

Handbook Series

6 departments, 100 handbooks, 100 spreadsheets

$197.00 $2,900.00 separately

Money-back guarantee · Secure payment

One-time payment of $197.00. The order form shows the final amount, with any taxes for your country, before you pay.

Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.

14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.

Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.