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
  • Purchasing
  • Supplier Price Lists

How to add Supplier Price Lists to Merchanter

This is a how to guide on uploading spreadsheets of supplier prices into a Merchanter system

Written by Ian Oldrey

Updated at December 21st, 2022

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

Once loaded into the system the prices will help anticipate price changes, can ensure purchases are placed with the lowest price supplier, and can be used to automatically drive selling prices.

 

The 10 minute video gives a demonstration of extracting a spreadsheet of products, mapping and importing the new prices into the system.

Ways to import supplier prices

There are two ways to import spreadsheets of prices into Merchanter:

 

1) Supplier spreadsheet - use a spreadsheet from a supplier and map the columns and rows as part of the import process. This template for each supplier can be reused the next time they send you a spreadsheet, assuming it uses the same layout.

 

2) Product spreadsheet - export a spreadsheet of products from Merchanter, revise the purchase prices and import back into the system. This is the example used in the video.

 

Adding a new price list

In Purchases > Supplier Price Lists

Click 'New' button

New pricelist header

Supplier - select supplier for this import. Each spreadsheet import is for one supplier's products

Currency - defaults to your home currency. Only one currency per upload.

Price Method - Priced is for spreadsheets with your buy price against the products. PriceLessDiscount is for spreadsheets with an RRP/MRP to which you receive a reseller discount

Discount percentage - sets the discount from the RRP/MRP you receive if using PriceLessDiscount

Valid from - the day the prices come into effect, defaults to today

Valid to - the day the prices are valid until

Description - a text description for viewing multiple price lists in a table. We would recommend using <Supplier Name> <Range of Products> <Date Range> as the description, for example "Acme Supplies Adhesives Jan 22", but you can type any description you would like

Once completed click 'Import Spreadsheet Prices'

 

Mapping a new spreadsheet layout

 

If you are mapping a new layout of spreadsheet you will need to follow this process:

Leave the spreadsheet open so you can view the relevant columns and rows

Click '+ New' to start a new template

Edit the template name to be the supplier name and a version (for example 'Acme Supplies v1')

Headings row - the row that contains the field headings and won't be imported as data

Import from row - the number of the first row to contain price data

Unknown product - This works two ways. Ignore will skip any lines where a match to your products cannot be found. This is useful if importing prices for a full catalogue, where the business only trades a few of the products. Prompt user will match any products is recognises and ask the user to lookup the products it doesn't recognise to manually match them. This is useful where you trade the full range of products from a supplier and they add a few new products with the price list.

Product Identification - Add in the columns that contain the Supplier product code; EAN; Barcode; Description; Internal Product code. Leave blank if not on the spreadsheet (there should be at least one entered). The system will try an match on Internal product code, then supplier and barcodes, then description. This is in order of how likely they are to match products in your system.

Price Information - enter the columns that contain the price information. List price is the RRP/MRP, Price is your buy price, Price per number is the number of items the price relates to and can be used to calculate a price per each. Price per unit is used to match the price unit on the system, MOQ is the minimum order quantity. Using this the price list can be used to bring different prices for quantity purchases of the same product (i.e MOQ 1 = £3 each, MOQ 10 = £2.50). Valid from & to are if a line has a different valid period to the values in the header.

Once you have mapped the template, close the spreadsheet

Click on 'Browse' at the top of the screen and select the spreadsheet from your computer

Click 'Import'

 

Uploading a spreadsheet with existing template

 

If you have previously mapped a a template to a spreadsheet layout, it is a quick process to upload the data:

Click on 'Browse' and select the spreadsheet from your computer

Import config - select the template from the drop down. Should be the name of the supplier

Click 'Import'

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Bulk Import Documents and CSV Linking Configuration
  • Confirming Delivery of a Sales Order
  • Managing Minimum (Min), Target and Maximum (Max) Stock Levels on a product/depot
  • How to Assign a Driver to a Sales Order
  • How to Setup a Milling Process to Add Cost by Time
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