Automatic Price Linking: Synchronize Your Linked Prices with a Single Click
On this page
Do your formats remain consistent when a price changes?
Let's plan an exchangeDiscover our product matching solutionAutomatic price linking involves linking the price of an item to that of a reference item according to a predefined rule, and then allowing the system to automatically pass on any changes to the reference price. For example, the price of a family-size item can be linked to that of an individual-size item using a fixed ratio.
The Essentials
- Automatic chaining propagates a change in the master price to its variants without requiring a human to manually update each SKU.
- Rules that have remained unchanged for years, even as the costs of different formats have diverged, ultimately result in absurd prices.
- It requires you to specify the base price and the rule that links the others before letting the system apply them.
In 6 Questions
A rule that links the prices of multiple SKUs to a reference price.
Pricing teams and category managers.
Every time the pilot price is updated.
Regarding variants: sizes, colors, and scents of the same product.
Ensure consistency across scales and save time.
Ratio, deviation, or formula, applied by the pricing engine.
Why Automate Price Chaining?
Because a single change in the base price must be accurately reflected across dozens of variants.
- Ensure consistency across sizes: the large size must remain less expensive per liter, as the customer expects.
- Reduce management time: A change to the driver is propagated to all 12 or 30 chained variants.
- Ensure business rules are followed: scale by format, consistent spacing between sizes, fixed ratio between colors.
Real-life example: a laundry detergent available in three sizes
When the price of the 1-liter bottle goes up to €7.20, the price of the 2-liter bottle automatically goes up to €12.60 and the price of the 5-liter bottle goes up to €27.36.
One introductory price, three formats updated together
Laundry Detergent · 1 L / 2 L / 5 L sizes, grouped by ratio
to apply the new pilot price to all three formats, without omissions or errors in the ratios.
The rule is simple: 2 L = 1 L × 1.75 and 5 L = 1 L × 3.80. Without formula linking, these three prices would have to be updated manually, with the risk of omissions or errors in the ratios.
How do you set up automatic chaining?
In four steps, from selecting families to configuring the pricing engine.
Identify eligible families
Different sizes, colors, or scents.
Select the pilot reference
Ideally, the best-selling item in each product family.
Write the rules
A multiplicative ratio, an additive difference, or a more complex formula.
Configure the engine
Applied with every update, with traceability for auditing purposes.
By extension, the term also refers to the automatic alignment of equivalent products across catalogs, which falls under product matching (see competitive monitoring and product matching). Both are covered by our product matching, cloning, and chaining solution; the rules are executed in our MPS pricing solution. See also horizontal chaining and vertical chaining.
Chaining can also be prepared by AI. At Booper, the Booper Mind agent offers to create, complete, or correct groups of formats and variants—along with their pilot references—and the user then validates each group.
We'll share what we've learned from having an LLM handle the chaining of scales.
3 Mistakes to Avoid in Automatic Chaining
A rule that goes against customer logic, has never been reviewed, or is based on a flawed prototype.
- Don't just buy whatever's on sale: make sure the large size is still cheaper per liter.
- Forgetting to review the rules when purchase costs vary by format.
- Relying on a secondary driver: A driver with poor sales drags down the whole team.
Frequently Asked Questions
Short answers to the most frequently asked questions about automatic chaining.
What is automatic chaining?
Automatic price linking involves programmatically linking the price of one SKU to that of another SKU according to a predefined rule, and allowing the system to automatically apply the update when the price of the master SKU changes. For example, the price of a family-size item can be linked to that of an individual-size item using a fixed ratio.
Why is automatic chaining useful in pricing?
Because it ensures price consistency across variants of the same product, without relying on individual vigilance. When the price of the single-serve size changes, the family-size follows according to the established rule, without the need for manual updates. Manual updates are eliminated, and with them the errors and oversights that result in a larger size costing more per liter than the smaller one. Business rules are then applied systematically across the entire catalog and with every price change.
What is the difference between manual and automatic chaining?
The difference lies in the time required and the risk of error. Manual chaining requires recalculating each variant by hand whenever the master item’s price changes, which is time-consuming and prone to errors, especially with a large catalog. Automatic price chaining instantly applies the rule to all linked SKUs, with a record of each update: you know which price changed, when, and because of which SKU. This traceability makes it easier to conduct audits and provide explanations to stores.
What kind of ruler should I use?
It all depends on how the prices are supposed to change together. A multiplicative ratio is appropriate when they need to change in proportion—typically between different sizes: the package price maintains a fixed ratio to the unit price. An additive spread is appropriate when the difference in euros must remain constant, for example between a standard version and its variant with an option. A more complex formula is justified for specific cases, provided that it remains understandable to the teams who will be implementing it.
What happens if the pilot item is out of stock?
This is the most common edge case, and it must be explicitly addressed. If the benchmark disappears, the rule loses its basis: the chained price either freezes at its last value or switches to a replacement benchmark designated in advance. Without this fallback rule, the chain produces inconsistent recommendations as soon as the first break occurs.
Can an automatic chaining conflict with another rule?
Yes, regularly, due to margin floors and competitive alignment constraints. Price linking establishes a ratio between two prices, while a margin floor sets a minimum value: for an item whose purchase price has risen, the two become incompatible. The order of priority among these rules must therefore be defined before the system goes live, not discovered through use.
How many items should be listed consecutively in a catalog?
As much as the job requires, provided you can explain each link. A network of links that’s too dense becomes unreadable: no one knows why a price changes, and teams stop following the recommendations. The rule of thumb is to create links where the consistency is visible to the client, and to leave the rest unlinked.
Key Takeaways
- Automatic linking uses a rule to link prices to a reference price.
- It ensures consistency in scale across variants and prevents omissions.
- The rules are reviewed when costs change, based on a representative pilot project.
Would you like to automatically chain your prices without manual errors?
Booper applies your chaining rules to the entire your catalog site, on an ongoing basis.
Let's talk about your chaining rules →Discover our product matching solutionThese articles can interest you
A pricing alert is a notification that is triggered when a price falls outside a predefined range and prompts a designated person to take action. The workflow follows this sequence: who processes it, within what timeframe, and who approves it. In retail, six alerts cover the essentials, ranging from “ below-cost resale threshold ” to local prices falling outside their ranges.
Thresholds should be set based on the team’s processing capacity, not just on risk; otherwise, alerts will be ignored. Workflows must remain short: only issues that fall outside the thresholds are escalated. A good metric is the percentage of alerts followed by a price change.
A pricing tool project is based on a pricing decision that takes effect today, not on a list of features. The scope defines this decision—an initial, representative but narrow scope—and determines the price once the tool is in place.
The generalization criterion is defined before the test and is evaluated against a control set. There is no requirement to go through an intermediate step between a spreadsheet and a more advanced tool: this often doubles the scope of the project without reducing the risk.
Product matching is the foundation of competitive monitoring: it prevents companies from lowering prices based on a false price difference between two non-equivalent products. Cases of doubt are referred to business-unit review.
According to Diamart Group (2026), about 50% of French retailers still perform their price matching manually, while 94% collect competitive data.