Why your spreadsheet price differs from the selected item
A saved ¥120 price and a ¥145 selected option may describe different choices, not an unexplained fee. Put the sheet row beside the current selection and match the option, quantity and currency first. Then separate the item amount from delivery charges.
Start with what each amount buysStart with what each amount buys
Read the saved RMB price as a snapshot. Does it name a size or version? Is it for one piece, a pair or a pack? A listing's lowest displayed amount may belong to an option other than the one pictured in the sheet.
In this illustrative example, a row says “navy top, ¥120.” The listing offers a basic version at ¥120 and a lined version at ¥145. If you select the lined version, the ¥25 difference is an option difference. It is not evidence of a payment fee or currency conversion.
| Mismatch | Compare these fields |
|---|---|
| Price changes after choosing a colour | Exact colour label and its selected amount |
| Price changes after choosing a size or version | Selected specification, not the listing headline |
| Checkout is roughly a multiple of the row price | Quantity and the number of pieces per unit |
| Same selection costs more than the old row | Saved date and current item amount |
| A converted sheet price looks inconsistent | Original currency and the sheet's conversion date or formula |
Keep domestic delivery on its own line
Suppose one item costs ¥145 and seller-to-warehouse delivery is separately shown as ¥8. The goods-stage amount is ¥153 in that example. Comparing ¥153 directly with a saved item-only ¥120 hides both the ¥25 option difference and the ¥8 delivery charge.
Those figures illustrate how to reconcile the amounts; they are not Oopbuy prices or a shipping quote. International freight belongs to a later stage, explained in shipping cost components.
What if every field matches?
If the listing, selected option, quantity and currency match but the amount has changed, use the current selection to evaluate the purchase. Keep the older amount with its date so you can see what changed instead of silently replacing the context.
For a sheet that displays a second currency, return to the original item amount before comparing. A saved conversion may use an old exchange rate or a different fee basis. There is no benefit in converting everything again when both item prices are already in yuan.
If the image and selected variant disagree, resolve that first with option and photo mismatches. A cheaper price is only useful when it buys the option you actually want.