Update Product Prices Across Your Whole Sales Team
Updating 200 product prices across a field sales team in SA takes days with spreadsheets. Here's how to do it in minutes with a central catalogue.
Table of Contents
The Supplier Cost Increase Email Arrives on Tuesday
It's a Tuesday morning. An email from your primary supplier arrives: raw material costs have increased, and they're passing through a 7% price increase effective from the 1st of next month. You have 200 active SKUs across five product categories. Some will need the full 7% applied; others have been partially absorbed. You have 25 reps spread across Johannesburg, Cape Town, Durban, and Pretoria.
How long does updating your field sales team's product prices actually take?
For most South African distributors still operating on spreadsheets: days. Minimum. And during those days — while you're recalculating, updating, sending, chasing, confirming — at least some of your reps are quoting prices that are about to be wrong.
Price updates shouldn't take days. Start your 14-day free trial and update product prices once — every rep sees it immediately. No credit card required.
The Spreadsheet Distribution Problem
Let's be precise about what "distributing a price list update" actually involves in a spreadsheet-based operation:
- You (or your admin) updates the master price list Excel file
- You save a new version (adding to the naming chaos: "Price List March 2026 v2 FINAL.xlsx")
- You email it to every rep — 25 individual emails, or a group email that half the team ignores
- You hope they open it. You hope they replace their old copy. You hope they don't accidentally use the wrong file tomorrow
- Three days later, someone on the road in Gqeberha is still quoting old prices because they didn't see the email
- A credit note gets raised. You have a conversation. The cycle repeats
This isn't a failure of diligence — it's a failure of process architecture. Email distribution of price list files is not a reliable update mechanism for a mobile sales force.
What the Central Catalogue Approach Changes
A central product catalogue means exactly what it sounds like: one place where all product information and pricing lives, and every rep's device reads from that same source.
When you update a price in the catalogue, you are not sending an update to 25 devices — you're changing the master record that all 25 devices already point to. The next time a rep opens the app or places an order, they see the new price. There is no distribution step. There is no version to manage. There is no email to send.
For a business dealing with regular price changes — whether driven by supplier increases, fuel surcharges, currency fluctuations, or promotions — this architectural difference is transformative.
Bulk Price Update Tools: Working at Scale
The 7% supplier increase scenario illustrates why bulk update functionality matters. You don't want to update 200 SKUs one by one. A proper pricing system allows:
- Category-level percentage increases — apply 7% to all products in the "Beverages" category in one operation
- Supplier-based increases — apply the increase to all products from a specific supplier code
- Selected SKU updates — apply a flat amount or percentage to a curated selection
- Mass edit with preview — see the new prices before committing, with a before/after comparison
This reduces a 200-product update from a half-day spreadsheet exercise to a 10-minute configuration task.
Handling Supplier Cost Changes Efficiently
When a supplier increase arrives, the practical workflow in a centralised system looks like this:
- Identify affected products — filter by supplier in the product catalogue
- Calculate new cost prices — update your cost-of-goods data (important for margin tracking)
- Apply the selling price increase — either as a fixed pass-through or with margin protection (system calculates the selling price needed to maintain your target margin percentage)
- Set the effective date — the new prices can be configured to go live on a future date, so you can prepare in advance
- Review and confirm — preview the changes, check for any anomalies
- Publish — all reps see the new prices from the effective date
The "effective date" capability deserves emphasis. You can make the price change on Tuesday, schedule it for the 1st of the month, and have every rep automatically start quoting the new rate on the correct date — without any further action required from you or your team.
Communicating Price Increases to Customers
Updating your internal pricing is only half the job. Customers need to be informed, particularly for significant increases. Best practice:
- Give advance notice — at least 30 days for meaningful increases (check if your trading terms specify notice periods)
- Communicate the reason — "supplier raw material cost increase" is better received than a silent price change
- Apply consistently — if different customers are on different price lists, ensure the increase is applied proportionally across tiers
A customer portal can surface upcoming price changes directly to customers' buying staff, reducing the number of "why is this invoice different?" calls your team receives.
Keep customers informed before they see a surprise invoice. A customer portal surfaces upcoming price changes to your buyers automatically. Start your free trial and update prices once — every rep and customer sees it immediately.
Seasonal and Promotional Pricing: Time-Limited Changes
Not every price change is permanent. Seasonal promotions, clearing of slow-moving stock, supplier-funded volume incentives — all of these involve temporary price reductions that need to revert at a specific point.
In a central catalogue system, promotional prices are configured with:
- Start date and end date
- Affected products and customer tiers (is this promotion available to all customers, or only to wholesale accounts?)
- Promotional price or discount percentage
When the promotion ends, the system reverts automatically. No action required. No risk of forgetting to remove the promotional rate. No rep accidentally quoting a promo price on an order placed the week after the promotion ended.
For SA distributors running supplier-funded promotional deals — common in the FMCG sector with manufacturers like Tiger Brands, Pioneer Foods, or AVI running trade promotions — this automated reversion is essential.
Preventing Rep Confusion During Price Changes
Even with a centralised system, reps need to know when prices are changing. No one wants to be mid-conversation with a customer and have the price change unexpectedly.
Good systems handle this through:
- In-app change notifications — "12 product prices will change from 1 April. Tap to preview."
- Change summaries — reps can see a before/after comparison for products in their territory
- Manager broadcast — push a message to all reps explaining the context of the increase
This keeps the team informed without requiring the manual email-everyone workflow.
Handling In-Flight Orders When Prices Change
A specific scenario worth planning for: a rep submits an order on Wednesday at the old price, but the price change takes effect on Thursday before the order is processed. What happens?
This depends on your policy, but the system should:
- Lock the order price at submission time — the price the rep quoted is the price honoured
- Flag price-changed items on orders placed at old rates — so admin can review and apply the agreed policy
- Prevent orders from being backdated to exploit a lower price that's no longer current
Having a clear policy on this, encoded in the system, prevents disputes and ensures consistent treatment.
The ROI of Getting Price Updates Right
Consider the direct cost of the current approach for a 25-rep team:
- Admin time to update and distribute price lists: 4-6 hours per update cycle
- Frequency: potentially 4-6 times per year (or more for active promo businesses)
- Total: 20-36 hours of admin time per year on price list distribution
- Credit notes from pricing errors: ongoing, hard to attribute precisely
A centralised pricing system converts that recurring cost into a one-time setup. The update workflow that takes hours now takes minutes. The errors that generate credit notes stop happening. For a business doing R5M+ in monthly revenue, the margin protection alone justifies the investment.
Start your 14-day free trial and experience what a price update looks like when it takes 10 minutes instead of two days.
Related Articles
Ultimate Guide to Stock Management Systems for South African Businesses
Complete guide to choosing the perfect stock management system for your South African business. Compare features, pricing, and implementation strategies for optimal inventory control.
Sales Rep Software Comparison: Top 10 Solutions for 2025
Compare the top 10 sales rep software solutions for 2025. Detailed analysis of features, pricing, and capabilities to help you choose the perfect sales management platform.
Commission Calculation Made Simple: Tools & Best Practices
Master commission calculation with our comprehensive guide. Learn formulas, tools, best practices, and common structures to optimize your sales compensation strategy.
Ready to Transform Your Sales Operations?
Discover how SalesPro Hub can help you implement the strategies discussed in this article and take your sales performance to the next level.