Forum Discussion

Learoy's avatar
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
    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'.