How can I compare the total listed cost of two online shopping baskets?
Quick answer
For each basket, add the listed prices for the quantities you need, subtract any discount that applies, then add shipping and every disclosed fee or tax. Keep unknown charges separate rather than treating them as zero. Compare the resulting listed totals only when the baskets use matching quantities, currency, and delivery assumptions, and note what could change the final amount.
The question, the details, the next step.
I have two online baskets with similar items. What’s a fair way to compare what they’ll cost without missing shipping or fees?
Make a separate line for each basket’s item prices at the quantities you actually need, discounts, shipping, and any fee or tax shown. Add each basket’s amounts separately. Use matching quantities, currency, and delivery assumptions so the comparison is like for like.
Call the result a “listed total” if you have not confirmed every possible charge. If something is not shown or is unclear, write “unknown” rather than entering zero. That keeps the comparison useful without implying the displayed amount is guaranteed to be the final amount.
Can you show me the arithmetic, including how to handle an unclear charge?
Assume you want two units of one item and one unit of another, in the same currency and with comparable delivery.
Basket A: two items at 18 each = 36; one item at 12 = 12. The item subtotal is 48. Subtract a displayed discount of 5, then add shipping of 6 and a disclosed fee of 2: 48 − 5 + 6 + 2 = 51.
Basket B: two items at 20 each = 40; one item at 14 = 14. The item subtotal is 54. Subtract a displayed discount of 10 and add displayed shipping of 0: 54 − 10 + 0 = 44. Record other charges as “unknown” if they are not shown; don’t assume there are none.
On these assumptions, B’s displayed total is lower by 7 before unknown charges. That does not establish which basket will have the lower final amount if an unknown charge changes the comparison. These figures are placeholders for demonstrating the arithmetic.
The discounts and shipping details are different. How do I compare them fairly and keep track of what I still need to check?
Record the discount amount displayed for each basket and what it appears to apply to. Don’t assume an offer covers every item or that differently worded offers are equivalent. If its scope is unclear, mark it “needs confirmation” and calculate a version without it too. For example: “With displayed discount: 44; scope unclear; without discount: 54, before unknown charges.”
Keep a shown shipping amount in the calculation. If the other basket says shipping will be calculated later, record shipping as “unknown.” You can compare the known listed amounts, but don’t call that basket cheaper overall. If you can see an estimate using the same delivery option and destination, add it as an estimate and label it clearly.
Copy this for each basket:
Basket: [A or B] Currency and delivery option: [details] Items: [quantity] × [listed unit price] = [line total] Other items: [quantity × price = line total] Item subtotal: [sum of line totals] Discount: −[displayed amount; note what it applies to] Shipping: +[displayed amount, estimate, or unknown] Disclosed fees or taxes: +[list each amount] Other charges not shown or unclear: [unknown / needs confirmation] Listed total from known amounts: [subtotal − discount + disclosed additions]
Then state: “At matching quantities and delivery assumptions, [basket] has the lower listed total by [amount], before [unknown items].” If delivery options do not match, say so rather than presenting the totals as directly comparable.
What should I check before deciding which displayed total to rely on?
Confirm that each basket has the quantities you need, discounts are counted only where displayed as applying, and shipping and disclosed additions are recorded. Check the arithmetic, then review unknowns beside—not inside—the listed total. If an amount is unclear, ask the seller what it applies to or wait until it is shown. The sheet compares the information available; it cannot determine charges that have not been disclosed.
A practical checklist
Match the quantities and currency in both baskets.
Record each item’s quantity, listed price, and line total.
Subtract only displayed discounts, noting unclear conditions.
Add shipping and each disclosed fee or tax separately.
Mark missing or unclear charges as unknown, not zero.
State which basket has the lower listed total and what remains uncertain.
A few more useful answers
Should I include a discount that appears in an advertisement but not in the basket?
Keep it separate from the calculated basket total until it is displayed as applying to that basket. You can note it as an unconfirmed possible discount.
Can I compare totals when the delivery options are different?
You can compare the displayed amounts, but label the difference in delivery assumptions. For a like-for-like comparison, use matching delivery options or mark the comparison as incomplete.
What if the listed total and checkout amount do not match?
Update the sheet with the newly displayed amount and record what changed. If the difference is unclear, ask the seller to explain it rather than guessing.