Guides · November 4, 2026 · 2 min read
A supplier-data intake sheet for ecommerce teams
A supplier spreadsheet is raw input, not automatically publishable catalog content.
By Polo Themes

A supplier spreadsheet is raw input, not automatically publishable catalog content. It may mix internal abbreviations, shipping measurements and consumer-facing facts. A short intake sheet helps an ecommerce team discover those differences before they become product-page errors.
Keep original data and interpretation separate
Preserve the supplied identifier and exact source value. Add separate columns for the customer-facing label and any conversion or explanation. If a carton measurement becomes the advertised product dimension, you need to see where that interpretation happened.
Ask whether each measurement describes the product, its packaging or a shipping unit. Identify whether a quantity means pieces, pairs or packs. A listing for six units is materially different from a listing for one pack containing six units; the difference should survive the import and the page layout.
Request the facts that affect selection
For each product family, list the choices customers must make. Clothing may need cut, size and composition. Electronics may need model compatibility and connector details. Do not demand the same long sheet for every category, but do require enough information to distinguish similar items accurately.
Include a source contact and an unresolved-questions column. “Supplier to confirm whether dimensions include the handle” is more useful than an empty cell because it tells the next person what must happen. Do not fill unknown fields with a plausible value from a neighboring product.
Test the sheet with difficult records
Choose an ordinary item, an item with several variants and one with an exception. Map them into your intended product-page structure before requesting the entire catalog. This exposes missing fields while the supplier can still change the export process.
Review the mapped result with someone who did not prepare it. Ask them to identify what is sold, how many units it contains and what distinguishes the variants. If they need an explanation from the importer, add that information to the sheet or the presentation.
Define acceptance and correction
Accept a row when its identity, required facts and media mapping are complete enough for the intended listing. Return incomplete rows with specific questions rather than rejecting the entire file without guidance. Retain the accepted revision so a later correction can be traced to a changed source instead of guessed from memory.
Continue with How to maintain a storefront terminology glossary.
