How to Build an Outdoor Furniture Product Comparison Sheet
Build an outdoor furniture product comparison sheet that keeps model identity, materials, dimensions, variants, sample status and open questions aligned.
Outdoor furniture buyers often receive product images, model codes, material notes and quotation lines in different formats. A comparison sheet creates one working record so the team can see which facts are confirmed, which models are genuinely comparable and which questions must be closed before sample or order approval.
Use one row for each exact model and controlled variant. Keep the supplier model code, buyer SKU, image reference, category, construction, confirmed dimensions, finish, cushion format, sample status and open questions in separate columns. Never fill a blank with an assumption. Link every important value to its source and record the revision date.
1. Start with the decision the sheet must support
A useful comparison sheet is not a copy of every catalogue field. It is a decision tool. Define whether the team is selecting a retail assortment, preparing a hospitality quotation, choosing sample models, comparing supplier offers or freezing the final approved specification.
The decision controls the columns. An early assortment sheet may focus on category role, visual direction and model identity. A sample-selection sheet needs confirmed construction and option references. A final order record requires the approved variant and current documents. Mixing all stages into one unlabelled sheet makes an early estimate look like a final fact.
For range planning before the model-level comparison, start with the outdoor furniture assortment guide. Use the product comparison sheet after the category roles and buyer channel are clear.
2. Give every row a stable product identity
Begin with the exact supplier model code and a short neutral product name. Add the buyer's internal SKU only in a separate column. A product photograph should be linked or embedded as a reference, but the image filename should not replace the model code because filenames can be renamed, duplicated or separated from their source.
If a retail or distribution system uses a Global Trade Item Number, keep it separate from both the supplier model and internal SKU. GS1 describes a GTIN as an identifier for trade items that may be priced, ordered or invoiced. That does not mean every sourcing comparison needs a GTIN or that a supplier has assigned one. It means the identifier used by a trading system should not be confused with a supplier's working model code.
3. Compare facts that change the buying decision
Use consistent field names across categories, then allow category-specific fields where needed. A dining chair and a hanging chair should share identity, finish and status columns, while basket size or stand format belongs only to the hanging-chair comparison.
| Field group | Recommended fields | Why it matters |
|---|---|---|
| Identity | Supplier model, product name, buyer SKU, image reference, category | Prevents similar products from being merged |
| Construction | Frame material, visible surface or weave, finish reference, cushion format | Shows real construction differences behind similar images |
| Size and format | Confirmed dimensions, seat or table format, stackability or assembly status when verified | Supports layout, storage and sample comparison |
| Variant control | Colour, rope or rattan reference, fabric reference, cushion option | Keeps the compared item tied to one controlled option |
| Decision status | Longlist, shortlist, sample requested, sample reviewed, approved or hold | Separates facts from workflow decisions |
| Source and revision | Source file, source date, reviewer, last update, open questions | Makes every important value traceable |
Do not force price, MOQ, lead time, packing, testing or compliance documents into the product specification columns. Those may be essential to a buying decision, but they should remain order-specific quotation fields until confirmed. The quotation comparison guide explains how to review those commercial assumptions separately.
4. Make missing information visible instead of filling the gap
A blank cell can mean "not supplied," "not applicable," "not reviewed" or "unknown." Those meanings should not be treated as equal. Add a controlled status beside any field that affects selection.
| Status | Meaning | Buyer action |
|---|---|---|
| Confirmed | Supported by the current agreed source | Record the source and revision |
| Pending supplier confirmation | A value was requested but not yet confirmed | Keep it open in the RFQ tracker |
| Conflict | Two sources give different values or descriptions | Preserve both sources and stop publication or approval |
| Not applicable | The field does not belong to this product format | Use a consistent N/A code |
| Not required for this decision | The field is outside the current comparison scope | Do not collect it merely to fill the sheet |
This approach is especially important when source files conflict. The correct response is not to choose the number that looks more plausible. Keep the conflict visible, assign an owner and close it before the value is used in a sample brief, quotation comparison or public product page.
5. Separate variants that could change the order identity
Do not place several colours, finishes or cushion arrangements in one row if the buyer needs to quote, sample or approve them separately. Use a base-model column and a controlled variant column. If the exact variant is still undecided, mark it as open instead of presenting a catalogue example as the selected option.
For a customization project, attach the approved material, finish and fabric references to the selected row. The customization approval guide provides a workflow for samples, change records and approval evidence.
GS1's GTIN Management Standard explains that product-identification decisions should be handled consistently when a trade item changes. Buyers should apply their own channel rules and should not infer that a supplier model change automatically creates or preserves a particular GTIN.
6. Use the sheet to reduce the sample list deliberately
After the fields are normalized, compare models by the job they perform. Remove duplicates that do not create a meaningful difference in construction, format, price position or application. Keep an alternative when it answers a separate buyer need, not simply because it has a different photograph.
- Group by category role. Dining, lounge, bar, poolside and occasional seating should not compete in one undifferentiated list.
- Identify the real difference. State what changes between the models using confirmed fields.
- Close critical unknowns. Do not request a sample only to discover that the compared construction was never confirmed.
- Record the decision reason. Note why a model moved to shortlist, hold or reject.
- Issue one sample brief. Send the exact model, variant, questions and evidence required.
Use the live category pages to begin a model list: outdoor dining chairs, outdoor sofa sets, outdoor bar chairs and sun loungers and beach chairs.
7. Keep one current sheet and preserve the decision trail
Name the owner, version and review date. Protect fields that have been approved, and record changes in a separate log rather than silently overwriting the earlier value. When a new quotation or sample note arrives, update the source reference and the status together.
GS1's Global Data Model Attribute Implementation Guideline describes the value of harmonized foundational product attributes for listing, ordering, moving, storing, selling and discontinuing products. A buyer's comparison sheet is not the GS1 model, but the same discipline is useful: define fields consistently, keep identity stable and make changes traceable.
8. Avoid six comparison-sheet mistakes
- Using images as identifiers. Keep the exact model code beside every image.
- Combining several variants in one row. Separate anything that needs its own quotation or approval.
- Mixing confirmed and estimated values. Give every important field a visible status.
- Copying supplier wording without normalization. Use consistent field names while preserving the original source.
- Ranking models before closing critical gaps. A comparison score is unreliable when key data are unknown.
- Overwriting revisions. Preserve the source and decision history.
Product comparison sheet checklist
- Every row has one exact supplier model.
- Buyer SKU and GTIN, when used, have separate fields.
- The product image is linked to the correct model.
- Category and intended role are recorded.
- Construction fields use consistent names.
- Dimensions are marked confirmed, pending or conflicting.
- Each selected colour or material variant is controlled.
- Commercial terms remain tied to the current quotation.
- Unknowns have an owner and next action.
- Shortlist decisions include a reason.
- Sample status and approval evidence are visible.
- The current version and source dates are recorded.
9. Send the comparison sheet with a focused RFQ
A clean comparison sheet lets the supplier answer model by model. Remove internal scoring that the supplier does not need, highlight the selected variants, list open questions and attach the current image references. Then use the outdoor furniture RFQ checklist to add quantity, destination, application and quotation requirements.
Importers and distributors planning a mixed-category range can also use the importer and distributor sourcing page to organize the initial request.
Frequently asked questions
Should every colour have a separate row?
Use a separate row or controlled variant record when the colour, finish, weave, fabric or cushion option needs its own quotation, sample or approval decision.
Is a supplier model code the same as a GTIN?
No. A supplier model is the supplier's product reference. A GTIN is a GS1 trade-item identifier used in applicable supply-chain systems. Keep them in separate fields and verify which identifiers the buyer's channel requires.
What should happen when two sources conflict?
Preserve both sources, mark the field as a conflict, name the person responsible for confirmation and do not publish or approve the disputed value.
When should the sheet be frozen?
Freeze a dated version when the shortlist or sample scope is approved. Later changes should create a new revision with a recorded reason and source.
Prepare a model-based request
Share model numbers or reference images, estimated quantities, intended application, preferred materials and colours, destination, and the fields your team still needs to confirm.
Official references
- GS1 - Global Trade Item Number (GTIN)
- GS1 - GTIN Management Standard
- GS1 - Global Data Model Attribute Implementation Guideline
These sources support general product-identity and product-data principles. No supplier GTIN assignment, GS1 data-network participation or compliance with a buyer's private identification rules is claimed.
