TL;DR:
The cheapest sticker price is often not the cheapest total. Add shipping, tax and fees.
Read the returns policy before you buy and write it into the comparison.
Put every option in one table with the same columns, and recompute the totals with a formula.
You need an office chair for a home desk and found three vendors selling a similar model. One has the lowest price on the page, another offers free shipping, and the third promises easy returns. Looking at three tabs, it is hard to say which is better. Putting them in one table, with the same columns, makes the answer much clearer.
What counts as the real price
The price on the product page is only the first line of the bill. Add shipping, tax, any handling or assembly fee, and the cost of a return if it does not work out. Some of those appear only at checkout, so go as far as the final review screen (without paying) to see them. Tax rules depend on where you live, so use the figure the checkout shows you rather than guessing.
Build the comparison table
Choose the options to compare: Pick products that meet your must-have requirements first, such as a height range or a warranty, so you compare like with like.
Make the columns: Vendor, item price, shipping, tax rate, total cost, return policy, delivery time, link and date checked.
Gather the numbers at checkout: Enter your real delivery address on each site and note the shipping and tax shown. Prices vary by address and sometimes by day.
Calculate the total: Use a formula, not mental arithmetic, so the totals update when a number changes.
Add the return terms: Write who pays return shipping, how many days you have and whether a restocking fee applies. Do this before you decide, not after.
Worked example: three vendors for office chairs
These numbers are invented to show the method. Say tax in your area is the item price × 0.08, and shipping and returns differ by vendor.
Vendor | Item price | Shipping | Tax | Total cost | Returns |
|---|---|---|---|---|---|
Vendor 1 | 180.00 | 25.00 | 14.40 | 219.40 | Free returns within 30 days |
Vendor 2 | 160.00 | 49.00 | 12.80 | 221.80 | You pay return shipping |
Vendor 3 | 199.00 | 0.00 | 15.92 | 214.92 | Free returns within 30 days |
In a spreadsheet, put the item price in B2, shipping in C2 and the tax rate in a labeled cell F1. The tax in D2 is =B2*$F$1 and the total in E2 is =B2+C2+D2. Fill both down.
Check each row by hand. Vendor 1: 180 × 0.08 = 14.40, and 180 + 25 + 14.40 = 219.40. Vendor 2: 160 × 0.08 = 12.80, and 160 + 49 + 12.80 = 221.80. Vendor 3: 199 × 0.08 = 15.92, and 199 + 0 + 15.92 = 214.92.
The lowest sticker price is Vendor 2 at 160.00, but it has the highest total at 221.80 because of shipping. Vendor 3 has the highest sticker price and the lowest total, 214.92, and its returns are free. The gap between the cheapest and most expensive total is 221.80 − 214.92 = 6.88. That small gap means returns matter more than price here: if the chair turns out to be uncomfortable, Vendor 2 would also cost you the return shipping, which you can add to its row as a risk.
Beyond the total
Once totals are close, break ties with things the table can hold: delivery date, warranty length, how long the vendor has been selling this item, and what other buyers say about problems rather than praise. Reading the worst reviews first tells you what goes wrong. Be careful with review counts and averages; look at what the complaints actually describe.
Reading a returns policy properly
A returns policy is part of the price. Look for four facts: how many days you have, whether the chair must be in its original packaging, who pays to send it back, and whether a restocking fee is deducted. Large items can be expensive to ship back, so a policy that says "free returns" is worth more than one that says "returns accepted".
Copy the exact wording into your table, with the link. If the policy is unclear, ask the vendor a direct question by chat or email and keep the reply. A written answer is easier to rely on later than a memory of what a page said.
Mistakes to avoid
Comparing sticker prices only.
Forgetting that shipping or tax can change with your address.
Missing a restocking fee or a short returns window.
Not recording the date. A sale price may be gone tomorrow.
Comparing different models without noting the differences.
Doing it faster
The same structure works for any purchase, and for comparing business tools as in competitive research in a spreadsheet. Be wary of any source of price information you cannot trace; the habits in finding reliable sources online apply to reviews too.
Note: Never enter payment details just to see a final price. Stop at the review screen, and go back if the site asks for a card before showing the total.
Frequently asked questions
Should I always buy the cheapest total?
Not always. If two totals are within a few dollars, choose on returns, warranty and delivery. The cheapest total with a hard return policy can cost more in the end.
Do I need a spreadsheet for three options?
A paper table works. A spreadsheet helps when you change a number, because the totals update on their own.
Get started
