Forum Discussion

Jpyn's avatar
Jpyn
Contributing User
17 days ago
Solved

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
    Jpyn
    16 days ago

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

5 Replies

Sort By
  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    17 days ago

    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.

     

    Thanks,
    Genreve

    • Jpyn's avatar
      Jpyn
      Contributing User
      17 days ago

      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
        Earl_HD
        MYOB Moderator
        17 days ago

        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.

        Regards,
        Earl