Hi J. Ganther:

Depending upon your version of the software you are using, it will vary the import line number 1 of the .csv file. For the current version of Sage 50 2021.1.1 your first line should be:     28101,1,Price Lists

The number in bold needs to changed with each new version of Sage 50 software in the .csv file. To determine the version number do an export of the data you wish to change in your current version of Sage 50 software. Open the file in Notepad to see the version. Change the version number in your .csv file and try the import again.

I exported the file from the main screen and it saves as a .txt file. When I opened it, the file does say 28101,1,Price Lists

But how do I check and amend the line in the .csv file? Or do I need to ask the company that provides my IT support? 

Hi J. Ganther:

To amend the file open it in MS-Excel and change cell A1 to the proper version. Save as a .csv and then try and import the pricing changes into Sage 50.

May I ask if there is some reason the internal price adjustment module does not work?  You can get to it on the Maintenance menu as one method.

Without knowing exactly how you edited in Excel and which method of export (File, Save As) and what the first line in your file actually indicates, it's hard to say how it went wrong.  I always use the CSV (Comma delimited) (*.csv) format (right above *.prn).  It may not be perfect but I edit in Notepad if necessary (sometimes double quotes in the descriptions can throw everything out of line).

If the one you exported and the new file you created don't have the same format, it may not import.