Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Merchanter
English (UK)
US English (US)
GB English (UK)
  • Home
  • How to use Merchanter
  • Products

How to update Product Base Prices in bulk

Gain insight into how to effectively manage bulk base price updates and improve efficiency.

Written by Ian Oldrey

Updated at April 27th, 2023

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Getting Started
    Training Sessions
  • How to use Merchanter
    Sales Invoicing & Credits Products Purchasing Stock Control OData System Settings & Administration Milling & Value Added Processing Sales Order Processing Customers System Release Updates Pricing & Costs Certification Order Picking Agency Sales
  • API Documentation
  • Integrations
    Sage 50 Woo Commerce ECS Webshop Link NearSt QuickBooks Xero ShopWired
  • FAQs
  • Industry Articles
+ More

Table of Contents

1 Introduction 2 Retrieving Objects 2.1 Retrieving All Objects 2.2 Retrieving a Single Object 2.3 Retrieving Associated Objects 3 Counting the Number of Objects 3.1 Retrieving a Count of Objects 3.2 (Inline) Count 4 Filtering 4.1 Passing attributes 4.2 Comparison Operators 4.3 Arithmetic Operators 4.4 Functions 4.5 Combining Filters 4.6 Filtering by Association 5 Sorting 6 Selecting fields

How to update Base Prices in bulk

The Bulk Price update tools in Merchanter make it easy to either upload from a spreadsheet, or manually manipulate product Base Prices

Why is it called a Base Price

In Merchanter the key selling price of a product is called the ‘Base Price’.  Most businesses set the base price as the retail or highest selling price of the product, and use other pricing tools (agreements, automatic price tables, etc.) to discount back by customer type or quantity being purchased.  However some businesses make the base price the best price that they can sell the product at, and then add a supplement for the customer type, supply method, etc.

We would recommend making the base price the retail price of your products and thinking of it as that figure.

 

 

How to import base prices from Excel - video

 

Updating Base Prices manually

  1. Click on Products > Bulk Pricing > New+
  2. Complete the fields in the header
    1. Description - title for the products being changed.  Typically <range of products> <date range prices apply to> (e.g. Plasterboard May 2023)
    2. Start Date - when the prices will apply from
    3. End Date - when the prices will cease to apply.  Leave this blank to apply until a new price is applied
    4. Price Type - this is Base Price by default, but can be an uplift from cost price
    5. Special Offer? - set if these price changes are a limited time special offer (remember to set an end date)  This will set these prices to override any automatic price table discounts, and flag the price changes as special offers (shows in KPIs)
    6. Use Price Tables? - should these prices work with the price tables, or bypass them?
    7. Test Adjustment - this is a sample percentage adjustment to apply to prices.  This makes it quick to apply a common adjustment to a range of products (e.g. update prices by 5%), or show the revised prices at <n>%, so you can decide on a manual price for each product
  3. Once you have completed the header fields navigate to the bottom of the page
    1. You will see all the products with their current base price, and the calculated price if you have put a test adjustment in
    2. Use the filters to look at the ranges of products
    3. If you want to apply the test adjustment base prices to all the products in the selected range, click on ‘Use Calculated Prices for ALL PRODUCTS’
    4. Alternatively highlight individual product lines with a single click and once you have made your selections click on ‘Use Calculated Prices for SELECTION’
    5. Alternatively if you enter a price in ‘edit price’ column it will automatically be added to the new prices table (above)
  4. All the product prices you select to change will appear in the middle table, below the header fields and above the product selection table
    1. You can continue to manually amend the prices once they are in the new prices table
  5. When you are ready to progress click one of the buttons at the bottom of the page
    1. Void - cancels the Draft Price Adjustment job
    2. Make Prices Live - this ignores the Start Date and applies the new prices immediately (use with caution)
    3. Save and Close - Saves the Price change job at the current status (Draft)
    4. Confirm Future Price Period - Save the new prices and set ready to apply on the start date

How to import Base Prices from Excel sheet

  1. Click on Products > Bulk Pricing > ‘Import Prices from Excel’
  2. Create a spreadsheet with columns
    1. Column A - Product Code (Merchanter main product code)
    2. Column B - Base Price (new Base Price)
      It is ok if there is data in the other columns of the spreadsheet as this will be ignored
  3. Save as <name>.xls - this should be an older format .xls, not the current .xlsx
  4. Browse and upload the file.  This will create a draft bulk price adjustment as per the manual creation, but with the product prices already set
  5. Complete the fields in the header

    1. Description - title for the products being changed.  Typically <range of products> <date range prices apply to> (e.g. Plasterboard May 2023)
    2. Start Date - when the prices will apply from
    3. End Date - when the prices will cease to apply.  Leave this blank to apply until a new price is applied
    4. Price Type - this is Base Price by default, but can be an uplift from cost price
    5. Special Offer? - set if these price changes are a limited time special offer (remember to set an end date)  This will set these prices to override any automatic price table discounts, and flag the price changes as special offers (shows in KPIs)
    6. Use Price Tables? - should these prices work with the price tables, or bypass them?
    7. Test Adjustment - this is a sample percentage adjustment to apply to prices.  This makes it quick to apply a common adjustment to a range of products (e.g. update prices by 5%), or show the revised prices at <n>%, so you can decide on a manual price for each product
  6. Once you have completed the header fields navigate to the bottom of the page
    1. You will see all the products with their current base price, and the calculated price if you have put a test adjustment in
    2. Use the filters to look at the ranges of products
    3. If you want to apply the test adjustment base prices to all the products in the selected range, click on ‘Use Calculated Prices for ALL PRODUCTS’
    4. Alternatively highlight individual product lines with a single click and once you have made your selections click on ‘Use Calculated Prices for SELECTION’
    5. Alternatively if you enter a price in ‘edit price’ column it will automatically be added to the new prices table (above)
  7. All the product prices you imported will appear in the middle table, below the header fields and above the product selection table
    1. You can continue to manually amend the prices once they are in the new prices table
    2. You can add other products manually by navigating to the bottom table and selecting (see section on manually adding base prices)
  8. When you are ready to progress click one of the buttons at the bottom of the page
    1. Void - cancels the Draft Price Adjustment job
    2. Make Prices Live - this ignores the Start Date and applies the new prices immediately (use with caution)
    3. Save and Close - Saves the Price change job at the current status (Draft)
    4. Confirm Future Price Period - Save the new prices and set ready to apply on the start date

 

base prices bulk pricing excel import product pricing

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Product Barcode setup on Merchanter
  • Average vs. Last vs. Standard Cost Prices
  • Adding product alert notes to products
  • Manually removing empty Lots
Solution Vendor Color.png

sales@ten-25.co.uk

01202 861606

Peartree Business Centre, Cobham Road, Ferndown, BH21 7PT, United Kingdom

BMF Service Member logo.jpg
  • linkedin
  • twitter
  • facebook
Privacy Policy

©2020 by Ten-25 Software Ltd.. Proudly created with Wix.com

Expand