There are Export and Import (Ledger) functions under the File menu.

Usually I export a few items to get the format, then add the items in Excel, check the format in Notepad, then import it back in.

If there are duplicate items they will be skipped over, rather than updated.

Things to keep in mind when setting up items:
- Sage 50 items are case-sensitive, so CHEV 1234567 is not the same as Chev 1234567.
- Don't allow negative inventory unless you understand what a mess it can make.
- If you use it anyway, set up a separate G/L expense account for variance.
- You only HAVE to fill in the G/L fields that have an asterisk.
- Use only one inventory G/L account unless you have an absolute need for more. (like the bank forces you to)
- Don't get too fancy with price lists. More isn't merrier, it's a lot of maintenance work and chances to make errors. Look at setting up invoice line item discounts instead.
- type-to-find in the description will find it anywhere in the description.
- Use 'service' items for things that you don't really need to track, but will buy and sell (lockwashers, marettes, etc.)
- Use 'Activity' items (Premium? Quantum?) for labour.

I hope that helps, please post back!

I think that will work.

Is there a spec on the format of that ledger record file? I've seen format specs for other lists for Sage but never seen this one mentioned.

"TRANSPORT","General Transport","Service","km",1.6,1.6,0,4725,0,0,
"WCBPRM","WCB Premiums for LB (Owner)","Service","Each",0,0,0,0,5685,0,

I notice that an expense item has only one zero after the account number and the income item has two zeros after the account number. It would be good to know why.

It's in the Help file when searching under Import Records. You will eventually get to a link.

Or you can just export the inventory you have in your file, open it in Notepad, change the items you want, save and reimport. It will ignore items currently in the file and import the new item codes. Don't misplace the commas. You can delete all the extra rows if you want or just export the items you want to change so the list is smaller.

Always, Always test your imports on a copy of your file first to make sure it works.

BTW, the video you watched was probably the US or UK version of the Sage 50 program, not the same thing as the Canadian version.