In this article we will look at how inventory prices and costs can be updated using the Jiwa Price Update - Import From Excel function.
Before using this feature it is highly recommended that you test your import file in your Test or Training database before attempting to complete the update in your live database.
Preparing Your Import File
Before importing our updates we need to first prepare our import file.
Your file only needs to include the part number and the price you want to update.
In the example below the default supplier cost will be updated however the current cost has been included in the file for comparison purposes only. The current cost will not be imported.
Save your file.
Importing Cost Price Updates
Select Inventory > Utilities > Price Updates > Import from Excel
Select your required ranges, in this example Clothing products will be updated.
Select the spreadsheet you want to use for the update.
Use the icon next to the Spreadsheet File field to browse to your file.
Set your required import fields
Select the price to be updated
Note: If updating your supplier cost price then select the option Supplier FX Cost. Only the cost for the default supplier and warehouse will be updated.
|Sheet||Specify the sheet from the file to be used|
|Part No. Column||Specify the column number in the sheet that contains the part number|
|Price Column||Specify the column number in the sheet that contains the price column to use|
|Start Row||Specify the first row to the import sheet to start at|
|End Row||Specify the last row in the import sheet to end at|
|Part No. Is Supplier Part No.||When ticked indicates that the part number contained the part number field is the supplier part number|
When you are ready select Process to complete you update.
The process status bar will be updated when the update has been completed.
This video is best seen on the full screen. Just click on the icon at the bottom right of the video (see image below).
To exit full screen just press escape