How to automatically select the best price among multiple suppliers
Working with multiple suppliers offers a competitive advantage: pricing flexibility, risk reduction, and access to a wide range of products. However, managing dozens or hundreds of bids for the same products becomes a complex task. Manually selecting the optimal price takes hours, leads to errors, and leads to lost profits. Automated systems analyze bids in real time, applying business rules and taking into account the total cost of ownership, quality, and reliability of each supplier.
Basic pricing strategies
There are several fundamental approaches to automated supplier selection, each of which is optimal for specific business goals:
1. Minimum price
Automatic selection of the lowest offer maximizes margins and competitiveness. This strategy works for standardized products where quality is independent of the supplier: name-brand electronics, sealed goods, and digital products. The system simply compares purchasing prices and selects the lowest.
Application: FMCG, consumer electronics, office supplies.
2. Maximum margin
The system selects the supplier offering the largest margin between the purchase price and the planned retail price. Individual discounts, bonuses, and payment terms are taken into account. The retail price remains competitive, and profits increase through procurement optimization.
Application: goods with low price elasticity, premium segment, unique products.
3. Preferred supplier
Priority is given to reliable partners with a proven track record, even if their price is not the lowest. The system selects a priority supplier if their price is within an acceptable range (for example, no higher than 10% of the minimum). This approach reduces operational risks and strengthens long-term partnerships.
Application: goods requiring high quality, complex logistics, business-critical positions.
Weighted Supplier Evaluation System
Modern solutions use a multi-factor assessment, where the supplier's final score is calculated based on several criteria with different weights:
Complex assessment formula
Total Score = Price (40%) + Reliability (30%) + Delivery (20%) + Support (10%)
| Criterion | Weight | Evaluation parameters |
|---|---|---|
| Price | 40% | Purchase price, discounts, payment terms, bonus programs |
| Reliability | 30% | Percentage of completed orders, absence of defects, compliance with description, stability of deliveries |
| Delivery | 20% | Delivery speed, logistics costs, packaging quality, warehouse locations |
| Support | 10% | Speed of response, problem solving, flexibility of terms, quality of service |
Calculation example
Supplier A: €100 (score 80), reliability 95%, delivery 3 days (score 90), support 4.5/5 (score 90)
Final score: 80×0.4 + 95×0.3 + 90×0.2 + 90×0.1 = 32 + 28.5 + 18 + 9 = 87.5
Supplier B: €92 (score 90), reliability 88%, delivery 7 days (score 70), support 3.8/5 (score 76)
Final score: 90×0.4 + 88×0.3 + 70×0.2 + 76×0.1 = 36 + 26.4 + 14 + 7.6 = 84
Solution: Despite the higher price, the system selects Supplier A due to its superiority in other criteria.
Criteria weights are adjusted to the specifics of your business. For urgent orders, the delivery weight can increase to 35-40%, and for premium goods, the reliability weight can increase to 40-45%.
Total Cost of Ownership Calculation
Choosing the lowest purchase price often leads to overpaying due to hidden costs. The correct approach is to calculate the Total Landed Cost, which includes all costs up until the product is ready for sale:
Full Cost Formula
TLC = Purchase Price + Shipping + Customs Duty + Packaging + Insurance + Handling + Loss
- Purchase price: the base price of the product, taking into account discounts, minimum quantities, and payment terms
- Delivery: shipping costs depending on weight, volume, distance and urgency
- Customs duties: For international deliveries - import duties, VAT, certification (relevant for Ukraine when importing from the EU)
- Packaging and labeling: repackaging, additional protection, labeling according to country requirements
- Insurance: protection against damage during transportation, especially for fragile goods
- Processing and storage: acceptance, quality control, warehousing before sale
- Losses and defects: statistical percentage of defective units based on supplier history
Comparison of real costs
Supplier from China: $50 per unit + $8 shipping + $6 duty + $2 insurance + $1 handling = $67 TLC, marriage 3% (+$2) = $69 final price
Supplier from Poland (EU): €60 ($66) per unit + €3 ($3.3) shipping + €0 duty + €0.5 ($0.55) handling = $69.85 TLC, marriage 0.5% (+$0.35) = $70.20 final price
Conclusion: With an apparent difference of €10-16, the real difference is only $1.20, and the European supplier ensures fast delivery (3-5 days instead of 20-30) and minimal defects.
Setting Up Automation Rules: 8 Key Steps
Effective automation of supplier selection requires a well-thought-out system configuration:
1. Import and normalization of price lists
Connect supplier price lists via API, files (CSV, XML, Excel), or website parsing. The system automatically compares products by SKU, EAN, and name, and normalizes currencies and units of measurement.
2. Defining strategy by category
Different categories require different approaches: minimum prices for electronics, fast delivery times for food, and reliability and quality for fashion. Set up rules at the category, brand, or individual product level.
3. Setting weighting factors
Determine the importance of each criterion for your business. Experiment with weights and analyze the results for 2-4 weeks before making final adjustments.
4. Creating a supplier rating
Each supplier is assessed based on reliability criteria, including the percentage of completed orders over the past 3-6 months, average defect rate, delivery delays, and quality of communication.
5. Setting up accessibility filters
Prioritize in-stock items, excluding made-to-order items if fast shipping is required. Minimum order quantity (MOQ) considerations: automatically exclude suppliers with MOQs higher than your needs.
6. Configuring switching rules
Automatic supplier switching when conditions change: if the primary supplier's price increases by >15%, the system selects an alternative; if the item is out of stock, the system switches to the next-highest-ranked option; if the delivery time exceeds the permitted limit, the system selects a faster option.
7. Setting limits and restrictions
Maximum share of purchases from one supplier (for example, no more than 40% of turnover), minimum rating requirements (not lower than 4.0 out of 5.0), geographic preferences (priority to local ones under equal conditions).
8. Setting up notifications and alerts
Alerts about critical events: sharp price increase (>20% in a week), drop in supplier rating, product unavailable from all suppliers, rule conflict (the system cannot select the optimal supplier).
Platform Elbuz provides an intuitive interface for setting up all these rules without coding, with visualization of results and the ability to A/B test strategies.
Fallback strategies and exception handling
A reliable automation system must operate correctly in emergency situations:
The supplier is unavailable
If the primary supplier fails to respond, the price list is outdated, or the website is unavailable, the system automatically switches to an alternative supplier. A timeout (e.g., 24 hours) is configured, after which the supplier is considered unavailable. The administrator receives a notification about the switch.
The product is out of stock
If the current supplier is out of stock, the system checks availability from other suppliers in priority order. If the item is only available from a low-ranking supplier, a warning is generated for manual confirmation or automatic selection with a special mark.
A sharp change in price
If the price changes by more than 30% in a short period (possibly due to a price list error), the system pauses automatic updates and sends an alert. The administrator manually verifies the change before applying it.
Conflict of rules
When no supplier meets all the criteria (for example, an unreliable supplier has the lowest price, while a reliable supplier is too expensive), the system applies a fallback strategy: selecting based on the main criterion (for example, reliability >4.0) or creating a task for the manager.
Properly setting up backup scenarios ensures uninterrupted system operation and prevents financial losses due to automatic errors.
Real-time price comparison
Modern systems update supplier prices automatically, ensuring data is up-to-date:
- API integration: Direct connection to supplier systems to receive prices and balances in real time (updated every 15-60 minutes)
- Automatic parsing: Regular scanning of supplier websites in the absence of an API (updating every 2-6 hours)
- Email monitoring: Automatic processing of price lists sent via email, with data extraction and system updates
- File sharing: Scheduled download of price lists from FTP, Dropbox, and Google Drive
- Multicurrency: Automatic conversion at current Central Bank rates or custom settings, taking into account commissions
The update frequency is individually configurable: every hour for highly volatile products (electronics, cryptocurrency), and once a day for stable categories.
To resolve difficult pricing situations, use the recommendations in the article. Price conflicts between suppliers: how to choose the best one.
Supplier rotation strategies
Relying on a single supplier is risky, even if it offers the best terms. Rotation distributes risks and stimulates competition:
1. Proportional distribution
Automatically distributes orders between multiple suppliers in a preset ratio: 50% to the primary supplier, 30% to alternative 1, 20% to alternative 2. Maintains relationships with all partners and ensures independence.
2. Periodic rotation
Scheduled priority change: every month or quarter, the next-highest-ranking supplier becomes the primary supplier. This is especially useful for large product groups where diversification is important.
3. Threshold rotation
Switching to an alternative supplier when the limit is reached: if you purchase more than €10,000 from one supplier in a month, subsequent orders are automatically transferred to the second supplier. This prevents overdependence.
4. Productive rotation
Each supplier's share is determined by their performance: the higher the rating, the more orders they receive. Automatic monthly recalculation of the proportions based on current metrics encourages suppliers to improve their service.
Rotation does not mean a complete abandonment of price optimization—the system continues to select the most advantageous offer within the established proportions.
Performance and KPI tracking
Regular analysis of automation results allows you to refine your strategy and maximize benefits:
| Metrics | Target value | Method of improvement |
|---|---|---|
| Average savings on purchases | 8-15% vs manual selection | Optimization of criteria weights, addition of new suppliers |
| Percentage of defective products | <2% от объема | Increasing the weight of reliability, eliminating problematic suppliers |
| Average delivery time | 3-7 days for EU/UA | Priority to local suppliers, increased shipping weight |
| Fill rate | >95% | Adding backup suppliers, improving forecasting |
| Frequency of manual interventions | <5% решений | Clarification of rules, expansion of fallback scenarios |
| TLC forecast accuracy | ±3% of the actual value | Calibration of the calculation formula, taking into account real statistics |
Analytics are broken down by category, supplier, and time period. Comparison of planned and actual indicators reveals system weaknesses.
For a comprehensive approach to evaluating suppliers, please review the material Compare suppliers: price, terms, and reliability.
Price history and trend analysis
Historical supplier pricing data is a valuable source of insights for improving strategy:
- Seasonal patterns: identifying periods of price increases and decreases (for example, electronics become cheaper before the release of new models) for purchasing planning
- Supplier volatility: Price change frequency as an indicator of stability; suppliers with frequent price changes receive a lower rating
- Correlation with the market: comparison of supplier price dynamics with the market average; a consistent lag indicates a competitive advantage
- Forecasting changes: using historical data to predict future prices and optimal purchasing times
- Detecting anomalies: Automatic detection of atypical changes (sharp increases/decreases) that may be price errors
Practical example
A six-month historical analysis revealed that Supplier A increases smartphone prices by 8-12% a month before the release of new models, and then reduces prices for older models by 15-20% two weeks after the release. Based on this pattern, the system automatically switches to alternative suppliers during the price increase period and returns to Supplier A after prices stabilize.
Frequently Asked Questions
How often should the criteria weights in the evaluation system be updated?
It's recommended to test the initial scale settings for 2-4 weeks, analyzing the results and adjusting the values. Once stabilized, review them quarterly or whenever business priorities change. Different sets of scales can be used for different product categories, increasing the accuracy of selection.
What to do if the system constantly switches between providers?
Frequent switching (charging) indicates excessively narrow difference thresholds or close supplier ratings. Solutions: Increase the minimum difference for switching (e.g., the new supplier must be 5+ points better), add "hysteresis" (priority to the current supplier under equal conditions), and set a minimum period of use of one supplier (e.g., one week) to reduce operating costs.
How to take into account supplier minimum quantities (MOQ) in automatic selection?
The system should filter out suppliers with MOQs higher than your current needs or consolidate orders until the minimum is reached. When calculating the TLC, consider the "effective price"—the full MOQ cost divided by the actual quantity needed. For example, if you need 10 units, and the MOQ is 50 at €10, the effective price is €50, not €10. This reveals hidden overpayments.
Is it possible to combine automatic and manual supplier selection?
A hybrid approach is the optimal solution for most businesses. Automation is applied to high-volume products (80-90% of the product range), where the rules operate reliably. Critical items, new products, and large orders remain under manual control. The system makes a recommendation, but the final decision is made by a manager. This combines the effectiveness of automation with expert risk management.
Conclusion
Automatically selecting the optimal supplier from a wide range of offers is a critical tool for modern e-commerce. Properly configured systems can save 8-15% on procurement, reduce operating costs by 30-40% by eliminating manual work, and minimize the risk of supply disruptions through diversification. The key to success is a comprehensive approach that considers not only price but also total cost of ownership, reliability, delivery speed, and service quality.
Start with basic strategies (minimum price or preferred supplier), gradually implementing multi-factor evaluation and historical data analysis. Regularly review the rules based on real performance indicators. Automation frees up the team's time for strategic tasks, and the system operates 24/7, instantly responding to market changes.
Read more about purchasing price management strategies in The Complete Guide to E-Commerce Price Management.
Automate supplier selection with Elbuz
The Elbuz platform processes price lists from dozens of suppliers, applies your business rules, and automatically selects the best offers. Setup takes just one day, and ROI is achieved in 2-4 weeks.
Try Elbuz for free
- Basic pricing strategies
- Weighted Supplier Evaluation System
- Total Cost of Ownership Calculation
- Setting Up Automation Rules: 8 Key Steps
- Fallback strategies and exception handling
- Real-time price comparison
- Supplier rotation strategies
- Performance and KPI tracking
- Price history and trend analysis
- Frequently Asked Questions
- Conclusion
Save a link to this article
In the world of automation, I am a translator of ideas into the language of effective business. Here, every dot is a code for success, and every comma is an inspiration for Internet prosperity!
Discussion of the topic – How to automatically select the best price among multiple suppliers
How to automatically select the best price among multiple suppliers
There are no reviews for this product.
Write a comment
Your email address will not be published. Required fields are checked *