Manually update a price list

Introduction

When a supplier updates their prices, these will either be sent by email or posted on their FTP server. Customers who do not receive automatic updates of price lists via an ERP system will have to manually update their price lists in Handyman Office. This article describes how to manually update a price list.

Environment

Handyman Office

Procedure

1. Download the price file and the discount file from the supplier and save them in an easily accessible folder, eg 'Downloads' or 'Documents'.
2. The process consists of 3 main steps:
   1. Delete existing price list (price - and discount file)
   2. Read new price - & discount file
   3. Import .CSV file (alternative format)
   4. Create the price list

Delete existing price and discount file

1. Navigate to the Logistics module > Supplier (1) > and select the supplier to be updated (2).
2. Select "Supplier's catalogue" tab (3)
3. In the "Supplier's catalog entries" menu on the left, click "Delete all.. (4)" to delete the existing price list
4. In the "Supplier" menu, click "Import supplier's catalogue"
5. An application called "Handyman article import" is opened
6. Navigate to "Discount" (1) to add the discount file
7. If the correct supplier is already selected in the dropdown list, remove the selection by choosing another supplier, and then select the correct supplier again. This is to update the discount file list (2)
8. Click "Delete All" (3)

Read the price file

1. Navigate to "Itemlist"
2. In the Supplier dropdown menu, select the correct supplier from the list. ("Delete all" should now be disabled to indicate that there are no existing items for the supplier)
3. Click "Read item file"
4. Locate the price file you downloaded earlier, and select it > Click Open
5. You should now see article items in the list below, and also name of the file you selected in "File Name"

Read the discount file

1. Navigate to "Discount" menu to add the discount file
2. In the dropdown menu Supplier, select the correct supplier from the list. ("Delete all" should now be disabled to indicate that there are no existing discounted items from the supplier)
3. Click "Read discount file"
4. Locate the discount file you downloaded earlier, and select it > Click Open
5. You should now see the list below being populated with items

Create the price list

1. Navigate to "Pricelist" (1)
2. Select the supplier from the Supplier drop-down (2)
3. If a list of article items is populated below, please click "Delete all" before continue to the next step
4. Choose to create the price list based on "list price + markup" or "cost price + markup" by selecting the point next to the appropriate option. (3)
5. Click "Update prices" (4)
6. This process may take some time, and it may appear that Handyman is crashing. If the application banner says "not responding", it means it is still functioning. Please have patience.
7. When done you will see the newly created price list being populated in the section below the "Drag a column header here to group by that column"
8. Close the window/application
9. You are done!