Sugargoo Spreadsheet: Track Items, QC Decisions and Parcel Costs

Connect each original product link with your QC decision and the parcel that contains it. Keep item costs separate from shared parcel charges to avoid counting the same shipping cost more than once.

This independent guide explains a manual record method and a worked allocation example. The downloadable worksheet does not connect to your account or provide a live shipping quote. Copy paid amounts and dated statuses from your own account.

Choose your destination guide

USA · UK · Canada · Australia · Česko

Then use the item table, decision log and parcel table below, connected with non-sensitive references such as Item A and Parcel 1.

1. Create the item table

Record a local item reference, source URL, seller or item identifier, selected size and colour, quantity, displayed item cost, currency and checked date.

Add your account's current status wording and the date you observed it. Keep your next action in a separate field. An item marked received at a warehouse is not the same as a parcel delivered to you.

Use Unknown for a missing value. Do not fill a blank weight or fee with zero simply to make a total appear complete.

2. Keep a QC decision log

For each item, record the photo reference, selected variant, specific detail checked, decision date and next action. Keep observations such as “size label unreadable” separate from conclusions such as “need another photo”.

Record the status you can verify: awaiting evidence, reviewing, additional information requested or decision recorded. These are personal worksheet labels, not a representation of Sugargoo's current interface.

Do not overwrite an earlier decision. Add a new dated entry when better evidence changes your view.

3. Connect items to a parcel

Create a parcel reference and list the item references assigned to it. An item that has not been assigned to a parcel should remain unassigned rather than inheriting another parcel's tracking status.

Record the destination country, chosen route, quoted weight and dimensions when displayed, quote date and later confirmed charge. Keep an estimate and an actual amount in different fields.

Before dispatch, check that the item count and selected variants in your records match the account information. Do not assume the worksheet itself creates or changes a shipment.

4. Separate costs by level

Item-level costs can include the item subtotal and an identifiable domestic delivery fee. Parcel-level costs can include the confirmed international charge and packing charge. Record each amount once, with its currency and source.

Keep duties, taxes, refunds and adjustments separate. If an amount is not yet known, show that the total is incomplete. Mixing currencies without a recorded exchange rate produces a misleading sum.

If you need a per-item estimate, allocate the shared parcel costs explicitly. Allocation is your accounting choice, not a provider's quote.

5. Choose an allocation method openly

The homepage illustrates a hybrid method: 70% of a shared parcel charge is allocated by item weight and 30% by item value. These percentages are an optional worksheet convention, not a Sugargoo rule.

For item i, the allocation is Shared charge × [0.70 × item weight / total item weight + 0.30 × item value / total item value]. Use consistent units and currencies. Both totals must be positive.

If an item weight or value is missing, do not calculate this method as though it were zero. Keep the allocation pending, or choose and disclose another method with complete inputs.

6. Check a worked example

Illustrative numbers: Parcel 1 has a shared charge of 100 currency units. Item A weighs 1 kg and has a value of 100; Item B weighs 3 kg and has a value of 100.

A's weight share is 1/4 and value share is 1/2. Its allocation is 100 × (0.70 × 0.25 + 0.30 × 0.50) = 32.50. B receives 67.50. The two allocations total 100.

These figures are only a mathematical example. They are not current shipping prices, a recommended route or an estimate for your parcel. Record any rounding adjustment so allocations still reconcile to the shared charge.

Add a source and timestamp to every number

Do not overwrite an estimate with a final value. Keep both, with a timestamp and source:

• listing_price — amount visible on the seller listing and the date checked;

• domestic_delivery — amount shown for seller-to-warehouse delivery;

• route_estimate — result from the official estimator with destination, category, weight and dimensions;

• packed_weight and packed_dimensions — values available after packing or simulation;

• shipping_paid — parcel charge actually paid;

• refund_or_adjustment — later change shown in the account;

• allocation_method — the rule used to split parcel-level costs across items.

The official estimator is planning evidence, not a guaranteed invoice. The official pre-shipment simulation guide says the packed parcel can produce a different final chargeable weight. Keep the original estimate so the difference can be explained instead of hidden.

Sources: Sugargoo shipping estimator guide and Sugargoo pre-shipment simulation guide, accessed 17 September 2026.

7. Reconcile actual charges and refunds

When a confirmed charge replaces an estimate, preserve the original quote and add the actual amount with its date. Write down the reason if the account supplies one; otherwise leave the reason unknown.

Keep refunds as separate transactions linked to the original cost. Distinguish requested, approved and received amounts. A request is not money returned.

For each parcel, check that shared-cost allocations sum to the recorded shared charge. For each item, show its own costs and its allocated share separately so a reader can reconstruct the total.

8. Maintain a useful status timeline

Record the latest carrier or account event text with its timestamp and source. Keep time zones when they are displayed. Do not turn a lack of updates into a predicted delivery date.

Choose a next action and a review date where necessary, such as checking an unreadable QC photo or an unexplained charge. Use official support for account-specific questions.

Before sharing the sheet, remove names, addresses, tracking numbers, account identifiers and screenshots containing personal details. A public example should use invented reference codes and clearly labelled sample amounts.

Sugargoo tracking worksheet questions

Does this spreadsheet track my account automatically?

No. This is a manual method. Update it from your own account and carrier information.

Is the 70/30 allocation an official shipping formula?

No. It is an optional way to divide an already known shared cost between items. It does not predict the charge.

Can I calculate with missing item weights?

Not with the weight-based method described here. Mark the calculation pending until the required inputs are available.

Does a QC decision prove quality or authenticity?

No. Record only what the available evidence supports and keep unresolved details visible.

Use the Return to the Sugargoo order-record overview as your starting point. Send corrections about this independent guide to WhatsApp +8613950785007; account support belongs with the official service.

Method note · reviewed 1 October 2026 (UTC+8)

Source notes for item, parcel and allocated-cost records

The worksheet above links item records to a parcel and optionally allocates a known shared charge. These source notes identify which parts correspond to Sugargoo's published workflow and which calculations remain the user's own accounting method.

Use the published workflow as table boundaries

Sugargoo's official About page describes procurement, warehousing, quality inspection, personalized packaging, international logistics and after-sales support as separate parts of its service. Keep seller or item data, warehouse and QC observations, parcel data, logistics events and later adjustments in separate records. One stage does not prove that the next has occurred.

Record the exact estimate inputs

Sugargoo's official shipping-estimate guide describes entering destination, product category, weight and, for bulky items, dimensions before reviewing routes. It also distinguishes estimated shipping from the final fee after packing. Save the input set, route, currency and checked date beside every estimate. If weight, dimensions or charge scope is missing, keep it Unknown.

Keep allocation separate from the provider's charge

The 70/30 weight-and-value allocation on this site is an optional worksheet convention. It divides an already recorded shared charge and is not presented by the official sources as Sugargoo's billing formula. Preserve the parcel's quoted or paid charge unchanged, record the allocation method, and make sure item allocations reconcile to that charge.

References and review rule

• Sugargoo official About page and published service stages

• Sugargoo official shipping-estimate guide

The estimator article was published on 12 September 2025 and updated on 17 October 2025. Its example prices are historical illustrations, not current quotes. These first-party pages support workflow and estimate inputs; they do not independently verify a seller, item, route result, final cost or delivery time. Use the site's parcel cost allocation worksheet, retain earlier estimates and update a status only from dated account or carrier evidence.