Wholesale and retail pricing

The same candle is $24 at your own stall, $12 to the shop on the high street and $10.50 to the one distributor who takes a pallet. A price list is a named sheet of prices, and once a client is on one, every quote, order and invoice for them charges the right price without anybody remembering to.

The two lists you already have

Every workspace starts with two:

• Retail — the default. What anyone with no list of their own pays.
• Wholesale — the trade sheet.

Find them under Items → Price lists. You can rename them, add as many more as you like (a distributor sheet, a trade sheet, a stockist who negotiated their own terms), and one of them is always the default.

A sheet nobody has filled in changes nothing. Wholesale arrives empty, so until it has prices on it — or a markup rule — a client put on Wholesale is charged your base prices, exactly as if they were on Retail. The client form says so next to the picker, with a link straight to the grid: a list marked no prices set is a decision that hasn't been made yet, not a decision that did nothing.

Filling a sheet in

The grid lists everything you sell down the side and what this list charges across. Type a price, press Save prices, and that is the sheet. Clearing a price takes the item off the list entirely.

Two more boxes sit beside the price, and they are what makes a trade sheet a trade sheet rather than just cheaper numbers:

• Minimum — the least a shop may order of that line. Six candles or none.
• Case pack — the multiple it is sold in. Six, twelve, eighteen; never seven.

Both are enforced when a document is written. Put three on a line that has a minimum of six and OrderDen says so — while you are typing, and again if you try to save — rather than letting a picking error out of the building.

A rule for the blanks

A list can carry a markup over cost: "50% over cost, rounded up to the nearest .50". Any item the sheet has no typed price for is then priced by the rule, so a new item is on the trade sheet the day you add it rather than the first time somebody notices it missing.

The cost the rule uses is whatever the item's cost source says it is — your recipe's answer for something you make, the weighted average for something you buy — so a sheet built from a rule moves when the cost of making the thing moves.

Fill from the rule writes the rule's answer onto every item at once. Prices you typed by hand are left alone unless you tick Recalculate prices I typed too.

Putting somebody on a list

• A client — the Price list picker on their record. A shop on the wholesale sheet gets trade prices on everything, and their card says so.

Which price wins

When a document line is priced, OrderDen works down this list and stops at the first answer:

1. The client's own price for that item — the one you negotiated and typed onto the item's Client prices.
2. The client's price list.
3. Your default list.
4. The item's own price, from the catalog.

The line records which one answered, so months later the order still says why it is priced as it is — and the margin panel can tell a trade price from a typed one.

Typing a price always wins. A price you enter yourself is kept exactly as typed and marked typed in; the lists advise, they never overrule somebody looking at the document. (A line left at zero is what asks the lists — so to give something away, use a 100% line discount rather than a zero price.)

Seeing every price at once

An item's page has an On each price list panel: what it sells for on every sheet you keep, and the margin each one leaves. $24 retail at 62% next to $12 trade at 25% is a decision, and it is one nobody can make from two numbers on different screens.

Importing a trade sheet

Wholesale pricing arrives as a spreadsheet more often than as anything else. Import → Price list prices takes one: a price list name, a SKU or item number, the price, and the minimum and case pack. The list has to exist first — a typo that quietly created "Wholsale" would be worse than being told to make it.

Wholesale against retail

Reports → Wholesale vs retail splits the period's money in two and compares them on margin rather than on price. You take half the money on a wholesale order and do a fraction of the work — no listing, no photography, no packing twelve parcels, no customer service — so the price alone never answers whether trade is worth doing. The margin, after the platform's cut on both sides, does.