Ripe tomatoes often sit unsold on a Tuesday morning. Cash stays tied up in the back stall.
Small-market stalls across Spain struggle with limited forecasting. They face tight cashflow and variable supplier lead times.
Practical, low-tech sourcing and inventory routines reduce spoilage. They keep products fresh for customers.
Small changes save money and food every market week.
Map harvest months to availability
Map harvest months by region to know when to stock each product.
Reading a regional calendar saves money and prevents spoilage before the stall opens.
The matrix shows peak months, shoulder months and off-season substitutes. A region-level view changes ordering: Andalusia peppers differ from Galicia brassicas.
How to use the month matrix
Start with your top 8 SKUs and mark peak month, shelf life and order cadence. Fill one row per SKU with month flags: peak, available or off-season. This process takes about 60 minutes for eight SKUs.
Regional differences that change orders
Andalusia has early tomatoes from Almería and an extended citrus window. Galicia favors brassicas and late-season greens. Huelva offers berries with tight pick-and-ship windows.
Quick exportable calendar example
Copy this table row into a spreadsheet.
SKU | Region | Jan–Dec flags | Peak month | Shelf life days | Usual lead time days
Use it as the working file for monthly planning.
Make the calendar your active working copy weekly.
A ready seasonality calendar should list common SKUs across rows and months across columns. Vendors spot peak, shoulder and off-season windows at a glance.
For example, a row for tomatoes could show: Andalusia (peak: May–Oct), Murcia (peak: Apr–Sep) and Galicia (short local window: Jul–Aug). Include shelf-life notes: ripe tomato 3–7 days at stall. Also add typical lead time per region.
Populate this table for your top 8–12 SKUs. This enables faster SKU planning and clearer seasonal sourcing. It also improves inventory management during shoulder months and festival periods.
Start with what sells best this coming month.
Build a supplier map and lead-time matrix
Map local suppliers, their lead times and minimums to pick the best mix for each SKU.
A supplier map helps decide when to use a farmer, cooperative or wholesale market.
List 2 primary suppliers and 1 backup per SKU. Record average lead time, min order and payment terms.
Supplier types and typical lead times
Farmer/producer direct: lead time 0–2 days from harvest to stall. Cooperatives/CSA: 1–4 days with weekly bundles. Wholesale markets (Mercamadrid, Mercabarna): same-day to 48 hours for most lines.
Supplier decision checklist
Ask for minimum order, typical lead-time variance, packing format and claim process. Use this script on calls: name, SKU interest, delivery days, MOQ, payment terms, emergency backup. Each call takes 6–12 minutes.
Supplier decision matrix
| Supplier type |
Lead time |
Typical MOQ |
Best for |
| Farmer / Producer |
0–2 days |
Small, flexible |
High-freshness SKUs |
| Cooperative / CSA |
1–4 days |
Weekly bundles |
Seasonal bulk items |
| Wholesale market |
Same-day–48h |
Larger lots |
Fill gaps fast |
| Distributor / Importer |
3–14+ days |
Medium to large |
Off-season supply |
Keep supplier notes updated after each phone call weekly.
An interactive supplier map becomes a practical tool when suppliers are modelled as structured records. (Include coordinates, typical lead_time_days, MOQ, contact and product list.) Export as GeoJSON or a simple CSV with lat/long.
For example, a GeoJSON feature might include properties: {"name":"Farmer A","lead_time":1,"MOQ":10,"products":["tomato","pepper"]}.
Embedding such a layer in a basic Leaflet map or Google Maps list gives vendors a visual supplier catchment. This helps choose local suppliers to reduce lead time and food waste.
Maps make fast supplier choices under market time pressure.
Publish schema.org LocalBusiness/Product markup for key suppliers and markets. This improves local discoverability. It makes supplier mapping a bridge to the wider supply chain for markets.
Set reorder points for perishables
Calculate reorder points that include demand during lead time, safety stock and expected spoilage.
Use a simple formula and a worked example to make ordering mechanical and fast. This reduces guesswork before busy market weeks.
ROP = demand during lead time + safety stock + expected spoilage losses (order-to-cover).
If a vendor expects 10% spoilage between receipt and sale, increase the reorder point. This ensures sellable units meet demand during lead time.
Do not subtract spoilage from your target sellable units; expected losses typically require ordering extra units to maintain service level. The worked example below uses a subtraction to show net sellable units after spoilage; if you want to order extra to cover those losses, add the expected spoilage to the ROP.
Estimate spoilage as percent of received stock. Add that expected loss into the ROP calculation or into the order quantity placed when ROP is reached.
Demand during lead time equals average daily sales times average lead time in days. Safety stock covers short lead-time spikes.
Practical safety stock and spoilage
For small vendors, set safety stock equal to 1–2 days of average sales. Measure spoilage as percent of received stock over four weeks. Update values monthly.
Worked numeric example
Average daily sales = 30 units. Lead time = 2 days. Safety stock = 30 units.
Spoilage = 10%. Then ROP = (30×2) + 30 - (0.10×(30×2)) = 84 units. This calculation takes two minutes per SKU.
Make this math a quick habit each week.
Demand forecasting for weekly market stalls can use low-tech methods. These methods reflect seasonality and short lead times.
A simple approach uses a 4-week moving average as the baseline. Then apply a seasonal index, for example July index 1.2 for summer demand.
Adjust for known events, for example festivals that increase baseline by X%.
For example: four weekly sales of 210, 240, 180 and 270 yield a 4-week average of 225. Applying a July index of 1.2 gives a near-term weekly forecast of 270.
Divide that weekly forecast by 7 to get average daily demand. Use that number in demand-during-lead-time calculations.
These forecasts feed minimum order quantity negotiations. They also determine when to use safety stock or increase order frequency.
Forecasts guide smarter buys and reduce forced markdowns.
Design order cadence and cashflow plan
Set order frequency per SKU based on perishability and supplier terms. Match cadence to cashflow and reduce waste.
Order cadence ties suppliers, lead times and stall receipts into a practical rhythm. Use short runs for high-perishables and larger, less frequent buys for durable items.
Weekly order template
Create a one-sheet order form with columns: SKU, avg daily sales, lead time, ROP, order qty, supplier, delivery day. Fill it 30 minutes before the weekly ordering slot.
How supplier lead times shape cadence
Farm pick-up allows same-day or next-day orders. This enables 2–3 orders weekly for salad greens.
Cooperatives with weekly delivery push vendors to plan weekly bundles. Imports need monthly planning.
Cashflow-friendly order sizing
Split payments when possible: pay small cash for daily buys and net terms for bulk weekly orders. Negotiate net 7–15 days with cooperatives when cashflow is tight. This reduces forced markdowns.
Small payment tweaks protect cash and keep profits steady.
Storage, packaging and waste reduction
Improve on-stall storage. Apply FIFO rotation and use targeted packaging to extend shelf life.
Small changes to storage and handling cut spoilage quickly. Simple equipment and routines often outperform expensive machines in weekly markets.
Low-cost storage tips
Insulated crates and shaded staging reduce heat stress on produce. Use evaporative cooling for leafy greens when electricity is unavailable. Label crates with arrival date for FIFO.
Packaging and hygiene essentials
Follow EU Regulation 1169/2011 for consumer information and EC Regulation 852/2004 for hygiene. Keep single-item labels with origin, weight and allergens visible. Municipal inspectors check basic compliance.
Waste-reduction actions
Apply day-two markdowns. Reprocess imperfect produce into value SKUs. Partner with local food banks for unsold edible stock.
Track weekly spoilage percent to spot trends.
Small routines add up to big waste cuts.
Templates, case studies and KPIs
Use ready templates and short case studies to copy proven changes into the stall routine. Templates reduce setup time and force consistent data collection. KPIs give quick signals to change orders before losses grow.
Included templates to copy
Weekly Order Sheet
Date: [YYYY-MM-DD]
SKU | Region | Avg daily sales | Lead time (days) | ROP | Order qty | Supplier | Delivery day
Tomato | Andalusia | 25 | 2 | 60 | 80 | Farmer A | Wed
Supplier call script:
Hello, this is [stall name]. Interested in [SKU]. What is MOQ? Typical lead time? Payment terms? Can you deliver on [day]? Thank you.
Vendor case studies with KPIs
Case A (Andalusia fruit stall): spoilage fell from 18% to 6% after switching to weekly cooperative deliveries and ROP orders. Sell-through rose 22% during summer 2022. This example shows seasonal sourcing reduces waste.
Case B (Catalan cheese stall): fill rate improved from 83% to 97% before a June festival. They achieved this by mapping supplier lead times and holding a 3-day safety stock for top sellers.
KPIs to track weekly
Track sell-through rate, days of inventory, spoilage %, fill rate and average order size. Sell-through rate equals sold ÷ received over seven days. Days of inventory equals average stock ÷ average daily sales.
Regional harvest windows differ. Andalusia often supplies early tomatoes and long citrus months. Catalonia supplies stone fruits in late spring. Galicia provides cool-season brassicas in autumn and winter. Use regional calendars rather than country-level assumptions when ordering.
PROCESS: Plan → Source → Order → Store
1
Plan: pick top SKUs and mark peak months
2
Source: map 2 suppliers per SKU and log lead times
3
Order: compute ROP and place orders by cadence
4
Store: apply FIFO, label crates, and mark day-two markdowns
The most frequent error at this point is assuming lead times stay constant. Seasonal roadworks, harvest delays or market holidays change lead times often. Record lead-time variance weekly and update ROP calculations monthly.
In practice, small stalls underestimate spoilage by 3–10 percentage points during heat waves. Adjust expected spoilage upwards in summer months and increase order frequency accordingly.
Evidence references: EU Regulation 1169/2011 on food information, EU Plant Health Regulation (EU 2016/2031) and EU Organic Regulation (EU 2018/848). They guide labelling and handling obligations for market sellers.
Check rules and labels before each market day.
Frequently asked questions
How do I find reliable local suppliers quickly?
Contact local cooperatives, Mercabarna or Mercamadrid directories and municipal market managers for supplier lists. Then call three candidates for each SKU and log lead time, MOQ and payment terms. Prioritize reliability and short lead time over lowest price for perishables.
How often should a stall update seasonality data?
Update the seasonality matrix monthly and review it before each new selling season. Check harvest windows after major weather events and before regional festivals that change demand patterns.
What is an acceptable spoilage rate for fruits?
Acceptable spoilage varies, but small vendors often see 5–15% monthly depending on SKU and season. Track spoilage weekly to spot spikes and adjust orders quickly.
How to calculate days of inventory for a weekly stall?
Days of inventory equals average inventory on hand divided by average daily sales. Use seven-day averages to reduce noise and update it every week.
Can small stalls negotiate lead times with suppliers?
Yes. Cooperatives often offer weekly bundles and net terms for committed buyers. Offer predictable weekly orders in exchange for a slightly better price or delivery terms.
What to do before a festival week to avoid stockouts?
Increase safety stock by 1.5–3 days for top SKUs and confirm deliveries one week prior. Flag festival dates in the four-week rolling forecast and notify suppliers of expected higher orders.
Closing: what to do now
Start by auditing top 8 SKUs and filling the weekly order sheet for each. Call two suppliers per SKU this week and record lead times and MOQs. Compute ROPs for high-perishables and set a one-week routine to check KPIs.
⚠️ This guide does not replace local regulatory advice. For labelling or hygiene questions consult MAPA or local town council rules before the season opens.
Source: Ministry of Agriculture, Fisheries and Food (MAPA)
