Forum Discussion

Jpyn's avatar
Contributing User
2 months ago

Bulk Item Import: Changing Item Number

Is it possible to do a bulk edit of the item number field? using item name as link?


  • Jpyn's avatar
    2 months ago

    So it seems I am correct to believe this is yet another on the long list of limitations on MYOB.... 

5 Replies

  • Genreve_S's avatar
    MYOB Moderator

    Hi Jpyn


    Thanks for the question. 


    Right now, the best way to update multiple item details or settings all at once is by importing the updates. If you'd like a detailed walkthrough on how to do this, I suggest checking out our articles on 'Importing Data' and 'Importing and Exporting Data - Using an Import Template'.


    If you run into any roadblocks while following these steps or if you have any additional questions, don't hesitate to reach out. We're here to assist you!


    If my response has answered your inquiry, please click "Accept as Solution" to assist other users find this information.



    • Jpyn's avatar
      Contributing User

      Hi Genreve


      Thank you for your response. 


      I am aware of the process to import bulk data changes. 


      My question is regarding changing bulk "Item Number" field. I'm wanting to update my current item list and change the Item number field for multiple products at once.


      However to me it seems MYOB defaults to using "Item Number" to link with existing data. 


      Meaning that if I change the Item number then MYOB creates a new product instead of updating an existing one. 


      Is there a work around for this? 


      I want to update the Item Number field for multiple items at one. 

      • Earl_HD's avatar
        MYOB Moderator

        Hi Jpyn,

        Thanks for your response. The workaround I suggest for updating multiple items at once is to export your item information to Excel. Start by going to the File menu and selecting Import/Export Assistant. Update the information in Excel accordingly. Once you've exported your item information from AccountRight, you can make the necessary updates in Microsoft Excel. After updating the information in Excel, you can then import your changes back into AccountRight. For more detailed instructions, please refer to this help article Editing items.

        Feel free to post again, we're happy to help!

        If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.