Issue Exporting Item List to Excel & Bulk Update Queries
Hello, I hope you're doing well.
I’m currently trying to export the Item List from MYOB to Excel, but when I attempt to export it, the file is only available in Text format. I’ve tried changing the file type to Excel, but unfortunately, it doesn’t work. Could anyone advise if this issue might be related to our current subscription plan? Currently our plan is just Essential plan.
Additionally, we are hoping to:
- Export the item list, perform a bulk update, and add the APN number for each item.
- If there's a way to add the APN number in bulk, can we do that easily or will it need to be entered manually?
We use Custom Fields 1 and 2 for Best Before dates, and Custom Field 3 for the Name to connect our website. We’d appreciate any help or guidance on how to proceed with these updates.
Thank you in advance for your help! It would be much appreciated!
Hi Tongil,
The import file format is not related to any subscription issue. You don't need to change the file format of AccountRight's exported data even if it's a text file. You can open it directly in Excel without any modifications. This link has steps that might help you edit the import file successfully.
Feel free to post again if you need any other help.
Thanks,
Genreve
