HOW TO IMPORT SUPPLIER PRICELISTS?

---

Introduction

Big companies use to import supplier pricelists day to day. Indeed, prices are always changing and you need to get price up to date to deal with a high number of products.

Now we learn how to import pricelists.

Required configuration

In purchase settings, you have 2 options:

- Manage vendor price on the product form

- Allow using and importing vendor pricelists

Here we are selecting: Allow using and importing vendor pricelists

(a)

Import vendor pricelists

There are 2 scenarios: import the vendor pricelist for the first time, or update an existing vendor pricelist. In both scenarios, we assume your product list and vendor list is updated and you want to import the price list of vendors for a given product.

To import a list from a document, the best pratice is to export first to get an example of data formating and a proper header to reimport.

(a)

(b)

Import the list for the first time

Prepare the document

In Purchase ‣ Purchase ‣ Supplier Pricelists, export a template of document to get import/export compatible and get the right format to import in mass. Create manually a data and export it (select ‣ Action ‣ Export)

(a)

Here is the list of fields you can import:

(b)

(b)

YImport this document in KIU ERP. Click on Import in the list view and upload your document. You can validate and check error. Once the system tells you everything is ok, you can import the list.

(a)

(a)

After the import, the Vendors section in Inventory tab of the product form is filled in.

Update the vendor pricelist

When the pricelist of your suppliers change, it is necessary to update existing prices.

Follow the procedure of the first scenario in order to export existing data from Purchases ‣ Purchase ‣ Vendor Pricelist. Select everything, and export from the Action menu.

Change price, end date, add a line, change a supplier,... and then reimport in KIU ERP. Thanks to the ID, the list will be updated. Either the id is recognized and the line is updated or the ID is not known by KIU ERP and it will create a new pricelist line.

After the import, the Vendors section in Inventory tab of the product form is updated.

(a)