/
Updating inventory default prices

Updating inventory default prices

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

I need to update inventory prices and I don't have Excel installed on the computer to use Import from XLS.

Step-by-step guide

  1. Create a CSV file with PartNo and DefaultPrice, RRPPrice, LastCost with relevant data

  2. Load Inventory > Utilities > Inventory Import

  3. Select the CSV file and make sure "Update existing inventory" is ticked

  4. Click Import - bottom right

A message displays  the results of records updated and details of any errors

 

 

Where the inventory item does not exist, there is no warning.

Related articles

Related content

Price Updates using the Import from Excel errors "Cannot create ActiveX component" error when selecting the Excel file
Price Updates using the Import from Excel errors "Cannot create ActiveX component" error when selecting the Excel file
Jiwa 7
More like this
Cost Price Updates
Cost Price Updates
Jiwa 7
More like this
Inventory
Inventory
Jiwa 7
More like this
Import of inventory transactions errors 'Object reference not set to an instance of an object
Import of inventory transactions errors 'Object reference not set to an instance of an object
Jiwa 7
More like this
Stock Transfers
Stock Transfers
Jiwa 7
More like this
Increasing IN_Main.AUX3 (Details) from 250 to 500 characters
Increasing IN_Main.AUX3 (Details) from 250 to 500 characters
Jiwa 7
More like this