Sugargoo Sheet: Keep Product Choices, Costs and Parcel Decisions Separate

A useful Sugargoo sheet answers three different questions: what do you want to buy, what have you committed to, and what will the parcel cost? Keep those answers separate. Otherwise a wishlist amount can quietly become a budget, and a shipping estimate can look like a payment already made.

Start with one row for one selected offer

Record the product name and address, then the colour, size or version you are considering. Add the quantity and the measurement or included component that matters most. When two options differ enough to change the purchase, give them separate comparison entries rather than putting an ambiguous price range beside one photograph.

For a practical bag example, open the crisscross backpack listing in the product catalog. Your own row could record the chosen option and a question about the usable opening. Do not fill in dimensions, material or capacity from appearance alone.

The accessories guide covers those fit questions. The spreadsheet links guide explains which destination to preserve with the selection.

Use a small set of clearly labelled fields

Field group What it should distinguish
Product Source, exact option, quantity and included pieces
Fit or function Relevant measurement and the question still to resolve
Item costs Unit amount, currency and domestic delivery
Purchase stage Considering, ordered, received or removed from the plan
Parcel Selected goods, packing choice and current shipping estimate

These are suggested fields for a personal shortlist, not a downloadable file or an automated order system. You can adapt them to the purchase, but keep their meanings stable. A column labelled “total” becomes misleading if some rows include shipping and others do not.

Google Sheets and Excel keep the same distinctions

Whether you use a Sugargoo Google spreadsheet or an Excel sheet, keep the original currency and the selected quantity beside the amount. Check which rows a total includes after you add or remove an alternative. A formula can be correct while adding items you never intended to buy.

Keep a private order record separate from the view shared for product advice. Before sharing, check the actual file permissions and remove personal records from the shared material rather than assuming that hiding a row prevents access. Test the shared view from the recipient's perspective without putting credentials or payment secrets into the sheet.

Calculate item amounts without hiding unknown charges

For a hypothetical order, two items at 18 each produce an item subtotal of 36. If domestic delivery for that order is 7, its initial total is 43. Do not multiply the delivery charge by two unless it actually applies separately to each item.

An unknown international shipping charge is not zero. Leave it outside the confirmed subtotal and identify it as an estimate once you have the required parcel inputs. Keep amounts in their stated currency until you make a deliberate conversion; numbers in different currencies cannot simply be added.

The payment guide separates product payments from later charges. The shipping calculator guide explains why changing the parcel inputs can change the freight estimate.

Keep estimates and actual payments in different places

Suppose an initial freight estimate is 52 and the later payable amount is 61. Replacing 52 with 61 without explanation loses the reason your budget changed. Retain the distinction between the planning amount and what you paid, and check whether packing, route or another input changed.

Those illustrative numbers are not a quote. Their purpose is to make a personal budget understandable when the process develops. A spreadsheet cannot make a preliminary estimate final simply by including it in a sum.

For coupon comparisons, use the single-coupon guide. Record the deduction actually applied to the eligible charge, not the face value of an entire promotional pack.

Advance the status only when the event happens

“Saved” means you found a candidate. “Ordered” is a purchase stage, while “received” and “inspected” require different information. Avoid using one green mark to mean all four.

When an item arrives, attach the relevant inspection notes to that exact selection. If you reject or return it, remove it from the planned parcel rather than leaving it in the shipping subtotal. The QC guide and returns guide address those decisions separately.

A parcel tracking reference belongs to the shipment it describes, not every alternative in your original wishlist. Use the tracking guide to distinguish domestic movement from international delivery.

Keep the shared view smaller than your private records

If someone is helping choose between items, they need the public product destinations and comparison details. They do not need your full order history, address or payment records. Share a limited view of the relevant candidates and remove personal details from any accompanying screenshots.

Before deleting duplicate entries, establish whether they are the same offer or different options. The links-shortlist guide explains how to group alternatives without losing meaningful differences.

Frequently asked questions

Does every candidate need a separate shipping price?

Not necessarily. Keep the item subtotal separate and calculate the parcel using its actual contents and packing assumptions. Avoid presenting an arbitrary division as a carrier quote.

Can a blank cost be treated as zero?

No. Distinguish a confirmed zero charge from a cost you have not established. Otherwise the apparent total understates what remains to be paid.

Does a complete sheet mean the order is ready?

Only if the actual purchase questions are resolved. Filled cells do not prove fit, stock, inspection or shipping eligibility.

Return to the Sugargoo spreadsheet for discovery or follow the ordering guide once the chosen items are clear.