How to: Import Supplier Prices from a Spreadsheet

With Merchanter you can quickly import prices from your favourite suppliers. Holding their current prices makes it quick to compare prices and simple to build purchase orders to maintain optimum stock levels.

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.

Individual product buy prices can be logged against a product for a supplier, or set from previous purchase orders.

View the full how-to guide and tutorial video on our Knowledge Base.