The customer web price import function will import prices from a specified file, creating specific pricing for the customer based on the file contents.
Select the file (with the correct format) to import and the expiry date to set for the customer-specific prices import.
The format of the file to be imported is as follows:
Delimiter, the field separating each field: |
Fields to be included and order
Customer Account Number
Inventory Group
Product Code
Selling Price multiplied by 100 (i.e., 1.00 = 100)
Example of a valid file format
A02|001|001PB-CAR|1135
A02|001|001PW-COM|1349
A02|001|001PB-COM|1710
A02|001|001P-SPEC-COM|1710
A02|002|002B|1981
A02|002|002-SPEC|1981
A02|002|002W|1710
A02|005|PK01|1800
A02|005|PK02|1800