<< Click to Display Table of Contents >> Navigation:  Welcome to Maxim Help Articles > IVSPC Supplier Price Update

This program allows you to bulk update Suppliers prices, via importing a CSV (Comma Delimited .csv) file with the new prices.

 

There are 3 methods to importing supplier price updates:

 

1.        Standard Import – This will be used my most users.

 

The following 2 import methods are to be used by advanced users only.

 

2.        Supplier Barcode Only

 

3.        Internal Price Update

 

NOTE: You can only import 1 Suppliers prices at a time. The supplier is selected when you run the import.

 

Standard Import

 

There are 3 options for importing Supplier prices updates:

 

The products in the import file are validated against the “Supplier Product Link” record (IVSPL), if the imported price update can’t be matched against a Supplier Product Link then the product will be added to the error report.

To learn more about the Supplier Product Links click here.

 

Below is the file layout for the each of the 3 methods for importing price changes:

 

By Supplier Product Code

 

 

By Supplier Barcode

 

 

By Maxim StockNbr

 

 

 

 

Supplier Barcode Only

 

With this option, a match is made using only the barcode. 

 

The products in the import file are validated against the “Supplier Product Link” record (IVSPL). When the product is validated the Supplier Link Record (IVSPL) and the Stock Location (IVLOC) records are updated with the Supplier Code, if the imported price update can’t be matched against a Supplier Product Link then the product will be added to the error report.

To learn more about the Supplier Product Links click here.

 

A price change record will be created if a matched Supplier Product Link (IVSPL) record is found and the following is true:

 item

 from the existing retail price.

 records are used, the price change record is created using the pricing default Retail

 Markup %

 

The new retail price is calculated using the retail markup percentage on the latest Price(IVPPR) record.

 

Multiple price change records will be created where there are multiple sell prices for an item.

Valid price changes will appear in the Price Changes screen. Prices can be verified and committed through the price change process.

 

Import File Layout:

 

 

Note: Where the product masterfile is shared by multiple companies and pricing is controlled centrally, it is recommended that the price changes are run for each operating company, as the same supplier in each of the operating companies may have a different supplier client code. If a central supplier client file is used or it can be guaranteed that the supplier client codes are the same in all operating companies, the price update can be run from the group company and all operating company price files will be updated.

 

 

Internal Price Update

 

Internal Price Update will select the 'Internal Customer Code' as the supplier; as set on the Sales/Despatch Option screen. The internal customer must be established also as a supplier.

 

A supplier link record for the product for the internal supplier will automatically be created. The preferred supplier for the product will not be updated to the internal supplier code.

 

Import File Layout: