Record availability alongside price when comparing book editions. An old price, an unavailable format, and a currently purchasable edition are different observations. Preserve the context, avoid treating a missing price as zero, and explain which entries support the current comparison instead of forcing every title into one average.
Define what the comparison is meant to show
Decide whether the research concerns current reader choices, historical pricing, or the positioning of similar editions. These questions can use some of the same titles but require different evidence. A price observed months earlier may be useful history without describing what a reader can buy today.
Record the intended marketplace, currency, format, and observation date. Identify the exact edition where the available information permits it. Keep the comparison question visible while collecting data so a missing offer does not cause the research to drift toward whatever number happens to be easiest to find.
Record absence as a condition rather than a number
When the intended edition has no visible purchasable offer in the inspected view, record what you actually observed. Distinguish an unavailable listing, a missing displayed price, and a page you could not inspect. These observations do not establish the same cause, and none should automatically become a zero in a price table.
Avoid inferring that a book has permanently ceased publication or that all readers see the same availability. Limit the record to the inspected place and time unless further evidence supports a broader statement. Preserve a reference to the observation where appropriate so later research can distinguish a changed condition from a data-entry mistake.

Keep other formats and offer conditions separate
A title may still show an ebook or another print edition when the format being compared is unavailable. Record that as a separate edition rather than substituting its price into the missing cell. A hardcover price does not become a paperback price simply because both appear under the same title.
Inspect the visible offer context as well. A used copy, a different seller, or a different condition may answer a different question from the current new-edition comparison. Include those observations only with clear labels and a reason relevant to the research. Do not attribute every displayed offer price to the author's chosen list price.
Decide how the entry participates in the analysis
For a comparison of currently available new editions, mark entries that do not meet the defined conditions as outside that calculation. Keep them in the research record with their context rather than deleting them silently. If historical positioning is relevant, analyze it separately using the dates and conditions that belong to those observations.
State the number and type of comparable observations remaining. A small or uneven set may support only a limited conclusion. Do not improve the apparent sample size by blending unrelated formats or old prices without explanation. The purpose is an interpretable comparison, not a larger spreadsheet whose rows no longer answer the same question.

Investigate exceptions without inventing explanations
If an unavailable edition is central to the intended comparison, decide what additional observation would help: another dated check, a clearly identified alternate edition, or an appropriate primary record. Keep the investigation proportional to the decision. A minor contextual title may not justify extensive reconstruction of its pricing history.
Record what remains unknown. Do not explain an unusually high offer as scarcity, author strategy, or proven demand without evidence. Likewise, absence from one inspected view does not establish that readers rejected the book. Separate observed price and availability from theories about why they occurred.
Use the findings to inform your own decision carefully
Summarize the current comparable set, excluded conditions, historical context, and important gaps. Compare that information with the actual reader task and production economics of your planned edition. Other books' prices provide context, not a guarantee that matching them will produce similar sales or contribution.
Preserve the research date and edition identifiers with the pricing decision. Refresh material observations when they become stale or when the planned book changes. The final comparison should show what was available to observe and what could reasonably be concluded, without hiding unavailable editions inside a misleading average.
Frequently asked questions
Clear answers for this publishing decision.
Should an unavailable edition be entered as zero?
No. Record the observed availability condition separately. Zero would misrepresent missing or unavailable pricing as an actual price.
Can I substitute the ebook price when the paperback is unavailable?
Keep it as a separate format observation. Do not place it in a paperback comparison without explicitly changing the question and labeling the difference.
Does a high third-party offer show the author’s chosen price?
Not by itself. Preserve seller, condition, edition, and observation context, and avoid inferring the author’s pricing decision from an unrelated offer.
Should unavailable titles be deleted from the research?
Retain their records and explain whether they are excluded from the current calculation or used only as dated historical context.
What does this book cost to print and produce, and what should the list price be?
Printing cost follows from the trim, ink, and page count, the list price sets the royalty after that cost, and the production budget should be estimated before generation starts, so compare these numbers before you commit to a format or a plan.
See what a book project costs in credits