Forum Discussion

Learoy's avatar
Learoy
Experienced Cover User
2 years ago
Solved

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 back into MYOB.

 

Is it possible to update the Selling Price of items from only a particular supplier?

 

I have exported all the inventory items into excel then modified it to one particular supplier. Does anyone know if I import this file will it cause any issues with our data?

 

Regards,

Lea 

  • 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

1 Reply

Sort By
Replies have been turned off for this discussion
  • 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