Summary
• Save and rename the price file
• Import Data
• Update Price File
• Update Stock from Price File
1. The manufacturer may supply the MG Price file in various formats.
The best file/format to use for importing into Autoline is the file called DLRPRC with header.CSV. Save the file as it is but rename to just mgprice.csv in the folder C:\rev8work
If the file with header is not available, use the file DLRPRC.CS1 and rename it to DLRPRC.CSV
make sure to add some header row to it
2. The file supplied should be in the format below. There should be a header on line 1
3. Import and run the Generic Price File
Go to Manufacturer Systems - 00, Parts Price File Menu, Generic Price File Import.
Select the Franchise MG from the dropdown. Click on Import Data
Click on Update Price File, Then OK
It is possible that there can be import errors as per the example below. In this case, make a note of the error and select skip. Errors should be reported back to the supplier for them to correct in their file.
In this error, an extra field has been inserted pushing everything out of alignment from ST onwards
When you are happy with the price file, update the stock file in MS/00 Parts Price File Menu
Select the Franchise that you are updating. In this case, MG. Click OK.
Select the applicable companies to update. (If you select all companies, only parts with stock will update.)