Independent practical guide
HooBuy Spreadsheet Guide: Verified Links, Size & QC
Start a HooBuy spreadsheet with one row per exact product option. Save the current link, selected price, size evidence and verification date; add order details, warehouse QC and parcel measurements as they become available.
A useful HooBuy spreadsheet is a decision record, not a page of product links. Every row should identify one exact listing and intended variant, show when its evidence was checked, preserve unresolved questions and connect later warehouse information to the same product.
This structure is designed for searches such as HooBuy spreadsheet, HooBuy finds and HooBuy product links. It helps an editor compare candidates without presenting a stale price, borrowed photo or seller claim as permanent fact.
Choose the unit of one row
Use one row for one source listing plus one intended option combination. If the page contains two sizes, colorways or constructions under active consideration, give them separate rows. This keeps the selected-state price, chart and later QC evidence attached to the correct choice.
Assign a stable candidate ID before writing a nickname. The ID survives translated titles, seller edits and internal reorganization. When a destination or seller changes, create a new version instead of silently rewriting the old evidence.
| Block | Core fields | Purpose |
|---|---|---|
| Source | Marketplace, final URL, item ID, seller ID | Reproduces the listing identity |
| Selection | Original option labels, quantity, intended use | Defines the exact order target |
| Evidence | Chart, claims, images, check date, unknowns | Separates facts from assumptions |
| Warehouse | Order ID, item ID, QC state, measurements | Connects received evidence |
| Parcel | Weight, dimensions, restrictions, decision | Supports current shipping checks |
Verify every product link before saving it
Open the shared link, record the original URL and save the final destination after any redirect or translation layer. Capture the marketplace, item identifier, seller or shop identifier and verification date. A matching image alone does not prove that two links lead to the same product.
Use the complete Taobao, 1688 and Weidian link checklist when an address is shortened, dead or redirected. Mark unresolved identity as a blocker; do not move it into the ready list.
Preserve exact option wording
Record every selected color, size, version, bundle and customization label in its original wording. Place translations and editorial explanations in separate fields. This makes the choice reproducible and prevents a familiar nickname from replacing the source option.
Save the displayed price only after selecting the intended combination. Keep amount, currency, quantity, domestic freight state and observation time separate. A headline minimum may belong to another variant and should not be presented as the cost of the intended item.
Design evidence fields by category
Generic columns are not enough. Shoes need size-system, foot-length, label, outsole and packaging fields. Hoodies need chest, length, sleeve method, fabric claim, print and stated weight. Jerseys need edition, customization, spelling and badge fields. Bags need exterior dimensions, hardware and included pieces.
Link category rows to the shoes, hoodie, jersey or bags spreadsheet method. Shared identity fields remain stable while category evidence changes.
Record size evidence without universal conversions
Keep source labels, original measurements, units, endpoints, measurement type and tolerance notes. Compare a candidate only with a reference garment or foot measurement taken on a compatible path. Do not assume that a familiar letter or number has the same dimensions across listings.
The size-chart workflow explains how to separate flat width from circumference, garment length from body measurement and foot length from insole or outsole length. Missing method data should remain visible.
Separate seller claims from observations
Create one field for what the seller states and another for what a current image or warehouse record visibly shows. Material, performance, durability, authenticity and comfort cannot be confirmed from appearance alone. Attribute every claim and date it.
Add an evidence-type field: selected listing text, general page text, image only, seller response, warehouse photo or measured warehouse value. This prevents a broad statement from being applied to an option it may not describe.
Write QC questions before ordering
Plan only the views or measurements that could change the decision. Start with product identity, selected color, size and quantity. Then add category-specific checks such as visible condition, construction, print placement, hardware, included pieces or defined measurement endpoints.
Keep expected evidence and received evidence in separate columns. Use statuses such as pending, matched, mismatch, unclear, missing or not applicable. A warehouse photo can show the specific item and captured surface; it cannot prove hidden composition or long-term performance.
Connect order and warehouse identifiers
After ordering, append the platform order identifier and later warehouse item identifier to the original candidate. Do not start a disconnected row that loses the source evidence. Preserve selected options and order notes exactly as submitted.
When an account event changes, add a timestamped update rather than rewriting the earlier state. The sequence is important when diagnosing a wrong option, seller delay or missing evidence. Use live labels from the account instead of inventing a universal status list.
Keep product amount and parcel planning separate
Product cost, domestic freight, optional services and international parcel charges occur at different stages. Give each its own block. Seller-stated weight belongs in an estimate field, while warehouse-measured weight and packed dimensions belong in later evidence fields.
Do not calculate a permanent shipping price from an old quote. Destination, contents, restrictions, packaging, actual weight, volumetric treatment and current routes can change. Record the current checkout decision and its date without presenting it as a universal rate.
Use statuses that drive action
- Discovered: link saved but identity is incomplete.
- Verified: listing, seller and intended option can be reproduced.
- Blocked: a sizing, inclusion, restriction or evidence question remains.
- Ready: critical fields are complete for the current decision.
- Ordered: order identity is linked to the row.
- QC review: warehouse evidence is being assessed.
- Parcel ready: approval and current shipping checks are complete.
- Archived: completed, rejected, dead or replaced, with a reason.
A numerical score may help sorting, but it must not override a blocker. One missing critical measurement can matter more than several strong listing images. The action status should remain explicit.
Maintain freshness without deleting history
Use separate fields for last listing verification, row edit, order event, QC review and parcel decision. When a seller changes the title, price or variants, append the new observation. Keep the version that informed an existing order.
Schedule rechecks for rows that remain in discovery. Dead or changed links should move to an archive with a reason. The seller-page checklist helps determine whether a replacement deserves a new record.
Use seasonal deadlines as stop rules
A spreadsheet can also control when discovery ends. For a seasonal shortlist, define the real use case and cap the number of overlapping products. For deadline-sensitive purchases, set a stop-adding date and move late candidates to a future parcel.
See the autumn finds shortlist and holiday timeline for practical examples. Neither framework promises delivery; both prevent one late or weak item from holding everything else.
Minimum HooBuy spreadsheet checklist
- One stable row ID per exact listing and intended variant.
- Original and final links with marketplace, item and seller identity.
- Complete original option labels and selected-state price.
- Category-specific size, construction and inclusion fields.
- Seller claims attributed and separated from observations.
- Blocking unknowns and next actions kept visible.
- Order and warehouse identifiers linked to the source row.
- Expected and received QC evidence stored separately.
- Estimated, measured and packed values labeled by stage.
- Dated status history and archive reason preserved.
Make every row explain the next decision
The best HooBuy spreadsheet is not necessarily the largest. It is the one another editor can audit: the exact listing is reproducible, the intended option is clear, the evidence source is labeled and uncertainty has not been disguised as certainty.
Start with a small set of verified candidates and add category fields only when they support a decision. Preserve history, recheck live details and let blockers stop the workflow. That structure turns product links into a maintainable research system from discovery through parcel planning.