Import Export of Price List

Question

Hello - I have a client who currently uses Sage 50 Quantum. He wants to quickly adjust his inventory prices so I had suggested he export his Price List, make the adjustments there and then import the amended copy. When we try to import we get this error message 
 : 
 How do I figure out what why I am having a file version mismatch. We've tried exporting directly to an Excel spreadsheet and we've tried exporting a .csv file first. After testing and adjusting only a few line item prices we tried to import and both times we get the above message. I confess I am not very "techy" so any assistance would be greatly appreciated. 
 Thank you

Agate · Answer

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.

Agate · Answer

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.

Sage 50 Canada

Import Export of Price List

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING