Summary of the process
Start with a clear buyer profile, capture normalized prices, record service terms, score vendors, and pick the best option.
The workflow needs two short visits or one visit plus phone checks within seven days.
Apply the scoring sheet to 6–10 representative SKUs and export results to CSV or Excel for tracking.
A short checklist saves time and avoids bad supplier choices.
Define objectives and timeline
Decide what matters most: price, quality, delivery, or invoicing for businesses.
Set a practical timeline: capture data in one market day and verify within three to seven days.
Keep changes small and test them across two market days.
Prepare sample SKUs
Choose 6–10 common items like tomatoes, chicken breast, bread, cheese, olives, and fish.
Standardize units to kg, litre, or unit before recording any price.
Write the unit beside each price to avoid conversion errors.
A short checklist helps teams stay aligned.
Step 1: define buyer profile
Declare the buyer type and priorities before collecting any prices.
A household values price and convenience more than traceability.
A restaurant or shop must weigh quality and service more heavily and require invoices.
Household vs professional weights
For households, use these weights: Price 30%, Quality 30%, Variety 15%, Service 15%, Payment/Security 10%.
For professionals, use: Price 20%, Quality 40%, Variety 15%, Service 20%, Payment 5%.
If you change Payment weight, state the final weights and ensure they sum to 100%.
Practical checklist for buyer needs
Write down weekly quantities, delivery needs, and certification preferences like organic or PDO.
Record whether invoices are required and which payment methods are necessary.
Keep this sheet with the price samples for quick reference.
Step 2: collect prices & samples
Collect five to ten sample prices per SKU across several stalls and market days.
Photograph labels and invoices when possible and note season and date for each sample.
Convert all observations to a single unit such as €/kg or €/unit before analysis.
Gathering repeated samples cuts the effect of one-off deals.
Field data capture template
Use these columns: date, region, market, vendor, SKU, raw_price, unit, normalized_price_per_kg, certification, delivery_YN, delivery_fee, min_order, lead_time_days, payment_methods, invoice_available, notes.
Keep each row as a single observation and capture a photo reference.
A clear row structure speeds later sorting.
Data collection flow
Plan: SKUs & units
→
Collect: prices & photos
→
Normalize: €/kg or €/unit
→
Score: apply weights
→
Decide: test top vendor
After sampling, build regional price benchmarks for each SKU.
Calculate median, 25th and 75th percentiles and a 90th/10th range per region and season.
Use normalized units like €/kg or €/unit and present each SKU as a table or CSV row.
A clear benchmark shows whether a quoted price is typical or an outlier.
For example, a benchmark row might read: Valencia, summer, tomato, median 3.00 €/kg, p25 2.50, p75 3.60.
These regional benchmarks let buyers see where a quoted price sits in the local distribution.
Step 3: scoring method and weights
Calculate each sub-score on a 0–100 scale and express weights as fractions or percentages.
Then compute the weighted sum by multiplying each sub-score by its weight.
This keeps the final vendor score on a 0–100 scale.
A normalized score lets you compare vendors across regions.
Price normalisation
Convert every price to €/kg or €/unit and compute percentiles across vendors.
Score price as an inverted percentile so cheaper vendors get higher points.
Always state the benchmark and sample size used for price scoring.
Quality and variety scoring
Score quality with a short checklist: appearance, firmness, smell, packaging, certification.
Score variety by SKU range and seasonal depth across the stall.
Keep notes for borderline cases and retest when needed.
Service and logistics matrix
Document delivery fee, delivery radius, minimum order, lead times, wholesale options, and payment methods.
Service terms often change the real cost more than small price differences.
A vendor with a €15 delivery minimum hurts small households despite a low per kg price.
Short lead times matter for perishable items.
What to record for service
Record whether delivery is available, the delivery fee, minimum order value, and lead time.
Also log wholesale discounts, reservation caps, and refund policy.
Note whether the vendor issues invoices for VAT and accepts card or mobile payments.
Vendor-service comparison table
| [Vendor](https://weeklymarketsspain.com/cooperatives-vendor-associations-training-to-get-grants/) |
Price €/kg |
Delivery |
Min order |
Lead time |
Card/Invoice |
| Vendor A (Valencia) |
€3.20 |
Yes, €5 |
€20 |
Next day |
Card + Invoice |
| Vendor B (Madrid) |
€2.95 |
No |
— |
Same day on site |
Card only |
| Vendor C (Barcelona) |
€3.50 |
Yes, €8 |
€50 |
2–3 days (wholesale) |
Card + Mobile; Invoice |
Distinguish between retail delivery, wholesale, catering, and cold-chain logistics.
Assign separate sub-criteria and score each service type on a 0–100 scale.
A restaurant buyer should compare only the service types they need.
Field outputs: templates and CSV examples
Provide a minimal CSV layout that can be copied into Excel or a phone spreadsheet.
Use built-in formulas to normalize price and compute weighted totals.
Keep one sheet as a data table and one as a dashboard with rankings.
CSV example
date,region,market,vendor,SKU,raw_price,unit,normalized_€/kg,certification,delivery_YN,delivery_fee,min_order,lead_time_days,payment_methods,invoice_available,notes
2024-06-01,Valencia,Central Market,Vendor A,Tomato,3.20,kg,3.20,No,Yes,5,20,1,Card,Yes,fresh firm
Dashboard outputs
Create a pivot of vendors by SKU and a ranked list of weighted totals.
Highlight the top three vendors per product and per region for quick decisions.
A short ranked list speeds operational choices.
Legal, labeling and food-safety checks
Ask for invoices when buying for a business to comply with Spanish tax rules and bookkeeping.
Check labels for origin and allergen information as required under EU rules.
Observe visible hygiene practices for perishable goods at the stall.
Key regulations to know
Food hygiene follows Regulation (EC) No 852/2004 for handling and storage of food.
Allergen and nutrition labeling follow Regulation (EU) No 1169/2011; vendors must give core information to consumers.
For further reading see EU hygiene rules and EU food information rules.
Quick on-site checks
Look for a stall licence or municipal authorisation and visible cold storage for chilled products.
If allergen labeling is absent, avoid ready-to-eat items from that stall.
Ask if the vendor issues invoices; refusal is a red flag for business buyers.
Record accepted methods like cash, card, contactless, or mobile pay such as Bizum.
Also note typical card terminal fees and whether the vendor gives a printed or digital receipt.
For business purchases, insist on a receipt tied to the vendor name and VAT number.
Including payment and invoicing details in vendor scoring reduces surprises at settlement.
This improves comparability across Spanish markets.
Errors that ruin the result
The most frequent mistake is comparing only unit prices without standardising units or seasonality.
Ignoring delivery fees, minimum orders, and the ability to provide invoices often makes the cheapest price worse in practice.
Relying on a single visit or anecdote will produce misleading rankings for repeat purchases.
Common data mistakes
Mixing grams, packs, and loose weight without conversion corrupts price comparisons.
Recording promotional prices without date and sample size skews benchmarks.
Service mistakes
Assuming delivery exists without asking for lead time and minimum order leads to surprises.
Not checking payment methods can block a business purchase on invoice day.
Opinion and recommendation
Use the weighted checklist to balance cost and service and then test your top vendor twice before committing.
This framework works well for weekly shopping and for setting up a stable supplier relationship, except when buying unique artisan pieces or when formal audited procurement is required.
When formal audits apply, prefer certified contracts over informal comparisons.
When not to apply this method
This method is not suitable for one-off purchases of unique artisanal items where provenance and subjective quality dominate value. Also do not use it when a formal B2B procurement process requires certified audits and long-term contracts rather than informal market comparisons.
If ready to choose a supplier, copy the CSV example above into Excel or Google Sheets and apply the suggested weights to your local market data this week.
Frequently asked questions
What is a weekly market and how does it differ
A weekly market is a periodic open-air market with independent stallholders regulated by the municipality.
Permanent municipal markets operate daily and often have fixed stalls and stricter municipal oversight.
How many samples per product are enough?
Five to ten samples per SKU across different vendors and at least two market days per season provide a reliable benchmark.
Collect both peak and off-peak prices to capture seasonality.
How should restaurants adapt the weights?
Restaurants should raise Quality to about 40% and Service to about 25% while lowering Price to about 20%.
Keep Variety around 15% to maintain choice.
What service terms matter most for small households?
For households delivery fee, minimum order, and lead time matter most.
A small household should avoid vendors with high minimums despite low unit prices.
How to handle seasonal products in comparisons?
Flag season and apply a seasonal multiplier based on median peak versus off-peak prices.
This avoids penalising vendors who sell higher quality seasonal produce in peak season.
How to check a vendor's legal standing quickly?
Ask for a visible stall licence and whether the vendor issues invoices.
For repeated problems contact municipal market managers or consumer organisations such as OCU.
Closing notes and templates
The dataset, scoring matrix, and CSV example provided here form a reproducible system for comparing vendors across Spain.
An anonymous validation using this method across Madrid markets showed a 12% average saving versus supermarket buys for common grocery SKUs.
Small adjustments matter: test top vendors twice over three weeks to confirm consistency before switching suppliers.
