PriceDesk

PriceDesk — case study

A pricing tool that starts from three questions. Product by product, it shows what volume and gross margin did when a price moved. Version of 21 November 2026.

The problem

Prices change every year, some up and some down. Few companies go back, product by product, to see whether each change paid off.

“Price up, volume down” is not the answer. A rise that loses some volume can still earn more gross margin. It depends on the margin the product started with.

Volume also moves for other reasons. When the whole range sells less, a product that fell after a price rise may have done no worse than the rest.

In eight years in the agricultural industry, six of them in global product management, I handled many pricing cases. I wrote down about twenty of them before building anything, and built the tool around a few.

The user

A commercial or pricing lead at a company with many products and many customers, its invoice lines in an export, and no pricing software.

They know their products and their customers. They are not trained in pricing theory, and they have a few minutes.

The test for every screen: someone who opens the site cold gets one useful answer in under two minutes, with nobody there to explain.

The second reader is a pricing expert, who asks “based on what?” of every figure.

What I built

Three questions, each opening one page with the answer on top:

Behind them: an Overview and nine more analyses, from returns and credit notes to prices across countries.

It runs on real public data: 1.04 million sales lines of a UK online giftware retailer, December 2009 to December 2011.

It also runs on your own file: CSV or Excel, five columns, read only in your browser. A sample file comes with five figures to find, so you can check that the tool read it correctly.

The Price & volume page: two boxes, Price up (151 products) and Price down (270 products), each with Volume up and Volume down; a filter, price moved by at least 5 %; gross margin fell on 81 products and held or rose on 70; below, the line that says what the figures are based on, and the chart of price change against volume change
The first question's page, on the real data. Under the five figures, a “Based on” line says what they cover and what they leave out.

Key choices

What I cut, and why

What the real data showed

December 2010 – November 2011 against the year before. € at a stated display rate of 1 £ = 1.15 €. Gross margin = net sales minus the cost of the goods, on simulated costs.

From sixteen pages to three questions

By November 2026 there was a lot in the tool. A visitor could not find their way through it alone, so I reworked how it opens.

“Open the tool” now opens the first answer instead of the whole Overview: about 7 seconds in the same kind of test. The full Overview still takes about 17 seconds, but the wait is no longer blank.

Limits

How it was built

The code was written with an AI assistant (Claude). I chose the questions, the rules and the thresholds, and decided what shipped.

Python prepared the public data once. JavaScript in the browser computes everything that moves with a filter or a threshold, and reads an uploaded file.

Each formula was checked on two or three cases, by hand or by a separate calculation, before it shipped.

Hosting runs on a free tier.

Built by Alexis De Schrevel. Hosted by Cloudflare, Inc., 101 Townsend St, San Francisco, CA 94107, USA.

Data: Chen, D. (2012), Online Retail II, UCI Machine Learning Repository, doi.org/10.24432/C5CG6D, licensed under CC BY 4.0; cleaned, aggregated and analysed by PriceDesk; the original company is not identified. Costs are simulated, and shown as such in the tool. € at 1 £ = 1.15 € (display only). A portfolio demo — not financial or professional advice.