Recording Competitor Pricing in Merchanter

Merchanter enables you to track and compare competitor pricing directly within your product records. This feature helps maintain market awareness by recording what competitors are charging for equivalent products, with visual indicators highlighting price differences and data currency.

Accessing Competitor Price Tracking

First, make sure you are logged into the system as a user with a role of at least Products - Low. 

Navigate to the product you wish to add a competitor price to, and select the Prices tab. 

Within this section, you will now find functionality to record and view competitor price information alongside your own pricing data.

Adding Competitor Price Entries

You can store multiple competitor price entries against a single product.

To add a new competitor price, Scroll down the the pricing section and click the + Competitor Price button. 

In the pop up that opens fill in the fields:

• Competitor name or identifier
• Their current price for the equivalent product
• The date this price was observed or verified

The system retains a complete history of competitor prices, allowing you to track changes over time.

Viewing Competitor Price Information

In the product pricing section, the most recent competitor price automatically displays directly beneath your base price line for quick comparison. The date the price was verified and the price difference against your base price are displayed.

A complete table of all recorded competitor prices appears further down the pricing tab, showing full historical data. Including the price difference and the user who recorded the competitor price.

Colour-Coded Date Indicators

To help identify potentially outdated information, competitor price entries include visual date indicators:

• Standard display for prices recorded within the last 30 days
• Orange warning colour for prices between 30 and 90 days old
• Red warning colour for prices older than 90 days

These visual cues help your team quickly assess the relevancy of competitor pricing information during sales discussions and pricing decisions.

Price Comparison Percentage

The system automatically calculates and displays a percentage comparison between your price and each competitor's price:

• Green percentage indicator shows when a competitor is charging more than your price
• Red percentage indicator shows when a competitor is charging less than your price

This immediate visual comparison helps identify competitive positioning at a glance.

Editing and Deleting a Competitor Price

If you need to edit or delete one of the competitor prices, double-click on the record in the competitor history table and the Price pop-up will open, here you can amend any of the fields required and save the changes or click the Delete button to remove the price from the history table.

Competitor Pricing During Order Entry

The same competitor price table also appears within the order line price Detail information pop-up during sales order creation. 

This allows your sales team to capture competitor pricing information directly at the point of order entry, ensuring market intelligence is gathered during customer conversations and updated in real time. 

Just click the clock button on the sales order line

and then scroll to the price history section and click the + Competitor Price button.

Practical Applications

This feature supports various business processes:

• Sales negotiations with the current market context
• Strategic pricing adjustments based on market position
• Historical tracking of competitor pricing strategies
• Quick reference during customer consultations

By integrating competitor pricing directly into your product records, Merchanter helps ensure your team has relevant market information available when making pricing decisions and discussing options with customers.

OData

The latest competitor pricing data you record against products can also be accessed through the Merchanter OData feed. This enables you to include competitive market intelligence in external reports, dashboards, or business analytics tools, extending the value of your captured data beyond the Merchanter interface.

Available OData Fields

The products' OData table now includes the following competitor pricing attributes:

• CompetitorPrice_Competitor – The name or identifier of the competitor
• CompetitorPrice_Price – The recorded competitor price for the product
• CompetitorPrice_PriceDate – The date the price was observed or verified

These fields are returned alongside standard product information when querying the product OData endpoint.

Use Cases for OData Competitor Data

With competitor pricing available via OData, you can:

• Build external dashboards tracking market position over time
• Create regular reports highlighting products where competitors are undercutting your prices
• Analyse competitor pricing trends to inform strategic decisions
• Integrate market intelligence into business intelligence tools
• Identify products most frequently targeted by competitor pricing activity

Further Assistance

For more detailed guidance on working with OData in Merchanter—including query syntax, authentication, and advanced integration scenarios—please refer to the dedicated OData - Merchanter guides available in our knowledge base.

Bulk Uploading Competitors' Prices

For situations where you need to add or update multiple competitor prices at once—such as initial data entry, regular market updates, or large-scale competitor price refreshes—Merchanter provides a bulk upload feature. This allows you to import competitor pricing data efficiently using a formatted Excel spreadsheet.

Prerequisites

Before using the bulk upload feature, ensure the following steps have been completed by your system administrator or Ten-25 Support:

1. Run MX Reflection Update – This system process ensures the import functionality is properly registered.
2. Import the Excel Importer Template – The template file ExcelTemplate_Competitor Price Import 1.1_2026-02-10_1801.xml must be imported into your Merchanter system. This defines the structure and mapping for competitor price imports.

Preparing Your Spreadsheet

Create an .xls file and call it CompetitorPrice-Import.xls with the following columns:

• Code – The product code for which you are recording a competitor price
• Price – The competitor's price for that product
• Competitor – The name or identifier of the competitor
• Date – The date this price was observed (format: DD-MM-YYYY)

Each row in your spreadsheet should represent a single competitor price entry for one product.

Example of good data for upload

You cannot upload 2 entries for one product. But you can do a 2nd upload.

For example, this would cause an error. But split it into 2 uploads, and it will work.

Performing the Bulk Upload

With a user with high enough permissions, navigate to Products - Bulk Pricing within Merchanter.

Click the Import Competitor Prices button in the top right of the Bulk Price Changes screen.

The system will locate the previously imported template and prompt you to select your prepared spreadsheet.

Click the browse button, navigate to your Excel file and select it.

Next, click Import to bring in the competitor prices.

The system will process the file and add competitor prices according to your spreadsheet data.

After the Import

Once the import completes:

• Verify that the competitor prices appear correctly on the relevant product records
• Check the competitor price history tables to confirm all entries have been added
• Review any error logs if the import reports issues with specific rows

Important Considerations

The import will add new competitor prices based on the combination of product code, competitor name, and date.

Ensure your spreadsheet uses the exact column headers shown above—any variation may cause the import to fail

Large imports may take a few moments to process; do not navigate away from the page until completion is confirmed

This bulk upload feature saves significant time when managing competitor pricing at scale, supporting regular market updates and initial data population during system setup.

Video Guide