How to automate pricing in eCommerce without losing control

Price should be a decision backed by strategy. But at mid-sized and larger retailers, prices are usually managed in several places at once. Some prices are kept in Excel, some in the ERP, others in the eShop, and then there are the channel feeds. Pricing and category managers spend most of their energy making sure the right value applies everywhere, and there’s no time left for strategy. Then the company decides to grow. A new channel or a new market brings more prices to maintain by hand, and time gets even scarcer.

Maybe this sounds familiar. A supplier raises the purchase price on a key product line. At the same moment, marketing is preparing a discount on the eShop. On top of that, someone is dealing with the extra fees of a marketplace you’ve just started selling on. Meanwhile, sales is opening a new market with a different currency and different VAT. Each of these changes is simple on its own. The hard part is figuring out everywhere it needs to change, because the whole process is opaque, split into parts that don’t know about each other, and mostly manual. So the website, the feed, the B2B offer and the local price list slowly drift apart.

This article is about pricing in the day-to-day operations of a growing company. First, we’ll look at why you need a pricing strategy and data in place before you start automating. Then we’ll look at what’s worth automating in pricing and why product and price belong in one system. And because even the best automation can’t do without people, we’ll show how to keep human control over automatically calculated data. You’ll find a practical checklist at the end.

We’ve deliberately left out made-up numbers, anonymous “studies of hundreds of companies” and promises that AI will solve everything. What we mainly want to show is that without unified data and managed price automation, a company sooner or later hits a scaling ceiling. And that human control is an essential part of the whole system.

Why manual pricing isn’t enough for a growing company

Companies calculate prices by hand mostly for historical reasons. One price list, one eShop and a few exceptions on paper used to be enough, and a salesperson could click the rest into the ERP if needed. The business grew, but the process stayed the same. That’s why this way of working now hits a ceiling and gradually turns into a brake on growth. Adding more people to the team usually doesn’t solve it.

New channels and markets, same old processes

A typical mid-sized or large retailer today sells in several places at once. It has its own eShop, marketplaces, a B2B portal and sometimes partner channels too. And when it adds another country, a new currency comes with it, along with VAT, local terms of trade and shipping. Add different competitors and customers who expect something different from prices and discounts.

So every new channel and market multiplies the exceptions. What used to mean “update the price list and send the feed” is now a web of dependencies. A different margin on the marketplace, a different B2B price level, different cost prices for items and shipping, a different exchange rate, plus promotions and strategies adapted to different competitors. A process built for one channel and one price list can’t handle that. And the pricing team was sized for a different reality.

The second dimension is the breadth of the range. Unless they’re a manufacturer, retailers usually want to offer as many brands as possible, so customers are sure to find what they’re looking for. Breadth matters so much that more and more retailers combine different ways of buying stock. They buy key bestsellers in advance for their own warehouse, order other goods from the supplier only once a customer shows interest, and some add dropshipping on top. Each of these models means a different price calculation, though. For goods bought in advance at a fixed price, the purchase price is known up front and the selling price is derived from it. For goods ordered on demand or dropshipped, the cost depends on current stock and supplier price lists at the moment the item goes into the cart. That can suddenly triple the number of variants pricing has to work with.

So growth comes down to three options. Keep hiring, automate, or drown in operations.

Typical operational problems

The pains companies actually deal with in pricing are very specific, and they repeat across mid-sized and large sellers, whether manufacturers, distributors or resellers.

Excel as the system of truth. The official price usually kept in a spreadsheet with several versions and copies, named something like “final_final_v3”. Prices are copied between sheets and systems by hand, rounding introduces errors, and campaigns get added next to the base price list. In the end, nobody’s sure which version applies on which channel. Excel is a great tool for ad hoc analysis. As an operational system of truth for prices across channels, though, it stops being enough once the company starts growing, because versions multiply faster than the team can merge them.

Inconsistency between channels. The website shows one price, the feed another, and the B2B offer a third. Customers notice, sales handles it as a complaint, and the eCommerce team fixes it by hand. Every channel has its own export, its own timing and its own exceptions. Inconsistency is the price the company pays for manual, fragmented publishing.

A mix of purchasing models. Own stock with a fixed purchase price, goods ordered from the supplier only after the customer orders, and dropshipping look mainly like a logistics problem at first glance. For pricing, though, they’re three different strategies.

If a retailer doesn’t want to show the customer several delivery options for one product and wants to offer a single selling price, there are two options. Either keep everything in stock, or accept the risk that with a fixed selling price, the purchase price, meaning its own cost, isn’t under control.

Supplier price lists also change at very different rates, once a year for some ranges and every hour in other industries. That can’t be processed by hand anymore. To use this scenario at all, the retailer needs suppliers connected online and their changes reflected in prices automatically. And if it doesn’t use it, it loses competitiveness.

Multi-market rules handled ad hoc. Commercial success means knowing the market and the customer in detail. The usual and minimum acceptable margins, what competitors charge for the same item, who just launched which promotion: these are all factors you need to work with. Often one person keeps them in their head, and then it’s only a matter of time before they reach a number of markets and categories they can’t keep track of alone.

Product data separated from price. With few exceptions, the pricing team doesn’t think about the prices of individual products in isolation. They typically set a strategy for a whole category and then add exceptions that don’t fit the general rule. But when the product structure, meaning categories, attributes, variants and so on, is maintained separately from prices, shared rules have nowhere to apply. The pricing manager ends up copying Excel formulas from item to item, trying not to miss anything. And when something changes in the product data, nobody remembers to adjust the price.

A growing company basically has three options. It can keep hiring people to keep the manual system running, knowing it’ll need more of them with every new channel and every expansion of the range. It can automate what repeats and leave strategic decisions and control to people. Or it can let the team get buried in operations and react to the market later and later.

What to prepare before you automate pricing

Automation comes second, or really third. First, you need to be clear about what you’re going to automate and based on what.

Pricing strategy

The foundation is defining the price components your pricing strategy will work with.

Costs. It’s best to start with the cost of acquiring goods and to include truly everything. That means external components like supplier invoices, shipping, customs duties or exchange rates, but also internal ones: administration, warehousing, people, and allocated costs for software and running the company.

Costs also need to reflect every purchasing strategy the company uses. Typically that’s own stock with a price fixed at the moment of purchase, buying from a supplier with the price derived from currently valid price lists, and dropshipping. You also need to account for pre-stocking discounts, volume purchase discounts and supplier promotions. The goal is a cost price that matches reality as closely as possible, not just the sum of line items on supplier invoices.

The second group is the cost of selling, whether across the board or specific to a sales channel. That includes warehouse costs, delivery to a particular country or location, carriers in that country, again customs duties and exchange rates, packaging and so on.

Regular selling price. The last component is the selling price itself. It should always be based on costs; there are just several ways to get there.

Manufacturers usually set fixed selling prices, more precisely base selling prices and reduced versions for wholesale customers. They calculate the margin on top and, when costs change, check whether the selling price is still profitable enough and competitive (two sides of the same coin), or whether the cost change needs to be passed on.

Distributors are in a different situation. External cost makes up a large part of their price, and so a large part of their risk, so they usually set the selling price as cost plus a standard margin for the sales channel, product category and customer tier. When costs change, the selling price adjusts automatically according to the configured coefficients and surcharges.

Promotions. The regular selling price comes from long-term rules, and only occasionally does a coefficient go up or down. But the final price usually also reflects current decisions by the sales teams. Price positioning against competitors, promotional discounts, clearance sales and many other commercial incentives or adjustments to the selling price are exactly what lets a company respond to what’s happening in the market.

These mechanisms should be defined in advance, including how they affect long-term price lists.

Limits a price must not cross. Validations and margin guards are a topic of their own. No automated pricing should run without checks. Price rules need to be supplemented with minimum acceptable margins for a given market or segment, typical prices for the category, a threshold for how much a price can change from its previous value without someone reviewing it, and so on. The basics can then run fully automatically, and the system reliably alerts users to anything unusual or wrong. Users also need to be able to override the rules with their own settings at any time. In a specific situation, they’ll always understand the market better than a machine.

Data, data, data

A system is only ever as good as the data it works with. So before you start setting up rules, it pays to go through which data they’ll be based on and whether you actually have it.

Is your pricing based on supplier data? Then you need regularly updated price lists and catalogs. Does it work with stock levels? Then the ERP has to provide them in a form that can be used for automatic calculation.

Want to reflect competitor offers in your rules? Then you can’t do without automated monitoring of the market and selected websites.

A lot of the data doesn’t need to be perfectly precise, though. It’s better to estimate allocated operating costs than to leave them out of the price structure entirely, and the same goes for sales data. Even statistics uploaded once in a while are more useful than none.

Want to set rules by category, brand or other product attributes? The foundation is a good product catalog that provides this information. The catalog is a topic of its own, though, so let’s look at it in more detail.

Clear product identity and hierarchy

Without a clean catalog, price rules can’t be applied. If it isn’t clear what a product is and how SKUs, variants, packaging and bundles relate to each other, a rule like “X% margin on this category” or “Y discount on the marketplace for this line” doesn’t work. It also has to be clear which product is in stock, which ones have supplier offers, and what the costs and delivery terms are for each variant and supplier. Without that, the system can’t calculate the inputs it needs to set a price.

Automation on bad data doesn’t save time. It just spreads errors faster. Repricing a hundred SKUs based on the wrong identity, an outdated hierarchy or another supplier’s price list is worse than slow manual repricing, because the error is consistent and reaches the channels much faster. Good, up-to-date product data is a prerequisite, not “something we’ll finish later once pricing is running”.

As we’ve mentioned, price is so closely tied to product attributes that having the catalog and pricing in one system makes the whole situation much simpler. In practice, it can look like this:

  • When a category, brand, variant or availability changes in the catalog, price rules take it into account right away, and nobody has to copy formulas between items.
  • Users find purchasing strategies and supplier offers on the same product as the selling price.
  • A change in the range structure triggers a controlled recalculation or a block, so nobody has to remember in Excel which prices are affected.
  • eCommerce, purchasing and sales see the same information about the product and its prices (as long as they’re supposed to see it, of course).

WisePorter combines the product catalog and dynamic pricing in one tool precisely so companies can run their strategy on a single set of data, with automatic calculation and human control over the result. It won’t come up with your strategy for you. But it will help you apply it without another layer of spreadsheets, integrations and syncs.

Pricing automation that keeps people in control

Once you have the strategy, the rules and the data you need, it’s time for software. And with it comes the question of how much to hand over to it.

Automating everything doesn’t make sense. The machine should calculate and propagate what repeats. Strategic decisions, commercial responses and handling exceptions should stay with people. And control over automatically calculated data is exactly what it takes for the team to trust the system.

What’s worth automating first

Start with inputs and calculations that repeat and follow clear rules set by your strategy. Typically:

  • Updates to cost components (exchange rates, shipping, customs duties, internal contributions already in your price structure).
  • Passing supplier price list changes through for purchasing strategies where cost isn’t fixed by buying into stock.
  • Recalculating the regular selling price based on configured coefficients and tiers (manufacturer or distributor, each with its own logic).
  • Channel and market layers (own eShop, marketplaces, B2B, countries) and basic rounding.
  • Running the validations and margin guards already described in your strategy.

Automate competitor and market monitoring only once you have a reliable foundation for calculating price from internal factors and supplier data. Competitor prices then serve to fine-tune and optimize that foundation, so you’re not copying them blindly. Add more complex commercial logic only when the foundation is stable and the team trusts it.

Human control as part of the system

A system of checks, margin guards and the ability to override a rule with your own settings belong in the pricing strategy from the very start. As with any software, you have to earn users’ trust, and these are the elements that get you there.

So give users clear rules for what’s normal and what’s suspicious. Add active alerts for situations that need their attention. And give them enough ways to step into the automation with their own decisions. That might be a mandatory approval the system asks for in certain situations, a time-limited exception to a rule, or a manually set fixed price for a specific product or group of products.

Most important of all, every price should always show which components it was built from and which rule produced it.

When people don’t understand the automation, they start working around it in Excel. When they can see it, they can steer it and trust it, and it can grow with every new channel and market.

What to monitor after rolling out price rules

The work doesn’t end when a rule goes live. Watch whether margins still hold, how quickly a supplier price list change made it into prices, how many manual interventions sales has to make, and which errors validations flag most often. Then adjust your strategy and rules accordingly.

Metrics across the whole system help a lot too, such as the duration of individual steps or the number of changes over a given period. In short, anything that can flag an unusual situation before it reaches your customers.

How to proceed: a practical checklist

The checklist is meant to be worked through together with your eCommerce, purchasing and sales teams to see where you stand. Choosing software comes last.

Map the current state

  • Is your pricing strategy written down, or do a few people keep it in their heads with the rest in spreadsheets?
  • Have you defined the price components (acquisition costs, selling costs, regular selling price, promotions)?
  • Which purchasing strategies do you use (own stock / order on demand / dropshipping), and how is cost calculated for each?
  • Where does your data come from (ERP, supplier price lists, catalog, competitors), and how up to date is it?
  • Where is the “official” price created before it’s published to the website, the feed and B2B? And how many systems and files does it pass through on the way?
  • Do you have a system of checks (margin guards, validations, manual rule overrides), or do you only find errors once customers see them?
  • Where are the biggest delays and most frequent errors? In a channel, a market, a type of promotion, or when a supplier price list changes?

The result is a map of your strategy, your data and the places where manual work drives decisions today. It’ll serve you better than any presentation.

Decide where to start

Start with the data and rules you can already name from your strategy, and only then deal with publishing to channels. Leave promotions and fine-tuning in people’s hands, with approval and an end date. Expanding and improving makes sense only once the foundation works reliably.

Only then choose software

When choosing, how the system is designed matters more than how long its feature list is. Focus mainly on these areas:

  • Catalog and pricing on the same data.
  • Support for price components and different purchasing strategies.
  • A system of checks, an audit trail and the option to override a rule manually.
  • Channels and markets without duplicating master data.
  • Scaling without having to hire more people.

The question that separates a demo from real operations is simple. How quickly can I see why this SKU has this exact price on this channel, which components it’s made of, and which rule produced it?

Growth without price automation is a limit, not a strategy

Price is a decision that comes from strategy. But for mid-sized and large retailers, channels, markets, range breadth and different purchasing strategies outgrew manual processes long ago. That’s why price automation is no longer a competitive advantage. It’s becoming a necessity. Companies that still calculate prices by hand are at a disadvantage, and with the arrival of AI, that gap will keep widening.

Automation without strategy and data just speeds up chaos. Strategy without automation stays in Excel. The way forward is a clear pricing strategy, good data, catalog and pricing in one system, automatic calculation and human control over the result. All of it is worth building step by step, on solid foundations, so users can always see where each price comes from.

If you’re planning new markets or channels, now is a good time to get your pricing ready before their exceptions start slowing you down.

You can start by going through the checklist above with your team. If you’re thinking about how to approach price automation and what to tackle first, book a short consultation with us about your current process. It doesn’t commit you to an implementation, and if you’d like, we’ll also show you how it could work in WisePorter.

I'm keen to try WisePorter!

RELATED ARTICLES

How to automate pricing in eCommerce without losing control

WisePorter v1.10 Release Notes

How a Czech Team Took Control of Their Product Data