Forum Discussion

20191001myob's avatar
20191001myob
Contributing User
8 days ago

Quote/Order Import/Export Problem

Hi,

I tried to export the quote to update the item price in bulk and import back.

But there is a problem happened, the order of the items in the list will change.

 

Original quote:

Updated quote:

Thanks

Grace

1 Reply

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    7 days ago

    Hey 20191001myob,

     

    To keep the line items steady, only update the price columns in Excel and avoid sorting, filtering or changing the Line No values. Import the file back using "Update existing data" and map both the quote number and the Line No so AccountRight updates the existing lines properly. If the items were still not lining up like the original quote, you can reach out to our team so they can check what’s going on. Make sure to contact them on Live Chat via our virtual assistant, MOCA, or by submitting a support case via My Account.

     

    Cheers,

    Doreen