Unfortunately the overwrite all values no longer works. After spending hours on the phone with the help desk we were told to make all the products & services in QB inactive and then we were able to import the spreadsheet with the new prices.
However, I have now found even though the prices are correct not all the information for each product & service has been imported. We use classes for all our items and the classes did not import. We have contacted QB helpline and they were not able to help. Their only solutions is to go into every item and enter the class manually. We have over 500 products & services and this is not a solution. It is time consuming and we do not have the time.
1/ Why has the change for importing price ubdates been changes when it worked well for the previous years?
2/ Why can't QB come up with an easier way of updating prices anually by telling the system to update all prices by a percentage without exporting and importin spreadsheets? Other systems can do this without any problem.
