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! Cap.jpg

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Issue Exporting Item List to Excel & Bulk Update Queries

Tongil

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!

Cap.jpg

Find more posts tagged with

Desktop

Accepted answers

Genreve_S

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

All comments

Anza

Hi @Genreve_S

Do you have an answer for the export of files. I am currently stuck on this and have no way of exporting reliable information over to excel to do bulk changes of items 658 in total. Is there a way to successfully export to excel in csv or similar. The TXT file with tabs will push some items into different columns. If done with comma, some descriptions have commas so that does not work.

regards

Aaron

Genreve_S

Hi @Tongil,

Feel free to post again if you need any other help.

Thanks,
Genreve