Forum Discussion

Learoy's avatar
Learoy
Experienced Cover User
2 years ago

update Selling price

I want to update the sales price of a number of inventory items. I have read about the option of importing the sale price of items from excel by exporting them first, updating them & importing them b...
  • gavin12345's avatar
    gavin12345
    2 years ago

    Hi Learoy 

     

    FYI a bad import cannot be un-done - so always take a backup or practice first on a copy of your file. 

     

    After exporting, you can remove rows for items you don't want to update. This will not affect existing items. 

     

    In the import file ensure the amount columns are formatted as 1234.45 rather than $1,234.45 - the later will cause an import error.

     

    Also take care and on step 3 of the import assistant under 'If data you are importing already exists in this company file' select 'Update existing data'. 

     

    Regards

    Gavin

gavin12345's avatar
gavin12345
Ultimate User
2 years ago

Hi Learoy 

 

FYI a bad import cannot be un-done - so always take a backup or practice first on a copy of your file. 

 

After exporting, you can remove rows for items you don't want to update. This will not affect existing items. 

 

In the import file ensure the amount columns are formatted as 1234.45 rather than $1,234.45 - the later will cause an import error.

 

Also take care and on step 3 of the import assistant under 'If data you are importing already exists in this company file' select 'Update existing data'. 

 

Regards

Gavin

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.